Purpose

The purpose of this document is to define the conversion approach for the object 2015 - Material Master Costing View 2
in S/4 HANA.

The Costing View 2 of the Material Master holds plant-specific costing parameters used in cost estimates, valuation, and financial planning. It complements Costing View 1 and is critical for materials with BOM/routing-based costing.

The key data maintained in the Costing View 2 of the Material Master is mainly the planned price and the date it is effective from for the relevant material. It is supplementary view and derives most of the information from the Costing View 1 of the Material Master. The fields for maintaining the Planned Prices are applicable dates are part of the table MBEW (Material Valuation)

 The Costing View 1 and 2 of the Material Master in S4HANA is similar to that of ECC which is defined by the table MBEW however below changes in S4HANA become important considerations for the conversion:

• The Table MBEW is still applicable but due to introduction of Universal Journal, the costing data is integrated 
• Material Ledger activation is mandatory in S4HANA even though actual costing for some Company Codes may not be applicable
• The planned prices as stored in MBEW will be dependent upon To Be design and accordingly picked up in the costing runs

In SAP ECC, the costing view 2 is maintained for Materials which are mainly as below 

(Reference: PF2 - Approx number of Materials - 4300 where the planned price is maintained)

• Material Ledger is active for the Valuation Area
• The Valuation Classes are as below:
  • Z000 - Main Raw Ma
  • Z100 - Finished Goods Manufacturing
  • Z050 - Other Raw Materials
  • Z051 - Packaging 
• The Costing View 2 is also maintained for some other valuation classes and also for materials where ML active indicator is blank. 
• Materials with blocked or marked for deletion status
  These cases will need to be validated and cleansed as part of the Master Data Services (MDS) process prior to migration.

(Reference: WP2 - Approx number of Materials - 30 where the planned price is maintained)

• Material Ledger is not active for the Valuation Area
• The Valuation Classes are as below:
  • Z100 - CS Raw Materials
  • Z110 - CS Packaging
  • Z130 - Trading Goods
  • Z150 - Finished Products

• Materials with blocked or marked for deletion status
  These cases will need to be validated and cleansed as part of the Master Data Services (MDS) process prior to migration.

The target design in S4HANA for maintaining the Planned Prices and effective dates as of now is relevant only for valuation classes pertaining to Raw Materials, Semi Finished and Finished Goods. This will be based on the value mapping of Valuation Classes between source and target.

The converted records will be loaded into the target S/4HANA system as overall load of Material Masters including different view, using standard SAP LTMC for Material Master.

Conversion Scope

The scope of this document covers the approach for converting the costing view 2 of the Material Master from Legacy Source Systems into S/4HANA following the Data Object DD-FUN-050 Master Data Standard_2015-Materials Costing 2. The Planned Prices (Fields MBEW-ZPLP1 to MBEW-ZPLP3 and corresponding dates (Fields MBEW-ZPLD1 to MBEW-ZPLD3) as per the intended design <TBC> will be applicable for only valuation classes pertaining to Raw Materials (Type ROH)

The data from legacy system includes:

1. Active Material Master that are in use (Production or Procurement) -Materials are relevant in table MARA (General Material Data) and MARC (Plant Data for Material)
2. The Materials must exit in table MBEW for Valuation Area (reference table T001K) or Company Code (Reference Table T001) in scope for conversion
3. Active Material Masters where one of the Prices, Standard (Fields MBEW-STPRS) or Moving Average (Field MBEW-VERPR) is not blank
4. The BOM must exist if the Material has "With Quantity Structure" (Field - MBEW-EKALR) indicator active
5. Active Material Masters where one of the Planned Prices (Fields MBEW-ZPLP1 or MBEW-ZPLP2 or MBEW-ZPLP3) is maintained

The data from legacy system excludes:

1. .

The data from legacy system excludes:

1. Material for which there is no stock available in "Total Stock (Field MBEW-LBKUM)
2. Material
3. Material for which there is no stock available in "Total Stock (Field MBEW-LBKUM)
4. Material pertaining to valuation classes which 

List of source systems and approximate number of records

(Note: Target numbers expected to be lower after cleansing)

Additional Information

Multi-language Requirement

Not applicable

Document Management

Not applicable

Legal Requirement

Not applicable

Special Requirements

No localization or specific requirements

No third-party system relevant for source 

Target Design

The target technical design based on the Master Data Standard for the object 2015 - Material Master Costing View 2 is as follows:

The technical design of the target for this conversion approach.

Data Cleansing

The data source will be from PF2 and WF2 systems for the active Company Codes and Plants in scope for S4HANA migration. The  

1. Data cleansing

1. will be based on the relevancy as defined in Conv Spec 2010 (Materials - General Plant Data / S.Loc Data) and 2019 (Materials – Basic View).

The data cleansing/relevancy check to be done in Synity Syniti based upon the To-be valuation classes relevant for Material Costing View 2. The Data cleansing reports will be same as those mentioned in the Conversion Specification for the object 2012 - Material Master Accounting View 1

Conversion Process

The generic high-level process for the conversion is as below:

1. Extraction:
   1. Extract from the source systems: Apply the selection parameters and data relevancy as mentioned in this specification, from the relevant tables
   2. DCT: The DCT to be prepared if the data to be transformed and is part of the load file is not available in the Source system
2. Transform 
   1. Transform fields by applying the fields and value mapping in the Syniti 
   2. Generate and validate Pre-load files
3. Load
   1. Load the validated Pre-load file using SAP's LTMC or the custom upload program as applicable. 

For the object 2015 - Material Master, Costing View 2, the extraction is from MBEW table and the transformation will happen in Syniti as part of overall material master data and will be loaded in the target using LTMC.

Data Privacy and Sensitivity

Extraction

Extract data from a source into Syniti. There are 2 possibilities:

1. The data exists. Syniti connects to the source and loads the data into SynitySyniti.  There There are 3 methods:
   1. Perform full data extraction from relevant tables in the source system(s).
   2. Perform extraction through the application layer.
   3. Only if Synity cannot Syniti cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
2. The data does not exist (or cannot be converted from its current state).  The data is manually collected by the business directly in Synity Syniti. This is to be conducted using DCT (Data Collection Template) in SynitySyniti.

The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads

Extraction Run Sheet

Selection Screen

Selection Screen

Data Collection Template (DCT)

Target Ready Data Collection Template will be created for Object 2014 Material Master - Accounting View 2 data with exception of some fields which require transformation as mentioned in the transformation rule.

CNV 2015 - As the data is from the source systems PF2 and WP2 and will be transformed along with other views of the Material Master, the DCT is not applicable.

Extraction Dependencies

Transformation

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 to make the data Target ready:

1. Perform value mapping and data transformation rules.
   1. Legacy values are mapped to the to-be values (this could include a default value)
   2. Values are transformed according to the rules defined in
2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation

Transformation Run Sheet

(only for enrichment, as of now this is a provision for DCT)

2015 - Material Master 2 Costing View 
DCT Rules

Extraction Dependencies

Transformation

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 to make the data Target ready:

1. Perform value mapping and data transformation rules.
   1. Legacy values are mapped to the to-be values (this could include a default value)
   2. Values are transformed according to the rules defined in
2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation

Transformation Run Sheet

Transformation Rules for extraction

Transformation Rules for DCT

Transformation Rules

Transformation Mapping

Transformation Dependencies

Pre-Load Validation

Project Team

Completeness

Accuracy

Business

Completeness

Accuracy

Load

The load process includes:

1. Execute the automated data load into target system using load tool which is LTMC. 
2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation

Load Run Sheet

Load Phase and Dependencies

The load phase for this object is ideally relevant for Pre-Cutover. TBC by S2P team.

Configuration

Below configurations/master data should be available for this object to be loaded successfully

Conversion Objects

Error Handling

Post-Load Validation

Project Team

Completeness

Accuracy

Business

Completeness

Accuracy

Key Assumptions

• Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
• Data object 2015 is in scope based on data design and any exception requested by business.
• The load for this object will be performed along with/ as parr of overall Material Master Load 

See also

Change log