- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Date value is not populating while using Native SQL in SAP to insert an Order
I think you need to put a colon (before variable as below:
EXEC SQL.
INSERT INTO order VALUES('2', :sy-datum)
ENDEXEC.I would also suggest you to use OpenSQL instead of Native SQL here. Native SQL is used when you try to use any features that are database specific.
The query you have used is very generic and not exclusive for backend database.
Updated on: 05-Dec-2019
206 Views
Advertisements