2023 Oct 09 10:37 AM
Hello i want to make SAP Query, can please let me know which tables i need to get my required output.
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
2023 Oct 09 10:38 AM
Hello Mahesh,
Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.
Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will also help you when preparing questions for the community.
Should you wish, you can revise your question by selecting Actions, then Edit.
By adding a picture to your profile you encourage your readers to respond.
Kind regards,
Anne