| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SMERP/STG_MM001 | Data staging - Material master plant view complex table | 301 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPActual CostingMaterial Ledger |
2 | CKMLMV013 | Assignment table: Process for production order | 18 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
3 | FCML_ALT | Alternatives | 9 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
4 | FCML_PROC | Business Processes | 11 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPBasic Data |
5 | MKAL | Production Versions of Material | 7 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPBasic Functions |
6 | MMPREF_PRO_02 | Log table - Main component - Information | 10 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
7 | MMPREK_PRO_02 | Log table - Main component - Information | 13 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
8 | MMPREW_PRO_02 | Preference CPG: Log main component - Information | 12 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
9 | T604I | Input Table for Collective Calculation for Goods Origin | 4 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
10 | T604_PREF_PARAM | Preference: Preference determination parameters | 8 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPBills of Material |
11 | CLST | Link class - BOM | 5 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
12 | CSUSR_DATA | User-defined data for order browser | 12 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
13 | DOST | Document to BOM Link | 7 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
14 | EQST | Equipment to BOM Link | 6 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
15 | KDST | Sales Order to BOM Link | 8 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
16 | MAST | Material to BOM Link | 6 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
17 | PRST | Project - BOM link | 7 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
18 | STAS | BOMs - Item Selection | 4 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
19 | STKO | BOM Header | 4 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
20 | STST | Standard BOM Link | 6 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
21 | T415A | Alternative BOM Determination | 7 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
22 | T415B | Alternative Determination by Unit of Measure | 5 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
23 | TPST | Link Between Functional Location and BOM | 6 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
24 | MMARC | Plant Data for Material | 105 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
25 | PDS_COMP | Component Data for PDS | 9 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
26 | PDS_KEY | Key Table for PDS Data from PDS Maintenance | 9 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPDistribution Requirements Planning |
27 | PLPLAN_PARAM | BOM-dependent planning parameter | 11 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPForeign Trade |
28 | /SAPSLL/TBTCAR3 | GTS: BOM Transfer: Alternative BOM - Country | 5 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
29 | /SAPSLL/TBTGAR3 | GTS: BOM Transfer: Alternative BOM - Global | 4 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
30 | /SAPSLL/TBTPAR3 | GTS: BOM Transfer: Alternative BOM - Plant | 6 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPGlobal Trade Services |
31 | /SAPSLL/BOMHD | SLL: BOM - Header | 7 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
32 | /SAPSLL/PRFPMR | SLL: Preference: Log: Products: Result of BOM Calculation | 5 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
33 | /SAPSLL/RXPMR | Re-Export: Log: BOPs of Product | 6 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPIntegrated Product and Process Engineering |
34 | CMIG_MAPPING | Mapping Table (Classic PP and iPPE Objekt Key) | 5 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPInventory Management |
35 | RESB | Reservation/dependent requirements | 164 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPLO Integration |
36 | CURTO_FOCUS_CHG | Change Pointer for Order/WBS BOM for PDS Transfer | 9 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
37 | CURTO_PDS_CHG | Change Pointer for Production Data Structure | 7 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPLocalization |
38 | J_3RFGTDMATBOM | BoM for Customs Decl. Tracking | 4 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPMaster Data |
39 | MDSM | Simulative dependent requirements | 97 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
40 | SAFK | Run Schedule Master Data | 31 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPMaterial Master |
41 | MARC | Plant Data for Material | 105 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
42 | MARC_TMP | File for Incorrect Data in Direct Input | 108 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
43 | MVRC | Cross-version fields for MARC | 105 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPMedia Product Sales and Distribution |
44 | JVSDSPLIT | IS-M: Media Issue Mix | 10 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
45 | JVSDSPLITPLAN | IS-M: Issue Split (Planned) | 10 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
46 | JVSDSPLITSUB | IS-M: Issue Split for Lower Level Issues | 11 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPProduct Data Management |
47 | CONV_MATRICES | Matrixes that must be checked into BOMs | 8 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
48 | PDN_MAP_HEADER | Product Designer: Mapping Table for Headers | 10 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
49 | PDN_MAP_ITEM | Product Designer: Mapping Table for Items | 7 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPProduct Safety |
50 | ESTWL | EHS: BOMBOS - Worklist Table | 20 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPProduct Structure Browser |
51 | USROBJECTS | Table of Previous Initial Object in Structure Overview | 18 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPProduction Orders |
52 | AFKO | Order Header Data PP Orders | 39 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPRecycling Administration Core Functions |
53 | J_7LM06 | REA Article Master: Bills of Material | 12 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
54 | J_7LV06 | REA Packaging Master Data: Bills of Material | 7 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPResourcen Management |
55 | FRMLT20 | RMS-FRM: Connection Table BOM - Formula (LoM) | 4 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
56 | MRTRST_HDR | RMS-MRTRS : MR Transformation Header | 18 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
57 | RMXTT_TRIAL_MR | Trial: Assigned Master Recipes | 8 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPRouting |
58 | PLKO | Task list - header | 63 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
59 | PLMZ | Allocation of bill of material items to operations | 16 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
60 | STPF | Structure tree of the exploded BOM | 8 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPSCM Basis |
61 | CIF_IMMBOM | IMod Reference Table for Material BOM's | 5 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
62 | CIF_IMPPM | Int. Model Reference Table for Production Process Model | 13 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
63 | CIF_MD_CHANGES | Changes to BOM, Routing and Production Version | 10 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPService Station Retailing |
64 | OIRAMATHANDGRP | Material handling group material assignment (IS-Oil SSR) | 13 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
TOPSimulation |
65 | VSAFKO_CN | Version: Order header data for PP orders | 40 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |
66 | VSRESB_CN | Version: Reservation/Dependent requirements | 165 | STLAL | Alternative BOM | nvarchar | 2 | 0 | | |