1. Home
  2. Resources
  3. SAP Tables
  4. DFKKINV_TRIG - Invoicing Order

SAP Table DFKKINV_TRIG

Invoicing Order

DFKKINV_TRIG (Invoicing Order) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DFKKINV_TRIG to other SAP tables.

DFKKINV_TRIG table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
SRCDOCCAT Category of Source Document To Be Invoiced SRCDOCCAT_KK CHAR 5 0
INVBI Billing Document
INFBI Billing Document (Informational)
VBRK SD Billing Document
SD SD Document (FI-CA Sample Document)
COLBI Collective Bill Document
SUBIN Single Invoicing Document for Invoicing List
ACTIT Open Posting Item To Be Activated
CYCLE Periodic Invoicing
ADHOC Ad Hoc Invoicing
PRLIN Preliminary Invoice
VBRKX SD Billing Doc. from Distributed System
SRCDOCNO Number of Source Document to Be Invoiced SRCDOCNO_KK CHAR 20 0
SRCDOCTYPE Type of Source Document to Be Invoiced SRCDOCTYPE_KK TFK2605S CHAR 3 0
LOG_SYSTEM Logical system LOGSYS TBDLS CHAR 10 0
APPLK Application area APPLK_KK CHAR 1 0
* Valid for all application areas
M Media Companies
P Public Administration
R Utility company
T Telecommunications
V Insurance company
X In-house development
S Extended FI-CA
SRCPROCESS Origin Process of Billing Document SRCPROCESS_KK TFK2641 NUMC 4 0
TECHDOCTYPE Type of Technical Billing/Invoicing Document TECHDOCTYPE_KK CHAR 1 0
1 Technical Document Based on Technical Master Data
2 Posting Not Needed
BUKRS Company Code BUKRS CHAR 4 0
GPART Business Partner Number GPART_KK BUT000 CHAR 10 0
GPART_SEL Business Partners Relevant for Document Selection GPART_SEL_KK BUT000 CHAR 10 0
VKONT Contract Account Number VKONT_KK FKKVK CHAR 12 0
VKONT_SEL Contract Account Relevant for Document Selection VKONT_SEL_KK FKKVK CHAR 12 0
MDCAT Type of Master Data for Billing and Invoicing MDCAT_CI_KK CHAR 1 0
NULL Master Data of Contract Accounts A/R & A/P
T Technical Master Data for Billing and Invoicing
GPART_SRCDOC Business Partner Number GPART_KK CHAR 10 0
VKONT_SRCDOC Contract Account Number VKONT_KK CHAR 12 0
ABWVK Alternative contract account for collective bills ABWVK_KK FKKVK CHAR 12 0
VTREF Reference Specifications from Contract VTREF_KK CHAR 20 0
SUBAP Subapplication in Contract Accounts Receivable and Payable SUBAP_KK CHAR 1 0
9 Real Estate
SPART Division SPART_KK TSPA CHAR 2 0
WAERS Transaction Currency BLWAE_KK TCURC CUKY 5 0
SRCDOC_AMOUNT Posting-Relevant Total Amount of Source Document SRCDOC_AMOUNT_KK CURR 13 2
DATE_FROM Start of Document Period BILL_PERIOD_FROM_KK DATS 8 0
DATE_TO End of Document Period BILL_PERIOD_TO_KK DATS 8 0
INV_CATEGORY Invoicing Category INV_CATEGORY_KK TFK2604 CHAR 4 0
PTSRL Partner Settlement Rule PTSRL_KK CHAR 4 0
SEPARATE_INV Control of Invoicing Unit SEPARATE_INV_KK CHAR 1 0
NULL 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 INVOICE_BASEDATE_KK DATS 8 0
INVOICE_FIRST Target Date for Invoicing INVOICE_FIRST_KK DATS 8 0
FAEDN_SEL Due Date for Selection of Invoicing Orders FAEDN_SEL_KK DATS 8 0
CRNAME User Who Created the Invoicing Order INVTRIG_CRNAM_KK CHAR 12 0
CRDATE Creation Date of Invoicing Order INVTRIG_CRDAT_KK DATS 8 0
SRCDOC_CRDATE Date of Creation of Source Document SRCDOC_CRDAT_KK DATS 8 0
RECNUM Total Number of Items of a Source Document SRCDOC_RECNUM_KK INT4 10 0
ARCHIVED Document Is Archived ARCHIVED_KK CHAR 1 0
X Yes
NULL No
INVDOCNO_OLD Document Number of Last Invoicing of Source Document INVDOCNO_OLD_KK NUMC 12 0
INVTRIGLOCK Invoicing Order Is Locked for Invoicing INVTRIGLOCK_KK CHAR 1 0
NULL No Lock
P Preliminary Invoicing Perfomed for Source Document
SIMULATED Invoicing Order Is Simulated INVTRIG_SIMULATED_KK CHAR 1 0
X Yes
NULL No
TARGPROCESS Target Process That Invoices the Billing Document TARGPROCESS_KK TFK2642 CHAR 4 0

DFKKINV_TRIG foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DFKKINV_TRIG ABWVK SYST MANDT FKKVK Contract Account Header MANDT
DFKKINV_TRIG ABWVK DFKKINV_TRIG ABWVK FKKVK Contract Account Header VKONT
DFKKINV_TRIG GPART SYST MANDT BUT000 BP: General data I CLIENT
DFKKINV_TRIG GPART DFKKINV_TRIG GPART BUT000 BP: General data I PARTNER
DFKKINV_TRIG GPART_SEL SYST MANDT BUT000 BP: General data I CLIENT
DFKKINV_TRIG GPART_SEL DFKKINV_TRIG GPART_SEL BUT000 BP: General data I PARTNER
DFKKINV_TRIG INV_CATEGORY SYST MANDT TFK2604 Invoicing Categories MANDT
DFKKINV_TRIG INV_CATEGORY DFKKINV_TRIG INV_CATEGORY TFK2604 Invoicing Categories INV_CATEGORY
DFKKINV_TRIG LOG_SYSTEM DFKKINV_TRIG LOG_SYSTEM TBDLS Logical system LOGSYS
DFKKINV_TRIG SPART SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
DFKKINV_TRIG SPART DFKKINV_TRIG SPART TSPA Organizational Unit: Sales Divisions SPART
DFKKINV_TRIG SRCDOCTYPE DFKKINV_TRIG MANDT TFK2605S Source Document Types MANDT
DFKKINV_TRIG SRCDOCTYPE DFKKINV_TRIG SRCDOCCAT TFK2605S Source Document Types SRCDOCCAT
DFKKINV_TRIG SRCDOCTYPE DFKKINV_TRIG SRCDOCTYPE TFK2605S Source Document Types SRCDOCTYPE
DFKKINV_TRIG SRCPROCESS DFKKINV_TRIG SRCPROCESS TFK2641 Origin Process of Billing Document SRCPROCESS
DFKKINV_TRIG TARGPROCESS DFKKINV_TRIG TARGPROCESS TFK2642 Target Process of Billing Document TARGPROCESS
DFKKINV_TRIG VKONT DFKKINV_TRIG VKONT FKKVK Contract Account Header VKONT
DFKKINV_TRIG VKONT SYST MANDT FKKVK Contract Account Header MANDT
DFKKINV_TRIG VKONT_SEL SYST MANDT FKKVK Contract Account Header MANDT
DFKKINV_TRIG VKONT_SEL DFKKINV_TRIG VKONT_SEL FKKVK Contract Account Header VKONT
DFKKINV_TRIG WAERS DFKKINV_TRIG WAERS TCURC Currency Codes WAERS
DFKKINV_TRIG WAERS SYST MANDT TCURC Currency Codes MANDT