topic Re: Open Data Set Issue in Application Development and Automation Discussions

Open Data Set Issue

Former Member — Thu, 13 Dec 2007 18:44:04 GMT

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

Re: Open Data Set Issue

Former Member — Thu, 13 Dec 2007 18:47:33 GMT

Hi,

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

declare with string...

you can send whole data without limitations

Re: Open Data Set Issue

Former Member — Thu, 13 Dec 2007 18:50:02 GMT

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

Re: Open Data Set Issue

Former Member — Thu, 13 Dec 2007 18:59:09 GMT

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 ..

Re: Open Data Set Issue

Former Member — Thu, 13 Dec 2007 19:02:08 GMT

while debuggin you can't see whole data..

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

Re: Open Data Set Issue

Former Member — Thu, 13 Dec 2007 19:06:23 GMT

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

Re: Open Data Set Issue

Former Member — Thu, 13 Dec 2007 19:06:56 GMT

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

Re: Open Data Set Issue

Former Member — Thu, 13 Dec 2007 19:22:44 GMT

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

Re: Open Data Set Issue

Former Member — Thu, 13 Dec 2007 19:33:07 GMT

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.

Re: Open Data Set Issue

Former Member — Thu, 13 Dec 2007 19:33:12 GMT

vicky,

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

Pra

Re: Open Data Set Issue

Former Member — Thu, 13 Dec 2007 19:35:59 GMT

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

LOOP AT l_xml_table(your itab) INTO l_xml_rec(work area).

TRANSFER l_xml_rec(work area) TO filepath.

ENDLOOP.

CLOSE DATASET filepath.