topic Re: Getting data from CDPOS table..plz reply soon in Application Development and Automation Discussions

Getting data from CDPOS table..plz reply soon

Former Member — Fri, 07 Mar 2008 11:39:32 GMT

Hi,

i m fetching data from CDPOS after passing objectclas, objectid, changenr and fname.

i have to get values for value_old and value_new fields.

i m not getting the correct values.

first i m using condense for the field value_oold and value_new.

because these two fields are of 254 char in length.

if the value is 500.000, it is coming as 500000.000.

please help me out.

Thanx in advance,

Sonali

Re: Getting data from CDPOS table..plz reply soon

Former Member — Fri, 07 Mar 2008 11:42:16 GMT

Divide the value by 1000.

Re: Getting data from CDPOS table..plz reply soon

Former Member — Fri, 07 Mar 2008 12:04:59 GMT

Is this teh right way to do it.

i mean is there any other option.

i want to know why it is coming like that.

Re: Getting data from CDPOS table..plz reply soon

Former Member — Fri, 07 Mar 2008 12:10:24 GMT

Hi Sonali,

Provide more details as for which data you are querying CDPOS?

Regards,

Atish

Re: Getting data from CDPOS table..plz reply soon

Former Member — Fri, 07 Mar 2008 12:19:36 GMT

Hi Atish,

First i m fetching the data from CDHDR tab, in that i m passin objectclas, objectid, changenr, udate and tcode.

After that i m fetching the data according to the above selection from CDPOS tab, in this i m passing objectclas, objectid, changenr and fname.

Now i m getting cdpos-value_old and cdpos-value_new values from this query.

but the values are not coming correctly.

instead of 500.000 its showing 500000.000.

Thanx,

Sonali

Re: Getting data from CDPOS table..plz reply soon

Former Member — Fri, 07 Mar 2008 12:21:41 GMT

HI,

Even we faced the same issue in our development. Actual the project was upgraded from 4.6 to Ecc6 .

The data before upgrade was like this and the data after upgrade was ok.

We haven't done anything but we have a raised this issue to sap.

But please do not divide it by 100 as that is not the correct procedure

Re: Getting data from CDPOS table..plz reply soon

Former Member — Fri, 07 Mar 2008 12:24:26 GMT

Hi Sonali,

I got that. More details means which the field values. For which kind of table you are looking for change documents?

And if all the values are stored as *100 then you can just divide it by 100. there is no as such hard and fast approach to be required.

Regards,

Atish

Re: Getting data from CDPOS table..plz reply soon

Former Member — Fri, 07 Mar 2008 12:26:07 GMT

Hi,

So do u know any way to do it.

Re: Getting data from CDPOS table..plz reply soon

Former Member — Fri, 07 Mar 2008 12:47:37 GMT

Hi,

DIvide it by 1000 is the right ans.

Just now i debugged FM CHANGEDOCUMENT_READ_POSITIONS.

In that also they are doing the same thing, Dividing it by 1000.

If u will directly use this FM than u can get the values for the two fields.

Thanx,

Sonali