It is a very common requirement to define attribute for a dimension when using BPC as a planning solution. In BPC standard model, we just need to add a new field in web admin, and value maintenance is also very straightforward.
How can we do that for virtual master data in BPC optimized for S/4 HANA, which is based on BPC Embedded model?
As the name indicates, the master data of “virtual master data” is not physically saved in BW but S/4. For example, master data of GL Account comes from SKA1 table. If the attribute you need is not defined in this table, then no related information could be provided from S/4 side.
We can’t change the structure of SKA1 to add some planning specific fields, so we need to create a new table to hold that attribute information. Below is the steps needed.
Firstly, create a new table for store the extra master data information. Make sure the key fields of host master data table is included in this new table. For example, if we’ll add attributes for GL Account, then following fields should be included:
Once the table is ready, next step is to set up a join between main master data with this attribute table. Generally left outer join should be used so even no content is maintained in attribute table, the master data table could be output.
Next step is to set all the attributes from attribute table to OUTPUT in HANA view.
Once the modelling at HANA side is done, we could start to define InfoObject in BW, just like the traditional way to add a new attribute for existing InfoObject.
Last step is to set up mapping between the InfoObject and field we expose in HANA view.