ABAP Select data from SAP table /SAPAPO/S_SCC_USRPR into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP /SAPAPO/S_SCC_USRPR table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to /SAPAPO/S_SCC_USRPR. See here for more generic Select statement tips.

Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.

There is also a full declaration of the /SAPAPO/S_SCC_USRPR table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.

DATA: IT_/SAPAPO/S_SCC_USRPR TYPE STANDARD TABLE OF /SAPAPO/S_SCC_USRPR,
      WA_/SAPAPO/S_SCC_USRPR TYPE /SAPAPO/S_SCC_USRPR,
      GD_STR TYPE STRING.

DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.

FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: </SAPAPO/S_SCC_USRPR> TYPE /SAPAPO/S_SCC_USRPR.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_/SAPAPO/S_SCC_USRPR.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /SAPAPO/S_SCC_USRPR
  INTO TABLE IT_/SAPAPO/S_SCC_USRPR.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /SAPAPO/S_SCC_USRPR
*  INTO TABLE @DATA(IT_/SAPAPO/S_SCC_USRPR2).
*--Further methods of using ABAP code to  select data from SAP database tables

*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_/SAPAPO/S_SCC_USRPR INDEX 1 INTO DATA(WA_/SAPAPO/S_SCC_USRPR2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SAPAPO/S_SCC_USRPR ASSIGNING </SAPAPO/S_SCC_USRPR>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</SAPAPO/S_SCC_USRPR>-ACTIVE_MAP_TSTFR = 1.
</SAPAPO/S_SCC_USRPR>-ACTIVE_MAP_TSTTO = 1.
</SAPAPO/S_SCC_USRPR>-MAP_DATE_FLG = 1.
</SAPAPO/S_SCC_USRPR>-MAP_MAT_FLG = 1.
</SAPAPO/S_SCC_USRPR>-MAP_DATEF = 1.

ENDLOOP.

LOOP AT IT_/SAPAPO/S_SCC_USRPR INTO WA_/SAPAPO/S_SCC_USRPR.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SAPAPO/S_SCC_USRPR-MAP_DATET, sy-vline,
  WA_/SAPAPO/S_SCC_USRPR-ACTIVETSTFR, sy-vline,
  WA_/SAPAPO/S_SCC_USRPR-ACTIVETSTTO, sy-vline,
  WA_/SAPAPO/S_SCC_USRPR-ACTIVEPRREG, sy-vline,
  WA_/SAPAPO/S_SCC_USRPR-ACTIVECTM_PRFLID, sy-vline,
  WA_/SAPAPO/S_SCC_USRPR-ACTIVESNP_PRASTP, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/SAPAPO/S_SCC_USRPR you want to display...

  WRITE:/ sy-uline.
* Aternatively use generic code to Write field values (and NAME) to screen report
  DO.
    ASSIGN COMPONENT sy-index OF STRUCTURE wa_/SAPAPO/S_SCC_USRPR TO <field>.
    IF sy-subrc <> 0. EXIT. ENDIF.
    WRITE:/ 'Field Value', <field>, sy-vline.
    gd_str = <field> .
    lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ).
    lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ).
    WRITE:/ 'Field Name', lv_fieldname.
  ENDDO.

  
*Redo loop but convert all fields from internal to out value  
LOOP AT IT_/SAPAPO/S_SCC_USRPR INTO WA_/SAPAPO/S_SCC_USRPR.


*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Convert all fields to display/output versions using conversion routines
  PERFORM convert_all_field_values CHANGING wa_EKKO.
	 
ENDLOOP.

  
*&---------------------------------------------------------------------*
*& Form convert_all_field_values
*&---------------------------------------------------------------------*
FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO.
DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.

*Conversion exit VRSIO, internal->external for field VRSIOID
CALL FUNCTION 'CONVERSION_EXIT_VRSIO_OUTPUT'
  EXPORTING
    input =                      WA_/SAPAPO/S_SCC_USRPR-VRSIOID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SAPAPO/S_SCC_USRPR-VRSIOID.
WRITE:/ 'New Value:', ld_input.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_/SAPAPO/S_SCC_USRPR_STR, 
ACTIVE_MAP_TSTFR TYPE STRING,
ACTIVE_MAP_TSTTO TYPE STRING,
MAP_DATE_FLG TYPE STRING,
MAP_MAT_FLG TYPE STRING,
MAP_DATEF TYPE STRING,
MAP_DATET TYPE STRING,
ACTIVETSTFR TYPE STRING,
ACTIVETSTTO TYPE STRING,
ACTIVEPRREG TYPE STRING,
ACTIVECTM_PRFLID TYPE STRING,
ACTIVESNP_PRASTP TYPE STRING,
MANDT TYPE STRING,
USERNAME TYPE STRING,
APPLID TYPE STRING,
ABSINTFLG TYPE STRING,
TSTFR TYPE STRING,
TSTTO TYPE STRING,
NMONTHS TYPE STRING,
NWEEKS TYPE STRING,
NDAYS TYPE STRING,
NHOURS TYPE STRING,
NMINUTES TYPE STRING,
INTFLG TYPE STRING,
SCCTSTR TYPE STRING,
VRSIOID TYPE STRING,
AMONPRFLG TYPE STRING,
ATP_PROFID TYPE STRING,
DP_PROFID TYPE STRING,
FCS_PROFID TYPE STRING,
SNP_PROFID TYPE STRING,
SDP_PROFID TYPE STRING,
VS_PROFID TYPE STRING,
TLB_PROFID TYPE STRING,
PP_PROFID TYPE STRING,
MSP_PROFID TYPE STRING,
VMI_PROFID TYPE STRING,
ATPPRREGFLG TYPE STRING,
PRREG TYPE STRING,
STAN_SELSC_FLG TYPE STRING,
INP_OBJ_DEFAULT TYPE STRING,
BASE_OBJ_DEFAULT TYPE STRING,
MAP_TREE_REL TYPE STRING,
MAP_DEFAULT TYPE STRING,
LV_ZOOM_FAC TYPE STRING,
LV_LUCORNERX TYPE STRING,
LV_LUCORNERY TYPE STRING,
GV_ZOOM_FAC TYPE STRING,
GV_LUCORNERX TYPE STRING,
GV_LUCORNERY TYPE STRING,
WA_INITIAL_IND TYPE STRING,
WA_SELMODE_IND TYPE STRING,
WA_SEL_DEFAULT TYPE STRING,
CTM_PRFL_FLG TYPE STRING,
CTM_PRFLID TYPE STRING,
SNP_PRASTP_FLG TYPE STRING,
SNP_PRASTP TYPE STRING,
MODEL TYPE STRING,
TRANSP_TSTTO TYPE STRING,
COLOR_CODING_FLG TYPE STRING,
LOC_POS_FLG TYPE STRING,
PROD_ASSIGN_FLG TYPE STRING,
LVIEW TYPE STRING,
GEOGR_VIEW_FLG TYPE STRING,
CONTEXT_PROFIL TYPE STRING,
WORKA TYPE STRING,
LINEUP_VERT_FLG TYPE STRING,
LINEUP_RI_LE_FLG TYPE STRING,
LINEUP_DO_UP_FLG TYPE STRING,
LINEUP_NAME_FLG TYPE STRING,
MULTI_OBJ_FLG TYPE STRING,
PLANNR TYPE STRING,
PL_USAGE TYPE STRING,
FILTER_LANE_FLG TYPE STRING,
RELH_FLG TYPE STRING,
RELH_WORKA_FLG TYPE STRING,
MC_DEP_OBJ TYPE STRING,
MC_LOK_LPROD TYPE STRING,
MC_LOK_RES TYPE STRING,
MC_LOK_PPM TYPE STRING,
AMON_POPUP_FLG TYPE STRING,
CATDESCR_FLG TYPE STRING,
RES_LONG_TXT_FLG TYPE STRING,
LP_DISP_FLG TYPE STRING,
ALERTDISPLAY_FLG TYPE STRING,
COLTRALERTERROR TYPE STRING,
COLTRALERTWARN TYPE STRING,
COLTRALERTINFO TYPE STRING,
COLMPALERTERROR TYPE STRING,
COLMPALERTWARN TYPE STRING,
COLMPALERTINFO TYPE STRING,
COLTRTEXT TYPE STRING,
COLNOMODEL TYPE STRING,
COLMPTEXT TYPE STRING,
COLMPHIGHLIGHT TYPE STRING,
DOCKEXTENSION TYPE STRING,
SPLITTERWIDTH TYPE STRING,
SCID TYPE STRING,
SCNAME TYPE STRING,
PMONDISP TYPE STRING,
CNTLFREE TYPE STRING,
CNTLTOGGLE TYPE STRING,
LONGTEXT TYPE STRING,
LONGTEXTMP TYPE STRING,
ND_PLRUN TYPE STRING,
MAP_CO_LEFT_LO TYPE STRING,
MAP_CO_RIGHT_LO TYPE STRING,
MAP_CO_TOP_LO TYPE STRING,
MAP_CO_BOTTOM_LO TYPE STRING,
MAP_CO_LEFT_GE TYPE STRING,
MAP_CO_RIGHT_GE TYPE STRING,
MAP_CO_TOP_GE TYPE STRING,
MAP_CO_BOTTOM_GE TYPE STRING,
MAP_LAYER TYPE STRING,
CLEARLVFLG TYPE STRING,
SORT_ALV1 TYPE STRING,
SORT_ALV2 TYPE STRING,
SORT_ALV3 TYPE STRING,
SORT_ALV4 TYPE STRING,
SORT_ALV5 TYPE STRING,
SORT_ALV7 TYPE STRING,
ALERTSATLOCATION TYPE STRING,
MSP_FLG TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/SAPAPO/S_SCC_USRPR_STR type T_EKKO_STR.

DATA: ld_text TYPE string.

LOOP AT IT_EKKO INTO WA_EKKO.
  MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR.
  CONCATENATE: sy-vline
WA_/SAPAPO/S_SCC_USRPR_STR-ACTIVE_MAP_TSTFR sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ACTIVE_MAP_TSTTO sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_DATE_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_MAT_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_DATEF sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_DATET sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ACTIVETSTFR sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ACTIVETSTTO sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ACTIVEPRREG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ACTIVECTM_PRFLID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ACTIVESNP_PRASTP sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MANDT sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-USERNAME sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-APPLID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ABSINTFLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-TSTFR sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-TSTTO sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-NMONTHS sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-NWEEKS sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-NDAYS sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-NHOURS sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-NMINUTES sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-INTFLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SCCTSTR sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-VRSIOID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-AMONPRFLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ATP_PROFID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-DP_PROFID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-FCS_PROFID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SNP_PROFID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SDP_PROFID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-VS_PROFID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-TLB_PROFID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-PP_PROFID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MSP_PROFID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-VMI_PROFID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ATPPRREGFLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-PRREG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-STAN_SELSC_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-INP_OBJ_DEFAULT sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-BASE_OBJ_DEFAULT sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_TREE_REL sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_DEFAULT sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LV_ZOOM_FAC sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LV_LUCORNERX sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LV_LUCORNERY sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-GV_ZOOM_FAC sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-GV_LUCORNERX sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-GV_LUCORNERY sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-WA_INITIAL_IND sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-WA_SELMODE_IND sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-WA_SEL_DEFAULT sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-CTM_PRFL_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-CTM_PRFLID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SNP_PRASTP_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SNP_PRASTP sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MODEL sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-TRANSP_TSTTO sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLOR_CODING_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LOC_POS_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-PROD_ASSIGN_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LVIEW sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-GEOGR_VIEW_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-CONTEXT_PROFIL sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-WORKA sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LINEUP_VERT_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LINEUP_RI_LE_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LINEUP_DO_UP_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LINEUP_NAME_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MULTI_OBJ_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-PLANNR sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-PL_USAGE sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-FILTER_LANE_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-RELH_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-RELH_WORKA_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MC_DEP_OBJ sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MC_LOK_LPROD sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MC_LOK_RES sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MC_LOK_PPM sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-AMON_POPUP_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-CATDESCR_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-RES_LONG_TXT_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LP_DISP_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ALERTDISPLAY_FLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLTRALERTERROR sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLTRALERTWARN sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLTRALERTINFO sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLMPALERTERROR sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLMPALERTWARN sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLMPALERTINFO sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLTRTEXT sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLNOMODEL sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLMPTEXT sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-COLMPHIGHLIGHT sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-DOCKEXTENSION sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SPLITTERWIDTH sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SCID sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SCNAME sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-PMONDISP sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-CNTLFREE sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-CNTLTOGGLE sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LONGTEXT sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-LONGTEXTMP sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ND_PLRUN sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_CO_LEFT_LO sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_CO_RIGHT_LO sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_CO_TOP_LO sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_CO_BOTTOM_LO sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_CO_LEFT_GE sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_CO_RIGHT_GE sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_CO_TOP_GE sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_CO_BOTTOM_GE sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MAP_LAYER sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-CLEARLVFLG sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SORT_ALV1 sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SORT_ALV2 sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SORT_ALV3 sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SORT_ALV4 sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SORT_ALV5 sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-SORT_ALV7 sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-ALERTSATLOCATION sy-vline 
WA_/SAPAPO/S_SCC_USRPR_STR-MSP_FLG sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.