Why fields of a cube table are different from the cube characteristics?
We've got a custom infocube called ZPUR_C01. Now we are trying to define purchasing doc number and Item number of purchasing document in a code.
When editing the cube, we can see the technical names are 0OI_EBELN and 0OI_EBELP respectively for the above two characteristics in the cube. But when using SE11 to check the cube table /BIC/FZPUR_C01, find there is no any field for purchasing doc number and Item number of purchasing document and most of them seem to show only key figures, why?
Techinaccly all dimension ids become the part of Primary key in F or E Tables of the cube.So you can not see (in the table /BIC/FZPUR_C01) directly the fields 0OI_EBELN and 0OI_EBELP .But you can see the Dimension id of both (if they belong to single dimensions) or 2 dimension ids respectively( if they belong to different dimensions).
And againn the dimesion tables are mapped to SID tables.
1) So find the SID from Stable for your PO.
2) Find the Dimension for the above SID from Dimesion table.
3) find out the records from Fact table with the above dimesion.
Anil Kumar Sharma .P