Lookup Function variable issue

[former_member309686]

Hi Experts,

I am using a lookup function in my script logic. The code is written below.

*LOOKUP Sales_Main//the real name of model 2

*DIM SALES_ACCOUNT ="QTY"

*DIM PRODUCT = "0100100101"

*DIM AP:CATEGORY="Annual_Plan"      //variable AP

*DIM LP:CATEGORY="Long_Plan"          //variable LP

*ENDLOOKUP

When I use these results in *REC statement, this only writes a record with variable LP (The last variable written in the lookup) and not with AP.

Now when i change the sequence of variable lines in my lookup function like this

*LOOKUP Sales_Main//the real name of model 2

*DIM SALES_ACCOUNT ="QTY"

*DIM PRODUCT = "0100100101"

*DIM LP:CATEGORY="Long_Plan"

//variable LP

*DIM AP:CATEGORY="Annual_Plan"      //variable AP

*ENDLOOKUP

this only writes a record with variable AP (The last variable written in the lookup function ) and not with LP.

Am I making some mistake or is this a bug? Can I use 2 variables for 2 different category?

Quick response is requested .

Thanks alot

[former_member186338 · Accepted solution]

BPC & BW version and SP! Please!!!!

It was a bug at some SP...

Vadim

[former_member309686 · Accepted solution]

Hi Vadim,

BPC version is 10.1

CPMBPC    810    0005    SAPK-81005INCPMBPC    SAP Business Planning and Consolidation

Regards

[former_member186338 · Accepted solution]

Yes, you have to upgrade to SP06 or implement the note: http://service.sap.com/sap/support/notes/2136166

Vadim

[former_member309686 · Accepted solution]

Thanks Vadim it works.

[former_member186338 · Accepted solution]

In future, please search SAP notes before asking In case of clear bug like this it's easy to find a solution in a note.