topic Re: select in db table in Application Development and Automation Discussions

select in db table

Former Member — Tue, 08 Nov 2005 15:18:32 GMT

i want to select VPOSN from VEDA

most of the field are empty,000000,12,20

how i select it

i made vposn = '000000'

or vposn = ' '.

and it's not work do you have any idea,

Re: select in db table

Former Member — Tue, 08 Nov 2005 15:20:40 GMT

Hi yehiel,

I think VPOSN = '000000' would be working.

Are you getting any error?

I have tried this

REPORT YRT_TEST.

tables: veda.

start-of-selection.

select single *

from veda

into veda

where vposn = '000000'.

if sy-subrc = 0.

write:/ veda-posnr.

endif.

Thanks,

Ravi

Re: select in db table

RichHeilman — Tue, 08 Nov 2005 15:23:28 GMT



data: xveda type veda.

parameters: p_vbeln type veda-vbeln.


* If the values for VPOSN are not filled, then you should
* be able to get them using  VPOSN = '000000'.
select single * from veda into xveda
                 where  vbeln =  p_vbeln
                   and  vposn = '000000'.

Regards,

Rich Heilman

Re: select in db table

Former Member — Tue, 08 Nov 2005 15:24:57 GMT

vposn = '000000' did not work for those

that are initial, so i made '' with 6 spaces

and it's not work

Re: select in db table

RichHeilman — Tue, 08 Nov 2005 15:25:49 GMT

Can you please post your exact code.

Thanks.

Regards,

Rich Heilman

Re: select in db table

Former Member — Tue, 08 Nov 2005 15:28:24 GMT

try VPOSN EQ SPACE

Also post ur code so that we can findout wat exactly is going wrong

Message was edited by: Nandha Kumar Raju

Re: select in db table

Former Member — Tue, 08 Nov 2005 15:31:29 GMT

SELECT venddat vbegdat

FROM veda

INTO (veda-venddat , veda-vbegdat)

WHERE vbeln = mdcw-zs_vbeln

AND ( vposn = mdcw-zs_posnr )

( VPOSN = ' ').

AND venddat = ( SELECT MAX( venddat )

FROM veda

WHERE vbeln = mdcw-zs_vbeln

AND ( vposn = mdcw-zs_posnr )

( VPOSN = ' ' ) ).

IF sy-subrc = 0.

mdcw-zs_venddat = veda-venddat.

mdcw-zs_vbegdat = veda-vbegdat.

else.

MODIFY mdcw.

ENDIF.

ENDSELECT.

i tried '000000' too

Re: select in db table

Former Member — Tue, 08 Nov 2005 15:31:53 GMT

REPORT YRT_TEST.

tables: veda.

start-of-selection.

select single * from veda

into veda

where vposn = '000000'

OR VPOSN IS NULL.

if sy-subrc = 0.

write:/ veda-vposn.

endif.

Re: select in db table

Former Member — Tue, 08 Nov 2005 15:32:34 GMT

the pointer '.' is wrong dont look at her

Re: select in db table

Former Member — Tue, 08 Nov 2005 15:36:34 GMT

SELECT venddat vbegdat

FROM veda

INTO (veda-venddat , veda-vbegdat)

WHERE vbeln = mdcw-zs_vbeln

AND ( vposn = mdcw-zs_posnr )

( VPOSN EQ SPACE )

( VPOSN = '000000' )

AND venddat = ( SELECT MAX( venddat )

FROM veda

WHERE vbeln = mdcw-zs_vbeln

AND ( vposn = mdcw-zs_posnr )

( VPOSN EQ SPACE )

( VPOSN = '000000' ) ).

IF sy-subrc = 0.

mdcw-zs_venddat = veda-venddat.

mdcw-zs_vbegdat = veda-vbegdat.

else.

MODIFY mdcw.

ENDIF.

ENDSELECT.

i tried this too and is not giving me the right data

Re: select in db table

RichHeilman — Tue, 08 Nov 2005 15:37:39 GMT

How about this, does this work?



select venddat vbegdat
   from veda
       into (veda-venddat , veda-vbegdat)
          where  vbeln = mdcw-zs_vbeln
            and ( vposn = mdcw-zs_posnr
             or   vposn = '000000' )
            and venddat = ( select max( venddat )
                               from veda
                                   where vbeln = mdcw-zs_vbeln
                                     and ( vposn = mdcw-zs_posnr
                                      or   vposn = '000000' ) ).
  if sy-subrc = 0.
    mdcw-zs_venddat = veda-venddat.
    mdcw-zs_vbegdat = veda-vbegdat.
  else.
    modify mdcw.
  endif.
endselect.

Regards,

Rich Heilman

Re: select in db table

Former Member — Tue, 08 Nov 2005 15:38:37 GMT

"OR VPOSN IS NULL" should detect this on an Oracle DB... not sure what DB system you are running.

Re: select in db table

Former Member — Tue, 08 Nov 2005 15:41:05 GMT

It has to be '000000'. I think your select statement is not working because of the positioning of the '(' and ')'. Here is the modified one.


  SELECT venddat vbegdat
    FROM veda
    INTO (veda-venddat , veda-vbegdat)
   WHERE vbeln = mdcw-zs_vbeln
     AND ( vposn = mdcw-zs_posnr OR
           vposn = '000000' )
     AND venddat = ( SELECT MAX( venddat )
                       FROM veda
                      WHERE vbeln = mdcw-zs_vbeln
                        AND ( vposn = mdcw-zs_posnr OR
                              vposn = '000000' ) ).

Please let me know if this is what you are looking for.

Srinivas

Re: select in db table

Former Member — Tue, 08 Nov 2005 15:50:08 GMT

thank rich

Re: select in db table

RichHeilman — Tue, 08 Nov 2005 15:52:18 GMT

So is it working now? If so, please make sure to mark your post as solved and award points to your fellow SNDers who have helped you.. Thanks.

Regards,

Rich Heilman