topic Re: updating database table in Application Development and Automation Discussions

updating database table

Former Member — Sat, 06 Jan 2007 07:36:33 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 08:30:21 GMT

It uses the conversion routine.

CONVERSION_EXIT_INVDT_INPUT

SO ur value will be stored in inverted format only.If u read the table values again its get converted into the orginal format using CONVERSION_EXIT_INVDT_OUTPUT

routine.

I.e Ur data is stored internally in one format thats use of conversion routine.

If u fetch the data & see it will be in the format which u give so dont worry

Re: updating database table

anversha_s — Sat, 06 Jan 2007 08:38:30 GMT

hi,

inverted _date

**************************

CALL FUNCTION 'CONVERSION_EXIT_INVDT_OUTPUT'
EXPORTING
input = '79948992'
IMPORTING
OUTPUT = d_date.
write d_date.

Output:10/07/2005

or

CONVERT INVERTED-DATE TCURR-GDATU INTO DATE VALID_FROM_DATE

<u>2) Reversal</u>

CALL FUNCTION 'CONVERSION_EXIT_INVDT_INPUT'
EXPORTING
input = '07/10/2005'
IMPORTING
OUTPUT = c_date.
write c_date.

Output: 79949289

Rgds

Anver