DFKKINV_BWTRIG SAP (BW: Group Extraction Order for Invoicing Documents/FIKEY) Table details
Description: BW: Group Extraction Order for Invoicing Documents/FIKEY
Related tables to DFKKINV_BWTRIG
Access table DFKKINV_BWTRIG
Table field list including key, data, relationships and ABAP select examples
DFKKINV_BWTRIG is a standard SAP Table which is used to store BW: Group Extraction Order for Invoicing Documents/FIKEY data and is available within R/3 SAP systems depending on the version and release level.
The DFKKINV_BWTRIG table consists of various fields, each holding specific information or linking keys about BW: Group Extraction Order for Invoicing Documents/FIKEY data available in SAP. These include APPLK (Application area), DATASOURCE (Invoicing DataSource (Sales Statistics)), BUDAT (Posting Date in the Document), FIKEY (Reconciliation Key for General Ledger).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DFKKINV_BWTRIG table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
APPLK | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
DATASOURCE | Invoicing DataSource (Sales Statistics) | INV_DATASOURCE_KK | CHAR | 30 | ROOSOURCED | RO1 | FKKINV_DATASOURCE | ||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
FIKEY | Reconciliation Key for General Ledger | FIKEY_KK | CHAR | 12 | Assigned to domain | FIKEY_KK | FKFI1 | ||
INV_PROCESS | Invoicing Process | INV_PROCESS_KK | CHAR | 2 | TFK2602 | INV_PROCESS_KK | |||
DOCTYPE | Document Type of Invoicing Document | INVDOC_DOCTYPE_KK | CHAR | 2 | DOCTYPE_KK | ||||
CRDATE | Creation Date of Invoicing Document | INVDOC_CRDAT_KK | DATS | 8 | DATUM | ||||
BWTRIG_CRMODE | Creation Mode of BI Extraction Order | BWTRIG_CRMODE_KK | CHAR | 1 | BWTRIG_CRMODE_KK | ||||
BWTRIG_CRDATE | Creation Date of BI Extraction Order | BWTRIG_CRDAT_KK | DATS | 8 | DATUM | ||||
BWTRIG_CRTIME | Time of Creation of BI Extraction Request | BWTRIG_CRTIM_KK | TIMS | 6 | UZEIT | ||||
BWTRIG_CRREQUNR | Request Number of Creation of BI Extraction Order | BWTRIG_CRREQUNR_KK | CHAR | 30 | RSREQUNR | ||||
REQUNR_LAST | Request number for the data transfer | RSREQUNR | CHAR | 30 | RSREQUNR | ||||
INVDOC_LAST | Last Invoicing Document Extracted to BI | INVDOC_BWUPD_KK | NUMC | 12 | Assigned to domain | INVDOCNO_KK | |||
INVDOCITEM_LAST | Last Invoicing Item Selected | INVDOCITEM_LAST_KK | NUMC | 8 | INVDOCITEM_KK |
Key field | Non-key field |
How do I retrieve data from SAP table DFKKINV_BWTRIG using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKINV_BWTRIG to SELECT all data from the tableDATA: WA_DFKKINV_BWTRIG TYPE DFKKINV_BWTRIG.
SELECT SINGLE *
FROM DFKKINV_BWTRIG
INTO CORRESPONDING FIELDS OF WA_DFKKINV_BWTRIG
WHERE...
How to access SAP table DFKKINV_BWTRIG
Within an ECC or HANA version of SAP you can also view further information about DFKKINV_BWTRIG and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects