topic Re: BDC DATASET syntax in Application Development and Automation Discussions

BDC DATASET syntax

Former Member — Thu, 18 Oct 2007 16:21:27 GMT

Hi friends,

I have 5 structures in a flat file. The data from flat file needs to move into an internal table through work area. When i am using open dataset in my code the total data is not moving from flat file to work area.Only structure 1 is getting moved into internal table.

Here for every new structure in the flat file the cursor moves to the new line feed i.e. if structure 1 data stop at the middle of the line.The next structure of the data in the flat file starts in the new line.Can any one tell me how we should write the open data set .

This program is just to read the file from application server to the internal table .

Please help me .Its very Urgent.

Thanks

Satish Raju

Re: BDC DATASET syntax

Former Member — Thu, 18 Oct 2007 16:24:38 GMT

Do you have any flag in the file which says the associated record belongs to which structure?

You can first move all data to a string and based upon the flag value you can move this string to respective file structures and likewise populate respective internal tables.

ashish

Re: BDC DATASET syntax

Former Member — Thu, 18 Oct 2007 16:33:04 GMT

I hope your flow is as follows. Also, your file should be a text file, otherwise is you are opening it in binary mode, you will have all of it in one line.

OPEN DATASET dsn IN TEXT MODE....

DO.

READ DATASET dsn INTO something....

IF sy-subrc <> 0.

EXIT.

ENDIF.

move 'something' to itab.

ENDDO.

Re: BDC DATASET syntax

Former Member — Fri, 19 Oct 2007 06:06:37 GMT

Hi Ashish,

As you said is ok.But my criteria is different . When I am reading dataset i am not getting total data from flat file to Work area or internal table.Only the first structure data is moving from flat file to internal table. from the second structure of flat file is not moving from flat file to work area. This is because the new structure data always begins with a new line. So generally when we move data from flat file to work area we only get if the data is continuous as per structure but here the condition is it differs in a new line when the structure changes in the flat file. Can you please help me in this issue .

Thanks,,

Satish Raju

Re: BDC DATASET syntax

andreas_mann3 — Fri, 19 Oct 2007 06:20:34 GMT

i don't get your problem:

pls post an example

Re: BDC DATASET syntax

Former Member — Sat, 20 Oct 2007 13:44:56 GMT

i have got the problem solved.

Re: BDC DATASET syntax

Former Member — Thu, 21 Jul 2011 07:51:00 GMT

Resolved myself