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

66 columns | Print definition?ERP 6.0  | STLAL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table301STLALAlternative BOMnvarchar20
TOPActual CostingMaterial Ledger
2CKMLMV013Assignment table: Process for production order18STLALAlternative BOMnvarchar20
3FCML_ALTAlternatives9STLALAlternative BOMnvarchar20
4FCML_PROCBusiness Processes11STLALAlternative BOMnvarchar20
TOPBasic Data
5MKALProduction Versions of Material7STLALAlternative BOMnvarchar20
TOPBasic Functions
6MMPREF_PRO_02Log table - Main component - Information10STLALAlternative BOMnvarchar20
7MMPREK_PRO_02Log table - Main component - Information13STLALAlternative BOMnvarchar20
8MMPREW_PRO_02Preference CPG: Log main component - Information12STLALAlternative BOMnvarchar20
9T604IInput Table for Collective Calculation for Goods Origin4STLALAlternative BOMnvarchar20
10T604_PREF_PARAMPreference: Preference determination parameters8STLALAlternative BOMnvarchar20
TOPBills of Material
11CLSTLink class - BOM5STLALAlternative BOMnvarchar20
12CSUSR_DATAUser-defined data for order browser12STLALAlternative BOMnvarchar20
13DOSTDocument to BOM Link7STLALAlternative BOMnvarchar20
14EQSTEquipment to BOM Link6STLALAlternative BOMnvarchar20
15KDSTSales Order to BOM Link8STLALAlternative BOMnvarchar20
16MASTMaterial to BOM Link6STLALAlternative BOMnvarchar20
17PRSTProject - BOM link7STLALAlternative BOMnvarchar20
18STASBOMs - Item Selection4STLALAlternative BOMnvarchar20
19STKOBOM Header4STLALAlternative BOMnvarchar20
20STSTStandard BOM Link6STLALAlternative BOMnvarchar20
21T415AAlternative BOM Determination7STLALAlternative BOMnvarchar20
22T415BAlternative Determination by Unit of Measure5STLALAlternative BOMnvarchar20
23TPSTLink Between Functional Location and BOM6STLALAlternative BOMnvarchar20
TOPCross-Application Components
24MMARCPlant Data for Material105STLALAlternative BOMnvarchar20
25PDS_COMPComponent Data for PDS9STLALAlternative BOMnvarchar20
26PDS_KEYKey Table for PDS Data from PDS Maintenance9STLALAlternative BOMnvarchar20
TOPDistribution Requirements Planning
27PLPLAN_PARAMBOM-dependent planning parameter11STLALAlternative BOMnvarchar20
TOPForeign Trade
28/SAPSLL/TBTCAR3GTS: BOM Transfer: Alternative BOM - Country5STLALAlternative BOMnvarchar20
29/SAPSLL/TBTGAR3GTS: BOM Transfer: Alternative BOM - Global4STLALAlternative BOMnvarchar20
30/SAPSLL/TBTPAR3GTS: BOM Transfer: Alternative BOM - Plant6STLALAlternative BOMnvarchar20
TOPGlobal Trade Services
31/SAPSLL/BOMHDSLL: BOM - Header7STLALAlternative BOMnvarchar20
32/SAPSLL/PRFPMRSLL: Preference: Log: Products: Result of BOM Calculation5STLALAlternative BOMnvarchar20
33/SAPSLL/RXPMRRe-Export: Log: BOPs of Product6STLALAlternative BOMnvarchar20
TOPIntegrated Product and Process Engineering
34CMIG_MAPPINGMapping Table (Classic PP and iPPE Objekt Key)5STLALAlternative BOMnvarchar20
TOPInventory Management
35RESBReservation/dependent requirements164STLALAlternative BOMnvarchar20
TOPLO Integration
36CURTO_FOCUS_CHGChange Pointer for Order/WBS BOM for PDS Transfer9STLALAlternative BOMnvarchar20
37CURTO_PDS_CHGChange Pointer for Production Data Structure7STLALAlternative BOMnvarchar20
TOPLocalization
38J_3RFGTDMATBOMBoM for Customs Decl. Tracking4STLALAlternative BOMnvarchar20
TOPMaster Data
39MDSMSimulative dependent requirements97STLALAlternative BOMnvarchar20
40SAFKRun Schedule Master Data31STLALAlternative BOMnvarchar20
TOPMaterial Master
41MARCPlant Data for Material105STLALAlternative BOMnvarchar20
42MARC_TMPFile for Incorrect Data in Direct Input108STLALAlternative BOMnvarchar20
43MVRCCross-version fields for MARC105STLALAlternative BOMnvarchar20
TOPMedia Product Sales and Distribution
44JVSDSPLITIS-M: Media Issue Mix10STLALAlternative BOMnvarchar20
45JVSDSPLITPLANIS-M: Issue Split (Planned)10STLALAlternative BOMnvarchar20
46JVSDSPLITSUBIS-M: Issue Split for Lower Level Issues11STLALAlternative BOMnvarchar20
TOPProduct Data Management
47CONV_MATRICESMatrixes that must be checked into BOMs8STLALAlternative BOMnvarchar20
48PDN_MAP_HEADERProduct Designer: Mapping Table for Headers10STLALAlternative BOMnvarchar20
49PDN_MAP_ITEMProduct Designer: Mapping Table for Items7STLALAlternative BOMnvarchar20
TOPProduct Safety
50ESTWLEHS: BOMBOS - Worklist Table20STLALAlternative BOMnvarchar20
TOPProduct Structure Browser
51USROBJECTSTable of Previous Initial Object in Structure Overview18STLALAlternative BOMnvarchar20
TOPProduction Orders
52AFKOOrder Header Data PP Orders39STLALAlternative BOMnvarchar20
TOPRecycling Administration Core Functions
53J_7LM06REA Article Master: Bills of Material12STLALAlternative BOMnvarchar20
54J_7LV06REA Packaging Master Data: Bills of Material7STLALAlternative BOMnvarchar20
TOPResourcen Management
55FRMLT20RMS-FRM: Connection Table BOM - Formula (LoM)4STLALAlternative BOMnvarchar20
56MRTRST_HDRRMS-MRTRS : MR Transformation Header18STLALAlternative BOMnvarchar20
57RMXTT_TRIAL_MRTrial: Assigned Master Recipes8STLALAlternative BOMnvarchar20
TOPRouting
58PLKOTask list - header63STLALAlternative BOMnvarchar20
59PLMZAllocation of bill of material items to operations16STLALAlternative BOMnvarchar20
60STPFStructure tree of the exploded BOM8STLALAlternative BOMnvarchar20
TOPSCM Basis
61CIF_IMMBOMIMod Reference Table for Material BOM's5STLALAlternative BOMnvarchar20
62CIF_IMPPMInt. Model Reference Table for Production Process Model13STLALAlternative BOMnvarchar20
63CIF_MD_CHANGESChanges to BOM, Routing and Production Version10STLALAlternative BOMnvarchar20
TOPService Station Retailing
64OIRAMATHANDGRPMaterial handling group material assignment (IS-Oil SSR)13STLALAlternative BOMnvarchar20
TOPSimulation
65VSAFKO_CNVersion: Order header data for PP orders40STLALAlternative BOMnvarchar20
66VSRESB_CNVersion: Reservation/Dependent requirements165STLALAlternative BOMnvarchar20