DFKKOP_REP

Open Items from FPO4 | #transactional | Component: Contract Accounts Receivable and Payable
Column Name Description
CLIENT Client
KEYDT Key Date for Analysis of Open Items
INTNR Number of interval within variant
LFDNR 4 Byte Signed Integer
Column Name Description
💲 Currency Key (T001.WAERS):
BETRH Amount In Local Currency With +/- Signs
BETRW Amount in Transaction Currency with +/- Sign
SKFBT Amount Eligible for Cash Discount in Document Currency
SBETH Tax Amount in Local Currency With +/- Sign
SBETW Tax Amount in Transaction Currency with +/- Sign
FDWBT Planned Amount in Document or G/L Account Currency
QSSHB Tax Base Amount
QBSHB Withholding Tax Amount (in Document Currency)
SCTAX Tax Portion in FI-CA Local Currency
STTAX Tax Amount as Statistical Information in Document Currency
BETR2 Amount in Second Parallel Currency with +/- Sign
BETR3 Amount in Third Parallel Currency with +/- Sign
SBET2 Tax Amount in Second Parallel Currency
SBET3 Tax Amount in Third Parallel Currency
💲 Clearing Currency (AUGWA):
AUGBT Clearing amount in clearing currency
AUGBS Tax Amount in Clearing Currency
AUGSK Cash Discount Granted/Surcharge Levied in Clearing Currency
💲 Update Currency for General Ledger Transaction Figures (PSWSL):
PSWBT Amount for Updating in General Ledger
PSWTX Tax Amount for Update in General Ledger
Column Name Description
Column Name Description
KEYDT Key Date for Analysis of Open Items
BLDAT Document Date in Document
BUDAT Posting Date in the Document
FAEDN Due date for net payment
FAEDS Due Date for Cash Discount
STUDT Deferral to
AUGDT Clearing Date
AUGBD Clearing Document Posting Date
AUGVD Value date for clearing
ABRZU Lower Limit of Billing Period
ABRZO Upper Limit of the Billing Period
TXDAT Decisive Date for Calculating Taxes
PNEXD SEPA: Date of Execution of Direct Debit Pre-Notifcation
/SAPCE/FKRU_CD Posting date of corrected document
/SAPCE/FKRU_AB Date from which time slice is valid
/SAPCE/FKRU_BIS Date at Which a Time Slice Expires
CPUDT_OP Document Item Creation Date
CPUTM_OP Time of Document Item Creation
CPUDT_ST Document Item Reversal Date
CPUTM_ST Time of Document Item Reversal
_DATAAGING Data Filter Value for Data Aging
TXDAT_FROM Valid-From Date of the Tax Rate
Column Name Description
AUGST Clearing Status Show values
ABWTP Category of Substitute Document in FI-CA Show values
APPLK Application Area Show values
XANZA Item is a Down Payment/Down Payment Request Show values
STAKZ Type of statistical item Show values
VERKZ Item Can Only Be Cleared Show values
XMANL Exclude Item from Dunning Run Show values
TXRUL Update Rule for Tax and Tax Clearing Show values
XAESP Printing - No Changes Possible Show values
AUGOB Item Canceled Show values
XEIPH Create Line Item in General Ledger Show values
XAUGP Check Sample Record Clearing Show values
XTAUS Item Split Show values
AUGRS Clearing restriction Show values
PDTYP Category of Payment Specification Show values
INFOZ Doubtful Item Entry/Individual Value Adjustment Show values
EUROU Status of Euro Conversion Show values
XRAGL Clearing posting reversed Show values
XWHPO Expanded Repetition Item Show values
ASTKZ Statistical Key of the Initiating Item Show values
RNDPS Type of Rounding Item Show values
QSPTP Line Item Category From Withholding Tax View Show values
XWHEX Variable Withholding Tax in DFKKOPWH Show values
XPYOR Item Included in a Payment Order Show values
INTBU Reason for Automatic Creation of Posting Show values
C4EYP Editing Process To Be Confirmed Show values
STZAL Status of Payment Processing Show values
NEGBU Control Field for Negative Posting Show values
SUBAP Subapplication in Contract Accounts Receivable and Payable Show values
XCOLC Item Is Included in Collection Case Show values
AASTA Control Field for Account Assignment Distributions Show values
XCSHA Document Contains Assignments from Cash Flows Show values
XUSTPD Tax on Sales/Purchases Was Calculated by Document Show values
PTITM Status of Partner Settlement Using Billable Items Show values
PALIX Item Is Part of a Collaborative Liability Show values
PNHKF SEPA: Origin of Direct Debit Pre-Notification Show values
PNCTR SEPA: Requirement for a Pre-Notification Show values
RDSTA Current Distribution Status Show values
RDSTB Last Distribution Status Reported Show values
FASTA Factoring: Current Status of Receivable Show values
PASTA Factoring: Check Status for Clearing Information Show values
FMTYP Update Method for FM - FI-CA Integration Show values
INTOP Internal Generation Characteristic for Document Item Show values
INTTX Internal Tax Characteristic for Tax Handling Show values
RCSTA Reconnection Status Show values
FULPA Only Full Payment Allowed Show values
INFPA Inform About Payment Show values
COPY Simulated Clearing Item Show values
MARK Checkbox Show values
Column Name Description Domain name
MANDT Client MANDT
OPBEL Number of a FI-CA Document OPBEL_KK
OPUPW Repetition Item in FI-CA Document OPUPW_KK
OPUPK Item Number in FI-CA Document OPUPK_KK
OPUPZ Subitem for a Partial Clearing in Document OPUPZ_KK
PRCTR Profit Center PRCTR
VTREF Reference Specifications from Contract VTREF_KK
VTPOS Contract: Item Number VTPOS_KK
VTRE2 Additional Reference Information VTREF_KK
ABWBL Number of the Substitute FI-CA Document ABWBL_KK
ABWKT Alternative Contract Account for Collective Bills VKONT_KK
KOFIZ Account Determination ID KOFIZ_KK
MWSZKZ Supplementary Tax MWSKZ
OPTXT Item text TEXT50
SKTPZ Cash Discount Percentage Rate PRZ23
KURSF Exchange rate KURSF
PYMET Payment Method PYMET_KK
PERNR Personnel Number PERNR
GRKEY Grouping Key for Displaying Open Items CHAR3
AUGBL Clearing Document or Printed Document AUGBL_KK
WHANG Number of repetition items NUM03
WHGRP Repetition group WHGRP_KK
FDZTG Additional Days for Cash Management NUM2
PYGRP Grouping field for automatic payments CHAR10
KONTL Acct assnmnt string for industry-specific account assngments CHAR50
OPSTA Dunning indicator OPSTA_KK
EMADR Address Number AD_ADDRNUM
ASBLG Number of Triggering Document OPBEL_KK
XBLNR Reference document number XBLNR_KK
INKPS Collection Item NUM03
QSSEW Withholding Tax Supplement QSSEW_KK
QSPRZ Withholding Tax Percentage STPRZ_KK
QSZNR Certificate Number of the Withholding Tax Exemption CHAR10
RFUPK Reference Item In FI-CA Document OPUPK_KK
EMCRD Alternative Payment Card ID in Document CHAR6
C4EYE Check Reason for Workflows Acc. to Dual Control Principle C4EYE_KK
CFOPN CFOP Code and Extension J_1BCFOP
TXGRP Grouping Key for Tax Items CHAR6
ORUPZ Subitem Number before Item Split CHAR3
PSGRP Grouping Key for Document Items CHAR4
REACC Originating Account in Cash Flow Anlaysis SAKNR
REBUK Partner Company Code for Cash Flow Analysis BUKRS
EMMND SEPA Mandate Identifier NUM06
PNNUM SEPA: Number of Direct Debit Pre-Notification PNNUM_KK
FINRE Contract Account of Final Recipient VKONT_KK
OPUPF Subitems in Factoring OPUPZ_KK
ORIGFIKRS Original FM Area for FM Account Assignment FIKRS
FIPEX Commitment Item FM_FIPEX
FISTL Funds Center FISTL
FONDS Fund BP_GEBER
FKBER Functional Area FKBER
MEASURE Funded Program FM_MEASURE
GRANT_NBR Grant GM_GRANT_NBR
BUDGETYEAR Original Year for FM Account Assignment GJAHR
BUDGET_PD Budget Period FM_BUDGET_PERIOD
COLOGRP Colocation Group for Business Partner COLOGRP_KK
HERKF_KK Document Origin Key HERKF_KK
/SAPCE/FKRU_CN Number of corrected document OPBEL_KK
/SAPCE/FKRU_RN Revision Number /SAPCE/FKRU_RNUM
TAXC_FACTOR Factor for Conversion into Tax Country/Region Currency FINS_T2ANY_CRCY_CONV_FACTOR
AWTYP_OP Reference Transaction in Business Partner Item AWTYP
AWKEY_OP Reference Key in Business Partner Item AWKEY
BCODE Branch Code BCODE_KK
BENT1 Service Type BENTY_KK
ISSRB ISS Tax Rate for Simples PRZ22
DUMMY_FKKOP_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes
Master Data Relations Join Conditions
Clearing Reason DFKKOP_REP.AUGRD == TFK001A.AUGRD
Additional Clearing Restriction DFKKOP_REP.AUGRE == TFK004AR.AUGRE
Document Type
  • Application Area
  • Document Type
  • DFKKOP_REP.MANDT == TFK003.MANDT
  • DFKKOP_REP.APPLK == TFK003.APPLK
  • DFKKOP_REP.BLART == TFK003.BLART
Company Code
  • DFKKOP_REP.MANDT == T001.MANDT
  • DFKKOP_REP.BUKRS == T001.BUKRS
Business Place
  • Company Code
  • Business Place
  • Client
  • ?
Clearing Lock Reason
  • Clearing Lock Reason
  • Client
  • DFKKOP_REP.CLRLOCK == TFK000S.SPPOS
  • DFKKOP_REP.MANDT == TFK000S.MANDT
Bank Details ID of Payee
  • Bank Details ID of Payee
  • Client
  • Alternative Business Partner for Payments
  • DFKKOP_REP.EMBVT == BUT0BK.BKVID
  • DFKKOP_REP.MANDT == BUT0BK.MANDT
  • DFKKOP_REP.EMGPA == BUT0BK.PARTNER
Alternative Business Partner for Payments
  • Alternative Business Partner for Payments
  • Client
  • DFKKOP_REP.EMGPA == BUT000.PARTNER
  • DFKKOP_REP.MANDT == BUT000.CLIENT
Planning Group
  • DFKKOP_REP.MANDT == T035.MANDT
  • DFKKOP_REP.FDGRP == T035.GRUPP
Planning level
  • DFKKOP_REP.MANDT == T036.MANDT
  • DFKKOP_REP.FDLEV == T036.EBENE
Tax type
Business Partner Number
  • Business Partner Number
  • Client
  • DFKKOP_REP.GPART == BUT000.PARTNER
  • DFKKOP_REP.MANDT == BUT000.CLIENT
Business Area
  • DFKKOP_REP.MANDT == TGSB.MANDT
  • DFKKOP_REP.GSBER == TGSB.GSBER
General ledger account
  • ?
  • Client
  • General ledger account
  • DFKKOP_REP.[column in domain "KTOPL"] == SKA1.KTOPL
  • DFKKOP_REP.MANDT == SKA1.MANDT
  • DFKKOP_REP.HKONT == SKA1.SAKNR
Main Transaction for Line Item
  • Application Area
  • Main Transaction for Line Item
  • DFKKOP_REP.MANDT == TFKHVO.MANDT
  • DFKKOP_REP.APPLK == TFKHVO.APPLK
  • DFKKOP_REP.HVORG == TFKHVO.HVORG
Check on Validity of Interest Key
Account Assignment Category DFKKOP_REP.KONTT == TFK000K.KONTT
Destination Country/Region (for Tax Reports)
  • Destination Country/Region (for Tax Reports)
  • Client
  • DFKKOP_REP.LANDL == T005.LAND1
  • DFKKOP_REP.MANDT == T005.MANDT
Dunning Procedure
  • Dunning Procedure
  • Client
Dunning Lock Reason
  • Dunning Lock Reason
  • Client
Account for posting taxes for down payments
  • ?
  • Client
  • Account for posting taxes for down payments
  • DFKKOP_REP.[column in domain "KTOPL"] == SKA1.KTOPL
  • DFKKOP_REP.MANDT == SKA1.MANDT
  • DFKKOP_REP.MWSKO == SKA1.SAKNR
Tax on sales/purchases code
  • ?
  • Tax on sales/purchases code
  • DFKKOP_REP.MANDT == T007A.MANDT
  • DFKKOP_REP.[column in domain "KALSM_D"] == T007A.KALSM
  • DFKKOP_REP.MWSKZ == T007A.MWSKZ
Account for offsetting tax posting in down payments
  • ?
  • Client
  • Account for offsetting tax posting in down payments
  • DFKKOP_REP.[column in domain "KTOPL"] == SKA1.KTOPL
  • DFKKOP_REP.MANDT == SKA1.MANDT
  • DFKKOP_REP.MWVKO == SKA1.SAKNR
Key for Period Assignment
Company Code for Automatic Payment Transactions
  • DFKKOP_REP.MANDT == T001.MANDT
  • DFKKOP_REP.PYBUK == T001.BUKRS
Withholding Tax Code
  • ?
  • Client
  • Withholding Tax Code
  • DFKKOP_REP.[column in domain "LAND1"] == T059Q.LAND1
  • DFKKOP_REP.MANDT == T059Q.MANDT
  • DFKKOP_REP.QSSKZ == T059Q.QSSKZ
Segment for Segmental Reporting
Division
  • DFKKOP_REP.MANDT == TSPA.MANDT
  • DFKKOP_REP.SPART == TSPA.SPART
Interest Lock Reason
  • Interest Lock Reason
  • Client
Lock Reason for Automatic Payment
  • DFKKOP_REP.MANDT == TFK008.MANDT
  • DFKKOP_REP.SPZAH == TFK008.ZAHLS
Tax Code for Other Taxes
  • ?
  • Tax Code for Other Taxes
  • DFKKOP_REP.MANDT == TFK007F.MANDT
  • DFKKOP_REP.[column in domain "LAND"] == TFK007F.LAND
  • DFKKOP_REP.STRKZ == TFK007F.STRKZ
Tax Reporting Country/Region
  • Tax Reporting Country/Region
  • Client
  • DFKKOP_REP.TAX_COUNTRY == T005.LAND1
  • DFKKOP_REP.MANDT == T005.MANDT
Subtransaction for Document Item
  • Main Transaction for Line Item
  • Application Area
  • Subtransaction for Document Item
  • DFKKOP_REP.MANDT == TFKTVO.MANDT
  • DFKKOP_REP.HVORG == TFKTVO.HVORG
  • DFKKOP_REP.APPLK == TFKTVO.APPLK
  • DFKKOP_REP.TVORG == TFKTVO.TVORG
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • DFKKOP_REP.MANDT == TTXJ.MANDT
  • DFKKOP_REP.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • DFKKOP_REP.TXJCD == TTXJ.TXJCD
Company ID of Trading Partner
  • DFKKOP_REP.MANDT == T880.MANDT
  • DFKKOP_REP.VBUND == T880.RCOMP
Contract Account Number
  • DFKKOP_REP.MANDT == FKKVK.MANDT
  • DFKKOP_REP.VKONT == FKKVK.VKONT
Transaction Currency
  • DFKKOP_REP.MANDT == TCURC.MANDT
  • DFKKOP_REP.WAERS == TCURC.WAERS