Skip to Content
author's profile photo Former Member
Former Member

0CUST_SALES_ATTR loading issues.

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Apr 30, 2012 at 12:54 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 30, 2012 at 12:57 PM

    HI,

    Check the data for those records in PSA.

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

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.