topic Re: open data set problem in Application Development and Automation Discussions

open data set problem

Former Member — Wed, 30 Sep 2009 13:36:07 GMT

Hi All,

What is the problem in following code? i am not able to open file

Data Declaration

DATA: L_FILENAME TYPE STRING value '/data/testdt.txt'.

DATA L_TEXT(50).

Opening the File

OPEN DATASET L_FILENAME FOR OUTPUT IN text mode

MESSAGE L_TEXT ENCODING DEFAULT.

Transferring Data

LOOP AT I_OUT INTO WA_OUT.

TRANSFER WA_OUT-KUNNR TO L_FILENAME.

ENDLOOP.

Closing the File

CLOSE DATASET L_FILENAME.

Thanks in Advance

Re: open data set problem

SuhaSaha — Wed, 30 Sep 2009 13:53:15 GMT

Hello,

Do you have authorisation to write to the folder?

Before OPEN DATASET check the auth. using the auth. object S_DATASET.

DATA: L_FILENAME TYPE STRING value '/data/testdt.txt',
L_REPID TYPE SY-REPID.

  L_REPID = SY-REPID.

DATA L_TEXT(50).

  AUTHORITY-CHECK OBJECT 'S_DATASET'
          ID 'PROGRAM' FIELD L_REPID
          ID 'ACTVT' FIELD '34' "-->Write Access
          ID 'FILENAME' FIELD L_FILENAME.                  "#EC *
  IF SY-SUBRC NE 0.
*    You have no authorization for file &
  ENDIF.

* Opening the File
OPEN DATASET L_FILENAME FOR OUTPUT IN text mode
MESSAGE L_TEXT ENCODING DEFAULT.

IF SY-SUBRC EQ 0. "-->Check SY-SUBRC = 0 after OPEN DATASET
* Transferring Data
LOOP AT I_OUT INTO WA_OUT.
TRANSFER WA_OUT-KUNNR TO L_FILENAME.
ENDLOOP.
* Closing the File
CLOSE DATASET L_FILENAME.
ELSE.
ENDIF.

Please check & revert.

BR,

Suhas

Re: open data set problem

Former Member — Wed, 30 Sep 2009 13:55:53 GMT

Please ignore my previous post. Looks like am drunk today

Re: open data set problem

SuhaSaha — Wed, 30 Sep 2009 13:57:09 GMT

That's why i dint p(o)int it out 😛

Re: open data set problem

Former Member — Wed, 30 Sep 2009 13:58:03 GMT

Hi,

i do it like this:

DATA: DATEI_OUT(30) TYPE C VALUE '/data/testdt.txt'.

OPEN DATASET DATEI_OUT

FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

Try here to check the SY-SUBRC, perhaps you get an OPEN-Error

LOOP AT IT_BEDNR_X INTO WA_BEDNR_X.

TRANSFER WA_BEDNR_X TO DATEI_OUT.

ENDLOOP.

CLOSE DATASET DATEI_BEDNR.

and it workd OK

Regards, Dieter

Re: open data set problem

Former Member — Wed, 30 Sep 2009 14:11:01 GMT

I check sy-subrc after authority check it is 0

Re: open data set problem

Former Member — Wed, 30 Sep 2009 14:14:24 GMT

Hi,

After the OPEN DATATSET statement, what is the value of L_TEXT?

Regards,

Nick

Re: open data set problem

SuhaSaha — Wed, 30 Sep 2009 14:15:45 GMT

And what exactly do you mean by "i am not able to open file"?

After OPEN DATASET stmt, please check for SY-SUBRC & revert back.

BR,

Suhas

Re: open data set problem

Former Member — Wed, 30 Sep 2009 14:16:44 GMT

After open data set sy-subrc value is 8

Re: open data set problem

Former Member — Wed, 30 Sep 2009 14:18:07 GMT

I just wrote this (resembles your program)

* Data Declaration
DATA: L_FILENAME TYPE STRING value '/tmp/testdt.txt'.
data: l_text(100).
DATA: begin of wa_out,
      kunnr like kna1-kunnr,
     end of wa_out.

* Opening the File
OPEN DATASET L_FILENAME FOR OUTPUT IN text mode
MESSAGE L_TEXT ENCODING DEFAULT.

* Transferring Data
wa_out-kunnr = '123456'.
TRANSFER WA_OUT-KUNNR TO L_FILENAME.

* Closing the File
CLOSE DATASET L_FILENAME.

and it works.

How do you check whether the file is being created? Do you read it back in? Or look at AL11?

Edited by: jon davies on Sep 30, 2009 4:19 PM

Re: open data set problem

Former Member — Wed, 30 Sep 2009 14:25:12 GMT

yed i checked in AL11

Re: open data set problem

Former Member — Wed, 30 Sep 2009 14:26:45 GMT

If I beg will you then paste your code.

I'm on my knees here.

Re: open data set problem

Former Member — Wed, 30 Sep 2009 14:36:22 GMT

Yest it should be yours