| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | PACKID | Package Number of Transformation / Analysis Package | nvarchar | 5 | 0 | CHAR | (N' ') | No | * | CNV_MBT_PACKID | Allow NULL? |
| 3 | OBJECT | Object Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | TROBJTYPE | Allow NULL? |
| 4 | OBJ_NAME | Object Name in Object Directory | nvarchar | 40 | 0 | CHAR | (N' ') | No | | SOBJ_NAME | Allow NULL? |
| 5 | SYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | No | | SYSYSID | Allow NULL? |
| 6 | SUB_TYPE | Subobject Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CNV_CMIS_A_SUBOBJTYPE | Allow NULL? |
| 7 | SUB_NAME | Subobject Name | nvarchar | 120 | 0 | CHAR | (N' ') | No | | CNV_CMIS_A_SUB_NAME | Allow NULL? |
| 8 | VERSN | Version Number | nvarchar | 3 | 0 | CHAR | (N' ') | No | | CNVCMIS_A_20_VERSN | Allow NULL? |
| 9 | AUTHOR | Person Responsible for a Repository Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RESPONSIBL | Allow NULL? |
| 10 | DEVCLASS | Package | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | DEVCLASS | Allow NULL? |
| 11 | CTEXT | Short Description of Repository Objects | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | AS4TEXT | Allow NULL? |
| 12 | APP_HIER | Application Hierarchy | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | CNVCMIS_A_10_APP_HIER | Allow NULL? |
| 13 | APP_HIER_TEXT | Application Hierarchy Text | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | CNVCMIS_A_10_APP_HIER_TEXT | Allow NULL? |
| 14 | CATEGORY | Normal Category | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CNVCMIS_A_CATEGORY | Allow NULL? |
| 15 | TRKORR | Request/Task | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | TRKORR | Allow NULL? |
| 16 | AS4USER | Owner of a Request or Task | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | TR_AS4USER | Allow NULL? |
| 17 | AS4DATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AS4DATE | Allow NULL? |
| 18 | AS4TIME | Last changed at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AS4TIME | Allow NULL? |
| 19 | SRCSYSTEM | Original System of Object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SRCSYSTEM | Allow NULL? |
| 20 | GENFLAG | Generation flag | char | 1 | 0 | CHAR | (N' ') | Yes | | GENFLAG | Allow NULL? |
| 21 | MASTERLANG | Original Language in Repository objects | char | 1 | 0 | LANG | (N' ') | Yes | * | MASTERLANG | Allow NULL? |
| 22 | STATUS | Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CNV_CMIS_STATUS | Allow NULL? |
| 23 | MOD_NAME | Development Environment TADIR Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | EU_ANAME | Allow NULL? |
