Question:
Hi, Prior to loading a Master data Object I would like to clear all the values of it's attributes. Does anyone know of a good way to do this? ABAP or otherwise?
Thanks
Answer:
There should be nothing in your IO if this were your first time loading it.
Answer:
Assume my infoobject is already loaded and the attributes have values. I would like to clear out the attribute values prior to loading....
Any ideas anyone?
ThankS!
Answer:
OK, unless your IO values are used in transaction data in data target(s), you can just delete all data and reload the new value or
Delete all transaction data in data target(s) first and then delete the IO data. or
Open you system and manually deleting the attributes for each IO data record. or
Just load the new data, any changes should be taken care by master data activation.
Answer:
I first thought about just deleting the master data completely each time because the infoobject is not currently used in any datatargets. But, it may be down the road and deleting it completely will not be an option. So, I would like to find a method to just clear out certain attributes of the infoobject each time it is loaded.
Any more ideas, anyone?
I could write a program to update the master data table and the sid table manually, but I don't know if there are any problems with doing this?
Thanks again...
Answer:
Maybe I totally misunderstood your requirement, but let's try it anyway.
At the InfoObject Change screen, highlight all the attributes and click the 'Maintain' button. It will give you an access to all the attributes data, there, you can perform mass delete all or some of them.
Good luck.
ASAPFan
Answer:
Hi Thanks for the reply, but let's keep trying. I need a way to clear the attributes of an InfoObject Prior to loading the InfoObject. I need to do this in a process chain so I'm sure I'll need a program or some process to do this.....
Any ideas out there?
Thanks again!
Answer:
You can certainly pre-load your IO with a dummy file i.e. from another IO with no attributes. BUT why do you need this feature, I must ask?
Answer:
Yeah, I thought about that, but it seems to be a hokey solution... The reason why I'd like to do this is a little complicated, but I'll try if someone is willing to listen...
I have an InfoObject IOBJ with attribute ATTR1. The source for this master data is a file. When an MD item is deleted in legacy then the flat file will not include the item in the file. This means that the item no longer should exist in the master data or should have the attributes of the item cleared. So, if I can clear the attributes of all the items then the next load will correctly populate only the active items and the deleted one will have empty attributes.... Let me know if you have any ideas again...
Thanks!
Answer:
I have some flags as attributes which I default every time I load the InfoObject (Customer IO with "Priority Treatment" flag for example). Customers which qualify as priority changes over time, and if a Customer was a priority yesterday doesn't mean they are one today (and the flag must be turned off).
I used the export datasource for the IO to recursively populate it. The infosource for Customer has a source system for the BW system. I then pull across only the key (Customer number) and deactivate all the transfer rules except the fields I want to default (which I populate with a constant).
This appears to work quickly and effectively.
Jim F.
Answer:
Here's another idea :
import your MD file into a BW transparent table first. This gives you a chance to check and update the status of each MD record in your ABAP codes . Then use this table as your IO data source using standard Bw functionality.
Very simple, and robust. I'm sure you have though about it.
Answer:
OK, great ideas and I appreciate all of the feedback... I'll give Jim's idea a try. Again thanks EVERYONE!
Have a great weekend warriors of BW....