SD Masterdata?

[Former Member]

Hi Friends,

I want to identify the required masterdata for sales reporting. Could any one help me some geenreal masterdata required....

Thanks,

Sudha

[Former Member · Accepted solution]

Hi,

best is, goto the infocube/s you are planning to load. Right click on them in rsa1 and select datasource overview. It will give you a list of datasources that needs to be loaded. --> texts, attributes, hierarchies and transactional data.

regards

Siggi

[Former Member]

Customers KNA1 General Data

KNB1 Customer Master – Co. Code

KNVV Sales Area Data (terms, order probability)

Sales Documents VBAKUK VBAK + VBUK

VBUK Header Status and Administrative Data

VBAK Sales Document - Header Data

VBKD Sales Document - Business

SD Delivery Document

LIPS Delivery Document item data, includes referencing PO

LIKP Delivery Document Header data

Billing Document

VBRK Billing Document Header

VBRP Billing Document Item

These are the tables generally used for to get the Sales Report.

Hope it will helps you.............

[Former Member]

Sales Org? 0SALESORG

Material? 0MATERIAL

Customer? 0SOLD_TO, 0SHIP_TO, 0CUSTOMER

Kind regards

/martin