| Status | Approved |
|---|---|
| Owner | |
| Stakeholders |
Purpose
The purpose of this document is to define the conversion approach to create Functional Location in S/4 HANA.
Legacy Functional Locations are using a diverse range of formats across the different systems. There are instances where the same Functional Locations are duplicated within and across sources, with informal words. This results in data inconsistency. As per SyWay design, EAM Functional Locations will be standardized.
Conversion Scope
The scope of this document covers the approach for converting active Functional Location from Legacy Source Systems into S/4HANA following the Functional Location Master Data Design Standard.
Functional Locations are technical objects that structure the maintainable objects of a company. They can represent either the location of a maintainable item, or the maintainable item itself. A functional location does not normally change and will record the history of all equipment that is installed at that location.
Syensqo utilizes Functional Locations (FLOC) within the SAP S/4HANA system to define and manage its Asset Hierarchy. The asset hierarchy is structured across three main categories:
- Organisational Level - This level represents the enterprise structure of Syensqo. It defines:
The Company
The Global Business Unit (GBU)
The Plant
Navigational Level - This level structures the hierarchy based on the functional or geographical layout of the plant. It defines:
- Units within the Plant
- Further sub-levels based on the physical location or logical grouping of assets, enabling effective representation and navigation within the hierarchy
- Asset Level - This is the installation level where the actual Assets and Sub-assets are physically located. It includes:
- Specific installation points for equipment
- Maintainable assets themselves, serving as key points for maintenance planning and execution
The data from legacy system includes:
- system status without INAC (Inactive)
The data from legacy system excludes:
- Not Applicable
| Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|
PF2, WP2 | An initial extract will be provided to the business to evaluate. Additional data/records may be required and these will be constructed via DCT. Enrichment of in-scope data may be required and will be added via transformation rules (business/technical). | 250,000 | S/4HANA | 250,000 |
Additional Information
Multi-language Requirement
Functional Location description will be made available in English.
Multi language is supported for Functional Location. Login via a different language will have its description displayed in the logon language if the language key is maintained in the Functional Location.
Document Management
- <Types of documents> documents currently attached to Functional Locations will be migrated to <TBD>.
- Refer to the conversion approach for <TBD>.
Legal Requirement
Not Applicable
Special Requirements
Not Applicable
Target Design
The technical design of the target for this conversion approach.
1. Functional Location Master
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| IFLOT | TPLNR | TPLNR | Functional Location Number | CHAR | 30 | Mandatory |
| IFLOT | TPLKZ | TPLKZ | Structure Indicator | CHAR | 80 | Mandatory |
| IFLOT | FLTYP | FLTYP | Category | CHAR | 80 | Mandatory |
| IFLOT | PLTXT | PLTXT | Description | CHAR | 40 | Mandatory |
| IFLOT | INBDT | INBDT | Start-Up Date | DATS | 8 | Conditional |
| IFLOT | EQART | EQART | Object Type | CHAR | 80 | Mandatory |
| IFLOT | HERST | HERST | Manufacturer | CHAR | 30 | Conditional |
| IFLOT | TYPBZ | TYPBZ | Model Number | CHAR | 20 | Conditional |
| IFLOT | MAPAR | MAPAR | Manufacturer Part Number | CHAR | 30 | Conditional |
| IFLOT | HERLD | HERLD | Country/Region of Manufacture | CHAR | 80 | Conditional |
| IFLOT | BAUJJ | BAUJJ | Year of Construction | CHAR | 4 | Conditional |
| IFLOT | BAUMM | BAUMM | Month of Construction | CHAR | 80 | Conditional |
| IFLOT | SERGE | SERGE | Manufacturer Serial Number | CHAR | 30 | Conditional |
| IFLOT | ANSWT | ANSWT | Acquisition Value | NUMC | 13 | Conditional |
| IFLOT | WAERS | WAERS | Currency Key ( ISO Format ) | CHAR | 80 | Conditional |
| IFLOT | SWERK | SWERK | Maintenance Plant | CHAR | 80 | Mandatory |
| IFLOT | EQFNR | EQFNR | Sort Field | CHAR | 30 | Conditional |
| IFLOT | BEBER | BEBER | Plant Section | CHAR | 80 | Conditional |
| IFLOT | ABCKZ | ABCKZ | ABC Indicator | CHAR | 80 | Conditional |
| ILOA | INGRP | INGRP | Planner Group | CHAR | 80 | Conditional |
| ILOA | IWERK | IWERK | Planning Plant | CHAR | 80 | Mandatory |
| ILOA | GEWRK | GEWRK | Maintenance Work Center | CHAR | 80 | Conditional |
| ILOA | WERGW | WERGW | Work Center Plant | CHAR | 80 | Conditional |
| ILOA | BUKRS | BUKRS | Company Code | CHAR | 80 | Mandatory |
| ILOA | KOSTL | KOSTL | Cost Center | CHAR | 80 | Conditional |
| ILOA | TPLMA | TPLMA | Superior Functional Location | CHAR | 80 | Conditional |
| ILOA | IEQUI | IEQUI | Indicator: Installation Allowed | CHAR | 1 | Conditional |
| ILOA | SUBMT | SUBMT | Construction Type | CHAR | 80 | Conditional |
| ILOA | KOKRS | KOKRS | Controlling Area | CHAR | 4 | Mandatory |
2. Functional Location Short Text
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| IFLOTX | TPLNR | TPLNR | Functional Location Number | CHAR | 30 | Mandatory |
| IFLOTX | SPRAS | SPRAS | Language Key | LANG | 1 | Mandatory |
| IFLOTX | PLTXT | PLTXT | Description of Functional Location | CHAr | 40 | Mandatory |
3. Functional Location Classification
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| KSSK | KLART | KLART | Class Type | CHAR | 20 | Mandatory |
| KSSK | OBTAB | OBTAB | Name of Database Table for Object | CHAR | 30 | Mandatory |
| KSSK | CLASSNUM | CLASSNUM | Class Name | CHAR | 30 | Mandatory |
| KSSK | OBJEK | OBJEK | Object Key (Functional Location Number) | CHAR | 90 | Mandatory |
| KSSK | STATU | STATU | Classification Status | CHAR | 80 | Mandatory |
| KSSK | STDCL | STDCL | Indicator: Standard Class | CHAR | 80 | |
| KSSK | KEYDATE | KEYDATE | Valid From Date | DATS | 8 | |
| KSSK | NO_DEFAULT_VALUES | NO_DEFAULT_VALUES | Indicator: No Default Values | CHAR | 80 | |
| AUSP | CHARACT | CHARACT | Characteristic Name | CHAR | 80 | Mandatory |
| AUSP | POSNR | POSNR | Item Number | CHAR | 3 | Mandatory |
| AUSP | ATFLV | ATFLV | Numerical Value - From (Floating Point) | NUMC | 16 | |
| AUSP | ATFLB | ATFLB | Numerical Value - To (Floating Point) | NUMC | 16 | |
| AUSP | ATCOD | ATCOD | Code for Value Dependency | CHAR | 1 | |
| AUSP | UNIT_FROM_ISO | UNIT_FROM_ISO | Base Unit of Measure - From (ISO Code) | CHAR | 80 | |
| AUSP | UNIT_TO_ISO | UNIT_TO_ISO | Base Unit of Measure - To (ISO Code) | CHAR | 80 | |
| AUSP | DATE_FROM | DATE_FROM | Lower Boundary for Date - Interval | DATS | 8 | |
| AUSP | DATE_TO | DATE_TO | Upper Boundary for Date - Interval | DATS | 8 | |
| AUSP | TIME_FROM | TIME_FROM | Lower Boundary for Time - Interval | TIMS | 6 | |
| AUSP | TIME_TO | TIME_TO | Upper Boundary for Time - Interval | TIMS | 6 | |
| AUSP | ATFLV | ATFLV | Currency Value - From (Floating Point) | NUMC | 16 | |
| AUSP | ATFLB | ATFLB | Currency Value - To (Floating Point) | NUMC | 16 | |
| AUSP | VALUE_CHAR | VALUE_CHAR | Characteristic Value | CHAR | 30 | |
| AUSP | VALUE_CHAR_LONG | VALUE_CHAR_LONG | Characteristic Value Long | CHAR | 70 | |
| AUSP | VALUE_NEUTRAL | VALUE_NEUTRAL | Characteristic Value Neutral | CHAR | 30 | |
| AUSP | VALUE_NEUTRAL_LONG | VALUE_NEUTRAL_LONG | Characteristic Value Neutral Long | CHAR | 70 | |
| AUSP | INHERITED | INHERITED | Indicator: Characteristic Is Inherited | CHAR | 1 |
4. Functional Location Permit
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| IHSG | OBJNR | OBJNR | Object Number (Internal Floc Number) | CHAR | 30 | Mandatory |
| IHSG | PMSOG | PMSOG | Permit Key | CHAR | 10 | Mandatory |
| IHSG | K_AF | K_AF | Indicator: Valid for Order Release | CHAR | 1 | |
| IHSG | K_AA | K_AA | Indicator: Valid for Order Completion | CHAR | 1 | |
| IHSG | K_DRUCK | K_DRUCK | Printout of Permit Papers | CHAR | 1 | |
| IHSG | K_PRO | K_PRO | Indicator: Permit Proposed During Processing | CHAR | 1 |
5. Functional Location Partner
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| IHPA | OBJNR | OBJNR | Object Number (Internal Floc Number) | CHAR | 30 | Mandatory |
| IHPA | OBTYP | OBTYP | Object Type | CHAR | 3 | Mandatory |
| IHPA | PARVW | PARVW | Partner Function | CHAR | 2 | Mandatory |
| IHPA | PARNR | PARNR | Partner | CHAR | 12 | Mandatory |
6. Functional Location User Status
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| JEST | OBJNR | OBJNR | Object Number (Internal Floc Number) | CHAR | 30 | Mandatory |
| JSTO | STSMA | STSMA | Status profile of the functional location | CHAR | 8 | Mandatory |
JEST | STAT | STAT | Status Number in User Status List | CHAR | 5 | Mandatory |
JEST | INACT | INACT | Indicator: Status Is Inactive | CHAR | 1 |
7. Functional Location Long Text Header
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| IFLOT | TPLNR | TPLNR | Functional Location Number | CHAR | 30 | Mandatory |
| IFLOTX | KZLTX | KZLTX | Long Text Exists | CHAR | 1 | Mandatory |
| STXL | TDOBJECT | TDOBJECT | Texts: application object | CHAR | 10 | Mandatory |
| STXL | TDNAME | TDOBNAME | Name | CHAR | 70 | Mandatory |
| STXL | TDID | TDID | Text ID | CHAR | 4 | Mandatory |
| STXL | TDSPRAS | SPRAS | Language Key | LANG | 1 | Mandatory |
Functional Location Long Text Line
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| IFLOT | TPLNR | TPLNR | Functional Location Number | CHAR | 30 | Mandatory |
| STXL | TDOBJECT | TDOBJECT | Texts: application object | CHAR | 10 | Mandatory |
| STXL | TDNAME | TDOBNAME | Name | CHAR | 70 | Mandatory |
| STXL | TDID | TDID | Text ID | CHAR | 4 | Mandatory |
| STXL | TDSPRAS | SPRAS | Language Key | LANG | 1 | Mandatory |
| STXL | TDFORMAT | TDFORMAT | Tag column | CHAR | 1 | Mandatory |
| STXL | TDLINE | TDLINE | Text Line | CHAR | 72 | Mandatory |
Data Cleansing
Functional Location Data strictly adheres to the Master Data Standard. The complete information of the key fields that hold the Functional Location information follows the Master Data Standard document that is located here.
| ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
|---|---|---|---|---|---|
1003-001 | C1 | Missing Functional Location Descriptions | Functional Location as per Relevancy Criteria where there are blank Functional Location Descriptions. | Functional Location Description | PF2, WP2 |
| 1003-002 | C2 | Functional Location Descriptions with Informal Words | Functional Location as per Relevancy Criteria which contain [Informal Words] in the Functional Location Description | Functional Location Description | PF2, WP2 |
| 1003-003 | C1 | Invalid, Inactive or no Cost Centres linked to Functional Location | Functional Location as per Relevancy Criteria assigned with a Cost Centre which does not belong below: 1. Cost Centre (FI) as per Relevancy Criteria | Cost Centre | PF2, WP2 |
| 1003-005 | C1 | Invalid, Inactive or no Class linked to Functional Location | Functional Location as per Relevancy Criteria assigned with a Class which does not belong below: 1. Class as per Relevancy Criteria | Class | PF2, WP2 |
| 1003-006 | C1 | Invalid, Inactive or no Characteristic linked to Functional Location | Functional Location as per Relevancy Criteria assigned with a Characteristic which does not belong below: 1. Characteristic as per Relevancy Criteria | Characteristic | PF2, WP2 |
| 1003-007 | C1 | Invalid, Inactive or no Construction Type linked to Functional Location | Functional Location as per Relevancy Criteria assigned with a Construction Type which does not belong below: 1. Construction Type as per Relevancy Criteria | Construction Type | PF2, WP2 |
| 1003-008 | C1 | Invalid or Inactive Document Info Record linked to Functional Location | Functional Location as per Relevancy Criteria assigned with a Document Info Record which does not belong below: 1. Document Info Record as per Relevancy Criteria | Document Info Record | PF2, WP2 |
1003-009 | C1 | Invalid or Inactive Material linked to Functional Location | Functional Location as per Relevancy Criteria assigned with a Material which does not belong below: 1. Material Master (S2P) as per Relevancy Criteria | Material | PF2, WP2 |
| 1003-010 | C1 | Invalid, Inactive or no Work Centres linked to Functional Location | Functional Location as per Relevancy Criteria assigned with a Work Centre which does not belong below: 1. Work Centre as per Relevancy Criteria | Work Centre | PF2, WP2 |
| 1003-011 | C1 | Invalid or no Planner Group linked to Functional Location | Functional Location as per Relevancy Criteria with no Planner Group Assigned or Invalid Planner Group (T024I) | Planner Group | PF2, WP2 |
| 1003-012 | C1 | Invalid or no Technical Object Type linked to Functional Location | Functional Location as per Relevancy Criteria with no Technical Object Type Assigned or Invalid Technical Object Type (T370K) | Technical Object Type | PF2, WP2 |
| 1003-013 | C1 | Maintainable physical assets created as Functional Location (than Equipment) | Functional Location | PF2, WP2 | |
| 1003-014 | C1 | Review all Functional Location / Equipment sitting under "ZDELETE". If these data set is not used / not needed, the system status should be set to INAC. | System Status | PF2, WP2 | |
| 1003-015 | C1 | Invalid, Inactive or no Superior Functional Location linked to Functional Location | Functional Location as per Relevancy Criteria with no Superior Functional Location Assigned or with a Superior Functional Location which does not belong below: 1. Functional Location as per Relevancy Criteria | Superior Functional Location | PF2, WP2 |
| 1003-016 | C1 | Invalid, Inactive or no Maintenance Plans linked to Functional Location | Functional Location as per Relevancy Criteria with no Maintenance Plan Linked or with a Maintenance Plan which does not belong below: 1. Maintenance Plan as per Relevancy Criteria | Maintenance Plan | PF2, WP2 |
| 1003-017 | C1 | Invalid or Inactive Business Partner (Customer) linked to Functional Location | Functional Location as per Relevancy Criteria assigned with a Business Partner / Customer which does not belong below: 1. Business Partner FLCU01 (SD) as per Relevancy Criteria | Business Partner (Customer) | PF2, WP2 |
| 1003-019 | C2 | Material Types of Construction Types are non-Maintenance Assembly | Functional as per Relevancy Criteria where the Construction Type Assigned has a non-Maintenance Assembly Material Type* QF2: ZZ90-Maintenance Assembly WQ2: ZIBA-Maintenance Assembly | Construction Type | PF2, WP2 |
| 1003-020 | C1 | Invalid or Inactive Bill of Material linked to Functional Location | Functional Location as per Relevancy Criteria assigned with a Bill of Materia which does not belong below: 1. Bill of Material as per Relevancy Criteria | Bill of Material | PF2, WP2 |
| 1003-021 | C1 | Functional Location Company Code incorrect. | Functional Location as per Relevancy Criteria with Invalid Company Code (T001) | Company Code | PF2, WP2 |
| 1003-023 | C1 | Functional Location Currency Codes incorrect. | Functional Location as per Relevancy Criteria with Invalid Currency Codes (TCURC) | Currency | PF2, WP2 |
| 1003-024 | C2 | Functional Location Planning Plant and Maintenance Plant are not the same. | Functional Location as per Relevancy Criteria with Planning Plant <> Maintenance Plant | Maintenance Plant, Planning Plant | PF2, WP2 |
| 1003-025 | C1 | ABC Indicator missing on Functional Location | Functional Location as per Relevancy Criteria where ABC Indicator is blank | ABC Indicator | PF2, WP2 |
Conversion Process
The high-level process for Source System Extraction is represented by the diagram below:
Collection will be done manually in the Data Collection Template for the following scenarios:
- For sites not on SAP-PF2 or WP2 systems
- For new Functional Location that need to be created to support the to-be design.
Data Privacy and Sensitivity
Not Applicable
Extraction
Extract data from a source into . There are 2 possibilities:
- The data exists. connects to the source and loads the data into . There are 3 methods:
- Perform full data extraction from relevant tables in the source system(s).
- Perform extraction through the application layer.
- Only if ; 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 . This is to be conducted using DCT (Data Collection Template) in
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 |
2 | Internal Staging Table populated with PF2 and WP2 information to be generated based on relevancy criteria. | 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 Functional Location with exception of some fields which require transformation as mentioned in the transformation rule.
- The extracted report will be loaded into the required structure using the DCT.
- Standardization activities (including deduplication, standardization and additions) will be carried out within the DCT.
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.
1. Functional Location Master
| Field Name | Field Description | Rule |
|---|---|---|
| TPLNR | Functional Location Number | |
| TPLKZ | Structure Indicator | |
| FLTYP | Category | |
| PLTXT | Description | |
| INBDT | Start-Up Date | |
| EQART | Object Type | |
| HERST | Manufacturer | |
| TYPBZ | Model Number | |
| MAPAR | Manufacturer Part Number | |
| HERLD | Country/Region of Manufacture | |
| BAUJJ | Year of Construction | |
| BAUMM | Month of Construction | |
| SERGE | Manufacturer Serial Number | |
| ANSWT | Acquisition Value | |
| WAERS | Currency Key ( ISO Format ) | |
| SWERK | Maintenance Plant | |
| EQFNR | Sort Field | |
| BEBER | Plant Section | |
| ABCKZ | ABC Indicator | |
| INGRP | Planner Group | |
| IWERK | Planning Plant | |
| GEWRK | Maintenance Work Center | |
| WERGW | Work Center Plant | |
| BUKRS | Company Code | |
| KOSTL | Cost Center | |
| TPLMA | Superior Functional Location | |
| IEQUI | Indicator: Installation Allowed | |
| SUBMT | Construction Type | |
| KOKRS | Controlling Area |
2. Functional Location Short Text
| Field Name | Field Description | Rule |
|---|---|---|
| TPLNR | Functional Location Number | |
| SPRAS | Language Key | |
| PLTXT | Description of Functional Location |
3. Functional Location Classification
| Data Element | Field Description | Rule |
|---|---|---|
| KLART | Class Type | |
| OBTAB | Name of Database Table for Object | |
| CLASSNUM | Class Name | |
| OBJEK | Object Key (Functional Location Number) | |
| STATU | Classification Status | |
| STDCL | Indicator: Standard Class | |
| KEYDATE | Valid From Date | |
| NO_DEFAULT_VALUES | Indicator: No Default Values | |
| CHARACT | Characteristic Name | |
| POSNR | Item Number | |
| ATFLV | Numerical Value - From (Floating Point) | |
| ATFLB | Numerical Value - To (Floating Point) | |
| ATCOD | Code for Value Dependency | |
| UNIT_FROM_ISO | Base Unit of Measure - From (ISO Code) | |
| UNIT_TO_ISO | Base Unit of Measure - To (ISO Code) | |
| DATE_FROM | Lower Boundary for Date - Interval | |
| DATE_TO | Upper Boundary for Date - Interval | |
| TIME_FROM | Lower Boundary for Time - Interval | |
| TIME_TO | Upper Boundary for Time - Interval | |
| ATFLV | Currency Value - From (Floating Point) | |
| ATFLB | Currency Value - To (Floating Point) | |
| VALUE_CHAR | Characteristic Value | |
| VALUE_CHAR_LONG | Characteristic Value Long | |
| VALUE_NEUTRAL | Characteristic Value Neutral | |
| VALUE_NEUTRAL_LONG | Characteristic Value Neutral Long | |
| INHERITED | Indicator: Characteristic Is Inherited |
4. Functional Location Permit
| Data Element | Field Description | Rule |
|---|---|---|
| OBJNR | Object Number (Internal Floc Number) | |
PMSOG | Permit Key |
|
K_AF | Indicator: Valid for Order Release |
|
K_AA | Indicator: Valid for Order Completion |
|
K_DRUCK | Printout of Permit Papers |
|
K_PRO | Indicator: Permit Proposed During Processing |
|
5. Functional Location Partner
| Data Element | Field Description | Rule |
|---|---|---|
| OBJNR | Object Number (Internal Floc Number) | |
| OBTYP | Object Type | |
| PARVW | Partner Function | |
| PARNR | Partner |
6. Functional Location User Status
| Data Element | Field Description | Rule |
|---|---|---|
| OBJNR | Object Number (Internal Floc Number) | |
| STSMA | Status profile of the functional location | |
| STAT | Status Number in User Status List | |
| INACT | Indicator: Status Is Inactive |
7. Functional Location Long Text Header
| Data Element | Field Description | Rule |
|---|---|---|
| TPLNR | Functional Location Number | |
| KZLTX | Long Text Exists | |
| TDOBJECT | Texts: application object | |
| TDOBNAME | Name | |
| TDID | Text ID | |
| SPRAS | Language Key |
Functional Location Long Text Line
| Data Element | Field Description | Rule |
|---|---|---|
| TPLNR | Functional Location Number | |
| TDOBJECT | Texts: application object | |
| TDOBNAME | Name | |
| TDID | Text ID | |
| SPRAS | Language Key | |
| TDFORMAT | Tag column | |
| TDLINE | Text Line |
Extraction Dependencies
| Item # | Step Description | Team Responsible |
|---|---|---|
1 | Ensure that create, change and deletion of master data is freeze in legacy Production system | Legacy IT |
| 2 | Relevancy Criteria for Characteristics | SyWay A2D Data Team |
| 3 | Relevancy Criteria for Class | SyWay A2D Data Team |
| 4 | Relevancy Criteria for Construction Type | SyWay A2D Data Team |
| 5 | Relevancy Criteria for Work Centre | SyWay A2D Data Team |
| 6 | Relevancy Criteria for Cost Centre | SyWay A2D Data Team |
| 7 | Relevancy Criteria for Business Partner (Vendor) | SyWay A2D Data Team |
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 | Ensure all mapping tables are up to date. | Syniti |
3 | In dspMigrate, select the wave –R3 S4/HANA – Plant Maintenance | Syniti |
4 | Go to Process Area Launch and Process the Object – Catalog Profile | Syniti |
5 | Review and Validate Error and Preload Reports | Syniti |
6 | Execute the transformation to prepare the target tables | Syniti |
7 | Validate data from pre-load and error reports | Business/Data owner |
| 8 | Generate load files | SyWay Data Team |
Transformation Rules
1. Functional Location Master
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | IFLOT | TPLNR | Functional Location Number | S/4 Hana | IFLOT | TPLNR | Functional Location Number | |
| 2 | DCT | IFLOT | TPLKZ | Structure Indicator | S/4 Hana | IFLOT | TPLKZ | Structure Indicator | |
| 3 | DCT | IFLOT | FLTYP | Category | S/4 Hana | IFLOT | FLTYP | Category | |
| 4 | DCT | IFLOT | PLTXT | Description | S/4 Hana | IFLOT | PLTXT | Description | |
| 5 | DCT | IFLOT | INBDT | Start-Up Date | S/4 Hana | IFLOT | INBDT | Start-Up Date | |
| 6 | DCT | IFLOT | EQART | Object Type | S/4 Hana | IFLOT | EQART | Object Type | |
| 7 | DCT | IFLOT | HERST | Manufacturer | S/4 Hana | IFLOT | HERST | Manufacturer | |
| 8 | DCT | IFLOT | TYPBZ | Model Number | S/4 Hana | IFLOT | TYPBZ | Model Number | |
| 9 | DCT | IFLOT | MAPAR | Manufacturer Part Number | S/4 Hana | IFLOT | MAPAR | Manufacturer Part Number | |
| 10 | DCT | IFLOT | HERLD | Country/Region of Manufacture | S/4 Hana | IFLOT | HERLD | Country/Region of Manufacture | |
| 11 | DCT | IFLOT | BAUJJ | Year of Construction | S/4 Hana | IFLOT | BAUJJ | Year of Construction | |
| 12 | DCT | IFLOT | BAUMM | Month of Construction | S/4 Hana | IFLOT | BAUMM | Month of Construction | |
| 13 | DCT | IFLOT | SERGE | Manufacturer Serial Number | S/4 Hana | IFLOT | SERGE | Manufacturer Serial Number | |
| 14 | DCT | IFLOT | ANSWT | Acquisition Value | S/4 Hana | IFLOT | ANSWT | Acquisition Value | |
| 15 | DCT | IFLOT | WAERS | Currency Key ( ISO Format ) | S/4 Hana | IFLOT | WAERS | Currency Key ( ISO Format ) | |
| 16 | DCT | IFLOT | SWERK | Maintenance Plant | S/4 Hana | IFLOT | SWERK | Maintenance Plant | |
| 17 | DCT | IFLOT | EQFNR | Sort Field | S/4 Hana | IFLOT | EQFNR | Sort Field | |
| 18 | DCT | IFLOT | BEBER | Plant Section | S/4 Hana | IFLOT | BEBER | Plant Section | |
| 19 | DCT | IFLOT | ABCKZ | ABC Indicator | S/4 Hana | IFLOT | ABCKZ | ABC Indicator | |
| 20 | DCT | ILOA | INGRP | Planner Group | S/4 Hana | ILOA | INGRP | Planner Group | |
| 21 | DCT | ILOA | IWERK | Planning Plant | S/4 Hana | ILOA | IWERK | Planning Plant | |
| 22 | DCT | ILOA | GEWRK | Maintenance Work Center | S/4 Hana | ILOA | GEWRK | Maintenance Work Center | |
| 23 | DCT | ILOA | WERGW | Work Center Plant | S/4 Hana | ILOA | WERGW | Work Center Plant | |
| 24 | DCT | ILOA | BUKRS | Company Code | S/4 Hana | ILOA | BUKRS | Company Code | |
| 25 | DCT | ILOA | KOSTL | Cost Center | S/4 Hana | ILOA | KOSTL | Cost Center | |
| 26 | DCT | ILOA | TPLMA | Superior Functional Location | S/4 Hana | ILOA | TPLMA | Superior Functional Location | |
| 27 | DCT | ILOA | IEQUI | Indicator: Installation Allowed | S/4 Hana | ILOA | IEQUI | Indicator: Installation Allowed | |
| 28 | DCT | ILOA | SUBMT | Construction Type | S/4 Hana | ILOA | SUBMT | Construction Type | |
| 29 | DCT | ILOA | KOKRS | Controlling Area | S/4 Hana | ILOA | KOKRS | Controlling Area |
2. Functional Location Short Text
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | IFLOTX | TPLNR | Functional Location Number | S/4 Hana | IFLOTX | TPLNR | Functional Location Number | |
| 2 | DCT | IFLOTX | SPRAS | Language Key | S/4 Hana | IFLOTX | SPRAS | Language Key | |
| 3 | DCT | IFLOTX | PLTXT | Description of Functional Location | S/4 Hana | IFLOTX | PLTXT | Description of Functional Location |
3. Functional Location Classification
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | KSSK | KLART | Class Type | S/4 Hana | KSSK | KLART | Class Type | |
| 2 | DCT | KSSK | OBTAB | Name of Database Table for Object | S/4 Hana | KSSK | OBTAB | Name of Database Table for Object | |
| 3 | DCT | KSSK | CLASSNUM | Class Name | S/4 Hana | KSSK | CLASSNUM | Class Name | |
| 4 | DCT | KSSK | OBJEK | Object Key (Functional Location Number) | S/4 Hana | KSSK | OBJEK | Object Key (Functional Location Number) | |
| 5 | DCT | KSSK | STATU | Classification Status | S/4 Hana | KSSK | STATU | Classification Status | |
| 6 | DCT | KSSK | STDCL | Indicator: Standard Class | S/4 Hana | KSSK | STDCL | Indicator: Standard Class | |
| 7 | DCT | KSSK | KEYDATE | Valid From Date | S/4 Hana | KSSK | KEYDATE | Valid From Date | |
| 8 | DCT | KSSK | NO_DEFAULT_VALUES | Indicator: No Default Values | S/4 Hana | KSSK | NO_DEFAULT_VALUES | Indicator: No Default Values | |
| 9 | DCT | AUSP | CHARACT | Characteristic Name | S/4 Hana | AUSP | CHARACT | Characteristic Name | |
| 10 | DCT | AUSP | POSNR | Item Number | S/4 Hana | AUSP | POSNR | Item Number | |
| 11 | DCT | AUSP | ATFLV | Numerical Value - From (Floating Point) | S/4 Hana | AUSP | ATFLV | Numerical Value - From (Floating Point) | |
| 12 | DCT | AUSP | ATFLB | Numerical Value - To (Floating Point) | S/4 Hana | AUSP | ATFLB | Numerical Value - To (Floating Point) | |
| 13 | DCT | AUSP | ATCOD | Code for Value Dependency | S/4 Hana | AUSP | ATCOD | Code for Value Dependency | |
| 14 | DCT | AUSP | UNIT_FROM_ISO | Base Unit of Measure - From (ISO Code) | S/4 Hana | AUSP | UNIT_FROM_ISO | Base Unit of Measure - From (ISO Code) | |
| 15 | DCT | AUSP | UNIT_TO_ISO | Base Unit of Measure - To (ISO Code) | S/4 Hana | AUSP | UNIT_TO_ISO | Base Unit of Measure - To (ISO Code) | |
| 16 | DCT | AUSP | DATE_FROM | Lower Boundary for Date - Interval | S/4 Hana | AUSP | DATE_FROM | Lower Boundary for Date - Interval | |
| 17 | DCT | AUSP | DATE_TO | Upper Boundary for Date - Interval | S/4 Hana | AUSP | DATE_TO | Upper Boundary for Date - Interval | |
| 18 | DCT | AUSP | TIME_FROM | Lower Boundary for Time - Interval | S/4 Hana | AUSP | TIME_FROM | Lower Boundary for Time - Interval | |
| 19 | DCT | AUSP | TIME_TO | Upper Boundary for Time - Interval | S/4 Hana | AUSP | TIME_TO | Upper Boundary for Time - Interval | |
| 20 | DCT | AUSP | ATFLV | Currency Value - From (Floating Point) | S/4 Hana | AUSP | ATFLV | Currency Value - From (Floating Point) | |
| 21 | DCT | AUSP | ATFLB | Currency Value - To (Floating Point) | S/4 Hana | AUSP | ATFLB | Currency Value - To (Floating Point) | |
| 22 | DCT | AUSP | VALUE_CHAR | Characteristic Value | S/4 Hana | AUSP | VALUE_CHAR | Characteristic Value | |
| 23 | DCT | AUSP | VALUE_CHAR_LONG | Characteristic Value Long | S/4 Hana | AUSP | VALUE_CHAR_LONG | Characteristic Value Long | |
| 24 | DCT | AUSP | VALUE_NEUTRAL | Characteristic Value Neutral | S/4 Hana | AUSP | VALUE_NEUTRAL | Characteristic Value Neutral | |
| 25 | DCT | AUSP | VALUE_NEUTRAL_LONG | Characteristic Value Neutral Long | S/4 Hana | AUSP | VALUE_NEUTRAL_LONG | Characteristic Value Neutral Long | |
| 26 | DCT | AUSP | INHERITED | Indicator: Characteristic Is Inherited | S/4 Hana | AUSP | INHERITED | Indicator: Characteristic Is Inherited |
4. Functional Location Permit
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | IHSG | OBJNR | Object Number (Internal Floc Number) | S/4 Hana | IHSG | OBJNR | Object Number (Internal Floc Number) | |
| 2 | DCT | IHSG | PMSOG | Permit Key | S/4 Hana | IHSG | PMSOG | Permit Key | |
| 3 | DCT | IHSG | K_AF | Indicator: Valid for Order Release | S/4 Hana | IHSG | K_AF | Indicator: Valid for Order Release | |
| 4 | DCT | IHSG | K_AA | Indicator: Valid for Order Completion | S/4 Hana | IHSG | K_AA | Indicator: Valid for Order Completion | |
| 5 | DCT | IHSG | K_DRUCK | Printout of Permit Papers | S/4 Hana | IHSG | K_DRUCK | Printout of Permit Papers | |
| 6 | DCT | IHSG | K_PRO | Indicator: Permit Proposed During Processing | S/4 Hana | IHSG | K_PRO | Indicator: Permit Proposed During Processing |
5. Functional Location User Status
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | IHPA | OBJNR | Object Number (Internal Floc Number) | S/4 Hana | IHPA | OBJNR | Object Number (Internal Floc Number) | |
| 2 | DCT | IHPA | OBTYP | Object Type | S/4 Hana | IHPA | OBTYP | Object Type | |
| 3 | DCT | IHPA | PARVW | Partner Function | S/4 Hana | IHPA | PARVW | Partner Function | |
| 4 | DCT | IHPA | PARNR | Partner | S/4 Hana | IHPA | PARNR | Partner |
5. Functional Location Partner
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | JEST | OBJNR | Object Number (Internal Floc Number) | S/4 Hana | JEST | OBJNR | Object Number (Internal Floc Number) | |
| 2 | DCT | JSTO | STSMA | Status profile of the functional location | S/4 Hana | JSTO | STSMA | Status profile of the functional location | |
| 3 | DCT | JEST | STAT | Status Number in User Status List | S/4 Hana | JEST | STAT | Status Number in User Status List | |
| 4 | DCT | JEST | INACT | Indicator: Status Is Inactive | S/4 Hana | JEST | INACT | Indicator: Status Is Inactive |
5. Functional Location Long Text Header
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | IFLOT | TPLNR | Functional Location Number | S/4 Hana | IFLOT | TPLNR | Functional Location Number | |
| 2 | DCT | IFLOTX | KZLTX | Long Text Exists | S/4 Hana | IFLOTX | KZLTX | Long Text Exists | |
| 3 | DCT | STXL | TDOBJECT | Texts: application object | S/4 Hana | STXL | TDOBJECT | Texts: application object | |
| 4 | DCT | STXL | TDNAME | Name | S/4 Hana | STXL | TDNAME | Name | |
| 5 | DCT | STXL | TDID | Text ID | S/4 Hana | STXL | TDID | Text ID | |
| 6 | DCT | STXL | TDSPRAS | Language Key | S/4 Hana | STXL | TDSPRAS | Language Key |
5. Functional Location Long Text Line
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | IFLOT | TPLNR | Functional Location Number | S/4 Hana | IFLOT | TPLNR | Functional Location Number | |
| 2 | DCT | STXL | TDOBJECT | Texts: application object | S/4 Hana | STXL | TDOBJECT | Texts: application object | |
| 3 | DCT | STXL | TDNAME | Name | S/4 Hana | STXL | TDNAME | Name | |
| 4 | DCT | STXL | TDID | Text ID | S/4 Hana | STXL | TDID | Text ID | |
| 5 | DCT | STXL | TDSPRAS | Language Key | S/4 Hana | STXL | TDSPRAS | Language Key | |
| 6 | DCT | STXL | TDFORMAT | Tag column | S/4 Hana | STXL | TDFORMAT | Tag column | |
| 7 | DCT | STXL | TDLINE | Text Line | S/4 Hana | STXL | TDLINE | Text Line |
List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register.
| Mapping Table Name | Mapping Table Description |
|---|---|
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Ensure DCT tables completeness | Syniti |
| 2 | Ensure all Transformation mappings are up to date | Syniti |
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 data load into target system using load tool
- 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 re-upload 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 | T370S - Structure Indicators with edit masks |
| 2 | T370F - Functional Location Category |
| 3 | T370K - Object Type |
| 4 | TCURC - Currency |
| 5 | T005 - Country of manufacturer |
| 6 | T001W - Maintenance Plant |
| 7 | T357 - Plant Section |
| 8 | T370C - ABC indicator |
| 9 | T399I - Planning Plant |
| 10 | T024I - Planner Group |
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| 1006 | Work Centre |
| 1074 | Cost Center |
| 1001 | BOM |
| 1015 | Characteristics |
| 1009 | Class |
| 1008 | Catalog Profile |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
Configuration | Invalid Structure indicator missing | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid Functional location cat missing | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid Object Type | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid Weight Unit | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid Currency | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid Country of Manufacturer | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid Maintenance Plant | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid Plant Section | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid ABC indicator | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid Planning Plant | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid Planner Group | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid catalog profile | Engage Functional team to expedite and fix the error in the system |
Configuration | Invalid Location | Engage Functional team to expedite and fix the error in the system |
Invalid Data | Invalid Cost Centre | Expedite whether the master data is changed in the system |
Invalid Data | Invalid Class | Expedite whether the master data is changed in the system |
Invalid Data | Invalid Work Centre | Expedite whether the master data is changed in the system |
Invalid Data | Invalid BOM | Expedite whether the master data is changed 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 Functional Location 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 Functional Location 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.
- Functional Location is in scope based on data design and any exception requested by business.
- All data cleansing and preparation has been completed.
See also
Change log
Workflow history
| Title | Last Updated By | Updated | Status | |
|---|---|---|---|---|
| There are no pages at the moment. | ||||