ABAP Select data from SAP table J_3R_PROPTAX_S21T_LAYOUT 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 J_3R_PROPTAX_S21T_LAYOUT 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 J_3R_PROPTAX_S21T_LAYOUT. 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 J_3R_PROPTAX_S21T_LAYOUT 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_J_3R_PROPTAX_S21T_LAYOUT TYPE STANDARD TABLE OF J_3R_PROPTAX_S21T_LAYOUT,
      WA_J_3R_PROPTAX_S21T_LAYOUT TYPE J_3R_PROPTAX_S21T_LAYOUT,
      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: <J_3R_PROPTAX_S21T_LAYOUT> TYPE J_3R_PROPTAX_S21T_LAYOUT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM J_3R_PROPTAX_S21T_LAYOUT
*  INTO TABLE @DATA(IT_J_3R_PROPTAX_S21T_LAYOUT2).
*--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_J_3R_PROPTAX_S21T_LAYOUT INDEX 1 INTO DATA(WA_J_3R_PROPTAX_S21T_LAYOUT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<J_3R_PROPTAX_S21T_LAYOUT>-CADASTR_NUM = 1.
<J_3R_PROPTAX_S21T_LAYOUT>-PROVISION_NUM = 1.
<J_3R_PROPTAX_S21T_LAYOUT>-INVNR = 1.
<J_3R_PROPTAX_S21T_LAYOUT>-OKOF_CODE = 1.
<J_3R_PROPTAX_S21T_LAYOUT>-NBV_VAL = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_J_3R_PROPTAX_S21T_LAYOUT-WAERS, sy-vline,
  WA_J_3R_PROPTAX_S21T_LAYOUT-TERR_CODE, sy-vline,
  WA_J_3R_PROPTAX_S21T_LAYOUT-PROPERTY_NUMBER, sy-vline,
  WA_J_3R_PROPTAX_S21T_LAYOUT-PROPERTY_NUMBER_TYPE, sy-vline,
  WA_J_3R_PROPTAX_S21T_LAYOUT-ADDRESS_GUID, sy-vline,
  WA_J_3R_PROPTAX_S21T_LAYOUT-POSTAL_CODE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_J_3R_PROPTAX_S21T_LAYOUT 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_J_3R_PROPTAX_S21T_LAYOUT 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_J_3R_PROPTAX_S21T_LAYOUT INTO WA_J_3R_PROPTAX_S21T_LAYOUT.


*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 AU172, internal->external for field NBV_VAL
CALL FUNCTION 'CONVERSION_EXIT_AU172_OUTPUT'
  EXPORTING
    input =                      WA_J_3R_PROPTAX_S21T_LAYOUT-NBV_VAL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_J_3R_PROPTAX_S21T_LAYOUT-NBV_VAL.
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_J_3R_PROPTAX_S21T_LAYOUT_STR, 
CADASTR_NUM TYPE STRING,
PROVISION_NUM TYPE STRING,
INVNR TYPE STRING,
OKOF_CODE TYPE STRING,
NBV_VAL TYPE STRING,
WAERS TYPE STRING,
TERR_CODE TYPE STRING,
PROPERTY_NUMBER TYPE STRING,
PROPERTY_NUMBER_TYPE TYPE STRING,
ADDRESS_GUID TYPE STRING,
POSTAL_CODE TYPE STRING,
REGION TYPE STRING,
DISTRICT_TYPE TYPE STRING,
DISTRICT_NAME TYPE STRING,
DISTRICT_TERR_TYPE TYPE STRING,
DISTRICT_TERR_NAME TYPE STRING,
LOCALITY_TYPE TYPE STRING,
LOCALITY_NAME TYPE STRING,
LOCALITY_TERR_TYPE TYPE STRING,
LOCALITY_TERR_NAME TYPE STRING,
STREET_TYPE TYPE STRING,
STREET_NAME TYPE STRING,
LAND_PLOT_NUM TYPE STRING,
BUILDING_TYPE1 TYPE STRING,
BUILDING_NUMBER1 TYPE STRING,
BUILDING_TYPE2 TYPE STRING,
BUILDING_NUMBER2 TYPE STRING,
BUILDING_TYPE3 TYPE STRING,
BUILDING_NUMBER3 TYPE STRING,
BUILDING_ROOM_TYPE TYPE STRING,
BUILDING_ROOM_NUMBER TYPE STRING,
APARTMENT_ROOM_TYPE TYPE STRING,
APARTMENT_ROOM_NUMBER TYPE STRING,
NUMBER1 TYPE STRING,
NUMBER2 TYPE STRING,
DISTRICTNAME1 TYPE STRING,
DISTRICTNAME2 TYPE STRING,
DISTRICTTERR1 TYPE STRING,
DISTRICTTERR2 TYPE STRING,
LOCALITYNAME1 TYPE STRING,
LOCALITYNAME2 TYPE STRING,
LOCALITYTERR1 TYPE STRING,
LOCALITYTERR2 TYPE STRING,
LOCALITYTERR3 TYPE STRING,
STREETNAME1 TYPE STRING,
STREETNAME2 TYPE STRING,
STREETNAME3 TYPE STRING,
OKOF1 TYPE STRING,
OKOF2 TYPE STRING,
OKOF3 TYPE STRING,
OKOF4 TYPE STRING,
OKOF5 TYPE STRING,
NBV_VAL_STR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_J_3R_PROPTAX_S21T_LAYOUT_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_J_3R_PROPTAX_S21T_LAYOUT_STR-CADASTR_NUM sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-PROVISION_NUM sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-INVNR sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-OKOF_CODE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-NBV_VAL sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-WAERS sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-TERR_CODE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-PROPERTY_NUMBER sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-PROPERTY_NUMBER_TYPE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-ADDRESS_GUID sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-POSTAL_CODE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-REGION sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-DISTRICT_TYPE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-DISTRICT_NAME sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-DISTRICT_TERR_TYPE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-DISTRICT_TERR_NAME sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-LOCALITY_TYPE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-LOCALITY_NAME sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-LOCALITY_TERR_TYPE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-LOCALITY_TERR_NAME sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-STREET_TYPE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-STREET_NAME sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-LAND_PLOT_NUM sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-BUILDING_TYPE1 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-BUILDING_NUMBER1 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-BUILDING_TYPE2 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-BUILDING_NUMBER2 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-BUILDING_TYPE3 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-BUILDING_NUMBER3 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-BUILDING_ROOM_TYPE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-BUILDING_ROOM_NUMBER sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-APARTMENT_ROOM_TYPE sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-APARTMENT_ROOM_NUMBER sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-NUMBER1 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-NUMBER2 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-DISTRICTNAME1 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-DISTRICTNAME2 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-DISTRICTTERR1 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-DISTRICTTERR2 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-LOCALITYNAME1 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-LOCALITYNAME2 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-LOCALITYTERR1 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-LOCALITYTERR2 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-LOCALITYTERR3 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-STREETNAME1 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-STREETNAME2 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-STREETNAME3 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-OKOF1 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-OKOF2 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-OKOF3 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-OKOF4 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-OKOF5 sy-vline 
WA_J_3R_PROPTAX_S21T_LAYOUT_STR-NBV_VAL_STR sy-vline      INTO ld_text SEPARATED BY SPACE.

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