ABAP on HANA: AMDP HANA Query where condition 'colon' clarification

[former_member210923]

Dear Team,

In AMDP HANA Query, kindly help to understand the difference between the following query.

it_output = select ebeln from ekko as A inner join ekpo as b where a.ebeln = b.ebeln and a.mandt = :im_mandt;

it_output = select ebeln from ekko as A inner join ekpo as b where a.ebeln = b.ebeln and a.mandt = im_mandt;

What difference the above query will make if i miss the colon for the importing parameter [im_mandt]. Please give a clarification. [Question might be simple. Pl help to understand]

[former_member302041]

If you miss the colon then the statement won't compile.

Colon means that you addressing local variable.

[former_member210923]

Thanks for the reply andrey.uryukin.zim. The Statement complies even if I miss out the colon. That is where my doubt raised.