Skip to Content
Former Member
Jul 20, 2005 at 04:34 PM

help in the query


hi folks,

Help me to build the query here.

Tables BKPF - fields belnr, blart

BSEG - fields kunnr,wrbtr, zuonr

I need to get the data into a single internal table whose strucutre consists of fields kunnr, blart,wrbtr and zuonr

the common field between the two tables is belnr and the query should be run based on 'zuonr' field


select ......................... where bseg-zuonr = p_advnum(paramter field where I get the data)

Question how to establish relation between two tables in asingle query without the use of 'JOIN' statements because BSEG is a cluster table and i cannot do that.

Thanks in advance.