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.
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
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |