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

33 columns | Print definition?ERP 6.0  | REG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FIWTQAD_TAXQatar Tax Details9REGCommercial Registrationnvarchar20
2P05EIR_ADDRESSElectronic Illness Reporting: Employee's Address Data10REGWage Return: Region Namenvarchar240
TOPProduct Safety
3CCRCC_BWEHS: Maintenance of Bonded Warehouses2REGRegulatory Listnvarchar100
4CCRCC_BW_CONFEHS: Function Modules for the Bonded Warehouse Functionality2REGRegulatory Listnvarchar100
5CCRCC_CDEHS: Rules for Country Determination2REGRegulatory Listnvarchar100
6CCRCC_CHCK_ONEHS: Online Checks for Regulation/Scenario/Scenario Category2REGRegulatory Listnvarchar100
7CCRCC_DETEHS: Data Determination Modules per Regulation/Scenario2REGRegulatory Listnvarchar100
8CCRCC_DETDOCTYPEEHS: Modules for Regulation/Scenario/Scenario Category2REGRegulatory Listnvarchar100
9CCRCC_ERRMAILEHS: Specify Recipients for Error Messages2REGRegulatory Listnvarchar100
10CCRCC_EXCHGEHS: Data Transfer from and to EH&S2REGRegulatory Listnvarchar100
11CCRCC_FILTEREHS: Data Filtering2REGRegulatory Listnvarchar100
12CCRCC_LIMITGEHS: General Quantity Restriction2REGRegulatory Listnvarchar100
13CCRCC_LIMITSEHS: Relative Quantity Restriction2REGRegulatory Listnvarchar100
14CCRCC_MONEHS: Monitoring Settings2REGRegulatory Listnvarchar100
15CCRCC_PERIODEHS: Period Definition3REGRegulatory Listnvarchar100
16CCRCC_POLEHS: Polymer Labeling and Monomer Composition per Regulation2REGRegulatory Listnvarchar100
17CCRCT_CALCEHS: Calculated Average3REGRegulatory Listnvarchar100
18CCRCT_COEHS: Confirmed Consumed Quantities2REGRegulatory Listnvarchar100
19CCRCT_COPLEHS: Planned Consumed Quantities2REGRegulatory Listnvarchar100
20CCRCT_CUEHS: Customer List - Header Data3REGRegulatory Listnvarchar100
21CCRCT_EHS_COMPEHS: Composition (EH&S Data)2REGRegulatory Listnvarchar100
22CCRCT_EHS_REGEHS: Registration Status (EH&S Data)2REGRegulatory Listnvarchar100
23CCRCT_EHS_SLIMITEHS: Limit Values in Substance (EH&S Data)2REGRegulatory Listnvarchar100
24CCRCT_LOCKEHS: Blocked Documents2REGRegulatory Listnvarchar100
25CCRCT_ORMaterial Business Partner Only Representative Assignment4REGRegulatory Listnvarchar100
26CCRCT_PREHS: Confirmed Produced Quantities2REGRegulatory Listnvarchar100
27CCRCT_PRPLEHS: Planned Produced Quantities2REGRegulatory Listnvarchar100
28CCRCT_PUEHS: Confirmed Purchased Quantities2REGRegulatory Listnvarchar100
29CCRCT_PUPLEHS: Planned Purchased Quantities2REGRegulatory Listnvarchar100
30CCRCT_RUNTime stamp of Tracking and Filling Runs3REGRegulatory Listnvarchar100
31CCRCT_SOEHS: Confirmed Sold Quantities2REGRegulatory Listnvarchar100
32CCRCT_SOPLEHS: Planned Sold Quantities2REGRegulatory Listnvarchar100
TOPReporting
33P05T_IV_PERSOONWage Return: Income Relationship - Personal Data23REGWage Return: Region Namenvarchar240