enhancing master data

[Former Member]

Hello Everyone,

I need to enhance the ds 0customer_attr with fields GRUPP and KDGRP from KNKK table. what is the logic that i need to use to fill the fields with data by also ensuring that i don't get any duplicate records for the fields. (the keys for the table KNKK --> KUNNR and KKBER).

P.S: How do i ensure whether i am getting duplicate records or not ?

Thanks in advance.

[Former Member · Accepted solution]

Hi,

To finout the values for the fields GRUPP and KDGRP, you need the two fields KUNNR and KKBER. But in the Extraction of 0customer_attr you will get only KUNNR,so you will get definately duplicate values for the fields GRUPP and KDGRP in the user exit for enahncement.

So to avoid duplicate values, instead of enhancing the master data (0customer_attr ) do enhancement of transaction data extractor. In transaction data, you definately have both fields's values( KUNNR and KKBER) so that you will get no duplication.

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

thanks anil. could u tell me which std transaction extractor can i append these fields to inorder to avoid duplication. other than this is there anyway that i can append these fields to a master datasource itself.

[Former Member · Accepted solution]

Hi,

AS per my knowledge it is not possible to avoid duplication if we add your required fields to 0customer_attr as enhancement.

To finout the Transaction extractor, you ask your self that what are the queries in which this information is needed. Then finout the Extractors which are supporting data for that cube .

It is better to wait for experts' suggestion to come to conclusion that whether it is possible through Master data extraction or not.

With rgds,

Anil Kumar Sharma .P

[Former Member · Accepted solution]

Hi,

You can append the fields to the master data DS itself. And the duplicate records can be avoided at the InfoPackage level while loading, by having the load through PSA and with the setting "Ignore Double Data records" checked.

Hope it helps.

[Former Member · Accepted solution]

thanks karthik for the suggestion.