ISSC_DB_SCHED_POS_SELECT SAP Function module - Selection of Scheduling Data on the Database

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

Associated Function Group: VVSC_DB
Released Date: Not Released
Processing type: Normal fucntion module

Pattern for FM ISSC_DB_SCHED_POS_SELECT - ISSC DB SCHED POS SELECT

CALL FUNCTION 'ISSC_DB_SCHED_POS_SELECT' "Selection of Scheduling Data on the Database
  EXPORTING
    i_vtref =                   " vvscpos-vtref
    i_gpart =                   " vvscpos-gpart
  TABLES
    et_vvscpos =                " vvscpos
*   selected_t_vvscpos =        " vvscpos       Bill Scheduling: Scheduling Item
  EXCEPTIONS
    NOT_FOUND = 1               "
    .  "  ISSC_DB_SCHED_POS_SELECT

ABAP code example for Function Module ISSC_DB_SCHED_POS_SELECT

The ABAP code below is a full code listing to execute function module ISSC_DB_SCHED_POS_SELECT 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:
it_et_vvscpos  
 
 TYPE STANDARD TABLE OF VVSCPOS,"TABLES PARAM
wa_et_vvscpos
 
 LIKE LINE OF it_et_vvscpos
,
it_selected_t_vvscpos  
 
 TYPE STANDARD TABLE OF VVSCPOS,"TABLES PARAM
wa_selected_t_vvscpos
 
 LIKE LINE OF it_selected_t_vvscpos
.

 

SELECT single VTREF 
  FROM VVSCPOS 
  INTO @DATA(ld_i_vtref).

 

SELECT single GPART 
  FROM VVSCPOS 
  INTO @DATA(ld_i_gpart).

 

"populate fields of struture and append to itab
append wa_et_vvscpos to it_et_vvscpos.
 

"populate fields of struture and append to itab
append wa_selected_t_vvscpos to it_selected_t_vvscpos.
.

CALL FUNCTION 'ISSC_DB_SCHED_POS_SELECT'
  EXPORTING
    i_vtref =                    ld_i_vtref
    i_gpart =                    ld_i_gpart
  TABLES
    et_vvscpos =                 it_et_vvscpos
*   selected_t_vvscpos =         it_selected_t_vvscpos
  EXCEPTIONS
    NOT_FOUND =                  1
    .  "  ISSC_DB_SCHED_POS_SELECT

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_i_vtref
 
 TYPE VVSCPOS-VTREF ,
it_et_vvscpos
 
 TYPE STANDARD TABLE OF VVSCPOS ,
wa_et_vvscpos
 
 LIKE LINE OF it_et_vvscpos,
ld_i_gpart
 
 TYPE VVSCPOS-GPART ,
it_selected_t_vvscpos
 
 TYPE STANDARD TABLE OF VVSCPOS ,
wa_selected_t_vvscpos
 
 LIKE LINE OF it_selected_t_vvscpos.



SELECT single VTREF 
  FROM VVSCPOS 
  INTO ld_i_vtref.
 

"populate fields of struture and append to itab
append wa_et_vvscpos to it_et_vvscpos.

SELECT single GPART 
  FROM VVSCPOS 
  INTO ld_i_gpart.
 

"populate fields of struture and append to itab
append wa_selected_t_vvscpos to it_selected_t_vvscpos.