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

30 columns | Print definition?ERP 6.0  | CARRIER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1MSPT_OIGSTD Shipment Header to store deleted records60CARRIERNumber of forwarding agentnvarchar100
TOPCross-Application Components
2SDEPMENTDepartments: Starting Situation2CARRIERAirline Codenvarchar30
3SDEPMENTTTexts for the Departments: Starting Situation2CARRIERAirline Codenvarchar30
4SDEPMENT_CHDepartments: Enhance with Dept. Head and Time in Incl. (2)2CARRIERAirline Codenvarchar30
5SDEPMENT_CSHDepartments: Collective Search Help2CARRIERAirline Codenvarchar30
6SDEPMENT_SEARCHDepartments: Search Help2CARRIERAirline Codenvarchar30
7SEMPLOYESEmployee Table: Starting Version2CARRIERAirline Codenvarchar30
8SEMPLOYES_APPEmployees: Enhancement by Append (4)2CARRIERAirline Codenvarchar30
9SEMPLOYES_RBEmployees: Enhancement by No. of Agency (2)2CARRIERAirline Codenvarchar30
10SEMPLOYES_TIEmployees: Enhancement by Time Field in Include (3)2CARRIERAirline Codenvarchar30
11SEMPLOY_CSHEmployee table: Collective Search Help2CARRIERAirline Codenvarchar30
12SEMPLOY_SEARCHEmployee Table: Search Help Attachment to Table2CARRIERAirline Codenvarchar30
13SFUNCTEXTText Table for SFUNCTION (Exercise Template BC430)2CARRIERAirline Codenvarchar30
14SFUNCTIONEmployee functions (Exercise template BC430)2CARRIERAirline Codenvarchar30
15SSALARYSalaries for Salary Levels (Exercise Template for BC430)2CARRIERAirline Codenvarchar30
16SSALLEVELSalary Levels for Airline Carriers (Exercise Template BC430)2CARRIERAirline Codenvarchar30
17SSALLEVELTSalary Level Texts (Exercise Templates BC430)2CARRIERAirline Codenvarchar30
TOPDownloadUpload
18/DSD/HH_RAHDDSD Route Settlement: Tour Header Data9CARRIERCarrier Who Accepted the Shipmentnvarchar100
TOPDSD Connector
19/DSD/ME_TOUR_HDDSD CN: Tour Header Data7CARRIERDSD Connector: Carrier IDnvarchar100
TOPInterface to Terminal Automation System
20TOIKTRVSLID TAS relevance determination Shipment6CARRIERTD carrier (vendor account number)nvarchar100
TOPLogistics - General
21OIJTSTransport system (IS-Oil TSW standard/core object )13CARRIERTransport system Carriernvarchar100
TOPRoute Settlement
22/DSD/SL_SLD_HEADSettlement Document Header4CARRIERNumber of forwarding agentnvarchar100
TOPTraders and Schedulers Workbench
23OIGSVTD Vehicles in Transport/Shipment8CARRIERTD carrier (vendor account number)nvarchar100
24OIGVTD Vehicle Header6CARRIERTD carrier (vendor account number)nvarchar100
25OIJHCT01OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE16CARRIERTransport system Carriernvarchar100
26OIJNOMHNomination Header64CARRIERTransport system Carriernvarchar100
27OIJNOMHVERSNomination Header Version Table57CARRIERTransport system Carriernvarchar100
28OIJ_EL_TICKET_HUniversal ticket table19CARRIERTransport system Carriernvarchar100
TOPTransportation and Distribution
29OIGDTD Driver6CARRIERTD carrier (vendor account number)nvarchar100
30OIGSTD Shipment Header60CARRIERNumber of forwarding agentnvarchar100