Technical Articles
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
Thanks a lot Anikesh for sharing detailed information about TDMS.
Regards,
Vishal