SAP table TKKVHVTVT (FS-CD Transactions: Texts)

SAP table TKKVHVTVT has 7 primary key fields being MANDT,SPRAS,APPLK,HVORG,TVORG,BUKRS,PRGRP.

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
SPRAS Language Key LANG 1 0 T002 SPRAS
APPLK Application Area CHAR 1 0 TKKVHVTV 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
HVORG Main Transaction for Line Item CHAR 4 0 TFKHVO HVORG_KK
TVORG Subtransaction for Document Item CHAR 4 0 TFKTVO TVORG_KK
BUKRS Company Code CHAR 4 0 T001 BUKRS
PRGRP Product Group CHAR 2 0 TKKVPRGRP PRGRP_VK
TXT30 Text CHAR 30 0 TXT30

TKKVHVTVT foreign key relationships

Table Field Check Table Check Field
0 TKKVHVTVT APPLK TKKVHVTV FS-CD Transactions MANDT
0 TKKVHVTVT APPLK TKKVHVTV FS-CD Transactions HVORG
0 TKKVHVTVT APPLK TKKVHVTV FS-CD Transactions TVORG
0 TKKVHVTVT APPLK TKKVHVTV FS-CD Transactions BUKRS
1 TKKVHVTVT BUKRS T001 Company Codes BUKRS
0 TKKVHVTVT HVORG TFKHVO Main transactions in contract accts receivable and payable MANDT
0 TKKVHVTVT HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
1 TKKVHVTVT PRGRP TKKVPRGRP Product Groups BUKRS
0 TKKVHVTVT SPRAS T002 Language Keys (Component BC-I18) SPRAS
1 TKKVHVTVT TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable HVORG
1 TKKVHVTVT TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable TVORG