04-18-2008 10:23 AM
Dear All
I have to track sales party wise, brand wise , state wise and city wise . How can I track sales from which table or is there
any bapi to track sales.
Please send with coding.
Thanks & R egards
Sangram
04-18-2008 10:26 AM
Hi Frds
Check out this tables
TVKO Sales organization / company code
TVKOV Distribution channel / sales organization
TVKOS Division to sales organization
TVTA Sales aria
TVKBZ Sales office to sales area
TVBVK Sales group to sales office
TVKWZ Plants to sales organization
Reward Me Points
By
Pari
04-18-2008 10:26 AM
Hi Frds
Check out this tables
TVKO Sales organization / company code
TVKOV Distribution channel / sales organization
TVKOS Division to sales organization
TVTA Sales aria
TVKBZ Sales office to sales area
TVBVK Sales group to sales office
TVKWZ Plants to sales organization
Reward Me Points
By
Pari
04-18-2008 10:44 AM
HI,
If COPA has been implemented on your system, then you will get this infor in CE1XXXX where XXXX is the controlling area. You can get the controlling area from your FI consultant.
I hope this helps,
Regards
Raju Chitale
04-18-2008 11:16 AM
Hi sangramk,
This will depend what is elibile criteria for sales user want to see (whether Sales Order has been created, Invoice has been created or Invoice cleared and posted to acconting).
For Sales Order data :
Sales Order Header table : VBAK
Sales Order Detail table : VBAP.
These table will also contain Ship-to-party or, sold-to party etc..If not you can go to Partner function table VBPA and find corresponding ship-to / sold-to or billed to party using partner function PARVW.
you can use Sales document flow table VBFA, this will contain all document links for sales. Using Subsequent document VBELN, POSNR for corresponding subsequent document type VBTYP_N (example VBTP_N = 'C' will indicate VBELN and POSNR corresponds to Sales Order, VBTYP_N = J indicates delivery etc) and preceding document VBELV, POSNV and it's corresponding VBTYP_V.
-
Using this links you can find corresponding delivery number, goods movement, shipment (if any), Billing document numbers.
Billing and corresponding Accounting document
Billing information can be found in tables VBRK (Header) and VBRP (Detail)... It iwll contain bill-to party also.
To find corresponding accounting document related to Billing, Use BKPF table, wherein BKPF-AWKEY will be billing doc number + document year and BKPF-AWTYP = 'VBRK'. you will get corresponding accounting document number for that Billing document.
To get data brandwise, you will need to refer, VBRP / VBAP table MATNR, go to MARA table and determine it's corresponding brand (using either product hierarchy PRDHA or other fields).
Regards,
Mohaiyuddin.