cancel
Showing results for 
Search instead for 
Did you mean: 

Semantic Groups - True or False?

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

former_member207826
Participant
0 Kudos

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.

anindya_bose
Active Contributor
0 Kudos

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