Skip to Content

SAPGetData formula is not working when referencing on other cells

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

sapgetdata.jpg (43.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Apr 02 at 03:08 PM

    Hi,

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

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 02 at 03:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 09 at 09:06 AM

    Hi,

    you have to escape the cell c3

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

    Add comment
    10|10000 characters needed characters exceeded