DFKKINVDOC_I SAP table for – Items of Invoicing Document

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

SAP DFKKINVDOC_I table

Table DFKKINVDOC_I technical data

TableDFKKINVDOC_I
Data storingItems of Invoicing Document
ModuleFI
Sub ModuleFI-CA-INV
SAP PackageFKKINV
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKINVDOC_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 DFKKINVDOC_I table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • INVDOCNO : Number of Invoicing Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 12
  • INVDOCITEM : 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 Invoicing Document Item
  • ITEMTYPE : Type of Invoicing Item
    Its data type is CHAR (Character String) with field length 8
  • 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
  • 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
  • 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
  • TOTALREL : Consider Items In Invoice Final Amount
    Its data type is CHAR (Character String) with field length 1
  • 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
  • WAERS : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • BETRW : Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • KOFIZ : Account Determination ID
    Its data type is CHAR (Character String) with field length 2
  • TAX_DET_TYPE : Type of Tax Calculation
    Its data type is CHAR (Character String) with field length 2
  • TAXGR : Grouping Key for Tax Display
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • STRKZ : Tax Code for Other Taxes
    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
  • ERMWSKZ : Indicator: Tax Determination Code
    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
  • KTOSL : Transaction key for account determination
    Its data type is CHAR (Character String) with field length 3
  • KSCHL : Condition Type
    Its data type is CHAR (Character String) with field length 4
  • TAX_PERC : Tax Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6
  • TXDAT : Decisive Date for Calculating Taxes
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SBASW : Amount Subject to Tax in Transaction Currency (Tax Base Amt)
    Its data type is CURR (Currency Field) with field length 13
  • SBETW : Tax Amount in Transaction Currency with +/- Sign
    Its data type is CURR (Currency Field) with field length 13
  • STTAX : Tax Amount as Statistical Information in Document Currency
    Its data type is CURR (Currency 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
  • MENGE : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • FAEDN : Due date for net payment
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FAEDS : Due Date for Cash Discount
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SKTPZ : Cash discount rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • XSTUND : Item(s) Deferred until Invoice Due Date
    Its data type is CHAR (Character String) with field length 1
  • 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
  • CADOCTYPE : Reference Document Type of Posting Document for Invoicing
    Its data type is CHAR (Character String) with field length 4
  • OPBEL : Number of Contract Accts Rec. & Payable Doc.
    Its data type is CHAR (Character String) with field length 12
  • 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
  • AUGBL : Clearing Document or Printed Document
    Its data type is CHAR (Character String) with field length 12
  • AUGBW : Clearing Amount in Transaction Currency (With +/- Sign)
    Its data type is CURR (Currency Field) with field length 13
  • ITEM_CRMET : Creation Method of Invoicing Document Item
    Its data type is CHAR (Character String) with field length 1
  • INV_FUNCTION : Invoicing Function
    Its data type is CHAR (Character String) with field length 12
  • SRCDOCCAT : Category of Source Document To Be Invoiced
    Its data type is CHAR (Character String) with field length 5
  • SRCDOCNO : Number of Source Document to Be Invoiced
    Its data type is CHAR (Character String) with field length 20
  • SRCITEMCAT : Category of Source Document Item Invoiced
    Its data type is CHAR (Character String) with field length 5
  • SRCDOCITEM : Item of Invoiced Source Document
    Its data type is CHAR (Character String) with field length 20
  • .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