Master data loading for CC and PC

[Former Member]

Dear Experts,

While pulling master data from SAP BW for cost center and profit center, we have to add Controlling area as a part of ID since it is the compounded info object for cost center and profit center in SAP BW.

But we don't need the controlling area to be part of ID's in BPC.

But while mapping ID, when we don't add controlling area as a part of Id, it throws an admin error while validating and processing the transformation file.

We tried below :

ID = ID

this was  not taken by the system.

As a work around we mapped as below :

ID = ID+*STR( ),

this was also not taken by the system.

But when we added any other character like '_' instead of  '  '   ,

ID = ID+*STR(_),

it accepts properly.

But the requirement is we need only ID for cost center and profit center in the BPC master data.

Awaiting for your kind assistance.

Regards,

sap bpc

[former_member190501 · Accepted solution]

Hi,

If system really does not allow with out compounding attribute into BPC then you can load your BW master data into custom info object with out compounding and load from the custom info object to BPC.

Hope it helps..

regards,

Raju

[Former Member · Accepted solution]

Thanks Prasad!!

[Former Member · Accepted solution]

Hi Prasad,

I have a similar issue while loading master data , the option of creating a custom object has been kept on hold until we find a solution on the transformation file to load ID's without compounding infoobjects.

Do you think we have a way to create a custom mapping in the transformation file and avoid creating custom infoobjects?

Welcome your suggestions !

Regards,

Deepak BM

[Former Member · Accepted solution]

Deepak,

If the below works for you.

ID = ID+*STR(_)

then in transformation file put this line and create a conversion file where you can use below.

External          Internal

*_                    *

So Basically I added an "_" in transformation file and got rid of it in conversion file so finally what will get loaded is only the ID.

Hope it helps.!

Regards

Nikhil

[Former Member · Accepted solution]

Hi Nikhil,

I applied the above and now I get the ID as 0000050001_ and I should be only getting 50001.

Any help !!

Thanks

Deepak BM

[former_member186338 · Accepted solution]

Hi Deepak,

It's better to open a new discussion and provide full texts of your transformation and conversion files.

Vadim