SAP table DFKKSUMC (Control details for posting totals)

SAP table DFKKSUMC has 2 primary key fields being MANDT,FIKEY.

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
FIKEY Reconciliation Key for General Ledger CHAR 12 0 FIKEY_KK
FIKST Status of Summary Records for Reconciliation Key CHAR 1 0 FIKST_KK
1 Reconciliation key for mass postings
2 Reconciliation key for individual postings
3 Reconciliation key for specific objects
4 Reconciliation Key for Aggregation
FIKVS Aggregation Status of Reconciliation Key CHAR 1 0 FIKVS_KK
No Aggregation
1 Aggregation Allowed
2 Aggregation Took Place
SUMSZ Number of Summary Records for Reconciliation Key INT4 10 0 SUMSZ_KK
CPUDT Date of entry (CPU date) DATS 8 0 CPUDT_KK
XERRO Table DFKKSUM Not Completely Updated CHAR 1 0 XERRO_KK
KORLV Highest assigned correction level NUMC 2 0 KORLV_KK
UEBIS Posting Date up to Which Data Was Transferred to G/L DATS 8 0 UEBIS_KK
UEKLV Transferred Up To Correction Level NUMC 2 0 UEKLV_KK
XUEVO Transfer All Data to General Ledger CHAR 1 0 XUEVO_KK
XCLOS No Further Postings Allowed CHAR 1 0 XCLOS_KK
RESOB Reservation Object CHAR 3 0 RESOB_KK
001 Payment Lot
002 Returns Lot
003 Document transfer
004 Payment Run
005 Dunning run
006 SD Billing
007 Mass activities
008 Mass Reversal
009 Mass write off
010 Transfer posting run deferred revenue
011 Transfer posting receivable evaluation
012 Automatic Clearing
013 Manual clearing front office
014 Mass Dunning Reversal
015 Manual Outgoing Checks
016 Check Encashment
017 Billing Engine Collective Run
018 Billing Engine Individual Run
019 Revenue Distribution
020 Split by Business Area and Profit Center
021 External Payment Collector, File Transfer
022 Year-End Closing Posting
023 Invoicing
024 Invoicing Reversal
025 Valuation of Promises to Pay
026 Payment Card Billing
027 Automatic Clearing of Prepaid Accounts
028 Postdated Checks: Transfer
029 Factoring: Execute Response
030 Factoring: Clearing Information
031 Subledger Transfer to FI-AR/AP
032 Document from CSV Import
087 Payment Service Provider Settlement
900 RE: Periodic Posting
910 RE: Service Charge Settlement
P01 IS-PS: Campus charge calculation
P02 IS-PS: FI-AP Transfer
R03 IS-U payment transfer
R04 IS-U Invoicing
R05 IS-U Partial billing
R06 IS-U consumption/partial bill
R07 IS-U collective bill
R09 IS-U invoice reversal
R20 IS-U Aggr. Posting, Invoicing of Service Provder, No Tax
R21 IS-U Aggr. Posting, Invoicing of Service Provider with Tax
R22 IS-U Reversal of Aggr. Posting, Inv. of Serv. Prov. with Tax
R23 IS-U Aggreg.Posting of Incoming Invoices
R24 IS-U Aggregated Posting of Outgoing Payments
V01 Broker Report
V02 Broker Report, Split Reconciliation Key
VI0 Italien Collection Agency
RESKY Key of Object That Used the Reconciliation Key CHAR 30 0 RESKY_KK
XARCH Documents Already Archived CHAR 1 0 XARCH_KK
ERNAM Name of the User who Created the Reconciliation Key CHAR 12 0 USNAM_KK
CLDAT Date on which the Reconciliation Key was Closed DATS 8 0 CLDAT_KK
CLTIM Time at which the Reconciliation Key was Closed TIMS 6 0 CLTIM_KK
CLNAM User who Closed the Reconciliation Key CHAR 12 0 CLNAM_KK
UECPU CPU date of the last transfer run DATS 8 0 UECPU_KK
BLCNT Counter for documents transferred to G/L NUMC 7 0 BLCNT_KK
COCNT Number of Accounting Calls for CO-PA NUMC 7 0 COCNT_KK
XUECOPA Data Transferred to Profitability Analysis (CO-PA) CHAR 1 0 XUECOPA_KK
Not transferred
G To Be Transferred Together with FI-GL
N Data for CO-PA not relevant
U Partially Transferred
X Completely Transferred
XMISS Not all documents are contained in the totals CHAR 1 0 XMISS_KK
COMPLETE Status Of Detail Structures For Reconciliation Key CHAR 1 0 COMPLETE_KK
All totals records and control information available
A All totals records and control information archived
D All totals records and control information deleted
XEXTKONT Adjustments Allowed When Transferring To General Ledger CHAR 1 0 XEXTKONT_KK
XKORR Reconciliation Key Corrected with RFKKGL20 CHAR 1 0 XKORR_KK
UEBPANR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
UEBPADAT Date DATS 8 0 DATUM
LIMITEM Itemization Is Limited for the Reconciliation Key CHAR 1 0 LIM_ITEM_KK
1 Due to SLO Migration
2 Set Manually by SAP Support
LIMRECON Behavior of Reconciliation Key in Reconciliation CHAR 1 0 LIM_RECON_KK
Reconcile Normally
1 Do Not Reconcile
2 Reconcile, But Do Not Allow Corrections
XDIRTR Reconcil. Key Contains Totals Records with Direct Transfer CHAR 1 0 XDIRTR_FIKEY_KK