DFKKINVDOC_I SAP (Items of Invoicing Document) Table details
Dictionary Type: Table
Description: Items of Invoicing Document
Description: Items of Invoicing Document
Table field list including key, data, relationships and ABAP select examples
DFKKINVDOC_I is a standard SAP Table which is used to store Items of Invoicing Document data and is available within R/3 SAP systems depending on the version and release level.
The DFKKINVDOC_I table consists of various fields, each holding specific information or linking keys about Items of Invoicing Document data available in SAP. These include INVDOCNO (Number of Invoicing Document), INVDOCITEM (Sequential Number of Document Item), ITEMTYPE (Type of Invoicing Item), BUKRS (Company Code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP DFKKINVDOC_I table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
INVDOCNO | Number of Invoicing Document | INVDOCNO_KK | NUMC | 12 | Assigned to domain | INVDOCNO_KK | FKKINV_INVDOCNO | ||
INVDOCITEM | Sequential Number of Document Item | INVDOCITEM_KK | NUMC | 8 | INVDOCITEM_KK | ||||
ITEMTYPE | Type of Invoicing Item | INV_ITEMTYPE_KK | CHAR | 8 | TFK2608 | INV_ITEMTYPE_KK | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
SPART | Division | SPART_KK | CHAR | 2 | TSPA | SPART | SPA | ||
VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
VTPOS | Contract: Item Number | VTPOS_KK | NUMC | 6 | VTPOS_KK | ||||
SUBAP | Subapplication in Contract Accounts Receivable and Payable | SUBAP_KK | CHAR | 1 | SUBAP_KK | 8SA | |||
GPART_A | Alternative Business Partner of Invoicing Item | INV_GPART_A_KK | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
VKONT_A | Alternative Contract Account of Invoicing item | INV_VKONT_A_KK | CHAR | 12 | Assigned to domain | ALPHA | VKONT_KK | ||
GPVKT_A_CAT | Category of Alternative Master Data for Invoicing Item | INV_GPVKT_A_CAT_KK | CHAR | 2 | INV_GPVKT_A_CAT_KK | ||||
HVORG | Main Transaction for Line Item | HVORG_KK | CHAR | 4 | TFKHVO | HVORG_KK | 8HV | ||
TVORG | Subtransaction for Document Item | TVORG_KK | CHAR | 4 | TFKTVO | TVORG_KK | |||
ITEM_SIMULATED | Line Item Is Simulated | ITEM_SIMULATED_KK | CHAR | 1 | XFELD | ||||
REVERSALITEM | Reversal Item | REVERSALITEM_KK | CHAR | 1 | XFELD | ||||
TOTALREL | Consider Items In Invoice Final Amount | TOTALREL_KK | CHAR | 1 | XFELD | ||||
POSTREL | Posting-Relevant Line Item | POSTREL_KK | CHAR | 1 | XFELD | ||||
NOT_BPREL | Not Relevant for Business Partner Items | NOT_BPREL_KK | CHAR | 1 | XFELD | ||||
PRINTREL | Line Item Is Relevant for Printing | PRINTREL_KK | CHAR | 1 | XFELD | ||||
PRINT_SUBSTITUTE | Substitute Group for Invoice Printing | PRINT_SUBSTITUTE_KK | CHAR | 4 | |||||
WAERS | Transaction Currency | BLWAE_KK | CUKY | 5 | TCURC | WAERS | FWS | ||
BETRW | Amount in Transaction Currency with +/- Sign | BETRW_KK | CURR | 13(2) | WRTV7 | ||||
SRCDOC_CURR | Currency of Source Document | SRCDOC_CURR_KK | CUKY | 5 | Assigned to domain | WAERS | |||
SRCDOC_AMT | Amount in Source Document Currency | SRCDOC_AMT_KK | CURR | 13(2) | WRTV7 | ||||
CURRC_GROUP | Grouping for Currency Translation | CURRC_GROUP_KK | NUMC | 6 | |||||
KOFIZ | Account Determination ID | KOFIZ_KK | CHAR | 2 | KOFIZ_KK | ||||
TAX_INCLUDED | Tax Included in Amount | TAX_INCLUDED_KK | CHAR | 1 | XFELD | ||||
TAX_DET_TYPE | Type of Tax Calculation | TAX_DET_TYPE_KK | CHAR | 2 | TAX_DET_TYPE_KK | ||||
TAXGR | Grouping Key for Tax Display | TAXGR_KK | NUMC | 6 | |||||
STRKZ | Tax Code for Other Taxes | STRKZ_KK | CHAR | 2 | TFK007F | STRKZ_KK | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
ERMWSKZ | Indicator: Tax Determination Code | ERMWSKZ | CHAR | 2 | TE011 | ERMWSKZ | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
KTOSL | Transaction key for account determination | KTOSL_KK | CHAR | 3 | CHAR3 | ||||
KSCHL | Condition Type | KSCHL | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
TAX_PERC | Tax Percentage | TAX_PERC_KK | DEC | 6(3) | TAX_PERC_KK | ||||
TXDAT | Decisive Date for Calculating Taxes | TXDAT_KK | DATS | 8 | DATUM | ||||
SBASW | Amount Subject to Tax in Transaction Currency (Tax Base Amt) | SBASW_KK | CURR | 13(2) | WRTV7 | ||||
SBETW | Tax Amount in Transaction Currency with +/- Sign | SBETRW_KK | CURR | 13(2) | WRTV7 | ||||
STTAX | Tax Amount as Statistical Information in Document Currency | STTAX_KK | CURR | 13(2) | WRTV7 | ||||
XANZA | Item is a Down Payment/Down Payment Request | XANZA_KK | CHAR | 1 | XFELD | ||||
STAKZ | Type of statistical item | STAKZ_KK | CHAR | 1 | STAKZ_KK | ||||
OFFSET_INVGR | Grouping of Offsetting Items | INV_OFFSET_GROUP_KK | CHAR | 6 | |||||
DEFREV_STAT | Status of Processing of Deferred Revenues | DEFREV_STAT_KK | CHAR | 1 | DEFREV_STAT_KK | ||||
PREPAID | Prepaid | PREPAID_KK | CHAR | 1 | XFELD | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
FAEDN | Due date for net payment | FAEDN_KK | DATS | 8 | DATUM | ||||
FAEDS | Due Date for Cash Discount | FAEDS_KK | DATS | 8 | DATUM | ||||
SKTPZ | Cash discount rate | SKTPZ_KK | DEC | 5(3) | PRZ23 | ||||
XSTUND | Item Deferred until Due Date for Invoice | INV_XSTUND_KK | CHAR | 1 | INV_XSTUND_KK | ||||
DATE_FROM | Start of Period of Line Item | ITEMPERIOD_FROM_KK | DATS | 8 | |||||
DATE_TO | End of Period of Line Item | ITEMPERIOD_TO_KK | DATS | 8 | |||||
CADOCTYPE | Reference Document Type of Posting Document for Invoicing | CADOCTYPE_KK | CHAR | 4 | TFK2605 | CADOCTYPE_KK | |||
OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | Assigned to domain | ALPHA | OPBEL_KK | 80B | |
PSGRP | Grouping Key for Document Items | PSGRP_KK | CHAR | 4 | CHAR4 | ||||
INVGR | Grouping Key for Invoicing | INVGR_KK | CHAR | 4 | CHAR4 | ||||
AUGBL | Clearing Document or Printed Document | AUGBL_KK | CHAR | 12 | ALPHA | AUGBL_KK | |||
AUGBW | Clearing Amount in Transaction Currency (With +/- Sign) | AUGBW_KK | CURR | 13(2) | WRTV7 | ||||
ITEM_CRMET | Creation Method of Invoicing Document Item | INVITEM_CRMET_KK | CHAR | 1 | INVITEM_CRMET_KK | ||||
INV_FUNCTION | Invoicing Function | INV_FUNCTION_KK | CHAR | 12 | TFK2601 | INV_FUNCTION_KK | |||
SRCDOCCAT | Category of Source Document To Be Invoiced | SRCDOCCAT_KK | CHAR | 5 | SRCDOCCAT_KK | ||||
SRCDOCNO | Number of Source Document to Be Invoiced | SRCDOCNO_KK | CHAR | 20 | ALPHA | SRCDOCNO_KK | FKKINV_SRCDOCNO | ||
SRCITEMCAT | Category of Source Document Item Invoiced | SRCITEMCAT_KK | CHAR | 5 | SRCITEMCAT_KK | ||||
SRCDOCITEM | Item of Invoiced Source Document | SRCDOCITEM_KK | CHAR | 20 | ALPHA | SRCDOCITEM_KK |
Key field | Non-key field |
How do I retrieve data from SAP table DFKKINVDOC_I using ABAP code
The following ABAP code Example will allow you to do a basic selection on DFKKINVDOC_I to SELECT all data from the tableDATA: WA_DFKKINVDOC_I TYPE DFKKINVDOC_I.
SELECT SINGLE *
FROM DFKKINVDOC_I
INTO CORRESPONDING FIELDS OF WA_DFKKINVDOC_I
WHERE...
How to access SAP table DFKKINVDOC_I
Within an ECC or HANA version of SAP you can also view further information about DFKKINVDOC_I and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects