Mass Maintenance
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.
