Skip to Content
author's profile photo Former Member
Former Member

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Aug 05, 2009 at 11:23 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 05, 2009 at 10:15 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 05, 2009 at 10:26 AM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 05, 2009 at 11:17 AM

    AFKO-APLZT = AFVC-APLZL

    AFKO-AUFPL = AFVC-AUFPL

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.