Mass Maintenance
Create rt Tables From the tt Tables and Create Views for the BAPI Process
Before performing these steps:
Once each tt table is created, use it as a script to create an rt table. Add the following columns to each table.
NOTE: The tt table has the ID column as an IDENTITY. When using the tt table as a basis for the rt table, the rt table will then also have the ID column as an IDENTITY when the rt table is created. In the rt table, the ArchiveID should be added as IDENTITY. Since a table can only have one IDENTITY column, the definition of the ID column has to be changed to not be IDENTITY. These updates to the rt table must be performed manually.
NOTE: ArchiveID column must be set as the PrimaryKey of the rt Table.
Column Name |
Data Type |
Value |
ArchiveID NOTE: This should be the first column in the table. |
int |
IDENTITY(1,1) NOT NULL
|
ID column must have its IDENTITY property removed. . |
Int |
NOT NULL |
PostedOn |
smalldatetime |
NULL DEFAULT (getdate()) |
PostedBy |
nvarchar (50) |
NULL |
Connection
|
nvarchar (50) |
NULL |
For each table (the main table and each upload table), create a tx view. The tx view should contain all columns from the tt table, the WebAppID where the view resides, and a WHERE clause 'WHERE [PostError] >= 1'.
Continue with Create Custom Pages and Views for the BAPI Process.