SAP CNV_TDMS_SCR_SET_DATA Function Module for Write Data to Database
CNV_TDMS_SCR_SET_DATA is a standard cnv tdms scr set data SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Write Data to Database processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.
See here to view full function module documentation and code listing for cnv tdms scr set data FM, simply by entering the name CNV_TDMS_SCR_SET_DATA into the relevant SAP transaction such as SE37 or SE38.
Function Group: CNV_TDMS_SCR
Program Name: SAPLCNV_TDMS_SCR
Main Program: SAPLCNV_TDMS_SCR
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Remote-Enabled
Update:
Function CNV_TDMS_SCR_SET_DATA pattern details
In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.CALL FUNCTION 'CNV_TDMS_SCR_SET_DATA'"Write Data to Database.
EXPORTING
I_TABNAME = "Table Name
TABLES
* IT_APPL_INS = "Application Master Table for Scrambling
* IT_GRPHI_INS = "Scrambling Groups Hierarchy
* IT_GRPT_INS = "Scrambling Groups Text Table
* IT_RULE_INS = "Scrambling Rules
* IT_RULET_INS = "Scrambling Rule Texts
* IT_GRLNK_INS = "Link Table : Connects Rules and Groups
* IT_MTYP_INS = "Mapping Types for Scrambling
* IT_MTYPT_INS = "Mapping Types Texts
* IT_MID_INS = "Mapping ID's for Scrambling
* IT_MIDT_INS = "Mapping ID Texts
* IT_MLNK_INS = "Link Table : Connects Mapping ID's to Rules
* IT_APPLT_INS = "Application Text Table
* IT_APLNK_INS = "Link Table : Connects Application to Process type
* IT_PROC_INS = "Process types
* IT_PROCT_INS = "Process type Texts
* IT_RSTAT_INS = "Scrambling Rules Preselection Statistics
* IT_FMID_INS = "Scrambling Random ID
* IT_COND_INS = "Scrambling Condition Sets
* IT_KEYST_INS = "Scrambling Keyset for rule
* IT_RANID_INS = "Scrambling Random ID
* IT_APPL_DEL = "Application Master Table for Scrambling
* IT_APPLT_DEL = "Application Text Table
* IT_CULNK_INS = "Link Table : Connects CWB Packages to TDMS Scrambling UI
* IT_CULNK_DEL = "Link Table : Connects CWB Packages to TDMS Scrambling UI
* IT_DOMS_DEL = "List of Domains Assigned to a Rule
* IT_FLDS_DEL = "List of Tables and Fields Assigned to a Rule
* IT_FPARS_DEL = "Parameters assigned to the Rules
* IT_DPARS_DEL = "Parameters assigned to the Rules
* IT_INCL_DEL = "List of Includes Assigned to a RUle
* IT_GRP_DEL = "Scrambling Groups
* IT_GRPHI_DEL = "Scrambling Groups Hierarchy
* IT_GRPT_DEL = "Scrambling Groups Text Table
* IT_RULE_DEL = "Scrambling Rules
* IT_DOMS_INS = "List of Domains Assigned to a Rule
* IT_RULET_DEL = "Scrambling Rule Texts
* IT_GRLNK_DEL = "Link Table : Connects Rules and Groups
* IT_MTYP_DEL = "Mapping Types for Scrambling
* IT_MTYPT_DEL = "Mapping Types Texts
* IT_MID_DEL = "Mapping ID's for Scrambling
* IT_MIDT_DEL = "Mapping ID Texts
* IT_MLNK_DEL = "Link Table : Connects Mapping ID's to Rules
* IT_APLNK_DEL = "Link Table : Connects Application to Process type
* IT_PROC_DEL = "Process Types
* IT_PROCT_DEL = "Process Types
* IT_FLDS_INS = "List of Tables and Fields Assigned to a Rule
* IT_RSTAT_DEL = "Scrambling Rules Preselection Statistics
* IT_FMID_DEL = "Scrambling Random ID
* IT_RANID_DEL = "Scrambling Random ID
* IT_COND_DEL = "Scrambling Condition Sets
* IT_KEYST_DEL = "Scrambling Keyset for rule
* IT_FPARS_INS = "Parameters assigned to the Rules
* IT_DPARS_INS = "Parameters assigned to the Rules
* IT_INCL_INS = "List of Includes Assigned to a RUle
* IT_GRP_INS = "Scrambling Groups
EXCEPTIONS
ERROR_IN_DELETION = 1 ERROR_IN_INSERTION = 2
IMPORTING Parameters details for CNV_TDMS_SCR_SET_DATA
I_TABNAME - Table Name
Data type: TABNAMEOptional: No
Call by Reference: No ( called with pass by value option)
TABLES Parameters details for CNV_TDMS_SCR_SET_DATA
IT_APPL_INS - Application Master Table for Scrambling
Data type: CNVTDMSSCR_APPLOptional: Yes
Call by Reference: Yes
IT_GRPHI_INS - Scrambling Groups Hierarchy
Data type: CNVTDMSSCR_GRPHIOptional: Yes
Call by Reference: Yes
IT_GRPT_INS - Scrambling Groups Text Table
Data type: CNVTDMSSCR_GRPTOptional: Yes
Call by Reference: Yes
IT_RULE_INS - Scrambling Rules
Data type: CNVTDMSSCR_RULEOptional: Yes
Call by Reference: Yes
IT_RULET_INS - Scrambling Rule Texts
Data type: CNVTDMSSCR_RULETOptional: Yes
Call by Reference: Yes
IT_GRLNK_INS - Link Table : Connects Rules and Groups
Data type: CNVTDMSSCR_GRLNKOptional: Yes
Call by Reference: Yes
IT_MTYP_INS - Mapping Types for Scrambling
Data type: CNVTDMSSCR_MTYPOptional: Yes
Call by Reference: Yes
IT_MTYPT_INS - Mapping Types Texts
Data type: CNVTDMSSCR_MTYPTOptional: Yes
Call by Reference: Yes
IT_MID_INS - Mapping ID's for Scrambling
Data type: CNVTDMSSCR_MIDOptional: Yes
Call by Reference: Yes
IT_MIDT_INS - Mapping ID Texts
Data type: CNVTDMSSCR_MIDTOptional: Yes
Call by Reference: Yes
IT_MLNK_INS - Link Table : Connects Mapping ID's to Rules
Data type: CNVTDMSSCR_MLNKOptional: Yes
Call by Reference: Yes
IT_APPLT_INS - Application Text Table
Data type: CNVTDMSSCR_APPLTOptional: Yes
Call by Reference: Yes
IT_APLNK_INS - Link Table : Connects Application to Process type
Data type: CNVTDMSSCR_APLNKOptional: Yes
Call by Reference: Yes
IT_PROC_INS - Process types
Data type: CNVTDMSSCR_PROCOptional: Yes
Call by Reference: Yes
IT_PROCT_INS - Process type Texts
Data type: CNVTDMSSCR_PROCTOptional: Yes
Call by Reference: Yes
IT_RSTAT_INS - Scrambling Rules Preselection Statistics
Data type: CNVTDMSSCR_RSTATOptional: Yes
Call by Reference: Yes
IT_FMID_INS - Scrambling Random ID
Data type: CNVTDMSSCR_FMIDOptional: Yes
Call by Reference: Yes
IT_COND_INS - Scrambling Condition Sets
Data type: CNVTDMSSCR_CONDOptional: Yes
Call by Reference: Yes
IT_KEYST_INS - Scrambling Keyset for rule
Data type: CNVTDMSSCR_KEYSTOptional: Yes
Call by Reference: Yes
IT_RANID_INS - Scrambling Random ID
Data type: CNVTDMSSCR_RANIDOptional: Yes
Call by Reference: Yes
IT_APPL_DEL - Application Master Table for Scrambling
Data type: CNVTDMSSCR_APPLOptional: Yes
Call by Reference: Yes
IT_APPLT_DEL - Application Text Table
Data type: CNVTDMSSCR_APPLTOptional: Yes
Call by Reference: Yes
IT_CULNK_INS - Link Table : Connects CWB Packages to TDMS Scrambling UI
Data type: CNVTDMSSCR_CULNKOptional: Yes
Call by Reference: Yes
IT_CULNK_DEL - Link Table : Connects CWB Packages to TDMS Scrambling UI
Data type: CNVTDMSSCR_CULNKOptional: Yes
Call by Reference: Yes
IT_DOMS_DEL - List of Domains Assigned to a Rule
Data type: CNVTDMSSCR_DOMSOptional: Yes
Call by Reference: Yes
IT_FLDS_DEL - List of Tables and Fields Assigned to a Rule
Data type: CNVTDMSSCR_FLDSOptional: Yes
Call by Reference: Yes
IT_FPARS_DEL - Parameters assigned to the Rules
Data type: CNVTDMSSCR_FPARSOptional: Yes
Call by Reference: Yes
IT_DPARS_DEL - Parameters assigned to the Rules
Data type: CNVTDMSSCR_DPARSOptional: Yes
Call by Reference: Yes
IT_INCL_DEL - List of Includes Assigned to a RUle
Data type: CNVTDMSSCR_INCLOptional: Yes
Call by Reference: Yes
IT_GRP_DEL - Scrambling Groups
Data type: CNVTDMSSCR_GRPOptional: Yes
Call by Reference: Yes
IT_GRPHI_DEL - Scrambling Groups Hierarchy
Data type: CNVTDMSSCR_GRPHIOptional: Yes
Call by Reference: Yes
IT_GRPT_DEL - Scrambling Groups Text Table
Data type: CNVTDMSSCR_GRPTOptional: Yes
Call by Reference: Yes
IT_RULE_DEL - Scrambling Rules
Data type: CNVTDMSSCR_RULEOptional: Yes
Call by Reference: Yes
IT_DOMS_INS - List of Domains Assigned to a Rule
Data type: CNVTDMSSCR_DOMSOptional: Yes
Call by Reference: Yes
IT_RULET_DEL - Scrambling Rule Texts
Data type: CNVTDMSSCR_RULETOptional: Yes
Call by Reference: Yes
IT_GRLNK_DEL - Link Table : Connects Rules and Groups
Data type: CNVTDMSSCR_GRLNKOptional: Yes
Call by Reference: Yes
IT_MTYP_DEL - Mapping Types for Scrambling
Data type: CNVTDMSSCR_MTYPOptional: Yes
Call by Reference: Yes
IT_MTYPT_DEL - Mapping Types Texts
Data type: CNVTDMSSCR_MTYPTOptional: Yes
Call by Reference: Yes
IT_MID_DEL - Mapping ID's for Scrambling
Data type: CNVTDMSSCR_MIDOptional: Yes
Call by Reference: Yes
IT_MIDT_DEL - Mapping ID Texts
Data type: CNVTDMSSCR_MIDTOptional: Yes
Call by Reference: Yes
IT_MLNK_DEL - Link Table : Connects Mapping ID's to Rules
Data type: CNVTDMSSCR_MLNKOptional: Yes
Call by Reference: Yes
IT_APLNK_DEL - Link Table : Connects Application to Process type
Data type: CNVTDMSSCR_APLNKOptional: Yes
Call by Reference: Yes
IT_PROC_DEL - Process Types
Data type: CNVTDMSSCR_PROCOptional: Yes
Call by Reference: Yes
IT_PROCT_DEL - Process Types
Data type: CNVTDMSSCR_PROCTOptional: Yes
Call by Reference: Yes
IT_FLDS_INS - List of Tables and Fields Assigned to a Rule
Data type: CNVTDMSSCR_FLDSOptional: Yes
Call by Reference: Yes
IT_RSTAT_DEL - Scrambling Rules Preselection Statistics
Data type: CNVTDMSSCR_RSTATOptional: Yes
Call by Reference: Yes
IT_FMID_DEL - Scrambling Random ID
Data type: CNVTDMSSCR_FMIDOptional: Yes
Call by Reference: Yes
IT_RANID_DEL - Scrambling Random ID
Data type: CNVTDMSSCR_RANIDOptional: Yes
Call by Reference: Yes
IT_COND_DEL - Scrambling Condition Sets
Data type: CNVTDMSSCR_CONDOptional: Yes
Call by Reference: Yes
IT_KEYST_DEL - Scrambling Keyset for rule
Data type: CNVTDMSSCR_KEYSTOptional: Yes
Call by Reference: Yes
IT_FPARS_INS - Parameters assigned to the Rules
Data type: CNVTDMSSCR_FPARSOptional: Yes
Call by Reference: Yes
IT_DPARS_INS - Parameters assigned to the Rules
Data type: CNVTDMSSCR_DPARSOptional: Yes
Call by Reference: Yes
IT_INCL_INS - List of Includes Assigned to a RUle
Data type: CNVTDMSSCR_INCLOptional: Yes
Call by Reference: Yes
IT_GRP_INS - Scrambling Groups
Data type: CNVTDMSSCR_GRPOptional: Yes
Call by Reference: Yes
EXCEPTIONS details
ERROR_IN_DELETION - Error in Data Deletion
Data type:Optional: No
Call by Reference: Yes
ERROR_IN_INSERTION - Error in Data Insertion
Data type:Optional: No
Call by Reference: Yes
Copy and paste ABAP code example for CNV_TDMS_SCR_SET_DATA Function Module
The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the newer method of declaring data variables on the fly. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8), which i why i have stuck to the origianl for this example.| DATA: | ||||
| lv_i_tabname | TYPE TABNAME, " | |||
| lt_it_appl_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_APPL, " | |||
| lv_error_in_deletion | TYPE CNVTDMSSCR_APPL, " | |||
| lt_it_grphi_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_GRPHI, " | |||
| lt_it_grpt_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_GRPT, " | |||
| lt_it_rule_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_RULE, " | |||
| lt_it_rulet_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_RULET, " | |||
| lt_it_grlnk_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_GRLNK, " | |||
| lt_it_mtyp_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_MTYP, " | |||
| lt_it_mtypt_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_MTYPT, " | |||
| lt_it_mid_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_MID, " | |||
| lt_it_midt_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_MIDT, " | |||
| lt_it_mlnk_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_MLNK, " | |||
| lt_it_applt_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_APPLT, " | |||
| lv_error_in_insertion | TYPE CNVTDMSSCR_APPLT, " | |||
| lt_it_aplnk_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_APLNK, " | |||
| lt_it_proc_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_PROC, " | |||
| lt_it_proct_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_PROCT, " | |||
| lt_it_rstat_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_RSTAT, " | |||
| lt_it_fmid_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_FMID, " | |||
| lt_it_cond_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_COND, " | |||
| lt_it_keyst_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_KEYST, " | |||
| lt_it_ranid_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_RANID, " | |||
| lt_it_appl_del | TYPE STANDARD TABLE OF CNVTDMSSCR_APPL, " | |||
| lt_it_applt_del | TYPE STANDARD TABLE OF CNVTDMSSCR_APPLT, " | |||
| lt_it_culnk_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_CULNK, " | |||
| lt_it_culnk_del | TYPE STANDARD TABLE OF CNVTDMSSCR_CULNK, " | |||
| lt_it_doms_del | TYPE STANDARD TABLE OF CNVTDMSSCR_DOMS, " | |||
| lt_it_flds_del | TYPE STANDARD TABLE OF CNVTDMSSCR_FLDS, " | |||
| lt_it_fpars_del | TYPE STANDARD TABLE OF CNVTDMSSCR_FPARS, " | |||
| lt_it_dpars_del | TYPE STANDARD TABLE OF CNVTDMSSCR_DPARS, " | |||
| lt_it_incl_del | TYPE STANDARD TABLE OF CNVTDMSSCR_INCL, " | |||
| lt_it_grp_del | TYPE STANDARD TABLE OF CNVTDMSSCR_GRP, " | |||
| lt_it_grphi_del | TYPE STANDARD TABLE OF CNVTDMSSCR_GRPHI, " | |||
| lt_it_grpt_del | TYPE STANDARD TABLE OF CNVTDMSSCR_GRPT, " | |||
| lt_it_rule_del | TYPE STANDARD TABLE OF CNVTDMSSCR_RULE, " | |||
| lt_it_doms_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_DOMS, " | |||
| lt_it_rulet_del | TYPE STANDARD TABLE OF CNVTDMSSCR_RULET, " | |||
| lt_it_grlnk_del | TYPE STANDARD TABLE OF CNVTDMSSCR_GRLNK, " | |||
| lt_it_mtyp_del | TYPE STANDARD TABLE OF CNVTDMSSCR_MTYP, " | |||
| lt_it_mtypt_del | TYPE STANDARD TABLE OF CNVTDMSSCR_MTYPT, " | |||
| lt_it_mid_del | TYPE STANDARD TABLE OF CNVTDMSSCR_MID, " | |||
| lt_it_midt_del | TYPE STANDARD TABLE OF CNVTDMSSCR_MIDT, " | |||
| lt_it_mlnk_del | TYPE STANDARD TABLE OF CNVTDMSSCR_MLNK, " | |||
| lt_it_aplnk_del | TYPE STANDARD TABLE OF CNVTDMSSCR_APLNK, " | |||
| lt_it_proc_del | TYPE STANDARD TABLE OF CNVTDMSSCR_PROC, " | |||
| lt_it_proct_del | TYPE STANDARD TABLE OF CNVTDMSSCR_PROCT, " | |||
| lt_it_flds_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_FLDS, " | |||
| lt_it_rstat_del | TYPE STANDARD TABLE OF CNVTDMSSCR_RSTAT, " | |||
| lt_it_fmid_del | TYPE STANDARD TABLE OF CNVTDMSSCR_FMID, " | |||
| lt_it_ranid_del | TYPE STANDARD TABLE OF CNVTDMSSCR_RANID, " | |||
| lt_it_cond_del | TYPE STANDARD TABLE OF CNVTDMSSCR_COND, " | |||
| lt_it_keyst_del | TYPE STANDARD TABLE OF CNVTDMSSCR_KEYST, " | |||
| lt_it_fpars_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_FPARS, " | |||
| lt_it_dpars_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_DPARS, " | |||
| lt_it_incl_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_INCL, " | |||
| lt_it_grp_ins | TYPE STANDARD TABLE OF CNVTDMSSCR_GRP. " |
| CALL FUNCTION 'CNV_TDMS_SCR_SET_DATA' "Write Data to Database |
| EXPORTING | ||
| I_TABNAME | = lv_i_tabname | |
| TABLES | ||
| IT_APPL_INS | = lt_it_appl_ins | |
| IT_GRPHI_INS | = lt_it_grphi_ins | |
| IT_GRPT_INS | = lt_it_grpt_ins | |
| IT_RULE_INS | = lt_it_rule_ins | |
| IT_RULET_INS | = lt_it_rulet_ins | |
| IT_GRLNK_INS | = lt_it_grlnk_ins | |
| IT_MTYP_INS | = lt_it_mtyp_ins | |
| IT_MTYPT_INS | = lt_it_mtypt_ins | |
| IT_MID_INS | = lt_it_mid_ins | |
| IT_MIDT_INS | = lt_it_midt_ins | |
| IT_MLNK_INS | = lt_it_mlnk_ins | |
| IT_APPLT_INS | = lt_it_applt_ins | |
| IT_APLNK_INS | = lt_it_aplnk_ins | |
| IT_PROC_INS | = lt_it_proc_ins | |
| IT_PROCT_INS | = lt_it_proct_ins | |
| IT_RSTAT_INS | = lt_it_rstat_ins | |
| IT_FMID_INS | = lt_it_fmid_ins | |
| IT_COND_INS | = lt_it_cond_ins | |
| IT_KEYST_INS | = lt_it_keyst_ins | |
| IT_RANID_INS | = lt_it_ranid_ins | |
| IT_APPL_DEL | = lt_it_appl_del | |
| IT_APPLT_DEL | = lt_it_applt_del | |
| IT_CULNK_INS | = lt_it_culnk_ins | |
| IT_CULNK_DEL | = lt_it_culnk_del | |
| IT_DOMS_DEL | = lt_it_doms_del | |
| IT_FLDS_DEL | = lt_it_flds_del | |
| IT_FPARS_DEL | = lt_it_fpars_del | |
| IT_DPARS_DEL | = lt_it_dpars_del | |
| IT_INCL_DEL | = lt_it_incl_del | |
| IT_GRP_DEL | = lt_it_grp_del | |
| IT_GRPHI_DEL | = lt_it_grphi_del | |
| IT_GRPT_DEL | = lt_it_grpt_del | |
| IT_RULE_DEL | = lt_it_rule_del | |
| IT_DOMS_INS | = lt_it_doms_ins | |
| IT_RULET_DEL | = lt_it_rulet_del | |
| IT_GRLNK_DEL | = lt_it_grlnk_del | |
| IT_MTYP_DEL | = lt_it_mtyp_del | |
| IT_MTYPT_DEL | = lt_it_mtypt_del | |
| IT_MID_DEL | = lt_it_mid_del | |
| IT_MIDT_DEL | = lt_it_midt_del | |
| IT_MLNK_DEL | = lt_it_mlnk_del | |
| IT_APLNK_DEL | = lt_it_aplnk_del | |
| IT_PROC_DEL | = lt_it_proc_del | |
| IT_PROCT_DEL | = lt_it_proct_del | |
| IT_FLDS_INS | = lt_it_flds_ins | |
| IT_RSTAT_DEL | = lt_it_rstat_del | |
| IT_FMID_DEL | = lt_it_fmid_del | |
| IT_RANID_DEL | = lt_it_ranid_del | |
| IT_COND_DEL | = lt_it_cond_del | |
| IT_KEYST_DEL | = lt_it_keyst_del | |
| IT_FPARS_INS | = lt_it_fpars_ins | |
| IT_DPARS_INS | = lt_it_dpars_ins | |
| IT_INCL_INS | = lt_it_incl_ins | |
| IT_GRP_INS | = lt_it_grp_ins | |
| EXCEPTIONS | ||
| ERROR_IN_DELETION = 1 | ||
| ERROR_IN_INSERTION = 2 | ||
| . " CNV_TDMS_SCR_SET_DATA | ||
ABAP code using 7.40 inline data declarations to call FM CNV_TDMS_SCR_SET_DATA
The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.Search for further information about these or an SAP related objects