DFKKIPBW_ITEM SAP table for – Installment Plan Items for Business Warehouse

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

SAP DFKKIPBW_ITEM table

Table DFKKIPBW_ITEM technical data

TableDFKKIPBW_ITEM
Data storingInstallment Plan Items for Business Warehouse
ModuleFI
Sub ModuleFI-CA
SAP PackageFKKBW
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKIPBW_ITEM 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 DFKKIPBW_ITEM 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
  • RECORDMODE : BW Delta Procedure: Update Mode
    Its data type is CHAR (Character String) with field length 1
  • 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
  • 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
  • SPART : Division
    Its data type is CHAR (Character String) with field length 2
  • 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
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BETRH : Amount In Local Currency With +/- Signs
    Its data type is CURR (Currency Field) with field length 13
  • HWAER : Local Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • AUGDT : Clearing 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
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes