| 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 ID | nvarchar | 5 | 0 | CHAR | (N' ') | No | | CNVCMIS_A_10_PACKID | Allow NULL? |
| 3 | VERSN | Version of an Analysis | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CNVCMIS_A_10_VERSN | Allow NULL? |
| 4 | TABNAME | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABNAME | Allow NULL? |
| 5 | FIELDNAME | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FIELDNAME | Allow NULL? |
| 6 | SYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | No | | SYSYSID | Allow NULL? |
| 7 | VERSIONNO | Object Version Number | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CNVCMIS_A_10_VERSIONNO | Allow NULL? |
| 8 | ROLLNAME | Data element (semantic domain) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ROLLNAME | Allow NULL? |
| 9 | POSITIONS | Position of the field in the table | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | TABFDPOS | Allow NULL? |
| 10 | KEYFLAG | Identifies a key field of a table | char | 1 | 0 | CHAR | (N' ') | Yes | | KEYFLAG | Allow NULL? |
| 11 | MANDATORY | Flag: Field is required (not blank) | char | 1 | 0 | CHAR | (N' ') | Yes | | MANDATORY | Allow NULL? |
| 12 | CHECKTABLE | Check table name of the foreign key | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CHECKTABLE | Allow NULL? |
| 13 | ADMINFIELD | Nesting depth for includes | char | 1 | 0 | CHAR | (N' ') | Yes | | ADMINFIELD | Allow NULL? |
| 14 | INTTYPE | ABAP data type (C,D,N,...) | char | 1 | 0 | CHAR | (N' ') | Yes | | INTTYPE | Allow NULL? |
| 15 | INTLEN | Internal Length in Bytes | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | INTLEN | Allow NULL? |
| 16 | REFTABLE | Table for reference field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFTABLE | Allow NULL? |
| 17 | PRECFIELD | Name of included table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | PRECFIELD | Allow NULL? |
| 18 | REFFIELD | Reference field for currency and qty fields | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFFIELD | Allow NULL? |
| 19 | CONROUT | Check or generating module for fields | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CONROUT | Allow NULL? |
| 20 | NOTNULL | Indicator for initial values in database fields | char | 1 | 0 | CHAR | (N' ') | Yes | | NOTNULL | Allow NULL? |
| 21 | DATATYPE | Data Type in ABAP Dictionary | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | DATATYPE_D | Allow NULL? |
| 22 | LENG | Length (No. of Characters) | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | DDLENG | Allow NULL? |
| 23 | DECIMALS | Number of Decimal Places | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | DECIMALS | Allow NULL? |
| 24 | DOMNAME | Domain name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | DD01L | DOMNAME | Allow NULL? |
| 25 | SHLPORIGIN | Origin of an Input Help | char | 1 | 0 | CHAR | (N' ') | Yes | | SHLPORIGIN | Allow NULL? |
| 26 | TABLETYPE | DD: Flag if it is a table | char | 1 | 0 | CHAR | (N' ') | Yes | | DDTABTYPE | Allow NULL? |
| 27 | DEPTH | DD: Depth for structured types | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | TYPEDEPTH | Allow NULL? |
| 28 | COMPTYPE | DD: Component Type | char | 1 | 0 | CHAR | (N' ') | Yes | | COMPTYPE | Allow NULL? |
| 29 | REFTYPE | Referenced Object Type | char | 1 | 0 | CHAR | (N' ') | Yes | | CNV_CMIS_DDREFTYPE | Allow NULL? |
| 30 | LANGUFLAG | Language Field Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CNV_CMIS_DLANGUFLG | Allow NULL? |
| 31 | SEVERITY | Severity | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CNV_CMIS_A_10_SEVERITY | Allow NULL? |
| 32 | DBPOSITION | Position of the field in the table | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | TABFDPOS | Allow NULL? |
