SAP table FKKVK (Contract Account Header)
SAP table FKKVK has 2 primary key fields being MANDT,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
Client
CLNT
3
0
T000
MANDT
Contract Account Number
CHAR
12
0
VKONT_KK
ERDAT
Date on which the record was created
DATS
8
0
ERDAT
ERNAM
Name of Person Responsible for Creating the Object
CHAR
12
0
ERNAM
LOEVM
Mark Contract Account for Deletion
CHAR
1
0
LOEVM_KK
AEDAT
Last Changed On
DATS
8
0
AEDAT
AENAM
Name of Person Who Changed Object
CHAR
12
0
AENAM
APPLK
Application Area
CHAR
1
0
APPLK_KK
Possible values
*
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
TFK002A
VKTYP_KK
VKONA
Contract account number in legacy system
CHAR
20
0
VKONA_KK
VKBEZ
Contract account name
CHAR
35
0
VKBEZ_KK
FKKVK foreign key relationships
Table
Field
Check Table
Check Field
0 FKKVK
MANDT
T000 Clients
MANDT
1 FKKVK
VKTYP
TFK002A Contract Account Categories
VKTYP