CP_DB_PLPO_READ SAP Function module

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

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

Pattern for FM CP_DB_PLPO_READ - CP DB PLPO READ

CALL FUNCTION 'CP_DB_PLPO_READ' "
  EXPORTING
*   datub = 0                   " plko-datuv    Date upper limit for DB selection
*   datuv = 0                   " plko-datuv    Date lower limit for DB selection
*   plnal = SPACE               " plko-plnal    selected alternative (optional ent
    plnnr =                     " plko-plnnr    selected routing number
    plnty =                     " plko-plnty    selected routing type
  IMPORTING
    flg_not_found =             "
    plnkn_max =                 " plpo-plnkn    Highest planning node number of th
    zaehl_max =                 " plpo-zaehl
  TABLES
    planpo =                    " plpob
  EXCEPTIONS
    NO_RECORDS = 1              "               No data records exist for the sele
    .  "  CP_DB_PLPO_READ

ABAP code example for Function Module CP_DB_PLPO_READ

The ABAP code below is a full code listing to execute function module CP_DB_PLPO_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_flg_not_found  
 
 TYPE STRING
,
ld_plnkn_max  
 
 TYPE PLPO-PLNKN
,
ld_zaehl_max  
 
 TYPE PLPO-ZAEHL
,
it_planpo  
 
 TYPE STANDARD TABLE OF PLPOB,"TABLES PARAM
wa_planpo
 
 LIKE LINE OF it_planpo
.

 

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

 

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

 

SELECT single PLNAL 
  FROM PLKO 
  INTO @DATA(ld_plnal).

 

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

 

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

 

"populate fields of struture and append to itab
append wa_planpo to it_planpo.
.

CALL FUNCTION 'CP_DB_PLPO_READ'
  EXPORTING
*   datub =                      ld_datub
*   datuv =                      ld_datuv
*   plnal =                      ld_plnal
    plnnr =                      ld_plnnr
    plnty =                      ld_plnty
  IMPORTING
    flg_not_found =              ld_flg_not_found
    plnkn_max =                  ld_plnkn_max
    zaehl_max =                  ld_zaehl_max
  TABLES
    planpo =                     it_planpo
  EXCEPTIONS
    NO_RECORDS =                 1
    .  "  CP_DB_PLPO_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_flg_not_found
 
 TYPE STRING ,
ld_datub
 
 TYPE PLKO-DATUV ,
it_planpo
 
 TYPE STANDARD TABLE OF PLPOB ,
wa_planpo
 
 LIKE LINE OF it_planpo,
ld_plnkn_max
 
 TYPE PLPO-PLNKN ,
ld_datuv
 
 TYPE PLKO-DATUV ,
ld_zaehl_max
 
 TYPE PLPO-ZAEHL ,
ld_plnal
 
 TYPE PLKO-PLNAL ,
ld_plnnr
 
 TYPE PLKO-PLNNR ,
ld_plnty
 
 TYPE PLKO-PLNTY .



SELECT single DATUV 
  FROM PLKO 
  INTO ld_datub.
 

"populate fields of struture and append to itab
append wa_planpo to it_planpo.

SELECT single DATUV 
  FROM PLKO 
  INTO ld_datuv.


SELECT single PLNAL 
  FROM PLKO 
  INTO ld_plnal.


SELECT single PLNNR 
  FROM PLKO 
  INTO ld_plnnr.


SELECT single PLNTY 
  FROM PLKO 
  INTO ld_plnty.