topic Re: Date format mismatching in BDC in Application Development and Automation Discussions

Date format mismatching in BDC

Former Member — Thu, 12 Mar 2009 06:30:54 GMT

displaying wrong date format

Hi,

I am uploading some price records, inthat input file i have MMDDYY format, but while uploading its giving error. Its geting stuckup there. i think i need to change the format before passing FVAL.

I declared the date field as RV13A-DATAB .

How resolve this...

Anyone having idea please help this out.

Mohana

Re: Date format mismatching in BDC

Former Member — Thu, 12 Mar 2009 06:33:28 GMT

hi,

1) change the input format to YYYYMMDD

2) Use write source to target statement.

3) Use the target field to populate the screen field.

This is because, the screen data is with respect to User profile data, hence it changes everytime user changes the format.

It would better for you to change the text file data to above specified format and carry out the rest of the steps.

The write to statement converts the data to what so ever user format being used, hence no inconsistencies with respect screen field format, which is nothing but the user format.

Thanks

Sharath

Re: Date format mismatching in BDC

Former Member — Thu, 12 Mar 2009 06:33:51 GMT

It depends on your system default date settings. In debug mode please change the format to DDMMYYYY to see if it works. Else try with other formats like YYYYDDMM .

I hope using this method you should be able to solve it in quick time.

Re: Date format mismatching in BDC

Former Member — Thu, 12 Mar 2009 06:35:26 GMT

Dear Mohana.

Instead of MMDDYY u can use DDMMYY.

I Mean to say , i n ur file data date is like 022309 instead of this u can write that in format 230209.

and your internal table date field u can five as tezt means date(10) type C instead of RV13A-DATAB .

Issue exist revert back.

Re: Date format mismatching in BDC

Former Member — Thu, 12 Mar 2009 06:39:47 GMT

Mohan,

pass the value coming from source file to FM:

Convert_date_to_internal:

this will convert date from MM/DD/YYYY to YYYYMMDD.

Pass this intranla table to FM: Convert_date_to_extranal. This will convert the internal table to

the external user format.

Re: Date format mismatching in BDC

Former Member — Thu, 12 Mar 2009 06:39:51 GMT

hi,

Check the following code

write fs_item-eeind to lw_date. " (1)
  concatenate 'RM06B-EEIND(' w_pos ')' into lw_line.
  perform bdc_field using lw_line lw_date.

" (2)

The above code ( 1 & 2 are of your interest) is with respect to ME51 transaction for table control and also populating screen. I had a similar issue with respect to date and that's how I could resolve it.

Thanks

Sharath

Re: Date format mismatching in BDC

Former Member — Thu, 12 Mar 2009 06:40:50 GMT

Hi,

Thnx for u peoples reply, but the problem is am not able to change the input file format. Even i am not able to change the user machine settings also.

Thy are going go maintain in MMDDYY format only, i need to correct in the program itself.

Pls help this issue.

Mohana V

Chennai

Re: Date format mismatching in BDC

Former Member — Thu, 12 Mar 2009 06:41:01 GMT

Hi,

This is simple...

1.Declare the date field as Char rather than RV13A-DATAB .

2.when you get the data into internal table, simply use offset and concatenate mechanism that convert the date into the required filed.

Means extract the MM,DD and YYYY from the filedval in the intrenal table then finally concatenate the 2 variablr as MMDDYY into the final 4th variable and use that variable or overwrite the variable in the intrenal table and use it in BDC recording.

Hope this might help you out.

Pooja

Re: Date format mismatching in BDC

Former Member — Thu, 12 Mar 2009 06:46:16 GMT

MMDDYY

Hi,

Data: var1 type sy-datum.

If file data was in Var2.

var1(2) = '20' " First 2 digits of the year - but it will work only till 2099 year.

var12(2) = file_data-date4(2).

var1+4(4) = file_data-date(4).

try this,

~Satya

Re: Date format mismatching in BDC

Former Member — Thu, 12 Mar 2009 06:49:05 GMT

hi,

BDC uses the data in the form of EXTERNAL.

Try to convert the date and use it.

ref FM: CONVERT_DATE_TO_EXTERNAL