Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.


Not what you were looking for? View more on this topic or Ask a question