topic Re: uploading date format in Application Development and Automation Discussions

uploading date format

Former Member — Fri, 26 May 2006 06:02:34 GMT

hi everybody ,

i am uploading data to Tcode ie01

when user enters the date it should take all the format

my internal table

1)datsl LIKE rm63e-datsl,

2)inbdt LIKE itob-inbdt,

recoding

1)perform bdc_field using 'RM63E-DATSL'

file_int-datsl.

2)perform bdc_field using 'ITOB-INBDT'

file_int-inbdt.

for this edit mask or any code where and how should code plz suggest me give the code and any sample program

will be helpful

thank's &regards

soorya

Re: uploading date format

vinod_gunaware2 — Fri, 26 May 2006 06:04:34 GMT

CONVERT_DATE_TO_EXTERNAL

CONVERT_DATE_TO_INTERNAL Converts internal date to user-specific format string and vice versa. Import/Export : YYYYMMDD;

Export/Import : user specific date string. Can be for import either without or within delimiters, but for export only without delimiters.

See field DATFM in the USR01 table. Can be set up via System -> User Profile -> User Defaults or using su50.

DATUMSAUFBEREITUNG Country-specific date formatting for the current user. Examples of output: MM/YY, MM/YYYY, DD.MM, M/D/YYYY, DD/MM/YYYY, WW/YY, WW/YYYY.

CONVERT_DATE_INPUT – Conversion exit routine for inverted date

CONVERT_DATE_TO_EXTERNAL – Formats date from internal to display format

CONVERT_DATE_TO_INTERNAL – Formats date from display to internal format

regards

vinod

Re: uploading date format

Former Member — Fri, 26 May 2006 06:09:22 GMT

Hi,

When you do a BDC the date format should be the external format of the user.

So, either you can use the conversion routine or simply WRITE date to varaible and use the variable in the BDC.

Regards,

Ravi

Note : Please mark all the helpful answers

Re: uploading date format

Former Member — Fri, 26 May 2006 06:13:15 GMT

Hi,

pass it in the format of YYYYMMDD , this will take care of the format.

Regards

vijay

Re: uploading date format

Former Member — Fri, 26 May 2006 06:14:18 GMT

can u ple give me any sample code

Re: uploading date format

Former Member — Fri, 26 May 2006 06:18:37 GMT

Hi,

Use CONVERT_DATE_TO_INTERN_FORMAT

pass DTYPE = 'DATS'.

This FM will take care of use settings and accordingly convert to the proper format.

(ie: internal format)

REgards,

Anjali

Re: uploading date format

Former Member — Fri, 26 May 2006 06:25:34 GMT

Hi soorya,

1. Do not worry about the format, or user format.

2. just use like this :

data : datestr(10) type c.

write sy-datum into datestr.

(Write will AUTOMATICALLY write into the variable

in the USER FORMAT)

3. Now use this DATESTR

for your bdc value.

regards,

amit m.