Application Development and Automation 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: 
Read only

BDC read from file!

Former Member
0 Likes
1,446

Dear friends,

I have one problem. When we are creating abap program by clicking on program button on recording screen it asks for the program name and there are 2 oprions..

1) read from file and

2)transfer from recording....second one is fine...but i am not able to use first option...how to use that and why it is used...

Thanks And Regards,

Bhavin Shah.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
792

Hi Bhavin,

The basic difference between read from file & transfer from recording is that...

In transfer from recording you have to give a session name or you have to choose call transaction. Here you have to give the data manually.

The Read from file will generate a dataset where who have to give that path of your flat file. When you execute it the data from the flat file will go into the necessary fields you have choosen before. You can process the job in the back ground which will be executed and a log file will be generated so that you can check whether it is updated correctly or not.

In general we use read from file option when we know that the data are correctly arranged for recording.

For eg. if you want to update the database with the file you have to know the datatype and length of each database-field so that you can specify the data in a file.

i.e Assume that you are having 2 fields in db-table of type char and length 10 & 20. Assume that you are going to give values for these fields as mala & kala.

In the file... you should specify like this...

mala      kala                xxx
123456789012345678901234567890
<---Ten--><-----Twenty------->

In a Real Time scenario you have a very large table with 50 to 100 fields to update with a very large data like 1000 - 10,000 records and if you are not sure with the flat file data. Then you should not go for the file option.

Hope this helps you.

Regards,

Maheswaran.B

Dear friends,

I have one problem. When we are creating abap program by clicking on program button on recording screen it asks for the program name and there are 2 oprions..

1) read from file and

2)transfer from recording....second one is fine...but i am not able to use first option...how to use that and why it is used...

Thanks And Regards,

Bhavin Shah.

2 REPLIES 2
Read only

Former Member
0 Likes
792

if you are specifying the file which is there in AL11 then it will be used...

i mean if you are accessing the file from application server then that will be used..

regards

vijay

Read only

Former Member
0 Likes
793

Hi Bhavin,

The basic difference between read from file & transfer from recording is that...

In transfer from recording you have to give a session name or you have to choose call transaction. Here you have to give the data manually.

The Read from file will generate a dataset where who have to give that path of your flat file. When you execute it the data from the flat file will go into the necessary fields you have choosen before. You can process the job in the back ground which will be executed and a log file will be generated so that you can check whether it is updated correctly or not.

In general we use read from file option when we know that the data are correctly arranged for recording.

For eg. if you want to update the database with the file you have to know the datatype and length of each database-field so that you can specify the data in a file.

i.e Assume that you are having 2 fields in db-table of type char and length 10 & 20. Assume that you are going to give values for these fields as mala & kala.

In the file... you should specify like this...

mala      kala                xxx
123456789012345678901234567890
<---Ten--><-----Twenty------->

In a Real Time scenario you have a very large table with 50 to 100 fields to update with a very large data like 1000 - 10,000 records and if you are not sure with the flat file data. Then you should not go for the file option.

Hope this helps you.

Regards,

Maheswaran.B