using this (~) symbol in select query ?what does this mean?

[Former Member]

Suppose

SELECT   mapl~vbeln INTO IT_TAB mean what? also is this obsolete practice or still existing?

Thank you for your time and answers in advance !

[Former Member]

Hi,

The tilde(~) is used in SELECT statements when doing INNER JOINs or LEFT OUTER JOINs,  in the field lists, the join conditions, as well as in the WHERE clause.

Still existing..

[Former Member]

Dear Anajai

Tilde(~) is used in Join query i.e where data come from more then one table.

Hiphen ( - ) is used in normal queries.

Regards

Parveen

[Former Member]

It is used when alias name is used instead of actual table name. You don't have to use join in order to use alias.

See ABAP Keyword Documentation and this:

1. DATA lv_cityfrom TYPE spfli-cityfrom.
2. SELECT SINGLE cityfrom FROM spfli AS a 
3.   INTO lv_cityfrom WHERE a~carrid EQ 'AA'.
4. IF sy-subrc EQ 0.
5.   WRITE lv_cityfrom.
6. ENDIF.

/.

[Former Member]

Hi,

The Tilde(~) symbol is used to represent the field of the respective table while you are using joins in your select statement for fecthing the data from database.

Regards,

Chakradhar.

[raymond_giuseppi]

Read column selector in online help (accessible thru SELECT - join documentation)

Regards,

Raymond