Hello,
can you please help me which tables used for creating the query.
Input: -
Plant
Plant-sp.matl status
Material
MDR Ticket number
MRP workflow status (from MDR)
Creation date (from MDR)
Layout selection option in the input screen
Output : -
Plant
Plant-sp.matl status
Creation date (from MDR)
MDR Ticket no
Material
Material description
CBE description
Basic Matl
Drawing number
Configurable tick (Basic data 2)
OA details - Ends (IN_OA_ENDS)
OA details - Main valve operation (IN_OA_OPER)
OA details - RT details (IN_OA_TEXT1)
OA details - Body specials
OA details - Bonnet specials (IN_OA_TEXT3)
Reference Material (From MDR)
Reference Material Material description
Reference Material CBE description
Reference Material Basic Matl
Reference Material Drawing number
Reference Material MRP Profile
Reference Material MRP controller
Reference Material MRP controller desc
Reference Material Maximum lot size
Reference Material Rounding value
Reference Material Prod. stor. location
Reference Material Default supply area
Reference Material Storage loc. for EP
Reference Material In-house production time
Reference Material Safety stock
Reference Material ConfigurableMaterial
Reference Material Prodn Supervisor
Reference Material Prodn Supervisor desc
Reference Material Procurement type
Reference Material Special proc typ
Reference Material MRP typ
Reference Material Lot size
