SAP table TFK002A (Contract Account Categories)

SAP table TFK002A has 3 primary key fields being MANDT,APPLK,VKTYP.

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 MANDT
APPLK Application Area CHAR 1 0 APPLK_KK
* Valid for all application areas
C Convergent FI-CA
M Media Companies
P Public Administration
R Utility company
S Extended FI-CA
T Telecommunications
V Insurance company
X In-house development
VKTYP Contract Account Category CHAR 2 0 VKTYP_KK
XGEIN Only One Business Partner Allowed CHAR 1 0 XGEIN_KK
SAMRG Contract Account is Collective Bill Account CHAR 1 0 SAMRG_KK
Normal account
X Account for collective bills
CPD Contract Account is a One-Time Account CHAR 1 0 CPD_KK
NRINT Number range for internal number assignment CHAR 2 0 FKK_NRIV_INT NRINT_KK
NREXT Number range for external number assignment CHAR 2 0 FKK_NRIV_EXT NREXT_KK
NREXT2 Number range for external number assignment CHAR 2 0 FKK_NRIV_EXT NREXT_KK
NOONL Online Maintenance Not Permitted CHAR 1 0 NOONL_KK
XVEIN Only One Contract Permitted CHAR 1 0 XVEIN_KK
XKART Account is managed as a customer or vendor account CHAR 1 0 XKART_KK
1 Customer
2 Vendor
VKTAU Check Authorization for Contract Acct Categy in Search Help CHAR 1 0 VKTAU_KK
FELDSTLST1 Field Status Bar CHAR 250 0 BU_FLDSTLS
FELDSTLST2 Field Status Bar CHAR 250 0 BU_FLDSTLS
FELDSTLST3 Field Status Bar CHAR 250 0 BU_FLDSTLS
FELDSTLST4 Field Status Bar CHAR 250 0 BU_FLDSTLS
FELDSTLST5 Field Status Bar CHAR 250 0 BU_FLDSTLS
FELDSTLST6 Field Status Bar CHAR 250 0 BU_FLDSTLS
FELDSTLST7 Field Status Bar CHAR 250 0 BU_FLDSTLS
XDEPOT Indicator: Deposit Account CHAR 1 0 XDEPOT_VK
XDEPOTIOB Indicator: Account Contains Deposit Contracts CHAR 1 0 XDEPOTIOB_VK
CRTVAR IO: Creation Variant for Automatic Account Creation CHAR 2 0 TIMA_CRT_ACC CRTVAR_MD
KKSALD Clearing on Open Acct Basis Active with Balance Carryforward CHAR 1 0 KKSALD_AKT_VK
INTLV Integration Schema for Contract Account CHAR 4 0 TFK002I INTLV_KK

TFK002A foreign key relationships

Table Field Check Table Check Field
0 TFK002A CRTVAR TIMA_CRT_ACC IO: Creation Variants for Account Creation CRTVAR
1 TFK002A NREXT FKK_NRIV_EXT Generated Table for View CLIENT
1 TFK002A NREXT FKK_NRIV_EXT Generated Table for View NRRANGENR
0 TFK002A NREXT2 FKK_NRIV_EXT Generated Table for View CLIENT
0 TFK002A NREXT2 FKK_NRIV_EXT Generated Table for View NRRANGENR
1 TFK002A NRINT FKK_NRIV_INT Generated Table for View CLIENT
1 TFK002A NRINT FKK_NRIV_INT Generated Table for View NRRANGENR