Mass Maintenance

Create rt Tables From the tt Tables and Create Views for the BAPI Process

Before performing these steps:

  1. Post Data Using A BAPI
  2. Create all tt Tables and Views for the BAPI Process

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.