SAP table DFKKKO (Header Data in Open Item Accounting Document)

SAP table DFKKKO has 2 primary key fields being MANDT,OPBEL.

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
OPBEL Number of a FI-CA Document CHAR 12 0 OPBEL_KK
FIKEY Reconciliation Key for General Ledger CHAR 12 0 FIKEY_KK
APPLK Application Area CHAR 1 0 APPLK_KK
* Valid for all application areas
C Convergent FI-CA
M Media Companies
P Public Administration
R Utility company
S Extended FI-CA
T Telecommunications
V Insurance company
X In-house development
BLART Document Type CHAR 2 0 TFK003 BLART_KK
HERKF Document Origin Key CHAR 2 0 HERKF_KK
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
WAERS Transaction Currency CUKY 5 0 BLWAE_KK
BLDAT Document Date in Document DATS 8 0 BLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT_KK
WWERT Translation date DATS 8 0 WWERT_D
XBLNR Reference document number CHAR 16 0 XBLNR_KK
RLGRD Return Reason CHAR 3 0 RLGRD_KK
ABGRD Posting Reason (For Write-Offs And Transfer Postings) CHAR 2 0 BUGRD_KK
XEIBH Create Separate Document in General Ledger CHAR 1 0 XEIBH_KK
XBWER Document Created by Foreign Currency Valuation or Reclass. CHAR 1 0 XBWER_KK
1 Reclassification Only for Local Currency 1
2 Reclassification Only for Local Currency 2
3 Reclassification Only for Local Currency 3
X Foreign Currency Valuation
AWTYP Reference procedure CHAR 5 0 AWTYP
AWKEY Reference Key CHAR 20 0 AWKEY
STBEL Number of Reversed Document CHAR 12 0 STBEL_KK
STMET Reversal Method Selected Internally CHAR 1 0 STMET_INT_KK
Clear Business Partner Items
1 Create Offsetting Postings for Business Partner Items
BLTYP Document Class CHAR 1 0 BLTYP_KK
Not Specified
1 Document does not have FI-CA items
2 Document has only statistical FI-CA items
AGINF Clearing Information CHAR 1 0 AGINF_KK
Document did not clear any items
0 Document cleared only statistical items
1 Document cleared only items without repetitions
2 Document cleared various items
STBUK Tax Company Code CHAR 4 0 STBUK_KK
STORB Number of Reversal Document CHAR 12 0 STORB_KK
APPDX Existing document supplements CHAR 1 0 APPDX_KK
C Payment Card Data
AWSYS Logical system of source document CHAR 10 0 AWSYS
VERSN Version Number CHAR 3 0 VERSN_KK
C4EYE Check Reason for Workflows Acc. to Dual Control Principle CHAR 2 0 C4EYE_KK
C4EYP Editing Process To Be Confirmed CHAR 1 0 C4EYP_KK
1 New Document, to Be Confirmed
2 Document To Be Reversed, to Be Confirmed
3 Document Change, to Be Confirmed
4 Installment Plan, to Be Confirmed
5 Repayment Request, to Be Confirmed
6 Installment Plan Change, to Be Confirmed
7 Write-Off Run, to Be Confirmed
TATYP Transaction Class of Document CHAR 1 0 TATYP_KK
Not Specified
1 Invoice
2 Payment, Reconciliation
3 Write-Off
4 Reversal
5 Clearing to Document in Prior Year
6 Clearing to Document in Following Year
7 Write-Off with Changed Conversion
V Posting Before FM Activation
HBBLA Document Type for Transfer to General Ledger CHAR 2 0 HBBLA_KK
XCSHA Document Contains Assignments from Cash Flows CHAR 1 0 XCSHA_KK
UTLOC Storage Location of Tax Supplement for Telco Tax (U.S.A) CHAR 2 0 UTLOC_UT_KK
XTXCH Tax Codes Were Exchanged CHAR 1 0 XTXCH_KK
VATDATE Tax Reporting Date DATS 8 0 VATDATE_KK
FULFILLDATE Tax Settlement Date DATS 8 0 VATDATE2_KK
WNPER Requested Special Period for Transfer to General Ledger NUMC 2 0 WNPER_KK
XSING Individual Posting CHAR 1 0 XSING_KK
KEYPP Subarea for Parallelization in Mass Processing NUMC 3 0 KEYPP_KK
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
XDAAG Data Aging: Document was already in historical area CHAR 1 0 XDAAG_KK
TRSLA Subledger Transfer: Application ID CHAR 5 0 TRSLA_KK
FI Financial Accounting (FI-AR/FI-AP)
LOCOK Submitted Local Currency Amounts Were Transferred CHAR 1 0 LOCOK_KK