Skip to Content
0
Former Member
Dec 19, 2007 at 05:47 PM

ODS for DataSource 0EC_PCA_3

49 Views

Hi Everybody

I need to use DataSource 0EC_PCA_3 to get the line detail of Profit Center. Due to some functional requirements I need to put the information in an ODS (then it will be loaded to several InfoCubes).

My problem is that I need to set an Key for the ODS and I don't know this DataSource in detail. Can any of you tell me which fields/infoobjects I have to use for the Key according to your experience?

In R/3 the GLPCA table uses the GL_SIRID as Primary Key and that fields is not coming in the DataSource.

For each record in the GLPCA table there are 3 records in the extractor (due to the several currencies) so I think that 0CURTYPE should be in the PK but... what else?

Thanks in advance.

Kindly regards. G.