DFKKOPBW SAP table for – OI Extraction

Here we would like to draw your attention to DFKKOPBW 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). DFKKOPBW is a SAP standard transp table used for storing OI Extraction related data in SAP. It comes under the package FKKBW.

SAP DFKKOPBW table

Table DFKKOPBW technical data

TableDFKKOPBW
Data storingOI Extraction
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKBW
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKOPBW 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 DFKKOPBW table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LAUFD : Date ID
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LAUFI : Additional Identification Characteristic
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • INTNR : Number of Interval within Variant (BW Extraction)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 7
  • RECNO : Record Number
    Its a key field. Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • KEYDT : Key Date for Analysis of Open Items
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RECCOUNT : Number of Summarized Items
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • .INCLUDE : Structure for OI Extraction
  • .INCLUDE : BW – Selected Fields from Items for Contract Acctg Document
  • 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
  • SPART : Division
    Its data type is CHAR (Character String) with field length 2
  • GPART : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 15
  • WAERS : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • VKONT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FAEDN : Due date for net payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BETRH : Amount in Local Currency with +/- Signs
    Its data type is CURR (Currency Field) with field length 15
  • HWAER : Local Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MAHNS : Dunning Level
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • INKPS : Collection Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : BW – Selected Fields from Contract Account
  • MAHNV : Dunning Procedure
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : BW – Selected Fields from Business Partner
  • ADDRNUMBER : Address number
    Its data type is CHAR (Character String) with field length 10
  • POST_CODE1 : City postal code
    Its data type is CHAR (Character String) with field length 10
  • COUNTRY : Country Key
    Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : BW Open Items – Derived Fields for Extraction
  • DELAY : Name of Grid
    Its data type is CHAR (Character String) with field length 14
  • .INCLUDE : BW Include for FM Integration (OI)
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Public Sector: Fields for Business Partner Items (BW)
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes