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

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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

39 columns | Print definition?ERP 6.0  | INV_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/VT_ATM_SRCSource Table for the Aggregations of the ATM report17INV_TYPEInvoice Typenvarchar30
2/OPT/X005Approval COA Fields2INV_TYPEInvoice Typenvarchar10
3/OPT/X069Document Type Definition32INV_TYPEInvoice Typenvarchar30
4/OPT/Y005Approval COA Fields2INV_TYPEInvoice Typenvarchar10
5/OPT/Y069Document Type Definition32INV_TYPEInvoice Typenvarchar30
6/OPT/Z005Approval COA Fields2INV_TYPEInvoice Typenvarchar10
7/OPT/Z069Document Type Definition32INV_TYPEInvoice Typenvarchar30
8DFKKINVDOC_LOGLog of Invoicing Runs7INV_TYPEInvoicing Typenvarchar20
9DFKKINVDOC_REVReversal Request for Invoicing Document7INV_TYPEInvoicing Typenvarchar20
10FIEUD_SBINV_HSAFT: Self Billing Invoices (Header)- (MM)17INV_TYPESAFT: Invoice Typenvarchar20
11FIEUD_SDINV_HSAFT: Invoices from SD module(Header)15INV_TYPESAFT: Invoice Typenvarchar20
12FIKZD_DEADJRNLInvoice Journal Deadlines (Electronic Invoices)2INV_TYPEInvoice Typenvarchar10
13FIKZD_REGINV_INIncoming Invoice Registration Journal15INV_TYPELine Typenvarchar10
14FIKZD_REGINV_OUTOutgoing Invoice Registration Journal14INV_TYPELine Typenvarchar10
15J_3RFDI_DEADJRNLInvoice Journal Deadlines (Electronic Invoices)2INV_TYPEInvoice Typenvarchar10
16J_3RF_REGCUS_OUTCustomizing for Outgoing Invoice Registration Journal9INV_TYPERevision of Invoice or Corrective Invoicenvarchar10
TOPBasis Components
17/XFT/INV_C1Process type customizing2INV_TYPEInvoice Receipt Typenvarchar40
18/XFT/INV_C3Invoice Receipt: Outbound/Inbound Proxies2INV_TYPEInvoice Receipt Typenvarchar40
19/XFT/INV_C8Workflow Assignment IR2INV_TYPEInvoice Receipt Typenvarchar40
20/XFT/INV_QInvoice receipt queue: Header3INV_TYPEInvoice Receipt Typenvarchar40
21/XFT/INV_Q_SInvoice receipt queue: Header3INV_TYPEInvoice Receipt Typenvarchar40
TOPCross-Application Components
22/OPT/S_INV_HDRVSS Staging Table: Invoice Header6INV_TYPEInvoice Typenvarchar10
23/OPT/VIM_HD_DPVIM IE Monitor: Header Data for DP Invoices9INV_TYPEInvoice Typenvarchar30
TOPDSD Connector
24/DSD/ME_COCI_ITMDSD CN: Check-Out Check-In Items5INV_TYPEDSD Connector: Inventory Typenvarchar10
25/DSD/ME_COCI_PAYDSD CN: Check-Out Check-In Payments5INV_TYPEDSD Connector: Inventory Typenvarchar10
26/DSD/ME_INVT_HDDSD CN: Stock header data4INV_TYPEDSD Connector: inventory typenvarchar10
27/DSD/ME_OI_INVDSD CN: Assign Invoice Types as Open Item Select. Criterias2INV_TYPEDSD CN: Invoice Typenvarchar150
TOPFinancial Accounting
28/OPT/BL_T401Approval COA Fields2INV_TYPEInvoice Typenvarchar10
29/OPT/VIM_T100Document Type Definition33INV_TYPEInvoice Typenvarchar30
TOPInvoice Forecasting
30IFW_C_STAT_OFFIFW customizing: status offset3INV_TYPEInvoice Reference Typenvarchar20
31IFW_HEADERInvoice forecasting header4INV_TYPEInvoice Reference Typenvarchar20
32IFW_ITEMInvoice forecasting item5INV_TYPEInvoice Reference Typenvarchar20
TOPInvoicing in Contract Accounts Receivable and Payable
33DFKKINVDOC_HInvoicing Document Header5INV_TYPEInvoicing Typenvarchar20
34TFK2602Invoicing Processes4INV_TYPEInvoicing Typenvarchar20
35TFK2603Invoicing Types (Process-Specific)4INV_TYPEInvoicing Typenvarchar20
36TFK2603AInvoicing Types3INV_TYPEInvoicing Typenvarchar20
37TFK2603ATInvoicing Types (Texts)4INV_TYPEInvoicing Typenvarchar20
38TFK2603FInvoicing Functions (Exceptions)4INV_TYPEInvoicing Typenvarchar20
39TFK2603TInvoicing Type Texts (Process-Specific)5INV_TYPEInvoicing Typenvarchar20