Skip to Content
0
Former Member
May 28, 2008 at 07:50 AM

inner join

20 Views

hi,

i have problem to execute the join using select options programm

my code is right but it give a problem of projection

TYPES: BEGIN OF it_output,

bukrs TYPE bseg-bukrs,

belnr TYPE bseg-belnr,

gjahr TYPE bseg-gjahr,

fisper TYPE bseg-gjahr,

buzei TYPE bseg-buzei,

augdt TYPE bseg-augdt,

shkzg TYPE bseg-shkzg,

dmbtr TYPE bseg-dmbtr,

kostl TYPE bseg-kostl,

hkont TYPE bseg-hkont,

matnr TYPE bseg-matnr,

werks TYPE bseg-werks,

blart TYPE bkpf-blart,

bldat TYPE bkpf-bldat,

budat TYPE bkpf-budat,

cpudt TYPE bkpf-cpudt,

usnam TYPE bkpf-usnam,

tcode TYPE bkpf-tcode,

bktxt TYPE bkpf-bktxt,

waers TYPE bkpf-waers,

awtyp TYPE bkpf-awtyp,

awkey TYPE bkpf-awkey,

END OF it_output.

DATA: lt_output TYPE it_output OCCURS 0 WITH HEADER LINE.

SELECTION-SCREEN BEGIN OF BLOCK bl WITH FRAME TITLE text-011.

SELECT-OPTIONS: s_bukrs FOR bseg-bukrs,

s_blart FOR bkpf-blart,

s_budat FOR bkpf-budat.

SELECTION-SCREEN END OF BLOCK bl.

FORM get_data .

SELECT bsegbukrs bsegbelnr bseggjahr bsegfisper bsegbuzei bsegaugdt bsegshkzg bsegdmbtr bsegkostl bseghkont bsegmatnr bsegwerks

bkpfblart bkpfbldat bkpfbudat bkpfcpudt bkpfusnam bkpftcode bkpfbktxt bkpfwaers bkpfawtyp bkpfawkey

INTO CORRESPONDING FIELDS OF TABLE lt_output

FROM ( bseg INNER JOIN bkpf ON

bsegbukrs = bkpfbukrs AND

bsegbelnr = bkpfbelnr AND

bseggjahr = bkpfgjahr )

WHERE bseg~bukrs IN s_bukrs AND

bkpf~blart IN s_blart AND

bkpf~budat IN s_budat.

ENDFORM. "get_data

plz give me a proper solution for this.

thanks.

it give error as

for pooled tables, clusters tables and projection views joins is not allowed "BSEG".

plz help me