| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | VIEWNAME | Name of SAP table view | nvarchar | 30 | 0 | CHAR | (N' ') | No | | VIEWNAME | Allow NULL? |
| 2 | AS4LOCAL | Activation Status of a Repository Object | char | 1 | 0 | CHAR | (N' ') | No | | AS4LOCAL | Allow NULL? |
| 3 | AS4VERS | Version of the entry (not used) | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | AS4VERS | Allow NULL? |
| 4 | AGGTYPE | Aggregate Type | char | 1 | 0 | CHAR | (N' ') | Yes | | AGGTYPE | Allow NULL? |
| 5 | APPLCLASS | Application class for DD objects (not used) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TAPPL | APPLCLASS | Allow NULL? |
| 6 | AUTHCLASS | Activation type | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | AUTHCLASS_ | Allow NULL? |
| 7 | READONLY | Read-Only Flag for Views (old) | char | 1 | 0 | CHAR | (N' ') | Yes | | MCROFLAG | Allow NULL? |
| 8 | ROOTTAB | Primary table of an aggregate | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ROOTTAB | Allow NULL? |
| 9 | AS4USER | Last Changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AS4USER | Allow NULL? |
| 10 | AS4DATE | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AS4DATE | Allow NULL? |
| 11 | AS4TIME | Last changed at | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | AS4TIME | Allow NULL? |
| 12 | VIEWCLASS | View Type | char | 1 | 0 | CHAR | (N' ') | Yes | | VIEWCLASS | Allow NULL? |
| 13 | ACTFLAG | Activation flag | char | 1 | 0 | CHAR | (N' ') | Yes | | ACTFLAG | Allow NULL? |
| 14 | MASTERLANG | Original Language in Repository objects | char | 1 | 0 | LANG | (N' ') | Yes | T002 | MASTERLANG | Allow NULL? |
| 15 | CUSTOMAUTH | Delivery class | char | 1 | 0 | CHAR | (N' ') | Yes | | CONTFLAG | Allow NULL? |
| 16 | VIEWGRANT | Maintenance status (modif. authorization) for view data | char | 1 | 0 | CHAR | (N' ') | Yes | | VIEWGRANT | Allow NULL? |
| 17 | GLOBALFLAG | Flag if Maintenance with Standard Tools is allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | MAINTFLAG | Allow NULL? |
| 18 | MANKEY | Permit manual maintenance of key attribute | char | 1 | 0 | CHAR | (N' ') | Yes | | DDVIMANKEY | Allow NULL? |
| 19 | DBREFNAME | DD: Name of View on Database | nvarchar | 250 | 0 | CHAR | (N' ') | Yes | | DBVIEWNAME | Allow NULL? |
| 20 | ALLDATAINCL | DD: DataAging: Handle data as hot and cold if switched on | char | 1 | 0 | CHAR | (N' ') | No | | DDALLDATAINCLU | Allow NULL? |
| 21 | WITH_PARAMETERS | DD: Set whenever a view or base view has parameters | char | 1 | 0 | CHAR | (N' ') | No | | DDWITHPAR | Allow NULL? |
| 22 | EXVIEW_INCLUDED | DD: Contains at least one external view in the hierarchy | char | 1 | 0 | CHAR | (N' ') | No | | DDEXTVIEW_INCLUDED | Allow NULL? |
| 23 | EXPR_IS_USED | DD: In the view, at least one expr. used (current append) | char | 1 | 0 | CHAR | (N' ') | No | | DDEXPR_IS_USED | Allow NULL? |
| 24 | KEYMAX_FEATURE | DD: Maximum CL_DD_DBFEATURES=>KEYCNT_MAX1 Key Fields | char | 1 | 0 | CHAR | (N' ') | No | | DDDBKEYMAXFEATURE | Allow NULL? |
| 25 | KEYLEN_FEATURE | DD: Maximum CL_DD_DBFEATURES=>KEYLEN_MAX1 Key Length | char | 1 | 0 | CHAR | (N' ') | No | | DDDBKEYLENFEATURE | Allow NULL? |
| 26 | TABLEN_FEATURE | DD: Maximum Width CL_DD_DBFEATURES=>LEN_MAX1 | char | 1 | 0 | CHAR | (N' ') | No | | DDDBTABLENFEATURE | Allow NULL? |
| 27 | NONTRP_INCLUDED | DD: At least one non-transparent one contained | char | 1 | 0 | CHAR | (N' ') | No | | DDNONTRANSP_INCLUDED | Allow NULL? |
