ABAP Select data from SAP table CCS_AEOI_EXT 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 CCS_AEOI_EXT 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 CCS_AEOI_EXT. 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 CCS_AEOI_EXT 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_CCS_AEOI_EXT TYPE STANDARD TABLE OF CCS_AEOI_EXT,
      WA_CCS_AEOI_EXT TYPE CCS_AEOI_EXT,
      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: <CCS_AEOI_EXT> TYPE CCS_AEOI_EXT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CCS_AEOI_EXT
*  INTO TABLE @DATA(IT_CCS_AEOI_EXT2).
*--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_CCS_AEOI_EXT INDEX 1 INTO DATA(WA_CCS_AEOI_EXT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CCS_AEOI_EXT>-MANDT = 1.
<CCS_AEOI_EXT>-AENNR = 1.
<CCS_AEOI_EXT>-AETYP = 1.
<CCS_AEOI_EXT>-OBJKT = 1.
<CCS_AEOI_EXT>-USOBJ = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CCS_AEOI_EXT-CCVMS, sy-vline,
  WA_CCS_AEOI_EXT-OITXT, sy-vline,
  WA_CCS_AEOI_EXT-LTXSP, sy-vline,
  WA_CCS_AEOI_EXT-AEDAT, sy-vline,
  WA_CCS_AEOI_EXT-AENAM, sy-vline,
  WA_CCS_AEOI_EXT-ANDAT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CCS_AEOI_EXT 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_CCS_AEOI_EXT 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_CCS_AEOI_EXT INTO WA_CCS_AEOI_EXT.


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

*Conversion exit ISOLA, internal->external for field LTXSP
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_CCS_AEOI_EXT-LTXSP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCS_AEOI_EXT-LTXSP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit NUMCV, internal->external for field REVLV
CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT'
  EXPORTING
    input =                      WA_CCS_AEOI_EXT-REVLV
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCS_AEOI_EXT-REVLV.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit CCMAT, internal->external for field MATNR
CALL FUNCTION 'CONVERSION_EXIT_CCMAT_OUTPUT'
  EXPORTING
    input =                      WA_CCS_AEOI_EXT-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCS_AEOI_EXT-MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit CCMAT, internal->external for field K_MATNR
CALL FUNCTION 'CONVERSION_EXIT_CCMAT_OUTPUT'
  EXPORTING
    input =                      WA_CCS_AEOI_EXT-K_MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCS_AEOI_EXT-K_MATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CCMAT, internal->external for field M_MATNR
CALL FUNCTION 'CONVERSION_EXIT_CCMAT_OUTPUT'
  EXPORTING
    input =                      WA_CCS_AEOI_EXT-M_MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCS_AEOI_EXT-M_MATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSP, internal->external for field P_PSPNR
CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT'
  EXPORTING
    input =                      WA_CCS_AEOI_EXT-P_PSPNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCS_AEOI_EXT-P_PSPNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CCMAT, internal->external for field P_MATNR
CALL FUNCTION 'CONVERSION_EXIT_CCMAT_OUTPUT'
  EXPORTING
    input =                      WA_CCS_AEOI_EXT-P_MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCS_AEOI_EXT-P_MATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CCTPL, internal->external for field T_TPLNR
CALL FUNCTION 'CONVERSION_EXIT_CCTPL_OUTPUT'
  EXPORTING
    input =                      WA_CCS_AEOI_EXT-T_TPLNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CCS_AEOI_EXT-T_TPLNR.
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_CCS_AEOI_EXT_STR, 
MANDT TYPE STRING,
AENNR TYPE STRING,
AETYP TYPE STRING,
OBJKT TYPE STRING,
USOBJ TYPE STRING,
CCVMS TYPE STRING,
OITXT TYPE STRING,
LTXSP TYPE STRING,
AEDAT TYPE STRING,
AENAM TYPE STRING,
ANDAT TYPE STRING,
ANNAM TYPE STRING,
OBJDT TYPE STRING,
OBJNM TYPE STRING,
CCLCK TYPE STRING,
AEOST TYPE STRING,
REVLV TYPE STRING,
AEDTZ TYPE STRING,
CCSTO TYPE STRING,
CCOAA TYPE STRING,
CONT1 TYPE STRING,
AEOI_GUID TYPE STRING,
STLAL TYPE STRING,
STA_SY_CUR_KEY TYPE STRING,
STA_SY_CUR_TXT TYPE STRING,
USERNAME TYPE STRING,
STA_DATE TYPE STRING,
STA_TIME TYPE STRING,
DURATION TYPE STRING,
ATTXT TYPE STRING,
ATABR TYPE STRING,
DATUV TYPE STRING,
AEDTN TYPE STRING,
ICON TYPE STRING,
AENOB TYPE STRING,
ALT_ECN_CHANGED TYPE STRING,
MATNR TYPE STRING,
DOKAR TYPE STRING,
DOKNR TYPE STRING,
DOKTL TYPE STRING,
DOKVR TYPE STRING,
PLNTY TYPE STRING,
PLNNR TYPE STRING,
D_DOKAR TYPE STRING,
D_DOKNR TYPE STRING,
D_DOKTL TYPE STRING,
D_DOKVR TYPE STRING,
E_EQUNR TYPE STRING,
E_WERKS TYPE STRING,
E_STLAN TYPE STRING,
K_VBELN TYPE STRING,
K_VBPOS TYPE STRING,
K_MATNR TYPE STRING,
K_WERKS TYPE STRING,
K_STLAN TYPE STRING,
M_MATNR TYPE STRING,
M_WERKS TYPE STRING,
M_STLAN TYPE STRING,
P_PSPNR TYPE STRING,
P_MATNR TYPE STRING,
P_WERKS TYPE STRING,
P_STLAN TYPE STRING,
S_STOBJ TYPE STRING,
S_WERKS TYPE STRING,
S_STLAN TYPE STRING,
T_TPLNR TYPE STRING,
T_WERKS TYPE STRING,
T_STLAN TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CCS_AEOI_EXT_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_CCS_AEOI_EXT_STR-MANDT sy-vline 
WA_CCS_AEOI_EXT_STR-AENNR sy-vline 
WA_CCS_AEOI_EXT_STR-AETYP sy-vline 
WA_CCS_AEOI_EXT_STR-OBJKT sy-vline 
WA_CCS_AEOI_EXT_STR-USOBJ sy-vline 
WA_CCS_AEOI_EXT_STR-CCVMS sy-vline 
WA_CCS_AEOI_EXT_STR-OITXT sy-vline 
WA_CCS_AEOI_EXT_STR-LTXSP sy-vline 
WA_CCS_AEOI_EXT_STR-AEDAT sy-vline 
WA_CCS_AEOI_EXT_STR-AENAM sy-vline 
WA_CCS_AEOI_EXT_STR-ANDAT sy-vline 
WA_CCS_AEOI_EXT_STR-ANNAM sy-vline 
WA_CCS_AEOI_EXT_STR-OBJDT sy-vline 
WA_CCS_AEOI_EXT_STR-OBJNM sy-vline 
WA_CCS_AEOI_EXT_STR-CCLCK sy-vline 
WA_CCS_AEOI_EXT_STR-AEOST sy-vline 
WA_CCS_AEOI_EXT_STR-REVLV sy-vline 
WA_CCS_AEOI_EXT_STR-AEDTZ sy-vline 
WA_CCS_AEOI_EXT_STR-CCSTO sy-vline 
WA_CCS_AEOI_EXT_STR-CCOAA sy-vline 
WA_CCS_AEOI_EXT_STR-CONT1 sy-vline 
WA_CCS_AEOI_EXT_STR-AEOI_GUID sy-vline 
WA_CCS_AEOI_EXT_STR-STLAL sy-vline 
WA_CCS_AEOI_EXT_STR-STA_SY_CUR_KEY sy-vline 
WA_CCS_AEOI_EXT_STR-STA_SY_CUR_TXT sy-vline 
WA_CCS_AEOI_EXT_STR-USERNAME sy-vline 
WA_CCS_AEOI_EXT_STR-STA_DATE sy-vline 
WA_CCS_AEOI_EXT_STR-STA_TIME sy-vline 
WA_CCS_AEOI_EXT_STR-DURATION sy-vline 
WA_CCS_AEOI_EXT_STR-ATTXT sy-vline 
WA_CCS_AEOI_EXT_STR-ATABR sy-vline 
WA_CCS_AEOI_EXT_STR-DATUV sy-vline 
WA_CCS_AEOI_EXT_STR-AEDTN sy-vline 
WA_CCS_AEOI_EXT_STR-ICON sy-vline 
WA_CCS_AEOI_EXT_STR-AENOB sy-vline 
WA_CCS_AEOI_EXT_STR-ALT_ECN_CHANGED sy-vline 
WA_CCS_AEOI_EXT_STR-MATNR sy-vline 
WA_CCS_AEOI_EXT_STR-DOKAR sy-vline 
WA_CCS_AEOI_EXT_STR-DOKNR sy-vline 
WA_CCS_AEOI_EXT_STR-DOKTL sy-vline 
WA_CCS_AEOI_EXT_STR-DOKVR sy-vline 
WA_CCS_AEOI_EXT_STR-PLNTY sy-vline 
WA_CCS_AEOI_EXT_STR-PLNNR sy-vline 
WA_CCS_AEOI_EXT_STR-D_DOKAR sy-vline 
WA_CCS_AEOI_EXT_STR-D_DOKNR sy-vline 
WA_CCS_AEOI_EXT_STR-D_DOKTL sy-vline 
WA_CCS_AEOI_EXT_STR-D_DOKVR sy-vline 
WA_CCS_AEOI_EXT_STR-E_EQUNR sy-vline 
WA_CCS_AEOI_EXT_STR-E_WERKS sy-vline 
WA_CCS_AEOI_EXT_STR-E_STLAN sy-vline 
WA_CCS_AEOI_EXT_STR-K_VBELN sy-vline 
WA_CCS_AEOI_EXT_STR-K_VBPOS sy-vline 
WA_CCS_AEOI_EXT_STR-K_MATNR sy-vline 
WA_CCS_AEOI_EXT_STR-K_WERKS sy-vline 
WA_CCS_AEOI_EXT_STR-K_STLAN sy-vline 
WA_CCS_AEOI_EXT_STR-M_MATNR sy-vline 
WA_CCS_AEOI_EXT_STR-M_WERKS sy-vline 
WA_CCS_AEOI_EXT_STR-M_STLAN sy-vline 
WA_CCS_AEOI_EXT_STR-P_PSPNR sy-vline 
WA_CCS_AEOI_EXT_STR-P_MATNR sy-vline 
WA_CCS_AEOI_EXT_STR-P_WERKS sy-vline 
WA_CCS_AEOI_EXT_STR-P_STLAN sy-vline 
WA_CCS_AEOI_EXT_STR-S_STOBJ sy-vline 
WA_CCS_AEOI_EXT_STR-S_WERKS sy-vline 
WA_CCS_AEOI_EXT_STR-S_STLAN sy-vline 
WA_CCS_AEOI_EXT_STR-T_TPLNR sy-vline 
WA_CCS_AEOI_EXT_STR-T_WERKS sy-vline 
WA_CCS_AEOI_EXT_STR-T_STLAN sy-vline      INTO ld_text SEPARATED BY SPACE.

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