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

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

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

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


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
</CEERE/DN>-TYPNEM = 1.
</CEERE/DN>-DRNEM = 1.
</CEERE/DN>-KODFU = 1.
</CEERE/DN>-NAZEVFU = 1.
</CEERE/DN>-KODOBCE = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/CEERE/DN-NAZEVOBCE, sy-vline,
  WA_/CEERE/DN-KODCOBCE, sy-vline,
  WA_/CEERE/DN-GEMARK, sy-vline,
  WA_/CEERE/DN-NAZEVKU, sy-vline,
  WA_/CEERE/DN-NARPARK, sy-vline,
  WA_/CEERE/DN-PARCKMEN, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/CEERE/DN 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_/CEERE/DN 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_/CEERE/DN INTO WA_/CEERE/DN.


*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 KODFU
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_/CEERE/DN-KODFU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CEERE/DN-KODFU.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field ROKOSVOD
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_/CEERE/DN-ROKOSVOD
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CEERE/DN-ROKOSVOD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field ROKOSVDO
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_/CEERE/DN-ROKOSVDO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CEERE/DN-ROKOSVDO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field ROKDOKONC
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_/CEERE/DN-ROKDOKONC
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CEERE/DN-ROKDOKONC.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit GJAHR, internal->external for field YEAGREFR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_/CEERE/DN-YEAGREFR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CEERE/DN-YEAGREFR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field YEINDEFR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_/CEERE/DN-YEINDEFR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CEERE/DN-YEINDEFR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field YEAGRETO
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_/CEERE/DN-YEAGRETO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CEERE/DN-YEAGRETO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field YEINDETO
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_/CEERE/DN-YEINDETO
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/CEERE/DN-YEINDETO.
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_/CEERE/DN_STR, 
TYPNEM TYPE STRING,
DRNEM TYPE STRING,
KODFU TYPE STRING,
NAZEVFU TYPE STRING,
KODOBCE TYPE STRING,
NAZEVOBCE TYPE STRING,
KODCOBCE TYPE STRING,
GEMARK TYPE STRING,
NAZEVKU TYPE STRING,
NARPARK TYPE STRING,
PARCKMEN TYPE STRING,
PARCPOD TYPE STRING,
PARCDIL TYPE STRING,
VYMERA TYPE STRING,
PRAVZTAH TYPE STRING,
SV_CITATEL TYPE STRING,
SV_JMENOVATEL TYPE STRING,
VYMERAOSV TYPE STRING,
VYMERAPOD TYPE STRING,
ZASTPL TYPE STRING,
PLOCHANP TYPE STRING,
KODOSVOB TYPE STRING,
ROKOSVOD TYPE STRING,
ROKOSVDO TYPE STRING,
CENASTODH TYPE STRING,
CENAODHAD TYPE STRING,
POCPATER TYPE STRING,
CISLOP TYPE STRING,
ROKDOKONC TYPE STRING,
POPIS TYPE STRING,
CIZIPOZ TYPE STRING,
DRUHSTA TYPE STRING,
BYTKAT TYPE STRING,
SVISKONST TYPE STRING,
JEDNKMEN TYPE STRING,
JEDNBYT TYPE STRING,
PLNOSVOB TYPE STRING,
XDAN TYPE STRING,
ANLN1 TYPE STRING,
ANLN2 TYPE STRING,
KOSTL TYPE STRING,
GSBER TYPE STRING,
SOLIDAGR TYPE STRING,
SOLIDIND TYPE STRING,
SOLAAGRE TYPE STRING,
SOLAINDE TYPE STRING,
YEAGREFR TYPE STRING,
YEINDEFR TYPE STRING,
YEAGRETO TYPE STRING,
YEINDETO TYPE STRING,
CODEAGRE TYPE STRING,
CODEINDE TYPE STRING,
RVZ_PODNIK TYPE STRING,
VYM_PODNIKPO TYPE STRING,
KC_ZVDA115PO TYPE STRING,
KC_DANOSV3PO TYPE STRING,
K_K102PO TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/CEERE/DN_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_/CEERE/DN_STR-TYPNEM sy-vline 
WA_/CEERE/DN_STR-DRNEM sy-vline 
WA_/CEERE/DN_STR-KODFU sy-vline 
WA_/CEERE/DN_STR-NAZEVFU sy-vline 
WA_/CEERE/DN_STR-KODOBCE sy-vline 
WA_/CEERE/DN_STR-NAZEVOBCE sy-vline 
WA_/CEERE/DN_STR-KODCOBCE sy-vline 
WA_/CEERE/DN_STR-GEMARK sy-vline 
WA_/CEERE/DN_STR-NAZEVKU sy-vline 
WA_/CEERE/DN_STR-NARPARK sy-vline 
WA_/CEERE/DN_STR-PARCKMEN sy-vline 
WA_/CEERE/DN_STR-PARCPOD sy-vline 
WA_/CEERE/DN_STR-PARCDIL sy-vline 
WA_/CEERE/DN_STR-VYMERA sy-vline 
WA_/CEERE/DN_STR-PRAVZTAH sy-vline 
WA_/CEERE/DN_STR-SV_CITATEL sy-vline 
WA_/CEERE/DN_STR-SV_JMENOVATEL sy-vline 
WA_/CEERE/DN_STR-VYMERAOSV sy-vline 
WA_/CEERE/DN_STR-VYMERAPOD sy-vline 
WA_/CEERE/DN_STR-ZASTPL sy-vline 
WA_/CEERE/DN_STR-PLOCHANP sy-vline 
WA_/CEERE/DN_STR-KODOSVOB sy-vline 
WA_/CEERE/DN_STR-ROKOSVOD sy-vline 
WA_/CEERE/DN_STR-ROKOSVDO sy-vline 
WA_/CEERE/DN_STR-CENASTODH sy-vline 
WA_/CEERE/DN_STR-CENAODHAD sy-vline 
WA_/CEERE/DN_STR-POCPATER sy-vline 
WA_/CEERE/DN_STR-CISLOP sy-vline 
WA_/CEERE/DN_STR-ROKDOKONC sy-vline 
WA_/CEERE/DN_STR-POPIS sy-vline 
WA_/CEERE/DN_STR-CIZIPOZ sy-vline 
WA_/CEERE/DN_STR-DRUHSTA sy-vline 
WA_/CEERE/DN_STR-BYTKAT sy-vline 
WA_/CEERE/DN_STR-SVISKONST sy-vline 
WA_/CEERE/DN_STR-JEDNKMEN sy-vline 
WA_/CEERE/DN_STR-JEDNBYT sy-vline 
WA_/CEERE/DN_STR-PLNOSVOB sy-vline 
WA_/CEERE/DN_STR-XDAN sy-vline 
WA_/CEERE/DN_STR-ANLN1 sy-vline 
WA_/CEERE/DN_STR-ANLN2 sy-vline 
WA_/CEERE/DN_STR-KOSTL sy-vline 
WA_/CEERE/DN_STR-GSBER sy-vline 
WA_/CEERE/DN_STR-SOLIDAGR sy-vline 
WA_/CEERE/DN_STR-SOLIDIND sy-vline 
WA_/CEERE/DN_STR-SOLAAGRE sy-vline 
WA_/CEERE/DN_STR-SOLAINDE sy-vline 
WA_/CEERE/DN_STR-YEAGREFR sy-vline 
WA_/CEERE/DN_STR-YEINDEFR sy-vline 
WA_/CEERE/DN_STR-YEAGRETO sy-vline 
WA_/CEERE/DN_STR-YEINDETO sy-vline 
WA_/CEERE/DN_STR-CODEAGRE sy-vline 
WA_/CEERE/DN_STR-CODEINDE sy-vline 
WA_/CEERE/DN_STR-RVZ_PODNIK sy-vline 
WA_/CEERE/DN_STR-VYM_PODNIKPO sy-vline 
WA_/CEERE/DN_STR-KC_ZVDA115PO sy-vline 
WA_/CEERE/DN_STR-KC_DANOSV3PO sy-vline 
WA_/CEERE/DN_STR-K_K102PO sy-vline      INTO ld_text SEPARATED BY SPACE.

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