SAP table DFKKINVBILL_H (Billing Document Header)

SAP table DFKKINVBILL_H has 2 primary key fields being MANDT,BILLDOCNO.

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
BILLDOCNO Number of Billing Document NUMC 12 0 BILLDOCNO_KK
REFDOCNO Document Number in External System CHAR 22 0 REFDOCNO_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
SRCDOCTYPE Source Document Type of Billing Document CHAR 3 0 SRCDOCTYPE_INVBI_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
DOCTYPE Document Type CHAR 2 0 TFK2600 DOCTYPE_KK
TARGPROCESS Target Process That Invoices the Source Document CHAR 4 0 TFK2642 TARGPROCESS_KK
GPART Business Partner Number for Billing and Invoicing CHAR 10 0 BUT000 GPART_CI_KK
VKONT Contract Account Number for Billing and Invoicing CHAR 12 0 FKKVK VKONT_CI_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_INV Alternative Business Partner for Invoicing CHAR 10 0 GPART_INV_KK
VKONT_INV Alternative Contract Account for Invoicing CHAR 12 0 VKONT_INV_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
BILL_BASEDATE Baseline Date for Period Assignment in Billing DATS 8 0 BILL_BASEDATE_KK
SIMULATED Billing Document Is Simulated CHAR 1 0 SIMULATED_KK
BILL_CURR Currency of Billing Document CUKY 5 0 * BILL_CURR_KK
INV_CURR Target Currency of Invoicing CUKY 5 0 TCURC INV_CURR_KK
TAX_DET_TYPE Type of Tax Calculation CHAR 2 0 TAX_DET_TYPE_KK
00 No Tax Calculation
01 Internal Tax Calculation
02 External Tax Calculation (Other Taxes)
03 External Tax Calculation with Backbilling
04 Telecommunications Tax (USA) w/ Ext. Tax System Integration
TAX_DATE_TYPE Type of Tax Date CHAR 2 0 TAX_DATE_TYPE_KK
No Internal Tax Calculation
01 Tax Calculation for Document Date
02 Tax Calculation for Posting Date
03 Tax Calculation for Date of Creation
04 Tax Calculation for External Tax Date
INV_CATEGORY Invoicing Category CHAR 4 0 TFK2604 INV_CATEGORY_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_FIRST Target Date for Invoicing DATS 8 0 INVOICE_FIRST_KK
REVREASON Reversal Reason for Billing Document CHAR 2 0 BILL_REVREASON_KK
REVERSALDOC Number of Reversal Document for Billing Document NUMC 12 0 REVERSALBILLDOC_KK
REVERSEDDOC Number of Reversed Billing Document NUMC 12 0 REVERSEDBILLDOC_KK
ADJUSTMENTDOC Number of Adjustment Billing Document NUMC 12 0 ADJUSTMENTBILLDOC_KK
ADJUSTEDDOC Number of Adjusted Billing Document NUMC 12 0 ADJUSTEDBILLDOC_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
TRIGDELETED Invoicing Order Deleted CHAR 1 0 TRIGDELETED_KK
XINFBILL Additional Statement in Another Invoice for Information Only CHAR 1 0 XINFBILL_KK
2 2 Additional Invoices for Information Only
3 3 Additional Invoices for Information Only
4 4 Additional Invoices for Information Only
5 5 Additional Invoices for Information Only
6 6 Additional Invoices for Information Only
7 7 Additional Invoices for Information Only
8 8 Additional Invoices for Information Only
9 9 or More Additional Invoices for Information Only
X 1 Additional Invoice for Information Only
XBILLAC Billing Document Is Relevant for Accrual/Deferral Posting CHAR 1 0 XBILLAC_KK
INVLOCK Billing Document Is Locked for Invoicing CHAR 1 0 INVLOCK_KK
No Invoicing Lock
0 Billing Document Reversed Before Invoicing
1 General Invoicing Lock
2 Technical Document, Not Relevant for Invoicing
3 No Invoicing as per Configuration of Billing
9 Manual Invoicing Lock
INVSTATUS Invoicing Status of Billing Document CHAR 1 0 INVSTATUS_KK
0 Not Yet Invoiced
1 Invoiced, a CI Invoicing Document Exists
2 Processed by External Invoicing
3 Invoiced, a Simulated CI Invoicing Document Exists
9 Not to Be Invoiced
INVDOCNO Number of Invoicing Document NUMC 12 0 INVDOCNO_KK
INVCRDATE Creation Date of Invoicing Document DATS 8 0 INVDOC_CRDAT_KK
ADD_GROUP Grouping of Additional Items CHAR 8 0 ADD_GROUP_KK
XINVBILL_X Billing Document Contains Links to Reference Objects CHAR 1 0 XINVBILL_X_KK
RECNUM Total Number of Items of a Billing Document INT4 10 0 BILLDOC_RECNUM_KK
KEYPP Subarea for Parallelization in Mass Processing NUMC 3 0 KEYPP_KK
CRNAME Created By CHAR 12 0 CRNAM
CRDATE Date on Which Billing Document Was Created DATS 8 0 BILLCRDATE_KK
CRTIME Time at Which Billing Document Was Created TIMS 6 0 BILLCRTIM_KK
BILLRUNNO Internal Number of Billing Run CHAR 12 0 BILLRUNNO_KK
BILL_PROCESS Billing Process CHAR 4 0 TFK8110 BILL_PROCESS_KK
BILL_TYPE Billing Type CHAR 4 0 TFK8112 BILL_TYPE_KK
PREPAID_INCL Document Contains Prepaid Items CHAR 1 0 PREPAID_INCL_KK
PPREFILL_INCL Document Contains Items for Prepaid Refill CHAR 1 0 PPREFILL_INCL_KK
REVREC_INCL Document Contains Posting Data from Revenue Deferral CHAR 1 0 REVREC_INCL_KK
ALTMD_ORIG_INCL Document Contains Alternative Original Master Data CHAR 1 0 ALTMD_ORIG_INCL_KK
PTSRL Partner Settlement Rule CHAR 4 0 * PTSRL_KK
DUMMY_INVBILL_H_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY

DFKKINVBILL_H foreign key relationships

Table Field Check Table Check Field
0 DFKKINVBILL_H BILL_PROCESS TFK8110 Billing Processes MANDT
1 DFKKINVBILL_H DOCTYPE TFK2600 Document Number Assignment: Document Type NROBJ
1 DFKKINVBILL_H DOCTYPE TFK2600 Document Number Assignment: Document Type DOCTYPE
0 DFKKINVBILL_H GPART BUT000 BP: General data I PARTNER
1 DFKKINVBILL_H INV_CATEGORY TFK2604 Invoicing Categories MANDT
1 DFKKINVBILL_H INV_CATEGORY TFK2604 Invoicing Categories INV_CATEGORY
0 DFKKINVBILL_H INV_CURR TCURC Currency Codes MANDT
0 DFKKINVBILL_H INV_CURR TCURC Currency Codes WAERS
1 DFKKINVBILL_H LOG_SYSTEM TBDLS Logical system LOGSYS
0 DFKKINVBILL_H SRCPROCESS TFK2641 Origin Process of Billing Document SRCPROCESS
1 DFKKINVBILL_H VKONT FKKVK Contract Account Header VKONT