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

please help

when i click transformation between source and target,when automatic mapping created between source and target in sap bi,.some times i have done manual mapping if transformations not automatically mapped,and some times automatic mapping done between source and target ,so when automatic and manual mapping happens when we click transformation

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Nov 24, 2011 at 05:43 AM

    Hi kumar,

    If the field( in r/3 ) or infoobject or infoprovider are custom object then we have to map manually,and suppose if u want to know which field in R/3 should map to infoobject in BI then go to SE11 ->RSOSFIELDMAP -->AND THEN GIVE THE FIELD NAME THEN U GET THE CORRESSPONDING INFOOBJECT NAME .

    Hope u got it,

    Assign Points if it help u,

    Thanx & Regads,


    Edited by: on Nov 24, 2011 8:53 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 24, 2011 at 09:57 AM

    Hi Kumar,

    There is no deal whether you done manual mapping or automatic mapping. Take care how good the data is populating to target field from source field.

    -If your target field doesnu2019t have source field then you can transform data using rule types

    - Direct Assignment:

    The field is filled directly from the selected source InfoObject. If the system does not propose a source InfoObject, you can assign a source InfoObject of the same type (amount, number, integer, quantity, float, time) or you can create a routine.


    The field is not filled by the InfoObject; it is filled directly with the value specified.


    The InfoObject is updated with a value determined using a formula.

    Read Master Data:

    The InfoObject is updated by reading the master data table of a characteristic that is included in the source with a key and a value and that contains the corresponding InfoObject as an attribute. The attributes and their values are read using the key and are then returned.


    The field is filled by the transformation routine you have written.


    The field is not filled. It remains empty.

    No Transformation:

    The key figures are not written to the InfoProvider.

    Time Update:

    When performing a time update, automatic time conversion and time distribution are available.

    Direct Update: the system automatically performs a time conversion.

    Time Conversion:

    You can update source time characteristics to target time characteristics using automatic time conversion. This function is not available for DataStore objects, since time characteristics are treated as normal data fields. The system only displays the time characteristics for which an automatic time conversion routine exists.

    Time Distribution:

    You can update time characteristics with time distribution. All the key figures that can be added are split into correspondingly smaller units of time. If the source contains a time characteristic (such as 0CALMONTH) that is not as precise as a time characteristic of the target (such as 0CALWEEK), you can combine these characteristics with one another in the rule. The system then performs time distribution in the transformation.



    Edited by: rvc171 on Nov 24, 2011 3:28 PM

    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.