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

54 columns | Print definition?ERP 6.0  | STLNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1SGT_BOMCSegmentation for BOM items3STLNRBill of materialnvarchar80
2ZEIM_VBAPSales Document: Item Data75STLNRBill of materialnvarchar80
TOPBasic Functions
3MMPREK_PRO_02Log table - Main component - Information14STLNRBill of materialnvarchar80
TOPBills of Material
4CLSTLink class - BOM4STLNRBill of materialnvarchar80
5DOSTDocument to BOM Link6STLNRBill of materialnvarchar80
6EQSTEquipment to BOM Link5STLNRBill of materialnvarchar80
7KDSTSales Order to BOM Link7STLNRBill of materialnvarchar80
8MASTMaterial to BOM Link5STLNRBill of materialnvarchar80
9PRSTProject - BOM link6STLNRBill of materialnvarchar80
10PSGRMaster item group7STLNRBill of materialnvarchar80
11STASBOMs - Item Selection3STLNRBill of materialnvarchar80
12STKOBOM Header3STLNRBill of materialnvarchar80
13STPNBOM Follow-Up Control4STLNRBill of materialnvarchar80
14STPOBOM item3STLNRBill of materialnvarchar80
15STPUBOM Subitem3STLNRBill of materialnvarchar80
16STSTStandard BOM Link5STLNRBill of materialnvarchar80
17STZUPermanent BOM data3STLNRBill of materialnvarchar80
18TPSTLink Between Functional Location and BOM5STLNRBill of materialnvarchar80
TOPCross-Application Components
19PDS_COMPComponent Data for PDS7STLNRBill of materialnvarchar80
20VVBAPSales Document: Item Data75STLNRBill of materialnvarchar80
TOPData Collection
21S008Communications Table SD -> CO/Projects43STLNRBill of materialnvarchar80
TOPDistribution Requirements Planning
22PLPLAN_PARAMBOM-dependent planning parameter10STLNRBill of materialnvarchar80
TOPEngineering Configuration Order BOM
23CUOBOM_CHANGEManually Changed Items in the Order BOM8STLNRBill of materialnvarchar80
TOPGlobal Trade Services
24/SAPSLL/BOMHDSLL: BOM - Header6STLNRBill of Material Numbernvarchar80
25/SAPSLL/PRFPMRSLL: Preference: Log: Products: Result of BOM Calculation4STLNRBill of Material Numbernvarchar80
26/SAPSLL/RXPMRRe-Export: Log: BOPs of Product5STLNRBill of Material Numbernvarchar80
TOPIntegrated Product and Process Engineering
27CMIG_MAPPINGMapping Table (Classic PP and iPPE Objekt Key)4STLNRBill of materialnvarchar80
28CMIG_STATUSStatus Table (iPPE Migration)4STLNRBill of materialnvarchar80
TOPInventory Management
29RESBReservation/dependent requirements60STLNRBill of materialnvarchar80
TOPLogistics - General
30WBHITrading Contract: Item Data129STLNRBill of materialnvarchar80
TOPMaster Data
31MDSMSimulative dependent requirements76STLNRBill of materialnvarchar80
TOPMedia Product Sales and Distribution
32JVSDSPLITIS-M: Media Issue Mix9STLNRBill of materialnvarchar80
33JVSDSPLITPLANIS-M: Issue Split (Planned)9STLNRBill of materialnvarchar80
34JVSDSPLITSUBIS-M: Issue Split for Lower Level Issues10STLNRBill of materialnvarchar80
TOPProduct Data Management
35CONV_MATRICESMatrixes that must be checked into BOMs7STLNRBill of materialnvarchar80
36PDN_MAP_HEADERProduct Designer: Mapping Table for Headers9STLNRBill of materialnvarchar80
37PDN_MAP_ITEMProduct Designer: Mapping Table for Items6STLNRBill of materialnvarchar80
TOPProduct Safety
38ESTWLEHS: BOMBOS - Worklist Table19STLNRBill of materialnvarchar80
TOPProduction Orders
39AFKOOrder Header Data PP Orders34STLNRBill of materialnvarchar80
40DRAD_PORDERAttributes for Links: Document to Production Order11STLNRBill of materialnvarchar80
TOPRecycling Administration Core Functions
41J_7LM06REA Article Master: Bills of Material11STLNRBill of materialnvarchar80
42J_7LV06REA Packaging Master Data: Bills of Material6STLNRBill of materialnvarchar80
TOPRemaining Beverage - Obsolete Objects
43/BEV1/RBVBAPSales Document: Item Data75STLNRBill of materialnvarchar80
TOPResourcen Management
44FRMLT20RMS-FRM: Connection Table BOM - Formula (LoM)3STLNRBill of materialnvarchar80
TOPRouting
45PLKOTask list - header62STLNRBill of materialnvarchar80
46PLMZAllocation of bill of material items to operations15STLNRBill of materialnvarchar80
47STPFStructure tree of the exploded BOM7STLNRBill of materialnvarchar80
TOPSales
48VBAPSales Document: Item Data75STLNRBill of materialnvarchar80
TOPSimulation
49VSAFKO_CNVersion: Order header data for PP orders35STLNRBill of materialnvarchar80
50VSRESB_CNVersion: Reservation/Dependent requirements61STLNRBill of materialnvarchar80
51VSVBAP_CNVersion: Sales document: Item data76STLNRBill of materialnvarchar80
TOPTransportation and Distribution
52OIGSMTD Material Allocated to a Shipment7STLNRBill of materialnvarchar80
TOPVariant Configuration
53CLRKRecursiveness Info on Objects in Classes for BOM7STLNRBill of materialnvarchar80
54CUPEExtension to BOM Item for Variants3STLNRBill of materialnvarchar80