Kontakt

Ansicht
Dokumentation

ABENCDS_COND_EXPR_TYPES - CDS COND EXPR TYPES

ABENCDS_COND_EXPR_TYPES - CDS COND EXPR TYPES

Vendor Master (General Section)   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.
SAP E-Book

- cond_expr, Comparable Types

The following tables show which built-in data types in ABAP Dictionary can be compared with each other in a condition of a CDS view.

Comparisons with Fields of Data Sources

The following table shows the possible combinations of data source fields data_source on the left side (lhs) with data source fields on the right side (rhs) of comparisons.

lhs/rhs INT1 INT2 INT4 INT8 DEC CURR QUAN DECFLOAT16 DECFLOAT34 FLTP CHAR SSTRING NUMC CLNT LANG DATS TIMS DATN TIMN UTCLONG ACCP UNIT CUKY RAW
INT1 x x x x x x x x x x - - - - - - - - - - - - - -
INT2 x x x x x x x x x x - - - - - - - - - - - - - -
INT4 x x x x x x x x x x - - - - - - - - - - - - - -
INT8 x x x x x x x x x x - - - - - - - - - - - - - -
DEC x x x x x x x x x x - - - - - - - - - - - - - -
CURR x x x x x x x x x x - - - - - - - - - - - - - -
QUAN x x x x x x x x x x - - - - - - - - - - - - - -
DECFLOAT16 x x x x x x x x x x - - - - - - - - - - - - - -
DECFLOAT34 x x x x x x x x x x - - - - - - - - - - - - - -
FLTP x x x x x x x x x x - - - - - - - - - - - - - -
CHAR - - - - - - - - - - x x x l x x x - - - x x x -
SSTRING - - - - - - - - - - x x - - x - - - - - x x x -
NUMC - - - - - - - - - - x - l l - l l - - - - - - -
CLNT - - - - - - - - - - l - l x - - - - - - - - - -
LANG - - - - - - - - - - x x - - x - - - - - - - - -
DATS - - - - - - - - - - x - l - - x - - - - - - - -
TIMS - - - - - - - - - - x - l - - - x - - - - - - -
DATN - - - - - - - - - - - - - - - - - x - - - - - -
TIMN - - - - - - - - - - - - - - - - - - x - - - - -
UTCLONG - - - - - - - - - - - - - - - - - - - x - - - -
ACCP - - - - - - - - - - x x - - - - - - - - x - - -
UNIT - - - - - - - - - - x x - - - - - - - - - x - -
CUKY - - - - - - - - - - x x - - - - - - - - - - x -
RAW - - - - - - - - - - - - - - - - - - - - - - - l

  • There are no restrictions for combinations using "x".
  • In combinations using "l", the lengths of the compared columns must match exactly.

Comparisons with Parameters

The following table shows the possible combinations of data source fields data_source on the left side (lhs) with parameters on the right side (rhs) of comparisons.

lhs/rhs INT1 INT2 INT4 INT8 DEC CURR QUAN DECFLOAT16 DECFLOAT34 FLTP CHAR SSTRING NUMC CLNT LANG DATS TIMS DATN TIMN UTCLONG ACCP UNIT CUKY RAW
INT1 x x x x x x x x x x - - - - - - - - - - - - - -
INT2 x x x x x x x x x x - - - - - - - - - - - - - -
INT4 x x x x x x x x x x - - - - - - - - - - - - - -
INT8 x x x x x x x x x x - - - - - - - - - - - - - -
DEC x x x x x x x x x x - - - - - - - - - - - - - -
CURR x x x x x x x x x x - - - - - - - - - - - - - -
QUAN x x x x x x x x x x - - - - - - - - - - - - - -
DECFLOAT16 x x x x x x x x x x - - - - - - - - - - - - - -
DECFLOAT34 x x x x x x x x x x - - - - - - - - - - - - - -
FLTP x x x x x x x x x x - - - - - - - - - - - - - -
CHAR - - - - - - - - - - x x x l x x x - - - - x x -
SSTRING - - - - - - - - - - x x - - x - - - - - - x x -
NUMC - - - - - - - - - - x - l l - l l - - - - - - -
CLNT - - - - - - - - - - l - l x - - - - - - - - - -
LANG - - - - - - - - - - x x - - x - - - - - - - - -
DATS - - - - - - - - - - x - l - - x - - - - - - - -
TIMS - - - - - - - - - - x - l - - - x - - - - - - -
DATN - - - - - - - - - - - - - - - - - x - - - - - -
TIMN - - - - - - - - - - - - - - - - - - x - - - - -
UTCLONG - - - - - - - - - - - - - - - - - - - x - - - -
ACCP - - - - - - - - - - x x - - - - - - - - - - - -
UNIT - - - - - - - - - - x x - - - - - - - - - x - -
CUKY - - - - - - - - - - x x - - - -   - - -- - - x -
RAW - - - - - - - - - - - - - - - - - - - - - - - l

  • There are no restrictions for combinations using "x".
  • In combinations using "l", the lengths of the compared operands must match exactly.

Comparisons with literals

The following table shows the possible combinations of data source fields data_source on the left side (lhs) with literals on the right side (rhs) of comparisons function. The data types of literals are determined by the content of literals (as described here) and only the data types shown in the table are possible.

lhs/rhs INT1 INT2 INT4 FLTP CHAR NUMC
INT1 x y - - - -
INT2 x x z - - -
INT4 x x x - - -
INT8 x x x - - -
DEC x x x d - -
CURR l l l d - -
QUAN l l l d - -
DECFLOAT16 x x x - - -
DECFLOAT34 x x x - - -
FLTP - - - - - -
CHAR - - - - m m
SSTRING - - - - m -
NUMC - - - - - l
CLNT - - - - - l
LANG - - - - l l
DATS - - - - - l
TIMS - - - - - l
ACCP - - - - - l
UNIT - - - - m -
CUKY - - - - m -
RAW - - - - - -

  • There are no restrictions for combinations using "x".
  • For the combination using "y", the literal value must be between 0 and 999. For the combination using "z", the literal value must be between -99999 and +99999.
  • For combinations using "m", the length of the literal cannot be larger than the column.
  • For combinations using "d", the length of the literal and the number of decimal places cannot be larger than the length and number for the column.
  • For combinations using "l", the length of the literal must be equal to the length of the column.





TXBHW - Original Tax Base Amount in Local Currency   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 54925 Date: 20240425 Time: 031915     sap01-206 ( 292 ms )