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

32 columns | Print definition?ERP 6.0  | HZDAT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CE1PR22Périm. résultat IDES10HZDATDate de création de l'enregistrementnvarchar80
2CE2PR22Périm. résultat IDES9HZDATDate de création de l'enregistrementnvarchar80
TOPBasic Functions
3FDESCash Management and Forecast: Memo Records17HZDATDate on Which Record Was Creatednvarchar80
4FDESDISTCash management memo records (distributed)18HZDATDate on Which Record Was Creatednvarchar80
TOPProfitability Analysis
5CE1850010HZDATDate on Which Record Was Creatednvarchar80
6CE1BGISErgebnisbereich für10HZDATDatum, an dem der Satz hinzugefügt wurdenvarchar80
7CE1E_B1Model Bank10HZDATDate on Which Record Was Creatednvarchar80
8CE1IDEAOp. Concern BR World10HZDATDate on Which Record Was Creatednvarchar80
9CE1IDEBErgebnisbereich IDES10HZDATDatum, an dem der Satz hinzugefügt wurdenvarchar80
10CE1IDESErgebnisbereich IDES10HZDATDatum, an dem der Satz hinzugefügt wurdenvarchar80
11CE1INT1Ergebnisbereich IDES10HZDATDatum, an dem der Satz hinzugefügt wurdenvarchar80
12CE1OC01Bike International10HZDATDate on Which Record Was Creatednvarchar80
13CE1R300Operating Concern IDES10HZDATDate on Which Record Was Creatednvarchar80
14CE1S001Sample operating concern10HZDATDate on Which Record Was Creatednvarchar80
15CE1S300Operating Concern IDES10HZDATDate on Which Record Was Creatednvarchar80
16CE1S_ALAirline Route Profit10HZDATDate on Which Record Was Creatednvarchar80
17CE1S_CPTemplate for Consumer Goods Industry10HZDATDate on Which Record Was Creatednvarchar80
18CE1S_GOQuickstart Template10HZDATDate on Which Record Was Creatednvarchar80
19CE285009HZDATDate on Which Record Was Creatednvarchar80
20CE2BGISErgebnisbereich für9HZDATDatum, an dem der Satz hinzugefügt wurdenvarchar80
21CE2E_B1Model Bank9HZDATDate on Which Record Was Creatednvarchar80
22CE2IDEAOp. Concern BR World9HZDATDate on Which Record Was Creatednvarchar80
23CE2IDEBErgebnisbereich IDES9HZDATDatum, an dem der Satz hinzugefügt wurdenvarchar80
24CE2IDESErgebnisbereich IDES9HZDATDatum, an dem der Satz hinzugefügt wurdenvarchar80
25CE2INT1Ergebnisbereich IDES9HZDATDatum, an dem der Satz hinzugefügt wurdenvarchar80
26CE2OC01Bike International9HZDATDate on Which Record Was Creatednvarchar80
27CE2R300Operating Concern IDES9HZDATDate on Which Record Was Creatednvarchar80
28CE2S001Sample operating concern9HZDATDate on Which Record Was Creatednvarchar80
29CE2S300Operating Concern IDES9HZDATDate on Which Record Was Creatednvarchar80
30CE2S_ALAirline Route Profit9HZDATDate on Which Record Was Creatednvarchar80
31CE2S_CPTemplate for Consumer Goods Industry9HZDATDate on Which Record Was Creatednvarchar80
32CE2S_GOQuickstart Template9HZDATDate on Which Record Was Creatednvarchar80