ABAP Select data from SAP table PSHLP_ACTY_MLST_ST 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 PSHLP_ACTY_MLST_ST 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 PSHLP_ACTY_MLST_ST. 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 PSHLP_ACTY_MLST_ST 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_PSHLP_ACTY_MLST_ST TYPE STANDARD TABLE OF PSHLP_ACTY_MLST_ST,
      WA_PSHLP_ACTY_MLST_ST TYPE PSHLP_ACTY_MLST_ST,
      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: <PSHLP_ACTY_MLST_ST> TYPE PSHLP_ACTY_MLST_ST.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM PSHLP_ACTY_MLST_ST
  INTO TABLE IT_PSHLP_ACTY_MLST_ST.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PSHLP_ACTY_MLST_ST
*  INTO TABLE @DATA(IT_PSHLP_ACTY_MLST_ST2).
*--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_PSHLP_ACTY_MLST_ST INDEX 1 INTO DATA(WA_PSHLP_ACTY_MLST_ST2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_PSHLP_ACTY_MLST_ST ASSIGNING <PSHLP_ACTY_MLST_ST>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PSHLP_ACTY_MLST_ST>-MLSTN = 1.
<PSHLP_ACTY_MLST_ST>-VORNR = 1.
<PSHLP_ACTY_MLST_ST>-LTXA1 = 1.
<PSHLP_ACTY_MLST_ST>-KZ_WFLOW = 1.
<PSHLP_ACTY_MLST_ST>-KZ_FRMST = 1.

ENDLOOP.

LOOP AT IT_PSHLP_ACTY_MLST_ST INTO WA_PSHLP_ACTY_MLST_ST.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PSHLP_ACTY_MLST_ST-KZ_TREND, sy-vline,
  WA_PSHLP_ACTY_MLST_ST-KZ_LSTWR, sy-vline,
  WA_PSHLP_ACTY_MLST_ST-KZ_FAKTP, sy-vline,
  WA_PSHLP_ACTY_MLST_ST-LST_FERTG, sy-vline,
  WA_PSHLP_ACTY_MLST_ST-FPROZ, sy-vline,
  WA_PSHLP_ACTY_MLST_ST-EDATU, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PSHLP_ACTY_MLST_ST 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_PSHLP_ACTY_MLST_ST 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_PSHLP_ACTY_MLST_ST INTO WA_PSHLP_ACTY_MLST_ST.


*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 NUMCV, internal->external for field VORNR
CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-VORNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-VORNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field DELTE
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-DELTE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-DELTE.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field STDNR_ICSN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-STDNR_ICSN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-STDNR_ICSN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ALTNR_ICSN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-ALTNR_ICSN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-ALTNR_ICSN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit NUMCV, internal->external for field OPRST_ICSN
CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-OPRST_ICSN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-OPRST_ICSN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit NUMCV, internal->external for field OPREN_ICSN
CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-OPREN_ICSN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-OPREN_ICSN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field STDNR_ICNW
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-STDNR_ICNW
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-STDNR_ICNW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ALTNR_ICNW
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-ALTNR_ICNW
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-ALTNR_ICNW.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field STDNR_ICPN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-STDNR_ICPN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-STDNR_ICPN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field ALTNR_ICPN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-ALTNR_ICPN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-ALTNR_ICPN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit NUMCV, internal->external for field VORNR_ICPN
CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT'
  EXPORTING
    input =                      WA_PSHLP_ACTY_MLST_ST-VORNR_ICPN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_PSHLP_ACTY_MLST_ST-VORNR_ICPN.
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_PSHLP_ACTY_MLST_ST_STR, 
MLSTN TYPE STRING,
VORNR TYPE STRING,
LTXA1 TYPE STRING,
KZ_WFLOW TYPE STRING,
KZ_FRMST TYPE STRING,
KZ_TREND TYPE STRING,
KZ_LSTWR TYPE STRING,
KZ_FAKTP TYPE STRING,
LST_FERTG TYPE STRING,
FPROZ TYPE STRING,
EDATU TYPE STRING,
EZEIT TYPE STRING,
TEDAT TYPE STRING,
TETIM TYPE STRING,
PDATU TYPE STRING,
PZEIT TYPE STRING,
TPDAT TYPE STRING,
TPTIM TYPE STRING,
LST_ACTDT TYPE STRING,
LST_ACTTM TYPE STRING,
LATED TYPE STRING,
DLTAS TYPE STRING,
DELTA TYPE STRING,
DELTE TYPE STRING,
PRCNT TYPE STRING,
RELSU TYPE STRING,
RELSU_SM TYPE STRING,
RELSU_TSS TYPE STRING,
RELSU_TUS TYPE STRING,
RELSU_CH TYPE STRING,
ACTLV TYPE STRING,
RELSU_TR TYPE STRING,
RELSU_SG TYPE STRING,
RELMS TYPE STRING,
RELMS_SM TYPE STRING,
RELMS_TSS TYPE STRING,
RELMS_TUS TYPE STRING,
RELMS_CH TYPE STRING,
RELMS_TR TYPE STRING,
RELMS_SG TYPE STRING,
INCSN TYPE STRING,
INCSN_SM TYPE STRING,
INCSN_TSS TYPE STRING,
INCSN_TUS TYPE STRING,
INCSN_CH TYPE STRING,
INCSN_TR TYPE STRING,
INCSN_SG TYPE STRING,
STDNR_ICSN TYPE STRING,
ALTNR_ICSN TYPE STRING,
OPRST_ICSN TYPE STRING,
OPREN_ICSN TYPE STRING,
INCNW TYPE STRING,
INCNW_SM TYPE STRING,
INCNW_TSS TYPE STRING,
INCNW_TUS TYPE STRING,
INCNW_CH TYPE STRING,
INCNW_TR TYPE STRING,
INCNW_SG TYPE STRING,
STDNR_ICNW TYPE STRING,
ALTNR_ICNW TYPE STRING,
AUART_ICNW TYPE STRING,
INCPN TYPE STRING,
INCPN_SM TYPE STRING,
INCPN_TSS TYPE STRING,
INCPN_TUS TYPE STRING,
INCPN_CH TYPE STRING,
INCPN_TR TYPE STRING,
INCPN_SG TYPE STRING,
STDNR_ICPN TYPE STRING,
ALTNR_ICPN TYPE STRING,
VORNR_ICPN TYPE STRING,
WKFLW TYPE STRING,
WKFLW_SM TYPE STRING,
WKFLW_TSS TYPE STRING,
WKFLW_TUS TYPE STRING,
WKFLW_CH TYPE STRING,
WKFLW_TR TYPE STRING,
WKFLW_SG TYPE STRING,
TASK_ID TYPE STRING,
USERH TYPE STRING,
USERV TYPE STRING,
DATEH TYPE STRING,
DATEV TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PSHLP_ACTY_MLST_ST_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_PSHLP_ACTY_MLST_ST_STR-MLSTN sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-VORNR sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-LTXA1 sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-KZ_WFLOW sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-KZ_FRMST sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-KZ_TREND sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-KZ_LSTWR sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-KZ_FAKTP sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-LST_FERTG sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-FPROZ sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-EDATU sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-EZEIT sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-TEDAT sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-TETIM sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-PDATU sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-PZEIT sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-TPDAT sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-TPTIM sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-LST_ACTDT sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-LST_ACTTM sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-LATED sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-DLTAS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-DELTA sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-DELTE sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-PRCNT sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELSU sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELSU_SM sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELSU_TSS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELSU_TUS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELSU_CH sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-ACTLV sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELSU_TR sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELSU_SG sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELMS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELMS_SM sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELMS_TSS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELMS_TUS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELMS_CH sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELMS_TR sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-RELMS_SG sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCSN sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCSN_SM sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCSN_TSS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCSN_TUS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCSN_CH sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCSN_TR sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCSN_SG sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-STDNR_ICSN sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-ALTNR_ICSN sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-OPRST_ICSN sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-OPREN_ICSN sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCNW sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCNW_SM sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCNW_TSS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCNW_TUS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCNW_CH sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCNW_TR sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCNW_SG sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-STDNR_ICNW sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-ALTNR_ICNW sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-AUART_ICNW sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCPN sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCPN_SM sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCPN_TSS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCPN_TUS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCPN_CH sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCPN_TR sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-INCPN_SG sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-STDNR_ICPN sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-ALTNR_ICPN sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-VORNR_ICPN sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-WKFLW sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-WKFLW_SM sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-WKFLW_TSS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-WKFLW_TUS sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-WKFLW_CH sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-WKFLW_TR sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-WKFLW_SG sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-TASK_ID sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-USERH sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-USERV sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-DATEH sy-vline 
WA_PSHLP_ACTY_MLST_ST_STR-DATEV sy-vline      INTO ld_text SEPARATED BY SPACE.

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