SAP table T011_XBRL (Fin. Statement Vers. from XBRL Taxonomies)

SAP table T011_XBRL 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 FS Version or Asset History Sheet from XBRL Taxonomy CHAR 30 0 VERSN_011_XBRL
STRTYPE Type of Financial Statement Version from XBRL Taxonomy CHAR 5 0 FAGL_FSV_TYPE
AHS Asset History Sheet
AHSS Asset History Sheet (Short Form)
BS Balance Sheet
BSIS Balance Sheet and Income Statement
IS Income Statement
DSPRA Language Key LANG 1 0 T002 SPRAS
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
XAUTO Indicator: Automatically Allocate Item Keys CHAR 1 0 XAUTO_011
XFBER Indicator: Assignment of Functional Areas Is Permitted CHAR 1 0 XFBER_011
LEADINGFILE Entry Schema of an XBRL Taxonomy CHAR 255 0 FAGL_FSV_XBRL_LEADINGFILE
TAXTYPE Type of XBRL Taxonomy CHAR 5 0 FAGL_FSV_XBRL_TAXONOMY
AHS Asset History Sheet
BANK Bank Taxonomy
BRNCH Industry Taxonomy
CORE Core Taxonomy
INS Insurance Taxonomy
PI Taxonomy for Payment Institutions
BRANCH Industry of XBRL Industry Taxonomy CHAR 5 0 FAGL_FSV_XBRL_BRANCH_BRA
99999 All Industries
EBV Municipal Enterprises
KHBV Hospitals
LUF Agriculture and Forestry
PBV Nursing Providers
VUV Transport Companies
WUV Housing Industry
LEGALFORM Legal Form of XBRL Banking Taxonomy CHAR 5 0 FAGL_FSV_XBRL_LEGALFORM_CORE
99999 All Legal Forms of Companies
EU Individual Enterprise
KST Corporation
PG Partnership
PLFORMAT Income Statement Format of XBRL Core Taxonomy CHAR 5 0 FAGL_FSV_XBRL_PLFORMAT_CORE
99999 All Income Statement Formats
GKV Period Accounting
UKV Cost of Sales Accounting (CSA)
CLOSETYPE Closing Type of XBRL Taxonomy CHAR 5 0 FAGL_FSV_XBRL_CLOSETYPE_CORE
99999 All Closing Types
FISC Under Tax Law
HGB Under Commercial Law
KINDOFINST Credit Institution Type of XBRL Banking Taxonomy CHAR 10 0 FAGL_FSV_XBRL_KINDOFINST_BANK
99999 All Credit Institution Types
BSPK Building and Loan Associations
FINDNSTL Financial Service Providers
GIROZ Central Clearing Banks
KAPANLG Capital Investment Companies
KREDG Credit Unions
KREDGWG Credit Unions with Commodity Trading
PFBB Mortgage Bond Banks
PFBBOERA Mortgage Bond Banks and Public Law Institutions
PFBG PfandBG
SKONTRO Lead Brokers
SPARK Savings Banks
UNII Universal Institutes
ZENTRB Central Banks
KINDOFBUS Insurer Type of XBRL Insurance Taxonomy CHAR 5 0 FAGL_FSV_XBRL_KINDOFBUS_INS
99999 All Insurance Types
LKV Life/Health Insurance
LUV Life Insurance with Direct Accident Insurance Business
PF Pension Fund Acc. to RechPensV
PSK Pension/Death Benefit Fund
RV Reinsurance
SUK Indemnity/Accident Insurance with Direct HI Ins. Business
SUV Indemnity/Accident Insurance
LEGALFORM_INS Legal Form of XBRL Insurance Taxonomy CHAR 5 0 FAGL_FSV_XBRL_LEGALFORM_INS
99999 All Legal Forms of Companies
BNAU Branch of Foreign Insurance Company
OERV Public Insurance Company
SEAG Stock Cooperation/European Company
VVAG Mutual Insurance Association
SOERGBIL Financial Statement Structure for Spec./Suppl. Balance Sheet CHAR 1 0 FAGL_FSV_XBRL_COMPL_TAX_BS
No
Y Yes
INCOMEUSE Appropriation of Net Income CHAR 1 0 FAGL_FSV_XBRL_INCOME_USE
No
Y Yes

T011_XBRL foreign key relationships

Table Field Check Table Check Field
0 T011_XBRL DSPRA T002 Language Keys (Component BC-I18) SPRAS
1 T011_XBRL KTOPL T004 Directory of Charts of Accounts MANDT
0 T011_XBRL MANDT T000 Clients MANDT