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.
