updating database table

[Former Member]

hi guys,

i want to sent some data to standard table TCURR using INSERT statement.

<b>insert tcurr from table tt_tcurr.</b>

tha data is getting updated but the problem is this table stores date in inverted format.

In what format i should send date, in inverted format or normal date format or how

Please suggest.

ahmed

[Former Member]

You have to use this conversion routine for that field in Tcurr table .

<b>CONVERSION_EXIT_INVDT_INPUT.</b>

CONVERSION_EXIT_INVDT_OUTPUT.

Can u please tell us what the business requirement is and y u r updating tcurr.

pass the date to this converison routine and get the output store into ur internal table this will be in the form of a number and now update the tcurr..

i hope this will do.

regards,

vijay

[Former Member]

Hi execute the code and check the output .

data : date like sy-datum,
       val like sy-datum,
       datum(8) type n .
date = sy-datum.

concatenate date+4(2) date+6(2) date+0(4) into val.  "-->input is MMDDYYYY

CALL FUNCTION 'CONVERSION_EXIT_INVDT_INPUT'
  EXPORTING
  input          = val
 IMPORTING
   OUTPUT        = datum. "is Tcurr format compatible

write:/ datum.

"--> store this into ur internal table and

insert in to Tcurr.

hope this helps

regards,

vijay

[anversha_s]

<i>pls dont open multiple threads</i>