| 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 | T000 | MANDT | Allow NULL? |
| 2 | CONAME | Cockpit | nvarchar | 15 | 0 | CHAR | (N' ') | No | UMM_CO100 | UMM_Y_CONAME | Allow NULL? |
| 3 | WANO | Number of a Wall in the Management Cockpit | char | 1 | 0 | NUMC | (N'0') | No | | UMM_Y_WANO | Allow NULL? |
| 4 | LVNO | Number of a Logical View in the Wall | char | 1 | 0 | NUMC | (N'0') | No | | UMM_Y_LVNO | Allow NULL? |
| 5 | FRNO | Number of a Frame in a Logical View | char | 1 | 0 | NUMC | (N'0') | No | | UMM_Y_FRNO | Allow NULL? |
| 6 | VANAME | Technical Name of a CPM Variable | nvarchar | 15 | 0 | CHAR | (N' ') | No | UMM_VA100 | UMM_Y_VANAME | Allow NULL? |
| 7 | SELNO | Selection number | nvarchar | 2 | 0 | NUMC | (N'00') | No | | UMC_Y_SELNO | Allow NULL? |
| 8 | FRNAME | Technical Name of a Frame | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | UMM_FR100 | UMM_Y_FRNAME | Allow NULL? |
| 9 | POSFLG | Ind. : Position-Dependent Variable Assignment in Cockpit | char | 1 | 0 | CHAR | (N' ') | Yes | | UMM_Y_POSFLG | Allow NULL? |
| 10 | YTD | Aggregation | char | 1 | 0 | CHAR | (N' ') | Yes | | UMC_Y_YTD | Allow NULL? |
| 11 | SIGN | Sign for selection | char | 1 | 0 | CHAR | (N' ') | Yes | | UMC_Y_SIGN | Allow NULL? |
| 12 | OPER | Selection operand (EQ, NE, .....) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | UMC_Y_OPER | Allow NULL? |
| 13 | LOW | Lower interval limit (ODBO) | nvarchar | 143 | 0 | CHAR | (N' ') | Yes | | UMC_Y_LOW | Allow NULL? |
| 14 | LOWBW | Upper Interval Limit (BW Internal Display) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | UMC_Y_LOWBW | Allow NULL? |
| 15 | LOWBW_EXT | Lower Interval Limit (BW) | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | UMC_Y_LOWBW_EXT | Allow NULL? |
| 16 | HIGH | Upper interval limit (ODBO) | nvarchar | 143 | 0 | CHAR | (N' ') | Yes | | UMC_Y_HIGH | Allow NULL? |
| 17 | HIGHBW | Lower Interval Limit (BW Internal Display) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | UMC_Y_HIGHBW | Allow NULL? |
| 18 | HIGHBW_EXT | Upper Interval Limit (BW) | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | UMC_Y_HIGHBW_EXT | Allow NULL? |
| 19 | HINAME | Hierarchy (ODBO Name) | nvarchar | 65 | 0 | CHAR | (N' ') | Yes | | UMC_Y_THINAME | Allow NULL? |
| 20 | HINAMEBW | Hierarchy Name (BW) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | UMC_Y_IHINAME | Allow NULL? |
| 21 | HINODE | Hierarchy Node (ODBO) | nvarchar | 143 | 0 | CHAR | (N' ') | Yes | | UMC_Y_THINODE | Allow NULL? |
| 22 | HINODEBW | Field for any Characteristic Value (BW Internal Display) | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | UMC_Y_ICHAVAL | Allow NULL? |
| 23 | HINODEBW_EXT | Field for any Characteristic Value (BW) | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | UMC_Y_ICHAVALEXT | Allow NULL? |
| 24 | HIVERS | Hierarchy version | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | UMC_Y_HIVERS | Allow NULL? |
| 25 | HIDATE | Hierarchy: Key date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | UMC_Y_HIDATE | Allow NULL? |
| 26 | TIMESTMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | RSTIMESTMP | |
