Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

flat file format

Former Member
0 Kudos

hi gurus......

Basically there r 3 types of flat file format

ASC

DAT

BIN

am I rite???

what is the difference between these formats?

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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.

D

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

user settings.

T

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

1 REPLY 1

Former Member
0 Kudos

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.

D

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

user settings.

T

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