DFKKINV_BWTRIGH SAP table for – BI: History Record for Extraction of Invoicing Documents

Here we would like to draw your attention to DFKKINV_BWTRIGH 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_BWTRIGH is a SAP standard transp table used for storing BI: History Record for Extraction of Invoicing Documents related data in SAP. It comes under the package FKKINV.

SAP DFKKINV_BWTRIGH table

Table DFKKINV_BWTRIGH technical data

TableDFKKINV_BWTRIGH
Data storingBI: History Record for Extraction of Invoicing Documents
ModuleFI
Sub ModuleFI-CA-INV
SAP PackageFKKINV
Delivery ClassA – Application table (master and transaction data)
ComponentFI-CA
Table CategoryTRANSP

SAP DFKKINV_BWTRIGH 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_BWTRIGH 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
  • REQUNR : Request number for the data transfer
    Its a key field. Its data type is CHAR (Character String) with field length 30
  • EXUUID : UUID in X form (binary)
    Its a key field. Its data type is RAW (Byte string) with field length 16
  • INV_PROCESS : Invoicing Process
    Its data type is CHAR (Character String) with field length 2
  • CRDATE : Creation date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DOCTYPE : Document Type
    Its data type is CHAR (Character String) with field length 2
  • 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
  • BWTRIG_EXSTAT : Status of Extraction for BI Extraction Order
    Its data type is CHAR (Character String) with field length 1
  • EXDATE : Extraction Day
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXTIME : Time of Extraction
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • EXDURA : Duration of Extraction (hhmmss)
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • INVDOCNO : Number of Invoicing Document
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • INVDOCNO_FROM : Number of Invoicing Document
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • INVDOCNO_TO : Number of Invoicing Document
    Its data type is NUMC (Character String with Digits Only) with field length 12
  • CNT_INVDOC_EXTR : Number of Extracted Invoicing Documents
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CNT_INVDOC_ERR : Number of Canceled Extractions of Invoicing Documents
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • CNT_DS_LINES : Number of DataSource Items Created by Extractor
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10