5 Replies Latest reply: Aug 5, 2009 1:29 PM by ilesh Nandaniya RSS

lINK BETWEEN AFKO AND AFVC

Khushi p
Currently Being Moderated

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

  • Re: lINK BETWEEN AFKO AND AFVC
    mohammad afzal
    Currently Being Moderated

    hai khusshi afvc table is for both network and orders , both are stored with same 12 char numbers but the differenece is in control key field STEUS which differentiate between both

    m.a

  • Re: lINK BETWEEN AFKO AND AFVC
    Khushi p
    Currently Being Moderated

    Hi,

    I wanted to ask that is there any other field to compare between afko and afvc ( other than aufnr) to extract exact record.

     

    Regards,

  • Re: lINK BETWEEN AFKO AND AFVC
    jaya rangwani
    Currently Being Moderated

    AFKO-APLZT = AFVC-APLZL

    AFKO-AUFPL = AFVC-AUFPL

  • Re: lINK BETWEEN AFKO AND AFVC
    ilesh Nandaniya
    Currently Being Moderated

    Hi Khushi,

     

     

    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

    ilesh 24x7

    ilesh Nandaniya

Actions