topic data types in Application Development and Automation Discussions

data types

Former Member — Mon, 30 Jul 2007 04:15:15 GMT

If data types of 2 fields are different how to compare???????????

Please let me know the solution and do needful

SELECT exnum

exdat

remtime

lifnr

rdoc

budat

FROM j_1iexchdr INTO CORRESPONDING FIELDS OF TABLE it_j_1iexchdr

FOR ALL ENTRIES IN it_mseg

WHERE rdoc = it_mseg-mblnr

AND ryear = it_mseg-mjahr.

Displayed message while developing a report

When you use the addition "FOR ALL ENTRIES IN itab", the fields "RYEAR"

and "IT_MSEG-MJAHR" must have the same type and the same length.

Re: data types

Former Member — Mon, 30 Jul 2007 04:25:25 GMT

Hi,

U can assign the value of 'IT_MSEG-MJAHR' to a Temporary Variable of type rdoc.

Like,

data : temp like j_1iexchdr-rdoc.

.....

temp = IT_MSEG-MJAHR.

SELECT exnum

exdat

remtime

lifnr

rdoc

budat

FROM j_1iexchdr INTO CORRESPONDING FIELDS OF TABLE it_j_1iexchdr

FOR ALL ENTRIES IN it_mseg

WHERE rdoc = temp

AND ryear = it_mseg-mjahr.

Regards,

Padmam.

Re: data types

Former Member — Mon, 30 Jul 2007 04:27:10 GMT

data: begin of ty_db.

v_mjahr(length) type c. " type c

end of

SELECT exnum

exdat

remtime

lifnr

rdoc

budat

FROM j_1iexchdr INTO CORRESPONDING FIELDS OF TABLE it_j_1iexchdr

FOR ALL ENTRIES IN it_mseg

WHERE rdoc = it_mseg-mblnr

AND ryear = it_mseg-mjahr

Re: data types

Former Member — Mon, 30 Jul 2007 04:31:42 GMT

Hi,

Usually this error will occur when we are using the FOR ALL ENTRIES option.

For this you can declare a temporary variable in your first internal table as the type of RYEAR.loop at that table and move the value to that temporary variable.

Now you can use that variable in the where condition.

reward will be helpful.

rgds

harris

Re: data types

mohammed_moqeeth — Mon, 30 Jul 2007 04:33:33 GMT

Dear Ray,

data element of j_1iexchdr -ryear is J_1IRYEAR1 --> CHAR (data type) 4(data length)

datalement of mseg-mjahr is MJAHR --> NUMC (data type) 4 (data length)

You have to define internal table it_j_1iexchdr with MJAHR as below:

data: begin of it_j_1iexchdr occurs 0,

.......

mjahr(4) type c,

.......

end of it_j_1iexchdr.

Reward Points for useful answers....

Regards,

Moqeeth.