on 01-22-2008 10:02 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
102 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.