C2_DB_PLPH_READ SAP Function module - Read PLPH from database

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

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

Pattern for FM C2_DB_PLPH_READ - C2 DB PLPH READ

CALL FUNCTION 'C2_DB_PLPH_READ' "Read PLPH from database
  EXPORTING
*   datub = 0                   " plph-datuv
*   datub = 0                   " plph-datuv    Date upper limit for DB selection
*   datuv = 0                   " plph-datuv
*   datuv = 0                   " plph-datuv    Date lower limit for DB selection
    plnnr =                     " plph-plnnr
    plnnr =                     " plph-plnnr    selected task list number
    plnty =                     " plph-plnty
    plnty =                     " plph-plnty    selected task list type
  IMPORTING
    plnph_max =                 " rc2bt-plnph_max  max. phase counter
    zaehl_max =                 " rc2bt-zaehl_ph  Max. change counter
  TABLES
    planph =                    " plphb
  EXCEPTIONS
    NO_RECORDS = 1              "               No records exist for selected task list no.
    .  "  C2_DB_PLPH_READ

ABAP code example for Function Module C2_DB_PLPH_READ

The ABAP code below is a full code listing to execute function module C2_DB_PLPH_READ 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_plnph_max  
 
 TYPE RC2BT-PLNPH_MAX
,
ld_zaehl_max  
 
 TYPE RC2BT-ZAEHL_PH
,
it_planph  
 
 TYPE STANDARD TABLE OF PLPHB,"TABLES PARAM
wa_planph
 
 LIKE LINE OF it_planph
.

 

SELECT single DATUV 
  FROM PLPH 
  INTO @DATA(ld_datub).

 

SELECT single DATUV 
  FROM PLPH 
  INTO @DATA(ld_datub).

 

SELECT single DATUV 
  FROM PLPH 
  INTO @DATA(ld_datuv).

 

SELECT single DATUV 
  FROM PLPH 
  INTO @DATA(ld_datuv).

 

SELECT single PLNNR 
  FROM PLPH 
  INTO @DATA(ld_plnnr).

 

SELECT single PLNNR 
  FROM PLPH 
  INTO @DATA(ld_plnnr).

 

SELECT single PLNTY 
  FROM PLPH 
  INTO @DATA(ld_plnty).

 

SELECT single PLNTY 
  FROM PLPH 
  INTO @DATA(ld_plnty).

 

"populate fields of struture and append to itab
append wa_planph to it_planph.
.

CALL FUNCTION 'C2_DB_PLPH_READ'
  EXPORTING
*   datub =                      ld_datub
*   datub =                      ld_datub
*   datuv =                      ld_datuv
*   datuv =                      ld_datuv
    plnnr =                      ld_plnnr
    plnnr =                      ld_plnnr
    plnty =                      ld_plnty
    plnty =                      ld_plnty
  IMPORTING
    plnph_max =                  ld_plnph_max
    zaehl_max =                  ld_zaehl_max
  TABLES
    planph =                     it_planph
  EXCEPTIONS
    NO_RECORDS =                 1
    .  "  C2_DB_PLPH_READ

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_plnph_max
 
 TYPE RC2BT-PLNPH_MAX ,
ld_datub
 
 TYPE PLPH-DATUV ,
ld_datub
 
 TYPE PLPH-DATUV ,
it_planph
 
 TYPE STANDARD TABLE OF PLPHB ,
wa_planph
 
 LIKE LINE OF it_planph,
ld_zaehl_max
 
 TYPE RC2BT-ZAEHL_PH ,
ld_datuv
 
 TYPE PLPH-DATUV ,
ld_datuv
 
 TYPE PLPH-DATUV ,
ld_plnnr
 
 TYPE PLPH-PLNNR ,
ld_plnnr
 
 TYPE PLPH-PLNNR ,
ld_plnty
 
 TYPE PLPH-PLNTY ,
ld_plnty
 
 TYPE PLPH-PLNTY .



SELECT single DATUV 
  FROM PLPH 
  INTO ld_datub.


SELECT single DATUV 
  FROM PLPH 
  INTO ld_datub.
 

"populate fields of struture and append to itab
append wa_planph to it_planph.

SELECT single DATUV 
  FROM PLPH 
  INTO ld_datuv.


SELECT single DATUV 
  FROM PLPH 
  INTO ld_datuv.


SELECT single PLNNR 
  FROM PLPH 
  INTO ld_plnnr.


SELECT single PLNNR 
  FROM PLPH 
  INTO ld_plnnr.


SELECT single PLNTY 
  FROM PLPH 
  INTO ld_plnty.


SELECT single PLNTY 
  FROM PLPH 
  INTO ld_plnty.