The first ID Column stores the row type, which defaults to a value of either H (Header) or D (Detail/Line Item). For multi-line transactions, by default, the first column of Excel is reserved for the Excel ID. NOTE: The rows selected must be inclusive.Įxcel ID Column: Type the column letter to specify the Excel column that is to contain the Mapper row ID number. Start Row/End Row: Type the Start Row and End Row you want to use, if other than the row or range of rows you initially selected on the Expert Recording Preview. The Excel Do-While Properties dialog box settings are: When you insert the Do While.Loop, the Mapper displays the fields contained within the loop by using two (Loop icons) connected by a line. Map your header information and line item detail. Select the line item detail and then click Loop.Because only one line item is required to be mapped, delete the second line item. Select the detail for the second line item.While recording the transaction, we recommend that you enter more than one line item in the transaction to create a visible pattern of repetition in the Mapper. Move to the next line and type information for another line item. In the form fields, type in the information for one line item.Click the green check mark or press ENTER. In the SAP transaction, type in the header detail.In the Record pane of TRANSACTION, type the transaction you want to use and click Go.In your script, the loop tells the script to use that particular code for each item. To ensure that your script returns repeatedly to the same SAP fields to enter new line item detail information, use loops. An example of such a transaction is a VAO1 sales order creation. Your data consists of information that is the same throughout the transaction, which is the header, and information that changes, which are the many line item details. ![]() ![]() Sometimes you may need to upload many lines of the same type of information, such as in a table or a grid. Introducing Winshuttle TRANSACTION > TRANSACTION Tutorial > Introduction: Creating loops
0 Comments
Leave a Reply. |