Skip to Content
0
Nov 08, 2012 at 08:22 AM

How to get Cost Center/Profit Center when the DataSource do not have the fields

230 Views

Hi BW gurus,

We are currently using Standard BI Content for FIAR and FIAP as following:-

0FI_AR_4 > 0FIAR_O03 > 0FIAR_C03

0FI_AP_4 > 0FIAP_O03 > 0FIAP_C03

What we need is to build a query on top of the InfoCube (or Multiprovider) and we need to include 0COSTCENTER and 0PROFIT_CTR,

but we have checked and there are no Source field from 0FI_AR_4 or 0FI_AP_4 that provide Cost/Profit Center.

Is there a way to get Cost Center and Profit Center?

Please share your knowledge if you know how, or did this before.

Any advice/help is much appreciated.

Many thanks,

Vince