topic Re: po in Application Development and Automation Discussions

po

Former Member — Tue, 23 Oct 2007 06:40:56 GMT

HI,

select objectclas

objectid

tabname

fname

value_new

value_old

from cdpos

into table t_cdpos

where objectclas = 'EINKBELEG'

and objectid = 3100000295

and tabname = 'ekpo'

and ( fname = 'brtwr'

or fname = 'key'

or fname = 'loekz' ).

wht's wrong in this?

I wnt to get old and new vlaues.

how to get those for that particular PO.

pls help its urgent.

regards,

Re: po

Former Member — Tue, 23 Oct 2007 06:43:38 GMT


select objectclas
objectid
tabname
fname
value_new
value_old
from cdpos
into table t_cdpos
where objectclas = 'EINKBELEG'
and objectid = 3100000295
and tabname = 'EKPO'  "Capital
and ( fname = 'BRWTR'  "Capital
or fname = 'KEY' "Capital
or fname = 'LOEKZ' ). "Capital

Re: po

Former Member — Tue, 23 Oct 2007 06:48:03 GMT

Hi kb,

write values in capital letters.

these are always case sensitive.

Whenever u comapre a value write that in capital letters in codes ( ' ' )

select objectclas

objectid

tabname

fname

value_new

value_old

from cdpos

into table t_cdpos

where objectclas = 'EINKBELEG'

and objectid = '3100000295'

and tabname = 'EKPO'

and ( fname = 'BRTWR'

or fname = 'KEY'

or fname = 'LOEKZ ).

Regards,

Hemant

Re: po

Former Member — Tue, 23 Oct 2007 06:48:52 GMT

Hi,

I am not getting any values into t_cdpos.

Pls help.

Regards,

Re: po

Former Member — Tue, 23 Oct 2007 06:50:42 GMT

Hi,

i have used capital letter's. Then also i am not getting values into t_cdpos.

regards,

Re: po

Former Member — Tue, 23 Oct 2007 06:52:13 GMT


select objectclas
objectid
tabname
fname
value_new
value_old
from cdpos
into table t_cdpos
where objectclas = 'EINKBELEG'
and objectid = '3100000295'  " Object ID should be in Single Quote <======
and tabname = 'EKPO'  "Capital
and ( fname = 'BRWTR'  "Capital
or fname = 'KEY' "Capital
or fname = 'LOEKZ' ). "Capital

Re: po

naimkhans_babi — Tue, 23 Oct 2007 07:00:11 GMT

well

Yaa its fine you need to pass the data in Capital only but as well you need to check.. wither that change object really contains any data.. or not.. for that you need to see RSSCD100 program.. pass all the values here.. you can find values if it is changed over there....and... you can check with the BANF as well may be sometime BANF contains the value as per the scenarios i dont know what you have.. but check with the BANF object instead of EINKBELENGE

Re: po

JoffyJohn — Tue, 23 Oct 2007 07:04:00 GMT

Try with this

SELECT objectclas

objectid

tabname

fname

value_new

value_old

FROM cdpos

INTO TABLE t_cdpos

WHERE objectclas = 'EINKBELEG'

AND objectid = '3100000295'

AND tabname = 'EKPO'

AND ( fname = 'BRTWR'

OR fname = 'KEY'

OR fname = 'LOEKZ' ).

Re: po

naimkhans_babi — Tue, 23 Oct 2007 07:06:05 GMT

Dear KB...

This is what i have written.. you can see the queries.. here...

select objectid changenr tabkey value_new from cdpos into table

it_cdpos1 for all entries in i_ekpo where

*objectclas = 'BANF' or

objectclas = 'EINKBELEG' and

objectid = i_ekpo-i_objectid and

tabname = 'EBAN' and

tabkey = i_ekpo-i_tabkey and

fname = 'FRGZU'.

used RSSCD100 program to check... change object information.

reward points if used full

Regards

Naeem

Re: po

Former Member — Wed, 14 Jan 2009 22:23:48 GMT

thanks