We normally “read” the data from SAP table throguh ABAP programmes. How can do the reverse…i.e. loading the data into Standard SAP tables like VBAP,VBRP,LIPS…etc through Data Intgrator 11.7
To be precise,I have an Excel file which needs to be inserted into SAP table.
learndi_2010 (BOB member since 2010-02-15)
You don’t load it into the SAP tables as you would endanger the integrity of the SAP system, e.g. an order does change the material reservations, has impact to cost bookings etc.
You use BAPIs for that.
https://wiki.sdn.sap.com/wiki/display/BOBJ/Calling+RFCs-BAPIs
Werner Daehn 
(BOB member since 2004-12-17)
Thanks for your prompt response.
ABAP programme normally executes on SAP Application server. Is there any way we can execute on DI server itself ? Similar to running/calling an oracle stored procedure through DI script.
learndi_2010 (BOB member since 2010-02-15)
Stored procedure = BAPI in SAP.
Werner Daehn (BOB member since 2004-12-17)
I understand that.my question is can we run BAPI from DI server itself…
similar to the script for calling oracel procedure like…
SQL(‘Target datastore’, ‘BEGIN Ora procedure name; END;’) ;
learndi_2010 (BOB member since 2010-02-15)
First of all, you would not run stored procedures via the sql() function, you would call it directly (import into the datastore).
Second, as it should deal with data, the stored procedure would be part of a dataflow, inside a query. But not as a mapping, a new_function_call.
And that is identical to the BAPI example, isn’t it?
To answer the question the other way around, no, a BAPI cannot be called from a sql() function and not from a script whereas both is possible with database stored procedures. But not applicable in your use case anyhow.
Werner Daehn (BOB member since 2004-12-17)
Thanks Werner.
learndi_2010 (BOB member since 2010-02-15)