How to merge PCA and SD data

[Former Member]

Hello Friends

This is my scenario. I have PCA Line item ODS and SD Billing ODS which has SHIP_TO field. I want to get the SHIP_TO field from Billing ODS for PCA Documents. I tried with multicube but it doesn't work. Any suggestion is appreciated.

thanks

sam

[dielom · Accepted solution]

Hi,

You may provide more information for detailed answer (datasources, fields, etc).

As a first impression, i think that it may be a little difficult to join that information, since PCA data is consolidated and not in a document level. and it depends on the structure of both ODS.

You may try to do this by material, but, i can't make sure of this. try to get a functional specification for this cases.

Hope this helps.

Regards,

Diego

[Former Member]

Thanks Diego and Prakash for your response. Currently i am working on this issue. I awarded points for your helpful answer.

thanks

sam

[Former Member]

Hi Dr,

The PCA stream brings in all kinds of data, SD, IM, FI etc. So the PCA line item data source (either 0EC_PCA_1 or 0EC_PCA_3) both bring data from SD too. which means it would jhave Sales document number.

So why dont you enhance the PCA datasource with just that one field of SHIP_TO. It woyld be pretty straightforward as you just need one field from SD.

So enahnce the PCA datasource and write code in the user exit in R/3 for transaction datasources and populate this field. Hope you are clear. If not let me know.

Prakash

PS: do assign points if this makes even a little bit of sense!