ABAP Select data from SAP table DDDDLNUMTYPES 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 DDDDLNUMTYPES 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 DDDDLNUMTYPES. 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 DDDDLNUMTYPES 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_DDDDLNUMTYPES TYPE STANDARD TABLE OF DDDDLNUMTYPES,
WA_DDDDLNUMTYPES TYPE DDDDLNUMTYPES,
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: <DDDDLNUMTYPES> TYPE DDDDLNUMTYPES.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_DDDDLNUMTYPES.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM DDDDLNUMTYPES
INTO TABLE IT_DDDDLNUMTYPES.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM DDDDLNUMTYPES
* INTO TABLE @DATA(IT_DDDDLNUMTYPES2).
*--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_DDDDLNUMTYPES INDEX 1 INTO DATA(WA_DDDDLNUMTYPES2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_DDDDLNUMTYPES ASSIGNING <DDDDLNUMTYPES>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<DDDDLNUMTYPES>-CCLNT = 1.
<DDDDLNUMTYPES>-KCHAR = 1.
<DDDDLNUMTYPES>-CFLTP = 1.
<DDDDLNUMTYPES>-CINT1 = 1.
<DDDDLNUMTYPES>-CINT2 = 1.
ENDLOOP. LOOP AT IT_DDDDLNUMTYPES INTO WA_DDDDLNUMTYPES. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_DDDDLNUMTYPES-CINT4, sy-vline,
WA_DDDDLNUMTYPES-CINT8, sy-vline,
WA_DDDDLNUMTYPES-CSTRING, sy-vline,
WA_DDDDLNUMTYPES-CCHAR1, sy-vline,
WA_DDDDLNUMTYPES-CCHAR2, sy-vline,
WA_DDDDLNUMTYPES-CCHAR3, sy-vline.
ENDLOOP. *Add any further fields from structure WA_DDDDLNUMTYPES 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_DDDDLNUMTYPES 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_DDDDLNUMTYPES INTO WA_DDDDLNUMTYPES. *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_DDDDLNUMTYPES_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,
CD34N TYPE STRING,
CD16N TYPE STRING,END OF T_EKKO_STR. DATA: WA_DDDDLNUMTYPES_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_DDDDLNUMTYPES_STR-CCLNT sy-vline
WA_DDDDLNUMTYPES_STR-KCHAR sy-vline
WA_DDDDLNUMTYPES_STR-CFLTP sy-vline
WA_DDDDLNUMTYPES_STR-CINT1 sy-vline
WA_DDDDLNUMTYPES_STR-CINT2 sy-vline
WA_DDDDLNUMTYPES_STR-CINT4 sy-vline
WA_DDDDLNUMTYPES_STR-CINT8 sy-vline
WA_DDDDLNUMTYPES_STR-CSTRING sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR1 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR2 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR3 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR4 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR5 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR6 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR8 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR10 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR30 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR50 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR100 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR250 sy-vline
WA_DDDDLNUMTYPES_STR-CCHAR1333 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_1 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_2 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_3 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_4 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_5 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_6 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_7 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_8 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_9 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_10 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_11 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_12 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_13 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_14 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_15 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_16 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_17 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_18 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_19 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_20 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_21 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_24 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_30 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_35 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_40 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_45 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_50 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_60 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_70 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_75 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_100 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_150 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_200 sy-vline
WA_DDDDLNUMTYPES_STR-CNUMC_250 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC5_0 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC5_2 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC11_2 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC13_2 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC15_0 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC15_2 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC15_5 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC15_7 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC21_0 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC21_2 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC21_5 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC21_7 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC23_2 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC31_2 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC31_0 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC31_7 sy-vline
WA_DDDDLNUMTYPES_STR-CDEC31_14 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR9_2 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR11_2 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR13_2 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR15_2 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR15_5 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR15_7 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR17_2 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR21_2 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR21_5 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR25_2 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR25_9 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR31_2 sy-vline
WA_DDDDLNUMTYPES_STR-CCURR31_14 sy-vline
WA_DDDDLNUMTYPES_STR-CCUKY sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN5_0 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN5_1 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN7_1 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN15_0 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN15_1 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN31_1 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN9_3 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN13_0 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN13_3 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN15_3 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN31_3 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN15_5 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN15_7 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN31_7 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN11_2 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN17_2 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN21_2 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN21_5 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN31_5 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN25_2 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN25_9 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN31_0 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN31_2 sy-vline
WA_DDDDLNUMTYPES_STR-CQUAN31_14 sy-vline
WA_DDDDLNUMTYPES_STR-CUNIT sy-vline
WA_DDDDLNUMTYPES_STR-CDATS sy-vline
WA_DDDDLNUMTYPES_STR-CTIMS sy-vline
WA_DDDDLNUMTYPES_STR-CLANG sy-vline
WA_DDDDLNUMTYPES_STR-C_RAW2 sy-vline
WA_DDDDLNUMTYPES_STR-C_RAW8 sy-vline
WA_DDDDLNUMTYPES_STR-C_RAW16 sy-vline
WA_DDDDLNUMTYPES_STR-C_RAW255 sy-vline
WA_DDDDLNUMTYPES_STR-CACCP sy-vline
WA_DDDDLNUMTYPES_STR-CD34N sy-vline
WA_DDDDLNUMTYPES_STR-CD16N sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.