| 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 | T000 | MANDT | Allow NULL? |
| 2 | SEQNR | Sequence number | char | 1 | 0 | NUMC | (N'0') | No | | FC_SEQNR | Allow NULL? |
| 3 | ALPHA | ALPHA conversion of consolidation groups and units | char | 1 | 0 | CHAR | (N' ') | No | | FC_ALPHA | Allow NULL? |
| 4 | ALPHB | ALPHA conversion of FS items | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_ALPHB | Allow NULL? |
| 5 | MONITOR | Status management activated | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_MONITOR | Allow NULL? |
| 6 | PEROPEN | Open periods explicitly in the monitor | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_PEROPEN | Allow NULL? |
| 7 | CONSCHECK | Consistency Check Activated | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CONSCHK | Allow NULL? |
| 8 | STLGH | Length of the subitem category | char | 1 | 0 | NUMC | (N'0') | Yes | | FC_STLGH | Allow NULL? |
| 9 | VALLGH | Length of value fields (list processor) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | FC_VALLGH | Allow NULL? |
| 10 | CISTI | Display statistical items in C/I audit trail | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_CISTI | Allow NULL? |
| 11 | EXRTYPD | Default exchange rate type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCURV | FC_EXRTYPD | Allow NULL? |
| 12 | PRGRPUSE | Type of product group usage | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_PRGRPUSE | Allow NULL? |
| 13 | SIITGRPIGN | Ignore the breakdown category of the totals items | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_SUMIT_ITGRP_IGNORE | Allow NULL? |
| 14 | MAXSET | Maximum Sets Active | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_MAXSET | Allow NULL? |
| 15 | REP_PERIV | Fiscal Year Variant for Reporting | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T009 | FC_REP_PERIV | Allow NULL? |
| 16 | DEFRM_LOCK | Block Online Data Entry per Layout | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_DEFRM_LOCK | Allow NULL? |
| 17 | BCF_CORR1 | Adjustment in period 1 for repetition of carryforward | char | 1 | 0 | CHAR | (N' ') | Yes | | FC_BCF_CORR1 | Allow NULL? |
