Sales order report

[Former Member]

Hi all,

I want to creat a report based on the following.

From which standard cube I will get the objects for report.

Selection Inputs

1. COMPANY CODE

2. BRANCH

3. STORAGE LOCATION

4. SALES ORDER

5. ORDER DATE

6. REJECTION DATE

7. CUSTOMER

8. ORDER TYPE

9. BRANCH

Selections options

1. BOOKING

2. REJECTION

Tables:

1. KNA1

2. KONV

3. MSEG

4. MSKA

5. TVAGT

6. TVM3T

7. VBAK

8. VBAP

9. VBEP

10. ZSALES

Edited by: Balaramtripathy on Apr 18, 2011 3:51 PM

[Former Member · Accepted solution]

Hi Balaram,

You can check the standard data sources in LBWE, there drill down the sales and distribution area there you can find total sales data sources.

click on mantain extract structure option on each data source, then above the comunication structure you can find one drop down box....you can find the table name there.....based on that you can find the required data sources....

Hope it helps you.

Regards,

Venkat

[Former Member]

HI,

Thanks for your reply.

Is 0SD_C05 suitable one for this report or/and I have to add 0SD_C03..

Regards,

Balaram

[Former Member]

hiii

if u r not able to find the standard info provider on the basis of tables mentioned then u can create a generic data source as well as a ZCube as per ur report requirement.

thanks

neha