1. Home
  2. Resources
  3. SAP Tables
  4. DFKKSUM - Posting totals from FI-CA

SAP Table DFKKSUM

Posting totals from FI-CA

DFKKSUM (Posting totals from FI-CA) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DFKKSUM to other SAP tables.

DFKKSUM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
FIKEY Reconciliation Key for General Ledger FIKEY_KK DFKKSUMC CHAR 12 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
HKONT General Ledger Account HKONT SKA1 CHAR 10 0
GSBER Business Area GSBER TGSB CHAR 4 0
KHASH Hash Code Using Account Determination Fields KHASH_KK CHAR 10 0
SUMSZ Number of Summary Records for Reconciliation Key SUMSZ_KK INT4 10 0
WAERS Currency Key WAERS TCURC CUKY 5 0
PSWSL Update Currency for General Ledger Transaction Figures PSWSL_KK CUKY 5 0
BUDAT Posting Date in the Document BUDAT_KK DATS 8 0
OPBEL Number of Contract Accts Rec. & Payable Doc. OPBEL_KK DFKKKO CHAR 12 0
OPUPK Item number in contract account document OPUPK_KK NUMC 4 0
XEIEI Line Item in Individual Document XEIEI_KK CHAR 1 0
X Yes
NULL No
BUPLA Business Place BUPLA CHAR 4 0
SEGMENT Segment for Segmental Reporting SEGMT_KK CHAR 10 0
KOSTL Cost Center KOSTL CHAR 10 0
PRCTR Profit Center PRCTR CHAR 10 0
AUFNR Order Number AUFNR CHAR 12 0
KDAUF Sales Order Number KDAUF CHAR 10 0
KDPOS Item Number in Sales Order KDPOS NUMC 6 0
KDEIN Delivery Schedule for Sales Order KDEIN NUMC 4 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PASUBNR Profitability segment changes (CO-PA) RKESUBNR NUMC 4 0
FDLEV Planning level FDLEV_KK CHAR 2 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
XSTEZ Tax item XSTEZ_KK CHAR 1 0
X Yes
NULL No
KTOSL Transaction Key KTOSL CHAR 3 0
STPRZ Tax rate STPRZ_KK NUMC 6 0
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
TXJCO Tax Jurisdiction Code (Entered value) TXJCO_KK CHAR 15 0
TXDAT Decisive Date for Calculating Taxes TXDAT_KK DATS 8 0
TXCNT Level Counter for Multi-Level Taxes in Tax Jurisdiction TXCNT_KK NUMC 1 0
KSCHL Condition Type KSCHL CHAR 4 0
BLDAT Document Date in Document BLDAT DATS 8 0
VALUT Value date VALUT DATS 8 0
VBUND Company ID of trading partner RASSC CHAR 6 0
KONTT Account Assignment Category KONTT_KK CHAR 2 0
KONTL Acct assnmnt string for industry-specific account assngments KONTL_KK CHAR 50 0
XNEGP Negative Posting XNEGP_KK CHAR 1 0
X Yes
NULL No
HBBLA Document Type for Transfer to General Ledger HBBLA_KK CHAR 2 0
LDGRP Ledger Group LDGRP_KK CHAR 4 0
XCSHA Document Contains Assignments from Cash Flows XCSHA_KK CHAR 1 0
X Yes
NULL No
REACC Originating Account in Cash Flow Anlaysis REACC_KK CHAR 10 0
REBUK Partner Company Code for Cash Flow Analysis REBUK_KK CHAR 4 0
BETRH Amount In Local Currency With +/- Signs BETRH_KK CURR 13 2
BETRW Amount in Transaction Currency with +/- Sign BETRW_KK CURR 13 2
BETR2 Amount in second parallel currency with +/- sign BETR2_KK CURR 13 2
BETR3 Amount in third parallel currency with +/- sign BETR3_KK CURR 13 2
PSWBT Amount for Updating in General Ledger PSWBT_KK CURR 13 2
SBASH Amount Subject to Tax in Local Currency (Tax Base Amount) SBASH_KK CURR 13 2
SBASW Amount Subject to Tax in Transaction Currency (Tax Base Amt) SBASW_KK CURR 13 2
STTAX Tax Amount as Statistical Information in Document Currency STTAX_KK CURR 13 2
SCTAX Tax Portion in FI-CA Local Currency SCTAX_KK CURR 13 2
MENGE Quantity MENGE_D QUAN 13 3
MEINS Base Unit of Measure MEINS UNIT 3 0
FMTYP Update Method for FM - FI-CA Integration FMTYP_KK CHAR 2 0
A Invoice
B Paid Invoice
C Clearing
D Clearing of Invoice in Prior Year
E Clearing of Invoice in Next Year
F Transfer Posting
G Payment on Account
H Down Payment
I G/L Account Transfer Posting
J Clarification Worklist
K Tax Item Created Automatically
L Invoice from Legacy System
M Reversal of Invoice in Prior Year
O Paid Invoice from Prior Year
P No Update
Q Clearing of Invoice and Credit Memo
R Clearing of Invoice and Credit Memo (Document in Prior Year)
S Clearing of Invoice and Credit Memo (Document in Next Year)
T Paid Invoice (Clearing with Credit Memo)
U Paid Invoice Prior Year (Clearing with Credit Memo)
V Posting before FM Activation
ORIGFIKRS Original FM Area for FM Account Assignment ORIGFIKRS_KK CHAR 4 0
FIPEX Commitment Item FM_FIPEX CHAR 24 0
FISTL Funds Center FISTL CHAR 16 0
FONDS Fund BP_GEBER CHAR 10 0
FKBER Functional Area FKBER CHAR 16 0
MEASURE Funded Program FM_MEASURE CHAR 24 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
BUDGETYEAR Original Year for FM Account Assignment FM_START_OF_CHAIN NUMC 4 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
KORRL Correction level for incorrect totals records KORRL_KK NUMC 2 0
UEBUD Alternative posting date for transfer to general ledger UEBUD_KK DATS 8 0
SNPER Special period for transferring postings to general ledger SNPER_KK NUMC 2 0
XKONTNEU Account Assignments Were Changed (Transfer To G/L) XKONTNEU_KK CHAR 1 0
X TRUE
NULL FALSE
REVSR Record Counter of Summary Record Reversed REVSR_KK INT4 10 0
XNEGK Negative Posting XNEGP_KK CHAR 1 0
X Yes
NULL No
VATDATE Tax Reporting Date VATDATE_KK DATS 8 0
WNPER Requested Special Period for Transfer to General Ledger WNPER_KK NUMC 2 0

DFKKSUM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DFKKSUM BUKRS DFKKSUM MANDT T001 Company Codes MANDT
DFKKSUM BUKRS DFKKSUM BUKRS T001 Company Codes BUKRS
DFKKSUM FIKEY DFKKSUM MANDT DFKKSUMC Control details for posting totals MANDT
DFKKSUM FIKEY DFKKSUM FIKEY DFKKSUMC Control details for posting totals FIKEY
DFKKSUM GSBER DFKKSUM MANDT TGSB Business Areas MANDT
DFKKSUM GSBER DFKKSUM GSBER TGSB Business Areas GSBER
DFKKSUM HKONT DFKKSUM MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
DFKKSUM HKONT T001 KTOPL SKA1 G/L Account Master (Chart of Accounts) KTOPL
DFKKSUM HKONT DFKKSUM HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
DFKKSUM OPBEL DFKKSUM MANDT DFKKKO Header Data in Open Item Accounting Document MANDT
DFKKSUM OPBEL DFKKSUM OPBEL DFKKKO Header Data in Open Item Accounting Document OPBEL
DFKKSUM WAERS DFKKSUM WAERS TCURC Currency Codes WAERS
DFKKSUM WAERS DFKKSUM MANDT TCURC Currency Codes MANDT