topic Re: internal tables and dates in Application Development and Automation Discussions

internal tables and dates

Former Member — Mon, 23 Jul 2007 05:40:07 GMT

hi all ,

i got 2 internal tables ,say itab1 and itab2.

itab1 is of like standarad table qmel.

itab2 is having all the feilds of qmel ie, of same structure of qmel but all feilds of type c .

i am uploading data from my flat file to my itab2 and further passing it to itab1.

everything is going fine but, there is 1 fields of date.

which in my flat file is of value 00:00:0000 now this value is coming to my itab2

but when i pass it to itab1 it takes 0.

rest where there is a true date like 01:02:2007 its working fine .

my date field is of type c and length 10.

so is the data passing correctly? becuase for rest of dates its going fine.

let me know if i need to do any changes if yes then like wot?.

1>i have already changed the dates to form yyyy:mm:dd database type

points for sure for solving the problem

thnkx

bhanu

Re: internal tables and dates

Former Member — Mon, 23 Jul 2007 05:43:27 GMT

Hi,

May be for you WRITE stetement with EDIT MASK works.

Reward if useful!

Re: internal tables and dates

Former Member — Mon, 23 Jul 2007 05:45:52 GMT

writev staetement?i mean where to use it i am simply passing data from 1 internal table to other , i am not using any write statement

Re: internal tables and dates

Former Member — Mon, 23 Jul 2007 05:47:29 GMT

Hi Bhanu,

If it is 0 then hard code it as 00:00:0000

Regards

Arun

Re: internal tables and dates

Former Member — Mon, 23 Jul 2007 05:49:12 GMT

Hi,

in ur internal table create that date field as of type <b>sy-datum</b> if u create it as char of length 10 it will neglect the separator between date,month and month,year.

rgds,

bharat.

Re: internal tables and dates

Former Member — Mon, 23 Jul 2007 05:49:44 GMT

hi arun the data is moving like this-->

itab-datefeild = itab-date feild

how to hard code over here?

thnkx

bhanu

Re: internal tables and dates

Former Member — Mon, 23 Jul 2007 05:55:41 GMT

Hi Bhanu,

instead of

itab-datefeild = itab-date feild

use stmt

write itab1-datefeild to itab2-datefeild DD/MM/YYYY.

Re: internal tables and dates

jayanthi_jayaraman — Mon, 23 Jul 2007 05:58:08 GMT

Hi,

After the assignment,check the left hand field of equal to.i.e. itab-datefeild

if itab-datefeild eq 0.

unpack itab-datefeild to itab-datefeild.

endif.

Re: internal tables and dates

Former Member — Mon, 23 Jul 2007 06:58:13 GMT

Hi Arun,

Now you have already Itab2 data available.

move Itab2 data to Itab1 do field to field.

Thaks,

Bala.