There are a couple of reports that you can run out of SAP that are able to tell you what inventory you have available to fulfill orders but there are also scenarios where you want to be able to do a simulation of an order that actually checks inventory levels. The order entry transaction VA01 supports the checking of inventory (ATP – Availability to Promise) as part of the order entry process and a few extra keystrokes in this screen can give you visibility into inventory levels.
Since you are possibly using VA01 to create orders in your SAP system already, why not consider enabling this extra capability in your transaction recording to read data out of the screen and display it in-line with your order data in Excel? Here’s how you would do it.
First, you do need to create your script in non-batch mode. The reason for this is that non-batch mode supports update and read of SAP GUI screens. Batch mode unfortunately only sends data to the SAP screens and fields so won’t allow you to do this. You could use GUI scripting which is the third mode, but that is relatively inefficient and so isn’t recommended unless absolutely necessary.
When recording your transaction, be sure to additionally (1) click on the row selector for the row you just created and then (2) click on the Availability Overview, this will show you the ATP situation
Since the first row in this screen is typically protected and will read only, you will need to manually insert the attributes for this field. This is usually MDEZ-MNG01 but could be different in your system. The screen for availability is typically a grid, we have a number of ATP activities showing but the first row (01) shows the Stock.
I have manually inserted this into my script by copying and pasting row 25 again into the mapper and then editing this row to reflect the data that I want to see. I have also toggled the mapping type to ‘Read from SAP’ thereby enabling me to map it to a column in EXCEL.
When inserting your loop into your script, be sure to put the loop around the SAPLATP4-0400 (Availability Overview) screen also.
Questions or comments about this article?
Tweet @uploadsap to continue the conversation!