topic Re: Select Query help req???? in Application Development and Automation Discussions

Select Query help req????

Former Member — Tue, 06 Nov 2007 10:11:37 GMT

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 eban_{ebeln = ekko}ebeln

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

Re: Select Query help req????

Former Member — Tue, 06 Nov 2007 10:22:29 GMT

Hi,

Loop at TAB1 where BSART = 'NB'.

if sy-subrc = 0.

Move ' ' to TAB1-FRGKZ.

modify TAB1.

Endloop.

Trythis,

Re: Select Query help req????

Former Member — Tue, 06 Nov 2007 10:31:19 GMT

well my prob is that i am selecting the data as per as the selection-screen.than i have to put it into an internal table & have to do the,claculations.

if user will put.doc type = 'nb',than its release indic is. frgkz is space,no entry.So my select query will not pick any data in case of NB as all the where condi has to be true.

so i am asking,where should i code,as per as my knowlege,i have to code before filling the data into the int. table.otherise,my table will be empty in case of BSART = NB.As its release indi is none,so i have to pass space in its filed.

please help me.if u got my prob??

Re: Select Query help req????

Former Member — Tue, 06 Nov 2007 10:33:51 GMT

Hi Vipin ,

Try this.

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 eban_{ebeln = ekko}ebeln

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

<b>( eban~bsart IN p_doctyp or " here put And / Or as reqd.

eban~bsart eq 'NB' ) and

eban-frgkz = ' ' and</b>

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 .

Reward If Useful,

Regards,

Chitra

Re: Select Query help req????

Former Member — Tue, 06 Nov 2007 10:39:38 GMT

Hi Vipin,

Try this.

Loop at TAB1into wa_itab1 where BSART = 'NB'.

if sy-subrc = 0.

delete itab1 from wa_itab1.

Endloop.

you can do this after you fill the in ternal tables, so that wherenever there is a NB entry , that entry willbe deleted.

Reward If Useful.

Regards,

Chitra

Re: Select Query help req????

Former Member — Tue, 06 Nov 2007 11:00:10 GMT

well in earlier select query,eban~frgkz = 'R' is already hardcoded. i forgot to write.

So now will 2 frgkz,means eban_{frgkz = '' ,eban}frgkz = 'R' will work .?

Re: Select Query help req????

Former Member — Tue, 06 Nov 2007 11:30:12 GMT

hi,can i use this??is displaying error?? "(" ")" has no closing.??

cn you please make it work.

SELECT DISTINCT eban~banfn

eban~badat

eban~matnr

eban~werks

eban~ekgrp

eban~bsart

eban~frgkz

eban~banpr

INTO CORRESPONDING FIELDS OF TABLE itab2 FROM eban AS eban

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

( eban_{frgkz EQ 'R' or eban}frgkz = space where eban~bsart = 'NB' ) and

( eban_{banpr EQ '05' or eban}banpr = space where eban~bsart = 'NB' ) AND

eban~ebeln EQ space

GROUP BY eban~banfn

eban~badat

eban~matnr

eban~werks

eban~ekgrp

eban~bsart

eban~frgkz

eban~banpr.