Skip to Content
0
Former Member
Jun 05, 2011 at 04:03 PM

LOOKUP in Script Logic

33 Views

Dear experts,

I am doing a look up in different application for multiple measures. Also for a DATASRC member, I need to look up at the TOT_SRC level for which I am doing CALC_DUMMY_ORG

Is it supported in BPC NW? The SAP 420 book says it's not supported. If it so, then what's the alternative approach?

I know in MS, we have SUB/ENDSUB to group logic instructions and can invoke wherever we want. Is it supported on NW?

My code is like the below

*LOOKUP TAUX

*CALC_DUMMY_ORG

*ORG DONNEES_SRC = PARENTH1

*WHERE TYPE_TAUX = PCT_TAUX_AUG, SAL_MOY, ECHELON, SAL_MAX

*WHERE CENTRE_COUTS = NA_CENTRE_COUTS

*ENDCALC

*DIM CENTRE_COUTS = "NA_CENTRE_COUTS"

*DIM CLASSE_TAUX=%CLASSE_TAUX_SET%

*DIM DEVISE_ENTREE="CAD"

*DIM DONNEES_SRC = "TOTAL_SRC"

*DIM TEMPS = %TEMPS_SET%

*DIM TITRE_DEMPLOI="NA_TITRE_DEMPLOI"

*DIM VERSION=%VERSION_SET%

*DIM PCTTAUXAUG:TYPE_TAUX = "PCT_TAUX_AUG"

*DIM AVGSAL:TYPE_TAUX = "SAL_MOY"

*DIM ECHELON:TYPE_TAUX = "ECHELON"

*DIM SALMAX:TYPE_TAUX = "SAL_MAX"

*ENDLOOKUP

Appreciate any advice.

Prabhakar