Skip to Content
0

Analysis for office 2.4 SAPGETDATA

Sep 28, 2017 at 09:16 PM

108

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Gersh Voldman
Sep 30, 2017 at 10:33 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded