Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Script Logic using Lookup - From Rate to Planning model (Multiply)

Dear Experts

I am following SAP Best Practices for HCM Planning. Following are my dimensions maintained.

HCM_RATES:

HCM_SALARY_TYPE (ACCOUNT DIMENSION) = BASIC SALARY

HCM_GRADE (USER DEFINED)= 1

TIME = 2015.01

CATEGORY = PLAN

R_ENTITY = GLOBAL

CURRENCY = QAR

VALUE = 5000

HCM_PLANNING

CATEGORY = PLAN

TIME = 2015.01

ENTITY = CC101010

MEASURES = PERIODIC

HCM_GRADE = 1

HCM_ACCOUNT = HC (INPUT 20)

My objective is User input & save HCM_Account (Head Count = 20), If the user runs data manager package the calculation should be as below

HCM_ACCOUNT (BASIC SALARY) = Head Count*(HCM_SALARY_TYPE&HCM_GRADE COMBO - To pick from the HCM_RATES Model)

BASIC SALARY = 20*5000 = 100000

*LOOKUP HCM_RATES

*DIM CATEGORY="Plan"

*DIM CTA:HCM_GRADE="1"

*DIM CTA:HCM_SALARY_TYPE="101"

*DIM R_ENTITY="CC101010"

*DIM TIME="2015.01"

*DIM MEASURES="PERIODIC"

*ENDLOOKUP

*WHEN HCM_ACCOUNT

*IS "HC"

*REC(EXPRESSION =%VALUE%*LOOKUP(CTA),HCM_ACCOUNT="101")

*ENDWHEN

*COMMIT

I tried the above based on experts documents & SCN posts but not able to achieve the desired result.

If experts suggest the solution it would be a good learning.

*Also correct me whether the approach of planning is wrong.

Former Member
Not what you were looking for? View more on this topic or Ask a question