SAP Function Modules

RPM_MIGRATION_RETRIEVE_DATA SAP Function module - Retrieve data from various tables







RPM_MIGRATION_RETRIEVE_DATA is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.

See here to view full function module documentation and code listing, simply by entering the name RPM_MIGRATION_RETRIEVE_DATA into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: RPM_MIGRATION
Released Date: Not Released
Processing type: Remote-Enabled
remote enabled module settings


Pattern for FM RPM_MIGRATION_RETRIEVE_DATA - RPM MIGRATION RETRIEVE DATA





CALL FUNCTION 'RPM_MIGRATION_RETRIEVE_DATA' "Retrieve data from various tables
* EXPORTING
*   it_external_id =            " rpm_tt_fi_range_projid  Table for having multiple project ids
  IMPORTING
    et_rpm_obj_links =          " rpm_tt_obj_link_db  Object Link Table Type
* TABLES
*   et_rpm_project =            " rpm_project   Project data
*   et_cgpl_project =           " cgpl_project  Project Planning: Project Headers Attribute Table
*   et_rpm_project_cust =       " rpm_project_cust  RPM Project: Customer data
*   et_cgpl_task =              " cgpl_task     Project Planning: Activities Attribute Table
*   et_cgpl_text =              " cgpl_text     Proj. Planning of Lang. Depend. Short Text for Proj./Tasks
*   et_rpm_project_der =        " rpm_project_der  Project data
*   et_cgpl_hierarchy =         " cgpl_hierarchy  Project Planning: Activities and Projects Hierarchy Table
*   et_rpm_proj_stkhld =        " rpm_proj_stkhld  Project Stakeholders
*   et_rpm_roles =              " rpm_role      RPM: Role attributes
*   et_rpm_roles_cust =         " rpm_role_cust  Customer Fields for Role
*   et_rpm_role_demands =       " rpm_role_avl  Project Role Demand
*   et_rpm_tasks =              " rpm_task      Project Task Data
*   et_rpm_tasks_cust =         " rpm_task_cust  Customer Fields at Task Level
*   et_rpm_resources =          " rpm_resource  Project Resource
*   et_rpm_relates =            " rpm_relate    RPM: Relationship table
*   et_rpm_relates_cust =       " rpm_relate_cust  Customer Fields for Relatinship
*   et_rpm_resource_allocs =    " rpm_relate_alloc  RPM: Relationship table
*   et_rpm_role_skill =         " rpm_role_skill  Skill sets for roles
    .  "  RPM_MIGRATION_RETRIEVE_DATA

ABAP code example for Function Module RPM_MIGRATION_RETRIEVE_DATA





The ABAP code below is a full code listing to execute function module RPM_MIGRATION_RETRIEVE_DATA including all data declarations. The code uses 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 original method of declaring data variables up front. 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).

DATA:
ld_et_rpm_obj_links  TYPE RPM_TT_OBJ_LINK_DB ,
it_et_rpm_project  TYPE STANDARD TABLE OF RPM_PROJECT,"TABLES PARAM
wa_et_rpm_project  LIKE LINE OF it_et_rpm_project ,
it_et_cgpl_project  TYPE STANDARD TABLE OF CGPL_PROJECT,"TABLES PARAM
wa_et_cgpl_project  LIKE LINE OF it_et_cgpl_project ,
it_et_rpm_project_cust  TYPE STANDARD TABLE OF RPM_PROJECT_CUST,"TABLES PARAM
wa_et_rpm_project_cust  LIKE LINE OF it_et_rpm_project_cust ,
it_et_cgpl_task  TYPE STANDARD TABLE OF CGPL_TASK,"TABLES PARAM
wa_et_cgpl_task  LIKE LINE OF it_et_cgpl_task ,
it_et_cgpl_text  TYPE STANDARD TABLE OF CGPL_TEXT,"TABLES PARAM
wa_et_cgpl_text  LIKE LINE OF it_et_cgpl_text ,
it_et_rpm_project_der  TYPE STANDARD TABLE OF RPM_PROJECT_DER,"TABLES PARAM
wa_et_rpm_project_der  LIKE LINE OF it_et_rpm_project_der ,
it_et_cgpl_hierarchy  TYPE STANDARD TABLE OF CGPL_HIERARCHY,"TABLES PARAM
wa_et_cgpl_hierarchy  LIKE LINE OF it_et_cgpl_hierarchy ,
it_et_rpm_proj_stkhld  TYPE STANDARD TABLE OF RPM_PROJ_STKHLD,"TABLES PARAM
wa_et_rpm_proj_stkhld  LIKE LINE OF it_et_rpm_proj_stkhld ,
it_et_rpm_roles  TYPE STANDARD TABLE OF RPM_ROLE,"TABLES PARAM
wa_et_rpm_roles  LIKE LINE OF it_et_rpm_roles ,
it_et_rpm_roles_cust  TYPE STANDARD TABLE OF RPM_ROLE_CUST,"TABLES PARAM
wa_et_rpm_roles_cust  LIKE LINE OF it_et_rpm_roles_cust ,
it_et_rpm_role_demands  TYPE STANDARD TABLE OF RPM_ROLE_AVL,"TABLES PARAM
wa_et_rpm_role_demands  LIKE LINE OF it_et_rpm_role_demands ,
it_et_rpm_tasks  TYPE STANDARD TABLE OF RPM_TASK,"TABLES PARAM
wa_et_rpm_tasks  LIKE LINE OF it_et_rpm_tasks ,
it_et_rpm_tasks_cust  TYPE STANDARD TABLE OF RPM_TASK_CUST,"TABLES PARAM
wa_et_rpm_tasks_cust  LIKE LINE OF it_et_rpm_tasks_cust ,
it_et_rpm_resources  TYPE STANDARD TABLE OF RPM_RESOURCE,"TABLES PARAM
wa_et_rpm_resources  LIKE LINE OF it_et_rpm_resources ,
it_et_rpm_relates  TYPE STANDARD TABLE OF RPM_RELATE,"TABLES PARAM
wa_et_rpm_relates  LIKE LINE OF it_et_rpm_relates ,
it_et_rpm_relates_cust  TYPE STANDARD TABLE OF RPM_RELATE_CUST,"TABLES PARAM
wa_et_rpm_relates_cust  LIKE LINE OF it_et_rpm_relates_cust ,
it_et_rpm_resource_allocs  TYPE STANDARD TABLE OF RPM_RELATE_ALLOC,"TABLES PARAM
wa_et_rpm_resource_allocs  LIKE LINE OF it_et_rpm_resource_allocs ,
it_et_rpm_role_skill  TYPE STANDARD TABLE OF RPM_ROLE_SKILL,"TABLES PARAM
wa_et_rpm_role_skill  LIKE LINE OF it_et_rpm_role_skill .

DATA(ld_it_external_id) = 'Check type of data required'.

"populate fields of struture and append to itab
append wa_et_rpm_project to it_et_rpm_project.

"populate fields of struture and append to itab
append wa_et_cgpl_project to it_et_cgpl_project.

"populate fields of struture and append to itab
append wa_et_rpm_project_cust to it_et_rpm_project_cust.

"populate fields of struture and append to itab
append wa_et_cgpl_task to it_et_cgpl_task.

"populate fields of struture and append to itab
append wa_et_cgpl_text to it_et_cgpl_text.

"populate fields of struture and append to itab
append wa_et_rpm_project_der to it_et_rpm_project_der.

"populate fields of struture and append to itab
append wa_et_cgpl_hierarchy to it_et_cgpl_hierarchy.

"populate fields of struture and append to itab
append wa_et_rpm_proj_stkhld to it_et_rpm_proj_stkhld.

"populate fields of struture and append to itab
append wa_et_rpm_roles to it_et_rpm_roles.

"populate fields of struture and append to itab
append wa_et_rpm_roles_cust to it_et_rpm_roles_cust.

"populate fields of struture and append to itab
append wa_et_rpm_role_demands to it_et_rpm_role_demands.

"populate fields of struture and append to itab
append wa_et_rpm_tasks to it_et_rpm_tasks.

"populate fields of struture and append to itab
append wa_et_rpm_tasks_cust to it_et_rpm_tasks_cust.

"populate fields of struture and append to itab
append wa_et_rpm_resources to it_et_rpm_resources.

"populate fields of struture and append to itab
append wa_et_rpm_relates to it_et_rpm_relates.

"populate fields of struture and append to itab
append wa_et_rpm_relates_cust to it_et_rpm_relates_cust.

"populate fields of struture and append to itab
append wa_et_rpm_resource_allocs to it_et_rpm_resource_allocs.

"populate fields of struture and append to itab
append wa_et_rpm_role_skill to it_et_rpm_role_skill. . CALL FUNCTION 'RPM_MIGRATION_RETRIEVE_DATA' * EXPORTING * it_external_id = ld_it_external_id IMPORTING et_rpm_obj_links = ld_et_rpm_obj_links * TABLES * et_rpm_project = it_et_rpm_project * et_cgpl_project = it_et_cgpl_project * et_rpm_project_cust = it_et_rpm_project_cust * et_cgpl_task = it_et_cgpl_task * et_cgpl_text = it_et_cgpl_text * et_rpm_project_der = it_et_rpm_project_der * et_cgpl_hierarchy = it_et_cgpl_hierarchy * et_rpm_proj_stkhld = it_et_rpm_proj_stkhld * et_rpm_roles = it_et_rpm_roles * et_rpm_roles_cust = it_et_rpm_roles_cust * et_rpm_role_demands = it_et_rpm_role_demands * et_rpm_tasks = it_et_rpm_tasks * et_rpm_tasks_cust = it_et_rpm_tasks_cust * et_rpm_resources = it_et_rpm_resources * et_rpm_relates = it_et_rpm_relates * et_rpm_relates_cust = it_et_rpm_relates_cust * et_rpm_resource_allocs = it_et_rpm_resource_allocs * et_rpm_role_skill = it_et_rpm_role_skill . " RPM_MIGRATION_RETRIEVE_DATA
IF SY-SUBRC EQ 0. "All OK ENDIF.







ABAP code to compare 7.40 inline data declaration with original syntax

The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.

DATA:
ld_et_rpm_obj_links  TYPE RPM_TT_OBJ_LINK_DB ,
ld_it_external_id  TYPE RPM_TT_FI_RANGE_PROJID ,
it_et_rpm_project  TYPE STANDARD TABLE OF RPM_PROJECT ,
wa_et_rpm_project  LIKE LINE OF it_et_rpm_project,
it_et_cgpl_project  TYPE STANDARD TABLE OF CGPL_PROJECT ,
wa_et_cgpl_project  LIKE LINE OF it_et_cgpl_project,
it_et_rpm_project_cust  TYPE STANDARD TABLE OF RPM_PROJECT_CUST ,
wa_et_rpm_project_cust  LIKE LINE OF it_et_rpm_project_cust,
it_et_cgpl_task  TYPE STANDARD TABLE OF CGPL_TASK ,
wa_et_cgpl_task  LIKE LINE OF it_et_cgpl_task,
it_et_cgpl_text  TYPE STANDARD TABLE OF CGPL_TEXT ,
wa_et_cgpl_text  LIKE LINE OF it_et_cgpl_text,
it_et_rpm_project_der  TYPE STANDARD TABLE OF RPM_PROJECT_DER ,
wa_et_rpm_project_der  LIKE LINE OF it_et_rpm_project_der,
it_et_cgpl_hierarchy  TYPE STANDARD TABLE OF CGPL_HIERARCHY ,
wa_et_cgpl_hierarchy  LIKE LINE OF it_et_cgpl_hierarchy,
it_et_rpm_proj_stkhld  TYPE STANDARD TABLE OF RPM_PROJ_STKHLD ,
wa_et_rpm_proj_stkhld  LIKE LINE OF it_et_rpm_proj_stkhld,
it_et_rpm_roles  TYPE STANDARD TABLE OF RPM_ROLE ,
wa_et_rpm_roles  LIKE LINE OF it_et_rpm_roles,
it_et_rpm_roles_cust  TYPE STANDARD TABLE OF RPM_ROLE_CUST ,
wa_et_rpm_roles_cust  LIKE LINE OF it_et_rpm_roles_cust,
it_et_rpm_role_demands  TYPE STANDARD TABLE OF RPM_ROLE_AVL ,
wa_et_rpm_role_demands  LIKE LINE OF it_et_rpm_role_demands,
it_et_rpm_tasks  TYPE STANDARD TABLE OF RPM_TASK ,
wa_et_rpm_tasks  LIKE LINE OF it_et_rpm_tasks,
it_et_rpm_tasks_cust  TYPE STANDARD TABLE OF RPM_TASK_CUST ,
wa_et_rpm_tasks_cust  LIKE LINE OF it_et_rpm_tasks_cust,
it_et_rpm_resources  TYPE STANDARD TABLE OF RPM_RESOURCE ,
wa_et_rpm_resources  LIKE LINE OF it_et_rpm_resources,
it_et_rpm_relates  TYPE STANDARD TABLE OF RPM_RELATE ,
wa_et_rpm_relates  LIKE LINE OF it_et_rpm_relates,
it_et_rpm_relates_cust  TYPE STANDARD TABLE OF RPM_RELATE_CUST ,
wa_et_rpm_relates_cust  LIKE LINE OF it_et_rpm_relates_cust,
it_et_rpm_resource_allocs  TYPE STANDARD TABLE OF RPM_RELATE_ALLOC ,
wa_et_rpm_resource_allocs  LIKE LINE OF it_et_rpm_resource_allocs,
it_et_rpm_role_skill  TYPE STANDARD TABLE OF RPM_ROLE_SKILL ,
wa_et_rpm_role_skill  LIKE LINE OF it_et_rpm_role_skill.

ld_it_external_id = 'Check type of data required'.

"populate fields of struture and append to itab
append wa_et_rpm_project to it_et_rpm_project.

"populate fields of struture and append to itab
append wa_et_cgpl_project to it_et_cgpl_project.

"populate fields of struture and append to itab
append wa_et_rpm_project_cust to it_et_rpm_project_cust.

"populate fields of struture and append to itab
append wa_et_cgpl_task to it_et_cgpl_task.

"populate fields of struture and append to itab
append wa_et_cgpl_text to it_et_cgpl_text.

"populate fields of struture and append to itab
append wa_et_rpm_project_der to it_et_rpm_project_der.

"populate fields of struture and append to itab
append wa_et_cgpl_hierarchy to it_et_cgpl_hierarchy.

"populate fields of struture and append to itab
append wa_et_rpm_proj_stkhld to it_et_rpm_proj_stkhld.

"populate fields of struture and append to itab
append wa_et_rpm_roles to it_et_rpm_roles.

"populate fields of struture and append to itab
append wa_et_rpm_roles_cust to it_et_rpm_roles_cust.

"populate fields of struture and append to itab
append wa_et_rpm_role_demands to it_et_rpm_role_demands.

"populate fields of struture and append to itab
append wa_et_rpm_tasks to it_et_rpm_tasks.

"populate fields of struture and append to itab
append wa_et_rpm_tasks_cust to it_et_rpm_tasks_cust.

"populate fields of struture and append to itab
append wa_et_rpm_resources to it_et_rpm_resources.

"populate fields of struture and append to itab
append wa_et_rpm_relates to it_et_rpm_relates.

"populate fields of struture and append to itab
append wa_et_rpm_relates_cust to it_et_rpm_relates_cust.

"populate fields of struture and append to itab
append wa_et_rpm_resource_allocs to it_et_rpm_resource_allocs.

"populate fields of struture and append to itab
append wa_et_rpm_role_skill to it_et_rpm_role_skill.

Contribute (Add Comments)

Please help keep this info upto date and use the comments section below to add useful hints, tips and information specific to this SAP function. This will then be available for you and other users to easily find by simply searching on the object name RPM_MIGRATION_RETRIEVE_DATA or its description.