ABAP Select data from SAP table RESCSUCOSTHISTORY into internal table

Get Example source ABAP code based on a different SAP table
  

Below is a number of ABAP code snippets to demonstrate how to select data from SAP RESCSUCOSTHISTORY 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 RESCSUCOSTHISTORY. 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 RESCSUCOSTHISTORY 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_RESCSUCOSTHISTORY TYPE STANDARD TABLE OF RESCSUCOSTHISTORY,
      WA_RESCSUCOSTHISTORY TYPE RESCSUCOSTHISTORY,
      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: <RESCSUCOSTHISTORY> TYPE RESCSUCOSTHISTORY.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RESCSUCOSTHISTORY
*  INTO TABLE @DATA(IT_RESCSUCOSTHISTORY2).
*--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_RESCSUCOSTHISTORY INDEX 1 INTO DATA(WA_RESCSUCOSTHISTORY2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_RESCSUCOSTHISTORY ASSIGNING <RESCSUCOSTHISTORY>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<RESCSUCOSTHISTORY>-MANDT = 1.
<RESCSUCOSTHISTORY>-INTRENO = 1.
<RESCSUCOSTHISTORY>-BUKRS = 1.
<RESCSUCOSTHISTORY>-SWENR = 1.
<RESCSUCOSTHISTORY>-SNKSL = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RESCSUCOSTHISTORY-SEMPSL, sy-vline,
WA_RESCSUCOSTHISTORY-OBJNR, sy-vline,
WA_RESCSUCOSTHISTORY-IMKEY, sy-vline,
WA_RESCSUCOSTHISTORY-CREATIONTYPE, sy-vline,
WA_RESCSUCOSTHISTORY-RERF, sy-vline,
WA_RESCSUCOSTHISTORY-DERF, sy-vline.
ENDLOOP. *Add any further fields from structure WA_RESCSUCOSTHISTORY 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_RESCSUCOSTHISTORY 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_RESCSUCOSTHISTORY INTO WA_RESCSUCOSTHISTORY. *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 SWENR, internal->external for field SWENR CALL FUNCTION 'CONVERSION_EXIT_SWENR_OUTPUT' EXPORTING input = WA_RESCSUCOSTHISTORY-SWENR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RESCSUCOSTHISTORY-SWENR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit IMKEY, internal->external for field IMKEY CALL FUNCTION 'CONVERSION_EXIT_IMKEY_OUTPUT' EXPORTING input = WA_RESCSUCOSTHISTORY-IMKEY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RESCSUCOSTHISTORY-IMKEY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field VALIDTO CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_RESCSUCOSTHISTORY-VALIDTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RESCSUCOSTHISTORY-VALIDTO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field CORRVALIDTO CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_RESCSUCOSTHISTORY-CORRVALIDTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RESCSUCOSTHISTORY-CORRVALIDTO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field PTO CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_RESCSUCOSTHISTORY-PTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RESCSUCOSTHISTORY-PTO.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit REDAT, internal->external for field PTO01 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_RESCSUCOSTHISTORY-PTO01 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RESCSUCOSTHISTORY-PTO01.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field PTO02 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_RESCSUCOSTHISTORY-PTO02 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RESCSUCOSTHISTORY-PTO02.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field PTO03 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_RESCSUCOSTHISTORY-PTO03 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RESCSUCOSTHISTORY-PTO03.
WRITE:/ 'New Value:', ld_input.

*Conversion exit REDAT, internal->external for field PTO04 CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_RESCSUCOSTHISTORY-PTO04 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RESCSUCOSTHISTORY-PTO04.
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_RESCSUCOSTHISTORY_STR,
MANDT TYPE STRING,
INTRENO TYPE STRING,
BUKRS TYPE STRING,
SWENR TYPE STRING,
SNKSL TYPE STRING,
SEMPSL TYPE STRING,
OBJNR TYPE STRING,
IMKEY TYPE STRING,
CREATIONTYPE TYPE STRING,
RERF TYPE STRING,
DERF TYPE STRING,
TERF TYPE STRING,
REHER TYPE STRING,
RBEAR TYPE STRING,
DBEAR TYPE STRING,
TBEAR TYPE STRING,
RBHER TYPE STRING,
RESPONSIBLE TYPE STRING,
USEREXCLUSIVE TYPE STRING,
AUTHGRP TYPE STRING,
VALIDFROM TYPE STRING,
VALIDTO TYPE STRING,
SUTYPE TYPE STRING,
XSU TYPE STRING,
TENANCYLAW TYPE STRING,
HASCOSTOBJECT TYPE STRING,
NOTAXCORR TYPE STRING,
EXCHANGETYPE TYPE STRING,
SETTLADVPAY TYPE STRING,
PERHEATING TYPE STRING,
PERHOTWATER TYPE STRING,
MSUCROSSOVERCC TYPE STRING,
CORRSU TYPE STRING,
CORRINTRENO TYPE STRING,
CORRVALIDFROM TYPE STRING,
CORRVALIDTO TYPE STRING,
SUEXTFORSCS TYPE STRING,
BUTXT TYPE STRING,
XWETEXT TYPE STRING,
XSCKEY TYPE STRING,
SETTLVARIANT TYPE STRING,
PFROM TYPE STRING,
PTO TYPE STRING,
PROCESSID TYPE STRING,
PROCESSEXTID TYPE STRING,
XSTATUS TYPE STRING,
VALIDITY TYPE STRING,
XAUTHGRP TYPE STRING,
GSBER TYPE STRING,
PRCTR TYPE STRING,
COST_INDICATOR TYPE STRING,
IS_APPORTIONABLE TYPE STRING,
ONLY_COMMERCIAL TYPE STRING,
USE_HEATDAYS TYPE STRING,
DIRECTCOSTID TYPE STRING,
CREDITGLACCSYMB TYPE STRING,
SCKEYPROCIND TYPE STRING,
SCKEYGRP TYPE STRING,
XSCKEYGRP TYPE STRING,
COSTACCOUNT TYPE STRING,
TAXACCOUNT TYPE STRING,
TAXTYPE TYPE STRING,
TAXGROUP TYPE STRING,
ACCOUNTDESCRIPTION TYPE STRING,
CURRENCY01 TYPE STRING,
NETAMOUNT01 TYPE STRING,
TAXAMOUNT01 TYPE STRING,
DEDUCTTAX01 TYPE STRING,
NONDEDUCTTAX01 TYPE STRING,
GROSSAMOUNT01 TYPE STRING,
PERCENT_NET01 TYPE STRING,
PERCENT_GROSS01 TYPE STRING,
PFROM01 TYPE STRING,
PTO01 TYPE STRING,
PROCESSID01 TYPE STRING,
CURRENCY02 TYPE STRING,
NETAMOUNT02 TYPE STRING,
TAXAMOUNT02 TYPE STRING,
DEDUCTTAX02 TYPE STRING,
NONDEDUCTTAX02 TYPE STRING,
GROSSAMOUNT02 TYPE STRING,
PERCENT_NET02 TYPE STRING,
PERCENT_GROSS02 TYPE STRING,
PFROM02 TYPE STRING,
PTO02 TYPE STRING,
PROCESSID02 TYPE STRING,
CURRENCY03 TYPE STRING,
NETAMOUNT03 TYPE STRING,
TAXAMOUNT03 TYPE STRING,
DEDUCTTAX03 TYPE STRING,
NONDEDUCTTAX03 TYPE STRING,
GROSSAMOUNT03 TYPE STRING,
PERCENT_NET03 TYPE STRING,
PERCENT_GROSS03 TYPE STRING,
PFROM03 TYPE STRING,
PTO03 TYPE STRING,
PROCESSID03 TYPE STRING,
CURRENCY04 TYPE STRING,
NETAMOUNT04 TYPE STRING,
TAXAMOUNT04 TYPE STRING,
DEDUCTTAX04 TYPE STRING,
NONDEDUCTTAX04 TYPE STRING,
GROSSAMOUNT04 TYPE STRING,
PERCENT_NET04 TYPE STRING,
PERCENT_GROSS04 TYPE STRING,
PFROM04 TYPE STRING,
PTO04 TYPE STRING,
PROCESSID04 TYPE STRING,END OF T_EKKO_STR. DATA: WA_RESCSUCOSTHISTORY_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_RESCSUCOSTHISTORY_STR-MANDT sy-vline
WA_RESCSUCOSTHISTORY_STR-INTRENO sy-vline
WA_RESCSUCOSTHISTORY_STR-BUKRS sy-vline
WA_RESCSUCOSTHISTORY_STR-SWENR sy-vline
WA_RESCSUCOSTHISTORY_STR-SNKSL sy-vline
WA_RESCSUCOSTHISTORY_STR-SEMPSL sy-vline
WA_RESCSUCOSTHISTORY_STR-OBJNR sy-vline
WA_RESCSUCOSTHISTORY_STR-IMKEY sy-vline
WA_RESCSUCOSTHISTORY_STR-CREATIONTYPE sy-vline
WA_RESCSUCOSTHISTORY_STR-RERF sy-vline
WA_RESCSUCOSTHISTORY_STR-DERF sy-vline
WA_RESCSUCOSTHISTORY_STR-TERF sy-vline
WA_RESCSUCOSTHISTORY_STR-REHER sy-vline
WA_RESCSUCOSTHISTORY_STR-RBEAR sy-vline
WA_RESCSUCOSTHISTORY_STR-DBEAR sy-vline
WA_RESCSUCOSTHISTORY_STR-TBEAR sy-vline
WA_RESCSUCOSTHISTORY_STR-RBHER sy-vline
WA_RESCSUCOSTHISTORY_STR-RESPONSIBLE sy-vline
WA_RESCSUCOSTHISTORY_STR-USEREXCLUSIVE sy-vline
WA_RESCSUCOSTHISTORY_STR-AUTHGRP sy-vline
WA_RESCSUCOSTHISTORY_STR-VALIDFROM sy-vline
WA_RESCSUCOSTHISTORY_STR-VALIDTO sy-vline
WA_RESCSUCOSTHISTORY_STR-SUTYPE sy-vline
WA_RESCSUCOSTHISTORY_STR-XSU sy-vline
WA_RESCSUCOSTHISTORY_STR-TENANCYLAW sy-vline
WA_RESCSUCOSTHISTORY_STR-HASCOSTOBJECT sy-vline
WA_RESCSUCOSTHISTORY_STR-NOTAXCORR sy-vline
WA_RESCSUCOSTHISTORY_STR-EXCHANGETYPE sy-vline
WA_RESCSUCOSTHISTORY_STR-SETTLADVPAY sy-vline
WA_RESCSUCOSTHISTORY_STR-PERHEATING sy-vline
WA_RESCSUCOSTHISTORY_STR-PERHOTWATER sy-vline
WA_RESCSUCOSTHISTORY_STR-MSUCROSSOVERCC sy-vline
WA_RESCSUCOSTHISTORY_STR-CORRSU sy-vline
WA_RESCSUCOSTHISTORY_STR-CORRINTRENO sy-vline
WA_RESCSUCOSTHISTORY_STR-CORRVALIDFROM sy-vline
WA_RESCSUCOSTHISTORY_STR-CORRVALIDTO sy-vline
WA_RESCSUCOSTHISTORY_STR-SUEXTFORSCS sy-vline
WA_RESCSUCOSTHISTORY_STR-BUTXT sy-vline
WA_RESCSUCOSTHISTORY_STR-XWETEXT sy-vline
WA_RESCSUCOSTHISTORY_STR-XSCKEY sy-vline
WA_RESCSUCOSTHISTORY_STR-SETTLVARIANT sy-vline
WA_RESCSUCOSTHISTORY_STR-PFROM sy-vline
WA_RESCSUCOSTHISTORY_STR-PTO sy-vline
WA_RESCSUCOSTHISTORY_STR-PROCESSID sy-vline
WA_RESCSUCOSTHISTORY_STR-PROCESSEXTID sy-vline
WA_RESCSUCOSTHISTORY_STR-XSTATUS sy-vline
WA_RESCSUCOSTHISTORY_STR-VALIDITY sy-vline
WA_RESCSUCOSTHISTORY_STR-XAUTHGRP sy-vline
WA_RESCSUCOSTHISTORY_STR-GSBER sy-vline
WA_RESCSUCOSTHISTORY_STR-PRCTR sy-vline
WA_RESCSUCOSTHISTORY_STR-COST_INDICATOR sy-vline
WA_RESCSUCOSTHISTORY_STR-IS_APPORTIONABLE sy-vline
WA_RESCSUCOSTHISTORY_STR-ONLY_COMMERCIAL sy-vline
WA_RESCSUCOSTHISTORY_STR-USE_HEATDAYS sy-vline
WA_RESCSUCOSTHISTORY_STR-DIRECTCOSTID sy-vline
WA_RESCSUCOSTHISTORY_STR-CREDITGLACCSYMB sy-vline
WA_RESCSUCOSTHISTORY_STR-SCKEYPROCIND sy-vline
WA_RESCSUCOSTHISTORY_STR-SCKEYGRP sy-vline
WA_RESCSUCOSTHISTORY_STR-XSCKEYGRP sy-vline
WA_RESCSUCOSTHISTORY_STR-COSTACCOUNT sy-vline
WA_RESCSUCOSTHISTORY_STR-TAXACCOUNT sy-vline
WA_RESCSUCOSTHISTORY_STR-TAXTYPE sy-vline
WA_RESCSUCOSTHISTORY_STR-TAXGROUP sy-vline
WA_RESCSUCOSTHISTORY_STR-ACCOUNTDESCRIPTION sy-vline
WA_RESCSUCOSTHISTORY_STR-CURRENCY01 sy-vline
WA_RESCSUCOSTHISTORY_STR-NETAMOUNT01 sy-vline
WA_RESCSUCOSTHISTORY_STR-TAXAMOUNT01 sy-vline
WA_RESCSUCOSTHISTORY_STR-DEDUCTTAX01 sy-vline
WA_RESCSUCOSTHISTORY_STR-NONDEDUCTTAX01 sy-vline
WA_RESCSUCOSTHISTORY_STR-GROSSAMOUNT01 sy-vline
WA_RESCSUCOSTHISTORY_STR-PERCENT_NET01 sy-vline
WA_RESCSUCOSTHISTORY_STR-PERCENT_GROSS01 sy-vline
WA_RESCSUCOSTHISTORY_STR-PFROM01 sy-vline
WA_RESCSUCOSTHISTORY_STR-PTO01 sy-vline
WA_RESCSUCOSTHISTORY_STR-PROCESSID01 sy-vline
WA_RESCSUCOSTHISTORY_STR-CURRENCY02 sy-vline
WA_RESCSUCOSTHISTORY_STR-NETAMOUNT02 sy-vline
WA_RESCSUCOSTHISTORY_STR-TAXAMOUNT02 sy-vline
WA_RESCSUCOSTHISTORY_STR-DEDUCTTAX02 sy-vline
WA_RESCSUCOSTHISTORY_STR-NONDEDUCTTAX02 sy-vline
WA_RESCSUCOSTHISTORY_STR-GROSSAMOUNT02 sy-vline
WA_RESCSUCOSTHISTORY_STR-PERCENT_NET02 sy-vline
WA_RESCSUCOSTHISTORY_STR-PERCENT_GROSS02 sy-vline
WA_RESCSUCOSTHISTORY_STR-PFROM02 sy-vline
WA_RESCSUCOSTHISTORY_STR-PTO02 sy-vline
WA_RESCSUCOSTHISTORY_STR-PROCESSID02 sy-vline
WA_RESCSUCOSTHISTORY_STR-CURRENCY03 sy-vline
WA_RESCSUCOSTHISTORY_STR-NETAMOUNT03 sy-vline
WA_RESCSUCOSTHISTORY_STR-TAXAMOUNT03 sy-vline
WA_RESCSUCOSTHISTORY_STR-DEDUCTTAX03 sy-vline
WA_RESCSUCOSTHISTORY_STR-NONDEDUCTTAX03 sy-vline
WA_RESCSUCOSTHISTORY_STR-GROSSAMOUNT03 sy-vline
WA_RESCSUCOSTHISTORY_STR-PERCENT_NET03 sy-vline
WA_RESCSUCOSTHISTORY_STR-PERCENT_GROSS03 sy-vline
WA_RESCSUCOSTHISTORY_STR-PFROM03 sy-vline
WA_RESCSUCOSTHISTORY_STR-PTO03 sy-vline
WA_RESCSUCOSTHISTORY_STR-PROCESSID03 sy-vline
WA_RESCSUCOSTHISTORY_STR-CURRENCY04 sy-vline
WA_RESCSUCOSTHISTORY_STR-NETAMOUNT04 sy-vline
WA_RESCSUCOSTHISTORY_STR-TAXAMOUNT04 sy-vline
WA_RESCSUCOSTHISTORY_STR-DEDUCTTAX04 sy-vline
WA_RESCSUCOSTHISTORY_STR-NONDEDUCTTAX04 sy-vline
WA_RESCSUCOSTHISTORY_STR-GROSSAMOUNT04 sy-vline
WA_RESCSUCOSTHISTORY_STR-PERCENT_NET04 sy-vline
WA_RESCSUCOSTHISTORY_STR-PERCENT_GROSS04 sy-vline
WA_RESCSUCOSTHISTORY_STR-PFROM04 sy-vline
WA_RESCSUCOSTHISTORY_STR-PTO04 sy-vline
WA_RESCSUCOSTHISTORY_STR-PROCESSID04 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.