| 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 | APPL | Application class for drilldown reporting | nvarchar | 4 | 0 | CHAR | (N' ') | No | * | CFAPPLCLAS | Allow NULL? |
| 3 | SUBCLASS | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FIELDNAME | Allow NULL? |
| 4 | TABNAME | FI-SL planning: Summary table name | nvarchar | 30 | 0 | CHAR | (N' ') | No | T8PL00 | TABNAME_GLPL | Allow NULL? |
| 5 | FIELDNAME | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FIELDNAME | Allow NULL? |
| 6 | DTYPE | Planning dimension type | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_DTYPE | Allow NULL? |
| 7 | DOBLI | Indicator: planning dimension obligatory? | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_DOBLI | Allow NULL? |
| 8 | DSHOW | Ind.: planning dimension for display active? | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_DSHOW | Allow NULL? |
| 9 | DINIT | Ind.: Is a blank value allowed as a select option? | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_DINIT | Allow NULL? |
| 10 | DMAC | Matchcode file name | nvarchar | 132 | 0 | CHAR | (N' ') | Yes | | DMAC_____4 | Allow NULL? |
| 11 | F4PR | Program containing own F4 functions | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | KPP_F4PR | Allow NULL? |
| 12 | F4FM | Form routine containing own F4 function for the dimension | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KPP_F4FM | Allow NULL? |
| 13 | B_MEMORYID | Set/Get parameter ID | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | MEMORYID | Allow NULL? |
| 14 | COMPL | CO planning processor: dimension complement permitted | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_COMPL | Allow NULL? |
| 15 | SORT | Validation sequence on initial screen | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | KPP_DSORT | Allow NULL? |
| 16 | DDDRI | Indicator: dimension based on data? | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_DDDRI | Allow NULL? |
| 17 | SETUSE | Ind.: Is a set used for the dimemsion? | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_SETUSE | Allow NULL? |
| 18 | RATIO | Screen area within row/column structure | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_RATIO | Allow NULL? |
| 19 | HDPOS | Position of dimension in header area | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | KPP_HDPOS | Allow NULL? |
| 20 | HIERLEVEL | Level within validation hierarchy | int | 10 | 0 | INT4 | ((0)) | Yes | | KPP_LEVEL | Allow NULL? |
| 21 | MOMENT | Time of validation | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_MOMENT | Allow NULL? |
| 22 | VALUE | Value in Characteristics Table | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | KPP_VALUE | Allow NULL? |
| 23 | INIT | Flag: Initial value chosen as select option | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_INIT | Allow NULL? |
| 24 | HEAD_ROW | Row in Screen Area | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | KPP_ROW | Allow NULL? |
| 25 | SUM_TYPE | Key Column Presentation Type | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_S_TYPE | Allow NULL? |
