FM to Read Master Data Values against an InfoObject

[Former Member]

hi Experts,

i want to know if there is any FM which will take the InfoObject and give all the Master Data Values in it.

basically we have a Master Data Value and an InfoObject, all we want is to validate the Master Data Value against the InfoObject.

i am actually an ABAP'er and i dont have any clue as to what InfoObject and Master Data Values are. so Incase you want to explain me something , keep it simple.

Mouli.

Points will be rewarded

[Former Member · Accepted solution]

Hi Mouli,

You can basically access the "P" table of the master data for both these info-objects and compare the values. The table's technical name would be either /BI0/P<technical name of the info-object> if it starts with 0 or it would be /BIC/P<technical name of the info-object>.

You can write a simple ABAP program or function module for this.

Bye

Dinesh

[Former Member · Accepted solution]

hi Dinesh,

i had actually checked RSDIOBJ table against that InfoObject Name(ZESTABID). i took the value FIELDNM against the InfoObject and checked a table /BIC/ZESTABID but could not find it as it is a structure.

but when i checked /BIC/SZESTABID, it was giving me all the Entries against the InfoObject.

So can i Hardcode this Table and check each time?

[Former Member · Accepted solution]

Hi,

the /BIC/S... is the sid table of the infoobject. The better approach might be to use the p-table /bic/p.... or the view /bic/m...

regards

Siggi

[Former Member · Accepted solution]

hi siggi,

there isnt any /BIC/P or /BIC/M for this InfoObject. Probably they are not maintaining values in RSA1 or something.

[Former Member · Accepted solution]

Hi,

okay, then your object doesn't have any attributes. Then you're ok with the sid-table.

regards

Siggi

[Former Member · Accepted solution]

thanks siggi,

we are yet to find if our Client uses SID Table or the "P" Table, basically i wanted a direct FM which can do this Process. anyway thanks for the response

[Former Member · Accepted solution]

Hi,

the p table is only available if your object is set up to have attributes and if at least one attribute is assigned to it.

regards

Siggi

[Former Member]

You should use the FM RSAU_READ_MASTER_DATA.

Regards,

Christoffer

[syed_er1]

Hi,

The best way is Goto to transaction RSD1 in BI/BW once you go there enter you infoobject name and display. If the infobject is masterdata then you will see masterdata/text tab with green icon, click on masterdata/text tab in that you will see master data tab there you will be having the transparent table name in which the data is being stored, using that you can compare.

hope this helps

thanks

syed