SQVI with join tables

[Former Member]

Dear PP Gurus,

Please suggest how to create query using more than two tables, i am trying to create for PIR display, i have used tables PBIM, PBED, and PBHI, but i am not getting output, system is giving error "no data was selected", so please guide how to link this tables, or what is exact procedure to see data from more than one table.

thanks in advance

Kailash T.

[Former Member]

Closing the thread.

Thanks for valuable inputs.

[former_member184655]

Dear Kailash,

What's your exact requirement?

What data do u need?

Regards

Mangalraj.S

[Former Member]

Dear Mangalraj S.,

I want output of requirements with columns, as,

Material / Plant / Requirement type / version / Requirements periodwise(week , month).say M1 / M2 / M3

Example:

600390 / P011 / BSF / 00 / 1000 / 2000 / 2500

600391 / P011 / VSF / 00 / 500 / 1500 / 3000.

and so on..................

Please guide

[Former Member]

HI..

plws follow the following steps ..

First create a query name in SQVI

then select it as table join and then enter...

give the table names which are reqd then

go back and then select the fields which are redqd for u for tht table..

Regrds

Sravanthi

[Former Member]

Dear,

I am unable to locate field for qty. monthwise - eg.

As i expalined, i have entered requirement as

Material / Plant / M1 /M2 /M3

600390 / P011 / 1000 / 2000 / 3000.

So in the above three table i am not getting this three fields.

Please guide.

[Former Member]

Hi,

Make join as shown below.

pbim_{bdzei = pbed}bdzei

pbed_{bdzei = pbhi}bdzei

Regards,

Vishal

[Former Member]

Thanks for response.

YES, it is working, now the issue is that it is displaying same line for many times, that is material, plant, requirement type everything is same, WHY? Please guide, also any solution, please provide.

Regards,

Kailash T.

[Former Member]

HI

even through the the material, plant, requirement type everything is same. IF THE MATERIAL HAVING MORE THAN ONE REQUIREMENT.

SAY SUPPOSE THE MATERIAL -X , PLANT XXXX, REMT TYPE - VSE

if the planning period is month

05month - 1000

06 month - 2000

so system show material, plant, requirement type everything two times. because the entry is two times . but if you include the period as diaplay field , you can find the diff periods.