SQVI - any experts?

[Former Member]

I need to tabulate data from VBRK / VBRP alongwith sold-to party and ship-to party and shipment address

What tables can I join (in SQVI) with VBRK or VBRP to be able to get shipment addresses ?

I tried VPBA and ADRC tables but no luck

Would any guru like to suggest something?

[Former Member]

hi shakeel,

begin at vbrp

add new table vbpa with vbepn ... posnr = 000000 parvw = AG

add new table adrc with adressnr of vbpa.

if you need add new table vbrk.

hans

[Former Member]

VBRP-VSTEL = TVST-VSTEL then take adrnr field from TVST Table

get the shippment address from ADRC Table

Reward Points if it is helpful

Thanks

Seshu

[Former Member]

Thanks Seshu,

When I reach ADRC it will give addresses - but how would I relate those to thousands of enteries in VBRP or VBRK enteries?

I need to join the tables so that the info is related on line by line basis - e.g. against easch billing document what was the ship-to party?

[Former Member]

Better to write ABAP Program than SQVI Query ,because you need to get the data on diffrent condition ,talk to ABAP developer