SAP SQL ELEM Get Example source ABAP code based on a different SAP tableSAP Help
ABAP_SQLEXP - sql_elem ABAP_SYNTAX ... col literal $| @dobj $| @( expr ) ... What does it do? Value from the database Column col of a data source The column col can be of any elementary data type from the ABAP Dictionary, unless otherwise documented for an operand position. Values of the ABAP program passed to the database system Literal literal Host variable @dobj Host expression @( expr ) The ABAP objects can have any non-generic elementary ABAP data type and the name of a host variable must be tagged with the escape character @. Typed literals are handled strictly according to their type. Untyped literals are restricted to the types c and i. Untyped text field literals are allowed. String literals are not allowed, neither typed nor untyped. Furthermore, no empty text field literal can be specified. An empty typed literal of type CHAR can be specified. Numeric ABAP TypeDictionary Type b, s, i, int8INT1, INT2, INT4, INT8 pDEC with appropriate length and decimal places decfloat16, decfloat34DF16_RAW, DF34_RAW fFLTP Character-Like ABAP TypeDictionary Type cCHAR with appropriate length nNUMC with appropriate length stringSTRING with appropriate length Byte-Like ABAP TypeDictionary Type xRAW with appropriate length xstringRAWSTRING with appropriate length ABAP Type for Date, Time, and Time StampDictionary Type dDATS tTIMS utclongUTCLONG text field literals are handled as fields with the type CHAR of the corresponding length where trailing blanks are respected. Like the untyped numeric literals of a general ABAP, untyped numeric literals are handled either as a field with the type INT4 or the type DEC, depending on their value. rules for lossless assignments . Latest notes: Columns, literals, host variables, and host expressions can also occur as elementary SQL operands in operand positions in which no general SQL expressions are possible. Columns, literals, hosts variables, and host expressions can only be handled as SQL expressions in positions where SQL expressions are possible. Only there can they be specified inside parentheses . Then, the statement can only have lists separated by commas and host variables must be indicated by the escape character @. If an elementary SQL expression consists of a host variable in the form of a field symbol or formal parameter, this expression must be completely typed. Untyped literals, host variables, and host expressions as operands of other SQL expressions are evaluated before the AB-SQL statement is sent to the database system. Specifying a host variable from a SELECT list after INTO in a SELECT loop does not mean that a different value is used in each loop pass. The fact that literals, host variables, and host expressions are mapped to specific dictionary types as operands of SQL expressions, whereas other operand positions allow conversions to different target types, is particularly significant for relational expressions in which the comparability of dictionary types is important. An elementary expression can always be evaluated in the table buffer. If an elementary expression is specified, table buffering is not bypassed. The column specification col can contain a path expression for CDS associations or CTE associations. If a host expression is used as an argument of another SQL expression, the syntax check is performed in a ABAP_STRICT_760 strict mode from ABAP_RELEASE ABAP_760 / , which handles the statement more strictly than the regular syntax check. ABAP_EXAMPLE_VX5 SELECT list of the second SELECT statement contains all possible elementary SQL expressions. ABAP_EXAMPLE_ABEXA Constant in the SELECT List
