DFKKOP SAP table for – Items in contract account document

Here we would like to draw your attention to DFKKOP table in SAP. As we know it is being mainly used with the SAP FI-CA (Contract Accounts Receivable and Payable in FI) component which is coming under FI module (Financial Accounting). DFKKOP is a SAP standard transp table used for storing Items in contract account document related data in SAP. It comes under the package FKKB.

SAP DFKKOP table

Table DFKKOP technical data

TableDFKKOP
Data storingItems in contract account document
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKB
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKOP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in DFKKOP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • OPUPW : Repetition Item in Contract Account Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • OPUPK : Item number in contract account document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • OPUPZ : Subitem for a Partial Clearing in Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • SEGMENT : Segment for Segmental Reporting
    Its data type is CHAR (Character String) with field length 10
  • AUGST : Clearing status
    Its data type is CHAR (Character String) with field length 1
  • GPART : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • VTREF : Reference Specifications from Contract
    Its data type is CHAR (Character String) with field length 20
  • VTRE2 : Additional Reference Information
    Its data type is CHAR (Character String) with field length 20
  • VKONT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • ABWBL : Number of the substitute FI-CA document
    Its data type is CHAR (Character String) with field length 12
  • ABWTP : Category of substitute document in FI-CA
    Its data type is CHAR (Character String) with field length 1
  • ABWKT : Alternative contract account for collective bills
    Its data type is CHAR (Character String) with field length 12
  • APPLK : Application area
    Its data type is CHAR (Character String) with field length 1
  • HVORG : Main Transaction for Line Item
    Its data type is CHAR (Character String) with field length 4
  • TVORG : Subtransaction for Document Item
    Its data type is CHAR (Character String) with field length 4
  • KOFIZ : Account Determination ID
    Its data type is CHAR (Character String) with field length 2
  • SPART : Division
    Its data type is CHAR (Character String) with field length 2
  • HKONT : General ledger account
    Its data type is CHAR (Character String) with field length 10
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • MWSZKZ : Supplementary Tax
    Its data type is CHAR (Character String) with field length 2
  • XANZA : Item is a Down Payment/Down Payment Request
    Its data type is CHAR (Character String) with field length 1
  • STAKZ : Type of statistical item
    Its data type is CHAR (Character String) with field length 1
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • OPTXT : Item text
    Its data type is CHAR (Character String) with field length 50
  • WAERS : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FAEDN : Due date for net payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FAEDS : Due Date for Cash Discount
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VERKZ : Item Can Only Be Cleared
    Its data type is CHAR (Character String) with field length 1
  • STUDT : Deferral to
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKTPZ : Cash discount rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • XMANL : Exclude Item from Dunning Run
    Its data type is CHAR (Character String) with field length 1
  • KURSF : Exchange rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • BETRH : Amount In Local Currency With +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • BETR2 : Amount in second parallel currency with +/- sign
    Its data type is CURR (Currency Field) with field length 13
  • BETR3 : Amount in third parallel currency with +/- sign
    Its data type is CURR (Currency Field) with field length 13
  • SKFBT : Amount eligible for cash discount in document currency
    Its data type is CURR (Currency Field) with field length 13
  • SBETH : Tax Amount in Local Currency With +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • SBETW : Tax Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • SBET2 : Tax amount in second parallel currency
    Its data type is CURR (Currency Field) with field length 13
  • SBET3 : Tax amount in third parallel currency
    Its data type is CURR (Currency Field) with field length 13
  • MWSKO : Account for posting taxes for down payments
    Its data type is CHAR (Character String) with field length 10
  • MWVKO : Account for offsetting tax posting in down payments
    Its data type is CHAR (Character String) with field length 10
  • TXRUL : Update Rule for Tax and Tax Clearing
    Its data type is CHAR (Character String) with field length 1
  • SPZAH : Lock Reason for Automatic Payment
    Its data type is CHAR (Character String) with field length 1
  • PYMET : Payment Method
    Its data type is CHAR (Character String) with field length 1
  • PYBUK : Company Code for Automatic Payment Transactions
    Its data type is CHAR (Character String) with field length 4
  • PERNR : Personnel Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • GRKEY : Grouping Key for Displaying Open Items
    Its data type is CHAR (Character String) with field length 3
  • PERSL : Key for Period Assignment
    Its data type is CHAR (Character String) with field length 4
  • XAESP : Printing – No Changes Possible
    Its data type is CHAR (Character String) with field length 1
  • AUGDT : Clearing date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUGBL : Clearing Document or Printed Document
    Its data type is CHAR (Character String) with field length 12
  • AUGBD : Clearing document posting date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUGRD : Clearing Reason
    Its data type is CHAR (Character String) with field length 2
  • AUGWA : Clearing currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • AUGBT : Clearing amount in clearing currency
    Its data type is CURR (Currency Field) with field length 13
  • AUGBS : Tax amount in clearing currency
    Its data type is CURR (Currency Field) with field length 13
  • AUGSK : Cash Discount Granted/Surcharge Levied in Clearing Currency
    Its data type is CURR (Currency Field) with field length 13
  • AUGVD : Value date for clearing
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUGOB : Item Canceled
    Its data type is CHAR (Character String) with field length 1
  • WHANG : Number of repetition items
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • WHGRP : Repetition group
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • XEIPH : Create Line Item in General Ledger
    Its data type is CHAR (Character String) with field length 1
  • MAHNV : Dunning Procedure
    Its data type is CHAR (Character String) with field length 2
  • MANSP : Dunning Lock Reason
    Its data type is CHAR (Character String) with field length 1
  • XAUGP : Check Sample Record Clearing
    Its data type is CHAR (Character String) with field length 1
  • ABRZU : Lower Limit of Settlement Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ABRZO : Upper Limit of the Billing Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FDGRP : Planning Group
    Its data type is CHAR (Character String) with field length 10
  • FDLEV : Planning level
    Its data type is CHAR (Character String) with field length 2
  • FDZTG : Additional Days for Cash Management
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • FDWBT : Planned Amount in Document or G/L Account Currency
    Its data type is CURR (Currency Field) with field length 13
  • XTAUS : Item Split
    Its data type is CHAR (Character String) with field length 1
  • AUGRS : Clearing restriction
    Its data type is CHAR (Character String) with field length 1
  • PYGRP : Grouping field for automatic payments
    Its data type is CHAR (Character String) with field length 10
  • PDTYP : Category of Payment Specification
    Its data type is CHAR (Character String) with field length 1
  • SPERZ : Interest Lock Reason
    Its data type is CHAR (Character String) with field length 1
  • INFOZ : Doubtful Item Entry/Individual Value Adjustment
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • TXDAT : Decisive Date for Calculating Taxes
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • KONTT : Account Assignment Category
    Its data type is CHAR (Character String) with field length 2
  • KONTL : Acct assnmnt string for industry-specific account assngments
    Its data type is CHAR (Character String) with field length 50
  • OPSTA : Dunning indicator
    Its data type is CHAR (Character String) with field length 3
  • BLART : Document Type
    Its data type is CHAR (Character String) with field length 2
  • EMGPA : Alternative business partner for payments
    Its data type is CHAR (Character String) with field length 10
  • EMBVT : Bank Details ID of Payee
    Its data type is CHAR (Character String) with field length 4
  • EMADR : Address number
    Its data type is CHAR (Character String) with field length 10
  • IKEY : Interest Key
    Its data type is CHAR (Character String) with field length 2
  • EUROU : Status of Euro Conversion
    Its data type is CHAR (Character String) with field length 1
  • XRAGL : Clearing posting reversed
    Its data type is CHAR (Character String) with field length 1
  • ASTKZ : Statistical Key of the Initiating Item
    Its data type is CHAR (Character String) with field length 1
  • ASBLG : Number of Triggering Document
    Its data type is CHAR (Character String) with field length 12
  • XBLNR : Reference document number
    Its data type is CHAR (Character String) with field length 16
  • INKPS : Collection Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • RNDPS : Type of Rounding Item
    Its data type is CHAR (Character String) with field length 1
  • QSSKZ : Withholding Tax Code
    Its data type is CHAR (Character String) with field length 2
  • QSSEW : Withholding Tax Supplement
    Its data type is CHAR (Character String) with field length 2
  • QSPTP : Line Item Category From Withholding Tax View
    Its data type is CHAR (Character String) with field length 1
  • QSSHB : Tax Base Amount
    Its data type is CURR (Currency Field) with field length 13
  • QBSHB : Withholding Tax Amount (in Document Currency)
    Its data type is CURR (Currency Field) with field length 13
  • QSZNR : Certificate Number of the Withholding Tax Exemption
    Its data type is CHAR (Character String) with field length 10
  • RFUPK : Reference Item In FI-CA Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • STRKZ : Tax Code for Other Taxes
    Its data type is CHAR (Character String) with field length 2
  • FITPR : Tax type
    Its data type is CHAR (Character String) with field length 2
  • XPYOR : Item Included in a Payment Order
    Its data type is CHAR (Character String) with field length 1
  • LANDL : Country Supplied (for Tax Notifications)
    Its data type is CHAR (Character String) with field length 3
  • INTBU : Reason for Automatic Creation of Posting
    Its data type is CHAR (Character String) with field length 1
  • EMCRD : Alternative Payment Card ID in Document
    Its data type is CHAR (Character String) with field length 6
  • C4EYE : Check Reason for Workflows Acc. to Dual Control Principle
    Its data type is CHAR (Character String) with field length 2
  • C4EYP : Editing Process To Be Confirmed
    Its data type is CHAR (Character String) with field length 1
  • SCTAX : Tax Portion in FI-CA Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • STTAX : Tax Amount as Statistical Information in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • STZAL : Status of Payment Processing
    Its data type is CHAR (Character String) with field length 1
  • ORUPZ : Subitem Number before Item Split
    Its data type is CHAR (Character String) with field length 3
  • NEGBU : Control Field for Negative Posting
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • SUBAP : Subapplication in Contract Accounts Receivable and Payable
    Its data type is CHAR (Character String) with field length 1
  • PSWSL : Update Currency for General Ledger Transaction Figures
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PSWBT : Amount for Updating in General Ledger
    Its data type is CURR (Currency Field) with field length 13
  • PSWTX : Tax Amount for Update in General Ledger
    Its data type is CURR (Currency Field) with field length 13
  • PSGRP : Grouping Key for Document Items
    Its data type is CHAR (Character String) with field length 4
  • EMMND : SEPA Mandate Identification
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • .INCLUDE : Direct Debit Pre-Notification in Document Item
  • PNNUM : SEPA: Number of Direct Debit Pre-Notification
    Its data type is CHAR (Character String) with field length 16
  • PNHKF : SEPA: Origin of Direct Debit Pre-Notification
    Its data type is CHAR (Character String) with field length 2
  • PNEXD : SEPA: Date of Execution of Direct Debit Pre-Notifcation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PNCTR : SEPA: Requirement for a Pre-Notification
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Structure for Revenue Distribution
  • FINRE : Contract Account of Final Recipient
    Its data type is CHAR (Character String) with field length 12
  • RDSTA : Current Distribution Status
    Its data type is CHAR (Character String) with field length 1
  • RDSTB : Last Distribution Status Reported
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Include: OI for Utility Companies: IS-U
  • .INCLUDE : Include OI for Insurance
  • .INCLUDE : IS-T: Include open items for telecommunications companies
  • .INCLUDE : Public Sector: Fields for Business Partner Items
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Include for FM Integration (OI)
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Include OI for IS-Media
  • .INCLUDE : FI-CA Extended: Include OI
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes