SAP Table DFKKINVBILL_H

Billing Document Header

DFKKINVBILL_H (Billing Document Header) 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 DFKKINVBILL_H to other SAP tables.

DFKKINVBILL_H table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BILLDOCNO Number of Billing Document BILLDOCNO_KK NUMC 12 0
REFDOCNO Document Number in External System REFDOCNO_KK CHAR 22 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
SRCDOCTYPE Source Document Type of Billing Document SRCDOCTYPE_INVBI_KK CHAR 3 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
DOCTYPE Document Type DOCTYPE_KK TFK2600 CHAR 2 0
GPART Business Partner Number for Billing and Invoicing GPART_CI_KK BUT000 CHAR 10 0
VKONT Contract Account Number for Billing and Invoicing VKONT_CI_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_INV Alternative Business Partner for Invoicing GPART_INV_KK CHAR 10 0
VKONT_INV Alternative Contract Account for Invoicing VKONT_INV_KK CHAR 12 0
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
BILL_BASEDATE Baseline Date for Period Assignment in Billing BILL_BASEDATE_KK DATS 8 0
SIMULATED Billing Document Is Simulated SIMULATED_KK CHAR 1 0
X Yes
NULL No
BILL_CURR Currency of Billing Document BILL_CURR_KK CUKY 5 0
INV_CURR Target Currency of Invoicing INV_CURR_KK TCURC CUKY 5 0
TAX_DET_TYPE Type of Tax Calculation TAX_DET_TYPE_KK CHAR 2 0
00 No Tax Calculation
01 Internal Tax Calculation
02 External Tax Calculation (Other Taxes)
03 External Tax Calculation with Internal Handling
04 Telecommunications Tax (USA) w/ Ext. Tax System Integration
TAX_DATE_TYPE Type of Tax Date TAX_DATE_TYPE_KK CHAR 2 0
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 INV_CATEGORY_KK TFK2604 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_FIRST Target Date for Invoicing INVOICE_FIRST_KK DATS 8 0
REVREASON Reversal Reason for Billing Document BILL_REVREASON_KK CHAR 2 0
REVERSALDOC Number of Reversal Document for Billing Document REVERSALBILLDOC_KK NUMC 12 0
REVERSEDDOC Number of Reversed Billing Document REVERSEDBILLDOC_KK NUMC 12 0
ADJUSTMENTDOC Number of Adjustment Billing Document ADJUSTMENTBILLDOC_KK NUMC 12 0
ADJUSTEDDOC Number of Adjusted Billing Document ADJUSTEDBILLDOC_KK NUMC 12 0
TRIGDELETED Invoicing Order Deleted TRIGDELETED_KK CHAR 1 0
X Yes
NULL No
XINFBILL Additional Statement in Another Invoice for Information Only XINFBILL_KK CHAR 1 0
X Yes
NULL No
INVLOCK Billing Document Is Locked for Invoicing INVLOCK_KK CHAR 1 0
NULL No Invoicing Lock
0 Billing Document Reversed Before Invoicing
1 General Invoicing Lock
2 Technical Document, Not Relevant for Invoicing
ADD_GROUP Grouping of Additional Items ADD_GROUP_KK CHAR 8 0
XINVBILL_X Billing Document Contains Links to Reference Objects XINVBILL_X_KK CHAR 1 0
X Yes
NULL No
RECNUM Total Number of Items of a Billing Document BILLDOC_RECNUM_KK INT4 10 0
CRNAME Created By CRNAM CHAR 12 0
CRDATE Date on Which Billing Document Was Created BILLCRDATE_KK DATS 8 0
CRTIME Time at Which Billing Document Was Created BILLCRTIM_KK TIMS 6 0
TARGPROCESS Target Process That Invoices the Billing Document TARGPROCESS_KK TFK2642 CHAR 4 0
BILLTYPE Billing Type BILLTYPE_KK NUMC 3 0
BILLCYCLE Billing Cycle BILLCYCLE_KK CHAR 10 0
BILLGROUP Billing Group BILLGROUP_KK NUMC 4 0
BILLTO Time of Billing BILLTASKBILLTO_KK DEC 15 0
TASKTYPE Billing Order Type TASKTYPE_KK CHAR 2 0
01 Periodic
02 Non-Periodic
03 As Needed
HOTBILLING Express Billing HOTBILLING_KK CHAR 1 0
X Yes
NULL No
BILLPROCEDURE Billing Procedure BILLPROCEDURE_KK CHAR 10 0
BILL_PROCESS Billing Process BILL_PROCESS_KK TFK8110 CHAR 4 0
BILL_TYPE Billing Type BILL_TYPE_KK TFK8112 CHAR 4 0
PREPAID_INCL Document Contains Prepaid Items PREPAID_INCL_KK CHAR 1 0
X Yes
NULL No
PPREFILL_INCL Document Contains Items for Prepaid Refill PPREFILL_INCL_KK CHAR 1 0
X Yes
NULL No
PTSRL Partner Settlement Rule PTSRL_KK CHAR 4 0

DFKKINVBILL_H foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DFKKINVBILL_H BILL_PROCESS SYST MANDT TFK8110 Billing Processes MANDT
DFKKINVBILL_H BILL_PROCESS DFKKINVBILL_H BILL_PROCESS TFK8110 Billing Processes BILL_PROCESS
DFKKINVBILL_H BILL_TYPE SYST MANDT TFK8112 Billing Types MANDT
DFKKINVBILL_H BILL_TYPE DFKKINVBILL_H BILL_TYPE TFK8112 Billing Types BILL_TYPE
DFKKINVBILL_H DOCTYPE DFKKINVBILL_H DOCTYPE TFK2600 Document Number Assignment: Document Type DOCTYPE
DFKKINVBILL_H DOCTYPE SYST MANDT TFK2600 Document Number Assignment: Document Type MANDT
DFKKINVBILL_H DOCTYPE 'FKKINVBILL' TFK2600 Document Number Assignment: Document Type NROBJ
DFKKINVBILL_H DOCTYPE DFKKINVBILL_H APPLK TFK2600 Document Number Assignment: Document Type APPLK
DFKKINVBILL_H GPART SYST MANDT BUT000 BP: General data I CLIENT
DFKKINVBILL_H GPART DFKKINVBILL_H GPART BUT000 BP: General data I PARTNER
DFKKINVBILL_H INV_CATEGORY SYST MANDT TFK2604 Invoicing Categories MANDT
DFKKINVBILL_H INV_CATEGORY DFKKINVBILL_H INV_CATEGORY TFK2604 Invoicing Categories INV_CATEGORY
DFKKINVBILL_H INV_CURR SYST MANDT TCURC Currency Codes MANDT
DFKKINVBILL_H INV_CURR DFKKINVBILL_H INV_CURR TCURC Currency Codes WAERS
DFKKINVBILL_H LOG_SYSTEM DFKKINVBILL_H LOG_SYSTEM TBDLS Logical system LOGSYS
DFKKINVBILL_H SRCPROCESS DFKKINVBILL_H SRCPROCESS TFK2641 Origin Process of Billing Document SRCPROCESS
DFKKINVBILL_H TARGPROCESS DFKKINVBILL_H TARGPROCESS TFK2642 Target Process of Billing Document TARGPROCESS
DFKKINVBILL_H VKONT SYST MANDT FKKVK Contract Account Header MANDT
DFKKINVBILL_H VKONT DFKKINVBILL_H VKONT FKKVK Contract Account Header VKONT