Semantic Grouping and DTP Packet Size
I have a DTP which loads data from DSO to DSO based on Valid customers in a particular week.
There are say 100 unique customers, then I want the number of data packets to be 100.
I used semantic grouping on this customer field, and set my datapacket size to 2k , but still there are chances that 2 unique customers come in single data package - in case Cuctomer 1 = C1 =500 records and Customer 2 = C2 = 1500 records.
Please let me know using what settings I can make sure that a data packet has single customer records (as said in above case semantic key may not always work)
I see Optimal datapacket size set in DTP take preceedence ove semantic key sometimes.
Please suggest any option/settings I can use for this.
Bhaskar V replied
Each Customer can be extracted in single package by below mentioned ways:
1. Add the Sementic key as Customer in DTP and the data package size as 1. So that each customer will be extracted in a single data pacakge .If 1 customer has 10 records and package size is 1 then all this 10 records will be loaded to single Data Package because semenctic key records takes precedence over package size.
2. By using a Planning sequence and writing a fox formule as For Each Customer perform the below logic.
3. Changing the ABAP Code (Based on your requirement) to consider all the customer based on the Loop Condition.
In Second and Third Method the changes needs to be done in all 3 landscapes. So first method is optimal for fast solution.
Kindly check the above solution and let us know for further clarifications.