Skip to Content
0
Former Member
Oct 12, 2006 at 08:43 AM

Excel to SAP Urgent

27 Views

HI All,

The Scenario is like this

Dispatch clerk at is responsible for checking the weight of the truck that is carrying the goods and issue a delivery note and upload all that into the SAP system through an excel file.

Now this excel file is generated by the client's properitery application which is connected to the weigh bridge and is responsible for noting the weight as well as generate a serial number...and the name of the excel file is also generated automatically by that proprietary application which in this case is the Serial Number of the delivery that has been generated while checking the weight...

Now, while uploading that excel file the dispatch clerk will be feeding in the SO number and shipment into the SAP system and the SAP system automatically should propose an excel filename which is same as the one generated by the client's proprietary application

Send me the logic soon.

Thanks & Regards