topic Re: whats wrong in this select statement in Application Development and Automation Discussions

whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 07:04:06 GMT

SELECT A~BUKRS

A~FKART

A~FKDAT

A~VBELN

B~POSNR

B~MATNR

B~MEINS

B~FKIMG

INTO TABLE IT_DATA

FROM VBRK AS A INNER JOIN VBRP AS B ON B_{VBELN = A}VBELN

WHERE A~BUKRS = P_BUKRS AND

A~FKART IN S_FKART AND

A~FKDAT IN S_FKDAT AND

B~MATNR IN S_MATNR.

i am getting dump in this select statement

Re: whats wrong in this select statement

kesavadas_thekkillath — Mon, 21 Dec 2009 07:06:58 GMT

What is the dump ?

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 07:07:57 GMT

hi,

can u cut paste the error.

Regards,

Abhijit

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 07:09:00 GMT

Hi,

Check your ON clause in inner join.

Left table : A

Right Table: B

so the condition should be like this:

A_{VBELN = B}VBELN

I hope it helps u.

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 07:14:35 GMT

hi deepti,

there are different cases .. can you give whta kind of dump your gtetting "dump discription".

~linganna

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 07:15:11 GMT

Hi ,

I guess it is the issue with the Structure of the "IT_DATA".

The code is working fine with the structure of "IT_DATA".

Please check the code -

data : begin of wa,
  bukrs type vbrk-bukrs,
        FKART type vbrk-FKART,
FKDAT type vbrk-FKDAT,
VBELN type vbrk-VBELN,
POSNR type vbrp-POSNR,
MATNR type vbrp-MATNR,
MEINS type vbrp-MEINS,
FKIMG type vbrp-FKIMG,
       end of wa,

it_data like table of wa.

SELECT A~BUKRS
A~FKART
A~FKDAT
A~VBELN
B~POSNR
B~MATNR
B~MEINS
B~FKIMG
INTO TABLE IT_DATA
FROM VBRK AS A INNER JOIN VBRP AS B ON B~VBELN = A~VBELN.
WHERE A~BUKRS = P_BUKRS AND
A~FKART IN S_FKART AND
A~FKDAT IN S_FKDAT AND
B~MATNR IN S_MATNR.

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 07:36:50 GMT

TYPES : BEGIN OF TY_DATA,

BUKRS TYPE VBRK-BUKRS,

FKART TYPE VBRK-FKART,

FKDAT TYPE VBRK-FKDAT,

VBELN TYPE VBRK-VBELN, " IN BOTH VBRK AND VBRP

POSNR TYPE VBRP-POSNR,

MATNR TYPE VBRP-MATNR,

MAKTX TYPE MAKT-MAKTX,

MEINS TYPE VBRP-MEINS,

FKIMG TYPE VBRP-FKIMG,

END OF TY_DATA.

DATA : WA_DATA TYPE TY_DATA,

IT_DATA TYPE STANDARD TABLE OF TY_DATA.

SELECT A~BUKRS

A~FKART

A~FKDAT

A~VBELN

B~POSNR

B~MATNR

B~MEINS

B~FKIMG

INTO TABLE IT_DATA

FROM VBRK AS A INNER JOIN VBRP AS B ON B_{VBELN = A}VBELN

WHERE A~BUKRS = P_BUKRS AND

A~FKART IN S_FKART AND

A~FKDAT IN S_FKDAT AND

B~MATNR IN S_MATNR.

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 07:43:41 GMT

use corresponding fields of table IT_DATA.

since the table structure is not similar to the fields selected in the SELECT Query .

Regards,

Abhijit

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 07:58:20 GMT

Hello


TYPES : BEGIN OF TY_DATA,
BUKRS TYPE VBRK-BUKRS,
FKART TYPE VBRK-FKART,
FKDAT TYPE VBRK-FKDAT,
VBELN TYPE VBRK-VBELN, " IN BOTH VBRK AND VBRP
POSNR TYPE VBRP-POSNR,
MATNR TYPE VBRP-MATNR,
MAKTX TYPE MAKT-MAKTX, <= this field is not present in SELECT !!!!!!
MEINS TYPE VBRP-MEINS,
FKIMG TYPE VBRP-FKIMG,
END OF TY_DATA.

DATA : WA_DATA TYPE TY_DATA,
IT_DATA TYPE STANDARD TABLE OF TY_DATA.

SELECT A~BUKRS
A~FKART
A~FKDAT
A~VBELN
B~POSNR
B~MATNR
B~MEINS
B~FKIMG
INTO TABLE IT_DATA
FROM VBRK AS A INNER JOIN VBRP AS B ON B~VBELN = A~VBELN
WHERE A~BUKRS = P_BUKRS AND
A~FKART IN S_FKART AND
A~FKDAT IN S_FKDAT AND
B~MATNR IN S_MATNR.

Field MAKTX is declared in internal table but not present in SELECT query. So in SELECT occurs attempt to write FKIMG to MAKTX. This brings to dumb because types inconsistency.

Two ways:

1. Remove this


TYPES : BEGIN OF TY_DATA,
BUKRS TYPE VBRK-BUKRS,
FKART TYPE VBRK-FKART,
FKDAT TYPE VBRK-FKDAT,
VBELN TYPE VBRK-VBELN, " IN BOTH VBRK AND VBRP
POSNR TYPE VBRP-POSNR,
MATNR TYPE VBRP-MATNR,
MAKTX TYPE MAKT-MAKTX, <= remove this
MEINS TYPE VBRP-MEINS,
FKIMG TYPE VBRP-FKIMG,
END OF TY_DATA.

2. Add to select query table MAKT for fetch MAKTX.

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 08:10:31 GMT

Either use move corresponding in the select query which is generally not preferable due to performance.

Or Remove the maktx field from the structure.

Or Move the maktx field in the structure at the last position in the structure so it wont affect the query.

Regards,

Lalit Mohan Gupta.

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 08:17:54 GMT

HI,

Use INTO CORRESPONDING FIELDS OF TABLE ITAB instead of INTO TABLE ITAB.

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 08:18:44 GMT

Error analysis

The data read during a SELECT access could not be inserted into the

target field.

Either conversion is not supported for the target field's type or the

target field is too short to accept the value or the data are not in a

form that the target field can accept

000890 FORM GET_DATA.

000900

000910

000920

000930 SELECT A~BUKRS

000940 A~FKART

000950 A~FKDAT

000960 A~VBELN

000970 B~POSNR

000980 B~MATNR

000990 B~MEINS

001000 B~FKIMG

001010 INTO TABLE IT_DATA

001020 FROM VBRK AS A INNER JOIN VBRP AS B ON B_{VBELN = A}VBELN

001030 WHERE A~BUKRS = P_BUKRS AND

001040 A~FKART IN S_FKART AND

001050 A~FKDAT IN S_FKDAT AND

> B~MATNR IN S_MATNR.

001070

001080

001090

001100 DESCRIBE TABLE IT_DATA1 LINES LINES.

001110 IF LINES = 0.

001120 MESSAGE I001 WITH 'No data available for the selection'.

001130 ENDIF.

001140

001150 CLEAR : LINES.

001160

001170

001180

001190 ENDFORM. " GET_DATA

001200

the above is the dump

Re: whats wrong in this select statement

Former Member — Mon, 21 Dec 2009 08:20:08 GMT

Hi,

Your tab declaration seems to be wrong.

try following code



tables: vbrp, vbrk.
parameters: p_bukrs type bukrs.

select-options: s_fkart for vbrk-fkart,
                s_fkdat for vbrk-fkdat,
                s_matnr for vbrp-matnr.

types : begin of ty_data,
bukrs type vbrk-bukrs,
fkart type vbrk-fkart,
fkdat type vbrk-fkdat,
vbeln type vbrk-vbeln, " IN BOTH VBRK AND VBRP
posnr type vbrp-posnr,
matnr type vbrp-matnr,
*MAKTX TYPE MAKT-MAKTX,        "TAKE OUT THIS FIELD FROM HERE
meins type vbrp-meins,
fkimg type vbrp-fkimg,
end of ty_data.

data : wa_data type ty_data,
it_data type standard table of ty_data.

select a~bukrs
a~fkart
a~fkdat
a~vbeln
b~posnr
b~matnr
b~meins
b~fkimg
into table it_data
from ( vbrk as a inner join vbrp as b on a~vbeln = b~vbeln )
where a~bukrs = p_bukrs and
      a~fkart in s_fkart and
      a~fkdat in s_fkdat and
      b~matnr in s_matnr.

Cheers,

Raj

Re: whats wrong in this select statement

former_member585060 — Mon, 21 Dec 2009 08:25:30 GMT

Hi,

TYPES : BEGIN OF TY_DATA,
BUKRS TYPE VBRK-BUKRS,
FKART TYPE VBRK-FKART,
FKDAT TYPE VBRK-FKDAT,
VBELN TYPE VBRK-VBELN, 
POSNR TYPE VBRP-POSNR,
MATNR TYPE VBRP-MATNR,
MAKTX TYPE MAKT-MAKTX, !
MEINS TYPE VBRP-MEINS,
FKIMG TYPE VBRP-FKIMG,
END OF TY_DATA.
 
DATA : WA_DATA TYPE TY_DATA,
IT_DATA TYPE STANDARD TABLE OF TY_DATA.
 
SELECT A~BUKRS
A~FKART
A~FKDAT
A~VBELN
B~POSNR
B~MATNR
C~MAKTX                   " Add this
B~MEINS
B~FKIMG
INTO TABLE IT_DATA
FROM VBRK AS A INNER JOIN VBRP AS B ON B~VBELN = A~VBELN
                               INNER JOIN MAKTX AS C ON B~MATNR = C~MATNR     " Add this
WHERE A~BUKRS = P_BUKRS AND
A~FKART IN S_FKART AND
A~FKDAT IN S_FKDAT AND
B~MATNR IN S_MATNR AND
C~SPRAS EQ 'EN'.      " Give the language here

or Use FOR ALL ENTRIES instead of Joins

Regards

Bala Krishna