UPG_DD12L - ICNV: Secondary Indexes - Header
ICNV: Secondary Indexes - Header information is stored in SAP table UPG_DD12L.
It is part of development package SICN in software component BC-DB-DB2-UPG. This development package consists of objects that can be grouped under "Incremental Conversion and Tools".
It is part of development package SICN in software component BC-DB-DB2-UPG. This development package consists of objects that can be grouped under "Incremental Conversion and Tools".
Fields for table UPG_DD12L
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SQLTAB | Table for incremental conversion | X | ICNVTAB | CHAR | 60 | |
| INDEXNAME | Index ID | X | CHAR | 6 | ||
| AS4LOCAL | Activation Status of a Repository Object | X | CHAR | 2 | ||
| AS4VERS | Version of the entry (not used) | X | NUMC | 8 | ||
| FCT | Function: 'ICN' or 'CRE' | CHAR | 6 | |||
| AUTHCLASS | Activation Type | NUMC | 4 | |||
| UNIQUEFLAG | Flag for UNIQUE indexes | CHAR | 2 | |||
| AS4USER | Last Changed by | CHAR | 24 | |||
| AS4DATE | Date of Last Change | DATS | 16 | |||
| AS4TIME | Last changed at | TIMS | 12 | |||
| ACTFLAG | Activation Flag | CHAR | 2 | |||
| DBINDEX | Database index | CHAR | 36 | |||
| DBSTATE | Status of index on the database | CHAR | 2 | |||
| DBINCLEXCL | List of DB systems used as list of inclusions/exclusions | CHAR | 2 | |||
| DBSYSSEL1 | Choose a database system for DB-specific indexes | CHAR | 6 | |||
| DBSYSSEL2 | Choose a database system for DB-specific indexes | CHAR | 6 | |||
| DBSYSSEL3 | Choose a database system for DB-specific indexes | CHAR | 6 | |||
| DBSYSSEL4 | Choose a database system for DB-specific indexes | CHAR | 6 |