lINK BETWEEN AFKO AND AFVC
How to link afko with afvc, i know the common field is AUFPL, but AFVC is table for operation, so how to choose exact row from multiple row. My coding is as follows
SELECT * into corresponding fields of table itab1 FROM afko as a
INNER JOIN afvc as b ON aaufpl = baufpl
INNER JOIN afru as c ON brueck = crueck
inner join afpo as d on daufnr = aaufnr
inner join crhd as e on eOBJID = BARBID
WHERE aaufnr = itab-aufnr AND cSTOKZ NE 'X'
AND cSTZHL = '0' AND cBUDAT IN P_DATE AND c~LTXA1 <> ''.