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.
@NatsolutionsBr8 жыл бұрын
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
@JamesBond-qg5gx4 ай бұрын
The material number is in all the tables, can we select from any table or it has to be from a specific table. Thanx
@martinjef8 жыл бұрын
Thank you so much. I am working in SAP MM. This is going to help me.. Save my time..
@rebecazepeda51628 жыл бұрын
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
@rodrigoglezsevilla94398 жыл бұрын
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?
@IwantanEOS56 жыл бұрын
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.
@Hawkfan19714 жыл бұрын
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.
@bluesky03003 жыл бұрын
If you are getting duplicate records this mean place more joins in each tables
@nilaykulkarni2797 жыл бұрын
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?
@vincenzopadulano49514 жыл бұрын
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
@alexanderblack83234 жыл бұрын
Great video, with a good explanation. Thanks.
@metaldeath26138 жыл бұрын
Hi Natan, Thanks for this nice tutorial. I didn't understand what is selection field. What does selection field do? Can you explain this?
@adityaacharya56015 жыл бұрын
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
@apoorvasharda51038 жыл бұрын
Hi Natan, Thank you for sharing this ..made it very easy for me to learn SAP Query using SQVI. Regards
@NatsolutionsBr8 жыл бұрын
So glad it helped you. Thank you very much for your visit Best Regards, Natan
@veve6868 жыл бұрын
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
@NatsolutionsBr8 жыл бұрын
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
@rrg59885 жыл бұрын
Please try linking EKPO and LIPS EBELP and VBELP
@esaonb293 жыл бұрын
How do you create a query using Mara table?
@jruizdes11 жыл бұрын
Excelent video, thanks, greetings from Perú.
@NatsolutionsBr10 жыл бұрын
Hello Javier, Thanks for your visit. Greetings from Brazil :) Cheers! Natan
@bluesky03003 жыл бұрын
Thank you for your support
@jeslaravishuda9 жыл бұрын
I really really thank you, you have solved a problem in my life. :)
@NatsolutionsBr9 жыл бұрын
Hi +Jeslara Vishuad01 Thank you for your visit and feed back. Glad to hear I have helped you somehow. Best Regards, Natan
@ynnad57910 жыл бұрын
Hi, create a query but the code of the material is repeated more than once. how can I fix?
@NatsolutionsBr10 жыл бұрын
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
@ynnad57910 жыл бұрын
hi, i will send you the screenshot. thanks Natan.
@veve6868 жыл бұрын
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
@NatsolutionsBr8 жыл бұрын
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
@aminechouaickh239510 жыл бұрын
Top! good presentation Natan, thank you
@NatsolutionsBr10 жыл бұрын
Hi Amine, Thank you for your visit! Best Regards, Natan
@aaa41636 жыл бұрын
Good explanation. Thank You
@NatsolutionsBr11 жыл бұрын
Hi Gundappa, Thank you very much ! Best Regards, Natan
@eslsoniavazquez9 жыл бұрын
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.
@raghavenderbandaru43333 жыл бұрын
Transaction is SQO1 or SQ01 , You said first one but it is not working. Better you Say SQ01
@gundappaa011 жыл бұрын
Nice Presentation
@davethamaster11 жыл бұрын
very good presentation!
@NatsolutionsBr10 жыл бұрын
Thank you Dave! Cheers! Natan
@riteshyadav-cd1wh6 жыл бұрын
how to write own Query in sap to create table......
@paulord6036 жыл бұрын
This is great. Thank you!
@NatsolutionsBr6 жыл бұрын
Hi Paul, Appreciate your visit and your Feedback. Regards, Natan
@bakalhau391610 жыл бұрын
Bom trabalho, obrigado.
@NatsolutionsBr10 жыл бұрын
Obrigado!
@karinvanvaalen47399 жыл бұрын
Great! Thank you.
@NatsolutionsBr9 жыл бұрын
Hi Karin van Vaalen Thank you for your visit! Regards, Natan