SQVI - Number of Records as output is less than that available in Std. Tables

[former_member590287]

Hi Gurus,

Requirement is to pass STUFE=5 > BUKR=XXXX in PRPS and get superior WBS at STUFE=4 in PRHI and again get WBS at STUFE=4 > BUKR = XXXX.

I am using SQVI to join std. tables PRPS, PRHI and ZPRPS (Alias of PRPS).

The output of the same is giving 610 records, while in std PRPS table, the record is 4510 something.

Also, upon execution I am getting an information as :

The field Level in Project Hierarchy cannot be totalled because of field overflow

Message No. 0K051

Can anyone help on how can I manage the output records.

Regards,

AKASH.

[MTerence]

Hi Akash,

Did you use the SQVI logic manually in SE11 or SE16 to check, whether it gets the output.

Regards

Terence

[former_member590287]

Hi Maria,

We have already checked. By SE16 only I came across the total record as 4510, while in SQVI, we are only getting 610 records.

Regards,

AKASH.

[MTerence]

Hi,

Can you share the SQVI table links here ?

Try to use PRPS table rather than ZPRPS and see how it goes. It could be some table links issue. Also you can pass the 610 records in PRPS to understand the unique, so remaining records are missed.

Regards

Terence