Can table entries be transportable if I insert entries through a BDC program(saved in $Tmp)
I need to create and maintain a table. The table entries are in an excel sheet. If I save that table in a transport request and maintain the table in SM30, the table entries also can be moved into production.
But There are many values in that table So I wanted to make entries through BDC or any function module.
- If I save that BDC program in a TR and if it is transported to production, will it search for the excel file in production system? Or else the entries of the table will be moved?
- If I save BDC program in local object and insert the data into the table(table created in a TR) will those table entries transported to production?
Please help me out how to make entries in that table.
1. First of all if you save your BDC program in TR & moved to production, it will definately ask you for flat file to upload data.
2. If you save your BDC program in local object directory then you can not move it to production without putting it in TR. If you upload data in Development environment then it won't reflect in production even if you transport table's TR in production. You have to upload data there separetely.
But here why are you using BDC program to upload data in single table.
Just use FM 'GUI_UPLOAD' to take file data in ITAB and user Insert statement to pull ITAB data into your Ztable.
Hope it will help you.