High- Level Specification
| Parameter | Value |
|---|---|
| Application System | S/4 HANA |
| Business Process Reference | 06.10.02.01. Manage Inbound Deliveries 09.11.01.05. Perform Operational Reporting for General Ledger Accounting |
Functional Overview
The main purpose of this custom development is to facilitate detailed cost and spend reporting based on material group information in financial reports in S/4 HANA. Due to limitations of SAP standard as explained further in SAP note '2843578 - S/4 HANA Finance: Attribute assignment for material inventory lines' the material group is now available as a table field but it is only populated for specific posting scenarios which is insufficient for comprehensive cost analysis on financial reporting. By implementing this custom development, the material group will be available for all material movements recorded in the system and all financially-relevant relevant sales as well as purchasing transactions and therefore allows for a holistic and flexible reporting of financial costs and spend based on the material group classification defined in S/4 HANA.
Scope and Objectives
In SAP standard, the material group is only captured for integrated, sales-related financial postings in the financial line item tables used for Financial reporting in S/4 HANA. The material group is equally if not more important for cost and spend analysis in integrated, procurement-related financial postings as it provides further and more detailed insights into the nature of the costs that may not always be obvious from just looking at the G/L account used for the financial posting. The Chart of Accounts in S/4 HANA has been condensed to a large extend under the premise that auxiliary reporting dimensions such as the material group can be used for a more detailed and granular analysis of costs incurred in the operational activities of an organization in financial reporting. The material group
The scope of this development therefore includes the following components:
- Derivation and capture of material group attribute from the material master data where available in the universal journal ledger (technical table name: ACDOCA) in S/4 HANA
- Derivation and capture of material group attribute from purchase order line item where no reference to a material is provided in the universal journal ledger
- Derivation and capture of material group description in universal journal ledger in custom field.
- Ensure custom field added to universal journal ledger is available for reporting across all key Finance reporting applications used in S/4 HANA.
Step | Description | Comment |
|---|---|---|
| 1 | Financial posting executed by end user. | This posting can come from various source applications and processes such as goods receipt, invoice receipt, process order settlement, etc. |
| 2 | Check if material group is populated in universal journal ledger. | In some scenarios as explained in note 2843578 the material group is populated automatically. In this case, no further action is required. |
| 3. | Posting contains reference to purchase order line item. | The material group used in the purchase order should take preference over the material group assigned in the material. Spend analysis between Procurement and Financial reporting based on material groups must be in sync. |
| 3 | Derive material group from purchase order line item captured in universal journal ledger record. | The material group should be directly read from the purchase order line item if a PO reference is present in the financial line item record. |
| 4 | Posting contains reference to material but no purchase order details. | Should a material movement be posted without a reference to a PO and the material group does not get determined by SAP standard behavior, it shall be derived from the material master. |
| 5 | Derive material group from material captured universal journal ledger record. | |
| 6 | Derive material group text and capture it in universal journal ledger custom field. | Ideally the material group text should be stored in a custom field in ACDOCA for easier identification of the actual spend category. |
| 7 | Execute financial report and drill-down by material group and material group description. | The fields for material group and material description can be added as drill-down dimension in key Finance reports used in S/4 HANA. |
Assumptions
- All purchase order line items are created in the system with at least a material group assignment.
- All materials are assigned to exactly one material group in the material master.
- If the purchase order line item is pointing to a material group which is different to the material group defined in the material master record of the purchased material, the material group used in the purchase order line item shall be taken for updating the Financial line item table. This is to keep the Financial reporting in sync with the Procurement spend reporting by material group.
- Financial cost and spend reporting in S/4 HANA will be based on the universal journal ledger (ACDOCA) and not the classic FI line item table (BSEG)
Dependencies
- Testing of this functionality will only be possible with a representative set o materials and material groups created in the system that follow the target design of those objects in the new S/4 HANA systems.
Security, Integrity and Controls
No specific requirements for authorization checks identified. For the CUI instance, the overarching export control principles shall apply and data shall be masked as per CUI classifications.
Apart from that, for this custom development the calling program's s authorization checks shall be followed.
Configuration Requirements
Language Requirements
Special Requirements
Design Rationale
Functional Requirements
Proposed Technology to Use
Data Source Considerations
| Table | Field Name | Comments/Calculation/Field Manipulation |
|---|---|---|
Data Validation Considerations
| Table | Field Name | Comments/Calculation/Field Manipulation |
|---|---|---|
Custom Tables
Master Data
| Field | Description | Data Type/Length | Validation rule/ Value Help |
|---|---|---|---|
Configuration Table
| Field | Description | Data Type/Length | Validation rule/ Value Help |
|---|---|---|---|
Selection Screen Enhancement
| Field Name | Description | Select: | Data Type/Length | Default Value/ Validation rule/ Value Help | Selection Logic |
|---|---|---|---|---|---|
Processing Logic
Volumetrics
Performance Considerations
Error Handling
Testing
How to Test
Test Conditions and Expected Results
| ID | Condition | Expected Result |
|---|---|---|
Test Considerations/Dependencies
Other Information
Development Details
Package
| Package Name | Parent Package |
|---|---|
Enhancement Implementation
| Enhancement Type | Standard Definition Name | Custom Implementation Name | Design Rationale Reference |
|---|---|---|---|
Other Development Objects
| Object Type | Object Name | Purpose/High Level Logic | Design Rationale Reference |
|---|---|---|---|
Appendix
Custom Authorization Group Naming Convention
This table is based on the Syensqo development standards document. It provides the naming conventions for authorization groups to associated with custom reports and tables to comply with security requirements.
ABAP | ZFI | ZMM | ZPS | ZCO | ZSD | ZBC | ZFI | ZCA |
|---|---|---|---|---|---|---|---|---|
| TABLES | ZFIT | ZMMT | ZPST | ZCOT | ZSDT | ZBCT | ZFIT | ZCAT |