Skip to Content
0
Former Member
Nov 13, 2007 at 07:18 PM

Update SQL table by ABAP CODE

1135 Views

Hi,

We are ECC 6.0 and SAP is on Windows.

I want to update a SQl table from SAP.

I am trying this way..Can anybody help me with further steps?

I created Connection using DBCo tcode

and that created antries in DBCON table.

After this I am trying to code like this...

report x.

tables: marc.

data: begin of itab occurs 0,

matnr like marc-matnr,

werks like marc-werks,

end of itab.

select matnr werks from marc

into corresponding fields of table itab

where werks = '1000'.

EXEC SQL.

CONNECT TO 'TEST_SAP_MATERIAL' AS 'V'

ENDEXEC.

EXEC SQL.

SET CONNECTION 'V'

ENDEXEC.

loop at itab.

EXEC SQL.

WHAT SHOULD I CODE HERE???

MY SQL TABLE NAME IS TESTSQL and fields are MATNR & WERKS .

ENDEXEC.

endloop.

Regards

Praveen

null

Message was edited by:

PRAVEEN s