topic open dataset in Application Development and Automation Discussions

open dataset

Former Member — Wed, 07 Mar 2007 14:15:19 GMT

Hi all,

My code like this when i try to upload .txt .

txt file will be poplulating in Wa but not moving into itab.

OPEN DATASET P_FILE FOR INPUT IN TEXT MODE ENCODING UTF-8.

IF SY-SUBRC = 0.

DO.

READ DATASET P_FILE INTO WA_ITAB.

IF SY-SUBRC = 0.

SPLIT WA_ITAB AT '#' INTO ITAB-WERKS

ITAB-MATNR

ITAB-EKGRP

ITAB-LIFNR

ITAB-EVERS

L_MENGE.

ITAB-MENGE = L_MENGE.

APPEND ITAB.

CLEAR ITAB.

ELSE.

EXIT.

ENDIF.

ENDDO.

ENDIF.

CLOSE DATASET P_FILE.

Re: open dataset

Former Member — Wed, 07 Mar 2007 14:18:47 GMT

Hello,

Change the code like this:


OPEN DATASET P_FILE FOR OUTPUT  " CHECK HERE
 IN TEXT MODE ENCODING UTF-8.
IF SY-SUBRC = 0.
DO.
READ DATASET P_FILE INTO WA_ITAB.
IF SY-SUBRC = 0.
SPLIT WA_ITAB AT '#' INTO ITAB-WERKS
ITAB-MATNR
ITAB-EKGRP
ITAB-LIFNR
ITAB-EVERS
L_MENGE.
ITAB-MENGE = L_MENGE.
APPEND ITAB.
CLEAR ITAB.
ELSE.
EXIT.
ENDIF.
ENDDO.
ENDIF.
CLOSE DATASET P_FILE.

Vasanth

Re: open dataset

Former Member — Wed, 07 Mar 2007 14:18:54 GMT

I presume you have debugged it and nothing is being passed into itab from the split statement.

Re: open dataset

Former Member — Wed, 07 Mar 2007 14:25:32 GMT

yes, i debugged it and nothing passing to itab.

Re: open dataset

Former Member — Wed, 07 Mar 2007 14:29:11 GMT

Hello,

I think the '#' symbol u r seeing here is not actually hash.

Please check the delimiter of the file. The split command can't able to identiy the '#'symbel.

Vasanth

Re: open dataset

Former Member — Wed, 07 Mar 2007 14:29:42 GMT

use cl_abap_char_utilities=>HORIZONTAL_TAB instead of # in split

split wa at cl_abap_char_utilities=>HORIZONTAL_TAB into....

Re: open dataset

Former Member — Wed, 07 Mar 2007 14:30:47 GMT

Hi Devender,

May be '#' represents Horizontal tab, so do as follows.

OPEN DATASET P_FILE FOR INPUT IN TEXT MODE ENCODING UTF-8.

IF SY-SUBRC = 0.

DO.

READ DATASET P_FILE INTO WA_ITAB.

IF SY-SUBRC = 0.

SPLIT WA_ITAB AT CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB INTO ITAB-WERKS

ITAB-MATNR

ITAB-EKGRP

ITAB-LIFNR

ITAB-EVERS

L_MENGE.

ITAB-MENGE = L_MENGE.

APPEND ITAB.

CLEAR ITAB.

ELSE.

EXIT.

ENDIF.

ENDDO.

ENDIF.

CLOSE DATASET P_FILE.

Thanks,

Vinay

Re: open dataset

Former Member — Wed, 07 Mar 2007 14:32:06 GMT

Hi,

split the value into work area and then append it into internal table:

SPLIT WA_ITAB AT '#' INTO WA_ITAB-WERKS

append WA_ITAB to ITAB.

Regards,

Chanadn

Re: open dataset

Former Member — Wed, 07 Mar 2007 14:34:41 GMT

THANKS VINAY. YOU ARE STAR.

WHAT IS UR EMAIL ADDRESS

Re: open dataset

Former Member — Wed, 07 Mar 2007 14:46:27 GMT

Hi Devender,

remeber ther is no splitting # .For a tab delimited file you see # symbol.

If you want to split

use the following syntax

for >= 4.6 c version

constants: con_tab type x value '09'

split xyz_file at con_tab into ---

for versions <= 4.7

constants: con_tab type c value cl_abap_char_utilities=>HORIZONTAL_TAB.

split xyz_file at con_tab into ---

hope you are clear.

Thanks

venki

Re: open dataset

Former Member — Wed, 07 Mar 2007 16:59:58 GMT

Hi Devender,

Thanks for your words and You can find my email address on business card.

Thanks,

Vinay