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

loading data from SAP BW standard table to master data text

Hi,

Can anyone please tell me the steps to load data from SAP BW standard table to master data text?

How should the data source be created?

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Feb 18, 2014 at 08:56 AM

    Hi aparajith,

    Have you loaded the master data attr ?

    ECC Steps

    then load the attr text

    create the ztable using standard table using generic data source using table function.

    there you can select the which field you required

    check the data in RSA3

    BI STEPS: -

    check the source system connection.

    replicate the data source

    create of find the master data object for text (including attr)

    map the transformation

    run the info package

    create the DTP.

    check the data in target object.

    Thanks,

    Phani.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 18, 2014 at 09:02 AM

    Hi,

    Am assuming as you need to load bw table data text to info object texts. if yes then

    in bw itself you can create Text data source based on your bw table, Tx - RSO2, select text radio button. do test run at bw RSA3.

    once you seen data then you can do remainining steps at bw side as usual.

    Creating transforamtions between data source and your info object(text).

    create infopack and dtp. load the data and check it.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • In addition to the Raman's reply you have to give application component and just tick only those fields ("Transfer Poss.") which are necessary. If you need Selection for fields select "Selection Poss".

      Replicate this newly created Data Source, without replicating you cannt see it.

      In DTP's update tab "Handle dupliate record key".

  • author's profile photo Former Member
    Former Member
    Posted on Feb 18, 2014 at 09:04 AM

    Hi Aparajitha,

    Can you please confirm if you want to load the text from a BW Table or ECC table?

    Regards,

    Satyam

    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.