BDC

[Former Member]

Please tell me how to upload data using bdc for one particular table and hr table fields.

No transaction codes are given just table name and fields.

[RichHeilman]

In order to use BDC, you must have know the transaction code. You do your recording in transaction SHDB. In this transaction you can have the code generated for you. You must know the tcode that will update your table.

Regard,

Rich Heilman

[Former Member]

Hi Karthik,

I don't understand why you need a BDC to populate a table. You can use INSERT SQL statement directly to populate the table, if you want to do some validations, you can do it before inserting. But remember populating standard table directly is not suggestible.

Cheers,

Satya

[Former Member]

Hi Karthik,

There could be multiple approaches to this based on your exact requirement.

1. If your table is a standard sap table where you need to upload data, you need to find out the transaction code used to upload data that table so that you can use BDC. One way of doing this is to get the development class of the table and then in SE80 transaction use the same development class to search for the transaction code involved to load data. You can also search for standard SAP function module/program/BAPI in SE80 which is used to load data to that table. In that case no BDC is required.

2. If your table is a custom table, then use direct insert/update queries to upload/modify the data.

3. Another method of using BDC to create entries in custom table is to use transaction SM30 while recording through SHDB. You can specify the table name and load data exactly the same way you can load through SM30. Although this is not a recommended method as you can achieve the same thing through SM30. But since u insist on BDC, this is one way.

Hope it helps.

Cheers

Sharmistha