Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
Showing results for 
Search instead for 
Did you mean: 

SQ01 Query treasury REGUH - BSEG

Former Member
0 Kudos


how to join tables REGUH and BSEG? I need an import from BSEG, and I can't find on another table, but the SQ01 don't leave to use BSEG in a Join.

I need to find the import of the tax payed in a bank transference from the REGUH. This import only is in the BSEG table.


Former Member
0 Kudos

Well, first of all, since BSEG is a cluster table, you can't use it in a join. But there are other techniques to get data from it efficiently.


0 Kudos

and where I can find this import or how to use the BSEG in a query?

0 Kudos


U should use the BSAD or BSAK tables instead of BSEG, but you should use REGUP table, not REGUH.

Which table has to be used depends on the partner: if the payment is of a vendor, u need to use BSAK, for a customer use BSAD.