Inverted date

The internal format of date in the table TCURR is called INVERTED date. Read more in this tip.

The internal format of date in the table TCURR is called INVERTED date. If you want to select some data from this

table you'll be in trouble if you don't know this. Here are the functions that help you to convert between formats. Also, the command CONVERT is very useful for these purposes.


DATA: XVAL(8) TYPE C VALUE '80009187'.
DATA: FECHA(10) TYPE C.

CALL FUNCTION 'CONVERSION_EXIT_INVDT_OUTPUT'
EXPORTING INPUT = XVAL "C(8) formato inverted
IMPORTING OUTPUT = FECHA "c(10) dd.mm.yyyy
EXCEPTIONS OTHERS = 1.
WRITE: SY-SUBRC, XVAL, FECHA.

WRITE SY-DATUM TO FECHA DD/MM/YYYY.
CALL FUNCTION 'CONVERSION_EXIT_INVDT_INPUT'
EXPORTING INPUT = FECHA "C(10) dd.mm.yyyy
IMPORTING OUTPUT = XVAL "C(8) formato inverted
EXCEPTIONS OTHERS = 1.
WRITE: / SY-SUBRC, FECHA,XVAL.

WRITE:/ 'With convert'.
CONVERT DATE SY-DATUM INTO INVERTED-DATE XVAL.
WRITE:/ SY-DATUM,XVAL.

This was first published in March 2002

Dig deeper on SAP Basis administration and NetWeaver administration

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close