Upload data in internal table though BDC

[Former Member]

How to upload data from a db table to internal table through BDC.

Moderator Message: Not enough research before posting

Message was edited by: Kesavadas Thekkillath

[Former Member]

hello,

Your question is not correct. BDC is used to post data in SAP which in turn goes to SAP tables or DB. If you need to get data from DB then you use statements like SELECT etc. This will read data from DB and put in the internal tables you define.

best regards

[Former Member]

Hi,

    your question is not correct......mainly upload data from flat file to sap. in this situation, you have to use GUI_UPLOAD fm......

Thanks

Sabyasachi

[former_member196213]

nidhi gaba wrote:
How to upload data from a db table to internal table through BDC.

I think you wanted to say

How to upload data from a db table to internal table for BDC.

BDC is a process or you can call it feature of ABAP where in you upload data to screen automatically hence to DB, rather than going and putting the data manually. So this could have been done directly updating DB, then Why BDC ?? Reason is with BDC it calls the actual screen and performs all the validations in place hence it avoids chances or errornous data in DB.

If I have to upload 20 peoples personal information then either I could put it using direct update/insert into DB, or using BDC(correct way), as it validates all values.

Now I may have the data for these 20 people in some flat file(text excel etc) or in any DB table. All these data I will require in an internal table to perform BDC.

If its a flat file I will read data into my internal table from the file.

If its in a DB table i will select values from DB table using select query. Then will put it in an internal table.

When I have the data in place(internal table) then I will call BDC.

I hope it clears your doubt or question

HAPPY ABAPing

Vishal