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
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

47 columns | Print definition?ERP 6.0  | HEIGHT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTX/RM_GOS_BCPRBusiness Content Preferences6HEIGHTHeight of a Business Content elementint100
2/OTX/RM_GOS_SCRSTable to configure screen size according to different action2HEIGHTScreen heightsmallint50
3DOUI_ELEMDBOS Cockpit: Screen Element39HEIGHTint100
TOPABAP Authorization and Role Management
4AGR_MINIMiniApps in Role4HEIGHTCounter for menu IDnvarchar50
5AGR_MINI2MiniApps in Role4HEIGHTCounter for menu IDnvarchar50
TOPAdvertising Management
6JHABILOZIS-M/AM: Assign Artwork to Ad Spec11HEIGHTIS-M/AM: Artwork Heightdecimal73
TOPApplication Frame
7CRMC_UI_FRW_FTRFooter Customization4HEIGHTComponent Heightnvarchar40
8CRMC_UI_FRW_HDRMain page header customizing table3HEIGHTMain Page Header Heightnvarchar40
9CRMC_UI_FRW_SBHDWorkcenter sub-header customizing table4HEIGHTComponent Heightnvarchar40
10CRMC_UI_FRW_WCHDWorkcenter Header Customizing4HEIGHTComponent Heightnvarchar40
TOPBusiness Planning and Simulation
11UPB_PM_GRAPHGraphic Settings for POBs of a Planning Folder10HEIGHTHeight of Graphicnvarchar40
TOPCentral Part of Product Master
12COMM_PR_UNITProduct Unit of Measurement14HEIGHTHeight of the Product or of the Packaging of the Productdecimal133
13COMM_PR_UNITHProduct Unit of Measurement History15HEIGHTHeight of the Product or of the Packaging of the Productdecimal133
TOPClinical System
14N1ANFTYPIS-H*MED: Request Type30HEIGHTLevel of the Graphical F4-Helpnvarchar40
15N1MEEVENTIS-H*MED: Medication, Medication Event39HEIGHTMedication: Order - Height for Calculation - OBSOLETEdecimal52
16TN1MEUNITIS-H*MED: Medication - Units for Orders6HEIGHTMedication: Height Unit Indicatornvarchar10
TOPCollaboration Folders
17CFX_THNThumbnails for cFolders Objects6HEIGHTnvarchar120
TOPData Modeler
18DM41SDM Data Model Hierarchy9HEIGHTFrame heightnvarchar50
TOPElectronic Data Interchange
19PRICAT_K004PRICAT:Cat. item units of measure, dimensions, weights,EANs32HEIGHTHeightdecimal133
20PRICAT_K004_PROIndication of Data to be Adopted from PRICAT_K00421HEIGHTIndicator for copying catalog datanvarchar10
TOPEnd User Technology
21RSKPI_ATTR_DEFKPI Attribute: Header Data8HEIGHTLength (For Example, Maximum Length of Attribute Value)int100
22RSRD_ATTRBroadcasting Framework: Producer/Distributor Attributes10HEIGHTMeasure for the Character Display of an Attributenvarchar30
23RSWAD_PAGE_SIZEPaper Sizes2HEIGHTHeight of Paper Sizedecimal104
TOPForms
24T7XSS_GRT_IFR_DCustomizing table for Iframe in the GRT based applications3HEIGHTHeight of the IFrame in Generic Reporting Toolnvarchar50
TOPGlobal Trade Services
25/SAPSLL/PRLegal & Logistics Services: Product Master15HEIGHTDimension as Floating Point Fieldfloat1516
26/SAPSLL/PRUOMLegal & Logistics Services: Product Master - Units20HEIGHTDimension as Floating Point Fieldfloat1516
TOPGraphic
27TBCLLayer types in bar chart8HEIGHTHeight of graphic elementint100
28TCNONetwork/hierarchy graphics: options profile7HEIGHTNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPInteractive Drilldown Reporting
29TKEB_LAYOUTUser-spec. Layout Info. for Drilldown Rep(invalid from 4.6C)13HEIGHTDrilldown: Control output, size ratio in percentint100
TOPLocalization
30J_3RF_WW_SIZESRersonnel sizes of working wear3HEIGHTHeightnvarchar30
TOPLogistics - General
31MGWPICTURECustomizing Image Data5HEIGHTHeight in Rowsnvarchar40
TOPMaster data
32PACKKPPacking Object Header7HEIGHTHeightdecimal133
TOPNetWeaver Demonstration
33SNWD_PDEPM: Product Data Table22HEIGHTEPM: Dimensiondecimal133
TOPOracle
34INDEX_STATindex_stats Cache: Result of VALIDATE Index (Oracle)4HEIGHTheight of the b-treedecimal140
TOPPlant Maintenance
35PLMN_FL_EXTGHO Object characteristics42HEIGHTHeightfloat1516
TOPRemote Logistics Management
36OIO_C1_CNTNRRLM Oil and gas container master data18HEIGHTContainer heightdecimal133
TOPSAP NetWeaver Mobile - Use subcomponents
37MEREP_PERSONPerson (Sample Application)9HEIGHTHeight (Sample Application)decimal52
TOPStatus and Action Management
38SAMDT_ELEMENTSS&AM Elements16HEIGHTNatural Numberint100
TOPURL Generation
39TWPSRVSFINRuntime: Service File Name & Attribute (Workplace Server)22HEIGHTHeight of the MiniAppnvarchar100
TOPUser Interface
40WCF_COMP_DIMNexus shape's dimentions (SAP table)4HEIGHTWCF GMT Nexus Pixel Length Typenvarchar320
41WCF_COMP_DIMCNexus shape's dimentions (C table)4HEIGHTWCF GMT Nexus Pixel Length Typenvarchar320
TOPWeb Application Builder
42SW3M_ATTRMiniApp Attributes12HEIGHTHeight of the MiniAppnvarchar100
43SW3M_ATTRCCustomizing Data for WebApps6HEIGHTHeight of the MiniAppnvarchar100
TOPWithout Description
44KAP_PSR_OBJObject: Element, Sample16HEIGHTHeightint100
TOPWorkbench
45UGWB1000Workbench Personalization: Size of Window6HEIGHTNatural Numberint100
TOPWorkbench Tools Editors, Painters, Modelers
46W3ATTRCXCustomer Settings for MiniApps6HEIGHTMiniApp Heightnvarchar100
47W3ATTRXMiniApp Attributes12HEIGHTMiniApp Heightnvarchar100