ABAP Select data from SAP table HCMT_BSP_PA_AT_R0527 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 HCMT_BSP_PA_AT_R0527 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 HCMT_BSP_PA_AT_R0527. 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 HCMT_BSP_PA_AT_R0527 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_HCMT_BSP_PA_AT_R0527 TYPE STANDARD TABLE OF HCMT_BSP_PA_AT_R0527,
      WA_HCMT_BSP_PA_AT_R0527 TYPE HCMT_BSP_PA_AT_R0527,
      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: <HCMT_BSP_PA_AT_R0527> TYPE HCMT_BSP_PA_AT_R0527.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM HCMT_BSP_PA_AT_R0527
*  INTO TABLE @DATA(IT_HCMT_BSP_PA_AT_R05272).
*--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_HCMT_BSP_PA_AT_R0527 INDEX 1 INTO DATA(WA_HCMT_BSP_PA_AT_R05272).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<HCMT_BSP_PA_AT_R0527>-OBJECT_KEY = 1.
<HCMT_BSP_PA_AT_R0527>-PERNR = 1.
<HCMT_BSP_PA_AT_R0527>-AEDTM = 1.
<HCMT_BSP_PA_AT_R0527>-UNAME = 1.
<HCMT_BSP_PA_AT_R0527>-SPRPS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_HCMT_BSP_PA_AT_R0527-SPRTX, sy-vline,
  WA_HCMT_BSP_PA_AT_R0527-ITBLD, sy-vline,
  WA_HCMT_BSP_PA_AT_R0527-ITXEX, sy-vline,
  WA_HCMT_BSP_PA_AT_R0527-BEGDA, sy-vline,
  WA_HCMT_BSP_PA_AT_R0527-ENDDA, sy-vline,
  WA_HCMT_BSP_PA_AT_R0527-BMGJV, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_HCMT_BSP_PA_AT_R0527 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_HCMT_BSP_PA_AT_R0527 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_HCMT_BSP_PA_AT_R0527 INTO WA_HCMT_BSP_PA_AT_R0527.


*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.
ENDFORM. 

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

TYPES: BEGIN OF T_HCMT_BSP_PA_AT_R0527_STR, 
OBJECT_KEY TYPE STRING,
PERNR TYPE STRING,
AEDTM TYPE STRING,
UNAME TYPE STRING,
SPRPS TYPE STRING,
SPRTX TYPE STRING,
ITBLD TYPE STRING,
ITXEX TYPE STRING,
BEGDA TYPE STRING,
ENDDA TYPE STRING,
BMGJV TYPE STRING,
WAERS TYPE STRING,
ABAUTO TYPE STRING,
GABFG TYPE STRING,
ABANZDJ TYPE STRING,
ANZDJ TYPE STRING,
ZSAUTO TYPE STRING,
SOSOZ TYPE STRING,
SZMGT TYPE STRING,
FAAUTO TYPE STRING,
FABFG TYPE STRING,
FAVDZ TYPE STRING,
FZMGT TYPE STRING,
PENAB TYPE STRING,
ANPAB TYPE STRING,
ANGAB TYPE STRING,
GBMFACH TYPE STRING,
EUAUTO TYPE STRING,
MAAUTO TYPE STRING,
UGLFD TYPE STRING,
UGSZG TYPE STRING,
KONT TYPE STRING,
MAANZDJ TYPE STRING,
UKTAG TYPE STRING,
UESVF TYPE STRING,
KGLFD TYPE STRING,
KGSZG TYPE STRING,
KKTAG TYPE STRING,
KSVBG TYPE STRING,
AUFLJ TYPE STRING,
NIUEG TYPE STRING,
NIKEG TYPE STRING,
GRTXT TYPE STRING,
UCU11 TYPE STRING,
UCU12 TYPE STRING,
UCU13 TYPE STRING,
UCU14 TYPE STRING,
UCU15 TYPE STRING,
UCU21 TYPE STRING,
UCU22 TYPE STRING,
UCU23 TYPE STRING,
UCU24 TYPE STRING,
USVBG TYPE STRING,
SIMU_GABFG TYPE STRING,
SIMU_FABFG TYPE STRING,
SIMU_SOSOZ TYPE STRING,
SIMU_UGLFD TYPE STRING,
SIMU_UGSZG TYPE STRING,
ABFEJ TYPE STRING,
AGLFD TYPE STRING,
AGSZG TYPE STRING,
ANUAB TYPE STRING,
MALUJ TYPE STRING,
MGLFD TYPE STRING,
MGSZG TYPE STRING,
UEUAJ TYPE STRING,
UCU31 TYPE STRING,
UCU32 TYPE STRING,
ABSTS TYPE STRING,
FAKT1 TYPE STRING,
ABS_BETRG TYPE STRING,
ANT_STFREI TYPE STRING,
DN_SVBETRG TYPE STRING,
SONDERZAHL TYPE STRING,
ABZYE_STNET TYPE STRING,
ABZYE_STBRT TYPE STRING,
PENRED TYPE STRING,
UGSZG_SVDAT TYPE STRING,
KGSZG_SVDAT TYPE STRING,
ABENT TYPE STRING,
BMGJVDEF TYPE STRING,
ANGABDEF TYPE STRING,
ANPABDEF TYPE STRING,
FABFGDEF TYPE STRING,
ANZDJDEF TYPE STRING,
PENABDEF TYPE STRING,
SOSOZDEF TYPE STRING,
FAVDZDEF TYPE STRING,
UKTAGDEF TYPE STRING,
UGLFDDEF TYPE STRING,
UGSZGDEF TYPE STRING,
KONTDEF TYPE STRING,
KKTAGDEF TYPE STRING,
KGLFDDEF TYPE STRING,
KGSZGDEF TYPE STRING,
GABFGDEF TYPE STRING,
ABANZDJDEF TYPE STRING,
ST_NACH_PROZENTSIM TYPE STRING,
ST_NACH_QUOTIENTSIM TYPE STRING,
NACH_QUOTIENT_BLERTSIM TYPE STRING,
NACH_QUOTIENT_ALERTSIM TYPE STRING,
GABFGSIM TYPE STRING,
UGLFDSIM TYPE STRING,
UGSZGSIM TYPE STRING,
FABFGSIM TYPE STRING,
SOSOZSIM TYPE STRING,
ABS_BETRGSIM TYPE STRING,
ANT_STFREISIM TYPE STRING,
DN_SVBETRGSIM TYPE STRING,
SONDERZAHLSIM TYPE STRING,
ABZYE_STNETSIM TYPE STRING,
ABZYE_STBRTSIM TYPE STRING,
MGLFDSIM TYPE STRING,
MGSZGSIM TYPE STRING,
ANT_STFREITAXSIM TYPE STRING,
SONDERZAHLTAXSIM TYPE STRING,
DN_SVBETRGTAXSIM TYPE STRING,
ABS_BETRGTAXSIM TYPE STRING,
ABZYE_STBRTTAXSIM TYPE STRING,
ABZYE_STNETTAXSIM TYPE STRING,
ABSTAUTO1FLG TYPE STRING,
ABSTAUTO2FLG TYPE STRING,
ABSTAUTO3FLG TYPE STRING,
ABSTAUTO4FLG TYPE STRING,
ABSTAUTO5FLG TYPE STRING,
ABSTAUTO6FLG TYPE STRING,
ABAUTOFLG TYPE STRING,
FAAUTOFLG TYPE STRING,
ZSAUTOFLG TYPE STRING,
MAAUTOFLG TYPE STRING,
EUAUTOFLG TYPE STRING,
KOSTR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_HCMT_BSP_PA_AT_R0527_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_HCMT_BSP_PA_AT_R0527_STR-OBJECT_KEY sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-PERNR sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-AEDTM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UNAME sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SPRPS sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SPRTX sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ITBLD sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ITXEX sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-BEGDA sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ENDDA sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-BMGJV sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-WAERS sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABAUTO sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-GABFG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABANZDJ sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ANZDJ sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ZSAUTO sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SOSOZ sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SZMGT sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-FAAUTO sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-FABFG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-FAVDZ sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-FZMGT sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-PENAB sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ANPAB sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ANGAB sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-GBMFACH sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-EUAUTO sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-MAAUTO sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UGLFD sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UGSZG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KONT sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-MAANZDJ sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UKTAG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UESVF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KGLFD sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KGSZG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KKTAG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KSVBG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-AUFLJ sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-NIUEG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-NIKEG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-GRTXT sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU11 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU12 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU13 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU14 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU15 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU21 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU22 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU23 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU24 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-USVBG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SIMU_GABFG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SIMU_FABFG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SIMU_SOSOZ sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SIMU_UGLFD sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SIMU_UGSZG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABFEJ sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-AGLFD sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-AGSZG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ANUAB sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-MALUJ sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-MGLFD sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-MGSZG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UEUAJ sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU31 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UCU32 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABSTS sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-FAKT1 sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABS_BETRG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ANT_STFREI sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-DN_SVBETRG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SONDERZAHL sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABZYE_STNET sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABZYE_STBRT sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-PENRED sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UGSZG_SVDAT sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KGSZG_SVDAT sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABENT sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-BMGJVDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ANGABDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ANPABDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-FABFGDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ANZDJDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-PENABDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SOSOZDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-FAVDZDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UKTAGDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UGLFDDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UGSZGDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KONTDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KKTAGDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KGLFDDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KGSZGDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-GABFGDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABANZDJDEF sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ST_NACH_PROZENTSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ST_NACH_QUOTIENTSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-NACH_QUOTIENT_BLERTSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-NACH_QUOTIENT_ALERTSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-GABFGSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UGLFDSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-UGSZGSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-FABFGSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SOSOZSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABS_BETRGSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ANT_STFREISIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-DN_SVBETRGSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SONDERZAHLSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABZYE_STNETSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABZYE_STBRTSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-MGLFDSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-MGSZGSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ANT_STFREITAXSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-SONDERZAHLTAXSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-DN_SVBETRGTAXSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABS_BETRGTAXSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABZYE_STBRTTAXSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABZYE_STNETTAXSIM sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABSTAUTO1FLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABSTAUTO2FLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABSTAUTO3FLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABSTAUTO4FLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABSTAUTO5FLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABSTAUTO6FLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ABAUTOFLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-FAAUTOFLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-ZSAUTOFLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-MAAUTOFLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-EUAUTOFLG sy-vline 
WA_HCMT_BSP_PA_AT_R0527_STR-KOSTR sy-vline      INTO ld_text SEPARATED BY SPACE.

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