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

[Former Member]

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.

[faisalatsap]

Hi,

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

Kind Regards,

Faisal