reation between sd tables

[Former Member]

hi,

i want relation between vbrp & vekp for a report.

this is a report for packing.

here we need the exidv no & correspondind material in that packing.

nilabichi

[Former Member]

hi. i got the answer.

nilabiochi

[Former Member]

Hi,

to link VBRP with VEKP, this is with the nb of delivery.

Delivery nb : VBRP-VGBEL

In VEKP, you'll find the del nb in VEKP-VPOBJKEY (no item nb).

Regards,

Lionel

[Former Member]

Hi,

You can get the information from SQO2 as well. you need to create a zinfoset ( make it local) then after that you will get the screen to join the tables. pls input the tables you want then you will get the relationship.

After that you can delete the infoset.

Regards,

Vvieks

[Lakshmipathi]

Dear nilabichi

Go to SQVI and table join these two tables. For information, Fields VBELN and POSNR are the reference fields which link these two tables.

thanks

G. Lakshmipathi