Skip to Content
Former Member
Sep 23, 2009 at 03:50 PM

SQ01 Query issue - Table join


Hi Gurus,

I need to make a change in already created query generating a report concerning Billing documents. Tables which are being used in there are VBRK, VBRP, VBPA & KNA1.

Now, I would like to add Purchase Order number as field in Field Group in related Infoset in SQ02.

The issue is when I include table VBKD field VBKD-BKSTD to fetch PO number and join it in infoset, it does get joined but the actual query does not work in SQ00 or SQ01 after getting this change done in infoset.

Can you please suggest if I am doing something wrong in joining the tables or should I try joining some other table to get this requirement??

Kindly help and thanks in advance for your suggestions!!