on 11-17-2012 12:26 PM
Hi Experts,
I need some help with SAP Query.
Clients requirement is as follows:
One time report that shows all materials satisfying two characteristic description. In the report one of the characteristics is the input (eg. channel) and the other characteristic description (eg. owner) and material number is the output.
In SAP there is no standard report to pull this data, so I would have to write a query to generate the report.
I am not sure which two table to join and how to join. Can you please help? Its quite urgent, so quick reply will be appreciated.
<removed by moderator>
Best Regards,
Karthik
Message was edited by: Jürgen L
Hi,
Please give which tables you want
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In SQVI t code enter quick view (anything) and click create option.
enter Title (anything) & 1 data source seleck table join click enter
click Insert table(shift+F1) enter Table(MARA) press enter & agine insert table(shift+F1) enter table (AUSP)
prease enter.
click back(F3) in list fields select (what you want in out put that descreption select click insert field(arrow))
click selection fields tab in that (what you give in input data that descreption select click insert field (arrow))
Click Excuet(F8)
Help full U.
Hi,
I am able to generate report.
I used only AUSP table, coz it has Material number too.....
In list fields and Selection fields tab, in both these places, I have given fields "Char Name" and "Char Value"
When i run report, input field i am able to give char value and it selects only those, but in output field also i am able to see the same char, but i need different char name and char value.
How to get it?
Let me be more clear: Input I am giving Char name as State and Char Value as say Florida, so I get report for all Materials for Florida, But in the report I need one more char name , for eg. Char Name as Material Type and I need all Char Value for the new Char for the Material and State FL.
How do i do this?
Thanks
Karthik
Hi,
which report you enter your Input input data or give exact description data
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.