SAP Function Modules

comments icon Comments

SCPR_DB_ATTR_GET_DETAIL SAP Function module







SCPR_DB_ATTR_GET_DETAIL 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 SCPR_DB_ATTR_GET_DETAIL into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: SCPRPR
Released Date: Not Released
Processing type: Normal fucntion module
Normal function module settings


Pattern for FM SCPR_DB_ATTR_GET_DETAIL - SCPR DB ATTR GET DETAIL 





CALL FUNCTION 'SCPR_DB_ATTR_GET_DETAIL' "
  EXPORTING
    profid =                    " scprattr-id
*   version = 'N'               " scprattr-version
*   category = SPACE            " scprattr-category
  IMPORTING
    proftype =                  " scprattr-type
    cli_dep =                   " scprattr-cli_dep
    cli_cas =                   " scprattr-cli_cas
    reftype =                   " scprattr-reftype
    refname =                   " scprattr-refname
    component =                 " scprattr-component  SW Component
    minrelease =                " scprattr-minrelease
    maxrelease =                " scprattr-maxrelease
    moddate =                   " scprattr-moddate  Date of Last Change
    modtime =                   " scprattr-modtime  Last changed at
    modifier =                  " scprattr-modifier  Last Changed by
    orgid =                     " scprattr-orgid
    profstate =                 " scprattr-state
    act_info =                  " scprattr-act_info
  EXCEPTIONS
    PROFILE_DONT_EXIST = 1      "
    .  "  SCPR_DB_ATTR_GET_DETAIL

ABAP code example for Function Module SCPR_DB_ATTR_GET_DETAIL





The ABAP code below is a full code listing to execute function module SCPR_DB_ATTR_GET_DETAIL 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_proftype    TYPE SCPRATTR-TYPE
,
ld_cli_dep    TYPE SCPRATTR-CLI_DEP
,
ld_cli_cas    TYPE SCPRATTR-CLI_CAS
,
ld_reftype    TYPE SCPRATTR-REFTYPE
,
ld_refname    TYPE SCPRATTR-REFNAME
,
ld_component    TYPE SCPRATTR-COMPONENT
,
ld_minrelease    TYPE SCPRATTR-MINRELEASE
,
ld_maxrelease    TYPE SCPRATTR-MAXRELEASE
,
ld_moddate    TYPE SCPRATTR-MODDATE
,
ld_modtime    TYPE SCPRATTR-MODTIME
,
ld_modifier    TYPE SCPRATTR-MODIFIER
,
ld_orgid    TYPE SCPRATTR-ORGID
,
ld_profstate    TYPE SCPRATTR-STATE
,
ld_act_info    TYPE SCPRATTR-ACT_INFO
.



 

SELECT single ID 
  FROM SCPRATTR 
  INTO @DATA(ld_profid).

 

SELECT single VERSION 
  FROM SCPRATTR 
  INTO @DATA(ld_version).

 

SELECT single CATEGORY 
  FROM SCPRATTR 
  INTO @DATA(ld_category).

.

CALL FUNCTION 'SCPR_DB_ATTR_GET_DETAIL'
  EXPORTING
    profid =                     ld_profid
*   version =                    ld_version
*   category =                   ld_category
  IMPORTING
    proftype =                   ld_proftype
    cli_dep =                    ld_cli_dep
    cli_cas =                    ld_cli_cas
    reftype =                    ld_reftype
    refname =                    ld_refname
    component =                  ld_component
    minrelease =                 ld_minrelease
    maxrelease =                 ld_maxrelease
    moddate =                    ld_moddate
    modtime =                    ld_modtime
    modifier =                   ld_modifier
    orgid =                      ld_orgid
    profstate =                  ld_profstate
    act_info =                   ld_act_info
  EXCEPTIONS
    PROFILE_DONT_EXIST =         1
    .  "  SCPR_DB_ATTR_GET_DETAIL

IF SY-SUBRC EQ 0.
  "All OK
ELSEIF SY-SUBRC EQ 1. "Exception
  "Add code for exception here
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_proftype  TYPE SCPRATTR-TYPE ,
ld_profid  TYPE SCPRATTR-ID ,
ld_cli_dep  TYPE SCPRATTR-CLI_DEP ,
ld_version  TYPE SCPRATTR-VERSION ,
ld_cli_cas  TYPE SCPRATTR-CLI_CAS ,
ld_category  TYPE SCPRATTR-CATEGORY ,
ld_reftype  TYPE SCPRATTR-REFTYPE ,
ld_refname  TYPE SCPRATTR-REFNAME ,
ld_component  TYPE SCPRATTR-COMPONENT ,
ld_minrelease  TYPE SCPRATTR-MINRELEASE ,
ld_maxrelease  TYPE SCPRATTR-MAXRELEASE ,
ld_moddate  TYPE SCPRATTR-MODDATE ,
ld_modtime  TYPE SCPRATTR-MODTIME ,
ld_modifier  TYPE SCPRATTR-MODIFIER ,
ld_orgid  TYPE SCPRATTR-ORGID ,
ld_profstate  TYPE SCPRATTR-STATE ,
ld_act_info  TYPE SCPRATTR-ACT_INFO .





SELECT single ID 
  FROM SCPRATTR 
  INTO ld_profid.


SELECT single VERSION 
  FROM SCPRATTR 
  INTO ld_version.


SELECT single CATEGORY 
  FROM SCPRATTR 
  INTO ld_category.

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 SCPR_DB_ATTR_GET_DETAIL or its description.


   
 

SCPR_DB_ATTR_GET_DETAIL - 
SCPR_DB_ATTR_GET_ADDITIONAL - 
SCPR_DB_ATTR_DELETE - 
SCPR_DB_ACTSTATUS_READ - 
SCPR_CT_VALUE_CONV_EXT_INT_STR - 
SCPR_CT_VALUE_CONVEXIT_INT_EXT -