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.