sales report with gl numbers

[Former Member]

Hi Gurus,

I want to generate a report from SD showing details of Material description (items sold) and amount from G/L Numbers 400013, 400017, 400018, 400001 and 400005.with the gl number also displayed. pls help.

thanks

Maureen

[Former Member]

tnx

[Lakshmipathi]

From VBRP table, you will get

a) Customer

b) Material Code

c) Qty

d) Billing Value

and from BSIS table, you can get

a) G/L Account

b) Document No.

c) Clearing Date

So in SQVI, table join the above two tables and generate the required report.

thanks

G. Lakshmipathi

[Former Member]

tnx, but each time i join sd and fi table, no data would be fould say i join bsid and vbrp as suggested, for month x, no data would be generated but if i join 2 sd tables say s001 and vbrp, data would be generated. why and what should be do.

[Former Member]

Hi Maureen

BSEG is a cluster table and hence cannot be used in joins..... as far as no data shown if u link SD and Fi table is maybe bcoz the joining criteria is not fullfilled.... Check the fields on which u r creating a link. Hope this helps you. BTW .... u still working on DL Project?

Milind Soundade

[Former Member]

Hi,

You can get the Desired report usign the Following tables,

BKPF,BSEG

VBRK, VBRP

VBAK,VBAP & VBFA

I would Suggest you to first analyse what fields you want to extract in the report and if the extracting logic is fairly easy use a SQVI Queiries to make a desired report and specify the join conditions where ever needed in the infoset

or you can ask your ABAP team to write a program in your desired functionality,

Since your report is involving BKPF and BSEG better to write an ABAP Program than a Query.

There will be a reference number in the billing document header (VBRK) which needs to be used as a join condition to BKPF and the accounting document number is the join condiion between BKPF and BSEG.

for getting t he GOods issue number you can use the document flow table VBFA. Give the billing document number as the Subsequent Number and preceding document category as " R - Goods Movement"

Hope this Helps

Thanks

Srini

[Former Member]

Hi,

Thanks for ur response, but when i try joining bkpf and bseg, i get error "bseg cannot be used in table join". pls assist. i would also want to know how to use colunm in a table as join condition.

Thanks

Maureen