BOM upload program
I have been given a scenario where Prior to project Go-Live all Bill of Material is to be uploaded into new Organization structures respectively.
The program will have functionality to accept an external file in MS EXCEL format for BOM data to be uploaded. The BOM data received from MS EXCEL file will be stored into Internal Tables for further process.
After data gathering into Internal Tables, system will run pre-recorded BDC Or BAPI to upload BOM in new Org Structures.
On successful completion or error, program should provide the respective message in terms of Completion Log.
I have never done any conversion program earlier and i am not able to figure out how to proceed.
Kindly help me.