inner join

Former Member — Wed, 28 May 2008 07:50:17 GMT

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 bseg_{bukrs bseg}belnr bseg_{gjahr bseg}fisper bseg_{buzei bseg}augdt bseg_{shkzg bseg}dmbtr bseg_{kostl bseg}hkont bseg_{matnr bseg}werks

bkpf_{blart bkpf}bldat bkpf_{budat bkpf}cpudt bkpf_{usnam bkpf}tcode bkpf_{bktxt bkpf}waers bkpf_{awtyp bkpf}awkey

INTO CORRESPONDING FIELDS OF TABLE lt_output

FROM ( bseg INNER JOIN bkpf ON

bseg_{bukrs = bkpf}bukrs AND

bseg_{belnr = bkpf}belnr AND

bseg_{gjahr = bkpf}gjahr )

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

Re: inner join

Former Member — Wed, 28 May 2008 07:52:47 GMT

Hi,

First read data from BKPF into table it_bkpf, then check the internal table is empty or not. Sort the internal table and use SELECT FOR ALL ENTRIES statement to read data from BSEG. Dont use Joins on Pooled and Clustered tables.

Rgds,

Bujji

topic Re: inner join in Application Development and Automation Discussions

inner join

Re: inner join