DFKKINV_TRIG SAP table for – Invoicing Order

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

SAP DFKKINV_TRIG table

Table DFKKINV_TRIG technical data

TableDFKKINV_TRIG
Data storingInvoicing Order
ModuleFI
Sub ModuleFI-CA-INV
SAP PackageFKKINV
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SRCDOCCAT : Category of Source Document To Be Invoiced
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • SRCDOCNO : Number of Source Document to Be Invoiced
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • .INCLUDE : Invoicing Order (Data)
  • LOG_SYSTEM : Logical system
    Its data type is CHAR (Character String) with field length 10
  • APPLK : Application area
    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
  • GPART : Business Partner Number
    Its data type is CHAR (Character String) with field length 10
  • GPART_SEL : Business Partners Relevant for Document Selection
    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
  • VKONT_SEL : Contract Account Relevant for Document Selection
    Its data type is CHAR (Character String) with field length 12
  • ABWVK : Alternative contract account for collective bills
    Its data type is CHAR (Character String) with field length 12
  • VTREF : Reference Specifications from Contract
    Its data type is CHAR (Character String) with field length 20
  • SPART : Division
    Its data type is CHAR (Character String) with field length 2
  • WAERS : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DATE_FROM : Start of Document Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_TO : End of Document Period
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SEPARATE_INV : Invoice Document Separately
    Its data type is CHAR (Character String) with field length 1
  • INVOICE_FIRST : Earliest Date of Invoicing
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FAEDN_SEL : Due Date for Selection of Invoicing Orders
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRDATE : Created on
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INVDOCNO_OLD : Document Number of Last Invoicing of Source Document
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • .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