Skip to Content
Technical Articles
Author's profile photo Anikesh Jyotishi

SAP TDMS Basic functionality and Control system setup

 

Overview

SAP Test Data Migration Server (TDMS) working as an ETL tool, its enable to copy of real-time production data to a non-production environment for training and projects SITs/UATs.

SAP Test Data Migration Server is a high-speed data extraction tool that transfers relevant business data from your SAP production system to your development, test, quality assurance, or training system.

By enabling the transfer of just the relevant set of application data from the SAP production system, SAP TDMS allows you to create a lean and consistent non-production system.

SAP TDMS can be used in the test phase of SAP Application Lifecycle Management.

 

DISCLAIMER

The content of this blog post is provided “AS IS”. This information could contain technical inaccuracies, typographical errors, and out-of-date information. This document may be updated or changed without notice at any time. Use of the information is therefore at your own risk. In no event shall SAP be liable for special, indirect, incidental, or consequential damages resulting from or related to the use of this document.

 

SAP TDMS Architecture: –

All SAP TDMS Applications run in a 3-tier architecture. Business uses this application to copy real-time data from production to non-production environment for training and testing.

 

SAP TDMS Benefits:-

  • Sensitive data protection in the non-production environment
  • Availability of real-time data in development and test environments
  • Quick and efficient data refresh in the non-production environment from production
  • Reduce infrastructure expenditures by using TDMS and copying data / build reduced capacity systems with production data

 

TDMS Usages:-

 

DATA migration solutions:

 

SAP TDMS provides the following DATA migration solutions:

Time-Based Reduction: Transfers all client-specific application data within a specified time slice from the production client to a specified client in the non-production system.

Transfer of Master Data and Customizing: Transfers client-specific master data and customizing data, but not the transactional data, from the production client to a specified client in the non-production system.

Company Code and Time-Based Reduction: Transfers data belonging to specified company codes and residing in a specified time slice from the production client to a specified client in the non-production system.

Full Transfer of Client-Specific Data: Transfers all client-specific application data from the production client to a specified client in the non-production system.

Business Process Library: Transfers data specific to a business process such as sales order from the ERP production client to any client in the non-production system. You use this migration solution if you want to you want to add business process data to (or modify business process data in) the data in your current non-production system.

Transfer of Human Capital Management Data:Transfers SAP ERP HCM data, which has been filtered based on your business criteria, from the production system to the non-production system.

Data Import Through Files: Allows the export of data to a file before importing the file to the receiver system using the File Transfer Protocol or a disk.

Object-Based Reduction for Industries: Transfers data specific to business objects such as business partners, contracts, stores, or external accounts from the production system to the non-production system. You use this migration solution if you want to completely wipe out the data in the non-production client and carry out a mass transfer of business object data.

System Shell Creation: Copies repository information and cross-client Customizing from the production system to a new non-production system. The new non-production system does not contain any application data. You can use a relevant migration solution to transfer application-related data.

Stand-Alone Scrambling: Allows the scrambling of sensitive data residing in a particular non-production system without transferring data across systems.

 

TDMS Tool Setup:-

 

Major and basic steps which are required for all type of data copy.

 

Source system: – DMIS and DMIS_CNT installed in the source system, Data copy user required with sap_all role.

Receiver system:- DMIS and DMIS_CNT installed in the receiver system, Data copy user required with sap_all role. The receiver system is on the same release as that of the sender system, repository objects are identical to those in the sender system.

Central system and control system (Main TDMS SYSTEM): – NW system with DMIS and DMIS_CNT add-ons

TDMS Central system setup :-

Use SAP maintenance planner and Install NW 7.5 ABAP system with SAP_BW, DMIS, and DMIS_CNT components, Start installation you will get the below components in the system.

 

NetWeaver Business Client (common)

– Profile Parameters

– login/create_sso2_ticket 3 Change with RSPFPAR to         2

– login/accept_sso2_ticket 1

– sapgui/user_scripting FALSE Change with RSPFPAR to         TRUE

NetWeaver Business Client 3.0, 3.5 or 4.0  (min. Release 7.02 SP02)

ICF Node Active  :- /sap/bc/nwbc

ICF Node Active   :- /sap/bc/gui/sap/its/

Roles :-

– Required for logon user        SAP_TDMS_NWBC_30               Assign role to current user

Connection Data

– URL:       https://Hostname:<httpport>/sap/bc/nwbc

– Type:      ABAP

– Client:    200

– Language:  EN

 

Check general ICF Nodes

– /SAP/PUBLIC/MYSSOCNTL

– /SAP/PUBLIC/BC/ICF

– /SAP/PUBLIC/BC/ICONS

– /SAP/PUBLIC/BC/ICONS_RTL

– /SAP/PUBLIC/BC/ITS

– /SAP/PUBLIC/BC/PICTOGRAMS

– /SAP/PUBLIC/BC/UR

– /SAP/PUBLIC/BC/WEBDYNPRO

– /SAP/PUBLIC/BC/WEBICONS

Check Web Dynpro Applications

Activate all services by TDMS_ACT_SICF tcode

Web Dynpro Application ICF Node Active
/SLOAP/BTP_AN_UI /sap/bc/webdynpro/sloap/btp_an_ui
BTP /sap/bc/webdynpro/sap/btp
BTP_BLUEPRINTS_POWL /sap/bc/webdynpro/sap/btp_blueprints_powl
BTP_BLUEPRINTS_POWL_TDMS /sap/bc/webdynpro/sap/btp_blueprints_powl_tdms
BTP_BLUEPRINT_OIF /sap/bc/webdynpro/sap/btp_blueprint_oif
BTP_BPCART_V2 /sap/bc/webdynpro/sap/btp_bpcart_v2
BTP_CHK_PROFMON /sap/bc/webdynpro/sap/btp_chk_profmon
BTP_CONTMGMT_OIF /sap/bc/webdynpro/sap/btp_contmgmt_oif
BTP_CONTMGMT_TDMS /sap/bc/webdynpro/sap/btp_contmgmt_tdms
BTP_DOCUDISPLAY /sap/bc/webdynpro/sap/btp_docudisplay
BTP_DOCUOBJECT /sap/bc/webdynpro/sap/btp_docuobject
BTP_HOME /sap/bc/webdynpro/sap/btp_home
BTP_INTERFACES_V2_EXT_MNT /sap/bc/webdynpro/sap/btp_interfaces_v2_ext_mnt
BTP_INTERFACES_V2_GLOBAL /sap/bc/webdynpro/sap/btp_interfaces_v2_global
BTP_LANDSCAPE_OIF /sap/bc/webdynpro/sap/btp_landscape_oif
BTP_LANDSCAPE_POWL /sap/bc/webdynpro/sap/btp_landscape_powl
BTP_LANDSCAPE_POWL_TDMS /sap/bc/webdynpro/sap/btp_landscape_powl_tdms
BTP_LANDSCAPE_V2_GAF /sap/bc/webdynpro/sap/btp_landscape_v2_gaf
BTP_PCLACTIVITY_OIF /sap/bc/webdynpro/sap/btp_pclactivity_oif
BTP_PCLPACKAGE_HELPER_OIF /sap/bc/webdynpro/sap/btp_pclpackage_helper_oif
BTP_PCLPACKAGE_OIF /sap/bc/webdynpro/sap/btp_pclpackage_oif
BTP_PCLPROCSTEPS_OIF /sap/bc/webdynpro/sap/btp_pclprocsteps_oif
BTP_PEMBLOCK_OIF /sap/bc/webdynpro/sap/btp_pemblock_oif
BTP_PORTFOLIO /sap/bc/webdynpro/sap/btp_portfolio
BTP_PORTFOLIO_TDMS /sap/bc/webdynpro/sap/btp_portfolio_tdms
BTP_PROJECT_OIF /sap/bc/webdynpro/sap/btp_project_oif
BTP_PROJECT_POWL /sap/bc/webdynpro/sap/btp_project_powl
BTP_PROJECT_POWL_TDMS /sap/bc/webdynpro/sap/btp_project_powl_tdms
BTP_SYST_LANDS_VALUE_HELP /sap/bc/webdynpro/sap/btp_syst_lands_value_help
BTP_ULV /sap/bc/webdynpro/sap/btp_ulv
BTP_WC2_CONTENT /sap/bc/webdynpro/sap/btp_wc2_content
CNVMBT_UI_CHANGE_DEL_TECH /sap/bc/webdynpro/sap/cnvmbt_ui_change_del_tech
CNVMBT_UI_EXCLUDE_DEL_TAB /sap/bc/webdynpro/sap/cnvmbt_ui_exclude_del_tab
CNVMBT_UI_MASS_STARTER /sap/bc/webdynpro/sap/cnvmbt_ui_mass_starter
CNVMBT_UI_SEL_DATEXTRACT /sap/bc/webdynpro/sap/cnvmbt_ui_sel_datextract
CNVTDMS_HCM_PD_PA_APPL /sap/bc/webdynpro/sap/cnvtdms_hcm_pd_pa_appl
CNVTDMS_SCR_COPY /sap/bc/webdynpro/sap/cnvtdms_scr_copy
CNVTDMS_SCR_OIF_APPL /sap/bc/webdynpro/sap/cnvtdms_scr_oif_appl
CNVTDMS_SCR_OIF_GROUP /sap/bc/webdynpro/sap/cnvtdms_scr_oif_group
CNVTDMS_SCR_OIF_MAP /sap/bc/webdynpro/sap/cnvtdms_scr_oif_map
CNVTDMS_SCR_OIF_PARAMS /sap/bc/webdynpro/sap/cnvtdms_scr_oif_params
CNVTDMS_SCR_OIF_RULE /sap/bc/webdynpro/sap/cnvtdms_scr_oif_rule
CNVTDMS_SCR_OIF_SOLCAT /sap/bc/webdynpro/sap/cnvtdms_scr_oif_solcat
CNVTDMS_SCR_OIF_TREE /sap/bc/webdynpro/sap/cnvtdms_scr_oif_tree
CNVTDMS_SCR_OVERVIEW_POWL /sap/bc/webdynpro/sap/cnvtdms_scr_overview_powl
CNVTDMS_SCR_OV_MAIN /sap/bc/webdynpro/sap/cnvtdms_scr_ov_main
CNVTDMS_SCR_SIMULATION /sap/bc/webdynpro/sap/cnvtdms_scr_simulation
CNVTDMS_SCR_TRO_SHOOTER /sap/bc/webdynpro/sap/cnvtdms_scr_tro_shooter
CNVTDMS_UI_BI_TABLE_RED /sap/bc/webdynpro/sap/cnvtdms_ui_bi_table_red
CNVTDMS_UI_BPL /sap/bc/webdynpro/sap/cnvtdms_ui_bpl
CNVTDMS_UI_BPL_OVW /sap/bc/webdynpro/sap/cnvtdms_ui_bpl_ovw
CNVTDMS_UI_BPL_SRCH_HELP /sap/bc/webdynpro/sap/cnvtdms_ui_bpl_srch_help
CNVTDMS_UI_BP_REEXEC_PKG /sap/bc/webdynpro/sap/cnvtdms_ui_bp_reexec_pkg
CNVTDMS_UI_BP_VIEW_TABLES /sap/bc/webdynpro/sap/cnvtdms_ui_bp_view_tables
CNVTDMS_UI_CHOOSE_OFFICE /sap/bc/webdynpro/sap/cnvtdms_ui_choose_office
CNVTDMS_UI_CNVMBTRENAME /sap/bc/webdynpro/sap/cnvtdms_ui_cnvmbtrename
CNVTDMS_UI_CONFIRM_SET /sap/bc/webdynpro/sap/cnvtdms_ui_confirm_set
CNVTDMS_UI_DATA_TRAN_VOL /sap/bc/webdynpro/sap/cnvtdms_ui_data_tran_vol
CNVTDMS_UI_DAT_SLICE_DATE /sap/bc/webdynpro/sap/cnvtdms_ui_dat_slice_date
CNVTDMS_UI_DDIC_COMPARE /sap/bc/webdynpro/sap/cnvtdms_ui_ddic_compare
CNVTDMS_UI_EC_TABLE_RED /sap/bc/webdynpro/sap/cnvtdms_ui_ec_table_red
CNVTDMS_UI_EXCLUDE_HR /sap/bc/webdynpro/sap/cnvtdms_ui_exclude_hr
CNVTDMS_UI_GETERPPACK /sap/bc/webdynpro/sap/cnvtdms_ui_geterppack
CNVTDMS_UI_GET_PLAN_VER /sap/bc/webdynpro/sap/cnvtdms_ui_get_plan_ver
CNVTDMS_UI_IS_BANK_SEL_CRI /sap/bc/webdynpro/sap/cnvtdms_ui_is_bank_sel_cri
CNVTDMS_UI_SELECT_CCODES /sap/bc/webdynpro/sap/cnvtdms_ui_select_ccodes
CNVTDMS_UI_SELECT_IS_UTIL /sap/bc/webdynpro/sap/cnvtdms_ui_select_is_util
CNVTDMS_UI_SELECT_ORGUNIT /sap/bc/webdynpro/sap/cnvtdms_ui_select_orgunit
CNVTDMS_UI_SHL_MOD_EXC_TB /sap/bc/webdynpro/sap/cnvtdms_ui_shl_mod_exc_tb
CNVTDMS_UI_SWITCHOFF_OPT /sap/bc/webdynpro/sap/cnvtdms_ui_switchoff_opt
CNVTDMS_UI_SYST_ANALYSIS /sap/bc/webdynpro/sap/cnvtdms_ui_syst_analysis
CNVTDMS_UI_TS_PARAMS_MAIN /sap/bc/webdynpro/sap/cnvtdms_ui_ts_params_main
CNVTDMS_UI_TS_SELEC_MAINT /sap/bc/webdynpro/sap/cnvtdms_ui_ts_selec_maint
CNV_TDMS_HCM_CALL_EXTN_WD /sap/bc/webdynpro/sap/cnv_tdms_hcm_call_extn_wd
CNV_TDMS_HCM_EXP /sap/bc/webdynpro/sap/cnv_tdms_hcm_exp
CNV_TDMS_HCM_PA_PD /sap/bc/webdynpro/sap/cnv_tdms_hcm_pa_pd
CNV_TDMS_HCM_SELECTION /sap/bc/webdynpro/sap/cnv_tdms_hcm_selection
CNV_TDMS_SCR_FIELD_SET /sap/bc/webdynpro/sap/cnv_tdms_scr_field_set
CNV_TDMS_SCR_RULE_OIF /sap/bc/webdynpro/sap/cnv_tdms_scr_rule_oif
CNV_TDMS_SCR_RULE_POWL /sap/bc/webdynpro/sap/cnv_tdms_scr_rule_powl
CNV_TDMS_SCR_SCRAMBLING_GRO /sap/bc/webdynpro/sap/cnv_tdms_scr_scrambling_grou
CNV_TDMS_SCR_UI_SUMMARY /sap/bc/webdynpro/sap/cnv_tdms_scr_ui_summary
CNV_TDMS_UI_ANALYSIS_REP /sap/bc/webdynpro/sap/cnv_tdms_ui_analysis_rep
CNV_TDMS_UI_CONTROLCENTER /sap/bc/webdynpro/sap/cnv_tdms_ui_controlcenter
LTS /sap/bc/webdynpro/sap/lts

Check all configuration by TDMS_CFGCHK tcode

Once the tool is setup based on requirements you can create projects and start data.

 

References:-

SAP Notes 970531 and 970532.

https://help.sap.com/saphelp_tdm40/helpdata/en/9c/45210a36024280b6ebf7b85b35f82d/frameset.htm

https://help.sap.com/doc/a949b3f450814c62b139164c2719fef5/4.0.14/en-US/JUNE2018_MASTERGUIDE_V21.pdf

890797 – SAP TDMS – required and recommended system settings

 

TDMS can be used for Applications Business Suite:-

SAP ERP, SAP ERP HCM, SAP CRM, SAP SCM, SAP SRM, Industry Solutions, AFS Banking (Loans and Deposits), Oil & Gas (Downstream), Utilities, CRM for Utilities Healthcare, DIMP Retail Other SAP NetWeaver BW, SAP GTS

 

I hope this document will help you to understand TDMS basic concept,

 

Cheers!

Anikesh Jyotishi

 

 

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Aanchal Mamgain
      Aanchal Mamgain

      Thanks a lot Anikesh for sharing detailed information about TDMS.

       

      Regards,

       

      Vishal