Country dimension for Expense Reporting not working for Subledger and Concur

[VirendraSharmaFICO]

Dear Community,

We have business requirement of reporting operating expenses by Country.

Recently, SAP has enabled new additional accounting dimensions in general ledger line items and analytical reports needed for insurance carriers: product group, branch, data source, customer country/region, customer group, customer industry.

However, there are certain limitation with the Country/Region field as listed below:

- Field country is not available for Fiori app 'Create Supplier Invoice'

- Value in country field is updated in Concur and same is getting populated in Concur payload file. However, it's not getting filled in S4 accounting document. We tried to explore Substitution rule for Concur via Fiori app 'Manage Concur Substitution Rules' to update the same in S4 accounting document, but field Country is not available in target field of substitution rule.

- Similarly, we are facing issue to update country value for Fixed Assets posting. We are unable to update it for depreciation posting. We tried to build substitution rule for Fixed Asset Posting via Fiori app 'Manage Substitution/Validation Rules for Asset Posting', but field country is not available in target field of substitution rule. 

Any inputs would be appreciated.

Regards,

Virendra Sharma

[HenrikeGrtecke]

Hello, thank you for your question. It has been forwarded to the experts. Kind regards, Henrike

[Mick]

Hi Virendra,

Financial Accounting operates multi-dimensional on GAAP whereas the legal entity Company explicitly belongs to one country. We do not understand why the accounting documents should carry a country ISO code. Especially for the depreciation posting run we do not see any need to fill redundant information. 

In any way, you should request new functionality via a CIP request und specify the business/legal need.

Best, 
 Mick

[andyschaefer]

Hi Virendra,

[andyschaefer]

Hi Virendra, do you really need that reporting in FI for expense reports? Why not use the reporting that is already available for Concur data, e.g., Spend Control Tower?

[Chuma]

Hello @VirendraSharmaFICO 

What you’re observing is expected in S/4HANA Public Cloud Edition today

The insurance details, such as Customer Country/Region, are supplied for analytical purposes. They are integrated into reports via data source extensions but are not accessible as input or target fields in Create Supplier Invoice, Manage Concur Substitution Rules, or Asset Posting substitutions. Therefore, they cannot be populated during AP entry, import into Concur, or depreciation processes run. SAP Help Portal-Add Dimensions to the Analytical Apps Using Data Source Extensions

Practical options supporthe ted by cloud

Put a country value on the FI document (ACDOCA):

• Create a custom field for the Journal Entry, Item in Custom Fields and Logic. Be sure to enable it for Create Supplier Invoice, Advanced, and other relevant options to ensure everything works smoothly reporting. SAP Help Portal-App Extensibility: Create Supplier Invoice - Advanced
• Map Concur’s country into the custom field, following the SAP’s Concur→S/4 journal extension pattern. SAP Community-Extending Journal Content and Structure with SAP Concur Expense Data

If you only need analytics:

• Keep the country in concur and include it in analytics (SAC/embedded) with the journal lines, or display the insurance dimensions in GL reports via data source extensions. SAP Help Portal-Add Dimensions to the Analytical Apps Using Data Source Extensions

For Fixed Assets/depreciation:

• You cannot replace a standard “country” target in this context today. If you require expenses broken down by country, use Universal Allocation (in the Margin Analysis or Manage Allocations section) to allocate or split costs by country at the end of the period into dedicated accounts or characteristics. SAP Help Portal-Universal Allocation

Product gap:

• If you require the standard Country/Region dimension to be writeable in AP/Concur/FA flows, submit a request via SAP Continuous Influence. SAP Community-Finance in SAP S/4HANA Cloud Public Edition 2402

The standard insurance dimensions are mainly for reporting. To track expenses by country in FI now, you can use a custom JE item field combined with Concur mapping, or you can calculate it at the end of the period using Universal Allocation.

With kind regards

Chuma