Sales and Distribution (SD) Module - Run SAP From Excel
In this video an End User runs various SAP Sales and Distribution (SD) module transactions and data extractions right from Excel utilizing Innowera's Process Runner Excel Add-in. VA01 Create Sales Order, VD02 Change Customer (Sales), data extractions from a table join of the VBAK Sales Document: Header Data and VBAP Sales Document: Item Data tables, and the BAPI, BAPI_SALESORDER_GETLIST are all covered. SAP made easy, by running these transactions and data extractions, with Excel as the interface to SAP is highlighted.
http://www.innowera.com/sapsd.php will tell you more about SAP SD automation in SAP using Process Runner.