Mass Maintenance
Create all tt Tables and Views for the BAPI Process
Before performing these steps, Post Data Using A BAPI.
Manually build tables (a main table and an upload table) and views in any database that has a supporting component and data source that is registered in the Stewardship Tier.
Using the auto-generated BAPI tables that exist in Integrate, script each BAPI table as a new table beginning with tt. In addition to the existing columns, add the following columns to each tt table:
NOTE: The ID column must be set as the PrimaryKey of the tt Table.
Column Name |
Data Type |
Value |
RequestID NOTE: Place this column at the top underneath ID. |
int |
NULL, <- |
PostError |
int |
NULL DEFAULT (2) |
PostMessage |
nvarchar (max) |
NULL DEFAULT '' |
boaStatus |
int |
NULL |
ValidationErrorMessage |
nvarchar (max) |
NULL |
Severity |
int |
NULL |
Reject |
bit |
NULL DEFAULT (0) |
RejectReason |
nvarchar (max) |
NULL |
RejectedBy |
nvarchar (50) |
NULL |
LockReject |
bit |
NULL |
Continue with Create rt Tables From the tt Tables and Create Views for the BAPI Process.