Purpose
The purpose of this document is to define the conversion approach to create Measuring Point in S/4 HANA.
Measuring point represents a physical or logical place at which a status or measurement is described. E.g. Temperature of the coolant or running hours of a motor.
Conversion Scope
The scope of this document covers the approach for converting active Measuring Point from Legacy Source Systems into S/4HANA following the Measuring Point Master Data Design Standard.
At Syensqo, Measuring Points are used to monitor the condition and usage of assets. They provide critical input to support condition-based and usage-based maintenance strategies. Measuring Points are created on either Functional Locations or Equipment, depending on the asset structure and monitoring requirement.
Syensqo primarily uses the following three types of Measuring Points:
1. Static Measuring Points
Static Measuring Points are used to capture snapshot values of an asset’s condition at a specific point in time. These readings represent parameters such as temperature, pressure, or vibration. The data collected through measurement documents enables trend analysis, which helps in assessing the health and performance of the asset.
Example: Monitoring equipment temperature over time.
2. Counter Measuring Points
Counter Measuring Points are used to capture the cumulative usage of an asset. These points incrementally track metrics such as operating hours, production cycles, or distance travelled. Measurement documents recorded at these points are often used to trigger maintenance plans based on usage, as per the maintenance strategy assigned to the asset.
Example: Tracking total operating hours of a motor.
3. Catalog Measuring Points
Catalog Measuring Points utilize predefined catalog codes to record qualitative or classified conditions observed during asset inspections. These codes represent specific condition statuses or fault categories. The selected catalog entry reflects the assessment of the asset’s condition, typically after a physical or visual check.
The data from legacy system includes:
- All Measuring Points (IMPTT-MPOBJ) linked to active Functional Locations (IFLOT-OBJNR) assigned to relevant plant (IFLOT-IWERK) in scope, which excludes the following status:
- Functional Location (IFLOT-TPLNR) with System Status (JEST-STAT) Inactive "INAC"
- Functional Location (IFLOT-TPLNR) with System Status (JEST-STAT) Deletion Flag "DLFL"
- All Measuring Points (IMPTT-MPOBJ) linked to active Equipment (EQUI-OBJNR) assigned to relevant plant (EQUI-IWERK) in scope, which excludes the following status:
- Equipment with System Status (JEST-STAT) Inactive "INAC"
- Equipment with System Status (JEST-STAT) Deletion Flag "DLFL"
- Equipment with System Status (JEST-STAT) In the warehouse "ESTO"
- Equipment with System Status (JEST-STAT) Available "AVLB"
- For the relevant plants in scope, refer to Value Mapping: Plant (Maintenance Plant = Yes)
The data from legacy system excludes:
- Measuring point without Measurement Document (IMRG-POINT) created within the last 1 year (IMRG-ERDAT)
- Measuring Points which are inactive (IMPTT-INACT="X")
List of Tables to extract for this object is maintained here: Extract Table Register.
| Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|
| PF2, WP2 | Relevant Measuring Points will be extracted from PF2 and WP2 | 6,000 | S/4HANA | 6,000 |
| DCT | Measuring points for plants which do not have data existing from WP2 and PF2 | TBD | S/4HANA | TBD |
Additional Information
Multi-language Requirement
Measuring point object does not have multi language support. Description will be made available in the language required by the respective plant using EN logon.
Document Management
Not Applicable
Legal Requirement
Not Applicable
Special Requirements
Not Applicable
Target Design
The technical design of the target for this conversion approach.
1. Measuring Point (Main)
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| IMPTT | POINT | IMRC_POINT | Measuring Point | CHAR | 12 | System Generated |
| RIMR0 | MPOTY | IMRC_MPOTY | Measuring Point Object | CHAR | 3 | Mandatory |
| EQUI | EQUNR | EQUNR | Equipment Number | CHAR | 18 | Conditional |
| IFLOT | TPLNR | TPLNR | Functional Location | CHAR | 30 | Conditional |
| IMPTT | MPTYP | IMRC_MPTYP | Measuring Point Category | CHAR | 1 | Mandatory |
| IMPTT | INDCT | IMRC_INDCT | Counter (Yes/No Indicator) | CHAR | 1 | Conditional |
| IMPTT | PSORT | IMRC_PSORT | Position (Measuring Point Position) | CHAR | 20 | Mandatory |
| IMPTT | PTTXT | IMRC_PTTXT | Measuring Point Description | CHAR | 40 | Mandatory |
| CABN | ATNAM | ATNAM | Characteristic Name (Link to Class/Char) | CHAR | 30 | Mandatory |
| IMPTT | DECIM | IMRC_DECIM | Number of Decimal Places | INT | 5 | Mandatory |
| IMPTT | CODGR | IMRC_CODGR | Code Group | CHAR | 8 | Conditional |
| RIMR0 | MRMAC | IMRC_MRMAC | Upper Measurement Range Limit in Measurement Range Unit | CHAR | 22 | Conditional |
| RIMR0 | MRMIC | IMRC_MRMIC | Lower Measurement Range Limit in Measurement Range Unit | CHAR | 22 | Conditional |
| IMPTT | CJUMC | IMRC_CJUMP | Counter Over Reading | FLTP | 16 | Conditional |
| IMPTT | PYEAC | IMRC_PYEAR | Annual Counter Reading | FLTP | 16 | Conditional |
| RIMR0 | DESIC | IMRC_DESIC | Measuring Point Target Value | CHAR | 22 | Conditional |
| IMPTT | CDSUF | IMRC_CDSUF | Indicator: Valuation Code Sufficient for Measurmnt. Document | CHAR | 1 | Conditional |
2. Measuring Point (Characteristics Values Header)
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| KLAH | KLART | KLASSENART | Class Type | CHAR | 3 | Mandatory |
| INOB | OBTAB | TABELLE | Name of Database Table for Object | CHAR | 30 | Mandatory |
| KLAH | CLASS | KLASSE_D | Class number | CHAR | 18 | Mandatory |
| IMPTT | POINT | IMRC_POINT | Measuring Point | CHAR | 12 | Mandatory (Key to link to Measuring Point) |
| KLAH | STATU | KLSTATUS | Class Status | CHAR | 1 | Mandatory |
3. Measuring Point (Characteristics Values Allocation)
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| KLAH | KLART | KLASSENART | Class Type | CHAR | 3 | Mandatory |
| INOB | OBTAB | TABELLE | Name of Database Table for Object | CHAR | 30 | Mandatory |
| KLAH | CLASS | KLASSE_D | Class number | CHAR | 18 | Mandatory |
| IMPTT | POINT | IMRC_POINT | Measuring Point | CHAR | 12 | Mandatory (Key to link to Measuring Point) |
| CABN | ATNAM | ATNAM | Characteristic Name | CHAR | 30 | Mandatory |
| AUSP | ATWRT | ATWRT | Characteristic Value | CHAR | 30 | Mandatory |
| KSML | POSNR | KPOSNR | Item Number | CHAR | 3 | Mandatory |
Measuring Point Data strictly adheres to the Master Data Standard. The complete information of the key fields that hold the Measuring Point information follows the Master Data Standard document that is located here.
Data Cleansing
| ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
|---|---|---|---|---|---|
| 1012-001 | C1 | Missing Measuring Point Description | Measuring Point as per Relevancy Criteria where there are blank Measuring Point Descriptions. | Measuring Point, Description, Plant | PF2, WP2 |
| 1012-002 | C1 | Missing Measuring Point Position | Measuring Point as per Relevancy Criteria where there are blank Measuring Point Position. | Measuring Point, Description, Plant, Position | PF2, WP2 |
| 1012-003 | C2 | Duplicate Measuring Point by same Technical Object, Position | Measuring Point as per Relevancy Criteria where there is more than one Measuring Point with the same combination of Functional Location + Equipment + Position | Measuring Point, Description, Plant, FL, EQ, Position | PF2, WP2 |
| 1012-004 | C3 | Info Report: Measuring Point which with latest Measurement Document that is older than 1 year | Retrieve the latest Measurement Document of the Measuring Point and list down all the Measuring points where the Measurement Document is older than 1 year. These Measuring Points will not be loaded unless there is a measuring point within 1 year | Measuring Point, Description, Plant, FL, EQ, Measurement Document, Measurement Document Date | PF2, WP2 |
| 1012-005 | Not Applicable | External Cleansing Report: Measuring Points not in SAP | Business to create the Measuring Points in legacy as part of this cleansing activity. Note: This will be a business-led cleansing activity to be executed as part of the SyWay process. No report development by ADMM | Not Applicable | PF2, WP2 |
Note:
- Where the Plant is required in the output, retrieve the planning plant of the linked object:
- Functional Location (IFLOT-IWERK)
- Equipment (EQUI-IWERK)
- List of Cleansing is maintained here: Conversion Specs Register (DCT & Cleansing Report) (WIP)
Conversion Process
The high-level process is represented by the diagrams below.
The following represents the high-level process for Source System Extraction:
The following represents the high-level process for DCT:
Collection will be done manually in the Data Collection Template for the following scenarios:
- For sites not on SAP-PF2 or WP2 systems
Data Privacy and Sensitivity
Not Applicable
Extraction
Extract data from a source into Syniti Migrate. There are 2 possibilities:
- The data exists.Syniti Migrate connects to the source and loads the data into Syniti Migrate. There are 3 methods:
- Perform full data extraction from relevant tables in the source system(s).
- Perform extraction through the application layer.
- Only if Syniti Migrate; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
- The data does not exist (or cannot be converted from its current state). The data is manually collected by the business directly in Syniti Migrate. This is to be conducted using DCT (Data Collection Template) in Syniti Migrate
The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads.
Extraction Run Sheet
| Req # | Requirement Description | Team Responsible |
|---|---|---|
| 1 | Extract data from source system based on relevancy rule | SyWay Data Team |
Selection Screen
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
| Not Applicable |
Data Collection Template (DCT)
Target Ready Data Collection Template will be created for Measuring Point data with exception of some fields which require transformation as mentioned in the transformation rule.
Delta Data Management: Initial collection will be done via the report and one-time load to the DCT will be performed. Any delta after the initial collection within the DCT will require business to take due diligence to ensure any subsequent delta cleansing is verified and aligned within the DCT.
Note: All rules specified below should be documented as a tooltip in the DC Page.
Format:
- Line 1: Mandatory / Conditional
- Line 2: Remaining text
1. Measuring Point Data Construction Rules
| Field Name | Field Description | Rule |
|---|---|---|
| ZLegacy_POINT | Legacy Measuring Point Number | Mandatory Staging identifier used to uniquely define a Measuring Point. |
| MPOTY | Measuring Point Object | Mandatory Allowed values: IEQ: Equipment IFL: Functional Location |
| POINT_OBJECT | Measuring Point Technical Object | Mandatory If Measuring Point Object = IEQ, enter legacy Equipment > Value must exist in Equipment DCT If Measuring Point Object = IFL, enter Category A Functional Location > Value must exist in Functional Location DCT |
| INDCT | Counter (Yes/No Indicator) | Conditional Checkbox X = Yes Blank = No |
| PSORT | Position (Measuring Point Position) | Mandatory Measuring Position for the given Technical Object shall be always Unique. |
| PTTXT | Measuring Point Description | Mandatory Follow convention: Characteristic Description + Asset Tag. |
| ATNAM | Characteristic Name | Mandatory Allowed values:
|
| CODGR | Code Group | Conditional A Code Group with Naming convention U-XX-XX created for Catalog "3" - Usage Decision shall be used, must exist in Code Group DCT. |
| MRMAC | Upper Measurement Range Limit in Measurement Range Unit | Conditional Only numeric values allowed. Updated only if Counter is not checked. |
| MRMIC | Lower Measurement Range Limit in Measurement Range Unit | Conditional Only numeric values allowed. Updated only if Counter is not checked. |
| CJUMC | Counter Over Reading | Conditional Updated if Counter is checked. Leave blank if Counter is not checked. |
| PYEAC | Annual Counter Reading | Conditional Updated if Counter is checked. Leave blank if Counter is not checked. Annual counter cannot be more than 8760 Hr or 365 Days or 1 Year based on the unit of the characterisrics. |
| DESIC | Measuring Point Target Value | Conditional Only numeric values allowed. Updated if Counter is checked. Leave blank if Counter is not checked. |
| CDSUF | Indicator: Valuation Code Sufficient for Measurmnt. Document | Conditional Checkbox X = Yes Blank = No Can be updated only if Code Group is populated. Must be blank if Code Group is empty. |
CHAR_DISCRETE_TO_ASSET | Discrete to the Asset Characteristic | Mandatory Allowed values: Yes/No Note: If blank, will be defaulted to "No" |
Extraction Dependencies
| Item # | Step Description | Team Responsible |
|---|---|---|
| Not Applicable |
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:
- Perform value mapping and data transformation rules.
- Legacy values are mapped to the to-be values (this could include a default value)
- Values are transformed according to the rules defined in
- 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
| Item # | Step Description | Team Responsible |
|---|---|---|
1 | Obtain DCT Sign-off from Business. | SyWay Data Team |
2 | In dspMigrate, select the wave – S4/HANA – Plant Maintenance | Syniti |
3 | Go to Process Area Launch and Process the Object – Measuring Point | Syniti |
4 | Review and Validate Error and Preload Reports | Syniti |
5 | Execute the transformation to prepare the target tables | Syniti |
6 | Validate data from pre-load and error reports | Business / Data owner |
7 | Generate load files | Syniti |
Transformation Rules
1. Measuring Point (Main) - DCT
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | - | ZLegacy_POINT | Legacy Measuring Point Number | - | - | - | - | Key for Measuring Point Load |
| 2 | DCT | IMPTT | MPOTY | Measuring Point Object | S/4 HANA | IMPTT | MPOTY | Measuring Point Object | Direct Mapping |
| 3 | DCT | - | POINT_OBJECT | Measuring Point Technical Object | S/4 HANA | IMPTT | EQUNR | Equipment Number | Value Mapping: Equipment Number where MPOTY= "IEQ" |
| 4 | DCT | - | POINT_OBJECT | Measuring Point Technical Object | S/4 HANA | IMPTT | TPLNR | Functional Location | Value Mapping: Functional Location where MPOTY= "IFL" |
| 5 | DCT | IMPTT | MPTYP | Measuring Point Category | S/4 HANA | IMPTT | MPTYP | Measuring Point Category | Default to "M" |
| 6 | DCT | IMPTT | INDCT | Counter (Yes/No Indicator) | S/4 HANA | IMPTT | INDCT | Counter (Yes/No Indicator) | Direct Mapping |
| 7 | DCT | IMPTT | PSORT | Position (Measuring Point Position) | S/4 HANA | IMPTT | PSORT | Position (Measuring Point Position) | Direct Mapping |
| 8 | DCT | IMPTT | PTTXT | Measuring Point Description | S/4 HANA | IMPTT | PTTXT | Measuring Point Description | Direct Mapping |
| 9 | DCT | IMPTT | ATNAM | Characteristic Name (Link to Class/Char) | S/4 HANA | IMPTT | ATNAM | Characteristic Name | Value Mapping: Characteristic A2D |
| 10 | DCT | IMPTT | DECIM | Number of Decimal Places | S/4 HANA | IMPTT | DECIM | Number of Decimal Places | Default to "3" |
| 11 | DCT | IMPTT | CODGR | Code Group | S/4 HANA | IMPTT | CODGR | Code Group | Direct Mapping |
| 12 | DCT | IMPTT | MRMAC | Upper Measurement Range Limit in Measurement Range Unit | S/4 HANA | IMPTT | MRMAC | Upper Measurement Range Limit in Measurement Range Unit | Direct Mapping |
| 13 | DCT | IMPTT | MRMIC | Lower Measurement Range Limit in Measurement Range Unit | S/4 HANA | IMPTT | MRMIC | Lower Measurement Range Limit in Measurement Range Unit | Direct Mapping |
| 14 | DCT | IMPTT | CJUMC | Counter Over Reading | S/4 HANA | IMPTT | CJUMC | Counter Over Reading | Direct Mapping |
| 15 | DCT | IMPTT | PYEAC | Annual Counter Reading | S/4 HANA | IMPTT | PYEAC | Annual Counter Reading | Direct Mapping |
| 16 | DCT | IMPTT | DESIC | Measuring Point Target Value | S/4 HANA | IMPTT | DESIC | Measuring Point Target Value | Direct Mapping |
| 17 | DCT | IMPTT | CDSUF | Indicator: Valuation Code Sufficient for Measurmnt. Document | S/4 HANA | IMPTT | CDSUF | Indicator: Valuation Code Sufficient for Measurmnt. Document | Direct Mapping |
2. Measuring Point (Main) - ECC
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PF2, WP2 | IMPTT | POINT | Measuring Point | - | - | - | - | Key for Measuring Point Load |
| 2 | - | - | - | - | S/4 HANA | IMPTT | MPOTY | Measuring Point Object | If EQUI-EQUNR is not blank, then "IEQ" If IFLOT-TPLNR is not blank, then "IFL" |
| 3 | PF2, WP2 |
|
|
| S/4 HANA | EQUI | EQUNR | Equipment Number | Value Mapping: Equipment Number Note: There is possibility that the legacy Functional Location is migrating to S/4 HANA Equipment. |
| 4 | PF2, WP2 | IFLOT | TPLNR | Functional Location | S/4 HANA | IFLOT | TPLNR | Functional Location | Value Mapping: Functional Location There is possibility that the legacy Functional Location is migrating to S/4 HANA Equipment. This is indicated by the field "New Technical Object" in the Mapping Table. In this case, ensure that the transformation is performed from Functional Location to Equipment for IMPTT-EQUNR |
| 5 | PF2, WP2 | IMPTT | MPTYP | Measuring Point Category | S/4 HANA | IMPTT | MPTYP | Measuring Point Category | Default to "M" |
| 6 | PF2, WP2 | IMPTT | INDCT | Counter (Yes/No Indicator) | S/4 HANA | IMPTT | INDCT | Counter (Yes/No Indicator) | Direct Mapping |
| 7 | PF2, WP2 | IMPTT | PSORT | Position (Measuring Point Position) | S/4 HANA | IMPTT | PSORT | Position (Measuring Point Position) | Direct Mapping |
| 8 | PF2, WP2 | IMPTT | PTTXT | Measuring Point Description | S/4 HANA | IMPTT | PTTXT | Measuring Point Description | Direct Mapping Overwrite with DCT if provided (as part of enrichment) |
| 9 | PF2, WP2 | CABN | ATNAM | Characteristic Name | S/4 HANA | CABN | ATNAM | Characteristic Name | Value Mapping: Characteristic A2D |
| 10 | PF2, WP2 | IMPTT | DECIM | Number of Decimal Places | S/4 HANA | IMPTT | DECIM | Number of Decimal Places | Default to "3" |
| 11 | PF2, WP2 | IMPTT | CODGR | Code Group | S/4 HANA | IMPTT | CODGR | Code Group | Value Mapping: Catalog Code Group and Code where New Catalog = "3" |
| 12 | PF2, WP2 | RIMR0 | MRMAC | Upper Measurement Range Limit in Measurement Range Unit | S/4 HANA | RIMR0 | MRMAC | Upper Measurement Range Limit in Measurement Range Unit | Direct Mapping |
| 13 | PF2, WP2 | RIMR0 | MRMIC | Lower Measurement Range Limit in Measurement Range Unit | S/4 HANA | RIMR0 | MRMIC | Lower Measurement Range Limit in Measurement Range Unit | Direct Mapping |
| 14 | PF2, WP2 | IMPTT | CJUMC | Counter Over Reading | S/4 HANA | IMPTT | CJUMC | Counter Over Reading | Direct Mapping |
| 15 | PF2, WP2 | IMPTT | PYEAC | Annual Counter Reading | S/4 HANA | IMPTT | PYEAC | Annual Counter Reading | Direct Mapping |
| 16 | PF2, WP2 | RIMR0 | DESIC | Measuring Point Target Value | S/4 HANA | RIMR0 | DESIC | Measuring Point Target Value | Direct Mapping |
| 17 | PF2, WP2 | IMPTT | CDSUF | Indicator: Valuation Code Sufficient for Measurmnt. Document | S/4 HANA | IMPTT | CDSUF | Indicator: Valuation Code Sufficient for Measurmnt. Document | Direct Mapping |
3. Measuring Point (Characteristics Values Header) - DCT
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - | - | S/4 HANA | KLAH | KLART | Class Type | Default to "037" |
| 2 | - | - | - | - | S/4 HANA | INOB | OBTAB | Name of Database Table for Object | Default to "IMPTT" |
| 3 | - | - | - | - | S/4 HANA | KLAH | CLASS | Class number | Default to "EAM_9999" |
| 4 | DCT | - | ZLegacy_POINT | Legacy Measuring Point Number | S/4 HANA | IMPTT | POINT | Measuring Point | Value Mapping: Measuring Point |
| 5 | - | - | - | - | S/4 HANA | KLAH | STATU | Class Status | Default to "1" |
4. Measuring Point (Characteristics Values Header) - ECC
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - | - | S/4 HANA | KLAH | KLART | Class Type | Default to "037" |
| 2 | - | - | - | - | S/4 HANA | INOB | OBTAB | Name of Database Table for Object | Default to "IMPTT" |
| 3 | - | - | - | - | S/4 HANA | KLAH | CLASS | Class number | Default to "EAM_9999" |
| 4 | PF2, WP2 | IMPTT | POINT | Measuring Point | S/4 HANA | IMPTT | POINT | Measuring Point | Value Mapping: Measuring Point |
| 5 | - | - | - | - | S/4 HANA | KLAH | STATU | Class Status | Default to "1" |
5. Measuring Point (Characteristics Values Allocation) - DCT
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - | - | S/4 HANA | KLAH | KLART | Class Type | Default to "037" |
| 2 | - | - | - | - | S/4 HANA | INOB | OBTAB | Name of Database Table for Object | Default to "IMPTT" |
| 3 | - | - | - | - | S/4 HANA | KLAH | CLASS | Class number | Default to "EAM_9999" |
| 4 | DCT | - | ZLegacy_POINT | Legacy Measuring Point Number | S/4 HANA | IMPTT | POINT | Measuring Point | Value Mapping: Measuring Point |
| 5 | - | - | - | - | S/4 HANA | CABN | ATNAM | Characteristic Name | Value Mapping: A2D Characteristics based on value A_DISCRETE_TO_ASSET |
| 6 | DCT | - | CHAR_DISCRETE_TO_ASSET | Discrete to the Asset Characteristic | S/4 HANA | AUSP | ATWRT | Characteristic Value | Direct Mapping If Blank, default to "No" |
| 7 | - | - | - | S/4 HANA | KSML | POSNR | Item Number | Derive from SAP based on Characteristics Name and Class Number |
UNION
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - | - | S/4 HANA | KLAH | KLART | Class Type | Default to "037" |
| 2 | - | - | - | - | S/4 HANA | INOB | OBTAB | Name of Database Table for Object | Default to "IMPTT" |
| 3 | - | - | - | - | S/4 HANA | KLAH | CLASS | Class number | Default to "EAM_9999" |
| 4 | DCT | - | ZLegacy_POINT | Legacy Measuring Point Number | S/4 HANA | IMPTT | POINT | Measuring Point | Value Mapping: Measuring Point |
| 5 | - | - | - | - | S/4 HANA | CABN | ATNAM | Characteristic Name | Value Mapping: A2D Characteristics based on value A_ALLOWED_CT |
| 6 | DCT | - | CHAR_DISCRETE_TO_ASSET | Discrete to the Asset Characteristic | S/4 HANA | AUSP | ATWRT | Characteristic Value | If CHAR_DISCRETE_TO_ASSET = "Yes", then leave blank If CHAR_DISCRETE_TO_ASSET = "No" or blank, then derive value from Construction Type field (EQUI-SUBMT or IFLOT-SUBMT) of POINT_OBJECT. |
| 7 | - | - | - | S/4 HANA | KSML | POSNR | Item Number | Derive from SAP based on Characteristics Name and Class Number |
6. Measuring Point (Characteristics Values Allocation) - ECC
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - | - | S/4 HANA | KLAH | KLART | Class Type | Default to "037" |
| 2 | - | - | - | - | S/4 HANA | INOB | OBTAB | Name of Database Table for Object | Default to "IMPTT" |
| 3 | - | - | - | - | S/4 HANA | KLAH | CLASS | Class number | Default to "EAM_9999" |
| 4 | PF2, WP2 | IMPTT | POINT | Measuring Point | S/4 HANA | IMPTT | POINT | Measuring Point | Value Mapping: Measuring Point |
| 5 | - | - | - | - | S/4 HANA | CABN | ATNAM | Characteristic Name | Value Mapping: A2D Characteristics based on value A_DISCRETE_TO_ASSET |
| 6 | DCT | - | CHAR_DISCRETE_TO_ASSET | Discrete to the Asset Characteristic | S/4 HANA | AUSP | ATWRT | Characteristic Value | Direct Mapping if provided (as part of enrichment) If Blank, default to "No" |
| 7 | - | - | - | S/4 HANA | KSML | POSNR | Item Number | Derive from SAP based on Characteristics Name and Class Number |
UNION
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - | - | S/4 HANA | KLAH | KLART | Class Type | Default to "037" |
| 2 | - | - | - | - | S/4 HANA | INOB | OBTAB | Name of Database Table for Object | Default to "IMPTT" |
| 3 | - | - | - | - | S/4 HANA | KLAH | CLASS | Class number | Default to "EAM_9999" |
| 4 | PF2, WP2 | IMPTT | POINT | Measuring Point | S/4 HANA | IMPTT | POINT | Measuring Point | Value Mapping: Measuring Point |
| 5 | - | - | - | - | S/4 HANA | CABN | ATNAM | Characteristic Name | Value Mapping: A2D Characteristics based on value A_ALLOWED_CT |
| 6 | DCT | - | CHAR_DISCRETE_TO_ASSET | Discrete to the Asset Characteristic | S/4 HANA | AUSP | ATWRT | Characteristic Value | If CHAR_DISCRETE_TO_ASSET = "Yes", then leave blank If CHAR_DISCRETE_TO_ASSET = "No" or blank, then derive value from Construction Type field (EQUI-SUBMT or IFLOT-SUBMT) of POINT_OBJECT. |
| 7 | - | - | - | S/4 HANA | KSML | POSNR | Item Number | Derive from SAP based on Characteristics Name and Class Number |
List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register. (still WIP)
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
|---|---|
Characteristic A2D | Old to New Characteristic A2D |
Measuring Point | Legacy Measuring Point XREF mapping table |
Catalog Code Group and Code | Mapping of legacy Catalog Code Group and Code to S/4 HANA Catalog Code Group and Code |
Functional Location | Mapping of legacy Functional Location to new Functional Location |
Equipment Number | Mapping of legacy Equipment to new Equipment |
ENR_Measuring Point Discrete to Asset | Enrichment for Measuring Point Discrete to Asset Characteristics |
ENR_Measuring Point Description | Enrichment for Measuring Point Description |
List of Transformation Mappings with additional details is maintained here: Transformation Mappings.
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step Description | Team Responsible |
|---|---|---|
1 | Ensure DCT tables completeness | SyWay Data Team |
2 | Ensure all Transformation mappings are up to date. | SyWay Data Team |
Pre-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
Verify Record Count | Data team to verify that the total number of relevant records from the source systems is equal to the total number of records in the Preload and Load Sheets. |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Data team to verify that all fields below meet pass the checks: 1. Mandatory Fields 2. Field and Value Mapping Correctness 3. Null Checks 4. Text Length Checks |
Review error reports | Review and correct the errors. Achieve a zero-error record count as much as possible. Raise defects for data remediated and requiring a correction in the source data. |
Business
Completeness
| Task | Action |
|---|---|
Verify Record Count | Business team to verify that the total number of relevant records from the source systems is equal to the total number of records in the Preload and Load Sheets. |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Business to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules (and signed-off data) |
Load
The load process includes:
- Execute the automated data load into target system using load tool or product the load file if the load must be done manually
- Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation
Load Run Sheet
| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Ensure Pre-load sign-offs are obtained. | SyWay Data team |
| 2 | Go to the load tool and select the correct load Program. | SyWay Data team |
| 3 | Proceed with Data load. | SyWay Data team |
| 4 | Validate few records loaded by accessing standard transactions | SyWay Data team |
| 5 | Generate the post load reports in the tool. | SyWay Data team |
| 6 | Log errors as defects, if any and address resolutions. Close defects. | SyWay Data team |
| 7 | Resolve defects by reupload and re-generate post load reports if necessary. | SyWay 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. | SyWay Data team |
Load Phase and Dependencies
Pre-Cutover
Configuration
| Item # | Configuration Item |
|---|---|
1 | T370P-Measuring Point Category |
2 | TCLA-Class Types |
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| 1003 | Functional Location |
| 1002 | Equipment |
| 1009 | Class |
| 1015 | Characteristics |
| 1007 | Catalog Code and Code Group |
| 1010 | Construction Type |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
Configuration | Invalid measuring point category | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid measuring point Class Type | Engage Functional team to expedite and fix the error in the system |
Invalid Data | Invalid Functional Location | Expedite whether the master data is available in the system |
Invalid Data | Invalid Equipment | Expedite whether the master data is available in the system |
| Invalid Data | Invalid Class | Expedite whether the master data is available in the system |
Invalid Data | Invalid Characteristics | Expedite whether the master data is available in the system |
Invalid Data | Invalid Catalog Code and Code Group | Expedite whether the master data is available in the system |
| Invalid Data | Invalid Construction Type | Expedite whether the master data is available in the system |
Post-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
Verify Count | Data team to verify the record count created in target S/4 HANA by accessing post load reports in dspMigrate or standard reports from S/4 HANA. |
Verify Logs | Check if there is data that failed to load and perform the necessary actions (e.g. register as post load issue, or attempt to load the record again, etc.). |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Data team to verify that the Measuring Point data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA. |
Business
Completeness
| Task | Action |
|---|---|
Verify Count | Download Post Load Reports from dspMigrate and verify that the record count loaded in the target S/4 HANA is the same count as of the endorsed load file. |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Verify that the Measuring Point data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA. |
Key Assumptions
- Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
- Data cleansing has met the required percentage threshold for the specified mock cycle and all preparation activities have been completed.
- Data entries in DCT are target-ready data unless a specific transformation rule is stated for that field in the transformation rules.
See also
Change log
Workflow history
| Title | Last Updated By | Updated | Status | |
|---|---|---|---|---|
| There are no pages at the moment. | ||||