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

34 columns | Print definition?ERP 6.0  | CHKDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHPRCD_PCR_COMPLCompliance Check Result12CHKDATEDate of Checknvarchar80
2HRP1772DB Table for Infotype 177224CHKDATEDate of Rule Checknvarchar80
TOPALE Integration Technology
3BDLSCCSStatus of ALE Basis Customizing Data Check4CHKDATEDate data element for SYSTnvarchar80
TOPCCMS Database Monitors for Oracle
4DBSMSGORAStructure for DB System Check Messages (Acc. to DBMSGORA)3CHKDATEDetection datenvarchar140
TOPDB2 for OS39
5DBMSGDB2DB2/390 System Check Messages3CHKDATEDB2 for OS/390: Date of the checknvarchar80
6DBSYCHKDB2DB2/390: Global Information for Database System Check1CHKDATEDB2 for OS/390: Date of the checknvarchar80
TOPLogistics Basic Data
7CMMD_CDT1Category13CHKDATECM: Space Management Key Datenvarchar80
8CMMD_CDT2Master Data Subcategory12CHKDATECM: Space Management Key Datenvarchar80
9CMMD_CDT3Master Data Segment12CHKDATECM: Space Management Key Datenvarchar80
10CMMD_CDT4Master Data Subsegment12CHKDATECM: Space Management Key Datenvarchar80
11CMMD_CDT5Master Data Sub-Subsegment12CHKDATECM: Space Management Key Datenvarchar80
12CMMD_CDT6Master Data Product Group12CHKDATECM: Space Management Key Datenvarchar80
13CMMD_CDT7Master Data Brand12CHKDATECM: Space Management Key Datenvarchar80
14CMMD_SKUCDT-SKU Assignment Table18CHKDATECM: Space Management Key Datenvarchar80
15WRF_CMMD_CDT1Category13CHKDATECM: Space Management Key Datenvarchar80
16WRF_CMMD_CDT2Subcategory13CHKDATECM: Space Management Key Datenvarchar80
17WRF_CMMD_CDT3Segment13CHKDATECM: Space Management Key Datenvarchar80
18WRF_CMMD_CDT4Subsegment13CHKDATECM: Space Management Key Datenvarchar80
19WRF_CMMD_CDT5Sub-Subsegment13CHKDATECM: Space Management Key Datenvarchar80
20WRF_CMMD_CDT6Product Group13CHKDATECM: Space Management Key Datenvarchar80
21WRF_CMMD_CDT7Brand13CHKDATECM: Space Management Key Datenvarchar80
22WRF_CMMD_SKUCDT-SKU Assignment Table18CHKDATECM: Space Management Key Datenvarchar80
23WRF_MATGRP_MD1Hierarchy Level 1 - Time-Dependent17CHKDATECM: Space Management Key Datenvarchar80
24WRF_MATGRP_MD10Hierarchy Level 10 - Time-Dependent26CHKDATECM: Space Management Key Datenvarchar80
25WRF_MATGRP_MD2Hierarchy Level 2 - Time-Dependent18CHKDATECM: Space Management Key Datenvarchar80
26WRF_MATGRP_MD3Hierarchy Level 3 - Time-Dependent19CHKDATECM: Space Management Key Datenvarchar80
27WRF_MATGRP_MD4Hierarchy Level 4 - Time-Dependent20CHKDATECM: Space Management Key Datenvarchar80
28WRF_MATGRP_MD5Hierarchy Level 5 - Time-Dependent21CHKDATECM: Space Management Key Datenvarchar80
29WRF_MATGRP_MD6Hierarchy Level 6 - Time-Dependent22CHKDATECM: Space Management Key Datenvarchar80
30WRF_MATGRP_MD7Hierarchy Level 7 - Time-Dependent23CHKDATECM: Space Management Key Datenvarchar80
31WRF_MATGRP_MD8Hierarchy Level 8 - Time-Dependent24CHKDATECM: Space Management Key Datenvarchar80
32WRF_MATGRP_MD9Hierarchy Level 9 - Time-Dependent25CHKDATECM: Space Management Key Datenvarchar80
33WRF_MATGRP_PRODHierarchy-Product Assignment Table25CHKDATECM: Space Management Key Datenvarchar80
TOPProduct Safety
34CCRCT_LOCKEHS: Blocked Documents10CHKDATEDate of Last Online Checknvarchar80