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

40 columns | Print definition?ERP 6.0  | EDATU

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule15EDATUnvarchar80
2/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.10EDATUnvarchar80
3ZEIM_VBEPSales Document: Schedule Line Data7EDATUSchedule line datenvarchar80
TOPBasic Functions
4FDS1Cash Management & Forecast: Line Items of SD Documents24EDATUSchedule line datenvarchar80
TOPBasis Components
5ZDS400_VBEPTabelle für Beispielprogramm des ZDS4007EDATUEinteilungsdatumnvarchar80
TOPCross-Application Components
6MAAVC_MILESTMPO: Milestones for WBS Elements2EDATUFixed milestone date (basic)nvarchar80
7VVBEPSales Document: Schedule Line Data7EDATUSchedule line datenvarchar80
TOPData Collection
8S260SD - Sales order114EDATUSchedule line datenvarchar80
9S260BIW1SD - Sales order114EDATUSchedule line datenvarchar80
10S260BIW2SD - Sales order114EDATUSchedule line datenvarchar80
11S261SD - Delivery note96EDATUSchedule line datenvarchar80
12S261BIW1SD - Delivery note96EDATUSchedule line datenvarchar80
13S261BIW2SD - Delivery note96EDATUSchedule line datenvarchar80
14S263SD - Sales order/delivery note75EDATUSchedule line datenvarchar80
15S263BIW1SD - Sales order/delivery note75EDATUSchedule line datenvarchar80
16S263BIW2SD - Sales order/delivery note75EDATUSchedule line datenvarchar80
17S264SD- Offer117EDATUSchedule line datenvarchar80
18S264BIW1S264BIW1 * SD - Quotation117EDATUSchedule line datenvarchar80
19S264BIW2S264BIW2 * SD - Quotation117EDATUSchedule line datenvarchar80
TOPLocalization
20J_3RSCCDITEMCargo Customs Declaration Item11EDATUSchedule line datenvarchar80
TOPMaster Data
21MDMULTLEVDELAYMultilevel Delay Calculated via Order Report22EDATUSchedule line datenvarchar80
TOPNetwork and Activity
22MLSTMilestone25EDATUFixed milestone date (basic)nvarchar80
TOPProfitability Analysis
23CEERRORCO-PA: Incorrect records from SD59EDATUSchedule line datenvarchar80
TOPRemaining Beverage - Obsolete Objects
24/BEV1/REMIETERental Items: Shadow Table for VBAK/VBAP/VBEP11EDATUSchedule line datenvarchar80
25/BEV1/REWARTRental Items: Delivery Schedule Items11EDATUSchedule line datenvarchar80
TOPSales
26VBEHSchedule line history9EDATUSchedule line datenvarchar80
27VBEPSales Document: Schedule Line Data7EDATUSchedule line datenvarchar80
TOPSimulation
28VSMLST_CNVersion: Milestone26EDATUFixed milestone date (basic)nvarchar80
29VSVBEP_CNVersion: Sales document: Schedule line data8EDATUSchedule line datenvarchar80
TOPTraders and Schedulers Workbench
30OIJ_EL_DOC_MOTOil TSW: TSW Relevance of order item10EDATUSchedule line datenvarchar80
31S430SIS: (OIL-TSW) Sales document statistics by TSW object25EDATUSchedule line datenvarchar80
TOPWarehouse Management
32LL01Whse Activity Monitor: Critical Transfer Order Items9EDATUWarehouse activity monitor: Creation datenvarchar80
33LL02Whse Activity Monitor: Critical Transfer Requirement Items10EDATUWarehouse activity monitor: Creation datenvarchar80
34LL03Whse Activity Monitor: Critical Posting Change Documents6EDATUWarehouse activity monitor: Creation datenvarchar80
35LL04Whse Activity Monitor: Critical Deliveries6EDATUWarehouse activity monitor: Creation datenvarchar80
36LL05Whse Activity Monitor: Critical Stocks6EDATUWarehouse activity monitor: Creation datenvarchar80
37LL06Whse Activity Monitor: Critical Storage Bins6EDATUWarehouse activity monitor: Creation datenvarchar80
38LL07Whse Activity Monitor: Critical Production Orders6EDATUWarehouse activity monitor: Creation datenvarchar80
39LQUAQuants24EDATUDate of last placement into stocknvarchar80
40LTAPTransfer order item132EDATUDate of Pick Confirmation (First Step)nvarchar80