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

20 columns | Print definition?ERP 6.0  | PROP_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/C_CUM_PROPCumulation Properties for Simplification3PROP_IDProperty ID for Cumulationnvarchar300
2/GBT/C_SEL_RANGESelection Range for Simplification4PROP_IDSelection Criterionnvarchar300
3/XFT/COMMAIL00AMail: Header Properties (String)3PROP_IDMail: property IDnvarchar20
4/XFT/DDS_SRM_01ADocument: String data3PROP_IDString Document Property IDnvarchar20
5/XFT/DDS_SRM_02AComponent: String data4PROP_IDString Component Property IDnvarchar20
TOPeCATT Extended Computer Aided Test Tool
6TZRR_DEP_PROPTestZone: Result Repository Deployment Properties5PROP_IDProperty IDnvarchar80
7TZRR_EXPROPTestZone: Result Repository Toolspezifische Erweiterungen5PROP_IDProperty IDnvarchar80
8TZRR_PROPTestZone: Result Repository Tool-Specific Extensions4PROP_IDProperty IDnvarchar80
TOPMapping
9SMPPBINDMapping Parameterization: Binding1PROP_IDXI Runtime: GUIDvarbinary160
10SMPPMAP3Mapping Runtime: Mapping20PROP_IDXI Runtime: GUIDvarbinary160
11SMPPPARMapping Runtime: Parameterization5PROP_IDXI Runtime: GUIDvarbinary160
12SMPPREL3Mapping Runtime: Mapping Relation22PROP_IDXI Runtime: GUIDvarbinary160
TOPPortfolio Management
13RPM_UI_CVIEWPROPiView Properties - Customer Settings3PROP_IDiView Property IDnvarchar200
14RPM_UI_IVIEWPROPiView Properties2PROP_IDiView Property IDnvarchar200
15RPM_UI_PROP_IDiView Property ID1PROP_IDiView Property IDnvarchar200
16RPM_UI_PROP_ID_TiView Property ID Text2PROP_IDiView Property IDnvarchar200
17RPM_UI_PROP_MAPiView Property Mapping2PROP_IDiView Property IDnvarchar200
TOPWeb Service and SOAP - ABAP
18SRT_CFG_DATASOAP Runtime Framework: Configuration Data7PROP_IDint100
19SRT_RTC_DATASOAP Runtime Cache: Data7PROP_IDint100
20SRT_RTC_DATALSOAP Runtime Cache: Data7PROP_IDint100