topic Required Logic in Application Development and Automation Discussions

Required Logic

Former Member — Thu, 18 Feb 2010 07:39:37 GMT

My flate file structure is

020116-FEB-201003:00:00

0679771000600 name tests 1NarenSTD2010011520100515201001152010010679771000600

000000000013

this i need to distinguish as first line as header, from Second line onwords Detaild, this detailed can have any number of lines and the last one is Trailer.

for this i have declared three internal tables for header detailed and trailer,

header internal table consists of '0201' this is constant for all the files and Date and time.

detailed with some fields

trailer will have only one field as count.

As header is having the constant value i can distinguish as header file based on that value '0201' but for the detailed and trailer how to distinguish.

for this Please Suggest the Solution and Logic how about to do this scenario.

Regards,

Pavan

Re: Required Logic

Former Member — Thu, 18 Feb 2010 07:52:21 GMT

Hi Kumar,

If you are using a standard FM to load the file into an internal table, you can use the DESCRIBE statement to count the total number of lines. Then, read the last line and pass it to your trailer table.

All remaining lines, between line 1 and the last line, will go in your detailed table.

Make sure you delete any null lines at the end of the table before the DESCRIBE statement.

Hope this helps! Do revert if you need anything else.

Cheers,

Shailesh.

Always provide feedback for helpful answers

Re: Required Logic

Former Member — Thu, 18 Feb 2010 09:08:27 GMT

Hi,

You can try this, if the file is of fixed length format i.e. the length of the data will never change.

For Header:

You are saying the the header will start with "020", so you are able to distinguish.

It may fail, if the detial record starts with "020".

So, What you can do is Since the Header Has 0201 (4) + Date of length(11) + Time(8) Total length is 23.

While reading the file if the Length of record is 23, then that record can be considered as header.

For Footer:

you can do it in 2 ways

1.Compare the length = 12, if yes then it is Trailer.

2.if you think that the trailer will have number always, then you can very well compare if the record has any characters, if no then obviously that will be Trailer.

For Details.

If the above 2 doesnt satisfy, then that record will be detailed record.

Overall Logic will be

Loop through the File.

if record length = 23.

Append it to the Header Table.

elseif not record CA sy-abcde.

Append it to the Trailer Table

else.

Append it to the Detail table.

endif.

endloop.

Thanks & Regards,

Vamsi.