| 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. |