Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 01, 2017 at 03:30 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 03, 2017 at 01:42 PM

    Thank you so much Vadim!

    Best Regards,

    Swakshar Choudhury

    Add comment
    10|10000 characters needed characters exceeded