ABAP Select data from SAP table CSS_BCSM10 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 CSS_BCSM10 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 CSS_BCSM10. 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 CSS_BCSM10 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_CSS_BCSM10 TYPE STANDARD TABLE OF CSS_BCSM10,
      WA_CSS_BCSM10 TYPE CSS_BCSM10,
      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: <CSS_BCSM10> TYPE CSS_BCSM10.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CSS_BCSM10
*  INTO TABLE @DATA(IT_CSS_BCSM102).
*--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_CSS_BCSM10 INDEX 1 INTO DATA(WA_CSS_BCSM102).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CSS_BCSM10>-CSINSTA = 1.
<CSS_BCSM10>-MNUMM = 1.
<CSS_BCSM10>-MYEAR = 1.
<CSS_BCSM10>-SERVICE = 1.
<CSS_BCSM10>-SERVICETYP = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CSS_BCSM10-KNDID1, sy-vline,
  WA_CSS_BCSM10-KNDID2, sy-vline,
  WA_CSS_BCSM10-INSTID, sy-vline,
  WA_CSS_BCSM10-SERVREL, sy-vline,
  WA_CSS_BCSM10-AKTION, sy-vline,
  WA_CSS_BCSM10-AKTIONINST, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CSS_BCSM10 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_CSS_BCSM10 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_CSS_BCSM10 INTO WA_CSS_BCSM10.


*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 ISOLA, internal->external for field SPRSL
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_CSS_BCSM10-SPRSL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CSS_BCSM10-SPRSL.
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_CSS_BCSM10_STR, 
CSINSTA TYPE STRING,
MNUMM TYPE STRING,
MYEAR TYPE STRING,
SERVICE TYPE STRING,
SERVICETYP TYPE STRING,
KNDID1 TYPE STRING,
KNDID2 TYPE STRING,
INSTID TYPE STRING,
SERVREL TYPE STRING,
AKTION TYPE STRING,
AKTIONINST TYPE STRING,
REGISTADR TYPE STRING,
REGISTINST TYPE STRING,
EINGA TYPE STRING,
ERFNAINSTA TYPE STRING,
ERFNA TYPE STRING,
ERFTSTMP TYPE STRING,
ERFTZR TYPE STRING,
AENAMINSTA TYPE STRING,
AENAM TYPE STRING,
AETSTMP TYPE STRING,
AETZR TYPE STRING,
CUSHOTLI TYPE STRING,
REGHOTLI TYPE STRING,
ACTHOTLI TYPE STRING,
PRIOA TYPE STRING,
INTPR TYPE STRING,
KTEXT TYPE STRING,
SPRSL TYPE STRING,
STATUS TYPE STRING,
ZERLTSTMP TYPE STRING,
ZERLTZR TYPE STRING,
BCSYSTEM TYPE STRING,
SERVMANDT TYPE STRING,
THEMKINT TYPE STRING,
THEMKEXT TYPE STRING,
TEXT_LOG TYPE STRING,
ATTR01 TYPE STRING,
ATTR02 TYPE STRING,
ATTR03 TYPE STRING,
ATTR04 TYPE STRING,
ATTR05 TYPE STRING,
ATTR06 TYPE STRING,
ATTR07 TYPE STRING,
ATTR08 TYPE STRING,
ATTR09 TYPE STRING,
ATTR10 TYPE STRING,
ATTR11 TYPE STRING,
ATTR12 TYPE STRING,
ATTR13 TYPE STRING,
ATTR14 TYPE STRING,
ATTR15 TYPE STRING,
ATTR16 TYPE STRING,
ATTR17 TYPE STRING,
ATTR18 TYPE STRING,
ATTR19 TYPE STRING,
ATTR20 TYPE STRING,
ATTR21 TYPE STRING,
ATTR22 TYPE STRING,
ATTR23 TYPE STRING,
ATTR24 TYPE STRING,
ATTR25 TYPE STRING,
ATTR26 TYPE STRING,
ATTR27 TYPE STRING,
ATTR28 TYPE STRING,
ATTR29 TYPE STRING,
ATTR30 TYPE STRING,
ATTR31 TYPE STRING,
ATTR32 TYPE STRING,
ATTR33 TYPE STRING,
ATTR34 TYPE STRING,
ATTR35 TYPE STRING,
ATTR36 TYPE STRING,
ATTR37 TYPE STRING,
ATTR38 TYPE STRING,
ATTR39 TYPE STRING,
ATTR40 TYPE STRING,
ATTR41 TYPE STRING,
ATTR42 TYPE STRING,
ATTR43 TYPE STRING,
ATTR44 TYPE STRING,
ATTR45 TYPE STRING,
ATTR46 TYPE STRING,
ATTR47 TYPE STRING,
ATTR48 TYPE STRING,
ATTR49 TYPE STRING,
ATTR60 TYPE STRING,
ATTR61 TYPE STRING,
ATTR62 TYPE STRING,
ATTR63 TYPE STRING,
ATTR64 TYPE STRING,
ATTR65 TYPE STRING,
ATTR66 TYPE STRING,
ATTR67 TYPE STRING,
ATTR68 TYPE STRING,
ATTR69 TYPE STRING,
ATTR70 TYPE STRING,
ATTR75 TYPE STRING,
ATTR76 TYPE STRING,
ATTR77 TYPE STRING,
ATTR78 TYPE STRING,
ATTR79 TYPE STRING,
ATTR80 TYPE STRING,
ATTR81 TYPE STRING,
ATTR82 TYPE STRING,
ATTR83 TYPE STRING,
ATTR84 TYPE STRING,
ATTR90 TYPE STRING,
ATTR91 TYPE STRING,
FLAG01 TYPE STRING,
FLAG02 TYPE STRING,
FLAG03 TYPE STRING,
FLAG04 TYPE STRING,
FLAG05 TYPE STRING,
FLAG06 TYPE STRING,
FLAG07 TYPE STRING,
FLAG08 TYPE STRING,
FLAG09 TYPE STRING,
FLAG10 TYPE STRING,
READ_INSTA TYPE STRING,
READ_ADRNR TYPE STRING,
CNT_NOTES TYPE STRING,
MASTERINST TYPE STRING,
AEORG TYPE STRING,
AEKOSTL TYPE STRING,
AKTIONKOST TYPE STRING,
RUESTZEIT TYPE STRING,
RPLTSTMP TYPE STRING,
CLOSETSTMP TYPE STRING,
POINTER TYPE STRING,
CNT_REFER TYPE STRING,
CNT_PART TYPE STRING,
CNT_ATTCH TYPE STRING,
CNT_001 TYPE STRING,
CNT_002 TYPE STRING,
CNT_003 TYPE STRING,
CNT_004 TYPE STRING,
CNT_005 TYPE STRING,
INIT_CACT TYPE STRING,
INIT_CACTI TYPE STRING,
SERVRELL TYPE STRING,
BCSYSTEML TYPE STRING,
SERVMANDTL TYPE STRING,
ATTR11L TYPE STRING,
ATTR12L TYPE STRING,
ATTR13L TYPE STRING,
ATTR14L TYPE STRING,
ATTR17L TYPE STRING,
ATTR18L TYPE STRING,
ATTR19L TYPE STRING,
ATTR20L TYPE STRING,
ATTR21L TYPE STRING,
ATTR22L TYPE STRING,
ATTR23L TYPE STRING,
ATTR28L TYPE STRING,
ATTR29L TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CSS_BCSM10_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_CSS_BCSM10_STR-CSINSTA sy-vline 
WA_CSS_BCSM10_STR-MNUMM sy-vline 
WA_CSS_BCSM10_STR-MYEAR sy-vline 
WA_CSS_BCSM10_STR-SERVICE sy-vline 
WA_CSS_BCSM10_STR-SERVICETYP sy-vline 
WA_CSS_BCSM10_STR-KNDID1 sy-vline 
WA_CSS_BCSM10_STR-KNDID2 sy-vline 
WA_CSS_BCSM10_STR-INSTID sy-vline 
WA_CSS_BCSM10_STR-SERVREL sy-vline 
WA_CSS_BCSM10_STR-AKTION sy-vline 
WA_CSS_BCSM10_STR-AKTIONINST sy-vline 
WA_CSS_BCSM10_STR-REGISTADR sy-vline 
WA_CSS_BCSM10_STR-REGISTINST sy-vline 
WA_CSS_BCSM10_STR-EINGA sy-vline 
WA_CSS_BCSM10_STR-ERFNAINSTA sy-vline 
WA_CSS_BCSM10_STR-ERFNA sy-vline 
WA_CSS_BCSM10_STR-ERFTSTMP sy-vline 
WA_CSS_BCSM10_STR-ERFTZR sy-vline 
WA_CSS_BCSM10_STR-AENAMINSTA sy-vline 
WA_CSS_BCSM10_STR-AENAM sy-vline 
WA_CSS_BCSM10_STR-AETSTMP sy-vline 
WA_CSS_BCSM10_STR-AETZR sy-vline 
WA_CSS_BCSM10_STR-CUSHOTLI sy-vline 
WA_CSS_BCSM10_STR-REGHOTLI sy-vline 
WA_CSS_BCSM10_STR-ACTHOTLI sy-vline 
WA_CSS_BCSM10_STR-PRIOA sy-vline 
WA_CSS_BCSM10_STR-INTPR sy-vline 
WA_CSS_BCSM10_STR-KTEXT sy-vline 
WA_CSS_BCSM10_STR-SPRSL sy-vline 
WA_CSS_BCSM10_STR-STATUS sy-vline 
WA_CSS_BCSM10_STR-ZERLTSTMP sy-vline 
WA_CSS_BCSM10_STR-ZERLTZR sy-vline 
WA_CSS_BCSM10_STR-BCSYSTEM sy-vline 
WA_CSS_BCSM10_STR-SERVMANDT sy-vline 
WA_CSS_BCSM10_STR-THEMKINT sy-vline 
WA_CSS_BCSM10_STR-THEMKEXT sy-vline 
WA_CSS_BCSM10_STR-TEXT_LOG sy-vline 
WA_CSS_BCSM10_STR-ATTR01 sy-vline 
WA_CSS_BCSM10_STR-ATTR02 sy-vline 
WA_CSS_BCSM10_STR-ATTR03 sy-vline 
WA_CSS_BCSM10_STR-ATTR04 sy-vline 
WA_CSS_BCSM10_STR-ATTR05 sy-vline 
WA_CSS_BCSM10_STR-ATTR06 sy-vline 
WA_CSS_BCSM10_STR-ATTR07 sy-vline 
WA_CSS_BCSM10_STR-ATTR08 sy-vline 
WA_CSS_BCSM10_STR-ATTR09 sy-vline 
WA_CSS_BCSM10_STR-ATTR10 sy-vline 
WA_CSS_BCSM10_STR-ATTR11 sy-vline 
WA_CSS_BCSM10_STR-ATTR12 sy-vline 
WA_CSS_BCSM10_STR-ATTR13 sy-vline 
WA_CSS_BCSM10_STR-ATTR14 sy-vline 
WA_CSS_BCSM10_STR-ATTR15 sy-vline 
WA_CSS_BCSM10_STR-ATTR16 sy-vline 
WA_CSS_BCSM10_STR-ATTR17 sy-vline 
WA_CSS_BCSM10_STR-ATTR18 sy-vline 
WA_CSS_BCSM10_STR-ATTR19 sy-vline 
WA_CSS_BCSM10_STR-ATTR20 sy-vline 
WA_CSS_BCSM10_STR-ATTR21 sy-vline 
WA_CSS_BCSM10_STR-ATTR22 sy-vline 
WA_CSS_BCSM10_STR-ATTR23 sy-vline 
WA_CSS_BCSM10_STR-ATTR24 sy-vline 
WA_CSS_BCSM10_STR-ATTR25 sy-vline 
WA_CSS_BCSM10_STR-ATTR26 sy-vline 
WA_CSS_BCSM10_STR-ATTR27 sy-vline 
WA_CSS_BCSM10_STR-ATTR28 sy-vline 
WA_CSS_BCSM10_STR-ATTR29 sy-vline 
WA_CSS_BCSM10_STR-ATTR30 sy-vline 
WA_CSS_BCSM10_STR-ATTR31 sy-vline 
WA_CSS_BCSM10_STR-ATTR32 sy-vline 
WA_CSS_BCSM10_STR-ATTR33 sy-vline 
WA_CSS_BCSM10_STR-ATTR34 sy-vline 
WA_CSS_BCSM10_STR-ATTR35 sy-vline 
WA_CSS_BCSM10_STR-ATTR36 sy-vline 
WA_CSS_BCSM10_STR-ATTR37 sy-vline 
WA_CSS_BCSM10_STR-ATTR38 sy-vline 
WA_CSS_BCSM10_STR-ATTR39 sy-vline 
WA_CSS_BCSM10_STR-ATTR40 sy-vline 
WA_CSS_BCSM10_STR-ATTR41 sy-vline 
WA_CSS_BCSM10_STR-ATTR42 sy-vline 
WA_CSS_BCSM10_STR-ATTR43 sy-vline 
WA_CSS_BCSM10_STR-ATTR44 sy-vline 
WA_CSS_BCSM10_STR-ATTR45 sy-vline 
WA_CSS_BCSM10_STR-ATTR46 sy-vline 
WA_CSS_BCSM10_STR-ATTR47 sy-vline 
WA_CSS_BCSM10_STR-ATTR48 sy-vline 
WA_CSS_BCSM10_STR-ATTR49 sy-vline 
WA_CSS_BCSM10_STR-ATTR60 sy-vline 
WA_CSS_BCSM10_STR-ATTR61 sy-vline 
WA_CSS_BCSM10_STR-ATTR62 sy-vline 
WA_CSS_BCSM10_STR-ATTR63 sy-vline 
WA_CSS_BCSM10_STR-ATTR64 sy-vline 
WA_CSS_BCSM10_STR-ATTR65 sy-vline 
WA_CSS_BCSM10_STR-ATTR66 sy-vline 
WA_CSS_BCSM10_STR-ATTR67 sy-vline 
WA_CSS_BCSM10_STR-ATTR68 sy-vline 
WA_CSS_BCSM10_STR-ATTR69 sy-vline 
WA_CSS_BCSM10_STR-ATTR70 sy-vline 
WA_CSS_BCSM10_STR-ATTR75 sy-vline 
WA_CSS_BCSM10_STR-ATTR76 sy-vline 
WA_CSS_BCSM10_STR-ATTR77 sy-vline 
WA_CSS_BCSM10_STR-ATTR78 sy-vline 
WA_CSS_BCSM10_STR-ATTR79 sy-vline 
WA_CSS_BCSM10_STR-ATTR80 sy-vline 
WA_CSS_BCSM10_STR-ATTR81 sy-vline 
WA_CSS_BCSM10_STR-ATTR82 sy-vline 
WA_CSS_BCSM10_STR-ATTR83 sy-vline 
WA_CSS_BCSM10_STR-ATTR84 sy-vline 
WA_CSS_BCSM10_STR-ATTR90 sy-vline 
WA_CSS_BCSM10_STR-ATTR91 sy-vline 
WA_CSS_BCSM10_STR-FLAG01 sy-vline 
WA_CSS_BCSM10_STR-FLAG02 sy-vline 
WA_CSS_BCSM10_STR-FLAG03 sy-vline 
WA_CSS_BCSM10_STR-FLAG04 sy-vline 
WA_CSS_BCSM10_STR-FLAG05 sy-vline 
WA_CSS_BCSM10_STR-FLAG06 sy-vline 
WA_CSS_BCSM10_STR-FLAG07 sy-vline 
WA_CSS_BCSM10_STR-FLAG08 sy-vline 
WA_CSS_BCSM10_STR-FLAG09 sy-vline 
WA_CSS_BCSM10_STR-FLAG10 sy-vline 
WA_CSS_BCSM10_STR-READ_INSTA sy-vline 
WA_CSS_BCSM10_STR-READ_ADRNR sy-vline 
WA_CSS_BCSM10_STR-CNT_NOTES sy-vline 
WA_CSS_BCSM10_STR-MASTERINST sy-vline 
WA_CSS_BCSM10_STR-AEORG sy-vline 
WA_CSS_BCSM10_STR-AEKOSTL sy-vline 
WA_CSS_BCSM10_STR-AKTIONKOST sy-vline 
WA_CSS_BCSM10_STR-RUESTZEIT sy-vline 
WA_CSS_BCSM10_STR-RPLTSTMP sy-vline 
WA_CSS_BCSM10_STR-CLOSETSTMP sy-vline 
WA_CSS_BCSM10_STR-POINTER sy-vline 
WA_CSS_BCSM10_STR-CNT_REFER sy-vline 
WA_CSS_BCSM10_STR-CNT_PART sy-vline 
WA_CSS_BCSM10_STR-CNT_ATTCH sy-vline 
WA_CSS_BCSM10_STR-CNT_001 sy-vline 
WA_CSS_BCSM10_STR-CNT_002 sy-vline 
WA_CSS_BCSM10_STR-CNT_003 sy-vline 
WA_CSS_BCSM10_STR-CNT_004 sy-vline 
WA_CSS_BCSM10_STR-CNT_005 sy-vline 
WA_CSS_BCSM10_STR-INIT_CACT sy-vline 
WA_CSS_BCSM10_STR-INIT_CACTI sy-vline 
WA_CSS_BCSM10_STR-SERVRELL sy-vline 
WA_CSS_BCSM10_STR-BCSYSTEML sy-vline 
WA_CSS_BCSM10_STR-SERVMANDTL sy-vline 
WA_CSS_BCSM10_STR-ATTR11L sy-vline 
WA_CSS_BCSM10_STR-ATTR12L sy-vline 
WA_CSS_BCSM10_STR-ATTR13L sy-vline 
WA_CSS_BCSM10_STR-ATTR14L sy-vline 
WA_CSS_BCSM10_STR-ATTR17L sy-vline 
WA_CSS_BCSM10_STR-ATTR18L sy-vline 
WA_CSS_BCSM10_STR-ATTR19L sy-vline 
WA_CSS_BCSM10_STR-ATTR20L sy-vline 
WA_CSS_BCSM10_STR-ATTR21L sy-vline 
WA_CSS_BCSM10_STR-ATTR22L sy-vline 
WA_CSS_BCSM10_STR-ATTR23L sy-vline 
WA_CSS_BCSM10_STR-ATTR28L sy-vline 
WA_CSS_BCSM10_STR-ATTR29L sy-vline      INTO ld_text SEPARATED BY SPACE.

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