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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

44 columns | Print definition?ERP 6.0  | CHA_DATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1MSPT_OIGSTD Shipment Header to store deleted records65CHA_DATEChanged Onnvarchar80
2MSPT_OIGSIShipment Item to store deleted records11CHA_DATEChanged Onnvarchar80
TOPDownstream
3OIGSJ1BHBrazilian Taxes for Delivery Header12CHA_DATEChanged Onnvarchar80
4OIGSJ1BIBrazilian Taxes for Delivery Item14CHA_DATEChanged Onnvarchar80
TOPRegulatory reporting for insurance companies
5TISSR_CHA_MDATAAufzeichnung von Aktivitaeten zur Stammdatenaenderung4CHA_DATEDatumnvarchar80
TOPRemote Logistics Management
6OIO_VMIS_RESCRLM VMIS: Rescue Material on Vehicle6CHA_DATEDate of Last Changenvarchar80
TOPTariffs, Duties and Permits
7OIH_J1B_TCHTax Calculation Commands Header10CHA_DATEChanged Onnvarchar80
8OIH_J1B_TCHHTax Calculation Commands Header History7CHA_DATEChanged Onnvarchar80
TOPTraders and Schedulers Workbench
9OIGCCTD Compartment14CHA_DATEDate of Last Changenvarchar80
10OIGCCMACompartment Meter Assignment Table8CHA_DATEDate of Last Changenvarchar80
11OIGCMTD Vehicle Meter14CHA_DATEDate of Last Changenvarchar80
12OIGCMATD Transport Unit Meter Assignment8CHA_DATEDate of Last Changenvarchar80
13OIGSVTD Vehicles in Transport/Shipment64CHA_DATEDate of Last Changenvarchar80
14OIGVTD Vehicle Header53CHA_DATEDate of Last Changenvarchar80
15OIGVTUTD Vehicle - Transport Unit Assignment7CHA_DATEDate of Last Changenvarchar80
16OIJECTD-Transport Unit Master Data Events24CHA_DATEChanged Onnvarchar80
17OIJEVTD-Vehicle ~ Berth Master Data Events27CHA_DATEChanged Onnvarchar80
18OIJNENomination Events25CHA_DATEChanged Onnvarchar80
19OIJSUBITEMEVENTSNomination Sub Item Events23CHA_DATEChanged Onnvarchar80
20OIJ_STAGESTSW (&TD) Shipment Stages12CHA_DATEChanged Onnvarchar80
TOPTranslation Tools
21TRMIDXLog Entries for TRM Processing Runs14CHA_DATEDate of Last Changenvarchar80
TOPTransportation and Distribution
22OIGCTD Transport unit24CHA_DATEDate of Last Changenvarchar80
23OIGDTD Driver10CHA_DATEDate of Last Changenvarchar80
24OIGDHTD Driver Shift8CHA_DATEDate of Last Changenvarchar80
25OIGDLTD Driver's license data9CHA_DATEDate of Last Changenvarchar80
26OIGRMTD Rack Meter Master Table19CHA_DATEDate of Last Changenvarchar80
27OIGRMMTD Rack Meter / Material Assignment6CHA_DATEDate of Last Changenvarchar80
28OIGRMPSTD Rack Meter / Storage Location Assignment7CHA_DATEDate of Last Changenvarchar80
29OIGSTD Shipment Header65CHA_DATEChanged Onnvarchar80
30OIGSETD Events22CHA_DATEChanged Onnvarchar80
31OIGSHTD Shipment History18CHA_DATEDate of Last Changenvarchar80
32OIGSIShipment Item11CHA_DATEChanged Onnvarchar80
33OIGSMTD Material Allocated to a Shipment21CHA_DATEChanged Onnvarchar80
34OIGSMSTD Material Samples on a Shipment13CHA_DATEChanged Onnvarchar80
35OIGSMVTD Material Balance on Vehicle15CHA_DATEChanged Onnvarchar80
36OIGSSTD Shipment Stages12CHA_DATEChanged Onnvarchar80
37OIGSVCTD Transport Unit in Shipment24CHA_DATEDate of Last Changenvarchar80
38OIGSVCCTD Compartment in Shipment16CHA_DATEDate of Last Changenvarchar80
39OIGSVCSTD Vehicle Seals on Transport Units12CHA_DATEChanged Onnvarchar80
40OIGSVDTD Driver per Vehicle on a Shipment9CHA_DATEChanged Onnvarchar80
41OIGSVMQTD Quantity Item for Material on Vehicle30CHA_DATEChanged Onnvarchar80
42OIGSVMQMTD On Board Movements References13CHA_DATEChanged Onnvarchar80
43OIGVLTD Licenses Needed for Vehicle6CHA_DATEDate of Last Changenvarchar80
44TOIGUSTD - User Screens for Master Data11CHA_DATEDate of Last Changenvarchar80