0CUST_SALES_ATTR loading issues.

[Former Member]

Hello Experts,

We are loading 0CUSTOMER_SALES_ATTR data into our 3.5 BW system using 'Delta' mode. We noticed that the Sales Office field is incorrect for a few of the records and so decided to do a 'Repair Full' load to correct these incorrect records. Now when the 'Repair Full' load is done, we see that in the 'Update' step of the data load that 'No database operations necessary, data unchanged '. Now when we compare the data in RSA3 for 0CUST_SALES_ATTR & the 0CUST_SALES master data table in BW, the Sales Office values are still different.

My assumption was that, when we do a Master data load, the system over-writes the master data table in case of the same records being posted again or it adds a new record to the table in case of a new record being posted.

Am I missing anything here, how does the system check to see if any database operations are needed during the master data load? Does it just check for changes in the Key Fields?

Thanks

Arvind

[former_member188080 · Accepted solution]

Hi,

First check what data is coming in PSA. whether it is same what u see in RSA3 in source system or it is different?if different than you have to see if there is any routine which is changing this value..

Normally master data load should overwrite..check RSRV also for master data..

in case of delta ..those delta enabled field should be changed..for record to get modified ..

see if you are missing on activation run/attribute change run else change will not reflect..so right click and activate the master data..

Thanks and regards

Kiran

[former_member182470]

HI,

Check the data for those records in PSA.

Instant Solution:  You can edit directly in the BW Master Data table.

Regards,

Suman