Customer Master Table

[Former Member]

Hi Gurus,

Can you please suggest me tables from which I can generate report for in XL for Ship to Party-Name of Ship to party-last time shipment was made to customer(Month & Year)-Sales area

Thanks in advance!

Bawa

[former_member217082]

Hi bawa bawa

Please check the following tables

Tables related to Customer Master data ,sales order,delivery and billing

KNA1 ,KNA2, KNVV

VBAK , VBAP , VBEP

LIKP,LIPS

VBRP,VBRK

Standard Reports :

Sales summary - VC/2

Customer Analysis-Basic List - MCTA

Customer Analysis- Sales - MC+E

Customer Analysis- Cr. Memo - MC+I

Deliveries-Due list - VL04

General- List of Outbound deliveries - VL06f

Regards

Srinath