DFKKINV_BWTRIG SAP table for – BW: Group Extraction Order for Invoicing Documents/FIKEY

Here we would like to draw your attention to DFKKINV_BWTRIG 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_BWTRIG is a SAP standard transp table used for storing BW: Group Extraction Order for Invoicing Documents/FIKEY related data in SAP. It comes under the package FKKINV.

SAP DFKKINV_BWTRIG table

Table DFKKINV_BWTRIG technical data

TableDFKKINV_BWTRIG
Data storingBW: Group Extraction Order for Invoicing Documents/FIKEY
ModuleFI
Sub ModuleFI-CA-INV
SAP PackageFKKINV
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKINV_BWTRIG 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_BWTRIG table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • APPLK : Application area
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • DATASOURCE : Invoicing DataSource (Sales Statistics)
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • BUDAT : Posting Date in the Document
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FIKEY : Reconciliation Key for General Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • INV_PROCESS : Invoicing Process
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • DOCTYPE : Document Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • CRDATE : Creation date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BWTRIG_CRMODE : Creation Mode of BI Extraction Order
    Its data type is CHAR (Character String) with field length 1
  • BWTRIG_CRDATE : Date BI Extraction Order Was Created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BWTRIG_CRTIME : Time of Creation of BI Extraction Order
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • BWTRIG_CRREQUNR : Request Number for Creation of BI Extraction Order
    Its data type is CHAR (Character String) with field length 30
  • REQUNR_LAST : Request number for the data transfer
    Its data type is CHAR (Character String) with field length 30
  • INVDOC_LAST : Last Invoicing Document Extracted to BW
    Its data type is NUMC (Character String with Digits Only) with field length 12