Skip to Content
author's profile photo Former Member
Former Member

Sales Report

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 22, 2008 at 11:07 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 22, 2008 at 10:10 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.