Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select Query help req????

Hi

I have to hardcode in the case of Doc Type = NB i.e BSART = 'NB' & FRGKZ = SPACE,in this code .I have to maintian the same functionlity,but if this is the case,than release indicator FRGKZ = Space.this additional thing as to be maintain.Please tell me...?

SELECT DISTINCT eban~banfn

eban~badat

eban~matnr

eban~werks

eban~ekgrp

eban~bsart

ekko~ebeln

ekko~bedat

INTO CORRESPONDING FIELDS OF TABLE itab1

FROM eban AS eban INNER JOIN ekko AS ekko ON ebanebeln = ekkoebeln

WHERE eban~loekz EQ space AND

eban~banfn IN p_prno AND

eban~badat IN p_prdate AND

eban~matnr IN p_matnr AND

eban~werks IN p_plant AND

eban~ekgrp IN p_prgrp AND

eban~bsart IN p_doctyp AND

ekko~ebeln IN p_pono AND

ekko~bedat IN p_podate AND

ekko~frgke = 'R'

GROUP BY eban~banfn

eban~badat

eban~matnr

eban~werks

eban~ekgrp

eban~bsart

ekko~ebeln

ekko~bedat

eban~banpr

eban~frgkz .

regards

Vipin

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question