Skip to Content
0

FMS for Cost Center in Row

Feb 24, 2017 at 02:48 AM

103

avatar image

Hi Experts!

I need help with building an FMS for my Cost Center.

I have set up several Cost Centers in SAP namely

Dimension 1 - left this blank for future purposes

Dimension 2 - Department

Dimension 3 - Section

I have 2 departments that has Sections namely:

Department: Finance

Sections: Choices would either be ACCOUNTING or MIS

Department: Supply Chain

Sections: Choices would either be PURCHASING or LOGISTICS

Now, when a user chooses FINANCE for the Dimension 2 (DEPARTMENT), I only want to show either ACCOUNTING or MIS for Dimension 3 (SECTION)

As seen on the screenshot below, 203 is Department FINANCE. But when choosing the from the list of SECTIONS, it generated all cost centers under the Dimension 3. I only want to show ACCOUNTING and MIS for the choices. Same with SUPPLY CHAIN, when this i chosen, I only want to see PURCHASING and LOGISTICS.

Would appreciate your help. Thank you!

1.jpg (105.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Rizki Wicaksana Feb 24, 2017 at 08:34 AM
1

Hai Nikka,

To solve your problem :

1. Create UDF in cost centers. For example ParentCostCenter. You can fill Finance as Parent Cost Center of ACCOUNTING.

2. Create FMS in your cost center column (Section)

3. Use this query :

SELECT T0.[PrcCode] FROM OPRC T0 WHERE T0.[DimCode] =3 and T0.[U_ParentCostCenter]=$[$38.2003.0]

Note :

$[$38.2003.0] => It shows your dimension 2 column (Department).

Regards,

Rizki

Share
10 |10000 characters needed characters left characters exceeded
Agustin Marcos Cividanes Feb 24, 2017 at 09:55 AM
0

Hi

the dimensions in cost center are different ways to see the information.

If you want to do this you have to create a jerarquical structure with user defined fields as @Rizki Wicaksana answered, and you have to use FMS to populate the fields.

Agustín

Share
10 |10000 characters needed characters left characters exceeded