SAP table T071 (FI Document Archiving - Account Lives)

SAP table T071 has 4 primary key fields being MANDT,BUKRS,KOART,VKONT.

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
BUKRS Company Code - Generic Entry Possible CHAR 4 0 BUKRS_MASK
KOART Account Type CHAR 1 0 KOART_MASK
* All account types
A Assets
D Customer accounts
K Vendor accounts
M Material
S G/L accounts
VKONT From Account CHAR 10 0 VKONT_001B
BKONT To Account CHAR 10 0 BKONT_001B
KTLFZ Account Life in Days NUMC 4 0 KTLFZ_T071
IDLFZ Life for Secondary Index in Days NUMC 4 0 IDLFZ_T071

T071 foreign key relationships

Table Field Check Table Check Field
0 T071 MANDT T000 Clients MANDT