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  | CRE_TIME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_U_PLISTCMIS Upg: Piece list administration6CRE_TIMETimenvarchar60
2CNVMBTDELPARAMSParameter for the generic deletion program16CRE_TIMETimenvarchar60
3CNVMBTDELREFTECHTechnical info about the reorganization like job and log9CRE_TIMEModification timenvarchar60
4MSPT_OIGSTD Shipment Header to store deleted records63CRE_TIMEEntry timenvarchar60
5MSPT_OIGSIShipment Item to store deleted records9CRE_TIMEEntry timenvarchar60
TOPBusiness Service Functions
6RTXTHHeader Table for Report Texts9CRE_TIMEnvarchar60
TOPDate Rules
7TIMERULEHDate Rules (Header)6CRE_TIMECreation Time of Date Ruledecimal150
8TIMERUSHShadow Table for Transport Date Rule (Header)6CRE_TIMECreation Time of Date Ruledecimal150
TOPDownstream
9OIGSJ1BHBrazilian Taxes for Delivery Header10CRE_TIMETime, at Which Record Was Addednvarchar60
10OIGSJ1BIBrazilian Taxes for Delivery Item12CRE_TIMETime, at Which Record Was Addednvarchar60
TOPEnd User Technology
11RSRA_BP_RTXTHReport Agent BP Transport Copy/Versioning of rtxth9CRE_TIMEnvarchar60
TOPTariffs, Duties and Permits
12OIH_J1B_TCHTax Calculation Commands Header8CRE_TIMEEntry timenvarchar60
TOPTraders and Schedulers Workbench
13OIGSVTD Vehicles in Transport/Shipment63CRE_TIMETime, at Which Record Was Addednvarchar60
14OIJECTD-Transport Unit Master Data Events21CRE_TIMEEntry timenvarchar60
15OIJEVTD-Vehicle ~ Berth Master Data Events24CRE_TIMEEntry timenvarchar60
16OIJNENomination Events23CRE_TIMEEntry timenvarchar60
17OIJSUBITEMEVENTSNomination Sub Item Events21CRE_TIMEEntry timenvarchar60
18OIJ_STAGESTSW (&TD) Shipment Stages10CRE_TIMETime of creationnvarchar60
TOPTransport Organizer
19E070CREATEChange & Transport System: Creation Date of Request3CRE_TIMELast changed atnvarchar60
TOPTransportation and Distribution
20OIGSTD Shipment Header63CRE_TIMEEntry timenvarchar60
21OIGSETD Events20CRE_TIMEEntry timenvarchar60
22OIGSHTD Shipment History17CRE_TIMETime, at Which Record Was Addednvarchar60
23OIGSIShipment Item9CRE_TIMEEntry timenvarchar60
24OIGSMTD Material Allocated to a Shipment19CRE_TIMETime, at Which Record Was Addednvarchar60
25OIGSMSTD Material Samples on a Shipment11CRE_TIMETime, at Which Record Was Addednvarchar60
26OIGSMVTD Material Balance on Vehicle13CRE_TIMETime, at Which Record Was Addednvarchar60
27OIGSSTD Shipment Stages10CRE_TIMEEntry timenvarchar60
28OIGSVCTD Transport Unit in Shipment23CRE_TIMEEntry timenvarchar60
29OIGSVCCTD Compartment in Shipment15CRE_TIMETime, at Which Record Was Addednvarchar60
30OIGSVCSTD Vehicle Seals on Transport Units10CRE_TIMETime, at Which Record Was Addednvarchar60
31OIGSVDTD Driver per Vehicle on a Shipment7CRE_TIMEEntry timenvarchar60
32OIGSVMQTD Quantity Item for Material on Vehicle28CRE_TIMETime, at Which Record Was Addednvarchar60
33OIGSVMQMTD On Board Movements References11CRE_TIMETime, at Which Record Was Addednvarchar60