How to retrieve data from COSP table with Value Type -11??

[Former Member]

Dear All,

We need to fetch the data from ECC table COSP where Value Type = 11(Statistical Postings) into BW but couldnt find any DS.

We also checked the DSs 0CO_OM_WBS_1 and 0CO_OM_WBS_6 but didnt find the required Value Type.

We have a field as VTSTAT(Statistic ID) in DS 0CO_OM_WBS_1 with values as 0 and 1 against Vtype 10(Actuals) and 20(Plan). But by this way also unable to reconcile data back with COSP table.

Could you please let us know if anyone has come across such requirement?

Thanks,

Nilesh

[former_member186399 · Accepted solution]

Dear Nilesh

You should try with 0CO_OM_OPA_1 or the OPA series datasource. It provides all the value type from COSP.

Regards

Gajesh

[Former Member · Accepted solution]

Dear Gajesh,

Thanks for your reply but mentioned DSs are not yet activated in our BW system so couldnt able to test the same.

Initially we had got wrong measures from Users, later we got correct values(Users need data from COEP table) so used DS 0CO_OM_WBS_1 to get the same.

Thanks,

Nilesh