what is meaning of SELECT gjahr belnr AS augbl umskz

[laxman_sankhla3]

hi

here what is meaning of AS augbl umskz in query

thanks

[Former Member]

Hi Laxman,

augbl umskz in the above query are the alias names for gjahr belnr respectively

In the syntax as

SELECT <s1> AS <a1> ....

we use the AS addition to specify the alias name <a1> for column <s1>.

The alias column name is used instead of the real name.

Generally they are used when we use inner joins,order by,group by clauses etc.

They are helpful when we use the INTO CORRESPONDING FIELDS addition in the select query so as we have the same names as that in the internal table.

Hope it helps you.

Regards,

Saumya

[seshatalpasai_madala]

Hi,

When you want to give alias names to the fileds in your selection then you use AS then you have to use the alias names in the WHERE CLAUSE if you have one.

Regards,

Sesh

[Former Member]

hi,

the names <b>augbl umskz</b> are the alias names for <b>gjahr belnr</b> ,

this is used if in case of inner joins if you want to select the fields with same names from different tables , you can select them with alias names, but this is valid only in the SELECT statement