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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAP Query

sawamah
Discoverer

‎2023 Oct 09 10:37 AM

0 Kudos
200
  • SAP Managed Tags:
  • SQL

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

1 REPLY 1

AnnePetteroe
Community Manager
Community Manager

‎2023 Oct 09 10:38 AM

0 Kudos
122
  • SAP Managed Tags:
  • SQL

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