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.
Hi +Jeff Curran Thanks for your visit , comments and contribution. Very good point! I would say every coin has two faces. To provide SQVI access to every single user means also lack of control, I mean, if you use a Z Report or a Standard Report, you can control information / data based on Roles and Profiles. When you open SQVI, you are giving all Company information to anyone who knows the tables check and download this data. Let us say, for security reasons, company does not want to share total amount of sales... this is just an example. I believe, yes companies can provide access to it, but it would be necessary to choose the users with responsability. Thanks again! Regards, Natan
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.
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
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?
Boa noite, tudo bem ? Infelizmente, a opção de Relatórios via SQVI não permite que você altere as cores das colunas, pois é bem engessado. Você irá conseguir alterar as cores das colunas ou mesmo das linhas se você criar um programa ABAP para o seu relatório. Sei que não ajudei muito, mesmo assim agradeço sua visita. Abs, Natan
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
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.
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
Olá, Sim, migrar para o Excel e fazer os ajustes de acordo com sua necessidade também funciona bem. Eu estava achando que você queria fazer isso diretamente no SAP. Obrigado, Natan
If you were to give the explanation in Portuguese only the final result would be more effective. Sometimes it was a bit difficult to follow your train of thought; however, technically it was good.
Hi, Can you please send me a screenshot from your Tables Join ? Send it to natan@natsolutions.com.br Also, you can try to change the left table. Example: Place MARA table as the very first table in the left, then you can place the other ones, like: MAKT (if you have two languages, system will duplicate material, so in the selection screen, you must select which language you desire to see the report), MARC (the same for Plants - define in the selection screen for which palnts you want to see the report), and MBEW. Hope it helps. Thanks, Natan
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.
Hi +Jeff Curran
Thanks for your visit , comments and contribution.
Very good point!
I would say every coin has two faces. To provide SQVI access to every single user means also lack of control, I mean, if you use a Z Report or a Standard Report, you can control information / data based on Roles and Profiles.
When you open SQVI, you are giving all Company information to anyone who knows the tables check and download this data.
Let us say, for security reasons, company does not want to share total amount of sales... this is just an example.
I believe, yes companies can provide access to it, but it would be necessary to choose the users with responsability.
Thanks again!
Regards,
Natan
Thank you so much. I am working in SAP MM. This is going to help me.. Save my time..
Thank you for your support
Great video, with a good explanation.
Thanks.
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.
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
The material number is in all the tables, can we select from any table or it has to be from a specific table.
Thanx
Hi Natan, Thank you for sharing this ..made it very easy for me to learn SAP Query using SQVI. Regards
So glad it helped you.
Thank you very much for your visit
Best Regards,
Natan
Please try linking EKPO and LIPS EBELP and VBELP
Excelent video, thanks, greetings from Perú.
Hello Javier,
Thanks for your visit.
Greetings from Brazil
:)
Cheers!
Natan
Top! good presentation Natan, thank you
Hi Amine,
Thank you for your visit!
Best Regards,
Natan
Hi Gundappa,
Thank you very much !
Best Regards,
Natan
I really really thank you, you have solved a problem in my life. :)
Hi +Jeslara Vishuad01
Thank you for your visit and feed back. Glad to hear I have helped you somehow.
Best Regards,
Natan
Good explanation. Thank You
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?
very good presentation!
Thank you Dave!
Cheers!
Natan
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?
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
Boa noite, tudo bem ?
Infelizmente, a opção de Relatórios via SQVI não permite que você altere as cores das colunas, pois é bem engessado. Você irá conseguir alterar as cores das colunas ou mesmo das linhas se você criar um programa ABAP para o seu relatório.
Sei que não ajudei muito, mesmo assim agradeço sua visita.
Abs,
Natan
How do you create a query using Mara table?
This is great. Thank you!
Hi Paul,
Appreciate your visit and your Feedback.
Regards,
Natan
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
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.
If you are getting duplicate records this mean place more joins in each tables
Nice Presentation
Hi Natan,
Thanks for this nice tutorial.
I didn't understand what is selection field. What does selection field do? Can you explain this?
On the basis of it, it defines what output u will see in ur table
It basically are parameters based on which other parameters can be seen
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
Olá,
Sim, migrar para o Excel e fazer os ajustes de acordo com sua necessidade também funciona bem. Eu estava achando que você queria fazer isso diretamente no SAP.
Obrigado,
Natan
Bom trabalho, obrigado.
Obrigado!
Great! Thank you.
Hi Karin van Vaalen
Thank you for your visit!
Regards,
Natan
Transaction is SQO1 or SQ01 , You said first one but it is not working. Better you Say SQ01
how to write own Query in sap to create table......
If you were to give the explanation in Portuguese only the final result would be more effective. Sometimes it was a bit difficult to follow your train of thought; however, technically it was good.
Bom vídeo,
Parabéns!
Olá Cássio Belo Clemente de Souza
Muito obrigado!
Hi, create a query but the code of the material is repeated more than once. how can I fix?
Hi,
Can you please send me a screenshot from your Tables Join ?
Send it to natan@natsolutions.com.br
Also, you can try to change the left table.
Example: Place MARA table as the very first table in the left, then you can place the other ones, like: MAKT (if you have two languages, system will duplicate material, so in the selection screen, you must select which language you desire to see the report), MARC (the same for Plants - define in the selection screen for which palnts you want to see the report), and MBEW.
Hope it helps.
Thanks,
Natan
hi, i will send you the screenshot.
thanks Natan.
Muy buen video (y)
+José Odar
Muchas Gracias!!
:)