flat file format

Former Member — Fri, 18 Jul 2008 01:09:19 GMT

hi gurus......

Basically there r 3 types of flat file format

ASC

DAT

BIN

am I rite???

what is the difference between these formats?

Re: flat file format

Former Member — Fri, 18 Jul 2008 03:13:54 GMT

Hi,

This is from the documentation available in GUI_UPLOAD func.module:

'BIN'.

The system reads a binary representation of the internal table from the

file. The data is neither converted nor interpreted in this case.

Usually, reasonable results are obtained only if the internal table

consists of a single column of type 'X'.

'DAT'

The components of the internal table are filled from the file. If the

table contains several columns, the entries in the file must be

separated by tabs. No conversion exits are performed. [ eg: .TXT with tab delimited ]

The following applies for the different data types:

I or N or P or F

The numbers must be formatted according to the decimal representation

defined in the user settings.

The date must be formatted according to the date format defined in the

user settings.

The time must be formatted as hh:mm:ss.

'ASC'.

The components of the internal table are filled from the file. Only

data types with fixed length are allowed. The data must be contained

in the file in its full length. [ eg: Like .TXT or .CSV files ]

Regards,

Subramanian