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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

42 columns | Print definition?B1 9.3  | STAGEID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPGeneral
1APH1Project Management - Stages - History3StageIDStage IDInt110
2APH2Project Management - Stages - Open Issues - History3StageIDStage IDInt110
3APH3Project Management - Stages - Attachments - History3StageIDStage IDInt110
4APH4Project Management - Stages - Documents - History3StageIDStage IDInt110
5APH5Project Management - Stages - Resources - History3StageIDStage IDInt110
6APH6Project Management - Stages - Activities - History3StageIDStage IDInt110
7APH7Project Management - Workorders - History3StageIDStage IDInt110
8APM1Project Management - Stages - History3StageIDStage IDInt110
9APM2Project Management - Stages - Open Issues - History3StageIDStage IDInt110
10APM3Project Management - Stages - Attachments - History3StageIDStage IDInt110
11APM4Project Management - Stages - Documents - History3StageIDStage IDInt110
12APM5Project Management - Stages - Resources - History3StageIDStage IDInt110
13APM6Project Management - Stages - Activities - History3StageIDStage IDInt110
14APM7Project Management - Workorders - History3StageIDStage IDInt110
15ASH1Project Management Time Sheet - Rows - History24StageIDStage IDInt110
16PHA1Project Management - Stages3StageIDStage IDInt110
17PHA2Project Management - Stages - Open Issues3StageIDStage IDInt110
18PHA3Project Management - Stages - Attachments3StageIDStage IDInt110
19PHA4Project Management - Stages - Documents3StageIDStage IDInt110
20PHA5Project Management - Stages - Resources3StageIDStage IDInt110
21PHA6Project Management - Stages - Activities3StageIDStage IDInt110
22PHA7Project Management - Workorders3StageIDStage IDInt110
23PMC2Project Management Configuration - Stages Setup1StageIDStage No.Int110
24PMG1Project Management - Stages3StageIDStage IDInt110
25PMG2Project Management - Stages - Open Issues3StageIDStage IDInt110
26PMG3Project Management - Stages - Attachments3StageIDStage IDInt110
27PMG4Project Management - Stages - Documents3StageIDStage IDInt110
28PMG5Project Management - Stages - Resources3StageIDStage IDInt110
29PMG6Project Management - Stages - Activities3StageIDStage IDInt110
30PMG7Project Management - Workorders3StageIDStage IDInt110
31PMG9Project Management - Charged Document Lines Log - Used by Billing Wizard9StageIDStage IDInt110
32TSH1Project Management Time Sheet - Rows24StageIDStage IDInt110
TOPInventory and Production
33ATT1Bill of Materials - Components - History28StageIdStage IDInt110
34ATT2BOM - Route Stages - History2StageIdStage IDInt110
35AWO1Production Order (Rows) - History32StageIdStage IDInt110
36AWO4Production Order - Route Stages - History2StageIdStage IDInt110
37ITT1Bill of Materials - Components28StageIdStage IDInt110
38ITT2BOM - Route Stages2StageIdStage IDInt110
39UWOR1Production Order - Rows32StageIdStage IDInt110
40UWOR4Production Order - Route Stages2StageIdStage IDInt110
41WOR1Production Order - Rows32StageIdStage IDInt110
42WOR4Production Order - Route Stages2StageIdStage IDInt110