Getting data from CDPOS table..plz reply soon

[Former Member]

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

[Former Member]

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

[Former Member]

Divide the value by 1000.

[Former Member]

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.

[Former Member]

Hi Sonali,

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

Regards,

Atish

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

So do u know any way to do it.

[Former Member]

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