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

49 columns | Print definition?ERP 6.0  | CRE_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_U_PLISTCMIS Upg: Piece list administration5CRE_DATEDatenvarchar80
2CNVMBTDELPARAMSParameter for the generic deletion program15CRE_DATEDatenvarchar80
3CNVMBTDELREFTECHTechnical info about the reorganization like job and log8CRE_DATEModification datenvarchar80
4MSPT_OIGSTD Shipment Header to store deleted records62CRE_DATEDate on Which Record Was Creatednvarchar80
5MSPT_OIGSIShipment Item to store deleted records8CRE_DATEDate on Which Record Was Creatednvarchar80
TOPBusiness Service Functions
6RTXTHHeader Table for Report Texts8CRE_DATEnvarchar80
TOPData Transfer
7KCD_TYVPES_ADMExt. Data Transfer: Creation Date of Entries in KCD_TYVPES3CRE_DATEDate of Last Changenvarchar80
TOPDownstream
8OIGSJ1BHBrazilian Taxes for Delivery Header9CRE_DATEDate on Which Record Was Creatednvarchar80
9OIGSJ1BIBrazilian Taxes for Delivery Item11CRE_DATEDate on Which Record Was Creatednvarchar80
TOPEnd User Technology
10RSRA_BP_RTXTHReport Agent BP Transport Copy/Versioning of rtxth8CRE_DATEnvarchar80
TOPKANBAN
11PKHDControl Cycle56CRE_DATECreation Date of Control Cyclenvarchar80
TOPRemote Logistics Management
12OIO_VMIS_RESCRLM VMIS: Rescue Material on Vehicle4CRE_DATECreated Onnvarchar80
TOPTariffs, Duties and Permits
13OIH_J1B_TCHTax Calculation Commands Header7CRE_DATEDate on Which Record Was Creatednvarchar80
TOPTraders and Schedulers Workbench
14OIGCCTD Compartment12CRE_DATECreated Onnvarchar80
15OIGCCMACompartment Meter Assignment Table6CRE_DATECreated Onnvarchar80
16OIGCMTD Vehicle Meter12CRE_DATECreated Onnvarchar80
17OIGCMATD Transport Unit Meter Assignment6CRE_DATECreated Onnvarchar80
18OIGSVTD Vehicles in Transport/Shipment61CRE_DATECreated Onnvarchar80
19OIGVTD Vehicle Header51CRE_DATECreated Onnvarchar80
20OIGVTUTD Vehicle - Transport Unit Assignment5CRE_DATECreated Onnvarchar80
21OIJECTD-Transport Unit Master Data Events20CRE_DATEDate on Which Record Was Creatednvarchar80
22OIJEVTD-Vehicle ~ Berth Master Data Events23CRE_DATEDate on Which Record Was Creatednvarchar80
23OIJNENomination Events22CRE_DATEDate on Which Record Was Creatednvarchar80
24OIJSUBITEMEVENTSNomination Sub Item Events20CRE_DATEDate on Which Record Was Creatednvarchar80
25OIJ_STAGESTSW (&TD) Shipment Stages9CRE_DATEDate on Which Record Was Creatednvarchar80
TOPTransport Organizer
26E070CREATEChange & Transport System: Creation Date of Request2CRE_DATEDate of Last Changenvarchar80
TOPTransportation and Distribution
27OIGCTD Transport unit22CRE_DATECreated Onnvarchar80
28OIGDTD Driver8CRE_DATECreated Onnvarchar80
29OIGDHTD Driver Shift6CRE_DATECreated Onnvarchar80
30OIGDLTD Driver's license data7CRE_DATECreated Onnvarchar80
31OIGRMTD Rack Meter Master Table17CRE_DATECreated Onnvarchar80
32OIGRMMTD Rack Meter / Material Assignment4CRE_DATECreated Onnvarchar80
33OIGRMPSTD Rack Meter / Storage Location Assignment5CRE_DATECreated Onnvarchar80
34OIGSTD Shipment Header62CRE_DATEDate on Which Record Was Creatednvarchar80
35OIGSETD Events19CRE_DATEDate on Which Record Was Creatednvarchar80
36OIGSHTD Shipment History15CRE_DATECreated Onnvarchar80
37OIGSIShipment Item8CRE_DATEDate on Which Record Was Creatednvarchar80
38OIGSMTD Material Allocated to a Shipment18CRE_DATEDate on Which Record Was Creatednvarchar80
39OIGSMSTD Material Samples on a Shipment10CRE_DATEDate on Which Record Was Creatednvarchar80
40OIGSMVTD Material Balance on Vehicle12CRE_DATEDate on Which Record Was Creatednvarchar80
41OIGSSTD Shipment Stages9CRE_DATEDate on Which Record Was Creatednvarchar80
42OIGSVCTD Transport Unit in Shipment21CRE_DATECreated Onnvarchar80
43OIGSVCCTD Compartment in Shipment13CRE_DATECreated Onnvarchar80
44OIGSVCSTD Vehicle Seals on Transport Units9CRE_DATEDate on Which Record Was Creatednvarchar80
45OIGSVDTD Driver per Vehicle on a Shipment6CRE_DATEDate on Which Record Was Creatednvarchar80
46OIGSVMQTD Quantity Item for Material on Vehicle27CRE_DATEDate on Which Record Was Creatednvarchar80
47OIGSVMQMTD On Board Movements References10CRE_DATEDate on Which Record Was Creatednvarchar80
48OIGVLTD Licenses Needed for Vehicle4CRE_DATECreated Onnvarchar80
49TOIGUSTD - User Screens for Master Data9CRE_DATECreated Onnvarchar80