| 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 | VERSN | Financial Statement Version | nvarchar | 4 | 0 | CHAR | (N' ') | No | | VERSN_011 | Allow NULL? |
| 3 | DSPRA | Language Key | char | 1 | 0 | LANG | (N' ') | No | T002 | SPRAS | Allow NULL? |
| 4 | ASPRA | Alternative languages | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ASPRA | Allow NULL? |
| 5 | XERGS | Financial Statement Version Uses Group Chart of Accounts | char | 1 | 0 | CHAR | (N' ') | No | | XERGS_011 | Allow NULL? |
| 6 | KTOPL | Financial Statement Version Uses Only One Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | No | T004 | KTOPL_011 | Allow NULL? |
| 7 | AKTVA | Item key representing the assets | nvarchar | 10 | 0 | CHAR | (N' ') | No | | AKTVA_011 | Allow NULL? |
| 8 | PSSVA | Item Key Representing the Liabilities | nvarchar | 10 | 0 | CHAR | (N' ') | No | | PSSVA_011 | Allow NULL? |
| 9 | ERGAK | Item key representing the line item net loss | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ERGAK_011 | Allow NULL? |
| 10 | ERGPA | Fin.statement key representing the net profit/yr | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ERGPA_011 | Allow NULL? |
| 11 | ERGGV | Fin.statement key representing the P+L profit item | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ERGGV_011 | Allow NULL? |
| 12 | ZUORD | Item key representing the non-assignable accounts | nvarchar | 10 | 0 | CHAR | (N' ') | No | | DZUORD_011 | Allow NULL? |
| 13 | XAUTO | Indicator: automatically allocate item keys | char | 1 | 0 | CHAR | (N' ') | No | | XAUTO_011 | Allow NULL? |
| 14 | XFBER | Indicator: assignment of functional areas is permitted | char | 1 | 0 | CHAR | (N' ') | Yes | | XFBER_011 | Allow NULL? |
| 15 | ANHNG | Item key that represents notes to financial statements | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ANHNG_011 | Allow NULL? |
