Hana Smart Data Integration - ABAP Adapter

[Arch]

Hello Everyone,

Am using ABAP Adapter in HANA web IDE (in SDI) - Created remote source to on-premise system.

While creating Virtual procedure from BAPI : BAPI_PO_CREATE1 or few other BAPI's , am getting an SQL error as shown below.

"(Catalog) (dberror) 257 - sql syntax error: incorrect syntax near "LIMIT": line 1 col 33704 (at pos 33705)"

I tried with other BAPI - BAPI_PO_GET_LIST, virtual procedure is being created.

Can't we create Virtual procedure's for BAPI's which right back to Remote system ?

Does ABAP Adapter support bidirectional ? If yes, kindly guide me how to write back data using BAPI .

Thanks,

Archana

[jeffrey_kresse]

ABAPAdapter does not support writeback. See page 19 in the PAM: https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/TIP/PAM_HANA_SDI_2_0.pdf

However I think calling a BAPI that creates something would not technically be considered writeback, there may be some other issue happening here. Can you provide specific steps to reproduce the error?

[Arch]

Hi Jeff,

Thanks for your quick response.

I am using licensed version v 1.120.35 .

1. created a remote source -> ABP.

From the list of BAPI Procedures - select "BAPI_PO_CREATE1" or "BAPI_PO_CREATE".

Right click on BAPI to create a "New Virtual procedure".

Entered the Procedure name and schema name and press enter. It just gives me an error .

"4:27:37 PM (Catalog) (dberror) 257 - sql syntax error: incorrect syntax near "LIMIT": line 1 col 33688 (at pos 33689)"

_ I think this is related to SQL limitations on using few keywords . (in this case BAPI has Table parameter POLIMIT-LIMIT - which must be the cause of error). Not sure. Kindly help

- Found something similar but not exactly the same.

"Database error occurs when running a combined query in a Web Intelligence document based on hana universe having “END_SQL = LIMIT XX” parameter set"

https://launchpad.support.sap.com/#/notes/2464974

Appreciate your inputs!

Thanks,

Archana

[former_member608605]

HI Archana,

Please share the details if you were able to resolve the above issue and write back to On premise system using virtual procedures.

Thanks,
Shubham