Hi all,
The below join statement fails to retrieve necessary data. For every PO number(ebeln) in EKBE table, multiple entries of document numbers(belnr) will be found in RSEG table. But the below statement returns zero entries.
IF NOT it_ekpo[] IS INITIAL.
SELECT a~ebeln "PO number
a~ebelp
a~zekkn
a~vgabe
a~gjahr
a~belnr "Document Number
a~buzei
b~menge
b~shkzg
b~wrbtr
INTO CORRESPONDING FIELDS OF TABLE it_ekbe
FROM ekbe AS a
INNER JOIN rseg as b
ON a~ebeln = b~ebeln
AND a~ebelp = b~ebelp
AND a~buzei = b~buzei
AND a~gjahr = b~gjahr
AND a~belnr = b~belnr
For all entries in it_ekpo
WHERE a~ebeln = it_ekpo-ebeln
AND a~ebelp = it_ekpo-ebelp.
ENDIF.
Please suggest. Thanks.
Hema.
Bluesky
