DFKKOP SAP (Items in contract account document) Table details
Dictionary Type: Table
Description: Items in contract account document
Description: Items in contract account document
Table field list including key, data, relationships and ABAP select examples
DFKKOP is a standard SAP Table which is used to store Items in contract account document data and is available within R/3 SAP systems depending on the version and release level.
The DFKKOP table consists of various fields, each holding specific information or linking keys about Items in contract account document data available in SAP. These include OPBEL (Number of Contract Accts Rec. & Payable Doc.), OPUPW (Repetition Item in Contract Account Document), OPUPK (Item number in contract account document), OPUPZ (Subitem for a Partial Clearing in Document).. 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 DFKKOP 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 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
| OPUPW | Repetition Item in Contract Account Document | OPUPW_KK | NUMC | 3 | OPUPW_KK | ||||
| OPUPK | Item number in contract account document | OPUPK_KK | NUMC | 4 | OPUPK_KK | ||||
| OPUPZ | Subitem for a Partial Clearing in Document | OPUPZ_KK | NUMC | 3 | OPUPZ_KK | ||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
| BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | |||
| SEGMENT | Segment for Segmental Reporting | SEGMT_KK | CHAR | 10 | Assigned to domain | ALPHA | FB_SEGMENT | ||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| AUGST | Clearing status | AUGST_KK | CHAR | 1 | AUGST_KK | ||||
| GPART | Business Partner Number | GPART_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | |
| VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
| VTPOS | Contract: Item Number | VTPOS_KK | NUMC | 6 | VTPOS_KK | ||||
| VTRE2 | Additional Reference Information | VTRE2_KK | CHAR | 20 | ALPHA | VTREF_KK | |||
| VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | KTO | FKKVKP_F4 |
| ABWBL | Number of the substitute FI-CA document | ABWBL_KK | CHAR | 12 | ALPHA | ABWBL_KK | |||
| ABWTP | Category of substitute document in FI-CA | ABWTP_KK | CHAR | 1 | ABWTP_KK | ||||
| ABWKT | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | ||
| APPLK | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
| HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | Assigned to domain | HVORG_KK | 8HV | ||
| TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | Assigned to domain | TVORG_KK | |||
| KOFIZ | Account Determination ID | KOFIZ_KK | CHAR | 2 | KOFIZ_KK | ||||
| SPART | Division | SPART_KK | CHAR | 2 | Assigned to domain | SPART | SPA | ||
| HKONT | General ledger account | HKONT_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAKO | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
| MWSZKZ | Supplementary Tax | MWSZKZ_KK | CHAR | 2 | Assigned to domain | MWSKZ | |||
| XANZA | Item is a Down Payment/Down Payment Request | XANZA_KK | CHAR | 1 | XFELD | ||||
| STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1 | STAKZ_KK | ||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
| OPTXT | Item text | OPTXT_KK | CHAR | 50 | TEXT50 | ||||
| WAERS | Transaction Currency | BLWAE_KK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
| FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | DATUM | ||||
| VERKZ | Item Can Only Be Cleared | VERKZ_KK | CHAR | 1 | VERKZ_KK | ||||
| STUDT | Deferral to | STUDT_KK | DATS | 8 | DATUM | ||||
| SKTPZ | Cash discount rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | ||||
| XMANL | Exclude Item from Dunning Run | XMANL_KK | CHAR | 1 | XFELD | ||||
| KURSF | Exchange rate | KURSF_KK | DEC | 9(5) | EXCRT | KURSF | |||
| BETRH | Amount In Local Currency With +/- Signs | BETRH_KK | CURR | 13(2) | WRTV7 | ||||
| BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
| BETR2 | Amount in second parallel currency with +/- sign | BETR2_KK | CURR | 13(2) | WRTV7 | ||||
| BETR3 | Amount in third parallel currency with +/- sign | BETR3_KK | CURR | 13(2) | WRTV7 | ||||
| SKFBT | Amount eligible for cash discount in document currency | SKFBT_KK | CURR | 13(2) | WRTV7 | ||||
| SBETH | Tax Amount in Local Currency With +/- Sign | SBETH_KK | CURR | 13(2) | WRTV7 | ||||
| SBETW | Tax Amount in Transaction Currency with +/- Sign | SBETW_KK | CURR | 13(2) | WRTV7 | ||||
| SBET2 | Tax amount in second parallel currency | SBET2_KK | CURR | 13(2) | WRTV7 | ||||
| SBET3 | Tax amount in third parallel currency | SBET3_KK | CURR | 13(2) | WRTV7 | ||||
| MWSKO | Account for posting taxes for down payments | MWSKO_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
| MWVKO | Account for offsetting tax posting in down payments | MWVKO_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
| TXRUL | Update Rule for Tax and Tax Clearing | TXRUL_KK | CHAR | 1 | TXRUL_KK | ||||
| SPZAH | Lock Reason for Automatic Payment | SPZAH_KK | CHAR | 1 | Assigned to domain | SPZAH_KK | |||
| PYMET | Payment Method | PYMET_KK | CHAR | 1 | Assigned to domain | PYMET_KK | |||
| PYBUK | Company Code for Automatic Payment Transactions | PYBUK_KK | CHAR | 4 | T001 | BUKRS | |||
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
| GRKEY | Grouping Key for Displaying Open Items | GRKEY_KK | CHAR | 3 | CHAR3 | ||||
| PERSL | Key for Period Assignment | PERSL_KK | CHAR | 4 | Assigned to domain | PERSL_KK | |||
| XAESP | Printing - No Changes Possible | XAESP_KK | CHAR | 1 | XFELD | ||||
| AUGDT | Clearing date | AUGDT_KK | DATS | 8 | DATUM | ||||
| AUGBL | Clearing Document or Printed Document | AUGBL_KK | CHAR | 12 | ALPHA | AUGBL_KK | |||
| AUGBD | Clearing document posting date | AUGBD_KK | DATS | 8 | DATUM | ||||
| AUGRD | Clearing Reason | AUGRD_KK | CHAR | 2 | Assigned to domain | AUGRD_KK | |||
| AUGWA | Clearing currency | AUGWA_KK | CUKY | 5 | Assigned to domain | WAERS | |||
| AUGBT | Clearing amount in clearing currency | AUGBT_KK | CURR | 13(2) | WRTV7 | ||||
| AUGBS | Tax amount in clearing currency | AUGBS_KK | CURR | 13(2) | WRTV7 | ||||
| AUGSK | Cash Discount Granted/Surcharge Levied in Clearing Currency | AUGSK_KK | CURR | 13(2) | WRTV7 | ||||
| AUGVD | Value date for clearing | AUGVD_KK | DATS | 8 | DATUM | ||||
| AUGOB | Item Canceled | AUGOB_KK | CHAR | 1 | XFELD | ||||
| WHANG | Number of repetition items | WHANG_KK | NUMC | 3 | NUM03 | ||||
| WHGRP | Repetition group | WHGRP_KK | NUMC | 3 | DFKKOPW | WHGRP_KK | |||
| XEIPH | Create Line Item in General Ledger | XEIPH_KK | CHAR | 1 | XFELD | ||||
| MAHNV | Dunning Procedure | MAHNV_KK | CHAR | 2 | Assigned to domain | MAHNV_KK | FKK_MAHNV | ||
| MANSP | Dunning Lock Reason | MANSP_KK | CHAR | 1 | Assigned to domain | MANSP_KK | |||
| XAUGP | Check Sample Record Clearing | XAUGP_KK | CHAR | 1 | XFELD | ||||
| ABRZU | Lower Limit of Settlement Period | ABRZU_KK | DATS | 8 | DATUM | ||||
| ABRZO | Upper Limit of the Billing Period | ABRZO_KK | DATS | 8 | DATUM | ||||
| FDGRP | Planning Group | FDGRP_KK | CHAR | 10 | Assigned to domain | ALPHA | FDGRP | FFG | |
| FDLEV | Planning level | FDLEV_KK | CHAR | 2 | Assigned to domain | FDLEV | FFE | ||
| FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 | ||||
| FDWBT | Planning amount in document currency | FDWBT | CURR | 13(2) | WERTV7 | ||||
| XTAUS | Item Split | XTAUS_KK | CHAR | 1 | XFELD | ||||
| AUGRS | Clearing restriction | AUGRS_KK | CHAR | 1 | AUGRS_KK | ||||
| PYGRP | Grouping field for automatic payments | PYGRP_KK | CHAR | 10 | CHAR10 | ||||
| PDTYP | Category of Payment Specification | PDTYP_KK | CHAR | 1 | PDTYP_KK | ||||
| SPERZ | Interest Lock Reason | SPERZ_KK | CHAR | 1 | Assigned to domain | SPERZ_KK | |||
| INFOZ | Doubtful Item Entry/Individual Value Adjustment | INFOZ_KK | NUMC | 3 | INFOZ_KK | ||||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
| TXDAT | Decisive Date for Calculating Taxes | TXDAT_KK | DATS | 8 | DATUM | ||||
| VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
| KONTT | Account Assignment Category | KONTT_KK | CHAR | 2 | Assigned to domain | KONTT_KK | |||
| KONTL | Acct assnmnt string for industry-specific account assngments | KONTL_KK | CHAR | 50 | CHAR50 | ||||
| OPSTA | Dunning indicator | OPSTA_KK | CHAR | 3 | OPSTA_KK | ||||
| BLART | Document Type | BLART_KK | CHAR | 2 | Assigned to domain | BLART_KK | |||
| EMGPA | Alternative Business Partner for Payments | EMGPA_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BUPA | |
| EMBVT | Bank Details ID of Payee | EMBVT_KK | CHAR | 4 | CHAR4 | ||||
| EMADR | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
| IKEY | Interest Key | IKEY_KK | CHAR | 2 | Assigned to domain | IKEY_KK | |||
| EUROU | Status of Euro Conversion | EUROU_KK | CHAR | 1 | EUROU_KK | ||||
| XRAGL | Clearing posting reversed | XRAGL_KK | CHAR | 1 | XFELD | ||||
| ASTKZ | Statistical Key of the Initiating Item | ASTKZ_KK | CHAR | 1 | ASTKZ_KK | ||||
| ASBLG | Number of Triggering Document | ASBLG_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | ||
| XBLNR | Reference document number | XBLNR_KK | CHAR | 16 | ALPHA | XBLNR_KK | |||
| INKPS | Collection Item | INKPS_KK | NUMC | 3 | NUM03 | ||||
| RNDPS | Type of Rounding Item | RNDPS_KK | CHAR | 1 | RNDPS_KK | ||||
| QSSKZ | Withholding Tax Code | QSSKZ | CHAR | 2 | Assigned to domain | QSSKZ | |||
| QSSEW | Withholding Tax Supplement | QSSEW_KK | CHAR | 2 | Assigned to domain | QSSEW_KK | |||
| QSPTP | Line Item Category From Withholding Tax View | QSPTP_KK | CHAR | 1 | QSPTP_KK | ||||
| QSSHB | Tax Base Amount | QSSHB_KK | CURR | 13(2) | WRTV7 | ||||
| QBSHB | Withholding Tax Amount (in Document Currency) | QBSHB_KK | CURR | 13(2) | WRTV7 | ||||
| QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
| XWHEX | Variable Withholding Tax in DFKKOPWH | XWHEX_KK | CHAR | 1 | XFELD | ||||
| RFUPK | Reference Item In FI-CA Document | RFUPK_KK | NUMC | 4 | OPUPK_KK | ||||
| STRKZ | Tax Code for Other Taxes | STRKZ_KK | CHAR | 2 | Assigned to domain | STRKZ_KK | |||
| FITPR | Tax type | J_1AFITP_D | CHAR | 2 | Assigned to domain | J_1AFITP | |||
| XPYOR | Item Included in a Payment Order | XPYOR_KK | CHAR | 1 | XPYOR_KK | ||||
| LANDL | Country Supplied (for Tax Notifications) | LANDL_KK | CHAR | 3 | Assigned to domain | LAND1 | |||
| INTBU | Reason for Automatic Creation of Posting | INTBU_KK | CHAR | 1 | INTBU_KK | ||||
| EMCRD | Alternative Payment Card ID in Document | EMCRD_KK | CHAR | 6 | CHAR6 | ||||
| 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 | ||||
| SCTAX | Tax Portion in FI-CA Local Currency | SCTAX_KK | CURR | 13(2) | WRTV7 | ||||
| STTAX | Tax Amount as Statistical Information in Document Currency | STTAX_KK | CURR | 13(2) | WRTV7 | ||||
| STZAL | Status of Payment Processing | STZAL_KK | CHAR | 1 | STZAL_KK | ||||
| ORUPZ | Subitem Number before Item Split | ORUPZ_KK | CHAR | 3 | CHAR3 | ||||
| NEGBU | Control Field for Negative Posting | NEGBU_KK | NUMC | 1 | NEGBU_KK | ||||
| SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR | 1 | SUBAP_KK | 8SA | |||
| PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL_KK | CUKY | 5 | Assigned to domain | WAERS | |||
| PSWBT | Amount for Updating in General Ledger | PSWBT_KK | CURR | 13(2) | WRTV7 | ||||
| PSWTX | Tax Amount for Update in General Ledger | PSWTX_KK | CURR | 13(2) | WRTV7 | ||||
| PSGRP | Grouping Key for Document Items | PSGRP_KK | CHAR | 4 | CHAR4 | ||||
| XCOLC | Item Is Included in Collection Case | XCOLC_KK | CHAR | 1 | XFELD | ||||
| AASTA | Control Field for Account Assignment Distributions | AASTA_KK | CHAR | 1 | AASTA_KK | ||||
| XCSHA | Document Contains Assignments from Cash Flows | XCSHA_KK | CHAR | 1 | XFELD | ||||
| REACC | Originating Account in Cash Flow Anlaysis | REACC_KK | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
| REBUK | Partner Company Code for Cash Flow Analysis | REBUK_KK | CHAR | 4 | Assigned to domain | BUKRS | |||
| XUSTPD | Tax on Sales/Purchases Was Calculated by Document | XUSTPD_KK | CHAR | 1 | XFELD | ||||
| PTITM | Status of Partner Settlement Using Billable Items | PTITM_KK | CHAR | 1 | PTITM_KK | ||||
| EMMND | SEPA Mandate Identifier | EMMND_KK | NUMC | 6 | NUM06 | ||||
| PNNUM | SEPA: Number of Direct Debit Pre-Notification | PNNUM_KK | CHAR | 16 | ALPHA | PNNUM_KK | |||
| PNHKF | SEPA: Origin of Direct Debit Pre-Notification | PNHKF_KK | CHAR | 2 | PNHKF_KK | ||||
| PNEXD | SEPA: Date of Execution of Direct Debit Pre-Notifcation | PNEXD_KK | DATS | 8 | DATUM | ||||
| PNCTR | SEPA: Requirement for a Pre-Notification | PNCTR_KK | CHAR | 1 | PNCTR_KK | ||||
| FINRE | Contract Account of Final Recipient | FINRE_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | FKKVKP_F4 | |
| RDSTA | Current Distribution Status | RDSTA_KK | CHAR | 1 | RDSTAT_KK | ||||
| RDSTB | Last Distribution Status Reported | RDSTB_KK | CHAR | 1 | RDSTAT_KK |
| Key field | Non-key field |
How do I retrieve data from SAP table DFKKOP using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKOP to SELECT all data from the tableDATA: WA_DFKKOP TYPE DFKKOP.
SELECT SINGLE *
FROM DFKKOP
INTO CORRESPONDING FIELDS OF WA_DFKKOP
WHERE...
How to access SAP table DFKKOP
Within an ECC or HANA version of SAP you can also view further information about DFKKOP 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