SAP DDIC CONVERSION FUNCTIONS



Get Example source ABAP code based on a different SAP table
  


• FLTP_TO_DEC ABAP_SQL_FUNC
• UNIT_CONVERSION ABAP_SQL_FUNC
• CURRENCY_CONVERSION ABAP_SQL_FUNC
• DECIMAL_SHIFT ABAP_SQL_FUNC
• BINTOHEX ABAP_SQL_FUNC
• HEXTOBIN ABAP_SQL_FUNC

ABAP_DDIC - Conversion Functions
The following table shows the conversion functions that can be used by ABAP CDS and AB_SQL . The last three columns indicate where a function can be used. SQL FunctionResult ABAP CDS, DDIC-Based Views ABAP CDS, View Entities AB_SQL
AS_GEO_JSONConverts an argument of type GEOM_EWKB to JSON format.- - x
BINTOHEXConverts an argument of the type RAW to a string of the type CHAR.x x x
CURRENCY_CONVERSIONConversion of currencies. x x x
CURR_TO_DECFLOAT_AMOUNTConverts a currency field of data type CURR into a currency field of data type DECFLOAT34. - x -
DECIMAL_SHIFTSets the decimal separator of an argument in accordance with a currency. x --
FLTP_TO_DECConverts an argument of type FLTP to a packed number.x x-
GET_NUMERIC_VALUEConverts a CDS amount field or a CDS quantity field into a regular field of data type DECFLOAT34. The reference to a unit or currency key is removed. - x -
HEXTOBINConverts an argument of the type CHAR or NUMC to a byte string of the type RAW. x x x
TO_BLOBConverts an argument of the type RAW to a byte string (BLOB) of the type RAWSTRING. -- x
TO_CLOBConverts an argument of the type SSTRING to a CLOB of the type STRING. --x
UNIT_CONVERSIONConversion of units. x x x
The possible operands and data types as well as the exact functionality is described in the corresponding documentation for ABAP CDS, DDIC-Based Views, ABAP CDS, View Entities, and AB_SQL .