topic Re: Flag in Application Development and Automation Discussions

Flag

Former Member — Tue, 28 Aug 2007 07:25:17 GMT

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

Re: Flag

JozsefSzikszai — Tue, 28 Aug 2007 07:30:09 GMT

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

Re: Flag

Former Member — Tue, 28 Aug 2007 07:33:06 GMT

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.

reward if helpful

rgds,

bharat.

Re: Flag

Former Member — Tue, 28 Aug 2007 07:45:04 GMT

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

Re: Flag

Former Member — Tue, 28 Aug 2007 07:50:12 GMT

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 CORRESPONDING FIELDS OF TABLE gt_prps1

FROM prps

WHERE pbukr IN s_bus_wg

AND BELKZ = C_FLAG

GROUP BY posid objnr pspnr

Message was edited by:

Chandrasekhar Jagarlamudi