Skip to Content

SAP BW: Only load data is insert or update from datasoure to ODS

Dear all,

I have datasoure 0REFX_2 from ERP and Data tranfer object (ZDTO_TEST) from BPC is contain,I load data from ERP system to BPC system 10.

the first, I load all record from 0REFX_2 to ZDTO_TEST.

the next, I just load records in 0REFX_2 is new or change.

eg:

DATA:

objnr fromdate todate amount

object1 sep,18 2014 march, 18 2015 10

object2 sep,18 2014 march, 18 2015 20

object3 sep,18 2014 march, 10 2015 30

THE FIRST : LOAD ALL

CHANGE DATA:

objnr fromdate todate amount

object1 sep,18 2014 march, 18 2015 10

object2 sep,18 2014 march, 18 2015 25 change amount

object3 sep,18 2014 sep, 18 2015 30 change period


THE NEXT : I just load object2 and object3


What should I do.

Thanks.


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 18, 2015 at 03:22 AM

    Hi D,

    your requirement is not clear, can you explain it again?

    In your DTP you can change overwrite or append.

    maybe try that?

    Andy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 19, 2015 at 01:44 AM
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Duong Do Anh

      Hi D,

      I want to do in this document, page 8..........!

      As per your requirement this can't be observed in BPC level it can be observed only in BW Level ...

      If you want to see the ORecordmode as mentioned in the Document you mentioned above ..

      Goto RSA1 in BW ...

      Select Display Data for ZDTO_TEST....

      And select Field Output for Selection on the Top ....

      There check ORECORDMODE.....

      Then you can able to see the changes as mentioned in the document ..... Only if you had already done with your DTP Delta Load.....

      Aravind

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.