07-18-2008 2:09 AM
hi gurus......
Basically there r 3 types of flat file format
ASC
DAT
BIN
am I rite???
what is the difference between these formats?
07-18-2008 4:13 AM
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
07-18-2008 4:13 AM
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