4 Replies Latest reply: Oct 16, 2011 8:20 AM by Venkateswarlu Nandimandalam RSS

Semantic Groups - True or False?

Gerrit Schang
Currently Being Moderated

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

  • Re: Semantic Groups - True or False?
    Anindya Bose
    Currently Being Moderated

    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

  • Re: Semantic Groups - True or False?
    Paulo Junior
    Currently Being Moderated

    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.

  • Re: Semantic Groups - True or False?
    Durgesh Gandewar
    Currently Being Moderated

    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.

  • Re: Semantic Groups - True or False?
    Venkateswarlu Nandimandalam
    Currently Being Moderated

    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

Actions