Skip to Content

change date type

My table is "tcurr"

and my field is "gdatu" which contains date but in a different format. I have to change this date format to //---- for posting in a BDC table which only alows //---- format. if i have to use

CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL/EXTERNAL' then how to use?

plz help

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • avatar image
    Former Member
    Aug 16, 2007 at 11:23 AM

    Hi,

    Use this function module before applying the BDC process, CONVERSION_EXIT_PDATE_OUTPUT, this will definitly serve the perpose, reward if found usefull.

    Regards,

    Rama Murthy.P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 10:28 AM

    Use the following code :

    CONVERT INVERTED-DATE <d1> INTO DATE <d2>.

    Regards,

    Aparna

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 09:53 AM

    USE write to ........... using edit mask STATEMENT FOR FORMATTING DATES.

    S@meer

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 16, 2007 at 09:58 AM

    Hi,

    external_date = '2006.12.01'.

    CALL FUNCTION 'KCD_EXCEL_DATE_CONVERT'

    EXPORTING

    EXCEL_DATE = external_date

    DATE_FORMAT = 'JMT' "(T) Day,(M) Month,(J) Year

    IMPORTING

    SAP_DATE = sap_date

    or

    You have to do settings in SU3(T.CODE). In SU3 goto defaults there you find Date Format. try to keep your settings and save it. Your BDC will work.

    aRs

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 10:27 AM

    Hi..

    that date format is inverted date format..

    Regards,

    Aparna

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 11:15 AM

    hi,

    use this function to get the desired output 'CONVERSION_EXIT_INVDT_OUTPUT' where your input is Gdatu and output is correct date.

    regards

    Abhilasha Gupta

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 11:16 AM

    make use of this FM

    CONVERSION_EXIT_INVDT_OUTPUT

    Regards

    Peram

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 18, 2007 at 06:33 AM

    problem solved

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      If the problem is solved assign points to the useful posts and close the thread,,

      Regards,

      Aparna