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

51 columns | Print definition?ERP 6.0  | STRUCTURE_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/C_STRSETMapping of Structure Names to Set Types1STRUCTURE_NAMETable Namenvarchar300
2/SAPSRM/C_SW_FLDTable to switch structure fields1STRUCTURE_NAMEName of Structurenvarchar300
3RSFBPSRCTYPEDEFDefinition of source types in the Open ODS View6STRUCTURE_NAMEName of Dictionary Typenvarchar300
4T77OVIS_OTYDFNObject Type Definition3STRUCTURE_NAMEStructure Namenvarchar320
5T77OVIS_OTYDFN_TObject Type definition texts3STRUCTURE_NAMEStructure Namenvarchar320
6T77OVIS_STRUCStructure Definition3STRUCTURE_NAMEStructure Namenvarchar320
7T77OVIS_STRUC_TText Table for Structure Name3STRUCTURE_NAMEStructure Namenvarchar320
TOPAccounting Engine
8/EACC/TBTA1002Data Types per Interface, Optimization for Joins6STRUCTURE_NAMEName of a structurenvarchar300
9/EACC/TBTA1004Linking of Dependent Tables, e.g. Header, Event, Row8STRUCTURE_NAMEName of a structurenvarchar300
10/EACC/TBTA1005Exceptions for Object Type with Statistical Structure Templ.4STRUCTURE_NAMEName of a structurenvarchar300
11/EACC/TBTA4002Assignment of Generated Structures to Log. Object Types4STRUCTURE_NAMEName of a structurenvarchar300
12/EACC/TBTA4005Assignment of Generated Structures for Derivations5STRUCTURE_NAMEName of a structurenvarchar300
TOPBusiness Partner
13BPCE_MO_CDOCOBSOLETE5STRUCTURE_NAMETable Namenvarchar300
14CCXO_BO_IO_STRSemantic Structure for Business Objects (Customer)4STRUCTURE_NAMEName of Read/Write Access Structurenvarchar300
15CCXO_MO_IO_STRSemantic Structure for Memory Objects (Customer)4STRUCTURE_NAMEName of Read/Write Access Structurenvarchar300
16CCXO_SO_IO_STRSemantic Structure for Segment Objects (Customer)4STRUCTURE_NAMEName of Read/Write Access Structurenvarchar300
17CEXO_BO_IO_STRSemantic Structure for Business Objects4STRUCTURE_NAMEName of Read/Write Access Structurenvarchar300
18CEXO_MO_IO_STRSemantic Structure for Memory Objects4STRUCTURE_NAMEName of Read/Write Access Structurenvarchar300
19CEXO_SO_IO_STRSemantic Structure for Segment Objects4STRUCTURE_NAMEName of Read/Write Access Structurenvarchar300
TOPCapacity and Resource Planning
20/MRSS/C_RM_COLSMaintain Column Display for WDA ALV2STRUCTURE_NAMEDictionary objectnvarchar300
TOPCommon Parts
21T7XSSPERSTRUCTInfotype record Structure assignment by country4STRUCTURE_NAME30 Charactersnvarchar300
TOPCross-Application Components
22J_5KFH_CLNRELDATNot relevant gathered data of Legal Forms3STRUCTURE_NAMEStructure for data storingnvarchar400
TOPE-Recruiting
23T77RCF_WL_AREAApplication Area for Worklists2STRUCTURE_NAMEStructure Name for Application Area of Worklistnvarchar300
TOPElectronic Data Interchange
24WRF_PRICAT_PREPrice Catalog Default5STRUCTURE_NAMETable Namenvarchar300
25WRF_PRICAT_PRE_CPrice Catalog Default Customizing for Client Level5STRUCTURE_NAMETable Namenvarchar300
26WRF_PRICAT_PRE_RPrice Catalog Default2STRUCTURE_NAMETable Namenvarchar300
27WRF_SEL_SUPPLYField Supply for Field Selection of Selection Fields1STRUCTURE_NAMEName of a structurenvarchar300
TOPESS Based on WD ABAP
28HRESS_D_PROFILESCATS: Table for storing structures created for each profile2STRUCTURE_NAMEField Namenvarchar300
TOPGeographical Information System
29GHO_ATTRNOSTRUCTest Table for Object Type Structure Mapping in GIS3STRUCTURE_NAMEName of a structurenvarchar300
30GHO_INT_OBJATTRTable for Internal Object Attributes4STRUCTURE_NAMEName of a structurenvarchar300
31GHO_INT_OBJATTRTText Table for GHO_INT_OBJATTR4STRUCTURE_NAMEName of a structurenvarchar300
32GHO_INT_PER_ATRInternal Attributes Personalization Table6STRUCTURE_NAMEName of a structurenvarchar300
TOPGRC Process Control Plug-in
33/GRCPI/GRIALOGCFAM - Change Log Suffix Structure2STRUCTURE_NAMETable Namenvarchar300
TOPInformation Retention Manager
34SILM_VIEW_EXITView Definition: Exit (Specific View Building)4STRUCTURE_NAMEResult Structure of an Exit Implementationnvarchar300
TOPLegal Case Management for ILM
35SLCM_OBJ_CATILM: Legal Case Management - Supported Object Categories4STRUCTURE_NAMETable Namenvarchar300
TOPLocalization
36J_3R_CLNRELDATNot relevant gathered data of Legal Forms3STRUCTURE_NAMEStructure for Data Storingnvarchar400
TOPMaintenance Orders
37/MRSS/C_SQE_RSSTMRS: structure for matching result3STRUCTURE_NAMEName of a structurenvarchar300
TOPMaterial Master
38WGDS_STRUCTURESGDS Storage : registered structure2STRUCTURE_NAMEStructure namenvarchar300
TOPPersonnel Time Management
39TPT_FIELD_CATField Catalog3STRUCTURE_NAMEStructure Namenvarchar300
TOPPlant Maintenance
40EAMSC_UI_SHLPConfiguration for search help assignment2STRUCTURE_NAMETable Namenvarchar300
41EAMS_CVBATTMANFTAttribute Manager: Field Text3STRUCTURE_NAMEName of a structurenvarchar300
42EAMS_CVBATTMANSTAttribute Manager: Structure Text3STRUCTURE_NAMEName of a structurenvarchar300
43EAMS_CVBATTRMANDAttribute Manager: User display fields6STRUCTURE_NAMEName of a structurenvarchar300
44EAMS_CVBATTRMANFAttribute Manager: Field3STRUCTURE_NAMEName of a structurenvarchar300
45EAMS_CVBATTRMANSAttribute Manager: Structure3STRUCTURE_NAMEName of a structurenvarchar300
46EAMS_SHLP_CONFIGConfiguration for Search Help Assignment2STRUCTURE_NAMETable Namenvarchar300
47EAMS_UI_SHLPConfiguration for search help assignment1STRUCTURE_NAMETable Namenvarchar300
TOPSAP Records Management
48SRM_INDX1Table for Queue Elements7STRUCTURE_NAMECharacter field, length 64nvarchar640
49SRM_INDX3Table for Deleted Queue Elements7STRUCTURE_NAMECharacter field, length 64nvarchar640
TOPWarranty Claim Processing
50WTY_FIELD_ATTR1Setting Fields for ALV Warranty Check2STRUCTURE_NAMEAllowed Tables for Generic Field Attributres ALVnvarchar300
TOPWeb Service and SOAP - ABAP
51SRT_CHECK_RESULTSRT Health Check: Result5STRUCTURE_NAMESRT Health Check: Structure Namenvarchar300