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
9OVTG52Tax Definition
10OPOR386Purchase Order

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

45 columns | Print definition?ERP 6.0  | STLTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1SGT_BOMCSegmentation for BOM items2STLTYBOM categorynvarchar10
2TCS05Transaction-Specific Defaults for BOMs3STLTYBOM categorynvarchar10
3ZEIM_VBAPSales Document: Item Data172STLTYBOM categorynvarchar10
TOPBills of Material
4PSGRMaster item group6STLTYBOM categorynvarchar10
5STASBOMs - Item Selection2STLTYBOM categorynvarchar10
6STKOBOM Header2STLTYBOM categorynvarchar10
7STPNBOM Follow-Up Control3STLTYBOM categorynvarchar10
8STPOBOM item2STLTYBOM categorynvarchar10
9STPUBOM Subitem2STLTYBOM categorynvarchar10
10STVBBills of Material - Serialization of Posting2STLTYBOM categorynvarchar10
11STZUPermanent BOM data2STLTYBOM categorynvarchar10
12TCS09BOM Control Depending on Category and Usage2STLTYBOM categorynvarchar10
13TCS17BOMs with History Requirement2STLTYBOM categorynvarchar10
TOPCross-Application Components
14PDS_COMPComponent Data for PDS6STLTYBOM categorynvarchar10
15VVBAPSales Document: Item Data172STLTYBOM categorynvarchar10
TOPDistribution Requirements Planning
16PLPLAN_PARAMBOM-dependent planning parameter9STLTYBOM categorynvarchar10
TOPEngineering Change Management
17TCC01ECH: Object types6STLTYBOM Categorynvarchar10
TOPEngineering Configuration Order BOM
18CUOBOM_CHANGEManually Changed Items in the Order BOM7STLTYBOM categorynvarchar10
TOPIntegrated Product and Process Engineering
19CMIG_MAPPINGMapping Table (Classic PP and iPPE Objekt Key)3STLTYBOM categorynvarchar10
20CMIG_STATUSStatus Table (iPPE Migration)3STLTYBOM categorynvarchar10
TOPInventory Management
21RESBReservation/dependent requirements59STLTYBOM categorynvarchar10
TOPLogistics - General
22WBHITrading Contract: Item Data128STLTYBOM categorynvarchar10
TOPMaster Data
23MDSMSimulative dependent requirements75STLTYBOM categorynvarchar10
TOPProduct Data Management
24CONV_MATRICESMatrixes that must be checked into BOMs6STLTYBOM categorynvarchar10
25PDN_MAP_HEADERProduct Designer: Mapping Table for Headers8STLTYBOM categorynvarchar10
26PDN_MAP_ITEMProduct Designer: Mapping Table for Items5STLTYBOM categorynvarchar10
TOPProduct Safety
27ESTWLEHS: BOMBOS - Worklist Table16STLTYBOM categorynvarchar10
TOPProduction Orders
28AFKOOrder Header Data PP Orders31STLTYBOM categorynvarchar10
29DRAD_PORDERAttributes for Links: Document to Production Order10STLTYBOM categorynvarchar10
TOPRemaining Beverage - Obsolete Objects
30/BEV1/RBVBAPSales Document: Item Data172STLTYBOM categorynvarchar10
TOPResourcen Management
31FRMLT20RMS-FRM: Connection Table BOM - Formula (LoM)8STLTYBOM categorynvarchar10
TOPRouting
32PLKOTask list - header61STLTYBOM categorynvarchar10
33PLMZAllocation of bill of material items to operations14STLTYBOM categorynvarchar10
34STPFStructure tree of the exploded BOM6STLTYBOM categorynvarchar10
TOPSales
35VBAPSales Document: Item Data172STLTYBOM categorynvarchar10
TOPSimulation
36VSAFKO_CNVersion: Order header data for PP orders32STLTYBOM categorynvarchar10
37VSRESB_CNVersion: Reservation/Dependent requirements60STLTYBOM categorynvarchar10
38VSVBAP_CNVersion: Sales document: Item data173STLTYBOM categorynvarchar10
TOPTraders and Schedulers Workbench
39OIJNOMCOIL-TSW: Nomination copy table63STLTYBOM categorynvarchar10
40OIJNOMINomination Item63STLTYBOM categorynvarchar10
41OIJNOMIVERSNomination Item Version Table65STLTYBOM categorynvarchar10
42OIJ_SCHEDPlanned Schedule Lines114STLTYBOM categorynvarchar10
TOPTransportation and Distribution
43OIGSMTD Material Allocated to a Shipment6STLTYBOM categorynvarchar10
TOPVariant Configuration
44CLRKRecursiveness Info on Objects in Classes for BOM6STLTYBOM categorynvarchar10
45CUPEExtension to BOM Item for Variants2STLTYBOM categorynvarchar10