BW backend table - Composite Provider

[Former Member]

Hello Experts

Is there any table where we can see all fields mapping for Composite provider. Something similar to RSDICMULTIIOBJ.

[dmendez]

For a compositeprovider, you can display the object in the SAP GUI, t-code: RSOHCPR or LISTCUBE and if the object has many infoObject, the pop-up window will come where you can select the IOs that you want to display (up to 72). In that pop up screen, select all the fields and then the second last icon: "Write to a file". You will get the info objects, description, including navigation attributes and even the objects from the HANA view in a format that you can use in Excel.

Option 2: in the same screen, at the very beginning, check: "Technical names" once you have the results (and for example the pop up screen did not show up) go to results and change the layout/variant. The column "Displayed columns" will have all the fields/IO technical names. Then you can select the entries with CTRL-mouse shift begin to end and copy into the buffer. You can paste in Excel the IO's.

[edwin_dayanandhm]

Hi,

Sorry I almost forgot.

Use the transaction RSOHCPR.

Give the HCPR name and click on Display XML to get the entire XML structure.

Best regards,

Edwin.

[Former Member]

Thanks Edwin for all the information.

Will have to create a program to get this output in tabular format.

Even though CP are more powerful, current method to create them in SAP BW is not that great. MP mapping was very easy to maintained and  enhanced. + meta data is easy to get in case of MP.

[Edwin]

Hi,

The definition of a CompositeProvider is stored as XML and therefore the mapping is not stored in the same way as with MultiProviders.

However, by converting the XML string you can get a display of the field mapping: Mapping of InfoProvider fields in CompositeProvider.

Regards,

Edwin

[edwin_dayanandhm]

Hi,

Just to add... Take a look into the table RSOHCPR.

If you extract the xml from the table as a file, then you can get the details.

Best regards,

Edwin.