Skip to Content

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

multiplication of account using script logic

Hi all,

My requirement is multiply the head count to salary account from specific time period.

For example user will input salary only for one month like 2015.jan now this salary account value should be multiplied with head count account for each time period of that year, and result should be stored on third account say headcount_exp.

*LOOKUP FINANCE

*DIM CATEGORY="ACTUAL"

*DIM DATASRC="INPUT"

*DIM TIME="2006.JAN"

*DIM DEPARTMENT="NODEPT"

*DIM ENTITY="IND"

*DIM INTCO="I_IND"

*DIM PRODLINE="P0101"

*DIM ACCOUNT="INVESTEQUITY"

*DIM DTTIM:RPTCURRENCY="LC"

*ENDLOOKUP



*XDIM_MEMBERSET CATEGORY=ACTUAL

*XDIM_MEMBERSET DATASRC=INPUT

*XDIM_MEMBERSET DEPARTMENT=NoDept

*XDIM_MEMBERSET ENTITY=IND

*XDIM_MEMBERSET INTCO=I_IND

*XDIM_MEMBERSET PRODLINE=P0101

*XDIM_MEMBERSET RPTCURRENCY=LC

*XDIM_MEMBERSET RPTCURRENCY=LC


*WHEN ACCOUNT

*IS SALESUNITS

   *REC(FACTOR=LOOKUP(DTTIM),ACCOUNT=IICREV)   

*ENDWHEN

I have hard coded time value in look up but i want time member to be pass from data prompt.

OR

Any other solution for above script?

Regards,

Sushant.

Former Member
replied

Hi Sushant,

Sorry for the delay in getting back to you. Try this setup:

Note: I'm adding [PERIOD]='JAN' to the *SELECT statement to ensure only one record is selected as the script doesn't seem to be able to handle several hits for *SELECT. It could be any property as long as you only get one hit

/Cecilia

0 View this answer in context

Helpful Answer

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