| Status | |
| Owner | |
| Stakeholders |
The purpose of this document is to define the conversion approach for the object 2012 - Material Master Accounting View 1 in S4HANA.
The document details out the field list, extraction criteria, scoping, mapping, transformation logic, generation of the pre-load file and loading of the same with respect to the object 2012- Accounting View 1 of the Material Master.
The accounting view governs how a material is valuated financially within a specific valuation area (typically plant or company code). It directly influences inventory valuation, cost accounting, and integration with the General Ledger Accounting.
Key data/fields maintained in the Material Master- Accounting View 1 are as below:
General Valuation Data
These section of the Accounting View 1 of the Material Master contains the fields that controls the valuation behavior and integration.
Prices and Value
These section of the Accounting View 1 of the Material Master contains the fields that stores the prices and values of a Material.
The Accounting View 1 and 2 of the Material Master in S4HANA is similar to that of ECC which is defined by the table MBEW and MBEWH however below changes in S4HANA become important considerations for the conversion:
In SAP ECC, the Accounting View 1 is maintained for Materials which are mainly as below
Reference: PF2 - where the total value is more than 0.
| Index | Valuation Class | Valuation Class Description | Records with Price Control S | Records with Price Control V | Total |
|---|---|---|---|---|---|
| 1 | Z000 | Main Raw Materials | 1247 | 59 | 1306 |
| 2 | Z049 | Interplant Raw Material | 2 | 0 | 2 |
| 3 | Z050 | Other Raw Materials | 112 | 93 | 205 |
| 4 | Z051 | Packaging | 800 | 340 | 1140 |
| 5 | Z053 | Semi-Finished Goods | 2 | 0 | 2 |
| 6 | Z054 | Utilities | 3 | 1 | 4 |
| 7 | Z055 | Gen & tec goods non packg | 2423 | 89963 | 92385 |
| 8 | Z057 | Waste | 39 | 7 | 46 |
| 9 | Z058 | Spare Parts | 5 | 8397 | 8402 |
| 10 | Z05A | Assets- Quantity mgmt | 1 | 167 | 168 |
| 11 | Z05L | Solid Fuels | 0 | 4 | 4 |
| 12 | Z05P | Light Fuel Oil | 0 | 1 | 1 |
| 13 | Z05R* | Gen & tec goods non packg | 0 | 7 | 7 |
| 14 | Z05Y* | Utilities | 0 | 2 | 2 |
| 15 | Z061* | Semi-Finished Goods | 50 | 24 | 74 |
| 16 | Z100 | Finished Goods | 2985 | 2324 | 5309 |
| 17 | Z101 | Finished Goods Purch. | 100 | 3168 | 3172 |
| Total | 7770 | 104458 | 112228 |
Note:
Reference: WP2 - where the total value is more than 0.
| Index | Valuation Class | Valuation Class Description | Records with Price Control S | Records with Price Control V | Total |
|---|---|---|---|---|---|
| 1 | Z100 | CS Raw Materials | 4987 | 378 | 5365 |
| 2 | Z110 | CS Packaging | 1946 | 573 | 2519 |
| 3 | Z120 | CS Spare Parts | 0 | 126159 | 126159 |
| 4 | Z125 | CS Spare Parts assets IFRS | 0 | 33 | 33 |
| 5 | Z130 | CS Trading Goods | 1171 | 59 | 1230 |
| 6 | Z140 | CS Intermediates | 1232 | 0 | 1232 |
| 7 | Z150 | CS Finished Products | 6166 | 1 | 6167 |
| 8 | Z160 | CS Spare Parts consum>BOM | 0 | 2265 | 2265 |
| 9 | Z170 | CS Other operating supplies | 0 | 442 | 442 |
| 10 | Z175 | CS Office supplies | 0 | 156 | 156 |
| Total | 15502 | 130066 | 144568 |
Note:
The target design in S4HANA for maintaining the Accounting View is as below
The converted records for Material Master - Accounting View 1 will be loaded into the target S/4HANA system as overall load of Material Masters including different view, using standard SAP LTMC.
The scope of this document covers the conversion approach for the Object 2012 - Material Master Accounting View 1 from Legacy Source Systems into S/4HANA following the DD-FUN-050 Master Data Standard_2012-Materials Accounting 1
The materials relevant for valuation will be either having the price control indicator (MBEW-VPRSV) as S-Standard or V-Moving Average and accordingly the applicable price will be either maintained upon creation of a new material or updated based on the material movements.
For the purpose of the conversion, the standard price will be maintained in the field MBEW-STPRS (Standard Price) along with relevant price determination which will be used to arrive at the Total Value (MBEW-SALK3) upon the initial stock upload using movement type 561.
Data Relevancy for object 2012:
The data from legacy system includes:
The data from legacy system excludes:
For the purpose of conversion, only those records which are active in Base table MARA and have a stock value will be considered. Accordingly, below approximated number of records are considered as scope for conversion, which may be reduced after cleansing.
| Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|
| PF2 | Materials Masters, active in table MARA, with value (MBEW-SALK3) not equals to 0 (Zero) | 112250 | S4HANA | 112250 |
| WP2 | Materials Masters, active in table MARA, with value (MBEW-SALK3) not equals to 0 (Zero) | 144600 | S4HANA | 144600 |
Not applicable
Not applicable
Not applicable
Below are the special requirements with respect to Material Master Accounting View 1:
No localization or specific requirements
No third-party system relevant for source
The to be target design relevant for Accounting View 1 of the Material Master based upon the MDS "DD-FUN-050 Master Data Standard_2012-Materials Accounting 1" is as below:
The technical design of the target for this conversion approach.
Table | Field | Data Element | Field Description | Data Type | Length (Decimals) | Requirement |
MBEW | MATNR | MATNR | Material Number | CHAR | 18 | Required |
MBEW | BWKEY | BWKEY | Valuation Area | CHAR | 4 | Required |
MBEW | BWTAR | BWTAR | Valuation Type | CHAR | 10 | Not in use |
| MBEW | BKLAS | BKLAS | Valuation Class | CHAR | 4 | Required |
MBEW | MLAST | MLAST | Price determination indicator | CHAR | 1 | Required |
MBEW | PEINH | PEINH | Unit price | DEC | 5 | Required |
MBEW | BWTTY | BWTTY | Valuation Category | CHAR | 1 | Optional |
MBEW | STPRS | STPRS | Standard Price | CURR | 13 | Required |
MBEW | MLMAA | CK_ML_MAAC | Material Ledger Active | CHAR | 1 | Required |
For the purpose of the Object 2012 - Material Master Accounting View 1, the data cleansing should happen in the source systems PF2, WP2 as per below cleansing activity. The business cleansing is expected to be done by the business.
Based upon the above rules for cleansing, the data will be extracted from source systems WP2, PF2 and will be checked in Syniti. The below checks to be done and reports to be generated
ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
1. | High | Material is not valid | Check MATNR is available in MARA and MARC table | Report showing records in error | PF2, WP2 |
2 | High | Check Material MATNR and Valuation Class | Valuation Classes not relevant for this view (to be maintained in the Syniti) | Report showing records in error | PF2, WP2 |
3 | High | Material with no stock | Check Material MATNR is not having LBKUM (Quantity) lower than or equal to 0 | Report showing records in error | PF2, WP2 |
4 | High | Material with no value | Check Material MATNR is not SALK3 (Value) lower than or equal to 0 | Report showing records in error | PF2, WP2 |
However, with respect to object 2012- Material Master - Accounting View 1, the conversion process will depend upon the overall cutover/migration strategy <To be finalised by Functional team>, in view of the mandatory Material Ledger activation in S4HANA. The common practice/approach and steps followed are as below:
As of now, this conversion specification is meant for updating the Accounting View 1 of the Material Master as part of the Material Master Load.
Standard LTMCs for Material Master and Material Valuations to be used.
Data Privacy and Sensitivity
Not applicable except materials having export control.
Extract data from a source into Syniti.
There are 2 possibilities:
The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads
Req # | Requirement description | Team responsible |
1. | Extract from table MBEW all MATNR (material masters) where MBEW-BKLAS (Valuation Class) is not blank | Syniti Team |
2. | Extract from table MBEW all MATNR (material masters) where MBEW-SALK3 (Total Value) is not blank | Syniti Team |
3. | Extract from table MBEW all MATR (material masters) where MBEW-LBKUM (Total Stock) is not blank | Syniti Team |
4. | Repeat Req # 1 to 3 if required | Syniti Team |
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
SE16N Table MBEW | Material (MATNR) | NA | Leave Blank | |
SE16N Table MBEW | Valuation Area (BWKEY) | Multiple | Yes | Enter the legacy Valuation Areas (Plant) |
SE16N Table MBEW | Total Stock (LBKUM) | Selective | Yes | "Select not equal" Value to be entered: Blank |
SE16N Table MBEW | Total Value (SALK3) | Selective | Yes | "Select not equal" Value to be entered: Blank |
SE16N Table MBEW | Valuation Class (BKLAS) | Selective | Yes | "Select not equal" Value to be entered: Blank |
2012 - Material Master 1 Accounting View
DCT Rules
Field Name | Field description | Rule |
MBEW-MATNR | Material | Material Number for which Price needs to be maintained |
MBEW-BWKEY | Valuation Area | Business to enter Plant of the Material |
MBEW-PEINH | Price Unit | Business to enter price unit if the Material Price unit is changing from legacy |
MBEW-MLAST | Price determination indicator | Business to enter price determination indicator as 2 for the case without ML actual costing, or MAP or 3 for the case of actual costing to be run for the material |
MBEW-VPRSV | Price Control | Business to enter S for Standard or V for Moving Average Price |
MBEW-STPRS | Standard Price | Business to enter standard price if the Material has price control as S |
MBEW-VERPR | Moving Average Price | Business to enter standard price if the Material has price control as V |
Extraction Dependencies
Below dependencies apply for extraction.
Item # | Step description | Team responsible |
1. | Any period / year end close activities including costing runs have been fully completed | Business |
2. | Data Cleansing (such as setting the Flag for Deletion at Master level) has been done | Business |
3. | The total value is reconciled in MM and FI | Business |
4 | The prices and units to be loaded have been confirmed and reconcile to total value to be loaded | Business |
The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow Syniti to make the data Target ready:
Item # | Step description | Team responsible |
1. | Ensure all the fields that require value mapping, as stipulated Mapping tables, have the latest signed-off mapping files imported into Syniti | Data team |
2. | Ensure that signed off value mappings have been maintained in the Syniti | Syniti team |
3. | Confirm the value mappings as maintained in the Syniti | Data team |
4. | Ensure that Signed off DCT from business has been received and maintained in Syniti | Syniti/Data team |
5 | Execute transformation for the object | Syniti team |
6 | Monitor the transformation progress and ensure performance and completion is within allowed timeframe | Syniti/Data team |
7. | Generate Pre-Load reports. | Syniti team |
8. | Generate data load count. | Syniti team |
9. | Log errors as defects, if any and address resolutions. Close defects. | Syniti/Data team |
10. | Re-transform and re-validate the Pre-load reports if necessary. | Syniti/Data team |
11. | Validate the transformed file as part of pre-load validation, raise data defects or provide the pre-load sign-off. | Business |
12. | Analyse and resolve any pre-load defects logged by business. | Syniti/Data team |
13. | Repeat steps 5 to 11 if necessary | Syniti/Data team |
14. | Proceed to pre-load validations | Data team |
Transformation Rules
Rule # | Source system | Source Table | Source Field | Source description | Target system | Target Table | Target Field | Target description | Transformation logic |
| 1 | PF2/WP2 | MBEW | MATNR | Material | S4HANA | MBEW | MATNR | Material | Source Material Number to Target Material Number |
| 2 | PF2/WP2 | MBEW | BWKEY | Valuation Area | S4HANA | MBEW | BWKEY | Valuation Area | Value Mapping for Valuation Area/ Valuation Class |
| 3 | PF2/WP2 | MBEW | BKLAS | Valuation Class | S4HANA | MBEW | BKLAS | Valuation Class | Value Mapping for Valuation Area/ Valuation Class |
| 4 | PF2/WP2 | MBEW | BWTAR | Valuation Type | S4HANA | MBEW | BWTAR | Valuation Type | Leave Blank |
| 5 | PF2/WP2 | MBEW | MLAST | Price determination indicator | S4HANA | MBEW | MLAST | Price determination indicator | 2 for the case without ML actual costing, or MAP 3 for the case of actual costing to be run for the material (Value as per DCT) |
| 6 | PF2/WP2 | MBEW | PEINH | Unit price | S4HANA | MBEW | PEINH | Unit price | Value as per DCT |
| 7 | PF2/WP2 | MBEW | VPRSV | Price Control | S4HANA | MBEW | VPRSV | Price Control | Value as per DCT |
| 8 | PF2/WP2 | MBEW | STPRS | Standard Price | S4HANA | MBEW | STPRS | Standard Price | Value as per DCT or leave blank |
| 9 | PF2/WP2 | MBEW | VERPR | Moving Average Price | S4HANA | MBEW | VERPR | Moving Average Price | Value as per DCT or leave blank |
| 10 | PF2/WP2 | MBEW | MLMAA | Material Ledger Active | S4HANA | MBEW | MLMAA | Material Ledger Active | Set to X "active" |
Mapping Table Name | Mapping Table Description |
Material | Mapping of Old vs New Material based on the Source MATNR number to target MATNR |
Valuation Area | Mapping of legacy ECC valuation area to S4HANA valuation area |
Valuation Class | Mapping of legacy ECC valuation area to S4HANA valuation area |
| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Ensure all the fields that require value mapping, as stipulated Mapping tables, have the latest signed-off mapping files imported into Syniti | Data team |
| 2 | Ensure that signed off value mappings have been maintained in the Syniti | Syniti team |
| 3 | Confirm the value mappings as maintained in the Syniti | Data team |
| 4 | Ensure that Signed off DCT from business has been received and maintained in Syniti | Syniti/Data team |
| 5 | Confirm on the extracted values | Syniti, Data and business |
Task | Action |
Generation of | Mandatory field check. Profit Centre Hierarchy Mapped to new values Person Responsible / HR positions mapped to new values |
Record Count Confirm the record counts in preload summary report Total Records: Valid Records: Invalid Records: |
Task | Action |
Mandatory field mapping and transformation | Obtain a list of the fields to be populated with values from mapping files and ensure all these fields contain S/4HANA values. |
| Task | Action |
|---|---|
| Verify record count in Pre-load reports by region | Confirm the Preload File contains all the records in scope of migration ( Based on list of profit centres mapped from old to new ) |
| Task | Action |
|---|---|
| Conversion accuracy | Verify Profit Centres are transformed accurately as per endorsed transformation/mapping rules. Review error reports in tool for any mismatch or missing transformed values. In legacy system, execute ECC tcode SE16N to display table CEPC to confirm copied fields are accurately copied. If any of the sum is different, raise defect and flag the relevant record as error. |
The load process includes:
Item | Step description | Team responsible |
1 | Ensure the load tools are transported into the correct tool instance. | Data team |
2 | Ensure DCTs and all required mappings are submitted and complete | Data team |
3 | Ensure Pre-load sign-offs are obtained. | Data team |
4 | Execute upload of Profit Centre Object using Migration Cockpit Object for Profit Centre Upload | Data team |
5 | Generate the post load reports in tool. | Data team |
6 | Log errors as defects, if any and address resolutions. Close defects. | Data team |
7 | Resolve defects by reupload and re-generate post load reports if necessary. | Data team |
8 | Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off. | Business |
9 | Repeat steps 5 to 7 if necessary. | Data team |
Load Phase and Dependencies
Identify the phase as to “when” the load for this object will occur. <Pre-Cutover, Cutover, Post Cutover> and list the steps that need to occur before the load can commence
List the Configurations required before loading can commence
Item # | Configuration item |
1. | Controlling Area |
2. | Standard Hierarchy is Maintained |
3. | Currencies (currency keys, decimal places in currencies) |
| Object # | Preceding Object Conversion Approach |
|---|---|
| N/A |
The table below depicts some possible system errors for this data object during data load. All data load error is to be logged as defect and managed within the Defect Management
Error type | Error description | Action taken |
P | Posting period is blocked for posting | Review project / cutover plan and ensure posting periods can be opened for postings |
Profit Centre does not exist | Profit centre does not exist in company code | Ensure the profit centre mapping is correct and or create the profit centre if it is valid |
| Task | Action |
|---|---|
| Reconciliation of Record Count | Total number of records loaded for TB Balance ( PY ) will be generated in the Post-load reports in tool based on the target table and fields mentioned in section 3. The reconciliation needs to be executed on the total number of ‘valid’ records and currency amount per company code in the source compared to total number of records and currency amount in S/4HANA Record Count Check the sum of record count of the open items in the load file is the same as S/4HANA. The record count for TB Balance ( PY ) will be done on the group basis. The fields in the group are consist of: Company Code, Vendor Account Check Amount in Document Currency and Local Currency Check on line item level that the sum of the amount in Document Currency and Local Currency in the load file is the same as posted in S/4HANA. If any of the sum is different, flag the record as error. |
| Task | Action |
|---|---|
| Check values in key fields for accuracy | Post-load reports will have the same structure as the load file and some additional columns as required to facilitate the post load validation. Leverage on tool to create a Post Load report that reports S/4HANA loaded records along with the legacy values side-by-side to allow for 100% check of all these fields in the shortest possible time. Any mismatch will be reported under the Post Load - Error report. |
| Task | Action |
|---|---|
| Record Count Check | Review the record count report from the Data Team and ensure it is correct by cross-checking with the record count confirmed during Pre-load Business Validations |
| Task | Action |
|---|---|
| Open items totals | Check business partner open item totals by Business partner, Company code, profit centre. Totals should be checked in Document, Local and Group currency. |
| Spot check | Business should choose some business partners and perform comprehensive check of open items, payment terms etc Such partners should have huge number of open items or be critical for payment runs in S4 or have certain complexity in conversion. |
Any additional key assumptions.