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

21 columns | Print definition?ERP 6.0  | ACCESSTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTEI/T_GU_ATGuestUser: Access type2ACCESSTYPEGuestUser: Access typenvarchar200
2/OTEI/T_GU_DOMGuestUser: Domains for eMail notification2ACCESSTYPEGuestUser: Access typenvarchar200
3/OTEI/T_GU_FOOTGuestUser: Footer for eMail notification2ACCESSTYPEGuestUser: Access typenvarchar200
4/OTEI/T_GU_GUGuestUser: Actual guest users3ACCESSTYPEGuestUser: Access typenvarchar200
5/OTEI/T_GU_LOGGuestUser: Log-Table guest users12ACCESSTYPEGuestUser: Access typenvarchar200
TOPBusiness Configuration Tools Runtime
6SC2_IPG_ACCESSC2: Implementation of Access Interface (Inactive)3ACCESSTYPEC2: Configuration Data Access Typenvarchar30
7SC2_PGL_ACCESSC2 Server: Implementation of Access Interface (old)4ACCESSTYPEC2: Configuration Data Access Typenvarchar30
8SC2_PG_ACCESSC2 Server: Access Interface Implementation4ACCESSTYPEC2: Configuration Data Access Typenvarchar30
TOPCross-Application Components
9SPRTL14Object Relations4ACCESSTYPEDrag&Relate: Type of Object Linknvarchar10
10SPRTL14CObject Relations (Runtime)5ACCESSTYPEDrag&Relate: Type of Object Linknvarchar10
TOPData Staging
11RSDSACCESSTYPESData Access Methods DataSource2ACCESSTYPEAccess Methodnvarchar10
TOPFinancial Accounting
12SREPACCESSTYPEAccess Type1ACCESSTYPEAccess Typenvarchar10
13SREPACCESSTYPETAccess Type2ACCESSTYPEAccess Typenvarchar10
TOPFlexible Real Estate Management
14TIVLDSTRATStrategy for Accessing Search Help Index Logical DB6ACCESSTYPEOption for ranges tablesnvarchar20
TOPGeneral Ledger Accounting
15FAGLSREPACCTPAccess Type for Financial Statements1ACCESSTYPEAccess Type for Financial Statementsnvarchar10
16FAGLSREPACCTPTAccess Type for Financial Statements2ACCESSTYPEAccess Type for Financial Statementsnvarchar10
TOPIncentive and Commission Management ICM
17TCACS_DETACCAccess Type1ACCESSTYPEAccess Typenvarchar20
18TCACS_DETACCTAccess Type Texts1ACCESSTYPEAccess Typenvarchar20
19TCACS_DETAFLAccess Type Characteristics1ACCESSTYPEAccess Typenvarchar20
20TCACS_DETETUAccess Type Assignment of Entry Point2ACCESSTYPEAccess Typenvarchar20
TOPProcess Management
21POC_DB_C_OPERDomain Model: Operation Collection5ACCESSTYPEAccess methodnvarchar10