Sales Report

[Former Member]

Hi,

We would like to create a small report as per details given below:

Plant Name

Billing Doc No

Posting Date

Customer Name

Net Amount (TPEdST-TD)

Only the above fields to be incorporate in the report, Please guide how to go about.

regards

Rajesh T

[Lakshmipathi · Accepted solution]

Dear Rajesh

You have to refer three Tables VBRK, VBRP & BKPF which is possible through Query SQVI.

Enter TCode SQVI and give some description in "QuickView" and select "Create". Screen will take you to a field "Title". Give some title here and select "Table Join" in Data Source and enter.

Select "Insert Table" (second from left on top) key or press "Shift-F1". Type one by one the above three tables mentioned above by selecting "Insert Table" each time. Now press "F3" so that you will see a screen divided into two. Left screen contains the tables you joined and on the right side, you can see datas like sort sequence, selection fields etc.,

Select the first table, say VBRK so that you will see two white boxes against many fields. Whatever fields you select on the right side (selection field) is the input data which you have to give. The left one is (List fields) the data which would be generated based on the input data you give.

So in your case, select only the (List fields) BUDAT (posting date) in BKPF, KUNAG (customer) and NETWR (net value) in VBRK and WERKS (plant) in VBRP. Execute the report.

Thanks

G. Lakshmipathi

[Former Member]

Hai Rajesh,

Use sap query trn code sq01,sq02,sq03, create user group first and then create info sets with fields and execute.

you will get desired output.

Regards

Pradeep Belur.