No Data in SQVI

[Former Member]

Hello,

Our requiremnt is with referance to Class type,Plant and sales organisation we want List of the material.

in standard we dont have any table where we can see all together so we used SQVI.

where we used MARC,KLAH,CABN but

at the time of execution we didnt get any data.

can anyone please tell which table should we use? and what join condition should we use?

All help will be reward.

Thank you

Regards,

Tina

[Former Member]

SQVI may not work.

Use Infoset and query or ABAP.

Find class type from INOB where Object = material number then link to KLAH.

Let me know if it works for you.

[Former Member]

HI Alan,

thanks for the reply

but it didnt worked ifact INOB table didnt executing.

reagards,

Tina

[Former Member]

Maybe you have to verify the links in SE16N first. Whether it is possible to link base on the keys and what you have done in SQVI.

if possible pls share screen of your SQVI. So I could help identify the link problems.