ABAP Select data from SAP table /DSD/RP_TOUR_CAPACITY 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 /DSD/RP_TOUR_CAPACITY 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 /DSD/RP_TOUR_CAPACITY. 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 /DSD/RP_TOUR_CAPACITY 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_/DSD/RP_TOUR_CAPACITY TYPE STANDARD TABLE OF /DSD/RP_TOUR_CAPACITY,
      WA_/DSD/RP_TOUR_CAPACITY TYPE /DSD/RP_TOUR_CAPACITY,
      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: </DSD/RP_TOUR_CAPACITY> TYPE /DSD/RP_TOUR_CAPACITY.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /DSD/RP_TOUR_CAPACITY
*  INTO TABLE @DATA(IT_/DSD/RP_TOUR_CAPACITY2).
*--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_/DSD/RP_TOUR_CAPACITY INDEX 1 INTO DATA(WA_/DSD/RP_TOUR_CAPACITY2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</DSD/RP_TOUR_CAPACITY>-TOP = 1.
</DSD/RP_TOUR_CAPACITY>-MANDT = 1.
</DSD/RP_TOUR_CAPACITY>-ROUTE = 1.
</DSD/RP_TOUR_CAPACITY>-VPTYP = 1.
</DSD/RP_TOUR_CAPACITY>-LFDNR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/DSD/RP_TOUR_CAPACITY-SEQUENCENR, sy-vline,
  WA_/DSD/RP_TOUR_CAPACITY-DRIVER1, sy-vline,
  WA_/DSD/RP_TOUR_CAPACITY-DRIVER2, sy-vline,
  WA_/DSD/RP_TOUR_CAPACITY-TRUCK, sy-vline,
  WA_/DSD/RP_TOUR_CAPACITY-TRAIL, sy-vline,
  WA_/DSD/RP_TOUR_CAPACITY-STOPS, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/DSD/RP_TOUR_CAPACITY 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_/DSD/RP_TOUR_CAPACITY 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_/DSD/RP_TOUR_CAPACITY INTO WA_/DSD/RP_TOUR_CAPACITY.


*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 ALPHA, internal->external for field DRIVER1
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/DSD/RP_TOUR_CAPACITY-DRIVER1
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/DSD/RP_TOUR_CAPACITY-DRIVER1.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit TSTRN, internal->external for field MAXTIME
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_/DSD/RP_TOUR_CAPACITY-MAXTIME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/DSD/RP_TOUR_CAPACITY-MAXTIME.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit TSTRN, internal->external for field DAUER_TOT
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_/DSD/RP_TOUR_CAPACITY-DAUER_TOT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/DSD/RP_TOUR_CAPACITY-DAUER_TOT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field DAUER_OCC
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_/DSD/RP_TOUR_CAPACITY-DAUER_OCC
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/DSD/RP_TOUR_CAPACITY-DAUER_OCC.
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_/DSD/RP_TOUR_CAPACITY_STR, 
TOP TYPE STRING,
MANDT TYPE STRING,
ROUTE TYPE STRING,
VPTYP TYPE STRING,
LFDNR TYPE STRING,
SEQUENCENR TYPE STRING,
DRIVER1 TYPE STRING,
DRIVER2 TYPE STRING,
TRUCK TYPE STRING,
TRAIL TYPE STRING,
STOPS TYPE STRING,
MAXTIME TYPE STRING,
LOCKED TYPE STRING,
KAPAZITAET TYPE STRING,
NUTZL_TOT TYPE STRING,
NUTZL_OCC TYPE STRING,
GEW_U TYPE STRING,
LVOL_TOT TYPE STRING,
LVOL_OCC TYPE STRING,
LVOL_U TYPE STRING,
VARKAP_TOT TYPE STRING,
VARKAP_OCC TYPE STRING,
KAPUNIT TYPE STRING,
ANZSTOPS_OCC TYPE STRING,
DAUER_TOT TYPE STRING,
DAUER_OCC TYPE STRING,
LEINH_TOT TYPE STRING,
LEINH_OCC TYPE STRING,
LAST_STOPNR TYPE STRING,
LKW_IST_ZU TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/DSD/RP_TOUR_CAPACITY_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_/DSD/RP_TOUR_CAPACITY_STR-TOP sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-MANDT sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-ROUTE sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-VPTYP sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-LFDNR sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-SEQUENCENR sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-DRIVER1 sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-DRIVER2 sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-TRUCK sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-TRAIL sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-STOPS sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-MAXTIME sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-LOCKED sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-KAPAZITAET sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-NUTZL_TOT sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-NUTZL_OCC sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-GEW_U sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-LVOL_TOT sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-LVOL_OCC sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-LVOL_U sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-VARKAP_TOT sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-VARKAP_OCC sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-KAPUNIT sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-ANZSTOPS_OCC sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-DAUER_TOT sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-DAUER_OCC sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-LEINH_TOT sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-LEINH_OCC sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-LAST_STOPNR sy-vline 
WA_/DSD/RP_TOUR_CAPACITY_STR-LKW_IST_ZU sy-vline      INTO ld_text SEPARATED BY SPACE.

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