SAP table DFKKINVDOC_I (Items of Invoicing Document)

SAP table DFKKINVDOC_I has 3 primary key fields being MANDT,INVDOCNO,INVDOCITEM.

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
INVDOCNO Number of Invoicing Document NUMC 12 0 INVDOCNO_KK
INVDOCITEM Sequential Number of Document Item NUMC 8 0 INVDOCITEM_KK
ITEMTYPE Type of Invoicing Item CHAR 8 0 TFK2608 INV_ITEMTYPE_KK
BUKRS Company Code CHAR 4 0 T001 BUKRS
SPART Division CHAR 2 0 TSPA SPART_KK
VTREF Reference Specifications from Contract CHAR 20 0 VTREF_KK
VTPOS Contract: Item Number NUMC 6 0 VTPOS_KK
SUBAP Subapplication in Contract Accounts Receivable and Payable CHAR 1 0 SUBAP_KK
No Contract Reference/Primary Contract
9 Real Estate
GPART_A Alternative Business Partner of Invoicing Item CHAR 10 0 * INV_GPART_A_KK
VKONT_A Alternative Contract Account of Invoicing item CHAR 12 0 * INV_VKONT_A_KK
GPVKT_A_CAT Category of Alternative Master Data for Invoicing Item CHAR 2 0 INV_GPVKT_A_CAT_KK
01 Partner/Account of Single Document of a Collective Bill
02 Partner/Account of Single Document of an Invoicing List
03 Partner/Account of Transferred Posting Document
04 Partner/Account of Posting Item
05 Alternative Partner/Account of Invoicing Item
06 Orig. Partner/Account of Source Document for Altern.Posting
07 Alternative Partner/Account of Source Document for Posting
08 Alternative Partner/Account of Source Document Item
HVORG Main Transaction for Line Item CHAR 4 0 TFKHVO HVORG_KK
TVORG Subtransaction for Document Item CHAR 4 0 TFKTVO TVORG_KK
ITEM_SIMULATED Line Item Is Simulated CHAR 1 0 ITEM_SIMULATED_KK
REVERSALITEM Reversal Item CHAR 1 0 REVERSALITEM_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
TOTALREL Consider Items In Invoice Final Amount CHAR 1 0 TOTALREL_KK
POSTREL Posting-Relevant Line Item CHAR 1 0 POSTREL_KK
NOT_BPREL Not Relevant for Business Partner Items CHAR 1 0 NOT_BPREL_KK
PRINTREL Line Item Is Relevant for Printing CHAR 1 0 PRINTREL_KK
PRINT_SUBSTITUTE Substitute Group for Invoice Printing CHAR 4 0 PRINT_SUBSTITUTE_KK
WAERS Transaction Currency CUKY 5 0 TCURC BLWAE_KK
BETRW Amount in Transaction Currency with +/- Sign CURR 13 2 BETRW_KK
SRCDOC_CURR Currency of Source Document CUKY 5 0 * SRCDOC_CURR_KK
SRCDOC_AMT Amount in Source Document Currency CURR 13 2 SRCDOC_AMT_KK
CURRC_GROUP Grouping for Currency Translation NUMC 6 0 CURRC_GROUP_KK
KOFIZ Account Determination ID CHAR 2 0 KOFIZ_KK
BUPLA Business Place CHAR 4 0 * BUPLA
GSBER Business Area CHAR 4 0 TGSB GSBER
TAX_INCLUDED Tax Included in Amount CHAR 1 0 TAX_INCLUDED_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
TAXGR Grouping Key for Tax Display NUMC 6 0 TAXGR_KK
STRKZ Tax Code for Other Taxes CHAR 2 0 TFK007F STRKZ_KK
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
ERMWSKZ Indicator: Tax Determination Code CHAR 2 0 TE011 ERMWSKZ
TXJCD Tax Jurisdiction CHAR 15 0 * TXJCD
KTOSL Transaction key for account determination CHAR 3 0 KTOSL_KK
BUV Company Code Clearing (Old)
BVR Company Code Clearing (Posting Area 0030)
GEB Revenue from Charges (Posting Area 0050)
KDF Exchange Rate Difference (Posting Area 0070)
MWS Output Tax
NAV Nondeductible Input Tax
NVV Nondeductible Input Tax Distributed
QSE Withholding Tax at Posting
QSO Offset to Withholding Tax Self-Withholding
QSS Withholding Tax Self-Withholding (Posting Area 0212)
QST Withholding Tax (Posting Area 0201)
QSZ Withholding Tax for Interest
RDW Rounding Difference (Posting Area 0040)
SKT Discount (Posting Area 0060)
SVA Tax Offset for Down Payments
TAX Special Tax (Posting Area 0015)
UCT U.S. Communication Tax (Posting Area 0017)
VST Input Tax
VZZ Interest at Clearing
ZZS Payment Surcharge (Posting Area 0060)
KSCHL Condition Type CHAR 4 0 * KSCHL
TAX_PERC Tax Percentage DEC 6 3 TAX_PERC_KK
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
TXDAT Decisive Date for Calculating Taxes DATS 8 0 TXDAT_KK
SBASW Amount Subject to Tax in Transaction Currency (Tax Base Amt) CURR 13 2 SBASW_KK
SBETW Tax Amount in Transaction Currency with +/- Sign CURR 13 2 SBETRW_KK
STTAX Tax Amount as Statistical Information in Document Currency CURR 13 2 STTAX_KK
QSSKZ Withholding Tax Code CHAR 2 0 * QSSKZ
XANZA Item is a Down Payment/Down Payment Request CHAR 1 0 XANZA_KK
STAKZ Type of statistical item CHAR 1 0 STAKZ_KK
A Down Payment Request
B Quotation
G Other statistical receivable (charges,interest)
H Cash Security Deposit Request
I Down Payment Request from Invoicing
J Payment Request from Invoicing
K Correspondence Request
M Collaborative Liability
P Budget Billing Plan Item
Q Expected withholding tax deduction
R Installment Plan Item
S Collective Bill Item
T Statisitcal receivable for other taxes
Z Payment Request
OFFSET_CAT Offsetting Category CHAR 3 0 * INV_OFFSET_CAT_KK
OFFSET_PROC Offsetting Procedure CHAR 2 0 INV_OFFSET_PROC_KK
01 Offset Payments on Request of Down Payment
02 Offset Prepayments
03 Offset Other Credit
04 Offset Partial Bills
05 Offset of Agreed Invoice Amounts
OFFSET_ACTION Action Code for Offsetting CHAR 1 0 INV_OFFSET_ACTION_KK
No Offsetting
1 Select Item for Offsetting
2 Offset Item
3 Clear with Offsetting
OFFSET_INVGR Grouping of Offsetting Items CHAR 6 0 INV_OFFSET_GROUP_KK
DEFREV_STAT Status of Processing of Deferred Revenues CHAR 1 0 DEFREV_STAT_KK
1 Event-Based Deferred Revenues Posted
2 Event-Based Deferred Revenues Activated
3 No Posting of Deferred Revenues According to System Setting
4 No Posting/Activation of Deferred Rev. Since Amount Is Zero
5 Event-Based Deferred Revenues (Partially) Reversed
6 Event-Based Deferred Revenues Activated in Billing
RAREL Relevant for Revenue Accounting CHAR 1 0 RAREL_KK
Not Relevant for Revenue Accounting
X Relevant for Revenue Accounting
RA_INVGR Revenue Grouping of Invoicing CHAR 6 0 RAI_INVGR_KK
SERVICE_TYPE Service Type for Revenue Accounting CHAR 6 0 * RAI_SERVICE_TYPE_KK
BILLAC_TYPE Type of Accrual/Deferral Posting - Individual Procedure CHAR 4 0 * BILLAC_TYPE_KK
PREPAID Prepaid CHAR 1 0 PREPAID_KK
MEINS Base Unit of Measure UNIT 3 0 * MEINS
MENGE Quantity QUAN 13 3 MENGE_D
FAEDN Due date for net payment DATS 8 0 FAEDN_KK
FAEDS Due Date for Cash Discount DATS 8 0 FAEDS_KK
SKTPZ Cash Discount Percentage Rate DEC 5 3 SKTPZ_KK
XSTUND Item Deferred until Due Date for Invoice CHAR 1 0 INV_XSTUND_KK
1 Due Date Adjusted
X Deferral Date Adjusted
DATE_FROM Start of Period of Line Item DATS 8 0 ITEMPERIOD_FROM_KK
DATE_TO End of Period of Line Item DATS 8 0 ITEMPERIOD_TO_KK
CADOCTYPE Reference Document Type of Posting Document for Invoicing CHAR 4 0 TFK2605 CADOCTYPE_KK
OPBEL Number of a FI-CA Document CHAR 12 0 * OPBEL_KK
PSGRP Grouping Key for Document Items CHAR 4 0 PSGRP_KK
INVGR Grouping Key for Invoicing CHAR 4 0 INVGR_KK
AUGBL Clearing Document or Printed Document CHAR 12 0 AUGBL_KK
AUGBW Clearing Amount in Transaction Currency (With +/- Sign) CURR 13 2 AUGBW_KK
ITEM_CRMET Creation Method of Invoicing Document Item CHAR 1 0 INVITEM_CRMET_KK
Standard
1 External, No Standard Account Assignment Derivation
2 External with External and Standard Account Assignment Drvtn
3 External with Standard Account Assignment Derivation
4 Posting Suppressed Externally
5 External
6 Internal for Externally Created Posting Item
INV_FUNCTION Invoicing Function CHAR 12 0 TFK2601 INV_FUNCTION_KK
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
SRCITEMCAT Category of Source Document Item Invoiced CHAR 5 0 SRCITEMCAT_KK
BILLI Line Item FKKINVBILL_I
BILLP Payment Data Item FKKINVBILL_PY
BILLT Tax Item FKKINVBILL_T
CHLDI Individual Items for Collective Bill (OPBEL+OPUPW+OPUPK)
VBRP SD Invoice Item
SRCDOCITEM Item of Invoiced Source Document CHAR 20 0 SRCDOCITEM_KK
DISCKEY Discount/Charge Key CHAR 8 0 TFK8117 DISCKEY_KK
DISCKEY_VERSNO Version Number of Disccount on Billable Items NUMC 2 0 DISCKEY_VERSNO_KK
DUMMY_INVDOC_I_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY

DFKKINVDOC_I foreign key relationships

Table Field Check Table Check Field
0 DFKKINVDOC_I BUKRS T001 Company Codes BUKRS
1 DFKKINVDOC_I ERMWSKZ TE011 Code for Tax Code Determination MANDT
1 DFKKINVDOC_I ERMWSKZ TE011 Code for Tax Code Determination LAND1
1 DFKKINVDOC_I ERMWSKZ TE011 Code for Tax Code Determination ERMWSKZ
0 DFKKINVDOC_I GSBER TGSB Business Areas MANDT
0 DFKKINVDOC_I GSBER TGSB Business Areas GSBER
1 DFKKINVDOC_I HVORG TFKHVO Main transactions in contract accts receivable and payable MANDT
1 DFKKINVDOC_I HVORG TFKHVO Main transactions in contract accts receivable and payable HVORG
0 DFKKINVDOC_I INV_FUNCTION TFK2601 Invoicing Functions INV_FUNCTION
1 DFKKINVDOC_I ITEMTYPE TFK2608 Invoicing Item Types MANDT
0 DFKKINVDOC_I MWSKZ T007A Tax Keys KALSM
0 DFKKINVDOC_I MWSKZ T007A Tax Keys MWSKZ
1 DFKKINVDOC_I SPART TSPA Organizational Unit: Sales Divisions MANDT
1 DFKKINVDOC_I SPART TSPA Organizational Unit: Sales Divisions SPART
0 DFKKINVDOC_I SRCDOCCAT TFK2605C Source Document Categories SRCDOCCAT
1 DFKKINVDOC_I STRKZ TFK007F Other Tax Codes LAND
0 DFKKINVDOC_I TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable HVORG
0 DFKKINVDOC_I TVORG TFKTVO Subtransactions in Contract Accounts Receivable and Payable TVORG
1 DFKKINVDOC_I WAERS TCURC Currency Codes MANDT
1 DFKKINVDOC_I WAERS TCURC Currency Codes WAERS