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

28 columns | Print definition?ERP 6.0  | ENTRY_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/C_MDFETType of Entry a field belongs to (normal, default or any)1ENTRY_TYPEEntry Typenvarchar10
2/SAPSRM/C_MDFETTType of Entry a field belongs to (normal, default or any)2ENTRY_TYPEEntry Typenvarchar10
3/SAPSRM/C_MDFSBMeta Data Configuration for Set Fields7ENTRY_TYPEEntry Typenvarchar10
4/SAPSRM/C_MDFSBCCustomer Table for Configuration of Set Field Metadata7ENTRY_TYPEEntry Typenvarchar10
5/SAPSRM/C_MDFSBLLook-Up Table BO specific Restriction of Set Field Metadata7ENTRY_TYPEEntry Typenvarchar10
6/SAPSRM/C_MDFSDMeta Data Configuration for Dependant object Fields5ENTRY_TYPEEntry Typenvarchar10
7/SAPSRM/C_MDFSDLLook-Up Table for Dependant Object/Set Field Metadata5ENTRY_TYPEEntry Typenvarchar10
8/SAPSRM/C_MDF_HCCustomer Meta Data Configuration for BO Header Fields6ENTRY_TYPEEntry Typenvarchar10
9/SAPSRM/C_MDF_HDMeta Data Configuration for Business Object Header Fields6ENTRY_TYPEEntry Typenvarchar10
10/SAPSRM/C_MDF_HLLook-Up Table for Meta Data Configuration for Header Fields5ENTRY_TYPEEntry Typenvarchar10
11/SAPSRM/C_MDF_ICCustomer Meta Data Configuration for BO Item Fields8ENTRY_TYPEEntry Typenvarchar10
12/SAPSRM/C_MDF_ILLook-Up Table for Meta Data Configuration for Item Fields7ENTRY_TYPEEntry Typenvarchar10
13/SAPSRM/C_MDF_ITMeta Data Configuration for Business Object Item Fields8ENTRY_TYPEEntry Typenvarchar10
TOPBasis Components
14/XFT/INV_Q_13Relations Process Types5ENTRY_TYPEEntry Typenvarchar320
15/XFT/INV_Q_13_SRelationes Process Types (Shadow Table)5ENTRY_TYPEEntry Typenvarchar320
TOPCheck Input
16OIUCI_HEADERIncoming Check Header information8ENTRY_TYPEMethod by which the Incoming Check Data is Creatednvarchar10
TOPClientServer Technology
17HTTP_WHITELISTHTTP White List2ENTRY_TYPEHTTP Framework - Filter Type for Valid URLsnvarchar20
18HTTP_WHITELIST_SHTTP White List2ENTRY_TYPEHTTP Framework - Filter Type for Valid URLsnvarchar20
TOPeCATT Extended Computer Aided Test Tool
19ECOQ_LOGeCATT OQ Log8ENTRY_TYPEeCATT OQ Log - Type of Log Entrynvarchar10
TOPNetWeaver Enterprise Search
20ESH_EX_CPOINTERChange Pointer Storage5ENTRY_TYPEChange Pointer Entry Typenvarchar10
21ESH_EX_CP_STATUSChange Pointer Processing Status6ENTRY_TYPEChange Pointer Entry Typenvarchar10
22ESH_EX_TPOINTERTransaction Change Pointer Storage6ENTRY_TYPEChange Pointer Entry Typenvarchar10
TOPNursing
23N1NRSPENursing Plan: Entry4ENTRY_TYPENursing Plan: Entry Typenvarchar20
TOPRecords and Case Management
24RMPSPROTETYPESTypes of Log Entries2ENTRY_TYPEType of Log Entrynvarchar200
25RMPSPROTETYPES_TDescription for Types of Log Entries2ENTRY_TYPEType of Log Entrynvarchar200
TOPSyntax, Compiler, Runtime
26SLAD_OBJSET_ENTLSLAD: Object Set - Line5ENTRY_TYPESLAD: Type of an Object Set Unitint100
TOPTravel Planning
27TA20LETree Node (Current Settings for Travel Planning)3ENTRY_TYPEType of Tree Entrynvarchar10
TOPWeb Service and SOAP - ABAP
28SRT_CFG_TRCTrace data for SOAP Runtime Configuration5ENTRY_TYPESRT trace entry typenvarchar10