Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have sample data for initial and delta data in SAP like this
1. Initial Data
Plant | Production Order | Production Order Type | Production Order Type name | Customer | Customer Name | Complete Date | Release Date | Work Order |
1000 | 110000033242 | Z110 | OUTER KCE | 100001 | Cust1 | 2/8/2011 | 21/7/2011 | 07091010-03-000 |
1000 | 110000033240 | Z110 | OUTER KCE | 100001 | Cust1 | 6/8/2011 | 21/7/2011 | 07091010-01-000 |
1000 | 110000033241 | Z110 | OUTER KCE | 100001 | Cust1 | 4/8/2011 | 21/7/2011 | 07091010-02-000 |
1000 | 110000033830 | Z110 | OUTER KCE | 100003 | Cust3 | 19/8/2011 | 28/7/2011 | 07229010-01-000 |
1000 | 110000033866 | Z110 | INNER KCE | 100002 | Cust2 | 8/8/2011 | 28/7/2011 | 07240010-01-000 |
1000 | 110000033867 | Z120 | INNER KCE | 100002 | Cust2 | 6/8/2011 | 28/7/2011 | 07240010-02-000 |
1000 | 110000033868 | Z120 | INNER KCE | 100002 | Cust2 | 4/8/2011 | 28/7/2011 | 07240010-03-000 |
1000 | 110000033869 | Z120 | INNER KCE | 100002 | Cust2 | 4/8/2011 | 28/7/2011 | 07240010-04-000 |
1000 | 110000033870 | Z120 | INNER KCE | 100002 | Cust2 | 4/8/2011 | 28/7/2011 | 07240010-05-000 |
1000 | 110000033871 | Z120 | INNER KCE | 100002 | Cust2 | 5/8/2011 | 28/7/2011 | 07240010-06-000 |
2. Delta data
Plant | Production Order | Production Order Type | Production Order Type name | Customer | Customer Name | Complete Date | Release Date | Work Order |
1000 | 110000033872 | Z120 | INNER KCE | 100002 | Cust2 | 6/8/2011 | 30/7/2011 | 07240010-04-000 |
1000 | 110000033870 | Z120 | INNER KCE | 100002 | Cust2 | x | 28/7/2011 | 07240010-05-000 |
1000 | 110000033873 | Z120 | INNER KCE | 100004 | Cust4 | 6/8/2011 | 29/7/2011 | 07240010-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?
1000 | 110000033870 | Z120 | INNER KCE | 100002 | Cust2 | x | 28/7/2011 | 07240010-05-000 |
2. how can i replace delta data in other way
Thz so much, very much and too much