Open Data Set Issue

[Former Member]

Hello

How can we set the length of the record size in the open data set. I have like 40 fields of internal table and I need to upload it to Appl server. I could do it but all the fields dont appear. How can set the record size ? Can anyone explain..Thanks

[Former Member]

Hi,

if you declared character limitation is some 65,000..

declare with string...

you can send whole data without limitations

[Former Member]

I did send the whole data but I cant able to view it when i had a breakpoint in the program.Its only taking upto certain limit and breaking it up..Please help ..

[Former Member]

Hi

while debuggin you can't see whole data..

go to cg3y transaction and download the file,, check wether you sent whole data or not

[Former Member]

If you go through al11 and see the data u can able to see only a part of data...

It happens that you see only a part of the line in AL11, but it does have the total data.

You can download the file to presentation server using the Transaction: cg3y

[Former Member]

Vicky,

u can check with NIHI's reply and alternate way...u can down load file contents..

using open data set , and transfer to itab..

This way also u can confirm

Pra

[Former Member]

I had uploaded and downloaded the file using CG3Y..It still doesnt show all the fields..

[Former Member]

HI Vicky,

doesn't show all fileds: scence in the file?

then either you are not passing the whole data or you are not selecting the whole data to the sending internal table

change your declaration to the string rather than character....

follow the code below:

DATA: filepath TYPE string.

OPEN DATASET filepath FOR OUTPUT IN BINARY MODE.

LOOP AT l_xml_table INTO l_xml_rec.

TRANSFER your itab TO filepath.

ENDLOOP.

CLOSE DATASET filepath.

[Former Member]

vicky,

Y dont u give a try to download contents from same file...using ur program..

Pra

[Former Member]

OPEN DATASET filepath FOR OUTPUT IN BINARY MODE.(or text mode)

LOOP AT l_xml_table(<b>your itab)</b> INTO l_xml_rec(<b>work area).</b>

TRANSFER l_xml_rec(<b>work area)</b> TO filepath.

ENDLOOP.

CLOSE DATASET filepath.

[Former Member]

Hi Vicky,

U can have break-point while uploading itab to file. There u can see all the contents what u r uploading.

And once it is successfully done, U can't see the whole file contents in AL11.

But the fields will b there...

try to download file info...in other program to an itab...u will get all the contents

Reward if it is useful

Pra