on 04-17-2008 9:20 PM
Helllo Gurus,
I am running a report on Infoset and some of the fields has no data. when I report executed, the fields with no data shows "Not assigned" in the report. If I manually enter "Blank" space in the master data, it is displaying "Empty Space" in the report. But we are loading Master data everyday using process chains. How can I write in transfer rules that if one field is empty then it shud pass "Blank" for that field.
How can achieve this????
Any Help is appreciated with points.
Regards,
PNK.
In the master data of the infoobject, change the field in first record (this will be a blank row) to what you want this field to display when there is no master data for it.
Save and activate the master data.
Now run the report for the Not assigned values it will display the values you just entered above.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sam, Thanks for quick reply and your solution worked perfectly fine. I showed the solution to my manager, he is happy as of now. if the same solution is work in Quality and Production, do I have to transport this infoobjects to Quality and Prod or do I have to manually enter "Blank" space for the first record?????
and during the refresh, we delete all the records from the master data and we reload. during this, do we have to do that again???
Regards,
PNK
This not a change to IO definition.
Its just master data maintenance you directly do it in production, Right click IO -> Maintain Master Data
Do the changes, Save and activate Master data.
and during the refresh, we delete all the records from the master data and we reload. during this, do we have to do that again???
What do you mean by this?
Hi Sam,
I mean, If I delete the master data, whatever the changes I made are also deleted and I had to save the first record again empty and reload. So, other than manually saving the space, if I want to use routines in the transformations that if a field is empty, then it should pass empty space.
Regards,
PNK
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.