SAP table T011 (Financial Statement Versions)
SAP table T011 has 2 primary key fields being MANDT,VERSN.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| VERSN | Financial Statement Version | CHAR | 4 | 0 | VERSN_011 | ||
| DSPRA | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| ASPRA | Alternative Languages | CHAR | 10 | 0 | ASPRA | ||
| XERGS | Financial Statement Version Uses Group Chart of Accounts | CHAR | 1 | 0 | XERGS_011 | ||
| KTOPL | Financial Statement Version Uses Only One Chart of Accounts | CHAR | 4 | 0 | T004 | KTOPL_011 | |
| AKTVA | Item Key Representing the Assets | CHAR | 10 | 0 | AKTVA_011 | ||
| PSSVA | Item Key Representing the Liabilities | CHAR | 10 | 0 | PSSVA_011 | ||
| ERGAK | Item Key Representing the Line Item Net Loss | CHAR | 10 | 0 | ERGAK_011 | ||
| ERGPA | Fin.Statement Key Representing the Net Profit/Yr | CHAR | 10 | 0 | ERGPA_011 | ||
| ERGGV | Fin.Statement Key Representing the P+L Profit Item | CHAR | 10 | 0 | ERGGV_011 | ||
| ZUORD | Item Key Representing the Non-Assignable Accounts | CHAR | 10 | 0 | DZUORD_011 | ||
| XAUTO | Indicator: Automatically Allocate Item Keys | CHAR | 1 | 0 | XAUTO_011 | ||
| XFBER | Indicator: Assignment of Functional Areas Is Permitted | CHAR | 1 | 0 | XFBER_011 | ||
| ANHNG | Item Key That Represents the Notes to Financial Statements | CHAR | 10 | 0 | ANHNG_011 |
T011 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T011 | DSPRA | T002 | Language Keys (Component BC-I18) | SPRAS |
| 1 T011 | KTOPL | T004 | Directory of Charts of Accounts | MANDT |
| 0 T011 | MANDT | T000 | Clients | MANDT |