cancel
Showing results for 
Search instead for 
Did you mean: 

query with condities

peter_decoster
Explorer
0 Kudos

Hi

Iu2019ll try to make a query to get a material number with the price (condition). I use the tables KONP and A304, but I get no results.

In table KONP Iu2019ve the condition record number and the amount; in table A304 Iu2019ve the condition record number and the material number. So I use as selection the material number in the table A304 to get the amount from KONP. But the query said no results.

When i use trx SE16 for both tables i'll will get the results that i want.

Can anyone tell me what Iu2019m doing wrong or better can give me the solution?

Thanks,

Peter

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Peter,

Go to Transaction SQVI and select the table join while creating the query and by default the tables are getting getting connected with many fields... remove all by right click on relation and join both the table with one field only i.e. "KNUMH" (condition record number)

please try it and confirm.

It is working fine.

Thanks & Regards,

Rahul Verulkar

peter_decoster
Explorer
0 Kudos

Hi Rahul

Thank you for this answer.

In this way it works exactly as I expected. You've given me a good day!

Thanks,

Peter

peter_decoster
Explorer
0 Kudos

Hi Yadav

Thanks for the quick response.

I was under the impression that the numbers were the same condition. but indeed I see now that it is not.

Do you may have suggestions for other combinations?

Peter

jpfriends079
Active Contributor
0 Kudos

Hello

For your requirement.

You can use TCode V\LD

Choose 15-Material Price

OR

Use TCode S_P6B_12000142

With your Condition type & Table 304 as parameter.

Thanks & Regards

JP

Lakshmipathi
Active Contributor
0 Kudos

You can try in SQVI by table joining A304 table with KONV

thanks

G. Lakshmipathi

Former Member
0 Kudos

Hello Peter,

The condition number in KONP and A304 are different. KONP consists of document condition number while A304 consists of condition record's condition number.

By chance both numbers are same in your case and your find match in SE16.

Try some other combination in your query.