DFKKKO SAP (Header Data in Open Item Accounting Document) Table details
Dictionary Type: Table
Description: Header Data in Open Item Accounting Document
Description: Header Data in Open Item Accounting Document
Table field list including key, data, relationships and ABAP select examples
DFKKKO is a standard SAP Table which is used to store Header Data in Open Item Accounting Document data and is available within R/3 SAP systems depending on the version and release level.
The DFKKKO table consists of various fields, each holding specific information or linking keys about Header Data in Open Item Accounting Document data available in SAP. These include OPBEL (Number of Contract Accts Rec. & Payable Doc.), FIKEY (Reconciliation Key for General Ledger), APPLK (Application area), BLART (Document Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DFKKKO table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | ALPHA | OPBEL_KK | 80B | ||
| FIKEY | Reconciliation Key for General Ledger | FIKEY_KK | CHAR | 12 | Assigned to domain | FIKEY_KK | FKFI1 | ||
| APPLK | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
| BLART | Document Type | BLART_KK | CHAR | 2 | TFK003 | BLART_KK | |||
| HERKF | Document Origin Key | HERKF_KK | CHAR | 2 | Assigned to domain | HERKF_KK | |||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
| CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
| WAERS | Transaction Currency | BLWAE_KK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
| BUDAT | Posting Date in the Document | BUDAT_KK | DATS | 8 | DATUM | ||||
| WWERT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
| XBLNR | Reference document number | XBLNR_KK | CHAR | 16 | ALPHA | XBLNR_KK | |||
| RLGRD | Return reason | RLGRD_KK | CHAR | 3 | Assigned to domain | RLGRD_KK | |||
| ABGRD | Posting Reason (For Write-Offs And Transfer Postings) | BUGRD_KK | CHAR | 2 | BUGRD_KK | ||||
| XEIBH | Create Separate Document in General Ledger | XEIBH_KK | CHAR | 1 | XFELD | ||||
| XBWER | Document Created by Foreign Currency Valuation or Reclass. | XBWER_KK | CHAR | 1 | XBWER_KK | ||||
| AWTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
| AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
| STBEL | Number of Reversed Document | STBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
| STMET | Reversal Method Selected Internally | STMET_INT_KK | CHAR | 1 | STMET_INT_KK | ||||
| BLTYP | Document Class | BLTYP_KK | CHAR | 1 | BLTYP_KK | ||||
| AGINF | Clearing Information | AGINF_KK | CHAR | 1 | AGINF_KK | ||||
| STBUK | Tax Company Code | STBUK_KK | CHAR | 4 | Assigned to domain | BUKRS | BUK | ||
| STORB | Number of Reversal Document | STORB_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
| APPDX | Existing document supplements | APPDX_KK | CHAR | 1 | APPDX_KK | ||||
| AWSYS | Logical system of source document | AWSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| VERSN | Version Number | VERSN_KK | CHAR | 3 | CHAR3 | ||||
| C4EYE | Check Reason for Workflows Acc. to Dual Control Principle | C4EYE_KK | CHAR | 2 | Assigned to domain | C4EYE_KK | |||
| C4EYP | Editing Process To Be Confirmed | C4EYP_KK | CHAR | 1 | C4EYP_KK | ||||
| TATYP | Transaction Class of Document | TATYP_KK | CHAR | 1 | TATYP_KK | ||||
| HBBLA | Document Type for Transfer to General Ledger | HBBLA_KK | CHAR | 2 | Assigned to domain | BLART | |||
| XCSHA | Document Contains Assignments from Cash Flows | XCSHA_KK | CHAR | 1 | XFELD | ||||
| UTLOC | Storage Location of Tax Supplement for Telco Tax (U.S.A) | UTLOC_UT_KK | CHAR | 2 | CHAR2 | ||||
| XTXCH | Tax Codes Were Exchanged | XTXCH_KK | CHAR | 1 | XFELD | ||||
| VATDATE | Tax Reporting Date | VATDATE_KK | DATS | 8 | DATUM | ||||
| WNPER | Requested Special Period for Transfer to General Ledger | WNPER_KK | NUMC | 2 | MONAT | ||||
| XSING | Individual Posting | XSING_KK | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table DFKKKO using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKKO to SELECT all data from the tableDATA: WA_DFKKKO TYPE DFKKKO.
SELECT SINGLE *
FROM DFKKKO
INTO CORRESPONDING FIELDS OF WA_DFKKKO
WHERE...
How to access SAP table DFKKKO
Within an ECC or HANA version of SAP you can also view further information about DFKKKO and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects