ABAP Select data from SAP table PC2TTI 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 PC2TTI 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 PC2TTI. 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 PC2TTI 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_PC2TTI TYPE STANDARD TABLE OF PC2TTI,
      WA_PC2TTI TYPE PC2TTI,
      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: <PC2TTI> TYPE PC2TTI.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PC2TTI
*  INTO TABLE @DATA(IT_PC2TTI2).
*--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_PC2TTI INDEX 1 INTO DATA(WA_PC2TTI2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PC2TTI>-TYPE = 1.
<PC2TTI>-TYP_IT = 1.
<PC2TTI>-PERNR = 1.
<PC2TTI>-PERNC = 1.
<PC2TTI>-CBUSN = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PC2TTI-QCTXI, sy-vline,
  WA_PC2TTI-WRKAR, sy-vline,
  WA_PC2TTI-PVTAX, sy-vline,
  WA_PC2TTI-CNTR1, sy-vline,
  WA_PC2TTI-INCOME, sy-vline,
  WA_PC2TTI-GRS, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PC2TTI 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_PC2TTI 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_PC2TTI INTO WA_PC2TTI.


*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_PC2TTI_STR, 
TYPE TYPE STRING,
TYP_IT TYPE STRING,
PERNR TYPE STRING,
PERNC TYPE STRING,
CBUSN TYPE STRING,
QCTXI TYPE STRING,
WRKAR TYPE STRING,
PVTAX TYPE STRING,
CNTR1 TYPE STRING,
INCOME TYPE STRING,
GRS TYPE STRING,
GRS_PTD TYPE STRING,
GRS_YTD TYPE STRING,
GRS_FUP TYPE STRING,
GRS_ALZ TYPE STRING,
GRS_ADD TYPE STRING,
PGR TYPE STRING,
PGR_YTD TYPE STRING,
PGR_FUP TYPE STRING,
EXM TYPE STRING,
EXM_PTD TYPE STRING,
EXM_YTD TYPE STRING,
EXM_FUP TYPE STRING,
EXM_ALZ TYPE STRING,
EXM_AVG TYPE STRING,
CRD_FUP TYPE STRING,
CRD_YTD TYPE STRING,
CRD_ALZ TYPE STRING,
CRP_FUP TYPE STRING,
CRP_YTD TYPE STRING,
CRP_ALZ TYPE STRING,
COM TYPE STRING,
COM_PTD TYPE STRING,
COM_FUP TYPE STRING,
CPP_FUP TYPE STRING,
CPP_YTD TYPE STRING,
CPP_ALZ TYPE STRING,
CEI_FUP TYPE STRING,
CEI_YTD TYPE STRING,
CEI_ALZ TYPE STRING,
TEE TYPE STRING,
TEE_PTD TYPE STRING,
TEE_YTD TYPE STRING,
TEE_ALZ TYPE STRING,
TEE_WT TYPE STRING,
TPE TYPE STRING,
TPE_YTD TYPE STRING,
TPE_WT TYPE STRING,
TEE_ADD TYPE STRING,
TEE_WTA TYPE STRING,
CEI_GRS_YTD TYPE STRING,
PPIP_FUP TYPE STRING,
PPIP_YTD TYPE STRING,
PPIP_ALZ TYPE STRING,
EI_CALC_YTD TYPE STRING,
DED TYPE STRING,
DED_PTD TYPE STRING,
DED_YTD TYPE STRING,
DED_ALZ TYPE STRING,
DED_GRS TYPE STRING,
DED_GRS_PTD TYPE STRING,
DED_GRS_FUP TYPE STRING,
CRF_FUP TYPE STRING,
CRF_YTD TYPE STRING,
CRF_ALZ TYPE STRING,
QHT_ALZ TYPE STRING,
QHT_YTD TYPE STRING,
QHT_FUP TYPE STRING,
QHT TYPE STRING,
QHT_WT TYPE STRING,
QHT_PTD TYPE STRING,
QHE_ALZ TYPE STRING,
QHE_YTD TYPE STRING,
QHE_FUP TYPE STRING,
QHE TYPE STRING,
QHE_WT TYPE STRING,
QHE_PTD TYPE STRING,
QHE_AVG TYPE STRING,
CQH_YTD TYPE STRING,
CQH_PTD TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PC2TTI_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_PC2TTI_STR-TYPE sy-vline 
WA_PC2TTI_STR-TYP_IT sy-vline 
WA_PC2TTI_STR-PERNR sy-vline 
WA_PC2TTI_STR-PERNC sy-vline 
WA_PC2TTI_STR-CBUSN sy-vline 
WA_PC2TTI_STR-QCTXI sy-vline 
WA_PC2TTI_STR-WRKAR sy-vline 
WA_PC2TTI_STR-PVTAX sy-vline 
WA_PC2TTI_STR-CNTR1 sy-vline 
WA_PC2TTI_STR-INCOME sy-vline 
WA_PC2TTI_STR-GRS sy-vline 
WA_PC2TTI_STR-GRS_PTD sy-vline 
WA_PC2TTI_STR-GRS_YTD sy-vline 
WA_PC2TTI_STR-GRS_FUP sy-vline 
WA_PC2TTI_STR-GRS_ALZ sy-vline 
WA_PC2TTI_STR-GRS_ADD sy-vline 
WA_PC2TTI_STR-PGR sy-vline 
WA_PC2TTI_STR-PGR_YTD sy-vline 
WA_PC2TTI_STR-PGR_FUP sy-vline 
WA_PC2TTI_STR-EXM sy-vline 
WA_PC2TTI_STR-EXM_PTD sy-vline 
WA_PC2TTI_STR-EXM_YTD sy-vline 
WA_PC2TTI_STR-EXM_FUP sy-vline 
WA_PC2TTI_STR-EXM_ALZ sy-vline 
WA_PC2TTI_STR-EXM_AVG sy-vline 
WA_PC2TTI_STR-CRD_FUP sy-vline 
WA_PC2TTI_STR-CRD_YTD sy-vline 
WA_PC2TTI_STR-CRD_ALZ sy-vline 
WA_PC2TTI_STR-CRP_FUP sy-vline 
WA_PC2TTI_STR-CRP_YTD sy-vline 
WA_PC2TTI_STR-CRP_ALZ sy-vline 
WA_PC2TTI_STR-COM sy-vline 
WA_PC2TTI_STR-COM_PTD sy-vline 
WA_PC2TTI_STR-COM_FUP sy-vline 
WA_PC2TTI_STR-CPP_FUP sy-vline 
WA_PC2TTI_STR-CPP_YTD sy-vline 
WA_PC2TTI_STR-CPP_ALZ sy-vline 
WA_PC2TTI_STR-CEI_FUP sy-vline 
WA_PC2TTI_STR-CEI_YTD sy-vline 
WA_PC2TTI_STR-CEI_ALZ sy-vline 
WA_PC2TTI_STR-TEE sy-vline 
WA_PC2TTI_STR-TEE_PTD sy-vline 
WA_PC2TTI_STR-TEE_YTD sy-vline 
WA_PC2TTI_STR-TEE_ALZ sy-vline 
WA_PC2TTI_STR-TEE_WT sy-vline 
WA_PC2TTI_STR-TPE sy-vline 
WA_PC2TTI_STR-TPE_YTD sy-vline 
WA_PC2TTI_STR-TPE_WT sy-vline 
WA_PC2TTI_STR-TEE_ADD sy-vline 
WA_PC2TTI_STR-TEE_WTA sy-vline 
WA_PC2TTI_STR-CEI_GRS_YTD sy-vline 
WA_PC2TTI_STR-PPIP_FUP sy-vline 
WA_PC2TTI_STR-PPIP_YTD sy-vline 
WA_PC2TTI_STR-PPIP_ALZ sy-vline 
WA_PC2TTI_STR-EI_CALC_YTD sy-vline 
WA_PC2TTI_STR-DED sy-vline 
WA_PC2TTI_STR-DED_PTD sy-vline 
WA_PC2TTI_STR-DED_YTD sy-vline 
WA_PC2TTI_STR-DED_ALZ sy-vline 
WA_PC2TTI_STR-DED_GRS sy-vline 
WA_PC2TTI_STR-DED_GRS_PTD sy-vline 
WA_PC2TTI_STR-DED_GRS_FUP sy-vline 
WA_PC2TTI_STR-CRF_FUP sy-vline 
WA_PC2TTI_STR-CRF_YTD sy-vline 
WA_PC2TTI_STR-CRF_ALZ sy-vline 
WA_PC2TTI_STR-QHT_ALZ sy-vline 
WA_PC2TTI_STR-QHT_YTD sy-vline 
WA_PC2TTI_STR-QHT_FUP sy-vline 
WA_PC2TTI_STR-QHT sy-vline 
WA_PC2TTI_STR-QHT_WT sy-vline 
WA_PC2TTI_STR-QHT_PTD sy-vline 
WA_PC2TTI_STR-QHE_ALZ sy-vline 
WA_PC2TTI_STR-QHE_YTD sy-vline 
WA_PC2TTI_STR-QHE_FUP sy-vline 
WA_PC2TTI_STR-QHE sy-vline 
WA_PC2TTI_STR-QHE_WT sy-vline 
WA_PC2TTI_STR-QHE_PTD sy-vline 
WA_PC2TTI_STR-QHE_AVG sy-vline 
WA_PC2TTI_STR-CQH_YTD sy-vline 
WA_PC2TTI_STR-CQH_PTD sy-vline      INTO ld_text SEPARATED BY SPACE.

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