I would like to retrieve records from SAP table VBRP. With the business requirement I need to apply a filter like a sub query as per the attached image.
Is it working fine when you are running the query with filter conditions as values? Are you getting the error only when sub query is added?
I do not have a personal SAP environment for a quick verification. So I would recommend to raise a Support case in parallel as SAP environments may not be readily available for all community members to cross check the issue.
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
I have found ELT components are available for SAP components, I try to use it, so that I can join the 2 tables at source and get only the valid records out of SAP.
in the tELTSAPMap component, its asking for some FTP details, if I leave them null and execute the job, its failing with the below error.
I checked the documentation, It is not clear why FTP is required for SAP ELT
On ELT call a file result will be created locally to SAP ERP filesystem. And in the same time your Talend job will download the file via FTP. Indeed the request is executed locally to SAP server (where clause, join and so on) for performance consideration.
On my side I don't have any ftp server on my SAP ERP machine and I wonder if it is possible to act without ftp server, just generate the file on SAP Server. Presently I get connection error. If anyone gets a workaround please tell me what.
