Transaction S_ALR_87012186

[Former Member]

Hi fellow Sap Users.

I am trying to find an SAP transaction which I can use as a reporting tool and extract sales Customer sales figures per month/year. can anyone recommend any good T-codes?

I have been using S_ALR_87012186 however you can only choose one year at a time.

I do have a question regarding this transaction. Does anyone know if the figures are excluding or including VAT? Also do the sales figures include discounts within orders or would I have to deduct that of the sales figures that I extract out of this report?

Look forward to hearing from you all

[arindam_m]

The basic SELECT statements used in the program are:

T001 select single * from t001 where bukrs = knb1-bukrs.

T009 select single * from t009 where periv = t001-periv.

BSEG select single * from bseg into gs_bseg where bukrs = gs_bsid-bukrs and belnr = gs_bsid-belnr and gjahr = gs_bsid-gjahr and buzei = gs_bsid-buzei.

BSEC select single * from bsec where bukrs = gs_bseg-bukrs and belnr = gs_bseg-belnr and gjahr = gs_bseg-gjahr and buzei = gs_bseg-buzei.

BSID select * from bsid into gs_bsid where bukrs = knb1-bukrs and kunnr = kna1-kunnr and umsks = space and umskz = space and gjahr = gejahr and monat in b_period order by primary key.

BSAD select * from bsad into gs_bsad where bukrs = knb1-bukrs and kunnr = kna1-kunnr and umsks = space and umskz = space and gjahr = gejahr and monat in b_period order by primary key.

T005T select single * from t005t where spras = sy-langu and land1 = kna1-land1.

So your figures expected in the report output would be as present in tables BSEG, BSEC, BSID, BSAD. Also as most of the amounts look to used from DMBTR. This should be including VAT.

Cheers,

Arindam