Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Status

Page Status

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to create Waste Materials  Materials (Waste and Emissions) in S/4 HANA.

In legacy ECC systems (PF2, WP2), materials relevant to waste management and emissions are identified by tagging existing materials with specific roles or classifications, along with associated physical-chemical properties used for regulatory compliance. These materials are managed within the Material Master (migrated separately by the S2P team), but the environmental tagging and properties reside in EHS-related tables

Conversion Scope

The scope of this document covers the approach for converting active Waste Materials from Legacy Source Systems into S/4HANA following the Waste Materials Master Data Design Standard.

In S/4HANA, Environment, Health & Safety (EHS) functionality provides dedicated Fiori apps where users assign environmental roles to existing materials:

Transport and Disposal Logistics role for Waste-relevant materials

Emissions role for Emission-relevant materials

Physical-chemical properties relevant to waste or emissions are maintained per material.

This conversion specifically focuses on migrating:

Material-level role assignments as Waste or Emission relevant

Associated physical-chemical properties per material and region

The data from legacy system includes:

  1. Materials flagged as Waste-relevant or Emission-relevant
  2. Role assignments linking materials to environmental classifications
  3. Physical-chemical properties linked to these materials for compliance
  4. Country or region-specific tagging relevant to regulatory needs

The data from legacy system excludes:

  • Core Material Master data (already migrated by S2P team)

  • Actual waste quantities, volumes, or emissions data (thresholds, limits)

  • List of source systems and approximate number of records
    SourceScope

    Source Approx No. of Records

    Target SystemTarget Approx

    No. of Records

    WP2Waste materialsS/4 HANAPF2Emission relevant materialsS/4 HANA

    Additional Information

    Multi-language Requirement

    Document Management

    Legal Requirement

    Special Requirements

    Data Ownership & System Architecture: It is critical to highlight that the lifecycle and governance of these materials are split across two distinct functional domains:

    • Source-to-Pay (S2P) / Supply Chain: The foundational Material Master record (e.g., Basic Data, Plant Data, purchasing views) is owned and managed in S/4HANA by S2P. They are responsible for creating the base material shell.

    • Environmental Health and Safety (EHS): The environment-related and compliance-specific data (e.g., Waste Codes, Waste Types, Physical/Chemical Properties, Emissions applicability) is managed in EHS using the Manage Material Data Fiori app.

    The Role of Logistics Roles in EHS: A key driver for this specific EHS data conversion is the assignment of Logistics Roles. While S2P defines what the material is, the EHS enrichment defines how the material behaves within environmental processes. By assigning specific Logistics Roles in the Fiori app, the system dictates the material's function:

    • Transport: Identifies materials utilized in the transportation routing and documentation of waste.

    • Emission: Flags the material as a subject for environmental compliance, meaning it generates trackable emissions or is used in emission calculations.

    • Disposal: Identifies the actual physical waste product being generated, stored, and sent to a facility for disposal.

    • Note: A single material record can hold multiple logistics roles simultaneously if applicable.

    Currently, in the legacy ECC system, this data is partially represented across Material Master (MARA) and Vendor Master (LFA1 for waste disposal partners/facilities). In S/4HANA, the EHS data model requires these S2P base materials to be explicitly extended with these Logistics Roles, Chemical Compliance Information, and Waste Management parameters.

    Conversion Scope

    The scope of this document covers the approach for converting active Waste Materials from Legacy Source Systems into S/4HANA following the Waste Materials Master Data Design Standard.

    This conversion will utilize a Data Collection Template (DCT) approach. The Data Team will extract a baseline of records from ECC based on strict relevancy criteria and map them to the corresponding S2P base materials. The business will then review this baseline and enrich the DCT with S/4HANA-specific EHS attributes (like the Logistics Roles) before the final load.

    In S/4HANA, Environment, Health & Safety (EHS) provides dedicated Fiori apps where users assign environmental roles to existing materials:

    Transport and Disposal Logistics role for Waste-relevant materials

    Emissions role for Emission-relevant materials

    Physical-chemical properties relevant to waste or emissions are maintained per material.

    This conversion specifically focuses on migrating:

    Material-level role assignments as Waste or Emission relevant

    Associated physical-chemical properties per material and region

    The data from legacy system includes:

    1. Materials flagged as Waste-relevant or Emission-relevant
    2. Role assignments linking materials to environmental classifications
    3. Physical-chemical properties linked to these materials for compliance
    4. Country or region-specific tagging relevant to regulatory needs
    5. Active Materials in ECC (MARA) where the Material Type corresponds to Waste or Emission categories (e.g., FERT, HALB, or custom legacy waste material types like WAST). Note: These materials MUST be confirmed as in-scope for the S2P Material Master load.
    6. Active Vendors in ECC (LFA1/LFB1) flagged with specific Account Groups or industry codes denoting them as Waste Partners/Disposal Facilities (required to build the Waste Partner UUID relationships).
    7. Materials linked to existing environmental health and safety (EHS) specifications or hazard classifications in legacy systems.

    The data from legacy system excludes:

    1. Core Material Master data (already migrated by S2P team)

    2. Actual waste quantities, volumes, or emissions data (thresholds, limits)

    3. Materials flagged for deletion (LVORM = 'X' at client or plant level) in ECC.
    4. Standard direct/indirect procurement materials not associated with waste generation or environmental emissions.
    5. Blocked vendor accounts (Waste Partners) with no recent transactional activity.


    List of source systems and approximate number of records
    SourceScope

    Source Approx No. of Records

    Target SystemTarget Approx

    No. of Records

    WP2/PF2Active Waste/Emission MaterialsTBDS/4 HANATBD
    WP2/PF2Active Waste Partners / FacilitiesTBDS/4 HANATBD





    Additional Information

    Multi-language Requirement

    Descriptions for Materials and Waste Types must be loaded in English. 

    Document Management

    Not Applicable

    Legal Requirement

    Must align with REACH, GHS, and local environmental agency waste coding structures. Data validation must ensure EHFNDD_CCI_PURP-PURPOSE_UUID (Compliance Purpose) is accurately mapped.

    Special Requirements


    S2P Dependency: The S2P team must successfully load the base Material Master records before the EHS extension load can occur.


    Target Design

    The technical design of the target for this conversion approach.

    TableFieldData ElementField DescriptionData TypeLengthRequirement
    EHEWAD_WA_MATUUIDEHEWA_WP_MAT_UUIDWaste Material UUIDRAW16

    System generated

    EHEWAD_WA_MAT

    WASTE_PARTNER_UUID

    EHEWA_WASTE_PARTNER_UUIDWaste Partner UUIDRAW16

    System generated

    EHEWAD_WA_MAT

    FACILITY_UUID

    EHEWA_WASTE_FACILITY_UUIDWaste Disposal Facility UUIDRAW16

    System generated

    EHEWAD_WA_MATCCI_UUIDEHFND_CCI_UUIDChemical Compliance Information UUIDRAW16

    System generated

    EHEWAD_WA_MATMC_CODEEHEWA_WASTE_MC_CODEWaste Management Method CodeCHAR10Required
    EHEWAD_WA_MAT

    CREA_DATE_TIME

    TIMESTAMPLCreated OnDEC21

    System generated

    EHEWAD_WA_MATCREA_UNAMEUNAMECreated ByCHAR12

    System generated

    EHEWAD_WA_MAT

    LCHG_DATE_TIME

    TIMESTAMPLChanged OnDEC21

    System generated

    EHEWAD_WA_MATLCHG_UNAMEUNAMEChanged ByCHAR12

    System generated

    EHEWAD_WA_MAT

    DUMMY_EHEWA_MAT

    CFD_DUMMYDummy FieldCHAR1Not Used
    EHFNDD_CCI_MATUUIDEHFND_CCI_MAT_UUIDProduct Assignment UUIDRAW16

    System generated

    EHFNDD_CCI_MAT

    CREA_DATE_TIME

    TIMESTAMPLCreated On (UTC)DEC21

    System generated

    EHFNDD_CCI_MATCREA_UNAMEUNAMECreated ByCHAR12

    System generated

    EHFNDD_CCI_MAT

    LCHG_DATE_TIME

    TIMESTAMPLLast Changed On (UTC)DEC21

    System generated

    EHFNDD_CCI_MATLCHG_UNAMEUNAMELast Changed ByCHAR12

    System generated

    EHFNDD_CCI_MAT

    CHEMICAL_COMPLIANCE_UUID

    EHFND_CCI_UUIDChemical Compliance Information UUIDRAW16

    System generated

    EHFNDD_CCI_MATMATNREHFND_MAT_IDProductCHAR40Required
    EHFNDD_CCI_MATIS_PRIMARYEHFND_CCI_CCOMP_IS_PRIMARYName Representing the ProductCHAR1Conditional
    EHFNDD_CCIUUIDEHFND_CCI_UUIDChemical Compliance UUIDRAW16

    System generated

    EHFNDD_CCI

    CREA_DATE_TIME

    TIMESTAMPLCreated OnDEC21

    System generated

    EHFNDD_CCICREA_UNAMEUNAMECreated ByCHAR12

    System generated

    EHFNDD_CCI

    LCHG_DATE_TIME

    TIMESTAMPLLast Changed OnDEC21

    System generated

    EHFNDD_CCILCHG_UNAMEUNAMELast Changed ByCHAR12

    System generated

    EHFNDD_CCI

    RESPONSIBLE_UNIT

    EHFND_CCI_RESPONSIBLE_UNIT_PSSResponsible UnitCHAR10

    System generated

    EHFNDD_CCI

    RESPONSIBLE_UNIT_DGR

    EHFND_CCI_RESPONSIBLE_UNIT_DGResponsible Unit – Dangerous GoodsCHAR10Required
    EHFNDD_CCI

    INTERNAL_NAME

    EHFND_CCI_INTERNAL_NAMEInternal NameCHAR132Required
    EHFNDD_CCI

    IS_BASE_PRODUCT

    EHFND_CCI_IS_BASE_PRODUCTBase Product IndicatorCHAR1Not Used
    EHFNDD_CCIIS_SOLDEHFND_CCI_IS_SOLDSold IndicatorCHAR1Not Used
    EHFNDD_CCI

    IS_TRANSPORTED

    EHFND_CCI_IS_TRANSPORTEDTransported IndicatorCHAR1Required
    EHFNDD_CCIIS_SOURCEEHFND_CCI_IS_SOURCEDSourced IndicatorCHAR1Not Used
    EHFNDD_CCI

    IS_PRODUCED

    EHFND_CCI_IS_PRODUCEDProduced IndicatorCHAR1Not Used
    EHFNDD_CCI

    SPECIFICATION_ID

    EHFND_INTERNAL_NRSpecification IDCHAR12Not Used
    EHFNDD_CCI

    IS_RESEARCHED

    EHFND_CCI_IS_RESEARCHEDR&D Sample IndicatorCHAR1Not Used
    EHFNDD_CCI

    SPECIFICATION_REF

    EHFND_EHS_ESERECNSpecification ReferenceNUMC20

    System generated

    EHFNDD_CCITYPEEHFND_CCI_TYPECCI TypeCHAR2

    System generated

    EHFNDD_CCI

    IS_NOT_DG_RELEVANT

    EHFND_CCI_IS_NOT_DG_RLVTNot Dangerous Goods RelevantCHAR1Required
    EHFNDD_CCI

    IS_NOT_PMA_RELEVANT

    EHFND_CCI_IS_NOT_PMA_RLVTNot Product Marketability RelevantCHAR1Not Used
    EHFNDD_CCI

    IS_NOT_PS_RELEVANT

    EHFND_CCI_IS_NOT_PS_RLVTNot Product Safety RelevantCHAR1Not Used
    EHFNDD_CCI

    IS_NOT_LR_RELEVANT

    EHFND_CCI_IS_NOT_PCS_RLVTNot Legal/Regulatory RelevantCHAR1Conditional
    EHFNDD_CCI

    IS_EMISSION_RELEVANT

    EHFND_CCI_IS_EMISSION_RLVTEmission RelevantCHAR1Required
    EHFNDD_CCIIS_DISPOSEDEHFND_CCI_IS_DISPOSEDDisposed IndicatorCHAR1Required
    EHFNDD_CCIPRODUCT_CATEGORIZATION

    EHFND_CHM_PROD_CATZTNPHRS_UUID

    Chemical Product Categorization

    RAW16System generated
    EHFNDD_CCIIS_MCPEHFND_CCI_IS_MCPProduct Is a Multi-Component ProductCHAR1System generated
    EHFNDD_CCA_ADLPRUUIDEHFND_CCA_ADLPR_UUIDChemical Compliance Additional Property UUIDRAW16

    System generated

    EHFNDD_CCA_ADLPR

    CHEMICAL_COMPLIANCE_UUID

    EHFND_CCI_UUIDChemical Compliance Information UUIDRAW16

    System generated

    EHFNDD_CCA_ADLPR

    CREA_DATE_TIME

    TIMESTAMPLCreated OnDEC21

    System generated

    EHFNDD_CCA_ADLPRCREA_UNAMEUNAMECreated ByCHAR12

    System generated

    EHFNDD_CCA_ADLPR

    LCHG_DATE_TIME

    TIMESTAMPLLast Changed OnDEC21

    System generated

    EHFNDD_CCA_ADLPRLCHG_UNAMEUNAMELast Changed ByCHAR12

    System generated

    EHFNDD_CCA_ADLPR

    VERSION_NUMBER

    EHFND_VERSION_NUMBERVersion NumberINT410

    System generated

    EHFNDD_CCA_ADLPR

    RELEASE_STATUS

    EHFND_CCA_ADLPR_STATUSRelease StatusCHAR2

    System generated

    EHFNDD_CCA_ADLPRVALID_FROMEHFND_VALID_FROM_TSTMPValid FromDEC15

    System generated

    EHFNDD_CCA_ADLPRVALID_TOEHFND_VALID_TO_TSTMPValid ToDEC15

    System generated

    EHFNDD_CCA_PRPTYUUIDEHFND_CCI_PRPTYAS_UUIDProperty Assignment UUIDRAW16

    System generated

    EHFNDD_CCA_PRPTY

    CCA_ADLPR_UUID

    EHFND_CCA_ADLPR_UUIDAdditional Property UUIDRAW16

    System generated

    EHFNDD_CCA_PRPTY

    CREA_DATE_TIME

    TIMESTAMPLCreated OnDEC21

    System generated

    EHFNDD_CCA_PRPTYCREA_UNAMEUNAMECreated ByCHAR12

    System generated

    EHFNDD_CCA_PRPTY

    LCHG_DATE_TIME

    TIMESTAMPLLast Changed OnDEC21

    System generated

    EHFNDD_CCA_PRPTYLCHG_UNAMEUNAMELast Changed ByCHAR12

    System generated

    EHFNDD_CCA_PRPTY

    PROPERTY_KEY_REF

    EHFND_CCI_PRPTY_UUIDProperty Key Reference UUIDRAW16

    System generated

    EHFNDD_CCA_PRPTY

    UNIT_KEY_REF

    EHFND_CCI_PRPTY_UNIT_UUIDUnit Key Reference UUIDRAW16

    System generated

    EHFNDD_CCA_PRPTYVALUEEHFND_CCI_PRPTY_VALUEProperty ValueDF16_RAW16Conditional
    EHFNDD_CCA_PRPTYUNITEHFND_UNIT_CODEUnit of MeasureUNIT3Conditional
    EHFNDD_CCA_PRPTY

    COMMENT_TEXT

    EHFND_NAMEComment / DescriptionCHAR60Conditional
    EHFNDD_CCI_PURPUUIDEHFND_CCI_PURP_UUIDPurpose Assignment UUIDRAW16

    System generated

    EHFNDD_CCI_PURP

    CHEMICAL_COMPLIANCE_UUID

    EHFND_CCI_UUIDChemical Compliance UUIDRAW16

    System generated

    EHFNDD_CCI_PURP

    CREA_DATE_TIME

    TIMESTAMPLCreated OnDEC21

    System generated

    EHFNDD_CCI_PURPCREA_UNAMEUNAMECreated ByCHAR12

    System generated

    EHFNDD_CCI_PURP

    LCHG_DATE_TIME

    TIMESTAMPLLast Changed OnDEC21

    System generated

    EHFNDD_CCI_PURPLCHG_UNAMEUNAMELast Changed ByCHAR12

    System generated

    EHFNDD_CCI_PURP

    PURPOSE_UUID

    EHFND_CMPLNC_PRPS_UUIDPurpose UUIDRAW16

    System generated

    EHFNDD_CHM_COMPDB_KEY/BOBF/CONF_KEYRoot Node KeyRAW16

    System generated

    EHFNDD_CHM_COMPROOT_KEY/BOBF/CONF_KEYRoot KeyRAW16

    System generated

    EHFNDD_CHM_COMPPARENT_KEY/BOBF/CONF_KEYParent Node KeyRAW16

    System generated

    EHFNDD_CHM_COMPDATETIME_CR/BOBF/DATETIME_CRCreated OnDEC15

    System generated

    EHFNDD_CHM_COMPUSER_ID_CR/BOBF/USER_ID_CRCreated ByCHAR12

    System generated

    EHFNDD_CHM_COMPDATETIME_CH/BOBF/DATETIME_CHLast Changed OnDEC15

    System generated

    EHFNDD_CHM_COMPUSER_ID_CH/BOBF/USER_ID_CHLast Changed ByCHAR12

    System generated

    EHFNDD_CHM_COMP

    LIS_SUB_KEY_REF

    EHFND_LISU_ROOT_REF_KEYListed Substance Root KeyRAW16

    System generated

    EHFNDD_CHM_COMPPROPORTIONEHFND_CHM_PROPORTION_MINProportionDF16_RAW16Conditional
    EHFNDD_CHM_COMPUNITEHFND_UNIT_CODEUnitUNIT3Conditional
    EHFNDD_CHM_COMP

    EEW_CHM_COMPOS_D

    DUMMYDummy FieldCHAR1Not Used
    EHFNDD_CP_TEXT

    COMPLIANCE_PURPOSE_ID

    EHFND_CMPLNC_PRPS_IDPurpose IDCHAR15

    System generated

    EHFNDD_CP_TEXT

    COMPLIANCE_PURPOSE_UUID

    EHFND_CMPLNC_PRPS_UUIDCompliance PurposeRAW16

    System generated

    EHFNDD_CP_TEXTLANGUAGESYLANGULanguage KeyLANG1

    System generated

    EHFNDD_CP_TEXT

    COMPLIANCE_PURPOSE_NAME

    EHFND_CMPLNC_PRPS_NAMECompliance Purpose NameCHAR120Required
    EHFNDD_PHPR_NMBCO_IDEHFND_BCO_IDBCO IDCHAR40

    System generated

    EHFNDD_PHPR_NMBCO_KEYEHFND_BCO_KEYBCO KeyCHAR32

    System generated

    EHFNDD_PHPR_NMDB_KEY/BOBF/CONF_KEYNodeIDRAW16

    System generated

    EHFNDD_PHPR_NMPARENT_KEY/BOBF/CONF_KEYParent KeyRAW16

    System generated

    EHFNDD_PHPR_NMDATETIME_CR/BOBF/DATETIME_CRCreated OnDEC15

    System generated

    EHFNDD_PHPR_NMUSER_ID_CR/BOBF/USER_ID_CRCreated ByCHAR12

    System generated

    EHFNDD_PHPR_NMDATETIME_CH/BOBF/DATETIME_CHLast Changed OnDEC15

    System generated

    EHFNDD_PHPR_NMUSER_ID_CH/BOBF/USER_ID_CHLast Changed ByCHAR12

    System generated

    EHFNDD_PHPR_NMLANGUAGEEHFND_LANGULanguageLANG1

    System generated

    EHFNDD_PHPR_NMTEXTEHFND_PHYSICAL_PARAMETER_NAMENameCHAR60Required
    EHFNDD_PHPR_NM

    TEXT_NORMED

    EHFND_PHYSICAL_PARAMETER_NAMENormalized NameCHAR60

    System generated

    EHFNDD_PHPR_NM

    EEW_PHPAR_ROOT_D

    DUMMYDummy FieldCHAR1Not Used
    EHFNDD_LISU_NAMELISTSUB_IDEHFND_REGBASLST_SUBListed Substance IDCHAR12

    System generated

    EHFNDD_LISU_NAMEBCO_KEYEHFND_BCO_KEYBCO KeyCHAR32

    System generated

    EHFNDD_LISU_NAMEDB_KEY/BOBF/CONF_KEYNodeIDRAW16

    System generated

    EHFNDD_LISU_NAMEPARENT_KEY/BOBF/CONF_KEYParent KeyRAW16Not Used
    EHFNDD_LISU_NAME

    NODE_CAT_KEY

    /BOBF/CONF_KEYNode Category KeyRAW16

    System generated

    EHFNDD_LISU_NAMEDATETIME_CR/BOBF/DATETIME_CRCreated OnDEC15

    System generated

    EHFNDD_LISU_NAMEUSER_ID_CR/BOBF/USER_ID_CRCreated ByCHAR12

    System generated

    EHFNDD_LISU_NAMEDATETIME_CH/BOBF/DATETIME_CHLast Changed OnDEC15

    System generated

    EHFNDD_LISU_NAMEUSER_ID_CH/BOBF/USER_ID_CHLast Changed ByCHAR12

    System generated

    EHFNDD_LISU_NAMELANGUAGEEHFND_LANGULanguageLANG1

    System generated

    EHFNDD_LISU_NAMETEXTEHFND_LISU_NAME_TEXTListed Substance NameCHAR1333Conditional
    EHFNDD_LISU_NAME

    TEXT_NORMED

    EHFND_LONG_NAMENormalized NameCHAR255Not Used
    EHFNDD_LISU_NAME

    SEQUENCE_NUMBER

    EHFND_LISU_SEQ_NUMName Sequence NumberINT13Not Used
    EHFNDD_LISU_NAMENAME_IDEHFND_LISU_NAME_IDName IDINT410

    System generated

    EHFNDD_LISU_NAME

    EEW_LONG_TEXT_D

    DUMMYDummy FieldCHAR1Not Used


    Data Cleansing

    IDCriticalityError Message/Report DescriptionRuleOutputSource System
    CL-01High"Orphaned Legacy Vendor"Legacy vendors targeted as Waste Partners must not have a deletion flag (LFA1-LOEVM)Exclude from ExtractECC
    CL-02High"Missing Base Product in Target"If an EHS Material maps to a Product ID, that ID must exist in the approved S2P Product Master manifestReject RecordDCT
    CL-03Medium"Invalid State of Matter"State of Matter must be populated with target values (e.g., 01=Solid, 02=Liquid, 03=Gas)Flag for EnrichmentDCT
    CL-04High"Missing Logistics Role"Every material must have at least one Logistics Role marked as 'Y'Reject RecordDCT



    Conversion Process

    The high-level process is represented by the diagram below:

    For every waste material in source system, a material has to be created in target system.

    Extract all active materials from MARA from source system and determine waste materials from the list by filtering with waste in the descriptions and based on historical transactions involving materials to waste transporters/disposers. For these materials, create material using manage material data fiori app or automated process.

    Also, need to update properties, waste code details for the materials using the same fiori app "manage material data" or automated process.


    This object will be managed as a Hybrid/Enrichment DCT.

    Phase 1: Data Extraction & Baseline Generation (Data Team)

    1. Extract: Query ECC tables using the relevancy criteria.

    2. Cross-Reference: Check the extracted list against the S2P Material Master load manifest to ensure the base product will exist in S/4HANA.

    3. Generate DCT: Produce the Data Collection Template pre-populated with baseline S2P identifiers (Product ID) and descriptions.

    Phase 2: Business Enrichment (EHS Business Team)

    1. Review: EHS business stakeholders review the baseline DCT.

    2. Enrich: The business populates missing, S/4HANA-specific EHS data directly into the DCT. Key enrichment fields aligned with Fiori "Manage Material Data" include:

      • Logistics Roles: (Checkboxes for Transport, Emission, Disposal)

      • Waste Codes & Waste Type

      • Physical/Chemical Properties (State of matter, Density, Flashpoint)

      • Compliance Scenario assignments

      • Compliance purposes

    Phase 3: Validation & Load (Data Team)

    1. Validate: Run automated pre-load validations against the enriched DCT. Verify that the Material ID exists in the target system (loaded by S2P).

    2. Load: Data is loaded into S/4HANA EHS.

    Data Privacy and Sensitivity

    No PII or sensitive data is included in the Material (Waste & Emissions) data object.

    Extraction

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

    1. The data exists. Syniti Migrate connects to the source and loads the data into Syniti Migrate. 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 Syniti Migrate; 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 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 DescriptionTeam Responsible
    EX-01Extract Legacy Waste Materials from MARA / MAKT based on relevancy criteriaData Team
    EX-02Extract Legacy Waste Vendors from LFA1 / LFB1 based on Selection ScreenData Team
    EX-03Cross-reference extracted legacy materials against the final S2P Product Master load manifest.Data Team
    EX-04Generate pre-populated DCT containing Legacy Material IDs, Material Descriptions, and Legacy Vendor IDs for Business Enrichment.Data Team


    Selection Screen

    Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set





















    Data Collection Template (DCT)

    Target Ready Data Collection Template will be created for Waste Materials data with exception of some fields which require transformation as mentioned in the transformation rule.

    Material (Waste and Emissions) DCT Rules

    Field NameField DescriptionRule
    MC_CODE Waste Management Method CodeRequired. Format rules: Length – 4. Data Type – CHAR.

    Allowed values/reference: Refer to EHEWAC_MC_CODE > Field = EHEWA_WASTE_MC_CODE.

    Conditional logic: NA.

    Multi-language: NA.

    Comments: Determines waste treatment or disposal type.
    MATNR Product ID / Material Number linked to Compliance data

    Required. Format rules: As per Material Master configuration.

    Data Type – CHAR.

    Length -  40

    Allowed values/reference: Must exist in SAP Material Master (MARA-MATNR).

    Conditional logic: Only one primary compliance assignment allowed per material.

    Multi-language:
    Inherited from Material Master

    IS_PRIMARY Name Representing the ProductConditional. Format rules: Boolean (X/Blank). Data Type – CHAR, Length - 1. 

    Allowed values/reference: ‘X’ = Primary.

    Conditional logic: Only one record per material can be flagged as Primary.
    Multi-language: NA.

    Comments: Identifies primary compliance linkage.
    RESPONSIBLE_UNIT_DGR Responsible Unit – Dangerous GoodsRequired if DG relevant. Format rules: As per Org Unit format.

    Data Type – CHAR. Length - 10

    Allowed values/reference: Must exist in approved DG organizational structure.

    Conditional logic: Mandatory when DG indicator is active.

    Multi-language: NA. Comments: Responsible unit for DG compliance.
    INTERNAL_NAME Internal NameRequired. Format rules:

    Data Type – CHAR. Length -132

    Allowed values/reference: NA

    Conditional logic: NA.

    Multi-language: NA

    Comments: Internal product name for compliance reporting.
    IS_TRANSPORTED Transported IndicatorRequired. Format rules: Boolean (X/Blank).

    Data Type – CHAR, Length- 1. 

    Allowed values/reference: ‘X’ = Transported.

    Conditional logic: If ‘X’, DG compliance data must exist.

    Multi-language: NA.

    Comments: Indicates transport relevance.
    IS_NOT_DG_RELEVANTNot Dangerous Goods RelevantConditional. Format rules: Boolean (X/Blank). Data Type – CHAR, Length - 1. 

    Allowed values/reference: ‘X’ = Not DG Relevant.

    Conditional logic: Cannot conflict with transport indicator.

    Multi-language: NA.

    Comments: Identifies DG exclusion.
    IS_NOT_LR_RELEVANTNot Legal/Regulatory RelevantConditional. Format rules: Boolean (X/Blank). Data Type – CHAR, Length - 1. 

    Allowed values/reference: ‘X’ = Not LR Relevant.

    Conditional logic: If flagged, legal reporting objects not generated.

    Multi-language: NA.

    Comments: Legal/regulatory relevance indicator.
    IS_EMISSION_RELEVANTEmission RelevantConditional. Format rules: Boolean (X/Blank).

    Data Type – CHAR, Length - 1. Allowed values/reference: ‘X’ = Emission Relevant. 

    Conditional logic: Mandatory to be maintained

    Multi-language: NA.

    Comments: Emission reporting relevance.
    IS_DISPOSEDDisposed IndicatorConditional. Format rules: Boolean (X/Blank).

    Data Type – CHAR, Length - 1

    Allowed values/reference: ‘X’ = Disposed.

    Conditional logic: NA

    Multi-language: NA.

    Comments: Disposal relevance indicator.
    TEXTNameConditional. Format rules: Data Type – CHAR, Length - 60
    Allowed values/reference:

    Conditional logic: Must align with disposal indicator.

    Multi-language: NA. Comments: Disposal relevance indicator.
    VALUEProperty ValueRequired. Format rules: Numeric; precision per property type.

    Data Type – DEC/CHAR (config dependent).
    Length - 16
    Allowed values/reference: Must align with property definition.

    Conditional logic: To be provided only if required or available

    Multi-language: NA.
    Comments: Stores compliance property value.
    UNITUnit of MeasureRequired. Format rules: Valid Unit of Measure.

    Data Type – CHAR. Allowed values/reference: Refer to SAP UoM table (T006).
    Length - 3
    Conditional logic: Must correspond to property type.

    Multi-language: As per UoM settings.

    Comments: Unit for property value.
    COMMENT_TEXTComment / DescriptionOptional. Format rules: .

    Data Type – STRING/CHAR. Allowed values/reference: System text length limit applies.
    Length - 60
    Conditional logic: NA. Multi-language: Supported.


    Comments: Regulatory explanation or remarks.
    TEXTListed Substance Name

    Optional. Format rules: .

    Length - 1333
    Data Type – CHAR Allowed values/reference: EHFNDD_LISU_NAME > TEXT

    Conditional logic: Required only if maintaining Analytical Composition
    Multi-language: NA


    Comments: NA

    PROPORTIONProportionOptional. Format rules:
    Data Type – DF16_RAW. Allowed values/reference: 16
    Length - 16
    Conditional logic: NA. Multi-language: NA


    Comments: NA
    UNITUnit

    Optional. Format rules:

    Length -  3

    Data Type –UNIT. Allowed values/reference: T006

    Conditional logic: NA. Multi-language: NA


    Comments: NA

    COMPLIANCE_PURPOSE_NAMECompliance Purpose Name

    Optional. Format rules: .

    Length - 120
    Data Type –CHAR. Allowed values/reference: Values from EHFNDD_CP_TEXT >COMPLIANCE_PURPOSE_NAME

    Conditional logic: NA. Multi-language: NA


    Comments: NA

    Waste_typeWaste type

    Format rules:

    Data type: Char, Length: 30

    Allowed values: Hazardous, Non-Hazardous, Universal

    Conditional logic: NA. Multi-language: NA


    Comments: NA

    Extraction Dependencies

    Item #Step DescriptionTeam Responsible
    1Source-to-Pay (S2P) team finalizes and freezes the target Product Master migration manifest.S2P
    2S/4HANA EHS configuration for Waste Codes, Waste Types, and Compliance Purposes is finalized and provided to the Data Team for value mapping.S2S Functional




    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 Syniti Migrate 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 Syniti Migrate.
    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

    Item #Step DescriptionTeam Responsible
    1Ingest baseline legacy extract into migration tool/staging environment.Data Team
    2Ingest fully enriched DCT from the EHS Business Data Owners.Data Team
    3Execute Transformation Logic (Joins, Value Mapping, Defaulting).Data Team
    4Generate Target-Ready Load File for Pre-Load Validation.Data Team


    Transformation Rules

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
    1DCT/ECCMAKTINTERNAL_NAMEINTERNAL NAMES/4 HANAEHFNDD_CCIINTERNAL_NAMEINTERNAL NAMEDirect Map. Pass value exactly as enriched in DCT.
    2DCT/ECCMARAMATNRProduct ID / Material Number linked to Compliance dataS/4 HANAEHFNDD_CCI_MATMATNRProduct IDDirect mapping
    3DCT
    IS_TRANSPORTEDTRANSPORT IndicatorS/4 HANAEHFNDD_CCIIS_TRANSPORTEDTRANSPORT IndicatorIf DCT = 'Y', pass 'X' (True). Else pass ' ' (False).
    4DCT
    IS_EMISSION_RELEVANTEMISSION_RELEVANT indicatorS/4 HANAEHFNDD_CCIIS_EMISSION_RELEVANTEMISSION_RELEVANT indicatorIf DCT = 'Y', pass 'X' (True). Else pass ' ' (False).
    5DCT
    IS_DISPOSEDDISPOSAL indicatorS/4 HANAEHFNDD_CCIIS_DISPOSEDDISPOSAL indicatorIf DCT = 'Y', pass 'X' (True). Else pass ' ' (False).
    6DCT
    RESPONSIBLE_UNIT_DGRResponsible unit for DGS/4 HANAEHFNDD_CCIRESPONSIBLE_UNIT_DGRResponsible unit for DGDirect mapping
    7DCT
    MC_CODEWaste codeS/4 HANAEHEWAD_WA_MATMC_CODEWaste codeDirect mapping
    8DCT
    WASTE_TYPEWASTE TYPES/4 HANAEHFNDD_WA_MATWASTE_TYPEWASTE TYPEDirect mapping
    9DCT
    COMPLIANCE_PURPOSE_NAMECompliance Purpose NaMES/4 HANAEHFNDD_CP_TEXTCOMPLIANCE_PURPOSE_NAMECompliance Purpose nameDirect mapping
    10DCT
    IS_PRIMARYName Representing the Product(Indicator)S/4 HANAEHFNDD_CCI_MATIS_PRIMARYName Representing the Product(Indicator)Direct mapping
    11DCT
    IS_NOT_DG_RELEVANTNot Dangerous S/4 HANAEHFNDD_CCIIS_NOT_DG_RELEVANTNot Dangerous Direct mapping
    12DCT
    IS_NOT_LR_RELEVANTNot Legal/Regulatory RelevantS/4 HANAEHFNDD_CCIIS_NOT_LR_RELEVANTNot Legal/Regulatory RelevantDirect mapping
    13DCT
    TEXTProperty NameS/4 HANAEHFNDD_PHPR_NMTEXTNameDirect mapping
    14DCT
    VALUEProperty ValueS/4 HANAEHFNDD_CCA_PRPTYVALUEProperty ValueDirect mapping
    15DCT
    UNITUnit of MeasureS/4 HANAEHFNDD_CCA_PRPTYUNITUnit of MeasureDirect mapping
    16DCT
    COMMENT_TEXTComment / DescriptionS/4 HANAEHFNDD_CCA_PRPTYCOMMENT_TEXTComment / DescriptionDirect mapping
    17DCT
    TEXTListed Substance NameS/4 HANAEHFNDD_LISU_NAMETEXTListed Substance NameDirect mapping
    18DCT
    PROPORTIONProportionS/4 HANA

    Target Design

    The technical design of the target for this conversion approach.

    TableFieldData ElementField DescriptionData TypeLengthRequirementEHEWAD_WA_MATUUIDWaste Material UUID

    System generated

    EHEWAD_WA_MAT

    WASTE_PARTNER_UUID

    Waste Partner UUID

    System generated

    EHEWAD_WA_MAT

    FACILITY_UUID

    Waste Disposal Facility UUID

    System generated

    EHEWAD_WA_MATCCI_UUIDChemical Compliance Information UUID

    System generated

    EHEWAD_WA_MATMC_CODEWaste Management Method CodeRequiredEHEWAD_WA_MAT

    CREA_DATE_TIME

    Created On

    System generated

    EHEWAD_WA_MATCREA_UNAMECreated By

    System generated

    EHEWAD_WA_MAT

    LCHG_DATE_TIME

    Changed On

    System generated

    EHEWAD_WA_MATLCHG_UNAMEChanged By

    System generated

    EHEWAD_WA_MAT

    DUMMY_EHEWA_MAT

    Dummy FieldNot UsedEHFNDD_CCI_MATUUIDProduct Assignment UUID

    System generated

    EHFNDD_CCI_MAT.INCLUDEAdministrative Data Include

    System generated

    EHFNDD_CCI_MAT

    CREA_DATE_TIME

    Created On (UTC)

    System generated

    EHFNDD_CCI_MATCREA_UNAMECreated By

    System generated

    EHFNDD_CCI_MAT

    LCHG_DATE_TIME

    Last Changed On (UTC)

    System generated

    EHFNDD_CCI_MATLCHG_UNAMELast Changed By

    System generated

    EHFNDD_CCI_MAT

    CHEMICAL_COMPLIANCE_UUID

    Chemical Compliance Information UUID

    System generated

    EHFNDD_CCI_MATMATNRProductRequiredEHFNDD_CCI_MATIS_PRIMARYName Representing the ProductConditionalEHFNDD_CCIUUIDChemical Compliance UUID

    System generated

    EHFNDD_CCI.INCLUDEAdmin Include

    System generated

    EHFNDD_CCI

    CREA_DATE_TIME

    Created On

    System generated

    EHFNDD_CCICREA_UNAMECreated By

    System generated

    EHFNDD_CCI

    LCHG_DATE_TIME

    Last Changed On

    System generated

    EHFNDD_CCILCHG_UNAMELast Changed By

    System generated

    EHFNDD_CCI

    RESPONSIBLE_UNIT

    Responsible Unit

    System generated

    EHFNDD_CCI

    RESPONSIBLE_UNIT_DGR

    Responsible Unit – Dangerous GoodsRequiredEHFNDD_CCI

    INTERNAL_NAME

    Internal NameRequiredEHFNDD_CCI

    IS_BASE_PRODUCT

    Base Product IndicatorNot UsedEHFNDD_CCIIS_SOLDSold IndicatorNot UsedEHFNDD_CCI

    IS_TRANSPORTED

    Transported IndicatorRequiredEHFNDD_CCIIS_SOURCESourced IndicatorNot UsedEHFNDD_CCI

    IS_PRODUCED

    Produced IndicatorNot UsedEHFNDD_CCI

    SPECIFICATION_ID

    Specification IDNot UsedEHFNDD_CCI

    IS_RESEARCHED

    R&D Sample IndicatorNot UsedEHFNDD_CCI

    SPECIFICATION_REF

    Specification Reference

    System generated

    EHFNDD_CCITYPECCI Type

    System generated

    EHFNDD_CCI

    IS_NOT_DG_RELEVANT

    Not Dangerous Goods RelevantRequiredEHFNDD_CCI

    IS_NOT_PMA_RELEVANT

    Not Product Marketability RelevantNot UsedEHFNDD_CCI

    IS_NOT_PS_RELEVANT

    Not Product Safety RelevantNot UsedEHFNDD_CCI

    IS_NOT_LR_RELEVANT

    Not Legal/Regulatory RelevantConditionalEHFNDD_CCI

    IS_EMISSION_RELEVANT

    Emission RelevantRequiredEHFNDD_CCIIS_DISPOSEDDisposed IndicatorRequiredC_CHMLCMPLNCPRIMMATLDEX

    PRODSTEWARDSHIPRESPUNIT

    Responsible UnitConditionalC_CHMLCMPLNCPRIMMATLDEX

    CHMLCMPLNCINFOUUID

    Chemical Compliance UUID

    System generated

    C_CHMLCMPLNCPRIMMATLDEX

    DNGRGSDRESPUNIT

    Responsible Unit for DGConditionalC_CHMLCMPLNCPRIMMATLDEX

    CHMLCMPLNCINFOTYPE

    CCI TypeNot UsedC_CHMLCMPLNCPRIMMATLDEX

    CHMLCMPLNCINTERNALNAME

    Internal Name

    System generated

    C_CHMLCMPLNCPRIMMATLDEX

    MATERIALISBASEPRODUCT

    Is Base ProductNot UsedC_CHMLCMPLNCPRIMMATLDEX

    MATERIALISSOLD

    Is SoldNot UsedC_CHMLCMPLNCPRIMMATLDEX

    MATERIALISTRANSPORTED

    Is TransportedRequiredC_CHMLCMPLNCPRIMMATLDEX

    MATERIALISSOURCED

    Is PurchasedNot UsedC_CHMLCMPLNCPRIMMATLDEX

    MATERIALISPRODUCED

    Is ProducedNot UsedC_CHMLCMPLNCPRIMMATLDEX

    MATERIALISDISPOSED

    Is DisposedRequiredC_CHMLCMPLNCPRIMMATLDEX

    MATERIALISEMISSIONRELVNT

    Product is Emission RelevantNot UsedC_CHMLCMPLNCPRIMMATLDEX

    SPECIFICATION

    Specification

    System generated

    C_CHMLCMPLNCPRIMMATLDEX

    SPECIFICATIONINTERNALID

    Internal Number

    System generated

    C_CHMLCMPLNCPRIMMATLDEX

    CHMLCMPLNCPRODISRESEARCHED

    R&D SampleNot UsedC_CHMLCMPLNCPRIMMATLDEX

    CHMLCMPLNCMATLASSGMUUID

    Product Assignment

    System generated

    C_CHMLCMPLNCPRIMMATLDEXMATERIALProduct

    System generated

    EHFNDD_CCA_ADLPRUUIDChemical Compliance Additional Property UUID

    System generated

    EHFNDD_CCA_ADLPR

    CHEMICAL_COMPLIANCE_UUID

    Chemical Compliance Information UUID

    System generated

    EHFNDD_CCA_ADLPR.INCLUDEAdmin Data Include

    System generated

    EHFNDD_CCA_ADLPR

    CREA_DATE_TIME

    Created On

    System generated

    EHFNDD_CCA_ADLPRCREA_UNAMECreated By

    System generated

    EHFNDD_CCA_ADLPR

    LCHG_DATE_TIME

    Last Changed On

    System generated

    EHFNDD_CCA_ADLPRLCHG_UNAMELast Changed By

    System generated

    EHFNDD_CCA_ADLPR

    VERSION_NUMBER

    Version Number

    System generated

    EHFNDD_CCA_ADLPR

    RELEASE_STATUS

    Release Status

    System generated

    EHFNDD_CCA_ADLPRVALID_FROMValid From

    System generated

    EHFNDD_CCA_ADLPRVALID_TOValid To

    System generated

    EHFNDD_CCA_PRPTYUUIDProperty Assignment UUID

    System generated

    EHFNDD_CCA_PRPTY

    CCA_ADLPR_UUID

    Additional Property UUID

    System generated

    EHFNDD_CCA_PRPTY.INCLUDEAdmin Data Include

    System generated

    EHFNDD_CCA_PRPTY

    CREA_DATE_TIME

    Created On

    System generated

    EHFNDD_CCA_PRPTYCREA_UNAMECreated By

    System generated

    EHFNDD_CCA_PRPTY

    LCHG_DATE_TIME

    Last Changed On

    System generated

    EHFNDD_CCA_PRPTYLCHG_UNAMELast Changed By

    System generated

    EHFNDD_CCA_PRPTY

    PROPERTY_KEY_REF

    Property Key Reference UUID

    System generated

    EHFNDD_CCA_PRPTY

    UNIT_KEY_REF

    Unit Key Reference UUID

    System generated

    EHFNDD_CCA_PRPTYVALUEProperty ValueConditionalEHFNDD_CCA_PRPTYUNITUnit of MeasureConditionalEHFNDD_CCA_PRPTY

    COMMENT_TEXT

    Comment / DescriptionConditionalEHFNDD_CCI_PURPUUIDPurpose Assignment UUID

    System generated

    EHFNDD_CCI_PURP

    CHEMICAL_COMPLIANCE_UUID

    Chemical Compliance UUID

    System generated

    EHFNDD_CCI_PURP.INCLUDEAdmin Data Include

    System generated

    EHFNDD_CCI_PURP

    CREA_DATE_TIME

    Created On

    System generated

    EHFNDD_CCI_PURPCREA_UNAMECreated By

    System generated

    EHFNDD_CCI_PURP

    LCHG_DATE_TIME

    Last Changed On

    System generated

    EHFNDD_CCI_PURPLCHG_UNAMELast Changed By

    System generated

    EHFNDD_CCI_PURP

    PURPOSE_UUID

    Purpose UUID

    System generated

    EHFNDD_CHM_COMPDB_KEYRoot Node Key

    System generated

    EHFNDD_CHM_COMPROOT_KEYRoot Key

    System generated

    EHFNDD_CHM_COMPPARENT_KEYParent Node Key

    System generated

    EHFNDD_CHM_COMPDATETIME_CRCreated On

    System generated

    EHFNDD_CHM_COMPUSER_ID_CRCreated By

    System generated

    EHFNDD_CHM_COMPDATETIME_CHLast Changed On

    System generated

    EHFNDD_CHM_COMPUSER_ID_CHLast Changed By

    System generated

    EHFNDD_CHM_COMP

    LIS_SUB_KEY_REF

    Listed Substance Root KeySystem generated
    EHFNDD_CHM_COMPPROPORTIONProportion
    Required
    Direct mapping
    19DCT
    EHFNDD_CHM_COMP

    UNITUnit
    Required
    S/4 HANAEHFNDD
    _CHM_COMPEEW
    _CHM_
    COMPOS_DDummy FieldNot Used

    Data Cleansing

    IDCriticalityError Message/Report DescriptionRuleOutputSource SystemN/AN/AN/AN/AN/AN/A

    Conversion Process

    The high-level process is represented by the diagram below:

    For every material in source system of material type WAST, a material has to be created in target system.

    Extract all materials from MARA from source system and filter with material type WAST. For these materials, create material using manage material data fiori app or automated process.

    Also, need to update properties, waste code details for the materials using the same fiori app "manage material data" or automated process.

    COMPUNITUnitDirect mapping


    Transformation Mapping

    Mapping Table NameMapping Table Description








    Transformation Dependencies

    List the steps that need to occur before transformation can commence
    Item #Step DescriptionTeam Responsible
    1Business completely fills out and signs off on the Enriched DCT. Business
    2S2P team provides the final Vendor-to-Business Partner cross-reference mapping file.Data Team




    Pre-Load Validation

    Project Team

    Completeness

    TaskAction
    Identify duplicateCheck for material ID field to check for duplicates. If found, remove the rows
    Identify blanksCheck for material ID field to check for any blank fields. If found, remove the rows
    Load File Record Count VerificationCompare the total number of records in the Target-Ready load file against the approved DCT to ensure no record drops occurred during transformation.

    Accuracy

    TaskAction
    S2P Dependency Referential IntegrityCompare the Product ID in the load file against the S/4HANA MARA table to check for any discrepancies 
    BP Dependency Referential IntegrityCompare the mapped WASTE_PARTNER against the S/4HANA BUT000 table to ensure the Business Partner exists.

    Business

    Completeness

    TaskAction
    Validate the total countCompare the count of materials in the load file vs MARA extract with materials containing waste in the description
    DCT Sign-offBusiness Data Owner confirms all applicable active legacy environmental materials are accounted for in the final DCT.

    Accuracy

    TaskAction
    Transformation Data VerificationBusiness to review random sample of the transformed data file to ensure critical EHS attributes, such as Logistics Roles and Waste Codes, have been accurately mapped according to the agreed business rules.


    Load

    The load process includes:

    1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
    2. 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 DescriptionTeam Responsible
    1Validate S2P Material/Product Master and BP loads are 100% complete and active in target system.Data Team
    2Execute data loadData Team
    3Download load error logs and resolve any immediate technical failures.Data Team


    Load Phase and Dependencies

    Configuration

    Item #Configuration Item
    1Waste Codes 
    2Compliance Purposes and Dangerous Goods regulations activated in target system.

    Conversion Objects

    Object #Preceding Object Conversion Approach

    list the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram)
    1Product Master
    2Business Partner (Vendor)

    Error Handling

    Error TypeError DescriptionAction Taken
    Dependency Error"Base S2P Product ID does not exist in target system"Data Team must pause load for that record and verify Product Master status with the Supply Chain track.
    Validation Error"Product is not flagged as Compliance Relevant"Data Team must request S2P to update the Product Master Basic Data view for the linked Material ID.
    Validation Error"Waste Code XXXXX is not recognized"Data Team to verify with EHS Functional if configuration is missing, or send back to Business for DCT correction.
    Dependency Error"Waste Partner (BP) does not exist"Verify S2P/Finance Business Partner load logs. Hold EHS record until BP is successfully loaded.


    Post-Load Validation

    Project Team

    Completeness

    TaskAction
    Table Record CountExtract records from EHEWAD_WA_MAT and compare against the total successful records in the migration load file.

    Accuracy

    TaskAction
    Linkage ValidationExtract table records and validate if S2P product link is correctly populated and verify the Compliance Purposes in EHFNDD_CHM_COMP.

    Business

    Completeness

    TaskAction
    Fiori App VerificationLog into the Fiori Launchpad. Open the Manage Material Data app. Validate that the expected volume of Waste and Emission materials appear in the active list view.

    Accuracy

    TaskAction
    Fiori UI Spot CheckOpen a 10% sample of materials. Navigate through the tabs to visually verify that Logistics Roles (Transport, Emission, Disposal checkboxes), Waste Codes, and Dangerous Goods compliance purposes accurately reflect the original enriched DCT.


    Data Privacy and Sensitivity

    Extraction

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

    1. The data exists. connects to the source and loads the data into . 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 ; 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 . 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 DescriptionTeam Responsible

    Selection Screen

    Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set

    Data Collection Template (DCT)

    Target Ready Data Collection Template will be created for Waste Materials data with exception of some fields which require transformation as mentioned in the transformation rule.

    DCT Rules

    Field NameField DescriptionRule

    Extraction Dependencies

    Item #Step DescriptionTeam Responsible

    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

    Item #Step DescriptionTeam Responsible

    Transformation Rules

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic

    Transformation Mapping

    Mapping Table NameMapping Table Description

    Transformation Dependencies

    List the steps that need to occur before transformation can commenceItem #Step DescriptionTeam Responsible

    Pre-Load Validation

    Project Team

    Completeness

    TaskActionIdentify duplicateCheck for material ID field to check for duplicates. If found, remove the rowsIdentify blanksCheck for material ID field to check for any blank fields. If found, remove the rows

    Accuracy

    TaskAction

    Business

    Completeness

    TaskActionValidate the total countCompare the count of materials in the load file vs MARA extract with WAST material type

    Accuracy

    TaskAction

    Load

    The load process includes:

    1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
    2. 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 DescriptionTeam Responsible

    Load Phase and Dependencies

    Configuration

    Item #Configuration Item

    Conversion Objects

    Object #Preceding Object Conversion Approachlist the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram)

    Error Handling

    Error TypeError DescriptionAction Taken

    Post-Load Validation

    Project Team

    Completeness

    TaskAction

    Accuracy

    TaskAction

    Business

    Completeness

    TaskAction

    Accuracy

    TaskAction

    Key Assumptions

    • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
    • Materials (Waste & Emissions) is in scope based on data design and any exception requested by business.
    • All predecessor objects (Product Master, Business Partner) will be fully loaded, validated, and active in the S/4HANA production client prior to the EHS cutover window.


    See also

    Change log

    Change History
    limit10