Relation between AUFK and AFVC

[#1]

Hi All..

There is a requirement to retrieve the Operational data within an order from table AFVC related to a particular Production Order.

Production Order can be fetched from AUFK.

Now how to map both the AUFK and AFVC Tables..???????

Regards

Pavan

[Former Member · Accepted solution]

Hi Pavan ,

Check the view VIAUF_AFVC.

Regadrs

Arun

[Former Member · Accepted solution]

use tables AFKO and AUFK. take the value from this

after u can link it to afvc AFVC-AUFPL = AFKO-AUFPL .

either u can take join on all three table.

link aufk---->afko------>afvc

.

[Former Member · Accepted solution]

Hi

The relation between AUFK and AFVC is like this.

From AUFK -- > AFKO based on AUFK-AUFNR = AFKO-AUFNR.

AFKO-AUFPL --> AFVC-AUFPL.

Now in AFVC -- VORNR will give you the Operation no and KTSCH will give you the Standard text key.

AFVU-- Will give you the user details

AFVV --Will give you the Dates.

Hope this information is useful for you

[Former Member]

hi,

In AFVC we have a field aufpl and in AUFK we have another field aufnr.

so the relation can be made as follows.

afvc-aufpl = afko-aufpl

retrieve all aufnrs

then afko-aufnr = aufk-aufnr

this can be made to relate aufk and afvc.

i tried it and it works.

Reward me if my suggestion is helpful.

regards,

ravi.

[Former Member]

Hi,

Check this Database view <b>CAUFV</b>.

Regards,

Balavardhan.K

[Former Member]

between

afko-aufpl and afvc-aufpl there is a link but there is no link between aufk and afvc

but not sure....

regards

shiba dutta