At times in SAP Business Planning and Consolidation, when writing a *WHEN-*REC-*ENDWHEN structure in script logic, we may come across a scenario where we want to post value to an intersection\/region where there is no data. This was not supported previously as calculations happen in transaction mode by default.<\/p>\n
The above is not a limitation anymore in SAP BPC NW with the new script logic keyword -*WHEN_REF_DATA. This allows us to switch our calculation mode to either transaction data or master data. <\/p>\n
Syntax<\/strong><\/p>\n 1) <\/strong>To enable master data mode<\/strong><\/p>\n *WHEN_REF_DATA = MASTER_DATA <\/p>\n \/\/*WHEN-*REC-*ENDWHEN CONSTRUCT<\/p>\n 2) <\/strong>To enable transaction data mode<\/strong><\/p>\n *WHEN_REF_DATA = TRANS_DATA <\/p>\n \/\/*WHEN-*REC-*ENDWHEN CONSTRUCT<\/p>\n Example<\/strong><\/p>\n *XDIM_MEMBERSET TIME=2010.MAR<\/p>\n *WHEN ACCOUNT<\/p>\n *IS ACC1<\/p>\n *REC(EXPRESSION=1000, ACCOUNT=ACC2)<\/p>\n *ENDWHEN<\/p>\n Here we have no *WHEN_REF_DATA and thus calculations will happen in the default mode i.e. transaction data mode. A value of 1000 will be written to ACC2 wherever there is a value for ACC1 in the period 2010.MAR.<\/p>\n Now, let us look at the same example in master data mode.<\/p>\n *XDIM_MEMBERSET TIME=2010.MAR<\/p>\n *WHEN_REF_DATA = MASTER_DATA <\/p>\n *WHEN ACCOUNT<\/p>\n *IS ACC1<\/p>\n *REC(EXPRESSION=1000, ACCOUNT=ACC2)<\/p>\n *ENDWHEN<\/p>\n In this case, 1000 will be written to ACC2 even when there is no data for ACC1 in the period 2010.MAR.<\/p>\n Please check the Note 1474115<\/a> for further details.<\/p>\n","protected":false},"excerpt":{"rendered":" At times in SAP Business Planning and Consolidation, when writing a *WHEN-*REC-*ENDWHEN structure in script logic, we may come across a scenario where we want to post value to an intersection\/region where there is no data. This was not supported … Continue reading \n