DFKKCIBW SAP table for – FICA: Extraction of Cleared Items

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

SAP DFKKCIBW table

Table DFKKCIBW technical data

TableDFKKCIBW
Data storingFICA: Extraction of Cleared Items
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKBW
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKCIBW 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 DFKKCIBW 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
  • CIFROM : Key Date for Extraction
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CITO : Key Date to which Cleared Items Are Analyzed
    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 the Extraction of Cleared Items from FI-CA
  • .INCLUDE : CIBW – Fields from FI-CA Document Items
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • SPART : Division
    Its data type is CHAR (Character String) with field length 2
  • 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
  • AUGRD : Clearing Reason
    Its data type is CHAR (Character String) with field length 2
  • MAHNV : Dunning Procedure
    Its data type is CHAR (Character String) with field length 2
  • MAHNS : Dunning Level
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • 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
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • 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
  • AUGDT : Clearing date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GPART : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • VKONT : Contract Account Number
    Its data type is CHAR (Character String) with field length 12
  • .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 : CIBW – 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 (CI)
  • .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