Skip to Content
0
Former Member
Jul 10, 2014 at 01:18 PM

SCRIPT LOGIC Error

24 Views

Dear Experts,

I have a simple requirement as below :

//*XDIM_MEMBERSET P_ACCT = EXPORT_SALE,TOTAL_SALE,DOM_ROYAL,DOM_OTHER,DOM_IMPORT_SALE

//[P_ACCT].[#EXPORT_SALE] = ([P_ACCT].[TOTAL_SALE] - ([P_ACCT].[DOM_ROYAL] + [P_ACCT].[DOM_OTHER] + [P_ACCT].[DOM_IMPORT_SALE]+[P_ACCT].[INTERNAL_SALE]))

//*COMMIT

But there is an exception with a set of cost center , where EXPORT_SALE = ZERO (0)

In order to implement this, we have written below script:

*XDIM_MEMBERSET CATEGORY=PLAN

*XDIM_MEMBERSET FLOW=NA

*XDIM_MEMBERSET P_ASSET=NA

*XDIM_MEMBERSET P_DATASRC=MANUAL

*XDIM_MEMBERSET P_CC=BAS(ABCD)

*XDIM_MEMBERSET P_ACCT = EXPORT_SALE,TOTAL_SALE,DOM_ROYAL,DOM_OTHER,DOM_IMPORT_SALE,INTERNAL_SALE

*XDIM_MEMBERSET P_EMP_TYPE=NA

*XDIM_MEMBERSET P_MATERIAL=NA

*XDIM_MEMBERSET P_PROJECT=NA

*XDIM_MEMBERSET P_SERVICES=NA

*WHEN P_CC

*IS BAS(BC)

*WHEN P_ACCT

*IS TOTAL_SALE,DOM_ROYAL,DOM_OTHER,DOM_IMPORT_SALE,INTERNAL_SALE

*REC(FACTOR=0,P_ACCT=EXPORT_SALE)

*ENDWHEN

*ELSE

*WHEN P_ACCT

*IS TOTAL_SALE

*REC(EXPRESSION=%VALUE%-([P_ACCT].[DOM_ROYAL]+[P_ACCT].[DOM_OTHER]+[P_ACCT].[DOM_IMPORT_SALE]+[P_ACCT].[INTERNAL_SALE]),P_ACCT=EXPORT_SALE)

*IS DOM_ROYAL

*REC(EXPRESSION=[P_ACCT].[TOTAL_SALE]-(%VALUE%+[P_ACCT].[DOM_OTHER]+[P_ACCT].[DOM_IMPORT_SALE]+[P_ACCT].[INTERNAL_SALE]),P_ACCT=EXPORT_SALE)

*IS DOM_OTHER

*REC(EXPRESSION=[P_ACCT].[TOTAL_SALE]-([P_ACCT].[DOM_ROYAL]+%VALUE%+[P_ACCT].[DOM_IMPORT_SALE]+[P_ACCT].[INTERNAL_SALE]),P_ACCT=EXPORT_SALE)

*IS DOM_IMPORT_SALE

*REC(EXPRESSION=[P_ACCT].[TOTAL_SALE]-([P_ACCT].[DOM_ROYAL]+[P_ACCT].[DOM_OTHER]+%VALUE%+[P_ACCT].[INTERNAL_SALE]),P_ACCT=EXPORT_SALE)

*IS INTERNAL_SALE

*REC(EXPRESSION=[P_ACCT].[TOTAL_SALE]-([P_ACCT].[DOM_ROYAL]+[P_ACCT].[DOM_OTHER]+[P_ACCT].[DOM_IMPORT_SALE]+%VALUE%),P_ACCT=EXPORT_SALE)

*ENDWHEN

*ENDWHEN

We have passed this script in default.lgf.

But every time any GL is written, the value is getting added to EXPORT_SALE for other values of P_CC other than BAS(BC)

Will appreciate your inputs.

Regards,

SAP BPC