-
Integrate Overview
-
Pages
- BAPI\\RFC Definition
- BAPI\\RFC Definition: Field
- BDC Post Methods and Settings on the Advanced tab
- BDC Screen Conditionals
- BDC Screen Fields H
- BDC Screen H
- BDCdirect: Script
- BDCPlus: Templates
- Categories
- Copy
- Custom Fields
- File Structure Field Element - Attributes
- GUI Script Actions
- GUI Script Commands
- GUI Script Conditionals
- GUI Script Data H
- Message File
- Messages H
- Post Adapter
- Post Engine H
- Post File Logs
- Post Files
- Post Monitor H
- Post Monitor Template
- Process H
- Process Post Connections
- Process Post H
- Process Template After Post Rule Collect Where
- Process Template Connections
- Process Template Loop
- Process Template Loop Field Mappings H
- Process Templates H
- Relationship Mapping
- Relationship Mapping BDC Script, GUI Script or BAPI/RFC Template Types
- Structure
- Structure Field
- Template H
- Template Processes
- Template Report
- Template RFC Documentation
-
Procedures
- Activate or Deactivate Multiple Processes for a Template
- Activate the BAPI Template
- Activate the BDC Script Template
- Activate the Custom Template
- Activate the GUI Script Template
- Activate the Process
- Activate the Process
- Activate the Process
- Activate the Process
- Activate the Process
- Activate the Process
- Activate the Process
- Activate the Process
- Activate the RFC Template
- Activate the Template
- Activate the User Defined Template
- Activate the XML Template
- Add Child Structure
- Add Custom Fields to a BDC Script Template
- Add Data in SQL to be Included in the Flat File
- Add Data to be Included in the XML file in SQL
- Add Templates to a Process
- Add the Template to a Process
- Add the Template to a Process
- Add the Template to a Process
- Add the Template to a Process
- Add the Template to a Process
- Add the Template to a Process
- Add the Template to a Process
- Assign the Custom Template to a Process
- BDC Posting
- BDC Script and GUI Script Recording Tips
- Configure a BAPI Template
- Configure a Conditional for a BDC Screen
- Configure a Process Template Loop for a BDC Script Template with a Single Loop
- Configure a Process Template Loop for a GUI Script Template with a Single Loop
- Configure a Process Template Loop for a SAP Data Services Job Process Template Automatically
- Configure a Process Template Loop for a SAP Data Services Job Process Template Manually
- Configure an RFC Template
- Configure an XML Template with Structures, Elements and Attributes
- Configure Conditional GUI Script Data Records
- Configure Field Mappings for a Process Based on a BDC Script Template
- Configure Field Mappings for a Process based on a GUI Script Template
- Configure Field Mappings for an SAP Data Services Job Process Template
- Configure Process Template Loops for a BAPI Template
- Configure Process Template Loops for a BDC Script Template with Looping Enabled
- Configure Process Template Loops for a Delimited or Fixed Width Template
- Configure Process Template Loops for a GUI Script Template with Looping Enabled
- Configure Process Template Loops for an RFC Template
- Configure Process Template Loops for an XML Template
- Configure Relationships Manually for a Process based on an XML Template
- Configure Template Loops for a BDC Script Template
- Configure Template Loops for a GUI Script Template
- Control data is obsolete, rerecord (VERBS-NAME: CreateObject CATT: \<none; \> Callno: 000001)
- Copy a GUI Script Data Record
- Copy a Process
- Copy a Process Template
- Copy a Template
- Copy the Assembly File to the Integrate Process Folder
- Create a Basic Template
- Create a Custom Assembly
- Create a Custom Posting
- Create A Custom Template
- Create a Delimited or Fixed Width User Defined Template
- Create a Process
- Create a View in SQL Server
- Create an SAP Data Services Job Template
- Create and Transfer Delimited or Fixed Width Files
- Create and Transfer Files for User Defined Fixed Width or Delimited Templates
- Create and Transfer XML Files
- Create and Transfer XML Files
- Debug a GUI Script Posting
- Define Structures and Fields for Delimited or Fixed Width Templates
- Delete GUI Script Fields
- Edit Connections to Target Systems at the Process Post Level
- Elements and Attributes
- Field X is not an input field.
- Generate Database Objects Automatically
- Import a BDC Script From a File
- Import Legacy BDCdirect<span>®</span> Scripts into Integrate
- Import Legacy BDCPlus Templates into Integrate
- Import Legacy Scripts into Integrate
- Integrate Tips and Troubleshooting
- Manage BDC Screens and Fields
- Manage Processes
- Manage Templates
- Merge or Copy BDC Screens to Another BDC Script Template
- Modify a GUI Script with a Custom Command
- Monitor Posts
- No batch input data for screen
- Post a Process with Multiple Templates
- Post Data for a Process Based on a BAPI
- Post Data for a Process Based on a BDC Script Template
- Post Data for a Process Based on a GUI Script Template
- Post Data for a Process Based on an RFC
- Post Data to Multiple Target Systems with One Process Template
- Post Data Using a BAPI
- Post Data Using a Custom Template
- Post Data Using a GUI Script
- Post Data Using an SAP Data Services Job
- Post Data Using an SAP Data Services Job Overview
- Post Data Using Transaction Stringing
- Post Data with a BDC Script
- Post Data with a Custom Template
- Post Using RFC Execution
- Posting Defaults
- Posting Methods
- Posting Troubleshooting
- Process Template Loop View Relationships
- Record a BDC Script
- Record a GUI Script
- Register a Collect Download After Post Rule Manually
- Register a Collect Download After Post Rule that is Built Automatically
- Register a Collect Download as an After Post Rule
- Register a Status View as an After Post Rule
- Register a Stored Procedure as an After Post Rule
- Register After Post Rules to a Process Template Overview
- Reset and Resubmit a Failed Post
- Resolve Problem Connecting to the SAP GUI During Template Recording
- Set Available Connections at the Process Template Level
- Set up After Post Rules to Check for Failed Posts for BAPI or RFC Processes
- Setup and Configuration for Integrate
- Synchronous and Asynchronous Post Execution Methods
- Verify the Data was Posted in SAP for the BAPI
- Verify the RFC Retrieved Data from SAP and Updated the Download Tables in SQL
- Verify the Tables and Views were Created in SQL by the Auto Generate Process for a BAPI
- Verify the Tables and Views were Created in SQL by the Auto Generate Process for an RFC
- View and Configure Field Mappings for a Process based on a BAPI
- View and Configure Field Mappings for a Process Based on an RFC
- View and Configure Relationships for a Process Based on a BAPI
- View and Configure Relationships for a Process Based on a BDC Script Template
- View and Configure Relationships for a Process Based on a GUI Script Template
- View and Configure Relationships for a Process Based on an RFC
- View Template Report
- View the Debug Log
-
Pages
Add Data to be Included in the XML file in SQL
Review the steps to create and transfer XML files.
Enter the data to the SQL database that Integrate will include in the XML file when it is generated.
Use the view name generated by the Auto Generate Database Objects feature for each loop in the process or the view that was manually created.
-
Log in to SQL Server.
-
Locate the database assigned to the process.
-
Locate the views and corresponding tables assigned to each of the process template loops.
NOTE: If Integrate created tables and views using the Auto Generate Database Objects feature, views are named tx[Process Name Template Name Loop Name]. Tables are named tt[Process Name Template Name Loop Name]_Upload.
-
Open each table and add records.
NOTE: The Parent ID ties the structure in the file to the column in the view.
NOTE: If the database objects were created using the Auto Generate Database Object feature, do not populate the ID field, it will be auto-generated.
Was this article helpful?
Sorry about that.
Why wasn't this helpful? (check all that apply)
Thanks for your feedback.
Want to tell us more?
Send an email to our authors to leave your feedback.
Great!
Thanks for your feedback.