DFKKSUM

Posting totals from FI-CA | #masterdata | Component: Contract Accounts Receivable and Payable
Column Name Description
MANDT Client
BUKRS FK Company Code
FIKEY FK Reconciliation Key for General Ledger
SHKZG Debit/Credit Indicator Show values
HKONT FK General Ledger Account
GSBER FK Business Area
KHASH Hash Code Using Account Determination Fields
SUMSZ Number of Summary Records for Reconciliation Key
Column Name Description
💲 Currency Key (T001.WAERS):
BETRH Amount In Local Currency With +/- Signs
BETRW Amount in Transaction Currency with +/- Sign
SBASH Amount Subject to Tax in Local Currency (Tax Base Amount)
SBASW Amount Subject to Tax in Transaction Currency (Tax Base Amt)
NDTAX Non-Deductible Tax Amount in Document Currency
NDTXH Non-Deductible Tax Amount in Local Currency
STTAX Tax Amount as Statistical Information in Document Currency
SCTAX Tax Portion in FI-CA Local Currency
BETR2 Amount in Second Parallel Currency with +/- Sign
BETR3 Amount in Third Parallel Currency with +/- Sign
💲 Update Currency for General Ledger Transaction Figures (PSWSL):
PSWBT Amount for Updating in General Ledger
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Quantity
Column Name Description
BUDAT Posting Date in the Document
TXDAT Decisive Date for Calculating Taxes
BLDAT Document Date in Document
VALUT Value date
UEBUD Alternative posting date for transfer to general ledger
VATDATE Tax Reporting Date
TXDAT_FROM Valid-From Date of the Tax Rate
Column Name Description
SHKZG Debit/Credit Indicator Show values
XEIEI Line Item in Individual Document Show values
XSTEZ Tax Item Show values
XNEGP Negative Posting Show values
XCSHA Document Contains Assignments from Cash Flows Show values
XNDTX Contains Non-Deductible Input Tax Show values
SQUAN Quantity +/- Sign Show values
FMTYP Update Method for FM - FI-CA Integration Show values
XKONTNEU Account Assignments Were Changed (Transfer To G/L) Show values
XNEGK Negative Posting Show values
XDIRTR Direct Transfer to G/L Accounting Show values
Column Name Description Domain name
OPUPK Item Number in FI-CA Document OPUPK_KK
BUPLA Business Place J_1BBRANCH
SEGMENT Segment for Segmental Reporting FB_SEGMENT
KOSTL Cost Center KOSTL
PRCTR Profit Center PRCTR
AUFNR Order Number AUFNR
KDAUF Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
KDEIN Delivery schedule for sales order NUM04
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSNR
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR
PASUBNR Profitability Segment Changes (CO-PA) RKESUBNR
FDLEV Planning level FDLEV
MWSKZ Tax on sales/purchases code MWSKZ
KTOSL Transaction Key CHAR3
STPRZ Tax rate STPRZ_KK
TXJCD Tax Jurisdiction TXJCD
TXJCO Tax Jurisdiction Code (Entered value) TXJCD
TXCNT Level Counter for Multi-Level Taxes in Tax Jurisdiction NUM01
KSCHL Condition Type KSCHL
VBUND Company ID of Trading Partner RCOMP
KONTT Account Assignment Category KONTT_KK
KONTL Acct assnmnt string for industry-specific account assngments CHAR50
HBBLA Document Type for Transfer to General Ledger BLART
LDGRP Ledger Group FAGL_LDGRP
REACC Originating Account in Cash Flow Anlaysis SAKNR
REBUK Partner Company Code for Cash Flow Analysis BUKRS
ORIGFIKRS Original FM Area for FM Account Assignment FIKRS
FIPEX Commitment Item FM_FIPEX
FISTL Funds Center FISTL
FONDS Fund BP_GEBER
FKBER Functional Area FKBER
MEASURE Funded Program FM_MEASURE
GRANT_NBR Grant GM_GRANT_NBR
BUDGETYEAR Original Year for FM Account Assignment GJAHR
BUDGET_PD Budget Period FM_BUDGET_PERIOD
KORRL Correction level for incorrect totals records NUM02
SNPER Special period for transferring postings to general ledger MONAT
REVSR Record Counter of Summary Record Reversed
WNPER Requested Special Period for Transfer to General Ledger MONAT
BLCNT Reference to Document Counter NUM07
TAXC_FACTOR_NUMC Factor for Conversion into Tax Country/Region Currency NUMC31_KK
DUMMY_FKKSUM_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Company Code
  • DFKKSUM.MANDT == T001.MANDT
  • DFKKSUM.BUKRS == T001.BUKRS
Reconciliation Key for General Ledger
Business Area
  • DFKKSUM.MANDT == TGSB.MANDT
  • DFKKSUM.GSBER == TGSB.GSBER
Short Key for a House Bank
  • Short Key for a House Bank
  • Company Code
  • DFKKSUM.MANDT == T012.MANDT
  • DFKKSUM.HBKID == T012.HBKID
  • DFKKSUM.BUKRS == T012.BUKRS
General Ledger Account
  • ?
  • Client
  • General Ledger Account
  • DFKKSUM.[column in domain "KTOPL"] == SKA1.KTOPL
  • DFKKSUM.MANDT == SKA1.MANDT
  • DFKKSUM.HKONT == SKA1.SAKNR
ID for Account Details
  • Company Code
  • ID for Account Details
  • Client
  • Short Key for a House Bank
  • DFKKSUM.BUKRS == T012K.BUKRS
  • DFKKSUM.HKTID == T012K.HKTID
  • DFKKSUM.MANDT == T012K.MANDT
  • DFKKSUM.HBKID == T012K.HBKID
Currency Key
  • DFKKSUM.MANDT == TCURC.MANDT
  • DFKKSUM.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Tax Reporting Country/Region
  • Company Code
  • Tax Reporting Country/Region