SAP table DFKKINV_TRIG (Invoicing Request)

SAP table DFKKINV_TRIG has 3 primary key fields being MANDT,SRCDOCCAT,SRCDOCNO.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
SRCDOCCAT Category of Source Document To Be Invoiced CHAR 5 0 TFK2605C SRCDOCCAT_KK
SRCDOCNO Number of Source Document to Be Invoiced CHAR 20 0 SRCDOCNO_KK
SRCDOCTYPE Type of Source Document to Be Invoiced CHAR 3 0 TFK2605SC SRCDOCTYPE_KK
LOG_SYSTEM Logical system CHAR 10 0 TBDLS LOGSYS
APPLK Application Area CHAR 1 0 APPLK_KK
* Valid for all application areas
C Convergent FI-CA
M Media Companies
P Public Administration
R Utility company
S Extended FI-CA
T Telecommunications
V Insurance company
X In-house development
SRCPROCESS Origin Process of Billing Document NUMC 4 0 TFK2641 SRCPROCESS_KK
SRCPROC_REF External Run Reference of Source Process CHAR 32 0 SRCPROC_REF_KK
TECHDOCTYPE Type of Technical Billing/Invoicing Document CHAR 1 0 TECHDOCTYPE_KK
1 Technical Document Based on Technical Master Data
2 Posting Not Needed
3 Document Contains Only Simulated Items
4 Posting and Invoicing Items Are Not Required
5 Only Simulated Invoicing Possible
6 Accrual/Deferral Posting
TARGPROCESS Target Process That Invoices the Source Document CHAR 4 0 TFK2642 TARGPROCESS_KK
BUKRS Company Code CHAR 4 0 BUKRS
GPART Business Partner Number CHAR 10 0 BUT000 GPART_KK
GPART_SEL Business Partners Relevant for Document Selection CHAR 10 0 * GPART_SEL_KK
VKONT Contract Account Number CHAR 12 0 FKKVK VKONT_KK
VKONT_SEL Contract Account Relevant for Document Selection CHAR 12 0 * VKONT_SEL_KK
MDCAT Type of Master Record for Convergent Invoicing CHAR 1 0 MDCAT_CI_KK
Master Data of Contract Accounts A/R & A/P
T Technical Master Data for Billing and Invoicing
GPART_SRCDOC Business Partner Number CHAR 10 0 * GPART_KK
VKONT_SRCDOC Contract Account Number CHAR 12 0 VKONT_KK
ABWVK Alternative Contract Account for Collective Bills CHAR 12 0 FKKVK ABWVK_KK
VTREF Reference Specifications from Contract CHAR 20 0 VTREF_KK
SUBAP Subapplication in Contract Accounts Receivable and Payable CHAR 1 0 SUBAP_KK
No Contract Reference/Primary Contract
9 Real Estate
BUPLA Business Place CHAR 4 0 * BUPLA
SPART Division CHAR 2 0 TSPA SPART_KK
WAERS Transaction Currency CUKY 5 0 TCURC BLWAE_KK
SRCDOC_AMOUNT Posting-Relevant Total Amount of Source Document CURR 13 2 SRCDOC_AMOUNT_KK
DATE_FROM Start of Document Period DATS 8 0 BILL_PERIOD_FROM_KK
DATE_TO End of Document Period DATS 8 0 BILL_PERIOD_TO_KK
INV_CATEGORY Invoicing Category CHAR 4 0 TFK2604 INV_CATEGORY_KK
CORRCAT Category of Invoice Correction CHAR 2 0 CORRCAT_KK
C0 Credit Memo
C1 Credit Memo (Adjustment of Original Invoice)
D0 Debit Memo
D1 Debit Memo (Adjustment of Original Invoice)
R0 Invoice Correction
PTSRL Partner Settlement Rule CHAR 4 0 * PTSRL_KK
SEPARATE_INV Control of Invoicing Unit CHAR 1 0 SEPARATE_INV_KK
No restrictions
0 Do not invoice document with other source document
1 Only invoice document with other source document
INVOICE_BASEDATE Baseline Date for Period Assignment in Invoicing DATS 8 0 INVOICE_BASEDATE_KK
INVOICE_FIRST Target Date for Invoicing DATS 8 0 INVOICE_FIRST_KK
FAEDN_SEL Due Date for Selection of Invoicing Orders DATS 8 0 FAEDN_SEL_KK
CRNAME User Who Created the Invoicing Request CHAR 12 0 INVTRIG_CRNAM_KK
CRDATE Creation Date of Invoicing Request DATS 8 0 INVTRIG_CRDAT_KK
SRCDOC_CRDATE Date of Creation of Source Document DATS 8 0 SRCDOC_CRDAT_KK
RECNUM Total Number of Items of a Source Document INT4 10 0 SRCDOC_RECNUM_KK
KEYPP 3-Byte field CHAR 3 0 CHAR3
ARCHIVED Document Is Archived CHAR 1 0 ARCHIVED_KK
INVDOCNO_OLD Document Number of Last Invoicing of Source Document NUMC 12 0 INVDOCNO_OLD_KK
INVTRIGLOCK Invoicing Order Is Locked for Invoicing CHAR 1 0 INVTRIGLOCK_KK
No Lock
O IS-U Print Document Is in Clarification
P Preliminary Invoicing Perfomed for Source Document
SIMULATED Invoicing Request Is Simulated CHAR 1 0 INVTRIG_SIMULATED_KK

DFKKINV_TRIG foreign key relationships

Table Field Check Table Check Field
0 DFKKINV_TRIG ABWVK FKKVK Contract Account Header VKONT
1 DFKKINV_TRIG GPART BUT000 BP: General data I PARTNER
0 DFKKINV_TRIG INV_CATEGORY TFK2604 Invoicing Categories MANDT
0 DFKKINV_TRIG INV_CATEGORY TFK2604 Invoicing Categories INV_CATEGORY
1 DFKKINV_TRIG LOG_SYSTEM TBDLS Logical system LOGSYS
0 DFKKINV_TRIG SPART TSPA Organizational Unit: Sales Divisions MANDT
0 DFKKINV_TRIG SPART TSPA Organizational Unit: Sales Divisions SPART
1 DFKKINV_TRIG SRCDOCCAT TFK2605C Source Document Categories SRCDOCCAT
0 DFKKINV_TRIG SRCPROCESS TFK2641 Origin Process of Billing Document SRCPROCESS
1 DFKKINV_TRIG VKONT FKKVK Contract Account Header VKONT
0 DFKKINV_TRIG WAERS TCURC Currency Codes MANDT
0 DFKKINV_TRIG WAERS TCURC Currency Codes WAERS