Skip to Content

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

problem in select query

i want to put a section query on table vbrp vbfa and vbrk based on vbrk-vbeln and vbfa-erdat..i hav written this code but its not working.. can nnbdy suggest me sth..

SELECT v1~vbeln AS vbeln

v1~kunag AS kunag

v1~vkorg AS vkorg

v1~netwr AS netwr

v2~ntgew AS ntgew

v2~matnr AS matnr

v3~erdat AS erdat

INTO CORRESPONDING fields of table it_data1

FROM vbrk AS v1

INNER JOIN vbrp AS v2

ON v1vbeln = v2vbeln

INNER JOIN vbfa AS v3

ON v2vbeln = v3vbeln

WHERE v1~vbeln eq s_vbeln .

delete it_data1 where erdat not in s_erdat.

thanks in advance....

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