Disaggregation with Badi /ABAP

[Former Member]

Hi All,

I want a write a BAdi for do desaggregation but i can not find the historical transaction data. Does anyone know where they keep the referential datas at the backend system?

Thanks in advance.

[Former Member · Accepted solution]

Hi,

Every application has a cube in BPC. All the data is stored in the fact table of this cube. You need to check the technical name of this table. You can use this to fetch historical records.

right click on your cube -> manage -> contents tab -> fact table

Hope this helps.

[Former Member · Accepted solution]

Thank you Chatterjee;

I have a problem about getting these values. The point i am missing that how can i get these values in BAdi UJR_WRITE_BACK?

[former_member200327 · Accepted solution]

Hi,

It depends where your historical data is stored - in a regular BW cube or in BPC Application.

For a regular BW cube you can use RSDRI interface to access the data.

For BPC Application mentioned in prev posting approach is good for 'proof of concept', but not if you want to transport that to Production since table name will change when you compress the cube, cube name will change when you transport it, fully optimize and in many other cases.

Do get dynamically cube name you have to use BPC Application framework. Class CL_UJA_APPLICATION and Method IF_UJA_APPLICATION_DATA~GET_APPLICATION_INFO are very useful. One of the parameters of that Method is UJA_S_APPL_INFO that has cube name. Than you can use SQE or RSDRI interfaces to retrieve the data that Application.

Hope this helps.

Gersh