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

Transformation of 0SD_C03

Hi Experts,

I am confused about how to create the transformation for Cube 0SD_C03.

What i have done so far:

1. Activated the Datasources in R/3 and dragged some fields required from communication structure.

2. Replicated it in BI system.

3. Migrated the Datasource in BI System.

Now when i try to create the transformation between the datasource 2LIS_13_VDITM (for billing item), many of the fields like document number, item number, customer gropu, material group etc that are available in my Datasource are not there in the cube.

Another thing that its taking data from multiple DataSources like 2LIS_13_VDHADR, 2LIS_13_VDITM, 2LIS_11_VDHADR & 2LIS_11_VDITM.

I need data from all of them how should i perform mapping, not getting it.

Please suggest me how to perform the mapping, its very urgent.

Thanks !

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 05:15 AM

    If you dont find the exact Business Content fit for your Business Requirements, most probably, either you need to enhance 0SD_C03 cube to accommodate the extra fields or create a ZSD_C03 with all the information you require.

    Also check is there any BC cube which is closely matching your requirements.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Praveen for billing related requirements there is only 0SD_C03 available.

      That has few fields meeting my requirement, but i am confused about for all the SD requirements is it not necessary to have the fields like Document number, billing number or item number in the standard cubes ?

      Then do i enhance it for Document number and other fields ?

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2007 at 05:18 AM

    Donot migrate the datasource before you migrate TR/UR.

    Saving TR/UR to a word doc may help in mapping as the system would hardly generate any proposals for mapping.

    If you have the same Cube & DS up and running in Sandbox - Validate the transformations.

    Routines may be migrated manually accordingly to OO ABAP.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I think you are looking at more detailed level information storage in BW.Most of the cases the requirement is to display only the sales information in a summarized form.

      If your requirement is to extract the sales info at Document Number level, you need to stage the information at ODS first and then update the the cube.look at 0SD_O03.

      Using RRI you can drilldown in reports upto Document Number level.

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.