Difference between Semantic key in Write optimized DSO & Semantic groups in DTP..?

[Former Member]

Hi,

What is the difference b/w Semantic key in Write optimized DSO  & Semantic groups in DTP..?

What is the role of Semantic key in Write optimized DSO in handling the records?

----------

Regards,

Sam

[Former Member]

Hi Sam,

Semantic Keys in WDSO  eliminate duplicate records while we are loading data from WDSO to standard DSO.( refer:http://scn.sap.com/thread/2124464)

Semantic Groups in DTP defines primary keys for error stack of DTP.Then ensure that corrected recrods get updated into the target.

Hope it helps.

Regards,

Harish.

[Former Member]

Agreed. Would be great if we can get any examples to demonstrate this some where....

[Former Member]

Semantic Keys in Write Optimized DSO :

1. If you are using the Write Optimized DSO for lookups etc - then you will need a semantic key - otherwise the lookups will be full table scans.

Semantic Keys is more for organizing the data in a readable format within the WDSO.

Semantic Keys for DTP -:

When loading data to another target - if you want to group the records in a specific way - for instance if you want to store the maximum value for each customer - then you will have to group the data to find this out when loading the information - this would mean that all the data for that customer should be in the same DTP data package - for this you use a semantic key in the DTP.

[Former Member]

Hi Arun,

Would you please elaborate Semantic groups in DTP with an example as I couldn't get the complete understanding..?

[Former Member]

Semantic keys are used mainly to identify the error in incomming records or duplicate records and also semantic keys protect the data quality.

The semantic key determines which records should be detained when processing.

All subsequent data records with same key are written to error stack along with the incorrect data records. These are not updated to data targets,these are update to the error stack.

In order to process error records or duplicate records, you must have to define Semantic group in DTP (data transfer process) that is used to define a key for evaluation.

If you want to use the Write optimized DSO objects in BEx Queries, it is recommended that you define semantic key and that you run a check to ensure that the data is unique.