No values in query

[Former Member]

Hello,

I have following problem: I created an infoset in SQ02, with VBUK as base table for join with VBAP (inner join) and LIPS (left outer join).

When I add column VBUK-KOSTK in SQ02 and then in SQ01, I always get blank value in my query in the output in that column.

This is problematic because I am creating a fulfillment rate report and information about overall picking status is essential.

Is there anything tricky that I did possibly wrong?

Thank You Gurus.

Pawel

[Former Member]

Hello,

I have following problem: I created an infoset in SQ02, with VBUK as base table for join with VBAP (inner join) and LIPS (left outer join).

When I add column VBUK-KOSTK in SQ02 and then in SQ01, I always get blank value in my query in the output in that column.

This is problematic because I am creating a fulfillment rate report and information about overall picking status is essential.

Is there anything tricky that I did possibly wrong?

Thank You Gurus.

Pawel

[Former Member]

Hi Pawel,

Are you sure the Table VBUK has a value for that delivery?

IF not just check in se16 .

Regards,

Ravi

[Former Member]

Hello,

thanks, I checked se16 and prepared a list of delivery documents which represent all KOSTK statuses (' ', 'A', 'B', 'C' ) and I was checking with this prepared delivery numbers.

Unfortunately for all , there is always ' '.

Pawel

[Former Member]

Hi,

check the corresponding values in other tables also.

they may not be there

Regards

Shiva

[Former Member]

Hello,

thank You for hints.

Finally it ocurred that the VBUK table VBELN field can contain both LIPS refference and VBAP refference. I changed the table join and it works now.

Bye,

Pawel

[Former Member]

Thank You. Problem solved. VBUK may be refferenced to both VBAP and LIPS.