Skip to Content

DESTINATION_APP mapping member from different accounts and models based on their properties

Hi gurus,

I have this particular scenario with a Destination_App logic case I am moving data from SOURCE to TARGET Model A to Model B the tricky part is that the dimensions are not the same.

The Requirement:

I need to send data from Source Model to Target Model using DESTINATION_APP but the members coming from the one Source Model Dimension JOB_CODE need to be filtered by a property "PARENTH1 = IUP" and its records "mapped" or moved to a Target Model MPU_UNIT Dimension in which the "only" members that should be affected are the ones which "ID" property is matching with "DESC" property of the incoming members from JOB_CODE from the Source Model.

The question:

Is this possible?and if so, would my code work satisfied the requirement? Thanks in advance.

Dimensions in Source Model

Dimensions in Target Model

*XDIM_MEMBERSET AUDIT_TRAIL = RATE_NPD,RATE_DBP,RATE_DDF
*XDIM_MEMBERSET CURRENCY = LC
*XDIM_MEMBERSET POSITION_ID = PINR
*XDIM_MEMBERSET POSITION_TYPE = PTNR
*XDIM_MEMBERSET MEASURE = PERIODIC
*XDIM_FILTER JOB_CODE = [JOB_CODE].PROPERTIES("PARENTH1")="IUP" 

*DESTINATION_APP = MPU

*ADD_DIM MPU_COMP = CCNR
*ADD_DIM MPU_COST = MSA
*SKIP_DIM = ORG_UNIT
*SKIP_DIM = POSITION_ACTION
*SKIP_DIM = POSITION_ID
*SKIP_DIM = POSITION_TYPE

*RENAME_DIM JOB_CODE = MPU_UNIT

*WHEN TIME 
*IS *
*REC(EXPRESSION=%VALUE%,JOB_CODE=JOB_CODE.MPU_UNIT) 
*ENDWHEN 

*COMMIT
position-model.png (24.0 kB)
mpu.png (22.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 19 at 03:12 PM

    Do you need an answer?

    Then please, prepare your question in line with: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

    Please don't include commented code!

    Please use correct line breaks!

    Add comment
    10|10000 characters needed characters exceeded