05-29-2006 7:31 AM
hi friends,
when uploads date it should accept all format and upload to the table
upload is from excel to tcode
plz give the exact code
<u>my itab field</u>
datsl LIKE rm63e-datsl,
<u>recorded date field</u>
perform bdc_field using 'RM63E-DATSL'
file_int-datsl.
thanks,
soorya
05-29-2006 7:34 AM
Soorya,
To a BDC the date always should be passed in the external format. So, just take the values as it is from the excel and just before passing to the PERFORM, call CONVERT_DATE_TO_EXTERNAL and pass the formatted date.
Regards,
Ravi
Note : Please mark the helpful answers
05-29-2006 7:38 AM
hi
u can move the date to string field and split it accordingly and concatenate it in the desired format and then pass it to the relevant internal table..
reward points if it helps
gunjna
05-29-2006 7:38 AM
Hi soorya,
1. For BDC purpose,
the format of date field
should not be YYYYMMDD.
2. Instead, it should be
AS IT IS
WHILE ENTERING MANUALLY THE DATA ON THE SCREEN.
3. Now, this depends upon the individual users format.
4. To make our code, independent of user format,
its better to use like this :
5. data : dtstr(10) type c.
write sy-datum to dtstr.
(write will write the date into character variable
dtstr AUTOMATICALLY IN THE USERS FORMAT)
6. Then we just need to use this new variable
DTSTR in our bdctable.
7. Thats all !
regards,
amit m.
05-29-2006 7:38 AM
Hi,
you need not to worry about it, it will be automatically converted to default format.
regards
vijay
05-29-2006 7:40 AM
Hai Soorya
ISM_CONVERT_DATE_CATEGORY
ISM_CONVERT_DATE_CATGRY_SINGLE
ISM_CONVERT_TO_DATE_CATEGORY
ISP_CONVERT_TO_VISIBLE_DATE
RKE_CONVERT_DATE_TO_LOGNR
RKE_CONVERT_DATE_TO_PERIOD
CONVERT_DATE_FORMAT
OIUHS_INTEGRATION_EPRZ_EXT OIUHS_CONVERT_DATE
CONVERT_DATE_TO_EXTERNAL
CONVERT_DATE_TO_INTERNAL
SCAL
DATE_CONVERT_TO_FACTORYDATE
FACTORYDATE_CONVERT_TO_DATE
SCA_CALENDAR_CONVERSION
CONVERT_CALENDAR_DATE
CONVERT_DATE_TO_EXTERNAL
CONVERT_DATE_TO_INTERNAL
SCAL
DATE_CONVERT_TO_FACTORYDATE
FACTORYDATE_CONVERT_TO_DATE
SCA_CALENDAR_CONVERSION
CONVERT_CALENDAR_DATE
SCON
CONVERT_DATE_INPUT
CONVERT_DATE_WITH_THRESHOLD
SLS_MISC_CONVERT_TO_DATE
ADDR_CONVERT_DATE_TO_TIMESTAMP
ADDR_CONVERT_TIMESTAMP_TO_DATE
CONVERT_DATE_BY_PERIOD_INPUT
CONVERT_DATE_INPUT
CONVERT_DATE_WITH_THRESHOLD
SLS_MISC_CONVERT_TO_DATE
ADDR_CONVERT_DATE_TO_TIMESTAMP
ADDR_CONVERT_TIMESTAMP_TO_DATE
CONVERT_DATE_BY_PERIOD_INPUT
Thanks & regards
Sreeni
OIUREP_ROY_STAT_AND_CNTRL