topic Re: transfer application server data to a data base table in Application Development and Automation Discussions

transfer application server data to a data base table

Former Member — Wed, 23 Sep 2009 11:40:25 GMT

hai all,

how to transfer application server data to a data base table, i am using this code

iF V_FILE = 'X'.

OPEN DATASET V_FILE2 FOR INPUT IN TEXT MODE ENCODING DEFAULT.

IF SY-SUBRC = 0.

DO.

READ DATASET V_FILE2 INTO DATA1.

SPLIT DATA1 AT C_COMMA INTO V_MATNR V_MTART V_WERKS V_LGORT.

IF SY-SUBRC = 0.

APPEND IT_MARA.

ELSE.

EXIT.

ENDIF.

ENDDO.

ENDIF.

CLOSE DATASET V_FILE2.

but the data is not splitting from data1 to the defined variables.

Re: transfer application server data to a data base table

Sandra_Rossi — Wed, 23 Sep 2009 12:43:07 GMT

by debug, check that data1 contains commas

Re: transfer application server data to a data base table

former_member209217 — Wed, 23 Sep 2009 13:02:46 GMT

Hi Kpsgoutam,

Check whether the data present in file in application server is comma delimited .It might be a tab separated one.check it in debugging mode whether its getting splitted or not

regards,

Lakshman.

Re: transfer application server data to a data base table

Former Member — Wed, 23 Sep 2009 14:04:37 GMT

check whats the separator in al11 or in debug mode..

it can be #, * , ',', or any other thing...

Re: transfer application server data to a data base table

ThomasZloch — Wed, 23 Sep 2009 14:10:29 GMT

Where is your code to move V_MATNR etc. to IT_MARA?

Also, SPLIT could change SY-SUBRC to 4, so it might exit your loop even before the file was processed completely.

Thomas