Substitutions for Market segment using g/l account in public cloud

[suyoung_choi3]

I want to set the value of a product group in a market segment substitutions  using g/l account,
and I want to know if it is possible.

[Chuma]

Hello @suyoung_choi3 

You can configure S/4HANA Public Cloud to automatically assign the Product Sold Group during FI postings to Margin Analysis (CO-PA). This can be done either through a no-code substitution in the Accounting: Market Segment context or, if that field is not available in your tenant, by implementing a small BAdI in Custom Logic.

Open Manage Substitution/Validation Rules.

Business context: Accounting: Market Segment

Event: During Journal Entry Item

Rule type: Substitution

Condition (IF): G/L Account = your account (or use a list/range if you have more than one).

Action (THEN): Set Product Sold Group to the fixed value that corresponds to that G/L account (your 1:1 mapping).

Activate the rule and test by posting a simple journal entry to that G/L. In the posting’s Market Segment (profitability segment), confirm that Product Sold Group is filled automatically. You’ll also see it reflected in profitability reports (Product Profitability).

If "Product Sold Group" appears in the rule’s target list, you are done; no code is needed.

Let me know how it goes

Chuma

[suyoung_choi3]

Thank you for your reply. You cannot select g/l account as a precondition field in Manage Substitution and Validation Rules app's market segment context. Please check again.

[OwenLiu]

@Chuma can you please help again?

[OwenLiu]

Hello,

It seems to be available:

Rules for Substitution | SAP Help Portal

What's the error you get?

Do you mean you can't set G/L as condition?

Best Regards,
Owen

[suyoung_choi3]

I want to set the value of a specific target field in the segment as the default value for a specific account. To do that, I need to be able to specify a g/l account in the precondition field, but I can't specify a g/l account as a field in the precondition in the Manage Substitution/Validation Rules app.

[RaymondGiuseppi]

Did you already consider using  GL Account Hierarchies ?

[suyoung_choi3]

Possible in events Journal Entry Item and Coding Block but not in events market segments.

[LucyLu]

Hi,

Could you help provide more detail information about your query?

What's the rules you want to set?

Thanks

Lucy

[suyoung_choi3]

There is an g/l account that is directly posted to CO-PA through FI posting, and a specific G/L account and Product Sold Group are set to 1:1, so I want to set it automatically without the user having to input it.