topic updating database table in Application Development and Automation Discussions

updating database table

Former Member — Sat, 06 Jan 2007 07:31:48 GMT

hi guys,

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

insert tcurr from table tt_tcurr.

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

Re: updating database table

Former Member — Sat, 06 Jan 2007 07:39:59 GMT

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

CONVERSION_EXIT_INVDT_INPUT.

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

Re: updating database table

Former Member — Sat, 06 Jan 2007 09:08:57 GMT

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

Re: updating database table

anversha_s — Sat, 06 Jan 2007 09:10:23 GMT

pls dont open multiple threads