More discussions in ABAP DevelopmentWhere is place located?
    5 Replies Latest reply: Aug 5, 2009 1:29 PM by ilesh Nandaniya RSS

    lINK BETWEEN AFKO AND AFVC

    Khushi p
    Khushi p
    Aug 5, 2009 12:07 PM
    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

    • 3555 Views
    • Re: lINK BETWEEN AFKO AND AFVC
      mohammad afzal
      mohammad afzal Aug 5, 2009 12:15 PM (in response to Khushi p)
      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
      Khushi p Aug 5, 2009 12:26 PM (in response to 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
      jaya rangwani Aug 5, 2009 1:17 PM (in response to Khushi p)
      Currently Being Moderated

      AFKO-APLZT = AFVC-APLZL

      AFKO-AUFPL = AFVC-AUFPL

    • Re: lINK BETWEEN AFKO AND AFVC
      ilesh Nandaniya
      ilesh Nandaniya Aug 5, 2009 1:29 PM (in response to Khushi p)
      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