selecting fields uisng joins

[Former Member]

Hi friends ,

can any one find my runtime error

types :

begin of ty_first,

mandt type mkpf-mandt,

mblnr type mkpf-mblnr,

mjahr type mkpf-mjahr,

budat type mkpf-budat,

xabln type mkpf-xabln,

bukrs type mseg-bukrs,

bwart type mseg-bwart,

bwtar type mseg-bwtar,

charg type mseg-charg,

ebeln type mseg-ebeln,

ebelp type mseg-ebelp,

lgort type mseg-lgort,

lifnr type mseg-lifnr,

matnr type mseg-matnr,

meins type mseg-meins,

menge type mseg-menge,

nplnr type mseg-nplnr,

vkwrt type mseg-vkwrt,

waers type mseg-waers,

werks type mseg-werks,

end of ty_first,

data :

it_first type standard table of ty_first,

wa_first type ty_first.

select mkpf~mandt

mkpf~mblnr

mkpf~mjahr

mkpf~budat

mkpf~xabln

mseg~bukrs

mseg~bwart

mseg~bwtar

mseg~charg

mseg~ebeln

mseg~ebelp

mseg~lgort

mseg~lifnr

mseg~matnr

mseg~meins

mseg~menge

mseg~nplnr

mseg~vkwrt

mseg~waers

mseg~werks

into table it_first

from mkpf inner join mseg

on mkpf_{mandt = mseg}mandt and mkpf_{mblnr = mseg}mblnr

and mkpf_{mjahr = mseg}mjahr

where MKPF~BUDAT in S_BUDAT AND

BWART = c_mov101 or

BWART = c_mov102 or

BWART = c_mov105 or

BWART = c_mov106.

when iam executing its showing me the follwoing run time error as

To few fields in into clause.

can any one check it.

Regards,

Priyanka

[Former Member]

Hi friends ,

can any one find my runtime error

types :

begin of ty_first,

mandt type mkpf-mandt,

mblnr type mkpf-mblnr,

mjahr type mkpf-mjahr,

budat type mkpf-budat,

xabln type mkpf-xabln,

bukrs type mseg-bukrs,

bwart type mseg-bwart,

bwtar type mseg-bwtar,

charg type mseg-charg,

ebeln type mseg-ebeln,

ebelp type mseg-ebelp,

lgort type mseg-lgort,

lifnr type mseg-lifnr,

matnr type mseg-matnr,

meins type mseg-meins,

menge type mseg-menge,

nplnr type mseg-nplnr,

vkwrt type mseg-vkwrt,

waers type mseg-waers,

werks type mseg-werks,

end of ty_first,

data :

it_first type standard table of ty_first,

wa_first type ty_first.

select mkpf~mandt

mkpf~mblnr

mkpf~mjahr

mkpf~budat

mkpf~xabln

mseg~bukrs

mseg~bwart

mseg~bwtar

mseg~charg

mseg~ebeln

mseg~ebelp

mseg~lgort

mseg~lifnr

mseg~matnr

mseg~meins

mseg~menge

mseg~nplnr

mseg~vkwrt

mseg~waers

mseg~werks

into table it_first

from mkpf inner join mseg

on mkpf_{mandt = mseg}mandt and mkpf_{mblnr = mseg}mblnr

and mkpf_{mjahr = mseg}mjahr

where MKPF~BUDAT in S_BUDAT AND

BWART = c_mov101 or

BWART = c_mov102 or

BWART = c_mov105 or

BWART = c_mov106.

when iam executing its showing me the follwoing run time error as

To few fields in into clause.

can any one check it.

Regards,

Priyanka

[Former Member]

post run time error.

also use into corresponding fields along with select query

[Former Member]

check this way...

select a~mandt

a~mblnr

a~mjahr

a~budat

a~xabln

b~bukrs

b~bwart

b~bwtar

b~charg

b~ebeln

b~ebelp

b~lgort

b~lifnr

b~matnr

b~meins

b~menge

b~nplnr

b~vkwrt

b~waers

b~werks

into table it_first

from mkpf as a inner join mseg as b

on a_{mblnr = b}mblnr

and a_{mjahr = b}mjahr

where a~BUDAT in S_BUDAT AND

( b~BWART = c_mov101 or

b~BWART = c_mov102 or

b~BWART = c_mov105 or

b~BWART = c_mov106 ).

[Former Member]

change the code to this..

REPORT  ztets.


TYPES :

BEGIN OF ty_first,
mandt TYPE mkpf-mandt,
mblnr TYPE mkpf-mblnr,
mjahr TYPE mkpf-mjahr,
budat TYPE mkpf-budat,
xabln TYPE mkpf-xabln,
bukrs TYPE mseg-bukrs,
bwart TYPE mseg-bwart,
bwtar TYPE mseg-bwtar,
charg TYPE mseg-charg,
ebeln TYPE mseg-ebeln,
ebelp TYPE mseg-ebelp,
lgort TYPE mseg-lgort,
lifnr TYPE mseg-lifnr,
matnr TYPE mseg-matnr,
meins TYPE mseg-meins,
menge TYPE mseg-menge,
nplnr TYPE mseg-nplnr,
vkwrt TYPE mseg-vkwrt,
waers TYPE mseg-waers,
werks TYPE mseg-werks,
END OF ty_first.
tables: mkpf.
data :
it_first TYPE STANDARD TABLE OF ty_first,
wa_first TYPE ty_first.
select-options: s_budat for mkpf-budat.

SELECT mkpf~mandt
mkpf~mblnr
mkpf~mjahr
mkpf~budat
mkpf~xabln
mseg~bukrs
mseg~bwart
mseg~bwtar
mseg~charg
mseg~ebeln
mseg~ebelp
mseg~lgort
mseg~lifnr
mseg~matnr
mseg~meins
mseg~menge
mseg~nplnr
mseg~vkwrt
mseg~waers
mseg~werks
INTO TABLE it_first
FROM mkpf INNER JOIN mseg
ON mkpf~mandt = mseg~mandt AND mkpf~mblnr = mseg~mblnr
AND mkpf~mjahr = mseg~mjahr
WHERE mkpf~budat IN s_budat AND
(
bwart = '101' OR
bwart = '102' OR
bwart = '105' OR
bwart = '106' ).
break-point.

[Former Member]

Hi,

You have to say the bwart value from which table field you are comparing.

Just change the small modification as highlighted.

select mkpf~mandt

mkpf~mblnr

mkpf~mjahr

mkpf~budat

mkpf~xabln

mseg~bukrs

mseg~bwart

mseg~bwtar

mseg~charg

mseg~ebeln

mseg~ebelp

mseg~lgort

mseg~lifnr

mseg~matnr

mseg~meins

mseg~menge

mseg~nplnr

mseg~vkwrt

mseg~waers

mseg~werks

into table it_first

from mkpf inner join mseg

on mkpf_{mandt = mseg}mandt and mkpf_{mblnr = mseg}mblnr

and mkpf_{mjahr = mseg}mjahr

where MKPF~BUDAT in S_BUDAT AND

mseg~BWART = c_mov101 or

mseg~BWART = c_mov102 or

mseg~BWART = c_mov105 or

mseg~BWART = c_mov106.

Regards,

Rama.

[former_member585060]

Try adding INTO CORRESPONDING FIELDS OF to ur select query.

SELECT

,

,

,

mseg~waers

mseg~werks

into INTO CORRESPONDING FIELDS OF table it_first

,

,

,