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.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQ01 Query treasury REGUH - BSEG

Former Member

‎07-10-2007 5:50 PM

0 Kudos

Hi,

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.

3 REPLIES 3

Former Member

‎07-10-2007 5:52 PM

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.

Rob

Former Member
In response to Former Member

‎07-10-2007 5:57 PM

0 Kudos

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

Former Member
In response to Former Member

‎07-10-2007 6:17 PM

0 Kudos

Hi

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.

Max