| 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 | * | CFAPPLCLAS | Allow NULL? |
| 2 | FIENM | Field Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | FIELDNAME | Allow NULL? |
| 3 | ROLNM | Data element (semantic domain) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | DD04L | ROLLNAME | Allow NULL? |
| 4 | RCSIN | Row/Column Structure Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSRCSIN | Allow NULL? |
| 5 | RSLIN | Report Selection Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSRSLIN | Allow NULL? |
| 6 | AGGDI | Aggregation | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CGSAGGDI | Allow NULL? |
| 7 | AGGTM | Aggregation based on time | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CGSAGGTM | Allow NULL? |
| 8 | AGGFI | Reference Field for Time-Based Aggregation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSAGGFI | 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 | RFTAB | Table for reference field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFTABLE | Allow NULL? |
| 12 | RFFIE | Reference field for currency and qty fields | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFFIELD | Allow NULL? |
| 13 | CQMRK | Quantity/amount/number indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSCQMRK | Allow NULL? |
| 14 | CUKY0 | Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CGSCUKY | Allow NULL? |
| 15 | UNIT0 | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CGSUNIT | Allow NULL? |
| 16 | CQFIE | Reference field for currency / unit | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSCQFIE | Allow NULL? |
| 17 | CHNAM | User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CGSCHNAM | Allow NULL? |
| 18 | CHDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CGSCHDAT | Allow NULL? |
| 19 | CHTIM | Time of Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CGSCHTIM | Allow NULL? |