Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on SAP Basis

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchContentManagement

SearchHRSoftware

Close