ABAP Select data from SAP table P15_CBI_F24_EP_RECORD_V1 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 P15_CBI_F24_EP_RECORD_V1 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 P15_CBI_F24_EP_RECORD_V1. 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 P15_CBI_F24_EP_RECORD_V1 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_P15_CBI_F24_EP_RECORD_V1 TYPE STANDARD TABLE OF P15_CBI_F24_EP_RECORD_V1,
      WA_P15_CBI_F24_EP_RECORD_V1 TYPE P15_CBI_F24_EP_RECORD_V1,
      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: <P15_CBI_F24_EP_RECORD_V1> TYPE P15_CBI_F24_EP_RECORD_V1.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM P15_CBI_F24_EP_RECORD_V1
*  INTO TABLE @DATA(IT_P15_CBI_F24_EP_RECORD_V12).
*--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_P15_CBI_F24_EP_RECORD_V1 INDEX 1 INTO DATA(WA_P15_CBI_F24_EP_RECORD_V12).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<P15_CBI_F24_EP_RECORD_V1>-TIPORECORD = 1.
<P15_CBI_F24_EP_RECORD_V1>-CODFISC = 1.
<P15_CBI_F24_EP_RECORD_V1>-PROGRESSIVO = 1.
<P15_CBI_F24_EP_RECORD_V1>-SPAZUTE1 = 1.
<P15_CBI_F24_EP_RECORD_V1>-FILLERA = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_P15_CBI_F24_EP_RECORD_V1-SPAZUTE2, sy-vline,
  WA_P15_CBI_F24_EP_RECORD_V1-FILLERB, sy-vline,
  WA_P15_CBI_F24_EP_RECORD_V1-TIPOMOD, sy-vline,
  WA_P15_CBI_F24_EP_RECORD_V1-CODUFF, sy-vline,
  WA_P15_CBI_F24_EP_RECORD_V1-CODATT, sy-vline,
  WA_P15_CBI_F24_EP_RECORD_V1-IDOPER, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_P15_CBI_F24_EP_RECORD_V1 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_P15_CBI_F24_EP_RECORD_V1 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_P15_CBI_F24_EP_RECORD_V1 INTO WA_P15_CBI_F24_EP_RECORD_V1.


*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_P15_CBI_F24_EP_RECORD_V1_STR, 
TIPORECORD TYPE STRING,
CODFISC TYPE STRING,
PROGRESSIVO TYPE STRING,
SPAZUTE1 TYPE STRING,
FILLERA TYPE STRING,
SPAZUTE2 TYPE STRING,
FILLERB TYPE STRING,
TIPOMOD TYPE STRING,
CODUFF TYPE STRING,
CODATT TYPE STRING,
IDOPER TYPE STRING,
TIPORIGA1 TYPE STRING,
CODTRIB1 TYPE STRING,
CODENTE1 TYPE STRING,
ESTREMI1 TYPE STRING,
RIFERIMENTOA1 TYPE STRING,
RIFERIMENTOB1 TYPE STRING,
IMPORTO1 TYPE STRING,
TIPORIGA2 TYPE STRING,
CODTRIB2 TYPE STRING,
CODENTE2 TYPE STRING,
ESTREMI2 TYPE STRING,
RIFERIMENTOA2 TYPE STRING,
RIFERIMENTOB2 TYPE STRING,
IMPORTO2 TYPE STRING,
TIPORIGA3 TYPE STRING,
CODTRIB3 TYPE STRING,
CODENTE3 TYPE STRING,
ESTREMI3 TYPE STRING,
RIFERIMENTOA3 TYPE STRING,
RIFERIMENTOB3 TYPE STRING,
IMPORTO3 TYPE STRING,
TIPORIGA4 TYPE STRING,
CODTRIB4 TYPE STRING,
CODENTE4 TYPE STRING,
ESTREMI4 TYPE STRING,
RIFERIMENTOA4 TYPE STRING,
RIFERIMENTOB4 TYPE STRING,
IMPORTO4 TYPE STRING,
TIPORIGA5 TYPE STRING,
CODTRIB5 TYPE STRING,
CODENTE5 TYPE STRING,
ESTREMI5 TYPE STRING,
RIFERIMENTOA5 TYPE STRING,
RIFERIMENTOB5 TYPE STRING,
IMPORTO5 TYPE STRING,
TIPORIGA6 TYPE STRING,
CODTRIB6 TYPE STRING,
CODENTE6 TYPE STRING,
ESTREMI6 TYPE STRING,
RIFERIMENTOA6 TYPE STRING,
RIFERIMENTOB6 TYPE STRING,
IMPORTO6 TYPE STRING,
TIPORIGA7 TYPE STRING,
CODTRIB7 TYPE STRING,
CODENTE7 TYPE STRING,
ESTREMI7 TYPE STRING,
RIFERIMENTOA7 TYPE STRING,
RIFERIMENTOB7 TYPE STRING,
IMPORTO7 TYPE STRING,
TIPORIGA8 TYPE STRING,
CODTRIB8 TYPE STRING,
CODENTE8 TYPE STRING,
ESTREMI8 TYPE STRING,
RIFERIMENTOA8 TYPE STRING,
RIFERIMENTOB8 TYPE STRING,
IMPORTO8 TYPE STRING,
TIPORIGA9 TYPE STRING,
CODTRIB9 TYPE STRING,
CODENTE9 TYPE STRING,
ESTREMI9 TYPE STRING,
RIFERIMENTOA9 TYPE STRING,
RIFERIMENTOB9 TYPE STRING,
IMPORTO9 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_P15_CBI_F24_EP_RECORD_V1_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_P15_CBI_F24_EP_RECORD_V1_STR-TIPORECORD sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODFISC sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-PROGRESSIVO sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-SPAZUTE1 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-FILLERA sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-SPAZUTE2 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-FILLERB sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-TIPOMOD sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODUFF sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODATT sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-IDOPER sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-TIPORIGA1 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODTRIB1 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODENTE1 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-ESTREMI1 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOA1 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOB1 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-IMPORTO1 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-TIPORIGA2 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODTRIB2 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODENTE2 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-ESTREMI2 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOA2 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOB2 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-IMPORTO2 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-TIPORIGA3 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODTRIB3 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODENTE3 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-ESTREMI3 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOA3 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOB3 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-IMPORTO3 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-TIPORIGA4 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODTRIB4 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODENTE4 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-ESTREMI4 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOA4 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOB4 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-IMPORTO4 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-TIPORIGA5 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODTRIB5 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODENTE5 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-ESTREMI5 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOA5 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOB5 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-IMPORTO5 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-TIPORIGA6 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODTRIB6 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODENTE6 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-ESTREMI6 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOA6 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOB6 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-IMPORTO6 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-TIPORIGA7 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODTRIB7 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODENTE7 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-ESTREMI7 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOA7 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOB7 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-IMPORTO7 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-TIPORIGA8 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODTRIB8 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODENTE8 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-ESTREMI8 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOA8 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOB8 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-IMPORTO8 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-TIPORIGA9 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODTRIB9 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-CODENTE9 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-ESTREMI9 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOA9 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-RIFERIMENTOB9 sy-vline 
WA_P15_CBI_F24_EP_RECORD_V1_STR-IMPORTO9 sy-vline      INTO ld_text SEPARATED BY SPACE.

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