Table to know the sales by customer and with packing data

[Former Member]

Helllo Experts,

Please let me know if you have got any idea on the tables to be joined for meeting the below requirement..

We need a table with all item no. based on the customer no in the period 2010 and 2011 till now. Beside the item no. additional information like packing unit and our sales price are requested too"

[jignesh_mehta3 · Accepted solution]

Hello,

You will have to create a Z-Report fetching data from VBRK, VBRP, LIKP & LIPS, KONV & KONP.

Just expore these Tables in SE16N & check if the data required by you is available.

If not, let us know your specific queries.

Hope this helps,

Thanks,

Jignesh Mehta

[Former Member]

Thanks all

[former_member209761]

Dear Dinakar,

all item no. based on the customer no in the period 2010 and 2011 till now. Beside the item no. additional information like packing unit and our sales price are requested too

Input the customer no in VBRK-KUNNR with FKDAT = 01.01.2010 to 31.12.2011 (if you reqiure the financial year , replace the date mentioned) and fetch VBELN.

Put that VBELN in VBRP to get MATNR (this will give you the item code)

From VBRK , fetch KONMV (condition record number) and put in KONV with KSCHL = Condition type for sales price.

Put VBRK-VBELN in VBFA as subsequent document and fetch the preceding document with document category J which will give you the delivery no of the invoice.

Put that delivery number in LIPS and fetch the relevant field for PACKING UNIT.

Thanks & Regards,

Hegal K Charles

[Former Member]

Thanks a lot .....Issue resolved

[Former Member]

Hi,

For customer sales details we can know by standard T.code VA05N,and for packing details you can get through VEPO table.

If you want to develop your own report for combination of customer and packing use the tables VBAK , LIKP and pass the

delivery details into VEPO there you can get the packing information.

Regards

Ram