| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | APPLC | Application class for drilldown reporting | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKCKC | CFAPPLCLAS | Allow NULL? |
| 2 | KEYRA | Key figure | nvarchar | 30 | 0 | CHAR | (N' ') | No | | KCKEYRA | Allow NULL? |
| 3 | ROLNM | Data element (semantic domain) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ROLLNAME | Allow NULL? |
| 4 | SBGRP | Key figure groups | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TKCKU | CGSSBGRP | Allow NULL? |
| 5 | AGGDI | Aggregation | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CGSAGGDI | Allow NULL? |
| 6 | AGGTM | Aggregation based on time | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CGSAGGTM | Allow NULL? |
| 7 | AGGFI | Reference Field for Time-Based Aggregation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSAGGFI | Allow NULL? |
| 8 | OPORD | Indicator: No Aggregation Required | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSOPORD | Allow NULL? |
| 9 | PRDEC | Decimal Places (Output) | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSDEC | Allow NULL? |
| 10 | PRSNT | Scaling factor | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSPRS | Allow NULL? |
| 11 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CGSCCNUM | Allow NULL? |
| 12 | DCURR | Target Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CGSDCURR | Allow NULL? |
| 13 | CHNAM | User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CGSCHNAM | Allow NULL? |
| 14 | CHDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CGSCHDAT | Allow NULL? |
| 15 | CHTIM | Time of Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CGSCHTIM | Allow NULL? |
| 16 | TFLAG | Flag: Text | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSTFLAG | Allow NULL? |
| 17 | RCSIN | Row/Column Structure Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSRCSIN | Allow NULL? |
| 18 | RSLIN | Report Selection Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSRSLIN | Allow NULL? |
| 19 | BASFL | Flag: key figure is a basic key figure | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSBASFL | Allow NULL? |
| 20 | COBJID | Folder Entry ID (Obj+Fol+Forwarder Name) | nvarchar | 46 | 0 | CHAR | (N' ') | Yes | | SO_ENTRYID | Allow NULL? |
