Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP QUERY TO DESIGN

sawamah
Discoverer
0 Kudos

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

  • SAP Managed Tags:
0 REPLIES 0