Process Template Loop

Description

Click to open the Template page with the template from the Process Template Loop displayed.

Click to open the Process Template Loop View Relationship page to view or edit relationships for the loops generated from looped BDC Script or GUI Script templates or from BAPI/RFC templates. Integrate can create these relationships automatically using the Auto Generate Database Objects feature.

Click to have Integrate automatically generate tables and views for the Process Template Loops for any template type and relationships for Process templates based on BDC Script, GUI Script, and BAPI/RFC template types.

If enabled, Integrate will include the loop when posting data. If disabled, the loop is excluded.

If enabled, the user can set the VIEW NAME and PRIMARY KEY COLUMN NAME. If disabled, these fields cannot be edited. This check box is not available when the template type is BDC Script, GUI Script or BAPI.

Displays the name of the loop Integrate generated, if the template is based on a BDC Script or GUI Script template. . For User Defined Templates, the structure names defined during template creation become the loop names.  The loop names for a BAPI/RFC template type are based on the structure definitions.

Displays the description of the loop which is supplied by different sources depending on the template type.

Displays the name of the view selected when the process was created or the name of the view that Integrate automatically generated when using the Auto Generate Database Objects feature. A user can also manually set the view if the view exists in the database. This view contains the data that will be posted.

Displays the column name of the view that uniquely identifies a record in the view.  This column is selected when the process was created or is automatically generated when using the Auto Generate Database Objects feature. This column must be set and can be overwritten by the user.

Displays the column that contains the key value that links a unique object across multiple structures used for flat file creation. The Flat File Object Key is a unique value for an object that Integrate uses to join the data stored in different tables to make a complete data set for the object. The data set has two loop levels, the header and the details. For example, Integrate uses the flat file object key of 1 in the first loop  the header  to join the header with detail records stored in tables that also have the flat file object key of 1. When posting, batch sizes are based on the number of header records as set by the flat file object key. The Flat File Object Key is used with  User Defined Fixed Width and Delimited template types only.

Displays the table where output from SAP will be written.

Displays for process templates based on BAPI/RFC template types only.

Displays the Primary Key Column on the Download table.  The Download Primary Key must be set up to be auto-incrementing to be unique in the database using either an IDENTITY column or a UNIQUEIDENTIFIER column with a default of NEWID  . 

Displays for process templates based on BAPI/RFC template types only.

Click to open the Process Template Loop Field Mappings page to edit field mappings for the Process Template Loop.