Need Syntax for Insert records into My Sql (External data base) from ABAP

Former Member — Thu, 22 Jan 2009 18:04:06 GMT

Hi Everyone,

Need Syntax for Insert records into My Sql (External data base) from ABAP programe, Connection is establishing to My Sql and ABAP, problem is need correct syntax.

Test if connection 'FAST_DEV' has already been opened

IF sy-sysid = 'DEV'.

EXEC SQL.

SET CONNECTION :'FAST_DEV'

ENDEXEC.

IF sy-subrc NE 0.

EXEC SQL .

CONNECT TO :'FAST_DEV'

ENDEXEC.

ENDIF. " IF sy-sysid = 'DEV'.

endif.

We are able to insert record into my sql with hard code values like below*

EXEC SQL.

insert into xtd_fas_sap_export_partner_invoice_detail

(SUMMARY_INVOICE_NUMBER,

SUMMARY_INVOICE_DATE,

COMPANY_CODE,

FI_DOC_NUMBER,

REFERENCE_NUMBER,

FISCAL_YEAR,

CUSTOMER_NUMBER,

BILLING_DOC_NUMBER,

BILLING_DOC_LINE_ITEM,

POSTING_DATE,

BILLED_QTY,

NET_VALUE,

SAP_SALES_DOC_NUMBER,

SAP_SALES_DOC_LINE_NUMBER,

SERVICES_RENDERED_DATE,

REVENUE,

FREIGHT,

TAX,

TAX_CODE,

TRANS_ID,

TAX_PERCENT,

SHIPMENT_ID,

ORDER_ID,

ORDER_ID_LINE,

DATE_CREATED )

VALUES ('10000', '20081211', 'VGB1', '123456789', '12456',

'2009', '1000', '12345', '123', '20080120', '12', '150', '123', '001',

'20090101', '10', '01', '1', '01', '01', '11', '123', '001',

'001', '20090101');

*But we are unable to update multiple records using below syntax *

LOOP AT lt_finaldata2 INTO lwa_finaldata2.

TRY.

EXEC SQL.

insert into xtd_fas_sap_export_partner_invoice_detail

(SUMMARY_INVOICE_NUMBER,

SUMMARY_INVOICE_DATE,

COMPANY_CODE,

FI_DOC_NUMBER,

REFERENCE_NUMBER,

FISCAL_YEAR,

CUSTOMER_NUMBER,

BILLING_DOC_NUMBER,

BILLING_DOC_LINE_ITEM,

POSTING_DATE,

BILLED_QTY,

NET_VALUE,

SAP_SALES_DOC_NUMBER,

SAP_SALES_DOC_LINE_NUMBER,

SERVICES_RENDERED_DATE,

REVENUE,

FREIGHT,

TAX,

TAX_CODE,

TRANS_ID,

TAX_PERCENT,

SHIPMENT_ID,

ORDER_ID,

ORDER_ID_LINE,

DATE_CREATED )

from (LWA_FINALDATA2-SUMMARY_INVOICE_NUMBER,

LWA_FINALDATA2-SUMMARY_INVOICE_DATE,

LWA_FINALdata2-COMPANY_CODE,

LWA_FINALdata2-FI_DOC_NUMBER,

LWA_FINALdata2-REFERENCE_NUMBER,

LWA_FINALdata2-FISCAL_YEAR,

LWA_FINALdata2-CUSTOMER_NUMBER,

LWA_FINALdata2-BILLING_DOC_NUMBER,

LWA_FINALdata2-BILLING_DOC_LINE_ITEM,

LWA_FINALdata2-POSTING_DATE,

LWA_FINALdata2-BILLED_QTY,

LWA_FINALdata2-NET_VALUE,

LWA_FINALdata2-SAP_SALES_DOC_NUMBER,

LWA_FINALdata2-SAP_SALES_DOC_LINE_NUMBER,

LWA_FINALdata2-SERVICES_RENDERED_DATE,

LWA_FINALdata2-REVENUE,

LWA_FINALdata2-FREIGHT,

LWA_FINALdata2-TAX,

LWA_FINALdata2-TAX_CODE,

LWA_FINALdata2-TRANS_ID,

LWA_FINALdata2-TAX_PERCENT,

LWA_FINALdata2-SHIPMENT_ID,

LWA_FINALdata2-ORDER_ID,

LWA_FINALdata2-ORDER_ID_LINE,

LWA_FINALdata2-DATE_CREATED);

ENDEXEC.

CATCH cx_sy_native_sql_error INTO exc_ref.

error_text = exc_ref->get_text( ).

CLEAR:w_flag.

w_flag = 'X'.

MESSAGE error_text TYPE 'I'.

ENDTRY.

CLEAR:lwa_finaldata2.

ENDLOOP.

Re: Need Syntax for Insert records into My Sql (External data base) from ABAP

faisalatsap — Thu, 22 Jan 2009 18:35:46 GMT

Hi,

Following Thread may help you in this way, Please have a look,

Kind Regards,

Faisal

topic Need Syntax for Insert records into My Sql (External data base) from ABAP in Application Development and Automation Discussions

Need Syntax for Insert records into My Sql (External data base) from ABAP

Re: Need Syntax for Insert records into My Sql (External data base) from ABAP