SAP Query

sawamah — Mon, 09 Oct 2023 09:37:58 GMT

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

Re: SAP Query

AnnePetteroe — Mon, 09 Oct 2023 09:38:15 GMT

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

topic Re: SAP Query in Application Development and Automation Discussions

SAP Query

Re: SAP Query