Skip to Content

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

Rollforward Balance Sheet Account Script Logic

Hello-

I am attempting to write a script that will take the latest value out of the "actual" category for account bs280. The total for this account should be rollforward to every month in the working plan to accunt 160700. Here is my script, I am getting the error "unknown dimension name in keyword" on line 35.

*SELECT(%WP2%,"[ID]","TIME","[WP]='Y'")

*SELECT(%LTP2%,"[ID]","TIME","[LTP]='Y'")

*LOOKUP FINANCE  

*DIM DATASRC = <ALL>

*DIM MEASURES = PERIODIC

*DIM FLOW = <ALL>

*DIM CATEGORY = ACTUAL

*DIM COMPANY = <ALL>

*DIM CCENTER = <ALL>  

*DIM TPARTNER = <ALL>  

*DIM PCPARTNER = <ALL>  

*DIM TIME = %CURRMO% 

*DIM PPE1:ACCOUNT = BS280

*ENDLOOKUP

*XDIM_MEMBERSET PCENTER = BAS(F2000)

*XDIM_MEMBERSET ACCOUNT = BAS(FIXEDASSETS_NET)

*XDIM_MEMBERSET CATEGORY = WORKINGPLAN

*XDIM_MEMBERSET MEASURES = PERIODIC

*XDIM_MEMBERSET CCENTER = <ALL>

*XDIM_MEMBERSET DATASRC = INPUT, SYNCCAPEX, ECC, BCF

*XDIM_MEMBERSET PCPARTNER = <ALL>

*XDIM_MEMBERSET TPARTNER = <ALL>

*XDIM_MEMBERSET TIME = %WP2%

*FOR %T%=%WP2%

  *WHEN ACCOUNT

  *IS 160700

  *REC(FACTOR=1*LOOKUP(PPE1),TMVL(1,%T%))

  *ENDWHEN

  *COMMIT

*NEXT

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