Cost Center Master Data Issue for Hierarchy

[Former Member]

Hi,

We are building a hierarchy on Cost Center and realized that the way Master data on Cost Center is stored in SPM it's getting concatenated with Controlling Area. So CC 1234 becomes 1234_010 where 010 is a controlling area.

While we understand a need to make CC unique across several controlling area, it's impacting Hierarchy. In Hierarchy we only upload CC and not CA.

Do you recommend to do concatenation of CC & CA for Hierarchy as well so that it matches with Master? Or is there any other recommended way to go ?

Regards

[Former Member]

Hi,

Yes the standard functionality in SPM is to concatenate the two to create a unique value and this is how its loaded in transaction records as well. So if you want to use the standard functionality i would recommend you to build the hierarchy with concatenation.

If you have changed how transaction records are being loaded then you can change the master data accordingly.

Regards,

Rohit

[Former Member]

Hi Rohit,

That was helpful. We will certainly take concatenation route.

However in Invoice Extract File we do get CC & CA separately in XARCOCTR & XSACOARR fields respectively.

When you say that this is concatenated even on Transaction Data are you talking about data AFTER it is loaded into SPM ? Also when data is sent out to DSE will it have CC & CA concatenated ?

Regards,

[Former Member]

Hi,

Yes the concatenation happens when data is loaded into the first layer (inbound layer).

Yes when you send the data to DSE the concatenated data is sent out, because the data is sent from the first layer.

Regards,

Rohit

[Former Member]

Thanks Rohit. That was really helpful.