Facing problem in loading masterdata from PSA for 0cust_sales

[Former Member]

Hi,

I am facing problem while loading Masterdata for 0cust_sales in PSA. data is coming from KNVV table but there is no duplicate record in the KNVV Table but while loading data to SAP BI, Its showing error message in PSA for few customers - duplicate records being created.

Kindly please help me with this issue

Regards,

Swapnil

[Former Member · Accepted solution]

Yes it has got duplicate records in PSA

[Former Member · Accepted solution]

Hi,

if you are on 7.0. you can switch on "Handle Duplicate Record keys" at the DTP / Update Register.

[Former Member · Accepted solution]

Switch on Indicator: Handling Duplicate Data Records

Use

If this indicator is set, duplicate data records (that is, records with the same key) are handled during an update in the order in which they occur in a data package.

For time-independent attributes of a characteristic, the last data record with the corresponding key within a data package defines the valid attribute value for the update for a given data record key.

For time-dependent attributes, the validity ranges of the data record values are calculated according to their order (see example).

If the indicator is not set and error handling is deactivated, the request terminates once data records with the same key are detected. If error handling is activated, data records that have the same key are written to the error stack of the DTP.

Note:

If during your data quality measures you want to make sure that the data packages delivered by the DTP are not modified by the master data update, you must not set this indicator.

[Former Member]

Please follow what 'Jürgen Sauer' has said.

and let us know if you still face the same problem.

Thanks,

Yerrabelli

[Former Member]

Please check if the data has duplicate entries in PSA....