SAP SCPR_DB_VIEW_RECORD_GET Function Module for









SCPR_DB_VIEW_RECORD_GET is a standard scpr db view record get 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 db view record get FM, simply by entering the name SCPR_DB_VIEW_RECORD_GET into the relevant SAP transaction such as SE37 or SE38.

Function Group: SCPRVI
Program Name: SAPLSCPRVI
Main Program: SAPLSCPRVI
Appliation area: S
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function SCPR_DB_VIEW_RECORD_GET 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_DB_VIEW_RECORD_GET'"
EXPORTING
VIEWNAME = "View Name
* PRIMTABNAME = "BC Set: Table/View Name
KEY = "
KEYLNG = "
* LANGU_ADJUST = ' ' "
* LANGU_FLD_NAME = "
* PRIMTABKEY = ' ' "

IMPORTING
RECORD = "

TABLES
FIELDDESCRS = "Field Descriptions
* VALUES = "

EXCEPTIONS
NOT_FOUND = 1 NO_VIEWMAINT_TOOL = 2 WRONG_PARAMETERS = 3
.



IMPORTING Parameters details for SCPR_DB_VIEW_RECORD_GET

VIEWNAME - View Name

Data type: DD02L-TABNAME
Optional: No
Call by Reference: No ( called with pass by value option)

PRIMTABNAME - BC Set: Table/View Name

Data type: SCPR_TABL
Optional: Yes
Call by Reference: Yes

KEY -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

KEYLNG -

Data type: I
Optional: No
Call by Reference: No ( called with pass by value option)

LANGU_ADJUST -

Data type: C
Default: SPACE
Optional: Yes
Call by Reference: No ( called with pass by value option)

LANGU_FLD_NAME -

Data type: SCPR_DESCR-FIELDNAME
Optional: Yes
Call by Reference: No ( called with pass by value option)

PRIMTABKEY -

Data type: CHAR1
Default: ' '
Optional: Yes
Call by Reference: No ( called with pass by value option)

EXPORTING Parameters details for SCPR_DB_VIEW_RECORD_GET

RECORD -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

TABLES Parameters details for SCPR_DB_VIEW_RECORD_GET

FIELDDESCRS - Field Descriptions

Data type: SCPR_FLDDESCRS
Optional: No
Call by Reference: Yes

VALUES -

Data type: SCPRVALS
Optional: Yes
Call by Reference: Yes

EXCEPTIONS details

NOT_FOUND -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

NO_VIEWMAINT_TOOL -

Data type:
Optional: No
Call by Reference: No ( called with pass by value option)

WRONG_PARAMETERS -

Data type:
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for SCPR_DB_VIEW_RECORD_GET 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_record  TYPE STRING, "   
lv_viewname  TYPE DD02L-TABNAME, "   
lv_not_found  TYPE DD02L, "   
lt_fielddescrs  TYPE STANDARD TABLE OF SCPR_FLDDESCRS, "   
lt_values  TYPE STANDARD TABLE OF SCPRVALS, "   
lv_primtabname  TYPE SCPR_TABL, "   
lv_no_viewmaint_tool  TYPE SCPR_TABL, "   
lv_key  TYPE SCPR_TABL, "   
lv_wrong_parameters  TYPE SCPR_TABL, "   
lv_keylng  TYPE I, "   
lv_langu_adjust  TYPE C, "   SPACE
lv_langu_fld_name  TYPE SCPR_DESCR-FIELDNAME, "   
lv_primtabkey  TYPE CHAR1. "   ' '

  CALL FUNCTION 'SCPR_DB_VIEW_RECORD_GET'  "
    EXPORTING
         VIEWNAME = lv_viewname
         PRIMTABNAME = lv_primtabname
         KEY = lv_key
         KEYLNG = lv_keylng
         LANGU_ADJUST = lv_langu_adjust
         LANGU_FLD_NAME = lv_langu_fld_name
         PRIMTABKEY = lv_primtabkey
    IMPORTING
         RECORD = lv_record
    TABLES
         FIELDDESCRS = lt_fielddescrs
         VALUES = lt_values
    EXCEPTIONS
        NOT_FOUND = 1
        NO_VIEWMAINT_TOOL = 2
        WRONG_PARAMETERS = 3
. " SCPR_DB_VIEW_RECORD_GET




ABAP code using 7.40 inline data declarations to call FM SCPR_DB_VIEW_RECORD_GET

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 TABNAME FROM DD02L INTO @DATA(ld_viewname).
 
 
 
 
 
 
 
 
 
DATA(ld_langu_adjust) = ' '.
 
"SELECT single FIELDNAME FROM SCPR_DESCR INTO @DATA(ld_langu_fld_name).
 
DATA(ld_primtabkey) = ' '.
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!