SAP MM - How to Create a Query

In this Video, you will be able to learn quickly how to create a Query.
Use this powerful SAP Standard tool in order to generate quick reports.

[TheJeffcurran]

In the video you mention that some IT departments forbid user access to SQVI or SQ01 because queries can impact system performance. This mentality is the single most significant reason why Enterprise Systems do not provide the value proposed. The purpose of an ERP system is to process and collect data. This data is the source of information that can propel a business forward. Restricting access to data prevents continuous improvement and puts the information in the hands of a select few who guard the data to advance their own job security agendas.

I speak from experience. As a non-IT, operations department super user, I was able to leverage business intelligence tools like SQVI to extract data that provided my department managers with business intelligence that propelled my department far ahead of other departments that did not allow access to information.

As you can see from my comment, I take serious exception to this mentality that IT managers would forbid access to these fundamental tools.

[martinjef]

Thank you so much. I am working in SAP MM. This is going to help me.. Save my time..

[JamesBond-qggx]

The material number is in all the tables, can we select from any table or it has to be from a specific table.
Thanx

[alexanderblack]

Great video, with a good explanation.
Thanks.

[rebecazepeda]

Thank you very much, understand how careful we should be when to chose them . Could you do one for unique raw materials, this is just when we know a certain finished good will be discontinue and we want to analyzed the impact of potential obsolescence

[apoorvasharda]

Hi Natan, Thank you for sharing this ..made it very easy for me to learn SAP Query using SQVI. Regards

[rodrigoglezsevilla]

Hi Natan Im including those tables, EKKO, EKPO, EBAN, EKES AND EKBE, and I already select the fields that I want, BUT when I run the report there is a message: "No data was selected" but I already select and include information, do you know why?

[jruizdes]

Excelent video, thanks, greetings from Perú.

[IwantanEOS]

Very good explanation but at the end you showed that the record with no history would not come out in the results.  If you had clicked on the join lines you could have selected to change the join to the history table to a left outer join, and then the record without the history lines will have shown up.

[aminechouaickh]

Top! good presentation Natan, thank you

[nilaykulkarni]

Can we create tcode of the report we create and give it to end users to execute. If not whats the best way so that end user can access the reports?

[Hawkfan]

Wonderful job! Would it be possible for you to create a video on how to create a Material Master Sqvi? I've created one using these tables (MARA, MAKT, MARC, MARD and MBEW). I left the joins exactly how they connected when I put the tables into the query. My problem is I get a lot of duplicate lines that come back and I don't know how to stop this. Any help would be greatly appreciated.

[jeslaravishuda]

I really really thank you, you have solved a problem in my life. :)

[vincenzopadulano]

Hello sir, good explaination, but actually the error the you faced 'condition join not legal' is what happen to me as well but is actually what i need. I have to insert in INOB-OBJEK the material and then take the INOB-CUOBJ and put into KSSK-OBJEK. That's the query that i need. How can i link the INOB-CUOBJ with KSSK-OBJEK?

Thank you

[rrg]

Please try linking EKPO and LIPS EBELP and VBELP

[NatsolutionsBr]

Hi Gundappa,
Thank you very much !
Best Regards,
Natan

[veve]

Boa tarde estou aprendendo agora SAP achei seu video muito bom; queria saber se eu quisesse mudar a cor da minha coluna como faria. Muito obrigada

[metaldeath]

Hi Natan,
Thanks for this nice tutorial.
I didn't understand what is selection field. What does selection field do? Can you explain this?

[esaonb]

How do you create a query using Mara table?

[veve]

Obrigada eu, mas já vi se quero fazer alguma costumizacao no meu relatório tenho que exportar para o Excel e lá posso fazer as modificações necessárias, mais uma vez obrigada