Skip to Content
Former Member
Oct 04, 2016 at 12:52 PM

SQ01 Query, Link CDHDR and VBAK for output.


Hi Gurus,

I have a requirement where I have to fetch CDHDR docs for sales orders using SQ01 query.

Since CDHDR is a cluster table and the data types of key fields do no match, i cannot directly join the tables in the infoset.

One record of VBAK would link to multiple records in CDHDR table. I need all the those records.

I tried adding Additional field/Structure, but it can fetch only one record from CDHDR at a time. The other records are missed out.

Please share if you have any ideas to how select multiple records from CDHDR table and display the same in output.

Thanks you,