How to modify master data while moving transaction data from one model to another?

[Former Member]

Hello,

I am trying to load data from one model to another using DESTINATION_APP. Now the source model has Cost Elements with a prefix of "CE_" and the target model has prefix "GL_".

I am mapping both using *RENAME_DIM COSTELEMENT = GLACCOUNT which is OK but how do i do the conversion from CE_****** to GL_******?

I believe from the Target model we can pull data using the Import TX Data from BW InfoProvider DMP but the users of the source model need control of the data movement.

Kindly let me know if you have any ideas.

For your reference, we are using BPC 10.1 Standard.

Thanks and Regards,

Swakshar

[former_member186338 · Accepted solution]

In the source model you have to create a property (GLACC) for COSTELEMENT containing required GLACCOUNT ID. Then in script use:

*REC(..., COSTELEMENT=COSYELEMENT.GLACC)

[former_member186338 · Accepted solution]

P.S. Prefix replacement you can do only in ABAP with custom logic badi.

"Import TX Data from BW InfoProvider" - bad idea, yellow request will not be imported!

[Former Member]

Thank you so much Vadim!

Best Regards,

Swakshar Choudhury

[former_member186338]

Instead of *RENAME_DIM you can use:

*SKIP_DIM = COSTELEMENT
*ADD_DIM GLACCOUNT = COSTELEMENT:GLACC 

with the same effect!

[Former Member]

Will try it out!

Thanks again Vadim!