Skip to Content

Analysis for office 2.4 SAPGETDATA

HI

=SAPGetData("DS_1",C12,C4,C5,C6) it returns #Value and error Object reference not set to an instance of an object.

below line 4 to 12

ERP/CATEGORY=PLN ERP/SEGMENT=# 0FISCPER=005.2017 ZAUDIT=INPUT /ERP/PROFTCTR=# /ERP/COMPCODE=2100 0UVGEUFLKQ4IEZDN1NO8D0BJM

line 12 i have used Enterprice id, in Bex we have used restricted key figure.

Error Log:

SAP .NET Connector 3.0 with file version 3.0.18.0 running on 32-bit .NET Framework 4.0.30319.42000 Program: C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE Working directory: C:\Users\developer3\Documents Operating system: Windows Server 2008 R2 Datacenter Server 64-bit Service Pack 1 Processor: 4x AMD64 (or x64) SAP release: 721, Kernel release: 721, Kernel patch level: 713 Hostname: WIN-xxxxxxxx, IP address: xxxxxx, IP_v6 address: Default trace level: None

Please advise

Regards

Vinoo Gan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 30, 2017 at 10:33 PM

    Hi Vinoo,

    You have to start from formula that works and change one parameter at a time. Use button "Convert to Formulas" to see working formulas.

    Regards,

    Gersh

    Add comment
    10|10000 characters needed characters exceeded