on 10-14-2011 8:30 AM
Hi all,
Is the following statement about semantic groups true?
"When semantic groups are activated during a load process, the system will select the data from the source using a GROUP BY statement. Records that share the same key (defined by the semantic groups) are then transferred using the same data package. If the defined key results in a grouped number of records that exceeds the maximum size of the data package (let's say semantic grouping is by company code), the load process fails."
Many thanks in advance,
Gerrit
Hi
Please check out the below threads
/thread/238438 [original link is broken]
http://sapsharing.blogspot.com/2011/06/dtp-error-maximum-package-size-for-data.html
Regards,
Venkatesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Semantic grouping will collect all the similar records in one data package. And when the data package size increases than particular group I guess SAP will adjust those records in next data package but for sure the data load will not fail.
Regards,
Durgesh.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not sure if there will solely be a Group By because there is no real aggregation function being used for records on the same group. The Group By may be used to calculate the number of records per group, but not to make the selection itself.
However, yes, it will insert all the records from the same group on the same data package.
The statement about the limit on the number of records and the load failing is not true. The following can be said, though:
1- If one more group fits the Data Package without reaching the Data Package Size set in the DTP, it will add this group to the Data Package.
Example:
Data Package Size: 1000 records
Semantic Group: Company Code
Number of records with Company Code 1000 = 500
Number of records with Company Code 2000 = 100.
Result:
Both groups containing Company Code 1000 and 2000 will be contained in the same Data Package.
2- If one group has more records than the Package Size set in the DTP, the Data Package will be bigger than the size set.
Example:
Data Package Size: 1000 records
Semantic Group: Company Code
Number of records with Company Code 1000 = 2000
Result:
The Data Package containing Company Code 1000 will contain 2000 records, even though the package size is set to 1000 only.
3- If you set the Data Package Size to 1, each Data Package will contain a single group.
Example:
Data Package Size: 1 records
Semantic Group: Company Code
Number of records with Company Code 1000 = 500
Number of records with Company Code 2000 = 100.
Result:
Data Package 1 will contain the 500 records from Company Code 1000, but can't include Company Code 2000 as the number of records already exceeds the package size of 1.
Data Package 2 will contain the 100 records from Company Code 2000, even though the package size is set to 1.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gerrit
Above statement is true except the below part
+"If the defined key results in a grouped number of records that exceeds the maximum size of the data package (let's say semantic grouping is by company code), the load process fails." +
I think in this case system adjust the Data Package size according to requirements.
Regards
Anindya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.