topic Re: Date format error in loading Programme in Application Development and Automation Discussions

Date format error in loading Programme

Former Member — Thu, 16 Apr 2009 06:43:04 GMT

Hi all,

I am getting the error as I_BLDAT invalid date (ORA-01840: input value not long enough for date format) but some how in loading program I am getting the date as . .0 instead of 00000000. can someone please help me where it went wrong.These are the lines involing BLDAT

CONCATENATE:
         wa_zfrcptp-bldat+6(2) wa_zfrcptp-bldat+4(2)
         wa_zfrcptp-bldat+0(4) INTO l_lla_dtl_rec-pay_date,

wa_zfrcptp-bldat        TO l_huon_crr_rec-receipt_date.

wa_zfrcptp-bldat        TO l_huon_ipr_rec-receipt_date.

CONCATENATE wa_zfrcptp-bldat+6(2)
                wa_zfrcptp-bldat+4(2)
                wa_zfrcptp-bldat+0(4)
                           INTO l_cal_dtl_rec-receipt_date

bldat_i(8)           TYPE c,

l_cid_dtl_rec-bldat_i     = wa_zfrcptp-bldat.

Thanks in advance,

Rishik.

Edited by: Rishik on Apr 16, 2009 8:44 AM

Re: Date format error in loading Programme

Former Member — Thu, 16 Apr 2009 07:07:50 GMT

HI,

If you are using the BDC for loading data..then while passing BLDAT to the BDC

Use the WRITE statement to convert the date to user format and pass to BDC

l_endda1 is of type char with length 10. endda type sy-datum.

WRITE i_input_line-endda TO l_endda1.
    PERFORM bdc_field       USING 'RP50G-ENDDA'    l_endda1.

Re: Date format error in loading Programme

Former Member — Thu, 16 Apr 2009 07:16:34 GMT

Hi There,

the message u r getting "input date is not longer enough" is due to the date format.

You can declare the date as c(10) and watch out for your user profile own date formant like dd.mm.yyyy or mm/dd/yyyy etc...

And when you are uploading the data The reason behind getting date format as "..00" etc is because the conventional program will take date input as "YYYYMMDD" and it converts this into your user profile date format like "dd.mm.yyyy" etc.

Please watch these answers you will be solving your issue.

Regards,

Shekher

Re: Date format error in loading Programme

Former Member — Thu, 16 Apr 2009 07:26:29 GMT

Hi,

If ur using BDC...then pass 10 character variable to it....as while accepting the data in BDC recording

system accepts it in 10 characters & stores internally in YYYYMMDD format.

Regards,

ajit.