what is the table relationship for VBPA - to create report for S-to-P 'AG'

[Former Member]

Hi all,

I want to make a program of Daily invoice report condition to orders made for sold-to-party only...that is Partner function 'AG'...(PARVW).....i know that the table is 'VBPA' where we get the sales & dis doc # ,partner funtion # and customer #.

in that,how to join the fields to get the invoice billing records like qty,amt for the corresponding vbeln in vbpa.

Pls do the needful and provide the tables and fields...to join the table with VBPA..

note that****

i already done daily sales report with VBAK , taken as the main table for sales details "AF"...but it displays only few details of sold-to-party records.

Expecting ur reply.

thanks & regards

sankar

[Former Member]

Hi Sankar,

Use this file to find the relation between tables.

http://www.abap.es/Descargas/TAB%20-%20Relacion%20de%20las%20tablas%20por%20modulos.PDF

Reward Points if this helps,

Satish

[Former Member]

thanks a lot...

got it....

regards

sankar