topic Re: sales report in Application Development and Automation Discussions

sales report

Former Member — Fri, 18 Apr 2008 09:23:10 GMT

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

Re: sales report

Former Member — Fri, 18 Apr 2008 09:26:55 GMT

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

Pari

Re: sales report

Former Member — Fri, 18 Apr 2008 09:44:28 GMT

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

Re: sales report

Former Member — Fri, 18 Apr 2008 10:16:19 GMT

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.