DFKKOP_REP - Open Items from FPO4

Open Items from FPO4 information is stored in SAP table DFKKOP_REP.
It is part of development package FKKB in software component FI-CA. This development package consists of objects that can be grouped under "Contract A/R & A/P: Central Objects".

Fields for table DFKKOP_REP

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
KEYDT	Key Date for Analysis of Open Items	X	OP_KEYDATE_KK	DATS	16
INTNR	Number of interval within variant	X	INTNR_KK	INT4	4
LFDNR	4 Byte Signed Integer	X	INT4	INT4	4
.INCLUDE				FKKOP_COPY	0
.INCLUDE				FKKOP	0
MANDT	Client		MANDT	CLNT	6	*
OPBEL	Number of a FI-CA Document		OPBEL_KK	CHAR	24	*
OPUPW	Repetition Item in FI-CA Document		OPUPW_KK	NUMC	6
OPUPK	Item Number in FI-CA Document		OPUPK_KK	NUMC	8
OPUPZ	Subitem for a Partial Clearing in Document		OPUPZ_KK	NUMC	6
BUKRS	Company Code		BUKRS	CHAR	8	T001
GSBER	Business Area		GSBER	CHAR	8	TGSB
BUPLA	Business Place		BUPLA	CHAR	8	J_1BBRANCH
SEGMENT	Segment for Segmental Reporting		SEGMT_KK	CHAR	20	FAGL_SEGM
PRCTR	Profit Center		PRCTR	CHAR	20
AUGST	Clearing Status		AUGST_KK	CHAR	2
GPART	Business Partner Number		GPART_KK	CHAR	20	BUT000
VTREF	Reference Specifications from Contract		VTREF_KK	CHAR	40
VTPOS	Contract: Item Number		VTPOS_KK	NUMC	12
VTRE2	Additional Reference Information		VTRE2_KK	CHAR	40
VKONT	Contract Account Number		VKONT_KK	CHAR	24	FKKVK
ABWBL	Number of the Substitute FI-CA Document		ABWBL_KK	CHAR	24
ABWTP	Category of Substitute Document in FI-CA		ABWTP_KK	CHAR	2
ABWKT	Alternative Contract Account for Collective Bills		ABWVK_KK	CHAR	24	*
APPLK	Application Area		APPLK_KK	CHAR	2
HVORG	Main Transaction for Line Item		HVORG_KK	CHAR	8	TFKHVO
TVORG	Subtransaction for Document Item		TVORG_KK	CHAR	8	TFKTVO
KOFIZ	Account Determination ID		KOFIZ_KK	CHAR	4
SPART	Division		SPART_KK	CHAR	4	TSPA
HKONT	General ledger account		HKONT_KK	CHAR	20	SKA1
MWSKZ	Tax on sales/purchases code		MWSKZ	CHAR	4	T007A
MWSZKZ	Supplementary Tax		MWSZKZ_KK	CHAR	4	*
XANZA	Item is a Down Payment/Down Payment Request		XANZA_KK	CHAR	2
STAKZ	Type of statistical item		STAKZ_KK	CHAR	2
BLDAT	Document Date in Document		BLDAT	DATS	16
BUDAT	Posting Date in the Document		BUDAT_KK	DATS	16
OPTXT	Item text		OPTXT_KK	CHAR	100
WAERS	Transaction Currency		BLWAE_KK	CUKY	10	TCURC
FAEDN	Due date for net payment		FAEDN_KK	DATS	16
FAEDS	Due Date for Cash Discount		FAEDS_KK	DATS	16
VERKZ	Item Can Only Be Cleared		VERKZ_KK	CHAR	2
STUDT	Deferral to		STUDT_KK	DATS	16
SKTPZ	Cash Discount Percentage Rate		SKTPZ_KK	DEC	3
XMANL	Exclude Item from Dunning Run		XMANL_KK	CHAR	2
KURSF	Exchange rate		KURSF_KK	DEC	5
BETRH	Amount In Local Currency With +/- Signs		BETRH_KK	CURR	7
BETRW	Amount in Transaction Currency with +/- Sign		BETRW_KK	CURR	7
BETR2	Amount in Second Parallel Currency with +/- Sign		BETR2_KK	CURR	7
BETR3	Amount in Third Parallel Currency with +/- Sign		BETR3_KK	CURR	7
SKFBT	Amount Eligible for Cash Discount in Document Currency		SKFBT_KK	CURR	7
SBETH	Tax Amount in Local Currency With +/- Sign		SBETH_KK	CURR	7
SBETW	Tax Amount in Transaction Currency with +/- Sign		SBETW_KK	CURR	7
SBET2	Tax Amount in Second Parallel Currency		SBET2_KK	CURR	7
SBET3	Tax Amount in Third Parallel Currency		SBET3_KK	CURR	7
MWSKO	Account for posting taxes for down payments		MWSKO_KK	CHAR	20	SKA1
MWVKO	Account for offsetting tax posting in down payments		MWVKO_KK	CHAR	20	SKA1
TXRUL	Update Rule for Tax and Tax Clearing		TXRUL_KK	CHAR	2
SPZAH	Lock Reason for Automatic Payment		SPZAH_KK	CHAR	2	TFK008
PYMET	Payment Method		PYMET_KK	CHAR	2	*
PYBUK	Company Code for Automatic Payment Transactions		PYBUK_KK	CHAR	8	T001
PERNR	Personnel Number		PERNR_D	NUMC	16
GRKEY	Grouping Key for Displaying Open Items		GRKEY_KK	CHAR	6
PERSL	Key for Period Assignment		PERSL_KK	CHAR	8	TFK001P
XAESP	Printing - No Changes Possible		XAESP_KK	CHAR	2
AUGDT	Clearing Date		AUGDT_KK	DATS	16
AUGBL	Clearing Document or Printed Document		AUGBL_KK	CHAR	24
AUGBD	Clearing Document Posting Date		AUGBD_KK	DATS	16
AUGRD	Clearing Reason		AUGRD_KK	CHAR	4	TFK001A
AUGWA	Clearing Currency		AUGWA_KK	CUKY	10	*
AUGBT	Clearing amount in clearing currency		AUGBT_KK	CURR	7
AUGBS	Tax Amount in Clearing Currency		AUGBS_KK	CURR	7
AUGSK	Cash Discount Granted/Surcharge Levied in Clearing Currency		AUGSK_KK	CURR	7
AUGVD	Value date for clearing		AUGVD_KK	DATS	16
AUGOB	Item Canceled		AUGOB_KK	CHAR	2
WHANG	Number of repetition items		WHANG_KK	NUMC	6
WHGRP	Repetition group		WHGRP_KK	NUMC	6	*
XEIPH	Create Line Item in General Ledger		XEIPH_KK	CHAR	2
MAHNV	Dunning Procedure		MAHNV_KK	CHAR	4	TFK047A
MANSP	Dunning Lock Reason		MANSP_KK	CHAR	2	TFK047S
XAUGP	Check Sample Record Clearing		XAUGP_KK	CHAR	2
ABRZU	Lower Limit of Billing Period		ABRZU_KK	DATS	16
ABRZO	Upper Limit of the Billing Period		ABRZO_KK	DATS	16
FDGRP	Planning Group		FDGRP_KK	CHAR	20	T035
FDLEV	Planning level		FDLEV_KK	CHAR	4	T036
FDZTG	Additional Days for Cash Management		FDZTG_KK	NUMC	4
FDWBT	Planned Amount in Document or G/L Account Currency		FDWBT_KK	CURR	7
XTAUS	Item Split		XTAUS_KK	CHAR	2
AUGRS	Clearing restriction		AUGRS_KK	CHAR	2
PYGRP	Grouping field for automatic payments		PYGRP_KK	CHAR	20
PDTYP	Category of Payment Specification		PDTYP_KK	CHAR	2
SPERZ	Interest Lock Reason		SPERZ_KK	CHAR	2	TFK056S
INFOZ	Doubtful Item Entry/Individual Value Adjustment		INFOZ_KK	NUMC	6
TXJCD	Tax Jurisdiction		TXJCD	CHAR	30	TTXJ
TXDAT	Decisive Date for Calculating Taxes		TXDAT_KK	DATS	16
VBUND	Company ID of Trading Partner		RASSC	CHAR	12	T880
KONTT	Account Assignment Category		KONTT_KK	CHAR	4	TFK000K
KONTL	Acct assnmnt string for industry-specific account assngments		KONTL_KK	CHAR	100
OPSTA	Dunning indicator		OPSTA_KK	CHAR	6
BLART	Document Type		BLART_KK	CHAR	4	TFK003
EMGPA	Alternative Business Partner for Payments		EMGPA_KK	CHAR	20	BUT000
EMBVT	Bank Details ID of Payee		EMBVT_KK	CHAR	8	BUT0BK
EMADR	Address Number		AD_ADDRNUM	CHAR	20	*
IKEY	Interest Key		IKEY_KK	CHAR	4	TFK056A
EUROU	Status of Euro Conversion		EUROU_KK	CHAR	2
XRAGL	Clearing posting reversed		XRAGL_KK	CHAR	2
XWHPO	Expanded Repetition Item		XWHPO_KK	CHAR	2
ASTKZ	Statistical Key of the Initiating Item		ASTKZ_KK	CHAR	2
ASBLG	Number of Triggering Document		ASBLG_KK	CHAR	24	*
XBLNR	Reference document number		XBLNR_KK	CHAR	32
INKPS	Collection Item		INKPS_KK	NUMC	6
RNDPS	Type of Rounding Item		RNDPS_KK	CHAR	2
QSSKZ	Withholding Tax Code		QSSKZ	CHAR	4	T059Q
QSSEW	Withholding Tax Supplement		QSSEW_KK	CHAR	4	*
QSPTP	Line Item Category From Withholding Tax View		QSPTP_KK	CHAR	2
QSSHB	Tax Base Amount		QSSHB_KK	CURR	7
QBSHB	Withholding Tax Amount (in Document Currency)		QBSHB_KK	CURR	7
QSPRZ	Withholding Tax Percentage		QSPRZ_KK	NUMC	12
QSZNR	Certificate Number of the Withholding Tax Exemption		QSZNR	CHAR	20
XWHEX	Variable Withholding Tax in DFKKOPWH		XWHEX_KK	CHAR	2
RFUPK	Reference Item In FI-CA Document		RFUPK_KK	NUMC	8
STRKZ	Tax Code for Other Taxes		STRKZ_KK	CHAR	4	TFK007F
FITPR	Tax type		J_1AFITP_D	CHAR	4	J_1AFITPV
XPYOR	Item Included in a Payment Order		XPYOR_KK	CHAR	2
LANDL	Destination Country/Region (for Tax Reports)		LANDL_KK	CHAR	6	T005
INTBU	Reason for Automatic Creation of Posting		INTBU_KK	CHAR	2
EMCRD	Alternative Payment Card ID in Document		EMCRD_KK	CHAR	12
C4EYE	Check Reason for Workflows Acc. to Dual Control Principle		C4EYE_KK	CHAR	4	*
CFOPN	CFOP Code and Extension		J_1BCFOP	CHAR	20	*
C4EYP	Editing Process To Be Confirmed		C4EYP_KK	CHAR	2
TXGRP	Grouping Key for Tax Items		TXGRP_KK	CHAR	12
SCTAX	Tax Portion in FI-CA Local Currency		SCTAX_KK	CURR	7
STTAX	Tax Amount as Statistical Information in Document Currency		STTAX_KK	CURR	7
STZAL	Status of Payment Processing		STZAL_KK	CHAR	2
ORUPZ	Subitem Number before Item Split		ORUPZ_KK	CHAR	6
NEGBU	Control Field for Negative Posting		NEGBU_KK	NUMC	2
SUBAP	Subapplication in Contract Accounts Receivable and Payable		SUBAP_KK	CHAR	2
PSWSL	Update Currency for General Ledger Transaction Figures		PSWSL_KK	CUKY	10	*
PSWBT	Amount for Updating in General Ledger		PSWBT_KK	CURR	7
PSWTX	Tax Amount for Update in General Ledger		PSWTX_KK	CURR	7
PSGRP	Grouping Key for Document Items		PSGRP_KK	CHAR	8
XCOLC	Item Is Included in Collection Case		XCOLC_KK	CHAR	2
AASTA	Control Field for Account Assignment Distributions		AASTA_KK	CHAR	2
XCSHA	Document Contains Assignments from Cash Flows		XCSHA_KK	CHAR	2
REACC	Originating Account in Cash Flow Anlaysis		REACC_KK	CHAR	20	*
REBUK	Partner Company Code for Cash Flow Analysis		REBUK_KK	CHAR	8	*
XUSTPD	Tax on Sales/Purchases Was Calculated by Document		XUSTPD_KK	CHAR	2
PTITM	Status of Partner Settlement Using Billable Items		PTITM_KK	CHAR	2
EMMND	SEPA Mandate Identifier		EMMND_KK	NUMC	12
PALIX	Item Is Part of a Collaborative Liability		PALIX_KK	CHAR	2
CLRLOCK	Clearing Lock Reason		CLRLO_KK	CHAR	2	TFK000S
.INCLUDE				FKK_PRN_OP	0
PNNUM	SEPA: Number of Direct Debit Pre-Notification		PNNUM_KK	CHAR	32
PNHKF	SEPA: Origin of Direct Debit Pre-Notification		PNHKF_KK	CHAR	4
PNEXD	SEPA: Date of Execution of Direct Debit Pre-Notifcation		PNEXD_KK	DATS	16
PNCTR	SEPA: Requirement for a Pre-Notification		PNCTR_KK	CHAR	2
.INCLUDE				FKKOPRD	0
FINRE	Contract Account of Final Recipient		FINRE_KK	CHAR	24
RDSTA	Current Distribution Status		RDSTA_KK	CHAR	2
RDSTB	Last Distribution Status Reported		RDSTB_KK	CHAR	2
.INCLUDE				FKKOPFA	0
FASTA	Factoring: Current Status of Receivable		FASTA_KK	CHAR	2
PASTA	Factoring: Check Status for Clearing Information		PASTA_KK	CHAR	2
OPUPF	Subitems in Factoring		OPUPF_KK	NUMC	6
.INCLUDE				IFKKFMOBJ	0
FMTYP	Update Method for FM - FI-CA Integration		FMTYP_KK	CHAR	4
.INCLUDE				IFKKFMOBJK	0
ORIGFIKRS	Original FM Area for FM Account Assignment		ORIGFIKRS_KK	CHAR	8	*
FIPEX	Commitment Item		FM_FIPEX	CHAR	48	*
FISTL	Funds Center		FISTL	CHAR	32	*
FONDS	Fund		BP_GEBER	CHAR	20	*
FKBER	Functional Area		FKBER	CHAR	32	*
MEASURE	Funded Program		FM_MEASURE	CHAR	48	*
GRANT_NBR	Grant		GM_GRANT_NBR	CHAR	40
BUDGETYEAR	Original Year for FM Account Assignment		FM_START_OF_CHAIN	NUMC	8
BUDGET_PD	Budget Period		FM_BUDGET_PERIOD	CHAR	20	*
.INCLUDE				SI_FKKOPR	0
.INCLUDE				SI_FKKOPV	0
.INCLUDE				SI_FKKOPT	0
.INCLUDE				SI_FKKOPP	0
.INCLUDE				CI_FKKOP	0
.INCLUDE				SI_FKKOPM	0
.INCLUDE				SI_FKKOPS	0
.INCLUDE				SI_FKKOPC_CLOUD	0
.INCLUDE				SI_FKKOPC_USTPD_CLOUD	0
.INCLUDE				CI_FKKOP_USTPD	0
COLOGRP	Colocation Group for Business Partner		COLOGRP_BP_KK	CHAR	24
HERKF_KK	Document Origin Key		HERKF_KK	CHAR	4	*
.INCLUDE				SI_FKKOP_LOC_CEE	0
.INCLUDE				/SAPCE/FKRU_VAT	0
/SAPCE/FKRU_CN	Number of corrected document		/SAPCE/FKRU_CBLNR	CHAR	24
/SAPCE/FKRU_CD	Posting date of corrected document		/SAPCE/FKRU_CUDAT	DATS	16
/SAPCE/FKRU_RN	Revision Number		/SAPCE/FKRU_RNUM	NUMC	4
/SAPCE/FKRU_AB	Date from which time slice is valid		ABZEITSCH	DATS	16
/SAPCE/FKRU_BIS	Date at Which a Time Slice Expires		BISZEITSCH	DATS	16
.INCLUDE				SI_FKKOPR_LOC_CEE	0
INTOP	Internal Generation Characteristic for Document Item		INTOP_KK	CHAR	2
CPUDT_OP	Document Item Creation Date		CPUDT_OP_KK	DATS	16
CPUTM_OP	Time of Document Item Creation		CPUTM_OP_KK	TIMS	12
CPUDT_ST	Document Item Reversal Date		CPUDT_ST_KK	DATS	16
CPUTM_ST	Time of Document Item Reversal		CPUTM_ST_KK	TIMS	12
_DATAAGING	Data Filter Value for Data Aging		DATA_TEMPERATURE	DATS	16
AUGRE	Additional Clearing Restriction		AUGRE_KK	CHAR	6	TFK004AR
.INCLUDE				CI_FKKOP_2	0
INTTX	Internal Tax Characteristic for Tax Handling		INTTX_KK	CHAR	2
TXDAT_FROM	Valid-From Date of the Tax Rate		FOT_TXDAT_FROM	DATS	16
TAX_COUNTRY	Tax Reporting Country/Region		FOT_TAX_COUNTRY	CHAR	6	T005
TAXC_FACTOR	Factor for Conversion into Tax Country/Region Currency		TAXC_FACTOR_KK	DEC	16
RCSTA	Reconnection Status		RCSTA_KK	CHAR	2
AWTYP_OP	Reference Transaction in Business Partner Item		AWTYP_OP_KK	CHAR	10	*
AWKEY_OP	Reference Key in Business Partner Item		AWKEY_OP_KK	CHAR	40
FULPA	Only Full Payment Allowed		FULPA_KK	CHAR	2
INFPA	Inform About Payment		INFPA_KK	CHAR	4
.INCLUDE				SI_FKKOP_LOC	0
BCODE	Branch Code		BCODE_KK	CHAR	10
BENT1	Service Type		BENTY_KK	CHAR	20
ISSRB	ISS Tax Rate for Simples		ISSR_KK	DEC	3
.INCLUDE				FKKOP_INCL_EEW_PS	0
DUMMY_FKKOP_INCL_EEW_PS	Custom Fields: Dummy for Use in Extension Includes		CFD_DUMMY	CHAR	2
COPY	Simulated Clearing Item		COPY_KK	CHAR	2
WAERH	Local Currency		WAERH	CUKY	10	*
MARK	Checkbox		XFELD	CHAR	2