394 questions
0
votes
0
answers
50
views
Python script causing An exception occurred while connecting with SAP system: ("unhashable type: 'dict'",)
Here is my python script that tries to pull data from a SAP table into AWS Glue.
from pyrfc import Connection
import pandas as pd
## Variables
sap_table = 'TABLENAME' # SAP Table Name
fields = ["...
- 3
0
votes
1
answer
193
views
Cython not installed error on any Python version when installing pyRFC
I have been following this guide to process SAP data via Python.
https://community.sap.com/t5/technology-blogs-by-members/connecting-python-with-sap-step-by-step-guide/ba-p/13452893
However, I get ...
1
vote
0
answers
147
views
SAP Connection failed: name 'Connection' is not defined, PyRFC in django
I'm experiencing an issue with the PyRFC library in my Django project running on Pythonanywhere server. Specifically, I am trying to use the Connection class from PyRFC to establish a connection to an ...
0
votes
2
answers
1k
views
How to update a single database table in a separate LUW in ABAP?
I have a requirement in an existing production development to log errors. It needs to be done in multiple applications.
I created a table and called it in a method. I am calling a Function Module as ...
- 51
2
votes
0
answers
273
views
RFCTYPE_TABLE cannot be converted to type RFC_STRUCTURE_HANDLE
I'm querying SAP using C# .NET Core, using SAPNWRFC for the first time, and I'm encountering issues with querying an RFC. Essentially, I'm calling an RFC with two parameters and retrieving the result ...
0
votes
1
answer
85
views
SAP RFC call in WCF and . NET 7 via VS 2022 error
I can not manage the following error :
System.InvalidOperationException: ‘’There is no TransportBindingElement in the CustomBinding on the ServiceEndpoint with the negotiation ‘ZQM_XPortType’. Each ...
- 90
1
vote
0
answers
618
views
How to connect to a SAP BW Cube from Python
I have a SAP BW cube and I can access it using power query with the "SAP Business Warehouse Message Server" Power BI connector,
The power M code is something like:
let
Source = ...
0
votes
1
answer
423
views
How to connect SAP ERP with node.js
I need to connect my VS code to the SAP system, because i need to develop a intern webshop. Unfortunately i can't find nothing for SAP ERP just fpr SAP HANA or S4/HANA i could find something. I find ...
- 1
-2
votes
1
answer
532
views
DLL load failed while importing _cyrfc: The specified module could not be found
getting error while importing pyrfc module:
DLL load failed while importing _cyrfc: The specified module could not be found.
can someone help?
- 29
0
votes
0
answers
332
views
How can I fetch table data using node-rfc SAP's BAPI
I need to fetch table data from a SAP system with node-rfc library. Need help where I can pass table name or parameters so that I can get proper data to build Node.js API.
Do you have any idea what is ...
- 555
0
votes
0
answers
114
views
C# SAP ABAP query TABLE STRUCTURE
I have the following structure received from SAP software, what is the correct way to obtain the DATA field where the TBL_ACT field is equal to "TAR - ENTRY"?
Code used in the API:
public ...
0
votes
1
answer
805
views
Get SAP BW infocube data with pyrfc RSDRI_INFOPROV_READ_RFC
I am trying to get data from an SAP BW infocube using Python with pyrfc. I am currently using the ABAP function RSDRI_INFOPROV_READ_RFC, but when I print the result I am unable to get something ...
- 11
0
votes
0
answers
58
views
How to to target_compile_definitions() in qmake? [duplicate]
In CMake I use:
#target_compile_definitions(appsap_rtf PRIVATE SAPwithUNICODE UNICODE _UNICODE SAPwithTHREADS)
target_compile_definitions(appsap_rtf PRIVATE SAPwithUNICODE)
target_compile_definitions(...
- 379
0
votes
0
answers
436
views
SAP Unicode Error calling Function Module in VBA
In VBA, I have created the function READ_TEXT to call the function module with the same name in SAP. To test the function, the sub tester_READ_TEXT is called with manual, hardcoded input.
Sub '...
- 431
0
votes
2
answers
237
views
SAPNWRFC connection refused with no error description
I have properly linked libs in my CMake:
set(SAPNWRFC_INCLUDE_DIR "${PROJECT_SOURCE_DIR}/nwrfcsdk/include")
set(SAPNWRFC_LIB_DIR "${PROJECT_SOURCE_DIR}/nwrfcsdk/lib")
set(...
- 379
1
vote
1
answer
2k
views
Calling a SAP table in Python via RFC_READ_TABLE gives an error: DATA_BUFFER_EXCEEDED
I am trying to extract a SAP table in Python using RFC_READ_TABLE:
result = conn.call('RFC_READ_TABLE', QUERY_TABLE=table_name, DELIMITER='|', FIELDS=fields, OPTIONS=Options, ROWCOUNT=MaxRows, ...
- 13
0
votes
0
answers
521
views
Extract a table with filters in Python via SAP RFC
I am trying to extract a table (BSIS) in Python via SAP RFC_READ_TABLE with the following code:
class Main:
def __init__(self):
self.conn = Connection(ashost=ASHOST, sysnr=SYSNR, client=...
- 13
0
votes
1
answer
351
views
Reading table via RFC_READ_TABLE in Java
I want to print details of all Transport requests, I am trying to read data in table E070 from SAP ECC using SAP JCo and RFC_READ_TABLE, I am running the following code but I am getting no output.
...
0
votes
1
answer
28
views
Value of type INTERFACE_HEAD() cannot be converted to INTERFACE_HEAD()
I want to connect with SOAP to SAP and have received a WSDL file. After import of the file as a Service Reference SOAPService I've now these classes available:
SOAPService.IMPORT1
Namespace ...
- 542
1
vote
1
answer
1k
views
Filtering the data by Date column using PyRFC with RFC_READ_TABLE
I managed to connect to SAP ABAP via Python, using PyRFC and RFC_READ_TABLE.
I am trying to figure how to querying a table by a Date column using the parameter OPTIONS.
I know the query should be the ...
- 81
1
vote
1
answer
346
views
How to pass RFC destination to BAPI from noderfc module?
Below is ABAP program which uses lv_destination which is RFC Target system for functional module BAPI_COMPANYCODE_GETDETAIL.
DATA lv_destination TYPE char10.
CASE sy-sysid+2(1).
WHEN 'P'.
...
1
vote
1
answer
458
views
SAP RFC libraries not working with IIS server
I am using SAP Connector Core Library to fetch SAP data using RFC, though my changes are working perfectly with the Kestrel server, but it is not working with IIS.
I am using the following libraries ...
- 2,444
2
votes
1
answer
465
views
Is it possible to install pyRFC onto a Databricks Spark cluster?
There is a Py-pi for pyRFC, but like all other C-python libraries, it has a lot of dependencies, and requires the setting of environment variables, etc.
Is it possible to install a c-python library ...
- 139
1
vote
1
answer
543
views
Can I use NW SDK client 7.5 for accessing NW 7.4 SAP server?
I have SAP NETWEAVER 7.4 installed on my SAP. Can I use 7.5 client libraries to connect to the server?
I have tried to connect to the server using SapNwRfc library, but got an exception
"...
- 109
0
votes
1
answer
618
views
Can I Create My JcoDestination File In Folder ? (JCO3 Java - SAP RFC Connection)
I want to access an RFC function on sap from my java program.
When I call getDestination("connect") I can connect and run my function without problems.
But I will have more than one config ...
1
vote
0
answers
259
views
Python 3.11.1. Getting error Failed to establish a new connection: [Errno -5] No address associated with hostname
I am using zeep 4.2.1 library to consume web services (RFC) from SAP. The API's are working in local server and getting the necessary response. However the API is not working in development ...
- 11
0
votes
1
answer
178
views
REDHAT 8 Apache PHP SAPNWRFC gkralik / php7-sapnwrfc only works from CLI - SAP
I'm using this repo to connect to SAP software:
https://github.com/gkralik/php7-sapnwrfc
but I don't know why my script connect and return data successfully from my zfunctions on SAP server only under ...
- 1,090
1
vote
2
answers
2k
views
SAP Table Connector - How to querying SAP table using RFC from Azure Synapse
We are using SAP Table Connector on Azure Synapse to extract SAP tables. However, we would like to filter the data in the copy activity.
I tried using the RFC table options using the COLUMN EQ 'SOME ...
- 11
0
votes
2
answers
5k
views
Extracting data from SAP spool to Excel using BAPI_XBP_JOB_SPOOLLIST_READ and VBA
I'm trying to build interactive Excel templates that extract data from SAP’s spool job using BAPI_XBP_JOB_SPOOLLIST_READ. The way I’m approaching the problem is:
Run a Transaction Code by means of ...
- 35
1
vote
1
answer
2k
views
RFC_CALL_TRANSACTION_USING to print to spool using VBA
I'm trying to use RFC_CALL_TRANSACTION_USING to get the SAP ERP software to run the transaction code FTE_BSM and print the result of the report to spool.
The transaction I am trying to use is FTE_BSM, ...
- 35
0
votes
0
answers
1k
views
.NET connection to SAP RFC table
I am not a SAP expert, but need to get a project up and running as quickly as possible and need some advise.
We have a .Net project (C#) that uses VS 2019 Professional and we need to pull data from a ...
-2
votes
1
answer
363
views
JCoFunction how to set a field of a structured parameter
I have this RFC
How do I set the internal value of the I_VALUE_DATA key?
<z_atcws_t_test>
<I_W_INFORMATION>str</I_W_INFORMATION>
<I_VALUE_DATA>
<E_DATA1>...
- 5
1
vote
0
answers
112
views
Wildcards/patterns with .Tables("PARA") when executing RFC INST_EXECUTE_REPORT
I'm using Excel and VBA to get SAP to download data from SAP through RFC using INST_EXECUTE_REPORT.
It works like a charm when I have specific input parameters. I just build up .Tables("PARA"...
- 35
0
votes
1
answer
635
views
Calling web API's via SAP Web Dispatcher from c#
I call a number of BAPI's and FM's using RFC calls to SAP using c#.
I would now like to convert these calls to connect and call then via SAP Web Dispatcher.
Does anyone know how the API calls will ...
- 3,104
0
votes
1
answer
696
views
Names of RFC parameters are unique?
I am working on an interface for communicating with SAP RFC functions. I have some questions regarding parameter hierarchy and uniqueness of parameter and table naming to which I can't seem to find an ...
0
votes
0
answers
251
views
LP_RFC_CONNECTION_PARAMETER_Array_5 error when initializing SAPNWRFC on Windows Python
I got this code in https://blogs.sap.com/2014/08/29/how-to-use-actual-sap-netweaver-rfc-library-with-python-read-table/
I did all the procedures to run it and it works on windows, but when I put it on ...
0
votes
1
answer
144
views
Get SMQ queues in Python?
I'm using the PYRFC library and so far I've managed to connect to SAP.
conn = Connection(ashost='xxxxxxxxx', sysnr='02', client='100', user='xxxxx', passwd='xxxxxxxx.')
result = conn.call('...
0
votes
0
answers
565
views
Cannot connect to SAP using PHP sapnwrfc with Connection Type Group
I cannot connect to SAP using PHP sapnwrfc, this is my code :
use SAPNWRFC\Connection as SapConnection;
use SAPNWRFC\Exception as SapException;
$config = [
'GROUP' => '*****', // Group/...
- 79
0
votes
0
answers
2k
views
Need to decode CLUSTD column SAP Hana
i am looking to decode the CLUSTD column of SAP, which is in encoded form as binary. I want to decode it outside SAP, I know READ_TEXT helps decode it but it is in SAP environment.
My CLUSTD is in ...
0
votes
1
answer
334
views
NET 6 Blazor WASM Working With SAP Integration Problem
I'm trying to integrate my blazor wasm app to sap. But when i call below code the IIS pool is stopping. But when i run project on my visual studio it's working successfully. I think IIS can't inject ...
- 137
0
votes
0
answers
218
views
SYSTEM_FAILURE when updating PO through excel VBA
I am trying to update the date and quantity for a Purchase Order in SAP ERP (ME22N). The first line in the excel sheet gets updated, however, it does not work for the lines after that.
I get the error ...
1
vote
1
answer
3k
views
Is it possible to return qRFC (SMQ2 transaction) errors to the caller?
In my landscape, the ERP system is creating deliveries in EWM via qRFC. The setup is standard and works via a distribution model in the ERP BD64 transaction. A BAPI is called that creates a delivery ...
- 1,059
2
votes
3
answers
441
views
.Net SAP Transaction restart from client
I'm using .Net NCo 3.0 library and I tried one example of tRFC wherein I see the transaction ID is created and associated with the RFC function and then invoked, after a successful transaction, the ...
- 467
0
votes
1
answer
2k
views
Call method always returns false, how to troubleshoot? (SAP RFC Excel VBA)
I've downloaded SAP GUI for Windows 7.70 (latest version with 64bits connectors) and created an RFC function called Z_GF_STOCK with a material string import parameter (ARTICULO) and labst export ...
- 253
0
votes
1
answer
357
views
error "object invoked has disconnected" in 7.70 64 bits (was working in 32 bits)
I have VBA in Excel 32 bits that can upload Sales Orders into SAP ERP software. In order to get the code to run on 64 bits Excel, I uninstalled current SAP GUI and installed SAP GUI 7.70. I now get ...
- 1
1
vote
1
answer
1k
views
Passing multiple values to ABAP TEXT FILTER with VBA
I've created a macro to read data from SAP Table using the BAPI BBP_RFC_READ_TABLE.
It successfully compiles and runs for a single parameter if I use the FILTER VIEW:
objOptTab(objOptTab.RowCount, &...
- 431
0
votes
0
answers
147
views
SapNwRfc BAPI COMPANY LIST
I am working with SapNwRfc (https://github.com/huysentruitw/SapNwRfc) I was able to use the .net framework and to connect with my sap production server.
However I have some issues on get everything ...
- 106
3
votes
1
answer
814
views
Call BAPI RFCs transactionally via JCo
First of all I'm not a SAP/BAPI developer.
We have a java application that is calling some BAPIs over RFCs using JCo library.
The question is whether there is any way to call several of those in a ...
- 1,643
0
votes
1
answer
1k
views
SAP table structure to proceed passing by table by XML
I've created Logic App in Azure which has some json data inside. I'd like to connect to SAP system and pass parameters to an ABAP Function Module via RFC.
RFC input parameters in XML:
<?xml version=...
- 65
1
vote
1
answer
807
views
SAP integration with Azure Logic Apps - Cache / Metadata problem?
I'm trying to automatize process using Logic Apps -> On-premises data gateway -> SAP system.
I think I have a problem with metadata or cache.
Scenario:
I stopped developing solution on Wednesday ...
- 65