Query helps on Vendor Country of Orgin and Material Commodity Code

[Former Member]

Hi all,

We ran in a AFS system and I needed to create a query which allow me to have the following informations.

1. Plant

2. Vendor Country of Origin

3. Sold-to-Party

4. Purchase Order information

- Material Qty/Unit Price/ Values

- GR'ed date

5. Material Commodity Code from Info. Records.

I tried to join EKPO to EKET

& EKPO to EINA - MARC

& EKPO to EKKN to VBAK to VBAP to VBPA

but it resulted in duplicated records i.e. for 1 material in a PO, the records got repeated over 10 times. I am not sure what caused it. Maybe I am not using the right table ?

Any helps please.

Thanks,

Rebella

[Former Member]

CLOSED as there were no reply.