SAPGetData formula is not working when referencing on other cells

[former_member1009339]

I would like to use SAPGetData for dynamic formulas.

For example:

The formula (pls see screenshot) is referencing on cell C3 for 0CALYEAR. In Cell C3, you will see "2018". I would now expect that the formula provides data for the year 2018. But it is not working.

The formula works only when mentioning all information in the formula (without any references), e.g. ;"0CALYEAR=2018".

Do you know how to reference on other cells?

Dirk

[reyemsaibot]

Hi,

you have to escape the cell c3

=SAPGetData("DS_1";"00O2TPBHJCSZRZ47C0MLIVE6X";"FIELD="&C3)

[former_member1009339]

Hi Jothi,

This one is not working:

=SAPGetData("DS_1";"00O2TGL3CDW39KP82H8LFPWYU";"0CALYEAR=C3";"0FISCVARNT=K4";"0FISCYEAR=K42018";"RCAAVKORG=1200";"RCAAKOKRS=1200";"RCAABUKRS=1200";"RCAAVTYPE=30";"0LOC_CURRCY=GBP")

C3 show =SAPGetMember("DS_1"; "0CALYEAR=2018"; "Key")

OR

C3 = 2018

OR

C3 = '2018

**********************

This one is working:

=SAPGetData("DS_1";"00O2TGL3CDW39KP82H8LFPWYU";"0CALYEAR=2018";"0FISCVARNT=K4";"0FISCYEAR=K42018";"RCAAVKORG=1200";"RCAAKOKRS=1200";"RCAABUKRS=1200";"RCAAVTYPE=30";"0LOC_CURRCY=GBP")

Thanks

Dirk

[jyothirmayee_s]

Hi,

Do post full SAPGETDATA() formula and also is 2018 with '2018 or just 2018?.

Thanks,

Jothi