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.

SAP PP Transaction Codes
Commonly Used Tcodes in PP Module Part 1
Commonly Used Tcodes in PP Module Part 2
Commonly Used Tcodes in PP Module Part 3

Get help for your SAP PP Problems
Do you have a SAP PP Question?

SAP PP Books
SAP Production Planning, Certification and Interview Questions Reference Books

SAP PP Tips
SAP PP Tips and Production Planning/Control Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com