‎2007 Mar 09 7:22 AM
hi!! Guys,
please can anybody help me how to compare date which is not in actual format
i.e. (when comparing BKPF-budat with TCURR-gdatu in where condition of a Select query its giving syntax error "when you use the addition 'fOR ALL ENTRIES IN itab' the fields gdatu and it_bkpf-budat" must have the same type and the same length. its very urgent...
thanks in advance.
akanksha.
‎2007 Mar 09 7:31 AM
Hi,
Budat in bkpf is of data type DATS
gdatu is of data type char of length type 8.
Declare the gdatu as of type data type dats.
Regards
‎2007 Mar 09 7:42 AM
try like this.
data : year(4),
mon(2),
day(2).
in itab declare field cbudat(8) type c.
loop at itab.
year = itab-budat(4).
mon = itab-budat+4(2).
day = itab-budat+6(2).
concatenate year mon day into itab-cbudat.
modify itab.
endloop.
now use select for all entries and check gdatu = itab-cbudat.
regards
shiba dutta