DFKKSUM SAP table for – Posting totals from FI-CA

Here we would like to draw your attention to DFKKSUM table in SAP. As we know it is being mainly used with the SAP FI-CA (Contract Accounts Receivable and Payable in FI) component which is coming under FI module (Financial Accounting). DFKKSUM is a SAP standard transp table used for storing Posting totals from FI-CA related data in SAP. It comes under the package FKKB.

SAP DFKKSUM table

Table DFKKSUM technical data

TableDFKKSUM
Data storingPosting totals from FI-CA
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKSUM Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in DFKKSUM table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • FIKEY : Reconciliation Key for General Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • SHKZG : Debit/Credit Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • HKONT : General Ledger Account
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GSBER : Business Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • KHASH : Hash Code Using Account Determination Fields
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • SUMSZ : Number of Summary Records for Reconciliation Key
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PSWSL : Update Currency for General Ledger Transaction Figures
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its data type is CHAR (Character String) with field length 12
  • OPUPK : Item number in contract account document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • XEIEI : Line Item in Individual Document
    Its data type is CHAR (Character String) with field length 1
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • KDAUF : Sales Order Number
    Its data type is CHAR (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • KDEIN : Delivery schedule for sales order
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • PASUBNR : Profitability Segment Changes (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FDLEV : Planning level
    Its data type is CHAR (Character String) with field length 2
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • XSTEZ : Tax item
    Its data type is CHAR (Character String) with field length 1
  • KTOSL : Transaction Key
    Its data type is CHAR (Character String) with field length 3
  • STPRZ : Tax rate
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • TXJCO : Jurisdiction code (specified value)
    Its data type is CHAR (Character String) with field length 15
  • TXDAT : Decisive Date for Calculating Taxes
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TXCNT : Level Counter for Multi-Level Taxes in Tax Jurisdiction
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • KSCHL : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • KONTT : Account Assignment Category
    Its data type is CHAR (Character String) with field length 2
  • KONTL : Acct assnmnt string for industry-specific account assngments
    Its data type is CHAR (Character String) with field length 50
  • XNEGP : Negative Posting
    Its data type is CHAR (Character String) with field length 1
  • HBBLA : Document Type for Transfer to General Ledger
    Its data type is CHAR (Character String) with field length 2
  • BETRH : Amount In Local Currency With +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • BETR2 : Amount in second parallel currency with +/- sign
    Its data type is CURR (Currency Field) with field length 13
  • BETR3 : Amount in third parallel currency with +/- sign
    Its data type is CURR (Currency Field) with field length 13
  • PSWBT : Amount for Updating in General Ledger
    Its data type is CURR (Currency Field) with field length 13
  • SBASH : Amount Subject to Tax in Local Currency (Tax Base Amount)
    Its data type is CURR (Currency Field) with field length 13
  • SBASW : Amount Subject to Tax in Transaction Currency (Tax Base Amt)
    Its data type is CURR (Currency Field) with field length 13
  • STTAX : Tax Amount as Statistical Information in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • SCTAX : Tax Portion in FI-CA Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • MENGE : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : FM Account Assignments for FI-CA Including Type
  • FMTYP : Update Method for FM – FI-CA Integration
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Funds Management Account Assignments for FI-CA
  • ORIGFIKRS : Original FM Area for FM Account Assignment
    Its data type is CHAR (Character String) with field length 4
  • FIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • FISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • FONDS : Fund
    Its data type is CHAR (Character String) with field length 10
  • FKBER : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • BUDGETYEAR : Original Year for FM Account Assignment
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUDGET_PD : FM: Budget Period
    Its data type is CHAR (Character String) with field length 10
  • KORRL : Correction level for incorrect totals records
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • UEBUD : Alternative posting date for transfer to general ledger
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SNPER : Special period for transferring postings to general ledger
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • XKONTNEU : Account Assignments Were Changed (Transfer To G/L)
    Its data type is CHAR (Character String) with field length 1
  • REVSR : Record Counter of Summary Record Reversed
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • XNEGK : Negative Posting
    Its data type is CHAR (Character String) with field length 1