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