topic Re: Big Endian Format in Application Development and Automation Discussions

Big Endian Format

Former Member — Mon, 23 Nov 2009 08:56:36 GMT

Hi,

I have a requirement where i have to download the contents of the standard table(kna1) to the application server.

OPEN DATASET p_file FOR OUTPUT IN legacy TEXT MODE big endian.

But i am getting error.

Could anyone please help me.

Thanks & Regards

Re: Big Endian Format

former_member206377 — Mon, 23 Nov 2009 09:06:36 GMT

Hi Divya,

Can you mention the error please!

Re: Big Endian Format

Former Member — Mon, 23 Nov 2009 09:09:46 GMT

Hi,

I am getting the following error

Runtime Errors DATASET_NOT_OPEN

Short text

File "/TMP/KNA1_DATA1.TXT" is not open.

I feels its because the data volue is huge because its a standard table.

Thanks

Re: Big Endian Format

kesavadas_thekkillath — Mon, 23 Nov 2009 09:16:41 GMT

goto su53 and check the authorization,

check whether the path exists.

check the sy-subrc value after open dataset statement

try "
TMP\KNA1_DATA1.TXT"

Re: Big Endian Format

Former Member — Mon, 23 Nov 2009 09:21:11 GMT

Hi,

I have authorization , i checked in SU53.

I amgetting bthe file open error because the internal table data is huge.

Could you please suggest for that?

Thanks

Re: Big Endian Format

former_member206377 — Mon, 23 Nov 2009 09:22:20 GMT

Have you specified the right path ?

For problem with huge data refer this link

Re: Big Endian Format

Former Member — Mon, 23 Nov 2009 09:42:54 GMT

Hi,

Thanks for the link!

Bit its not specified in the link for huge volume of records.

Could you please help me on that.

Thanks

Re: Big Endian Format

kesavadas_thekkillath — Mon, 23 Nov 2009 09:51:07 GMT

if its of huge data

then spli the data to another data and use it.

Re: Big Endian Format

former_member206377 — Mon, 23 Nov 2009 10:07:35 GMT

Hi Divya,

check the reply by Vedavathy Kotak.. in the link provided. She mentions that the code she has specified works fine for any size of the file.

Re: Big Endian Format

former_member206377 — Mon, 23 Nov 2009 11:02:23 GMT

Hi Divya,

Is your issue resolved?

Re: Big Endian Format

Former Member — Mon, 23 Nov 2009 11:11:27 GMT

Hi Divya,

The error is at the OPEN DATASET statement, right? This is the first statement for openning a file and at this point you have not even started writing to the file, so this error has nothing to do with internal table size or file size. It is also clear from the error you have received. Check whether you have specified the path correct.

Why are you using LEGACY TEXT MODE BIG ENDIAN? any specific reason?

Best Regards,

Loveline thomas.

Re: Big Endian Format

Former Member — Mon, 23 Nov 2009 11:14:00 GMT

Hi loveline,

Thnaks .

Yes i have an internal table which has all the contents of kna1 table.


IF p_kna1 = 'X'.
    SELECT *  INTO TABLE i_kna1 FROM kna1.
   OPEN DATASET p_k1 FOR OUTPUT In TEXT MODE ENCODING DEFAULT.
if sy-subrc eq 0.
      LOOP AT i_kna1.
         CLEAR w_rec.
             DO.
      ASSIGN COMPONENT sy-index OF STRUCTURE i_kna1 to <fs>.
       if sy-subrc <> 0.
          EXIT.
        ENDIF.
        DESCRIBE FIELD <fs> TYPE l_type.
        CONCATENATE w_rec <fs> INTO w_rec
         SEPARATED BY '  '.
        ENDDO.
        TRANSFER w_rec to p_k1.
    ENDLOOP.
 endif.

This is the code i have given.

Code Formatted by: Alvaro Tejada Galindo on Jan 13, 2010 5:07 PM

Re: Big Endian Format

Former Member — Mon, 23 Nov 2009 11:22:30 GMT

Is SY-SUBRC EQ 0, after the OPEN DATASET statement?

If not, it means the file could not be open. Are you trying to write the file in TMP folder? Usually the administrator fix a size for this folder, if that size has reached you will not be able create any new file in this folder. So check with your system administrator about the folder size.

Best Regards,

Loveline Thomas.

Re: Big Endian Format

Former Member — Mon, 23 Nov 2009 11:39:04 GMT

Thanks .

yes my sy-subrc is 0 after open dataset statement.

In al11 i could see the file but when i clock on it , it says "Unable to display this file".

Any suggestions please.

Re: Big Endian Format

Former Member — Wed, 13 Jan 2010 07:12:17 GMT

answered

Re: Big Endian Format

kesavadas_thekkillath — Thu, 14 Jan 2010 17:49:30 GMT

Hi Divya,

What was the solution ?