SAP table TFKTVO (Subtransactions in Contract Accounts Receivable and Payable)

SAP table TFKTVO has 4 primary key fields being MANDT,APPLK,HVORG,TVORG.

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
HVORG Main Transaction for Line Item CHAR 4 0 TFKHVO HVORG_KK
TVORG Subtransaction for Document Item CHAR 4 0 TVORG_KK
HVORG_REV Main Transaction for Offsetting Item for Reversal CHAR 4 0 TFKHVO HVORG_REV_KK
TVORG_REV Subtransaction for Offsetting Item for Reversal CHAR 4 0 TFKTVO TVORG_REV_KK
HVORG_SPL Main Transaction for Distribution with Plus/Minus Change CHAR 4 0 TFKHVO HVORG_SPL_KK
TVORG_SPL Subtransaction for Distribution with Sign Change CHAR 4 0 TFKTVO TVORG_SPL_KK
FAETP Special Due Date Determination CHAR 1 0 FAETP_KK
1 Posting Date
2 Document date
3 Current date
QSVTP Withholding Tax Amount Type CHAR 1 0 QSVTP_KK
1 Customer can withhold
2 We can withhold
RLADDR Rule For Additional Receivable CHAR 2 0 TFK058 RLADDR_KK
XPAYT Payment Transaction CHAR 1 0 XPAYT_KK
XNEGA Clearing Must Be Negative Posting CHAR 1 0 XNEGA_KK
TRTRG Transfer: Identification of Subledger CHAR 5 0 TRTRG_KK
FIAP FI-AP Accounts Payable Accounting
FIAR FI-AR Accounts Receivable Accounting
BSCHL Posting Key CHAR 2 0 TBSL BSCHL
UMSKZ Special G/L Indicator CHAR 1 0 T074U UMSKZ

TFKTVO foreign key relationships

Table Field Check Table Check Field
0 TFKTVO BSCHL TBSL Posting Key MANDT
0 TFKTVO BSCHL TBSL Posting Key BSCHL
1 TFKTVO HVORG TFKHVO Main transactions in contract accts receivable and payable MANDT
1 TFKTVO HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
0 TFKTVO HVORG_REV TFKHVO Main transactions in contract accts receivable and payable MANDT
0 TFKTVO HVORG_REV TFKHVO Main transactions in contract accts receivable and payable HVORG
1 TFKTVO HVORG_SPL TFKHVO Main transactions in contract accts receivable and payable MANDT
1 TFKTVO HVORG_SPL TFKHVO Main transactions in contract accts receivable and payable HVORG
0 TFKTVO RLADDR TFK058 FI-CA: Rules for Additional Receivables MANDT
0 TFKTVO RLADDR TFK058 FI-CA: Rules for Additional Receivables RLADDR
1 TFKTVO TVORG_REV TFKTVO Subtransactions in Contract Accounts Receivable and Payable HVORG
1 TFKTVO TVORG_REV TFKTVO Subtransactions in Contract Accounts Receivable and Payable TVORG
0 TFKTVO TVORG_SPL TFKTVO Subtransactions in Contract Accounts Receivable and Payable HVORG
0 TFKTVO TVORG_SPL TFKTVO Subtransactions in Contract Accounts Receivable and Payable TVORG
1 TFKTVO UMSKZ T074U Special G/L Indicator Properties MANDT