Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

UNION ALL

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.

Thanks

R

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question