Skip to Content
avatar image
Former Member

SD Masterdata?

Hi Friends,

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

Thanks,

Sudha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 21, 2007 at 10:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 10:55 AM

    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.............

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 10:37 AM

    Sales Org? 0SALESORG

    Material? 0MATERIAL

    Customer? 0SOLD_TO, 0SHIP_TO, 0CUSTOMER

    Kind regards

    /martin

    Add comment
    10|10000 characters needed characters exceeded