Flag

[Former Member]

HI,

In the following select statement i have added a condition like BELKZ = 'X' ,

how to declare this in data.

SELECT pspnr posid objnr INTO TABLE gt_prps1

FROM prps

WHERE pbukr IN s_bus_wg

AND BELKZ = ‘X’

GROUP BY posid objnr pspnr

[JozsefSzikszai]

hi hemal,

do you mean:

DATA : gv_belkz LIKE prps-belkz.

...

gv_belkz = 'X'.

SELECT pspnr posid objnr INTO TABLE gt_prps1

FROM prps

WHERE pbukr IN s_bus_wg

AND BELKZ = gv_belkz

GROUP BY posid objnr pspnr

hope this is what you mean

ec

[Former Member]

Hi,

tables:prps.

SELECT-OPTIONS s_bus_wg for prps-pbukr.

DATA:gt_prps1 type prps occurs 0,

i_BELKZ type prps-BELKZ value 'X'.

SELECT pspnr posid objnr INTO TABLE gt_prps1

FROM prps

WHERE pbukr IN s_bus_wg

AND BELKZ = i_BELKZ

GROUP BY posid objnr pspnr.

<b>reward if helpful</b>

rgds,

bharat.

[Former Member]

Hi hemal ,

You can declare it as constant.

Data : gc_belkz type c value 'X'.

In select you use it as

SELECT pspnr posid objnr INTO TABLE gt_prps1

FROM prps

WHERE pbukr IN s_bus_wg

AND BELKZ = gc_belkz

GROUP BY posid objnr pspnr

[Former Member]

hi Hemal,

There is no need to declare anthing, if at all you want to use a constant for value X , then declare as below

Constants : c_flag(1) value 'X'.

SELECT pspnr posid objnr INTO <b>CORRESPONDING FIELDS OF</b> TABLE gt_prps1

FROM prps

WHERE pbukr IN s_bus_wg

AND <b>BELKZ = C_FLAG</b>

GROUP BY posid objnr pspnr

Message was edited by:

Chandrasekhar Jagarlamudi