topic Re: No values in query in Application Development and Automation Discussions

No values in query

Former Member — Thu, 01 Feb 2007 10:15:56 GMT

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

Re: No values in query

Former Member — Thu, 01 Feb 2007 10:17:57 GMT

Hi Pawel,

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

IF not just check in se16 .

Regards,

Ravi

Re: No values in query

Former Member — Thu, 01 Feb 2007 10:45:09 GMT

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

Re: No values in query

Former Member — Thu, 01 Feb 2007 10:50:34 GMT

Hi,

check the corresponding values in other tables also.

they may not be there

Regards

Shiva

Re: No values in query

Former Member — Tue, 06 Feb 2007 10:29:34 GMT

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

Re: No values in query

Former Member — Tue, 06 Feb 2007 10:29:53 GMT

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