DFKKINVBILL_I SAP table for – Billing Document Items

Here we would like to draw your attention to DFKKINVBILL_I 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). DFKKINVBILL_I is a SAP standard transp table used for storing Billing Document Items related data in SAP. It comes under the package FKKINV.

SAP DFKKINVBILL_I table

Table DFKKINVBILL_I technical data

TableDFKKINVBILL_I
Data storingBilling Document Items
ModuleFI
Sub ModuleFI-CA-INV
SAP PackageFKKINV
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BILLDOCNO : Number of Billing Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 12
  • BILLDOCITEM : Sequential Number of Document Item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 8
  • .INCLUDE : Data of Billing Document Item
  • REFITEM : Number of Line Item in External System
    Its data type is CHAR (Character String) with field length 10
  • BILL_AMOUNT : Amount in Billing Document Item
    Its data type is CURR (Currency Field) with field length 13
  • BILL_CURR : Currency of Billing Document
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • ITEM_SIMULATED : Line Item Is Simulated
    Its data type is CHAR (Character String) with field length 1
  • REVERSALITEM : Indicator: Reversal Item
    Its data type is CHAR (Character String) with field length 1
  • POSTREL : Posting-Relevant Line Item
    Its data type is CHAR (Character String) with field length 1
  • PRINTREL : Line Item Is Relevant for Printing
    Its data type is CHAR (Character String) with field length 1
  • PRINT_SUBSTITUTE : Substitute Group for Invoice Printing
    Its data type is CHAR (Character String) with field length 4
  • DATE_FROM : Start of Period of Line Item
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_TO : End of Period of Line Item
    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
  • SPART : Division
    Its data type is CHAR (Character String) with field length 2
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • 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
  • TAX_GROUP : Grouping of Tax Items
    Its data type is CHAR (Character String) with field length 8
  • EXT_TAX_DATE : External Tax Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERMWSKZ : Indicator: Tax Determination Code
    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
  • STRKZ : Tax Code for Other Taxes
    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
  • QTY_UNIT : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • QTY_BW_REL : Quantity Is BW-Relevant
    Its data type is CHAR (Character String) with field length 1
  • QTY_FI_CO_REL : Quantity Is FI/CO-Relevant
    Its data type is CHAR (Character String) with field length 1
  • VTREF : Reference Specifications from Contract
    Its data type is CHAR (Character String) with field length 20
  • SUBAP : Subapplication in Contract Accounts Receivable and Payable
    Its data type is CHAR (Character String) with field length 1
  • ADD_GROUP : Grouping of Additional Items
    Its data type is CHAR (Character String) with field length 8
  • QUANTITY_PDP : Billing Quantity: Places before Decimal Point
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 17
  • QUANTITY_ADP : Billing Quantity: Places after Decimal Point
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 14
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Enhancement Billing Line for Public Sector
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes