topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Thu, 07 Dec 2006 09:02:08 GMT

hi friends,

can we write iner join on tables MSEG and BSEG tables

regards,

malleswari.

Re: inner join

Former Member — Thu, 07 Dec 2006 09:04:48 GMT

MSEG you can write Inner Join but BSEG you can not as it is Cluster table in Newer Version.

Regards

Nimesh Patel.

Re: inner join

Former Member — Thu, 07 Dec 2006 09:05:17 GMT

Hi malleswari,

1. BSEG - Not (bcos its a cluster table)

2. MSEG - Yes (bcos its a normal transparent table)

3. For BSEG,

if we want to use inner join concept,

then instead we should use FOR ALL ENTRIES.

eg. First we gather main data from BKPF,

then we gather data from BSEG in ANOTHER INTERNAL TABLE,

and there we use FOR ALL ENTRIES concept.

regards,

amit m.

Re: inner join

Former Member — Thu, 07 Dec 2006 09:05:29 GMT

Hi,

No, i dont think so,

MSEG is a transparent table

whereas BSEG is a cluster table.

Regards,

pankaj singh

Re: inner join

Former Member — Thu, 07 Dec 2006 09:07:00 GMT

fetch the data from the VBRK and VBRP tables

select vbrk~vbeln

vbrp~posnr

vbrk~fkart

vbrk~ktgrd

vbrp~oipbl

vbrp~matkl

vbrp~volum

vbrp~netwr

vbrp~voleh

vbrk~waerk

into table it_bill1

from vbrk

inner join vbrp

on vbrk_{vbeln = vbrp}vbeln

where vbrk~fkart in s_fkart and

vbrk~vkorg in s_vkorg and

vbrk~spart in s_spart and

vbrk~fkdat in s_fkdat and

vbrp~matkl in s_matkl and

vbrp~oipbl in s_oipbl.

*----

select a~vbeln

b~posnr

a~fkart

a~ktgrd

a~oipbl

b~matkl

b~volum

b~netwr

b~voleh

a~waerk

into table it_bill1

from vbrk as a

inner join vbrp as b

on a_{vbeln = b}vbeln

where a~fkart in s_fkart and

a~vkorg in s_vkorg and

a~spart in s_spart and

a~fkdat in s_fkdat and

b~matkl in s_matkl. " and

b~oipbl in s_oipbl.

Re: inner join

Former Member — Thu, 07 Dec 2006 09:07:33 GMT

You cannot write join for cluster tables like BSEG..Instead you can use FOR ALL ENTRIES options..

EX..

DATA: T_BKPF TYPE STANDARD TABLE OF BKPF,
T_BSEG TYPE STANDARD TABLE OF BSEG.

SELECT * FROM BKPF
INTO TABLE T_BKPF
WHERE....

IF NOT T_BKPF IS INITIAL.

SELECT * FROM BSEG
INTO TABLE T_BSEG
FOR ALL ENTRIES IN T_BKPF
WHERE BUKRS = T_BKPF-BUKRS
AND BELNR = T_BKPF-BELNR
AND GJAHR = T_BKPF-GJAHR..

ENDIF.