topic Re: SQVI possible? in Application Development and Automation Discussions

SQVI possible?

tabraiz_khan — Wed, 09 Nov 2011 15:31:06 GMT

Hi All,

I am trying to find out a list of VBELN/POSNR entries which are available in VBAP but not available in a certain table.

Is this possible through SQVI? Any other way possible other than writing a report?

Check this example:

VBAP has:

VBELN POSNR

100 10

100 20

200 10

The second table, say, ZXYZ has:

VBELN POSNR

100 10

200 10

The final result should only return:

100 10

200 10

Any help would be appreciated.

Thanks,

Tabraiz

Re: SQVI possible?

Former Member — Wed, 09 Nov 2011 15:40:39 GMT

Shouldn't Joining ZXYZ (first) and VBAP solve your problem ?

Re: SQVI possible?

tabraiz_khan — Wed, 09 Nov 2011 15:52:35 GMT

This will only return the VBELN/POSNR entries present in both anyway.

Re: SQVI possible?

Former Member — Wed, 09 Nov 2011 15:55:59 GMT


This will only return the VBELN/POSNR entries present in both anyway.

Well, that's what your example shows.

Rob

Re: SQVI possible?

tabraiz_khan — Wed, 09 Nov 2011 16:06:22 GMT

Apologies, it should have been like this:

VBAP has:

VBELN POSNR

100 10

100 20

200 10

The second table, say, ZXYZ has:

VBELN POSNR

100 10

200 10

The final result should only return:

100 20

Re: SQVI possible?

Former Member — Wed, 09 Nov 2011 16:32:06 GMT

You want relative compliment of one table with the other, which is not possible with SQVI. You would need coding for this.

Re: SQVI possible?

Former Member — Wed, 09 Nov 2011 16:41:18 GMT

If you are just trying to find out the records - you can Create SQVI with VBAP (first) and ZXYZ Join on both VBENL and POSNR with "Left Outer Join" ( Right click on the link to change it ) and in the output Include VBELN POSNR from both the tables ..( VBELN, POSNR , VBELN, POSNR ) and in the output filter the VBELN ( of ZXYZ ) to be blank. You will get the records which are only in VBAP and not in ZXYZ.

Re: SQVI possible?

tabraiz_khan — Wed, 09 Nov 2011 20:33:28 GMT

Suman,

Thanks for the reply. I will give it a shot tomorrow. If this works, it saves me a loooot of work

Thanks again.

Tabraiz.

Re: SQVI possible?

tabraiz_khan — Thu, 10 Nov 2011 10:06:02 GMT

Just executed the query. Thanks mate, worked like a charm.