Date value is not populating while using Native SQL in SAP to insert an Order

When inserting date values using Native SQL in SAP ABAP, you may encounter issues with date population. The primary issue is often related to variable binding syntax in the SQL statement.

Solution

You need to put a colon (:) before the variable to properly bind it in Native SQL. Here's the corrected syntax ?

EXEC SQL.
   INSERT INTO order VALUES('2', :sy-datum)
ENDEXEC.

The colon (:) is essential for host variable binding in Native SQL. Without it, the system treats sy-datum as a literal string rather than a variable reference.

Alternative Approach

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. Here's the OpenSQL equivalent ?

INSERT INTO order VALUES order_id = '2' order_date = sy-datum.

Benefits of OpenSQL

OpenSQL offers several advantages ?

• Database independence ? Works across different database systems
• Automatic type conversion ? Handles SAP date formats automatically
• Better performance ? Optimized by SAP kernel
• Easier syntax ? No need for host variable binding

Conclusion

Always use colon prefix for variables in Native SQL, but consider OpenSQL for generic database operations as it provides better portability and automatic date handling.