SAP SCPR_PRSET_DB_GET_DETAIL Function Module for
SCPR_PRSET_DB_GET_DETAIL is a standard scpr prset db get detail SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used to perform a specific ABAP function and below is the pattern details, 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 scpr prset db get detail FM, simply by entering the name SCPR_PRSET_DB_GET_DETAIL into the relevant SAP transaction such as SE37 or SE38.
Function Group: SCPRPS
Program Name: SAPLSCPRPS
Main Program: SAPLSCPRPS
Appliation area: S
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:

Function SCPR_PRSET_DB_GET_DETAIL 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 'SCPR_PRSET_DB_GET_DETAIL'".
EXPORTING
PROFID = "
* VERSION = 'N' "
* CATEGORY = ' ' "
* LANGU = SY-LANGU "
* FLDDESCR_REDUC = 'X' "
* GEN_BCSETS_ALLOWED = ' ' "
IMPORTING
PROFTYPE = "
MODTIME = "Last changed at
MODIFIER = "Last Changed by
ORGID = "
PROFSTATE = "
ACT_INFO = "(obsolete)
PROFTEXT = "
CLI_DEP = "
CLI_CAS = "
REFTYPE = "
REFNAME = "
COMPONENT = "SW Component
MINRELEASE = "
MAXRELEASE = "
MODDATE = "Date of Last Change
TABLES
* SUBPROFS = "
* VALUES = "
* RECATTR = "
* IT_FIELDDESCRS = "Field Descriptions
* TEXTS = "
* IT_FLDV = "BC Set: Replace Field Text in Variable Fields
* RECATTRT = "
* ORIG_RECNUM_ASSIGNS = "
EXCEPTIONS
NO_PROFILE_ID = 1 WRONG_VERSION = 2 WRONG_CATEGORY = 3 PROFILE_DONT_EXIST = 4
IMPORTING Parameters details for SCPR_PRSET_DB_GET_DETAIL
PROFID -
Data type: SCPRATTR-IDOptional: No
Call by Reference: No ( called with pass by value option)
VERSION -
Data type: SCPRATTR-VERSIONDefault: 'N'
Optional: Yes
Call by Reference: No ( called with pass by value option)
CATEGORY -
Data type: SCPRATTR-CATEGORYDefault: SPACE
Optional: Yes
Call by Reference: No ( called with pass by value option)
LANGU -
Data type: SCPRTEXT-LANGUDefault: SY-LANGU
Optional: Yes
Call by Reference: No ( called with pass by value option)
FLDDESCR_REDUC -
Data type: CDefault: 'X'
Optional: Yes
Call by Reference: No ( called with pass by value option)
GEN_BCSETS_ALLOWED -
Data type: CDefault: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)
EXPORTING Parameters details for SCPR_PRSET_DB_GET_DETAIL
PROFTYPE -
Data type: SCPRATTR-TYPEOptional: No
Call by Reference: No ( called with pass by value option)
MODTIME - Last changed at
Data type: SCPRATTR-MODTIMEOptional: No
Call by Reference: No ( called with pass by value option)
MODIFIER - Last Changed by
Data type: SCPRATTR-MODIFIEROptional: No
Call by Reference: No ( called with pass by value option)
ORGID -
Data type: SCPRATTR-ORGIDOptional: No
Call by Reference: No ( called with pass by value option)
PROFSTATE -
Data type: SCPRATTR-STATEOptional: No
Call by Reference: No ( called with pass by value option)
ACT_INFO - (obsolete)
Data type: SCPRATTR-ACT_INFOOptional: No
Call by Reference: No ( called with pass by value option)
PROFTEXT -
Data type: SCPRTEXT-TEXTOptional: No
Call by Reference: No ( called with pass by value option)
CLI_DEP -
Data type: SCPRATTR-CLI_DEPOptional: No
Call by Reference: No ( called with pass by value option)
CLI_CAS -
Data type: SCPRATTR-CLI_CASOptional: No
Call by Reference: No ( called with pass by value option)
REFTYPE -
Data type: SCPRATTR-REFTYPEOptional: No
Call by Reference: No ( called with pass by value option)
REFNAME -
Data type: SCPRATTR-REFNAMEOptional: No
Call by Reference: No ( called with pass by value option)
COMPONENT - SW Component
Data type: SCPRATTR-COMPONENTOptional: No
Call by Reference: No ( called with pass by value option)
MINRELEASE -
Data type: SCPRATTR-MINRELEASEOptional: No
Call by Reference: No ( called with pass by value option)
MAXRELEASE -
Data type: SCPRATTR-MAXRELEASEOptional: No
Call by Reference: No ( called with pass by value option)
MODDATE - Date of Last Change
Data type: SCPRATTR-MODDATEOptional: No
Call by Reference: No ( called with pass by value option)
TABLES Parameters details for SCPR_PRSET_DB_GET_DETAIL
SUBPROFS -
Data type: SCPROPROFOptional: Yes
Call by Reference: No ( called with pass by value option)
VALUES -
Data type: SCPRVALSOptional: Yes
Call by Reference: No ( called with pass by value option)
RECATTR -
Data type: SCPRRECAOptional: Yes
Call by Reference: No ( called with pass by value option)
IT_FIELDDESCRS - Field Descriptions
Data type: SCPR_RECORDSOptional: Yes
Call by Reference: Yes
TEXTS -
Data type: SCPRTEXTOptional: Yes
Call by Reference: No ( called with pass by value option)
IT_FLDV - BC Set: Replace Field Text in Variable Fields
Data type: SCPRFLDVOptional: Yes
Call by Reference: Yes
RECATTRT -
Data type: SCPR_RECATTRSOptional: Yes
Call by Reference: Yes
ORIG_RECNUM_ASSIGNS -
Data type: SCPR_ORIG_RECNUM_ASSIGNSOptional: Yes
Call by Reference: Yes
EXCEPTIONS details
NO_PROFILE_ID -
Data type:Optional: No
Call by Reference: No ( called with pass by value option)
WRONG_VERSION -
Data type:Optional: No
Call by Reference: No ( called with pass by value option)
WRONG_CATEGORY -
Data type:Optional: No
Call by Reference: Yes
PROFILE_DONT_EXIST -
Data type:Optional: No
Call by Reference: No ( called with pass by value option)
Copy and paste ABAP code example for SCPR_PRSET_DB_GET_DETAIL 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_profid | TYPE SCPRATTR-ID, " | |||
| lv_proftype | TYPE SCPRATTR-TYPE, " | |||
| lt_subprofs | TYPE STANDARD TABLE OF SCPROPROF, " | |||
| lv_no_profile_id | TYPE SCPROPROF, " | |||
| lv_modtime | TYPE SCPRATTR-MODTIME, " | |||
| lv_modifier | TYPE SCPRATTR-MODIFIER, " | |||
| lv_orgid | TYPE SCPRATTR-ORGID, " | |||
| lv_profstate | TYPE SCPRATTR-STATE, " | |||
| lv_act_info | TYPE SCPRATTR-ACT_INFO, " | |||
| lv_proftext | TYPE SCPRTEXT-TEXT, " | |||
| lt_values | TYPE STANDARD TABLE OF SCPRVALS, " | |||
| lv_cli_dep | TYPE SCPRATTR-CLI_DEP, " | |||
| lv_version | TYPE SCPRATTR-VERSION, " 'N' | |||
| lv_wrong_version | TYPE SCPRATTR, " | |||
| lv_cli_cas | TYPE SCPRATTR-CLI_CAS, " | |||
| lt_recattr | TYPE STANDARD TABLE OF SCPRRECA, " | |||
| lv_category | TYPE SCPRATTR-CATEGORY, " SPACE | |||
| lv_wrong_category | TYPE SCPRATTR, " | |||
| lv_langu | TYPE SCPRTEXT-LANGU, " SY-LANGU | |||
| lv_reftype | TYPE SCPRATTR-REFTYPE, " | |||
| lt_it_fielddescrs | TYPE STANDARD TABLE OF SCPR_RECORDS, " | |||
| lv_profile_dont_exist | TYPE SCPR_RECORDS, " | |||
| lt_texts | TYPE STANDARD TABLE OF SCPRTEXT, " | |||
| lv_refname | TYPE SCPRATTR-REFNAME, " | |||
| lv_flddescr_reduc | TYPE C, " 'X' | |||
| lt_it_fldv | TYPE STANDARD TABLE OF SCPRFLDV, " | |||
| lv_component | TYPE SCPRATTR-COMPONENT, " | |||
| lv_gen_bcsets_allowed | TYPE C, " ' ' | |||
| lt_recattrt | TYPE STANDARD TABLE OF SCPR_RECATTRS, " | |||
| lv_minrelease | TYPE SCPRATTR-MINRELEASE, " | |||
| lv_maxrelease | TYPE SCPRATTR-MAXRELEASE, " | |||
| lt_orig_recnum_assigns | TYPE STANDARD TABLE OF SCPR_ORIG_RECNUM_ASSIGNS, " | |||
| lv_moddate | TYPE SCPRATTR-MODDATE. " |
|   CALL FUNCTION 'SCPR_PRSET_DB_GET_DETAIL' " |
| EXPORTING | ||
| PROFID | = lv_profid | |
| VERSION | = lv_version | |
| CATEGORY | = lv_category | |
| LANGU | = lv_langu | |
| FLDDESCR_REDUC | = lv_flddescr_reduc | |
| GEN_BCSETS_ALLOWED | = lv_gen_bcsets_allowed | |
| IMPORTING | ||
| PROFTYPE | = lv_proftype | |
| MODTIME | = lv_modtime | |
| MODIFIER | = lv_modifier | |
| ORGID | = lv_orgid | |
| PROFSTATE | = lv_profstate | |
| ACT_INFO | = lv_act_info | |
| PROFTEXT | = lv_proftext | |
| CLI_DEP | = lv_cli_dep | |
| CLI_CAS | = lv_cli_cas | |
| REFTYPE | = lv_reftype | |
| REFNAME | = lv_refname | |
| COMPONENT | = lv_component | |
| MINRELEASE | = lv_minrelease | |
| MAXRELEASE | = lv_maxrelease | |
| MODDATE | = lv_moddate | |
| TABLES | ||
| SUBPROFS | = lt_subprofs | |
| VALUES | = lt_values | |
| RECATTR | = lt_recattr | |
| IT_FIELDDESCRS | = lt_it_fielddescrs | |
| TEXTS | = lt_texts | |
| IT_FLDV | = lt_it_fldv | |
| RECATTRT | = lt_recattrt | |
| ORIG_RECNUM_ASSIGNS | = lt_orig_recnum_assigns | |
| EXCEPTIONS | ||
| NO_PROFILE_ID = 1 | ||
| WRONG_VERSION = 2 | ||
| WRONG_CATEGORY = 3 | ||
| PROFILE_DONT_EXIST = 4 | ||
| . " SCPR_PRSET_DB_GET_DETAIL | ||
ABAP code using 7.40 inline data declarations to call FM SCPR_PRSET_DB_GET_DETAIL
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.| "SELECT single ID FROM SCPRATTR INTO @DATA(ld_profid). | ||||
| "SELECT single TYPE FROM SCPRATTR INTO @DATA(ld_proftype). | ||||
| "SELECT single MODTIME FROM SCPRATTR INTO @DATA(ld_modtime). | ||||
| "SELECT single MODIFIER FROM SCPRATTR INTO @DATA(ld_modifier). | ||||
| "SELECT single ORGID FROM SCPRATTR INTO @DATA(ld_orgid). | ||||
| "SELECT single STATE FROM SCPRATTR INTO @DATA(ld_profstate). | ||||
| "SELECT single ACT_INFO FROM SCPRATTR INTO @DATA(ld_act_info). | ||||
| "SELECT single TEXT FROM SCPRTEXT INTO @DATA(ld_proftext). | ||||
| "SELECT single CLI_DEP FROM SCPRATTR INTO @DATA(ld_cli_dep). | ||||
| "SELECT single VERSION FROM SCPRATTR INTO @DATA(ld_version). | ||||
| DATA(ld_version) | = 'N'. | |||
| "SELECT single CLI_CAS FROM SCPRATTR INTO @DATA(ld_cli_cas). | ||||
| "SELECT single CATEGORY FROM SCPRATTR INTO @DATA(ld_category). | ||||
| DATA(ld_category) | = ' '. | |||
| "SELECT single LANGU FROM SCPRTEXT INTO @DATA(ld_langu). | ||||
| DATA(ld_langu) | = SY-LANGU. | |||
| "SELECT single REFTYPE FROM SCPRATTR INTO @DATA(ld_reftype). | ||||
| "SELECT single REFNAME FROM SCPRATTR INTO @DATA(ld_refname). | ||||
| DATA(ld_flddescr_reduc) | = 'X'. | |||
| "SELECT single COMPONENT FROM SCPRATTR INTO @DATA(ld_component). | ||||
| DATA(ld_gen_bcsets_allowed) | = ' '. | |||
| "SELECT single MINRELEASE FROM SCPRATTR INTO @DATA(ld_minrelease). | ||||
| "SELECT single MAXRELEASE FROM SCPRATTR INTO @DATA(ld_maxrelease). | ||||
| "SELECT single MODDATE FROM SCPRATTR INTO @DATA(ld_moddate). | ||||
Search for further information about these or an SAP related objects