regarding bdc

[Former Member]

using BDC we fetch information from flat file and place it into sap.

what do u mean by flat file? From what kind of files(like .txt,.doc...) we can fetch information?

[Former Member]

Hi

Flat file can be any type like Txt or Excel file.

First need to extract data from legacy system into flat file. Then upload that data into SAP Application server. Then do the BDC for that. That will be the real world scenorio..

Reward me if its useful.

Regards

Ravi

[Former Member]

hi

u can fetch information fron text files .doc files and excel files as well.

just refer to the link below

http://www.sapmaterial.com/?gclid=CN322K28t4sCFQ-WbgodSGbK2g

hope it may help u.

regards

ravish

plz dont forget to reward points if helpful

[Former Member]

Hi,

Flat file may be TXT file or XLS file, if those are in local systems. But mostly we will get the data from the sequential data sources it means data will be stored in Application server. You can use AL11 transaction to see the sequential files.

If you need more information let me know.

To get the data from the local files, we need to use standard Fms like UPLOAD, GUI_UPLOAD...etc...

to get the data from the sequential files we need to ...

Dataset can be opened for four tasks.

input - with this data can be Read only ,

output - file contains are cleard and new data wrtten,

appending- With this contains are appended to exsitng contains,

update - With this containsare updated in files anywhere.

I will tell you more about INPUT and OUTPUT:

Input: The addition FOR INPUT opens the file for reading. By default, the file pointer is set at the start of the file. If the file specified does not exist, sy-subrc is set to 8.

Means, file will be open for read only purpose.

Output : The addition FOR OUPUT opens the file for writing. If the specified file already exists, its content is deleted. If the file specified does not exist, it is created. Read access is also permitted.

Means file will open for writing purpose and old contains will be deleted.

Regards,

• Dj

reward for all useful answers

[Former Member]

hi,

Flat file : nothing but any file with the data to upload which presents in presentation server

we can upod data from following types of files only using gui_upload.

file types :

'ASC' :

ASCII format. The table is transferred as text. The conversion exits are carried out. The output format additionally depends on the parameters CODEPAGE, TRUNC_TRAILING_BLANKS, and TRUNC_TRAILING_BLANKS_EOL.

'IBM' :

ASCII format with IBM codepage conversion (DOS). This format corresponds to the 'ASC' format when using target codepage 1103. This codepage is often used for data exchange by disc.

'DAT' :

Column-by-column transfer. With this format, the data is transferred as with ASC text. However, no conversion exists are carried out and the columns are separated by tab characters. This format creates files that can be uploaded again with gui_upload or ws_upload.

'DBF' :

The data is downloaded in dBase format. Because in this format the file types of the individual columns are included, import problems, for example, into Microsoft Excel can be avoided, especially when interpreting numeric values.

'WK1' :

The data is downloaded in Lotus 1-2-3 format.

'BIN' :

Binary format. The data is transferred in binary format. There is no formatting and no codepage conversion. The data is interpreted row by row and not formatted in columns. Specify the length of the data in parameter BIN_FILESIZE. The table should consist of a column of type X, because especially in Unicode systems the conversion of structured data into binary data leads to errors.