Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Corrected the table name for field SMTP_ADDR
Status

Page Status

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to create TM-Locations in S/4 HANA TM (Transportation management).

In SAP Transportation Management (TM), a location represents a physical or logical place where goods or resources are handled or stored. These locations are fundamental to transportation planning, serving as source, destination, or intermediate stops within the transportation network. 

Locations are the most granular objects in the transportation network. They are used for further definitions, such as transportation lanes, and so on. They are classified using a location type.

TM locations can be created in S4 from plants, shipping points, suppliers, customers etc using standard SAP report /SAPAPO/CREATE_LOCATION. For the cases where Locations need to be separately created e.g. incoterm locations, the data for TM Locations in S/4 would need to be constructed in the data collection template (DCT).


Conversion Scope

The scope of this document covers the approach for converting active from Legacy Source Systems into creating TM Locations in S/4HANA following the TM-Locations Master Data Design Standard. This includes:

  • Capturing and using the TM Locations data in data collection template (DCT).
  • Applying transformation logic via Syniti to conform with the S/4 HANA data model.
  • Loading the transformed data into SAP S/4 HANA while ensuring data integrity.

The data from legacy system includes:

  1. N/A (Manual data collection)

The data from legacy system excludes:

  1. N/A (Manual data collection)


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

DCTCreation of TM LocationsTBDS/4 HANA (TM)TBD















Additional Information

Multi-language Requirement

Location description will be made available in English.

Multi language is supported for locations. Login via a different language will show the description displayed in the logon language if the language key is maintained.

Document Management

Not Applicable

Legal Requirement

Not Applicable

Special Requirements

Not Applicable




Target Design

The complete information of the key fields that hold the TM Location information follows the Master Data Standard document.

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLengthRequirementNotes
/SAPAPO/LOCLOCNOLOCNO

Location

CHAR20MandatoryLocation no would be input by user
/SAPAPO/LOCLOCTYPELOCTYPELocation TypeCHAR4Mandatory
/SAPAPO/LOCTSPRASSPRAS

Language Key



CHAR1MandatoryMulti language is supported for locations.
/SAPAPO/LOCTDESCR40DESCR40Location DescriptionCHAR40Mandatory
/SAPAPO/LOC
tzone
TZONETZONETimezoneCHAR6Optional
/SAPAPO/
LOCADR
LOCUNLOCODEUNLOCODEUN/LOCODECHAR5Optional
/SAPAPO/LOCIATACODEIATACODEIATA CodeCHAR3Optional
/SAPAPO/LOCPARTNER_GUIDPARTNER_GUIDBusinessPartnerCHAR16Optional
/SAPAPO/LOCADV_SHP_RECV_RLVADV_SHP_RECV_RLV

Advanced Shipping and Receiving Relevance

CHAR1OptionalValues: 1 or empty
Syensqo Locations with EWM we put 1, rest "empty"
ADRCTITLETITLETitleCHAR4Optional

ADRC

NAME1NAME1

Name 1

CHAR40Optional

/SAPAPO/LOCADR

ADRC

ADRC

HOUSE_NUM1HOUSE_NUM1

House Number

CHAR10Optional

ADRC

STREETSTREET

STREET

CHAR60Optional

/SAPAPO/LOCADR

ADRC

ADRC

CITY1CITY1

City

CHAR40Optional

/SAPAPO/LOCADR

ADRC

ADRC

POST_CODE1POST_CODE1

City postal code

CHAR10Optional

/SAPAPO/LOCADR

ADRC

COUNTRY

COUNTRY

CHAR2

ADRC

COUNTRYCOUNTRY

COUNTRY

CHAR2Optional

ADRC

REGIONREGION

REGION

CHAR3Optional

ADRC

SORT1SORT1

Search Term 1


CHAR20Optional

ADRC

LANGULANGU

Language

CHAR1Optional

ADRC

TEL_NUMBERTEL_NUMBER

Telephone

CHAR30Optional

ADR6

SMTP_ADDRSMTP_ADDR

Email

CHAR241Optional

/SAPAPO/LOCMAP

WM_LOGSYSWM_LOGSYS

SAP EWM Target System

CHAR10Optional

/SAPAPO/LOCMAP

WM_WH_NUMBERWM_WH_NUMBER

SAP EWM Warehouse Number

CHAR4Optional

/SAPAPO/LOC

TIME_RESTIME_RES

Operating Time Inbound

CHAR22Optional

/SAPAPO/

LOCADR

ADRC

REGIONREGION

LOC

TIME_RES_OUTTIME_RES_OUT

Operating Time Outbound

CHAR
3
22Optional


Data Cleansing

TM Location data will be populated directly in the Data Collection Template (DCT).

IDCriticalityError Message/Report DescriptionRuleOutputSource System


























Conversion Process

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

Data Privacy and Sensitivity

Please note that the data may have to be loaded in multiple target systems (US instance, China instance and RoW).

Image Added

Data Privacy and Sensitivity


Extraction

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

    Extraction Run Sheet

    Req #Requirement DescriptionTeam Responsible
    1Data is populated in the DCT or uploaded from downloaded Excel templateData owner (Business)
    2If the data is uploaded to DCT in bulk via excel template, any upload errors need to be reviewed and correctedData owner (Business), Syniti/ Data Team
    3The data which has passed validation checks in DCT will be used for transformation/further processingSyniti




    Selection Screen

    Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set





















    Data Collection Template (DCT)

    A Target Ready Data Collection Template will be created for

    data with exception of some fields which require transformation as mentioned in the transformation rule.

    the required data, except for fields that need transformation as per the defined transformation rules. It will follow the format required by the target S/4HANA TM Location.

    Please find below the DCT details (main DCT page and another page for non English descriptions).

    Google Drive Live Link
    urlhttps://docs.google.com/spreadsheets/d/1uwJC90JCj3R6JocsN_LcyIlAAniO00Z5vVhReHJDJDs/edit?gid=1969652361#gid=1969652361

     DCT Rules

    Please refer to the above Google sheet for the DCT rules. DCT Rules

    Field NameField DescriptionRule












    Extraction Dependencies

    Not applicable.

    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 Syniti platform 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 platform
    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
    1Capture the data for TM Location in DCT. Review and correct any errors if bulk uploading data via downloaded excel DCT template.Business team
    2Ensure the mapping tables which are needed during transformation have been reviewed and signed off by business.Business team, Data Team (SCM)
    3Obtain DCT Sign-off from BusinessData Team (SCM)
    4Generate Pre-Load reportsData Team (Syniti)
    5Review and Validate Error and Preload ReportsData Team (SCM)
    6Log errors as defects, if any and address resolutions.Data Team (SCM)
    7Re-transform and re-validate the Pre-load reports if necessary.Data Team (SCM), Data Team (Syniti)
    8Obtain preload validation sign-off from BusinessBusiness + Functional (SCM) + Data Team (SCM)
    9Generate Load FilesData Team (Syniti)


    Transformation Rules

    Please check the attached file for the complete source-to-target field mapping, validation checks and proposed error messages. The validation checks list is not exhaustive and may change over time as the design and configuration of the system evolves.

    Google Drive Live Link
    urlhttps://docs.google.com/spreadsheets/d/1fOAYJhvfqW5FWV25iRvmMWiDw7JQpEvHNMSzmYpknp8/edit?gid=0#gid=0

    Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation LogicNotes
    1051-001DCT


    S/4 HANA/SAPAPO/LOCLOCNOLocationDirect Mapping

    DCT


    S/4 HANA/SAPAPO/LOCLOCTYPELocation TypeDirect Mapping

    DCT


    S/4 HANA/SAPAPO/LOCTSPRASLanguage KeyDirect Mapping

    DCT


    S/4 HANA/SAPAPO/LOCTDESCR40Location DescriptionDirect Mapping

    DCT


    S/4 HANA/SAPAPO/LOCTZONETimezoneDirect Mapping

    DCT


    S/4 HANA/SAPAPO/LOCUNLOCODEUN/LOCODEDirect Mapping

    DCT


    S/4 HANA/SAPAPO/LOCIATACODEIATA CodeDirect Mapping

    DCT


    S/4 HANAN/AzLegacySysSource systemThis will be used together with legacy vendor or customer in determining the new (S4) BP number

    DCT


    S/4 HANA/SAPAPO/LOCPARTNER_GUIDBusiness PartnerValue mapping: Use the legacy to SAP vendor and customer mapping table to determine the new (S4) BP numberBusiness partner should exist in SAP.

    DCT


    S/4 HANA/SAPAPO/LOCADV_SHP_RECV_RLVAdvanced Shipping and Receiving RelevanceDirect Mapping

    DCT


    S/4 HANAADRCTITLETitleDirect Mapping

    DCT


    S/4 HANAADRCNAME1Name 1Direct Mapping

    DCT


    S/4 HANAADRCHOUSE_NUM1House NumberDirect Mapping

    DCT


    S/4 HANAADRCSTREETStreetDirect Mapping

    DCT


    S/4 HANAADRCCITY1CityDirect Mapping

    DCT


    S/4 HANAADRCPOST_CODE1Postal codeDirect MappingCountry specific postal code check should be made to validate the accuracy.

    DCT


    S/4 HANAADRCCOUNTRYCountryDirect Mapping

    DCT


    S/4 HANAADRCREGIONRegionDirect Mapping

    DCT


    S/4 HANAADRCSORT1Search Term 1Direct Mapping

    DCT


    S/4 HANAADRCLANGULanguageDirect Mapping

    DCT


    S/4 HANAADRCTEL_NUMBERTelephoneDirect Mapping

    DCT


    S/4 HANAADR6SMTP_ADDREmailDirect Mapping

    DCT


    S/4 HANA

    /SAPAPO/LOCMAP

    WM_LOGSYS

    SAP EWM Target System

    Direct Mapping

    DCT


    S/4 HANA

    /SAPAPO/LOCMAP

    WM_WH_NUMBER

    SAP EWM Warehouse Number

    Direct Mapping

    DCT


    S/4 HANA

    /SAPAPO/LOC

    TIME_RES

    Operating Time Inbound

    Direct Mapping

    DCT


    S/4 HANA

    /SAPAPO/LOC

    TIME_RES_OUT

    Operating Time Outbound

    Direct Mapping

    List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register.

    Transformation Mapping

    Field NameMapping Table NameMapping Table Description
    PARTNER_GUIDVendor Number and Customer Number

    i) LIFNR: Old Vendor Code to New Vendor Code cross reference

    ii) KUNNR: Old to New Customer No.










    Transformation Dependencies

    List the steps that need to occur before transformation can commence
    Item #Step DescriptionTeam Responsible
    1Ensure DCT tables completenessData Team (SCM)
    2Value Mappings are according to the latest designFunctional Team (SCM) + Data Team (SCM)
    3SAP Transportation management configuration for TM Locations is completeFunctional Team (SCM) + Data Team (SCM)
    4Dependent Master Data records for Resources and Business Partners are loadedFunctional Team (SCM) + Data Team (SCM)


    Pre-Load Validation

    Project Team

    Completeness

    TaskAction
    Check ValuesValidate the pre-load data confirming the values are aligned with target system format
    Validate template structure and required field populationEnsure mandatory fields like Location, Location type, Description are filled
    Verify Record CountSCM Data Team to verify that the total number of relevant records from the  DCT is equal to the total number of records in the Preload and Load Sheets

    Accuracy

    TaskAction
    Conversion Accuracy

    SCM 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
    Perform format validation (date, currency, decimal separators)Standardize format to match SAP accepted input (e.g., YYYYMMDD for dates)
    Review Error ReportsReview 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.
    Conduct dry runs using LTMC or BAPIs and review logsAnalyze load results and correct format or conversion errors

    Business

    Completeness

    TaskAction
    Verify Record CountBusiness Data Owner/s to verify that the total number of relevant records from the the DCT is equal to the total number of records in the Preload validation file.





    Accuracy

    TaskAction
    Conversion Accuracy

    Business Data Owner/s to verify that all the data in the preload validation file is accurate as per endorsed transformation/mapping rules (and signed-off DCT data).

    Review error reports in tool for any mismatch or missing transformed values.






    Load

    The load process includes:

    1. Execute the automated data load into target system using load tool or product produce 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 with side by side check of each fields in scope of the objects with fields to be displayed as XXXX_DCT, XXXX_S4HANA, XXXX_MATCH ( As TRUE or FALSE) with an additional column denoting fields not matching and status of loading in S/4HANA as LOADED_IN_S4HANA ( As TRUE or FALSE) 

    Function_Loader_Inlay program or Custom Migration Cockpit Object (LTMOM) will have to be used for automated load of default routes to SAP S/4 HANA TM. There is no standard object available in SAP Migration Cockpit for Default routes. The load file format can be finalized when development system is available.

    BAPI: BAPI_LOCSRVAPS_SAVEMULTI2

    Load Run Sheet

    Item #Step DescriptionTeam Responsible
    1Ensure the load tools are transported into the correct system/instance.Data Team (SCM)
    2Ensure Pre-load sign-offs are obtained.Data Team (SCM)
    3Execute upload of TM Locations using Function_Loader_Inlay program or Custom Migration Cockpit Object.Data Team (SCM)
    4Validate few records loaded by accessing standard transactions from S/4HANA E.g. Fiori app 'Define Location'.Data Team (SCM)
    5

    Generate the post load reports in tool.

    The following fields should be used to form a key for postload comparison:

    /SAPAPO/LOC-LOCNO
    /SAPAPO/LOC-LOCTYPE

    Data Team (SCM), Data Team (Syniti)
    6Log errors as defects, if any and address resolutions. Close defects.Data Team (SCM)
    7Resolve defects by reupload and re-generate post load reports if necessary.Data Team (SCM), Data Team (Syniti)
    8Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off.Business team
    9Repeat steps 5 to 7 if necessary.Data Team (SCM), Data Team (Syniti)


    Load Phase and Dependencies

    TM Locations data will be loaded in the pre-cutover window.

    Configuration

    Item #Configuration Item
    1

    SAP Transportation management configuration for Location

    • Define IATA location codes (Table: /SCMTMS/C_IATAC)
    • Define UN/LOCODE (Table: /SCMTMS/C_UNLOC)
    • Define Geocoding levels (Table: /SAPAPO/LOC_GL)
    • Define GIS zone (Table: /SCMB/GIS_ZONE)
    2T002 - Language Keys


    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

    1195TM Resources (only for the specific Locations where Operating time inbound/outbound fields are going to be maintained)
    3007Business Partners - General


    Error Handling

    As part of the TM Locations data load to S/4HANA  using the Syniti data migration tool, various data quality, configuration, and technical challenges may arise.

    The following table outlines the most commonly observed error types during data load, and the corrective actions typically taken to resolve them. This helps ensure consistency in issue handling, improves traceability during cutover, and supports smooth end-to-end execution of the default routes load.

    Error TypeError DescriptionAction Taken
    ConfigurationInvalid or missing SAP TM Locations configurationEngage Functional team to expedite and fix the error in the system
    Formatting ErrorsOne or more key fields are incorrectly formattedEnsure formatting is done correctly
    Authorization ErrorsLack of access to execute load in target client/systemRaised access request; obtained necessary authorizations
    Transformation MissRequired transformation logic not applied before loadRe-applied transformation rules and revalidated source-target mapping
    Technical Load FailureFile not processed due to syntax/format error or system issueReviewed logs; regenerated file; re-executed load after resolving issue


    Post-Load Validation

    Project Team

    Completeness

    TaskAction
    Run Fiori app/tcode to check loaded data in SAPRun Fiori app 'Define Location' to check if data has been loaded 
    Compare uploaded data against source file valuesUse Custom reconciliation tools e.g. SQL Server or Excel based comparison tools to validate the number of records loaded against the load file record volume
    Check for load errors in load toolReview custom load tool or Legacy Transfer Migration Cockpit LTMC logs for any failures

    Accuracy

    TaskAction
    Compare uploaded data against source file valuesUse automated postload validation report or standard reports from S/4 HANA to validate field by field value match across all loaded records





    Business

    Completeness

    TaskAction
    Verify CountDownload Postload validation reports from Syniti and verify that the record count loaded in the target S/4 HANA is the same count as of the endorsed load file.
    Review loaded TM LocationsAccess the S/4HANA system (via Fiori app Define Location) to view loaded TM Locations



    Accuracy

    TaskAction
    Compare Against Approved Load FileCross-check data in S/4HANA against the final business-approved load file used for migration
    Validate Accuracy of Converted/Transformed DataReview any transformed fields (e.g., business partner number) for correctness
    Log and Report DiscrepanciesUse provided discrepancy log format or defect management tool to report any findings


    Key Assumptions

    • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
    • TM Location is in scope based on data design and any exception requested by business.
    • Data entries in DCT are target-ready data unless a specific transformation rule is stated for that field in the transformation rules.
    • The list of validation checks in transformation section is not exhaustive and may change over time as the design and configuration of the system evolves.


    See also

    Change log

    Change History
    limit10

    Workflow history

    Workflow Report
    parent@self
    hideheadertrue
    typeapprovals