topic Re: SELECT Query - Data Type and Length problem in Application Development and Automation Discussions

SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 09:07:32 GMT

Hi All,

Please go thro' the below code.

TYPES: BEGIN OF t_ebeln,

ebeln(16),

ebelp TYPE ebelp,

matnr TYPE ekpo-matnr,

xblnr TYPE xblnr,

flag(1),

END OF t_ebeln,

BEGIN OF t_mseg,

ebeln TYPE MSEG-EBELN,

ebelp TYPE ebelp,

mblnr TYPE mblnr,

bwart TYPE bwart,

matnr TYPE matnr,

werks TYPE werks_d,

lgort TYPE lgort_d,

sobkz TYPE sobkz,

lifnr TYPE lifnr,

menge TYPE menge_d,

meins TYPE meins,

sgtxt TYPE sgtxt,

budat TYPE budat,

rec_lgort TYPE lgort_d,

flag(1) TYPE c,

END OF t_mseg.

In the I_EBELN internal Table I will have my PO's.

IF NOT i_ebeln[] IS INITIAL.

SELECT mblnr

budat

xblnr

FROM mkpf

INTO TABLE i_mkpf

FOR ALL ENTRIES IN i_ebeln

WHERE xblnr = i_ebeln-ebeln.

IF sy-subrc EQ 0.

SORT i_mkpf BY mblnr budat DESCENDING.

ENDIF.

To get Quantity based on the Movement Types.

IF NOT i_mkpf[] IS INITIAL.

SELECT ebeln

ebelp

mblnr

bwart

matnr

werks

lgort

sobkz

lifnr

menge

meins

sgtxt

FROM mseg

INTO TABLE i_mseg

FOR ALL ENTRIES IN i_mkpf

WHERE mblnr = i_mkpf-mblnr AND

lifnr IN s_lifnr AND

( bwart = c_501 AND

sobkz = c_k ).

IF sy-subrc EQ 0.

SORT i_mseg BY ebeln ebelp mblnr.

ENDIF.

*Get the PO's with 101 Quantity

SELECT ebeln

ebelp

mblnr

bwart

matnr

werks

lgort

sobkz

lifnr

menge

meins

sgtxt

FROM mseg

APPENDING TABLE i_mseg

FOR ALL ENTRIES IN i_ebeln

*WHERE ebeln = iebeln-ebeln AND*_

lifnr IN s_lifnr AND

bwart = c_101.

For the above SELECT statement I am getting error as 'EBELN' and 'I_EBELN-EBELN' should have same type and Length.

How to Over Come this.

\[removed by moderator\]

Regards,

Viji

Edited by: VijayaLakshmi Krishnaswamy on Aug 6, 2008 11:07 AM

Edited by: Jan Stallkamp on Aug 6, 2008 2:39 PM

Re: SELECT Query - Data Type and Length problem

sachin_mathapati — Wed, 06 Aug 2008 09:14:14 GMT

HI ,

change this..

TYPES: BEGIN OF t_ebeln,

ebeln type mseg-ebeln,

ebelp TYPE ebelp,

matnr TYPE ekpo-matnr,

xblnr TYPE xblnr,

flag(1),

END OF t_ebeln.

Regards,

Sachin M M

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 09:15:52 GMT

please declare ebeln with length 10 characters

otherwise use the dataelement ebeln to declare data type.

regards

Thirumaran k

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 09:17:00 GMT

Hi,

I cant change that. B'coz I have to Fetch Record from MKPF based on the XBLNR = EBELN.

SELECT mblnr

budat

xblnr

FROM mkpf

INTO TABLE i_mkpf

FOR ALL ENTRIES IN i_ebeln

WHERE xblnr = i_ebeln-ebeln.

Regards,

Viji.

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 09:19:25 GMT

Hi VijayaLakshmi,

Can you please give declaration of I_EBELN table.

It seems there is mismatch between EBELN declared in I_EBELN and MSEG-EBELN.

Regards,

Mohaiyuddin

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 09:21:58 GMT

Hi,

No need to change the length of ebeln bocz

xblnr if of length 16 and ebeln 10 which is less than 16.

so the system will automatically take care of it.

so change ebeln type mseg-ebeln.

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 09:23:21 GMT

Hi,

Please check the below.

TYPES: BEGIN OF t_ebeln,

ebeln(16),

ebelp TYPE ebelp,

matnr TYPE ekpo-matnr,

xblnr TYPE xblnr,

flag(1),

END OF t_ebeln,

I have declared EBELN as 16 Characters. B'cox to get record from MKPF based on XBLNR = EBELN.

Regards,

Viji.

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 09:24:10 GMT

hii

create another types as

TYPES: BEGIN OF t_ebeln,

ebeln(10),

ebelp TYPE ebelp,

matnr TYPE ekpo-matnr,

xblnr TYPE xblnr,

flag(1),

END OF t_ebeln,

copy the value from I_EBELN to a_ebeln.

a_ebeln [] = i_ebeln[].

for first select query use i_ebeln

and for second select query use a_ebeln.

hope , this will solve u r problem

Reagrds ,

Sabarinathan.L

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 09:25:09 GMT

Hi Arun,

When giving FOR ALL ENTRIES system will check for the DATA TYPE and LENGTH. It will not allow 16 Character with 10 Character.

Kindly check my code.

Regards,

Viji.

Re: SELECT Query - Data Type and Length problem

SuhaSaha — Wed, 06 Aug 2008 09:25:39 GMT

Hello,

You need to modify the TYPES declaratio a bit:

TYPES: BEGIN OF t_ebeln,

~~ebeln(16),~~

ebeln TYPE MSEG-EBELN,

ebelp TYPE ebelp,

matnr TYPE ekpo-matnr,

xblnr TYPE xblnr,

flag(1),

END OF t_ebeln,

Hope this is helpful.

BR,

Suhas

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 09:27:33 GMT

Correct as below

TYPES: BEGIN OF t_ebeln,

ebeln TYPE ekko-ebeln,

ebelp TYPE ebelp,

matnr TYPE ekpo-matnr,

xblnr TYPE xblnr,

flag(1),

END OF t_ebeln,

rgds

rajesh

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 10:40:19 GMT

Hi,

The TYPES of EBELN(16) should be of 16 Character. So that I can able to Extract data from MKPF table based on XBLNT = EBELN.

In this XBLNR is 16 Character Length.

So I cant change EBELN(16).

Regards,

Viji.

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 06 Aug 2008 10:46:50 GMT

hi can you do one thing..

first select statement...

after this send this to a variable..

loop at itab .

variable = itab-field.

use conversion_exit function module..

then use the second select single here ...

where field = variable.

endloop.

Re: SELECT Query - Data Type and Length problem

Former Member — Wed, 27 Aug 2008 05:50:15 GMT

Hi All,

thanks for your Answers.

Regards,

Viji

Re: SELECT Query - Data Type and Length problem

Former Member — Tue, 25 Nov 2008 09:15:04 GMT

Hi vijaya,

I have a similar problem in using FOR ALL ENTRIES as its giving a type and length mismatch error.

Were you able to solve your problem regarding the same?If so can you suggest me a solution.

My table is declared like this.

DATA:tb_vlcactdata_cs TYPE vlcactdata OCCURS 0 WITH HEADER LINE.

I am fecthing values into this table tb_vlcactdata_cs using an FM.

After that i m writing this select query for further processing.

SELECT * FROM nast

INTO TABLE tb_nast

FOR ALL ENTRIES IN tb_vlcactdata_cs

WHERE kschl = tb_vlcactdata_cs-kscha AND

objky = tb_vlcactdata_cs-vbeln.

This select query throws an error as tb_vlcactdata_cs-vbeln is of length 10 and nast-objky is of length 30.

So what is the possible solution to my query.

Thanks in advance.

Rithwika.