topic Re: SAP SQL to SQL convert in Application Development and Automation Discussions

SAP SQL to SQL convert

former_member1209037 — Mon, 08 Aug 2022 16:14:27 GMT

Hi SAP Experts,

I need a piece of code which is written in the SAP should be converted to normal plan sql. The Query is almost 1000 lines big. I have solved almost major portion of it and required below code to be converted from SAP SQL to SQL normal.

Select MCH1.MANDT

FROM MCH1

WHERE

( MCH1.MANDT=@Prompt('Client','A','SAPR3 T000\Mandt',MONO,CONSTRAINED ,,{'050'} ) )

This need to be converted to SQL. Here the major problem is the "@prompt" I studied and it will be prompting the values before any user try to enter the values simply we are restricting the data. So I need help here on how we should be doing it

Re: SAP SQL to SQL convert

AlexGourdet — Mon, 08 Aug 2022 16:14:43 GMT

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get most out of your community membership, please consider include a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

Profile https://developers.sap.com/tutorials/community-profile.html
Tips for Questions: https://community.sap.com/resources/questions-and-answers
Consider to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

All the best,

-Alex