| 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 | 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 | KPP_JOIN | Link number for bracketted dimensions/characteristics | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | KPP_JOIN | Allow NULL? |
| 7 | VALUE | Value in Characteristics Table | nvarchar | 40 | 0 | CHAR | (N' ') | No | | KPP_VALUE | Allow NULL? |
| 8 | INIT | Flag: Initial value chosen as select option | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_INIT | Allow NULL? |
| 9 | SCRTEXT_S | Short Field Label | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SCRTEXT_S | Allow NULL? |
| 10 | SCRTEXT_M | CO Planning Processor: Name Field | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | KPP_TEXT_M | Allow NULL? |
| 11 | SCRTEXT_L | Long Field Label | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SCRTEXT_L | Allow NULL? |
| 12 | TEXTR | Ind. Texts for characterstic read? | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_TEXTR | Allow NULL? |
| 13 | KPP_INPUT | Set as Ready for Input | char | 1 | 0 | CHAR | (N' ') | Yes | | INPUT | Allow NULL? |
| 14 | CALCM | Time-Based Aggregation Behavior of Characteristic Value | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_CALCM | Allow NULL? |
| 15 | CALCD | Factual Aggregation Behavior of Characteristic Value | char | 1 | 0 | CHAR | (N' ') | Yes | | KPP_CALCD | Allow NULL? |
| 16 | NORMA | Characteristic for standardizing, using standard. method | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | KPP_NORMA | Allow NULL? |