#1
|
|||
|
|||
![]()
MASTER DATA
Engineering Change Management AENR Customer and priority AEOI Revision Numbers Work Center CRHD Workcenter Header Data CRCA Workcenter Capacity Allocation CRCO Workcenter Cost Center Assignment CRHH Hierarchy Header CRHS Hierarchy Structure CRTX Workcenter Text KAKO Capacity Header KAZY Intervals of Capacity Routing PLPO Routing Operation Details PLKO Routing Header Details MAPL Routing Link to Material PLAB Relationships - Standard Network PLAS Task List - Selection of Operations PLMZ Component Allocation PLPH CAPP Sub-operations PLFH PRT Allocation PLWP Maintenance Package Allocation PLMK Inspection Characteristics Bill of Material STPO BOM Item Details STPU BOM Sub Items (designators) STKO BOM Header Details MAST BOM Group to Material STZU BOM History Records STAS BOM Item Selection STPF BOM Explosion Structure Line Design LDLH Line Hierarchy Header LDLP Line Hierarchy Items LDLT Line Hierarchy Takt Times LDLBC Takts/No. Individual Capacities per Line LDLBH Line Balance Header LDLBP Line Balance Items LDLBT Line Hierarchy Entry and Exit Takts PRT's CRFH PRT Master Data CRVD_A Link of PRT to Document CRVD_B Link of Document to PRT CRVE_A Assignment of PRT data to Equipment CRVE_B Assignment of equipment to PRT data CRVM_A Link of PRT data to Material CRVM_B Link of Material to PRT data CRVS_A Link of PRT Internal number to PRT External number CRVS_B Link of PRT External number to PRT Internal number How to create a query that is very similar to CA03? What tables contain those information and what are the relationships? See below routing table relationships: Table MAPL, pass input material number, plant, routing group counter. Table PLKO, field PLNNR, PLNAL eq mapl-plnnr, mapl-plnal Table PLAS, field PLNNR, PLNAL eq mapl-plnnr, mapl-plnal and LOEKZ ne ' ', take field PLNKN Table PLPO, field PLNNR, PLNKN eq plas-plnnr, plas-plnkn You will get correct result same as CA03 list. |