0 Replies Latest reply: Sep 14, 2011 11:38 PM by junenoize RSS

    Other way for doing Delta load

      I have sample data for initial and delta data in SAP like this

      1. Initial Data

      PlantProduction  
      Order
      Production  
      Order Type
      Production  
      Order Type name
      CustomerCustomer  
      Name
      Complete  
      Date
      Release  
      Date
      Work   Order
      1000110000033242Z110OUTER KCE100001Cust12/8/201121/7/201107091010-03-000
      1000110000033240Z110OUTER KCE100001Cust16/8/201121/7/201107091010-01-000
      1000110000033241Z110OUTER KCE100001Cust14/8/201121/7/201107091010-02-000
      1000110000033830Z110OUTER KCE100003Cust319/8/201128/7/201107229010-01-000
      1000110000033866Z110INNER KCE100002Cust28/8/201128/7/201107240010-01-000
      1000110000033867Z120INNER KCE100002Cust26/8/201128/7/201107240010-02-000
      1000110000033868Z120INNER KCE100002Cust24/8/201128/7/201107240010-03-000
      1000110000033869Z120INNER KCE100002Cust24/8/201128/7/201107240010-04-000
      1000110000033870Z120INNER KCE100002Cust2 4/8/201128/7/201107240010-05-000
      1000110000033871Z120INNER KCE100002Cust25/8/201128/7/201107240010-06-000

      2. Delta data

      PlantProduction  
      Order
      Production  
      Order Type
      Production  
      Order Type name
      CustomerCustomer  
      Name
      Complete  
      Date
      Release  
      Date
      Work   Order
      1000110000033872Z120INNER KCE100002Cust26/8/201130/7/201107240010-04-000
      1000110000033870Z120INNER KCE100002Cust2 x28/7/201107240010-05-000
      1000110000033873Z120INNER KCE100004Cust46/8/201129/7/201107240010-06-000


      I try to replace the orange line in initial data with the orange line in delta data and it works

      In Sap, it has a lot of data if I want to update only one line I think it may take a long time right?
      so I want to ask 2 questions ....

      1. how to delete this line in delta data if it has x in Complete date?

      1000110000033870Z120INNER KCE100002Cust2 x28/7/201107240010-05-000


      2. how can i replace delta data in other way

       

      Thz so much, very much and too much