Skip to Content
0
Former Member
Feb 23, 2009 at 01:38 PM

regarding initilization logic

26 Views

hi,

i have one requirement to add in below select statement

AND mara~mstav EQ 'S0'.(its a hard coaded value)

SELECT mara~matnr

marc~werks

marc~beskz

marc~webaz

marc~plifz

marc~wzeit

marc~dzeit

marc~ekgrp

marc~dispo

marc~strgr

mara~meins

marc~disls

marc~mrppp

marc~zz_ext_del

marc~zz_ext_mod

INTO TABLE itb_art

FROM ( mara

INNER JOIN marc

ON maramatnr = marcmatnr )

WHERE mara~matnr IN s_matnr

AND marc~werks EQ p_werks

AND mara~mtart IN s_mtart

AND mara~lvorm EQ ' '

AND marc~lvorm EQ ' '

AND marc~beskz NE ' '

AND mara~mstav EQ 'E0'.

this is the suggestion given by my client instaead of hardcoading follow these steps..

so how to i will write the code????

Why donu2019t you propose to have a new selection criteria field for MARA-MMSTAV and then initialize the values u201CE0u201D & u201CS0u201D?

Then you use the same screen variables in the select query.

OR ELSE.

Use a RANGES option in the program and then append both the values in the range and then use the range in select query instead of writing separately as

MARA~MMSTAV = u2018E0u2019

MARA~MMSTAV = u2018S0u2019 in the query.

WHAT TO DO????

please help me..

thanks

navketan