| 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 | USGFL | Use flag | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSUSGFL | Allow NULL? |
| 4 | ROLNM | Data element (semantic domain) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ROLLNAME | Allow NULL? |
| 5 | TIMFL | Flag: Field with time dimension | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSTIMFL | Allow NULL? |
| 6 | CHTAB | Check table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CGSCHTAB | Allow NULL? |
| 7 | CHFIE | Check table field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSCHFIE | Allow NULL? |
| 8 | VALEX | Flag: Domain values | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSVALEX | Allow NULL? |
| 9 | FIXVL | Constant (value of characteristic) | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | CGSFIXVL | Allow NULL? |
| 10 | TIMLC | Time logic | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSTIMLC | Allow NULL? |
| 11 | RETAB | Read (text) table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CGSRETAB | Allow NULL? |
| 12 | REFIE | Read (text) field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSREFIE | Allow NULL? |
| 13 | REFIL | Long Text Field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSREFIL | Allow NULL? |
| 14 | REFLL | Length of long text field | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | CGSREFLL | Allow NULL? |
| 15 | VIEWN | View name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSVIEWN | Allow NULL? |
| 16 | TCDIS | Transaction Code: Display Characteristic Values | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | CGSTCDIS | Allow NULL? |
| 17 | TCMOD | Transaction Code: Change Characteristic Values | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | CGSTCMOD | Allow NULL? |
| 18 | ATRFB | Function Module for Reading Attributes | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGDATRFB | Allow NULL? |
| 19 | SPCTR | Special handling of fields of an operating concern | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | RKE_SHANDLING | Allow NULL? |
| 20 | ORTAB | Origin Table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CGSORTAB | Allow NULL? |
| 21 | ORFIE | Origin field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSORFIE | Allow NULL? |
| 22 | OAPPL | Source application | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CGSOAPPL | Allow NULL? |
| 23 | OAFIE | Original field (of the application) | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSOAFIE | Allow NULL? |
| 24 | DIMPR | Characteristic Display | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSDIMPR | Allow NULL? |
| 25 | REPIN | Report Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSREPIN | Allow NULL? |
| 26 | PLAIN | Planning Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSPLAIN | Allow NULL? |
| 27 | LITIN | Line Item Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSLITIN | Allow NULL? |
| 28 | RCSIN | Row/Column Structure Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSRCSIN | Allow NULL? |
| 29 | RSLIN | Report Selection Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSRSLIN | Allow NULL? |
| 30 | CHAIN | Characteristic Value Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSCHAIN | Allow NULL? |
| 31 | AGGDI | Aggregation | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CGSAGGDI | Allow NULL? |
| 32 | AGGTM | Aggregation based on time | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | CGSAGGTM | Allow NULL? |
| 33 | AGGFI | Reference Field for Time-Based Aggregation | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSAGGFI | Allow NULL? |
| 34 | PRDEC | Decimal Places (Output) | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSDEC | Allow NULL? |
| 35 | PRSNT | Scaling factor | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSPRS | Allow NULL? |
| 36 | SBGRP | Key figure groups | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TKCKU | CGSSBGRP | Allow NULL? |
| 37 | CCNUM | Currency Translation Number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CGSCCNUM | Allow NULL? |
| 38 | DCURR | Target Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CGSDCURR | Allow NULL? |
| 39 | RFTAB | Table for reference field | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFTABLE | Allow NULL? |
| 40 | RFFIE | Reference field for currency and qty fields | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | REFFIELD | Allow NULL? |
| 41 | DSRFF | Reference field in the data structure | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSDSRFF | Allow NULL? |
| 42 | CQMRK | Quantity/amount/number indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSCQMRK | Allow NULL? |
| 43 | CUKY0 | Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CGSCUKY | Allow NULL? |
| 44 | UNIT0 | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | CGSUNIT | Allow NULL? |
| 45 | CQFIE | Reference field for currency / unit | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | CGSCQFIE | Allow NULL? |
| 46 | TFLAG | Flag: Text | char | 1 | 0 | CHAR | (N' ') | Yes | | CGSTFLAG | Allow NULL? |
| 47 | COBJID | Folder Entry ID (Obj+Fol+Forwarder Name) | nvarchar | 46 | 0 | CHAR | (N' ') | Yes | | SO_ENTRYID | Allow NULL? |
| 48 | DMAC | Matchcode | nvarchar | 31 | 0 | CHAR | (N' ') | Yes | | CGSDMAC | Allow NULL? |
| 49 | CHNAM | User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CGSCHNAM | Allow NULL? |
| 50 | CHDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CGSCHDAT | Allow NULL? |
| 51 | CHTIM | Time of Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | CGSCHTIM | Allow NULL? |
