SAP table TFK001B (Company Codes in Contract Accounts Receivable and Payable)

SAP table TFK001B has 2 primary key fields being MANDT,BUKRS.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
OPBUK Company Code Group CHAR 4 0 OPBUK_KK
XAKOZ Create Payments on Account in Standard Company Code CHAR 1 0 XAKOZ_KK
XFAER Include All Receivables In Total Invoice CHAR 1 0 XFAER_KK
PCTOP Profit Center in Business Partner Items CHAR 1 0 PCTOP_KK
Not Allowed
1 Allowed
TXAAR Splitting of Tax Items by Account Assignment CHAR 1 0 TXAAR_KK
No Distribution by Account Assignments
1 Distribution Active, No Separate Tax Reporting Data
2 Distribution Active, Separate Tax Reporting Data
ABSCH Component for Reconciling Check Encashment CHAR 1 0 ABSCH_KK
General Ledger Accounting
1 Contract Accounts Receivable and Payable
XAWML Foreign Trade Reporting Active for Company Code CHAR 1 0 XAWML_KK
Not Active
X Active for Reporting Payments
Y Active for Reporting Receivables and Payables
XAKAN Post Payments on Account as Down Payments CHAR 1 0 XAKAN_KK
XSTZA Automatic Assignment for Reversed Payment Order CHAR 1 0 XSTZA_KK
XNORA No Retroactive Clearing Permitted CHAR 1 0 XNORA_KK
XESCH Check Escheatment Process Active CHAR 1 0 XESCH_KK
XDISM Dispute Management: Dispute Case Processing Active CHAR 1 0 XDISM_KK
BWPLV Valuation Plan Variant CHAR 2 0 TFK044F BWPLV_KK
GRPLVL Master Data Grouping Level CHAR 1 0 GRPLVL_CM_KK
K Contract Account
V Contract
XCFAN Cash Flow Analysis Active CHAR 1 0 XCFAN_KK
SEGFD Posting Date As of Which Segment Is Posted DATS 8 0 SEGFD_KK
RVATD Rule for Determining Tax Reporting Date CHAR 1 0 RVATD_KK
No Tax Date
1 Document Date Is Tax Date
2 Posting Date Is Tax Date
XTFUL Tax Settlement Date Entry Active CHAR 1 0 XTFUL_KK
XWTAC Extended Withholding Tax Active CHAR 1 0 XWTAC_KK
XQLND Determine WHT Country/Region from Supplied Country CHAR 1 0 XQLND_KK
XCRAN Execute Tax on Sales/Purchases Posting at Clearing CHAR 1 0 XCRAN_KK
PRLPO Usage of Provisional Postings CHAR 1 0 PRLPO_KK
Is Not Allowed
1 Is Allowed Without Ledger Group
2 Is Allowed with and Without Ledger Group
XBRACTIV Activate Settings for Brazil CHAR 1 0 XBRACTIV_KK
XDPTX Down Payments with Multi-Level Tax Allowed CHAR 1 0 XDPTX_KK
XPDCA Postdated Checks Allowed CHAR 1 0 XPDCA_KK
XTAXX Alternative Exchange Rate for Tax Items (Local Currency 1) CHAR 1 0 XTAXX_KK
XASKZ Alternative Tax Determination Code Active CHAR 1 0 XASKZ_KK
XFLOC Foreign Currency Valuation Based on First Local Currency CHAR 1 0 XFLOC_KK
XRTPA Real-Time Payments Allowed CHAR 1 0 XRTPA_KK
XCOLI Co-Liability Active CHAR 1 0 XCOLI_KK
XFCTA Factoring Is Active. CHAR 1 0 XFCTA_KK
XEXOT Current Exchange Rate with Payment Difference CHAR 1 0 XEXOT_KK
XUTDD Determinr default for tax date for company code. CHAR 1 0 XUTDD_KK
XCTRD Tax date from statistical receivable when cleared? CHAR 1 0 XCTRD_KK
XFVAD Foreign Currency Valuation for Value Adjustment CHAR 1 0 XFVAD_KK
XSEGO Segment Optional in Contract Accounts Receivable/Payable CHAR 1 0 XSEGO_KK
XMLPA Machine Learning Active for Payment Assignment CHAR 1 0 XMLPA_KK
XCASA Cash Management: Forward Reconciliation Acct f. Receivables? CHAR 1 0 XCASH_AKONT_KK
DPRUN Cash Management: Determine Payability via Payment Run? CHAR 1 0 DPRUN_KK
1 Check Line Item and Contract Account
XMOFF Cash Management: Mark Settlements as Offset Postings CHAR 1 0 XMOFF_KK

TFK001B foreign key relationships

Table Field Check Table Check Field
0 TFK001B BUKRS T001 Company Codes BUKRS
1 TFK001B BWPLV TFK044F Valuation Plan Variants BWPLV