SAP DFKKOP Items in contract account document Table data and field list

DFKKOP is a standard SAP Table which is used to store Items in contract account document data in SAP systems, such as SAP R/3, S/4HANA, 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. .

DFKKOP table Technical Details:

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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the DFKKOP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

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

< DFKKODNREP - Official Document Number for Reporting DFKKOPAA - Distribution Items with Account Assignment >

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).