-
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
- Solutions
- Platform
- Integrate
- 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 a BAPI
>Review the steps in the process.
If the Auto Generate Database Objects feature was used, confirm that database objects were created. Access the SQL database to view the views and tables Integrate created during the auto-generation process.
-
Log in to SQL Management Studio.
-
Locate the database assigned to the process.
-
Locate the views and tables created in the database.
NOTE: Integrate creates tables and views in the database for all process template loops for a process, including download tables that contain the unique identifier Posting ID for those loops that contain download fields. It names the tables tt[Process Name][Template Name][Loop Name]_Upload and tt[Process Name][Template Name][Loop Name]_Download. The View Name for each process template is tx[Process Name] [Template Name] [Loop Name]_Int.
-
Open the Download tables in Design mode and verify that each has a PostingID column.
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.