ABAP Select data from SAP table DDDDLNUM_DUMMY 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 DDDDLNUM_DUMMY 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 DDDDLNUM_DUMMY. 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 DDDDLNUM_DUMMY 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_DDDDLNUM_DUMMY TYPE STANDARD TABLE OF DDDDLNUM_DUMMY,
      WA_DDDDLNUM_DUMMY TYPE DDDDLNUM_DUMMY,
      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: <DDDDLNUM_DUMMY> TYPE DDDDLNUM_DUMMY.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM DDDDLNUM_DUMMY
*  INTO TABLE @DATA(IT_DDDDLNUM_DUMMY2).
*--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_DDDDLNUM_DUMMY INDEX 1 INTO DATA(WA_DDDDLNUM_DUMMY2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<DDDDLNUM_DUMMY>-CCLNT = 1.
<DDDDLNUM_DUMMY>-KCHAR = 1.
<DDDDLNUM_DUMMY>-CFLTP = 1.
<DDDDLNUM_DUMMY>-CINT1 = 1.
<DDDDLNUM_DUMMY>-CINT2 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_DDDDLNUM_DUMMY-CINT4, sy-vline,
  WA_DDDDLNUM_DUMMY-CINT8, sy-vline,
  WA_DDDDLNUM_DUMMY-CSTRING, sy-vline,
  WA_DDDDLNUM_DUMMY-CCHAR1, sy-vline,
  WA_DDDDLNUM_DUMMY-CCHAR2, sy-vline,
  WA_DDDDLNUM_DUMMY-CCHAR3, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_DDDDLNUM_DUMMY 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_DDDDLNUM_DUMMY 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_DDDDLNUM_DUMMY INTO WA_DDDDLNUM_DUMMY.


*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.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_DDDDLNUM_DUMMY_STR, 
CCLNT TYPE STRING,
KCHAR TYPE STRING,
CFLTP TYPE STRING,
CINT1 TYPE STRING,
CINT2 TYPE STRING,
CINT4 TYPE STRING,
CINT8 TYPE STRING,
CSTRING TYPE STRING,
CCHAR1 TYPE STRING,
CCHAR2 TYPE STRING,
CCHAR3 TYPE STRING,
CCHAR4 TYPE STRING,
CCHAR5 TYPE STRING,
CCHAR6 TYPE STRING,
CCHAR8 TYPE STRING,
CCHAR10 TYPE STRING,
CCHAR30 TYPE STRING,
CCHAR50 TYPE STRING,
CCHAR100 TYPE STRING,
CCHAR250 TYPE STRING,
CCHAR1333 TYPE STRING,
CNUMC TYPE STRING,
CNUMC_1 TYPE STRING,
CNUMC_2 TYPE STRING,
CNUMC_3 TYPE STRING,
CNUMC_4 TYPE STRING,
CNUMC_5 TYPE STRING,
CNUMC_6 TYPE STRING,
CNUMC_7 TYPE STRING,
CNUMC_8 TYPE STRING,
CNUMC_9 TYPE STRING,
CNUMC_10 TYPE STRING,
CNUMC_11 TYPE STRING,
CNUMC_12 TYPE STRING,
CNUMC_13 TYPE STRING,
CNUMC_14 TYPE STRING,
CNUMC_15 TYPE STRING,
CNUMC_16 TYPE STRING,
CNUMC_17 TYPE STRING,
CNUMC_18 TYPE STRING,
CNUMC_19 TYPE STRING,
CNUMC_20 TYPE STRING,
CNUMC_21 TYPE STRING,
CNUMC_24 TYPE STRING,
CNUMC_30 TYPE STRING,
CNUMC_35 TYPE STRING,
CNUMC_40 TYPE STRING,
CNUMC_45 TYPE STRING,
CNUMC_50 TYPE STRING,
CNUMC_60 TYPE STRING,
CNUMC_70 TYPE STRING,
CNUMC_75 TYPE STRING,
CNUMC_100 TYPE STRING,
CNUMC_150 TYPE STRING,
CNUMC_200 TYPE STRING,
CNUMC_250 TYPE STRING,
CDEC5_0 TYPE STRING,
CDEC5_2 TYPE STRING,
CDEC11_2 TYPE STRING,
CDEC13_2 TYPE STRING,
CDEC15_0 TYPE STRING,
CDEC15_2 TYPE STRING,
CDEC15_5 TYPE STRING,
CDEC15_7 TYPE STRING,
CDEC21_0 TYPE STRING,
CDEC21_2 TYPE STRING,
CDEC21_5 TYPE STRING,
CDEC21_7 TYPE STRING,
CDEC23_2 TYPE STRING,
CDEC31_2 TYPE STRING,
CDEC31_0 TYPE STRING,
CDEC31_7 TYPE STRING,
CDEC31_14 TYPE STRING,
CCURR9_2 TYPE STRING,
CCURR11_2 TYPE STRING,
CCURR13_2 TYPE STRING,
CCURR15_2 TYPE STRING,
CCURR15_5 TYPE STRING,
CCURR15_7 TYPE STRING,
CCURR17_2 TYPE STRING,
CCURR21_2 TYPE STRING,
CCURR21_5 TYPE STRING,
CCURR25_2 TYPE STRING,
CCURR25_9 TYPE STRING,
CCURR31_2 TYPE STRING,
CCURR31_14 TYPE STRING,
CCUKY TYPE STRING,
CQUAN5_0 TYPE STRING,
CQUAN5_1 TYPE STRING,
CQUAN7_1 TYPE STRING,
CQUAN15_0 TYPE STRING,
CQUAN15_1 TYPE STRING,
CQUAN31_1 TYPE STRING,
CQUAN9_3 TYPE STRING,
CQUAN13_0 TYPE STRING,
CQUAN13_3 TYPE STRING,
CQUAN15_3 TYPE STRING,
CQUAN31_3 TYPE STRING,
CQUAN15_5 TYPE STRING,
CQUAN15_7 TYPE STRING,
CQUAN31_7 TYPE STRING,
CQUAN11_2 TYPE STRING,
CQUAN17_2 TYPE STRING,
CQUAN21_2 TYPE STRING,
CQUAN21_5 TYPE STRING,
CQUAN31_5 TYPE STRING,
CQUAN25_2 TYPE STRING,
CQUAN25_9 TYPE STRING,
CQUAN31_0 TYPE STRING,
CQUAN31_2 TYPE STRING,
CQUAN31_14 TYPE STRING,
CUNIT TYPE STRING,
CDATS TYPE STRING,
CTIMS TYPE STRING,
CLANG TYPE STRING,
C_RAW2 TYPE STRING,
C_RAW8 TYPE STRING,
C_RAW16 TYPE STRING,
C_RAW255 TYPE STRING,
CACCP TYPE STRING,END OF T_EKKO_STR.
DATA: WA_DDDDLNUM_DUMMY_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_DDDDLNUM_DUMMY_STR-CCLNT sy-vline 
WA_DDDDLNUM_DUMMY_STR-KCHAR sy-vline 
WA_DDDDLNUM_DUMMY_STR-CFLTP sy-vline 
WA_DDDDLNUM_DUMMY_STR-CINT1 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CINT2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CINT4 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CINT8 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CSTRING sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR1 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR3 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR4 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR5 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR6 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR8 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR10 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR30 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR50 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR100 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR250 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCHAR1333 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_1 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_3 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_4 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_5 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_6 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_7 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_8 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_9 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_10 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_11 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_12 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_13 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_14 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_15 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_16 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_17 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_18 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_19 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_20 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_21 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_24 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_30 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_35 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_40 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_45 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_50 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_60 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_70 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_75 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_100 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_150 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_200 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CNUMC_250 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC5_0 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC5_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC11_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC13_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC15_0 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC15_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC15_5 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC15_7 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC21_0 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC21_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC21_5 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC21_7 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC23_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC31_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC31_0 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC31_7 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDEC31_14 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR9_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR11_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR13_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR15_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR15_5 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR15_7 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR17_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR21_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR21_5 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR25_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR25_9 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR31_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCURR31_14 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CCUKY sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN5_0 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN5_1 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN7_1 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN15_0 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN15_1 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN31_1 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN9_3 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN13_0 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN13_3 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN15_3 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN31_3 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN15_5 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN15_7 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN31_7 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN11_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN17_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN21_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN21_5 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN31_5 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN25_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN25_9 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN31_0 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN31_2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CQUAN31_14 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CUNIT sy-vline 
WA_DDDDLNUM_DUMMY_STR-CDATS sy-vline 
WA_DDDDLNUM_DUMMY_STR-CTIMS sy-vline 
WA_DDDDLNUM_DUMMY_STR-CLANG sy-vline 
WA_DDDDLNUM_DUMMY_STR-C_RAW2 sy-vline 
WA_DDDDLNUM_DUMMY_STR-C_RAW8 sy-vline 
WA_DDDDLNUM_DUMMY_STR-C_RAW16 sy-vline 
WA_DDDDLNUM_DUMMY_STR-C_RAW255 sy-vline 
WA_DDDDLNUM_DUMMY_STR-CACCP sy-vline      INTO ld_text SEPARATED BY SPACE.

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