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

lINK BETWEEN AFKO AND AFVC

Hi,

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 <> ''.

Regards

Helpful Answer

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