SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

Home | ERP 6.0  | DFKKINVDOC_I
JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Financial Accounting :: Contract Accounts Receivable and Payable :: Invoicing in Contract Accounts Receivable and Payable
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DFKKINVDOC_I691Items of Invoicing DocumentInvoicing in Contract Accounts Receivable and Payable
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, INVDOCNO, INVDOCITEM, ITEMTYPE, BUKRS, SPART, VTREF, VTPOS, SUBAP, GPART_A, VKONT_A, GPVKT_A_CAT, HVORG, TVORG, ITEM_SIMULATED, REVERSALITEM, TOTALREL, POSTREL, NOT_BPREL, PRINTREL, PRINT_SUBSTITUTE, WAERS, BETRW, SRCDOC_CURR, SRCDOC_AMT, CURRC_GROUP, KOFIZ, BUPLA, GSBER, TAX_INCLUDED, TAX_DET_TYPE, TAXGR, STRKZ, MWSKZ, ERMWSKZ, TXJCD, KTOSL, KSCHL, TAX_PERC, TXDAT, SBASW, SBETW, STTAX, QSSKZ, XANZA, STAKZ, OFFSET_INVGR, DEFREV_STAT, PREPAID, MEINS, MENGE, FAEDN, FAEDS, SKTPZ, XSTUND, DATE_FROM, DATE_TO, CADOCTYPE, OPBEL, PSGRP, INVGR, AUGBL, AUGBW, ITEM_CRMET, INV_FUNCTION, SRCDOCCAT, SRCDOCNO, SRCITEMCAT, SRCDOCITEM FROM DFKKINVDOC_I
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2INVDOCNONumber of Invoicing Documentnvarchar120NUMC(N'000000000000')No*INVDOCNO_KK Allow NULL? 
3INVDOCITEMSequential Number of Document Itemnvarchar80NUMC(N'00000000')NoINVDOCITEM_KK Allow NULL? 
4ITEMTYPEType of Invoicing Itemnvarchar80CHAR(N' ')YesTFK2608INV_ITEMTYPE_KK Allow NULL? 
5BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
6SPARTDivisionnvarchar20CHAR(N' ')YesTSPASPART_KK Allow NULL? 
7VTREFReference Specifications from Contractnvarchar200CHAR(N' ')YesVTREF_KK Allow NULL? 
8VTPOSContract: Item Numbernvarchar60NUMC(N'000000')YesVTPOS_KK Allow NULL? 
9SUBAPSubapplication in Contract Accounts Receivable and Payablechar10CHAR(N' ')YesSUBAP_KK Allow NULL? 
10GPART_AAlternative Business Partner of Invoicing Itemnvarchar100CHAR(N' ')Yes*INV_GPART_A_KK Allow NULL? 
11VKONT_AAlternative Contract Account of Invoicing itemnvarchar120CHAR(N' ')Yes*INV_VKONT_A_KK Allow NULL? 
12GPVKT_A_CATCategory of Alternative Master Data for Invoicing Itemnvarchar20CHAR(N' ')YesINV_GPVKT_A_CAT_KK Allow NULL? 
13HVORGMain Transaction for Line Itemnvarchar40CHAR(N' ')YesTFKHVOHVORG_KK Allow NULL? 
14TVORGSubtransaction for Document Itemnvarchar40CHAR(N' ')YesTFKTVOTVORG_KK Allow NULL? 
15ITEM_SIMULATEDLine Item Is Simulatedchar10CHAR(N' ')YesITEM_SIMULATED_KK Allow NULL? 
16REVERSALITEMReversal Itemchar10CHAR(N' ')YesREVERSALITEM_KK Allow NULL? 
17TOTALRELConsider Items In Invoice Final Amountchar10CHAR(N' ')YesTOTALREL_KK Allow NULL? 
18POSTRELPosting-Relevant Line Itemchar10CHAR(N' ')YesPOSTREL_KK Allow NULL? 
19NOT_BPRELNot Relevant for Business Partner Itemschar10CHAR(N' ')YesNOT_BPREL_KK Allow NULL? 
20PRINTRELLine Item Is Relevant for Printingchar10CHAR(N' ')YesPRINTREL_KK Allow NULL? 
21PRINT_SUBSTITUTESubstitute Group for Invoice Printingnvarchar40CHAR(N' ')YesPRINT_SUBSTITUTE_KK Allow NULL? 
22WAERSTransaction Currencynvarchar50CUKY(N' ')YesTCURCBLWAE_KK Allow NULL? 
23BETRWAmount in Transaction Currency with +/- Signdecimal132CURR((0))YesBETRW_KK
24SRCDOC_CURRCurrency of Source Documentnvarchar50CUKY(N' ')Yes*SRCDOC_CURR_KK Allow NULL? 
25SRCDOC_AMTAmount in Source Document Currencydecimal132CURR((0))YesSRCDOC_AMT_KK
26CURRC_GROUPGrouping for Currency Translationnvarchar60NUMC(N'000000')YesCURRC_GROUP_KK Allow NULL? 
27KOFIZAccount Determination IDnvarchar20CHAR(N' ')YesKOFIZ_KK Allow NULL? 
28BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
29GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
30TAX_INCLUDEDTax Included in Amountchar10CHAR(N' ')YesTAX_INCLUDED_KK Allow NULL? 
31TAX_DET_TYPEType of Tax Calculationnvarchar20CHAR(N' ')YesTAX_DET_TYPE_KK Allow NULL? 
32TAXGRGrouping Key for Tax Displaynvarchar60NUMC(N'000000')YesTAXGR_KK Allow NULL? 
33STRKZTax Code for Other Taxesnvarchar20CHAR(N' ')YesTFK007FSTRKZ_KK Allow NULL? 
34MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')YesT007AMWSKZ Allow NULL? 
35ERMWSKZIndicator: Tax Determination Codenvarchar20CHAR(N' ')YesTE011ERMWSKZ Allow NULL? 
36TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
37KTOSLTransaction key for account determinationnvarchar30CHAR(N' ')YesKTOSL_KK Allow NULL? 
38KSCHLCondition Typenvarchar40CHAR(N' ')Yes*KSCHL Allow NULL? 
39TAX_PERCTax Percentagedecimal63DEC((0))YesTAX_PERC_KK
40TXDATDecisive Date for Calculating Taxesnvarchar80DATS(N'00000000')YesTXDAT_KK Allow NULL? 
41SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132CURR((0))YesSBASW_KK
42SBETWTax Amount in Transaction Currency with +/- Signdecimal132CURR((0))YesSBETRW_KK
43STTAXTax Amount as Statistical Information in Document Currencydecimal132CURR((0))YesSTTAX_KK
44QSSKZWithholding Tax Codenvarchar20CHAR(N' ')Yes*QSSKZ Allow NULL? 
45XANZAItem is a Down Payment/Down Payment Requestchar10CHAR(N' ')YesXANZA_KK Allow NULL? 
46STAKZType of statistical itemchar10CHAR(N' ')YesSTAKZ_KK Allow NULL? 
47OFFSET_INVGRGrouping of Offsetting Itemsnvarchar60CHAR(N' ')YesINV_OFFSET_GROUP_KK Allow NULL? 
48DEFREV_STATStatus of Processing of Deferred Revenueschar10CHAR(N' ')YesDEFREV_STAT_KK Allow NULL? 
49PREPAIDPrepaidchar10CHAR(N' ')YesPREPAID_KK Allow NULL? 
50MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
51MENGEQuantitydecimal133QUAN((0))YesMENGE_D
52FAEDNDue date for net paymentnvarchar80DATS(N'00000000')YesFAEDN_KK Allow NULL? 
53FAEDSDue Date for Cash Discountnvarchar80DATS(N'00000000')YesFAEDS_KK Allow NULL? 
54SKTPZCash discount ratedecimal53DEC((0))YesSKTPZ_KK
55XSTUNDItem Deferred until Due Date for Invoicechar10CHAR(N' ')YesINV_XSTUND_KK Allow NULL? 
56DATE_FROMStart of Period of Line Itemnvarchar80DATS(N'00000000')YesITEMPERIOD_FROM_KK Allow NULL? 
57DATE_TOEnd of Period of Line Itemnvarchar80DATS(N'00000000')YesITEMPERIOD_TO_KK Allow NULL? 
58CADOCTYPEReference Document Type of Posting Document for Invoicingnvarchar40CHAR(N' ')YesTFK2605CADOCTYPE_KK Allow NULL? 
59OPBELNumber of Contract Accts Rec. & Payable Doc.nvarchar120CHAR(N' ')Yes*OPBEL_KK Allow NULL? 
60PSGRPGrouping Key for Document Itemsnvarchar40CHAR(N' ')YesPSGRP_KK Allow NULL? 
61INVGRGrouping Key for Invoicingnvarchar40CHAR(N' ')YesINVGR_KK Allow NULL? 
62AUGBLClearing Document or Printed Documentnvarchar120CHAR(N' ')YesAUGBL_KK Allow NULL? 
63AUGBWClearing Amount in Transaction Currency (With +/- Sign)decimal132CURR((0))YesAUGBW_KK
64ITEM_CRMETCreation Method of Invoicing Document Itemchar10CHAR(N' ')YesINVITEM_CRMET_KK Allow NULL? 
65INV_FUNCTIONInvoicing Functionnvarchar120CHAR(N' ')YesTFK2601INV_FUNCTION_KK Allow NULL? 
66SRCDOCCATCategory of Source Document To Be Invoicednvarchar50CHAR(N' ')YesTFK2605CSRCDOCCAT_KK Allow NULL? 
67SRCDOCNONumber of Source Document to Be Invoicednvarchar200CHAR(N' ')YesSRCDOCNO_KK Allow NULL? 
68SRCITEMCATCategory of Source Document Item Invoicednvarchar50CHAR(N' ')YesSRCITEMCAT_KK Allow NULL? 
69SRCDOCITEMItem of Invoiced Source Documentnvarchar200CHAR(N' ')YesSRCDOCITEM_KK Allow NULL? 
NamePrimaryUniqueTypeColumns
DFKKINVDOC_I~0YesYesCLUSTEREDINVDOCITEM, INVDOCNO, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy