Knowledge Management

Question:
Is there a standard report available in the system that would aid the management in identifying stock which has exceeded min/max levels.
Thanks a Bunch !
Pappu
Answer:
Hi,
You can set up the simple query joining both Tables MARD and MARC.
Cheers,
HT
Answer:
Hi HT;
How to join two tables...Pls let me know complete process...
Thanks;
Guest
Answer:
First, create a Functional area using TCODE SQ02. There you must specify the tables in use, and perform the join. Then select the fields that you want in the report/query.
Secondly, create an ABAB query in SQ01 on functional area that you created in SQ02.
Regards
Christo Vermeulen
_________________
Why did the chicken cross the road?
...there is absolutely no proof that it was a chicken to begin with!
Answer:
Hi cvermeu2
You can also use "QUICKVIEWER" SQVI to generate the report using the tables mentioned warlier.
This method won't require the creation of Functional area.
Thanx
Prasad
Answer:
I appreciate your inputs on this...to all of you.
Pappu
Answer:
Hello,
I saw prasadp's reply re: SQVI. Is there a way to view the underlying SQL code for the joins that you do using the SQVI graphical tool??
My table joins produced some incorrect results (wrong vendor name LFA1 attached to vendor number pulled from EKKO). I'd like to look at the code to see where I went wrong. I'm thinking there should be a way like when you use SE49 to display code behind a t-code, program, etc.
Thanks for any assistance!!
Answer:
Hi SAPoilgal
Follow the steps given below to see the code.
When you execute the Quickview on selection parameter screen:
System - Status
Window will pop-up showing the program name & lot more other details.
Double click on program name & system will show you the code.
I hope this helps you
Thanx
Prasad