SQL Syntax Question
Hello everyone: I am trying to write an SQL query in ABAP function. I know how to write it in Oracle but not sure how to write it in ABAP. For example
DATA: begin of wa_ITAB_SALESRECS,
ZVBELN type VBELN_VA,
ZPOSNR type POSNR_VA,
end of WA_ITAB_SALESRECS,
ITAB_SALESRECS LIKE HASHED TABLE OF WA_ITAB_SALESRECS WITH UNIQUE KEY ZVBELN ZPOSNR.
Select VBAK, '' from VBAK
Select VBELN, POSNR from VBAP
I'm trying to enter the result into wa_itab_salesrecs.
Please note that '' in the first select statement is a blank. I don't know the syntax for blanks.
So what I want to know is:
1. What is the syntax to enter blank
2. What is the syntax for UNION.