DFKKOPK SAP table for – Items in contract account document

Here we would like to draw your attention to DFKKOPK 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). DFKKOPK 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 DFKKOPK table

Table DFKKOPK technical data

TableDFKKOPK
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 DFKKOPK 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 DFKKOPK 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
  • 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
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • HKONT : General ledger account
    Its data type is CHAR (Character String) with field length 10
  • 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
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • KDAUF : Sales Order Number
    Its data type is CHAR (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • KDEIN : Delivery schedule for sales order
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • PASUBNR : Profitability Segment Changes (CO-PA)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FDLEV : Planning level
    Its data type is CHAR (Character String) with field length 2
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • 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
  • WHGRP : Repetition group
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • STRKZ : Tax Code for Other Taxes
    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
  • 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
  • TXJCD : Tax Jurisdiction
    Its data type is CHAR (Character String) with field length 15
  • TXJCO : Jurisdiction code (specified value)
    Its data type is CHAR (Character String) with field length 15
  • TXCNT : Level Counter for Multi-Level Taxes in Tax Jurisdiction
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • TXDAT : Decisive Date for Calculating Taxes
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TXEXK : Key for tax exception
    Its data type is CHAR (Character String) with field length 16
  • SBASH : Amount Subject to Tax in Local Currency (Tax Base Amount)
    Its data type is CURR (Currency Field) with field length 13
  • SBASW : Amount Subject to Tax in Transaction Currency (Tax Base Amt)
    Its data type is CURR (Currency Field) with field length 13
  • KTOSL : Transaction key for account determination
    Its data type is CHAR (Character String) with field length 3
  • STPRZ : Tax rate
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • KSCHL : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • XEIPH : Create Line Item in General Ledger
    Its data type is CHAR (Character String) with field length 1
  • 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
  • XINTB : Item Created by Posting Interface
    Its data type is CHAR (Character String) with field length 1
  • EUROU : Status of Euro Conversion
    Its data type is CHAR (Character String) with field length 1
  • FIKEY : Reconciliation Key for General Ledger
    Its data type is CHAR (Character String) with field length 12
  • XCOPA : CO-PA update done directly
    Its data type is CHAR (Character String) with field length 1
  • MENGE : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • REGIO : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • COUNC : County Code
    Its data type is CHAR (Character String) with field length 3
  • GRICD : Activity Code for Gross Income Tax
    Its data type is CHAR (Character String) with field length 2
  • GITYP : Distribution Type for Employment Tax
    Its data type is CHAR (Character String) with field length 2
  • INTBU : Reason for Automatic Creation of Posting
    Its data type is CHAR (Character String) with field length 1
  • NEGBU : Control Field for Negative Posting
    Its data type is NUMC (Character String with Digits Only) 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
  • PSGRP : Grouping Key for Document Items
    Its data type is CHAR (Character String) with field length 4
  • INVGR : Grouping Key for Invoicing
    Its data type is CHAR (Character String) with field length 4
  • SCTAX : Tax Portion in FI-CA Local Currency
    Its data type is CURR (Currency Field) with field length 13
  • .INCLUDE : Include: OII for Utility Companies: IS-U
  • .INCLUDE : Insurance Include for Offsetting Items
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Public Sector: Fields for General Ledger Items
  • .INCLUDE : FI-CA Extended: Include G/L Items
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Include for FM Integration (OPK)
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Include for Funds Commitment (OPK)