cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Query

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

  Please give which tables you want

Former Member
0 Kudos

I think I should have MARA table for material number and AUSP table for Characteristic value......

But as i said one Char Value is input and the other is output, so am not sure if my understanding is correct.

Regards

Karthik

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi,

Thanks a lot,

I think I have almost cracked it, I just found out that only AUSP table is sufficent, coz Object field is actually the material number, will try once again and let u know of the result.

Thanks a ton

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi,

  In SQVI t code click Change option and left said data field table join in that check check box which field you want check it. Help full you

Former Member
0 Kudos

I am still not getting the result, the report shows the same char twice, which is not what i need..... I want two different char to be picked.

How will the system know this? The system is picking the same char which I give as input at the start of the report.

JL23
Active Contributor
0 Kudos

Had you actually tried CL30N transaction?

Former Member
0 Kudos

Thanks , I did not know about this Trx.

This Trx has solved the issue, so I guess there is no need to write a query.

Thanks for the help, really appreciate it.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

  which report you enter your Input input data or give exact description data