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 <> ''.
AFKO ==> AUFNR is the only Primary Key
AFVC ==> AUFPL and APLZL together is the primary Key...
AUFPL you will get from AFKO and You can pass it to AFVC...
For One AUFNR you may get several records in AFVC depending on the Number of Activity / Operations attched to given production Order..
You can pass the counter (it refers the Operation/Activity)... along with AUFPL to AFVC to get unique record..
By Seeing your Select Query... I can say you should include
RMZHL while joining AFVC and AFRU.... in Join Condition....
SELECT * into corresponding fields of table itab1 FROM afko as a INNER JOIN afvc as b ON a~aufpl = b~aufpl INNER JOIN afru as c ON b~rueck = c~rueck
AND b~RMZHL = c~RMZHL
inner join afpo as d on d~aufnr = a~aufnr inner join crhd as e on e~OBJID = B~ARBID WHERE a~aufnr = itab-aufnr AND c~STOKZ NE 'X' AND c~STZHL = '0' AND c~BUDAT IN P_DATE AND c~LTXA1 ''.
Hope it will solve your problem..
Thanks & Regards