SAP table TFK100D (Cash Desk: Cash Desk Clearing Accounts)

SAP table TFK100D has 4 primary key fields being MANDT,BUKRS,PAYTP,CDVKO.

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
PAYTP Category of Payment/Payment Lot CHAR 2 0 PAYTP_KK
* Valid for All Payment Categories
AM Account Maintenance
CH Check payment
CO Outgoing Check Payment
CP Card Payment
CS Cash payment
EX External Payment
PO Postal remittance
RD Zero Document or Collective Bill for Cash Register
CDVKO Cash Desk Clearing Account CHAR 10 0 SKAT CDVKO_KK

TFK100D foreign key relationships

Table Field Check Table Check Field
0 TFK100D BUKRS T001 Company Codes BUKRS
1 TFK100D CDVKO SKAT G/L Account Master Record (Chart of Accounts: Description) MANDT
1 TFK100D CDVKO SKAT G/L Account Master Record (Chart of Accounts: Description) SPRAS
1 TFK100D CDVKO SKAT G/L Account Master Record (Chart of Accounts: Description) KTOPL