ABAP Select data from SAP table CRMST_PROC_TYPE_ACT 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 CRMST_PROC_TYPE_ACT 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 CRMST_PROC_TYPE_ACT. 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 CRMST_PROC_TYPE_ACT 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_CRMST_PROC_TYPE_ACT TYPE STANDARD TABLE OF CRMST_PROC_TYPE_ACT,
      WA_CRMST_PROC_TYPE_ACT TYPE CRMST_PROC_TYPE_ACT,
      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: <CRMST_PROC_TYPE_ACT> TYPE CRMST_PROC_TYPE_ACT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CRMST_PROC_TYPE_ACT
*  INTO TABLE @DATA(IT_CRMST_PROC_TYPE_ACT2).
*--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_CRMST_PROC_TYPE_ACT INDEX 1 INTO DATA(WA_CRMST_PROC_TYPE_ACT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CRMST_PROC_TYPE_ACT>-CLIENT = 1.
<CRMST_PROC_TYPE_ACT>-PROCESS_TYPE = 1.
<CRMST_PROC_TYPE_ACT>-PROCESS_BLOCKED = 1.
<CRMST_PROC_TYPE_ACT>-NUMBER_RANGE_INT = 1.
<CRMST_PROC_TYPE_ACT>-NUMBER_RANGE_EXT = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CRMST_PROC_TYPE_ACT-INCR_ITEM_PROC, sy-vline,
  WA_CRMST_PROC_TYPE_ACT-INCR_S_ITEM_PROC, sy-vline,
  WA_CRMST_PROC_TYPE_ACT-TEXT_PROCEDURE, sy-vline,
  WA_CRMST_PROC_TYPE_ACT-PART_DETERM_PROC, sy-vline,
  WA_CRMST_PROC_TYPE_ACT-USER_STAT_PROC, sy-vline,
  WA_CRMST_PROC_TYPE_ACT-OBJECT_TYPE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CRMST_PROC_TYPE_ACT 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_CRMST_PROC_TYPE_ACT 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_CRMST_PROC_TYPE_ACT INTO WA_CRMST_PROC_TYPE_ACT.


*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_CRMST_PROC_TYPE_ACT_STR, 
CLIENT TYPE STRING,
PROCESS_TYPE TYPE STRING,
PROCESS_BLOCKED TYPE STRING,
NUMBER_RANGE_INT TYPE STRING,
NUMBER_RANGE_EXT TYPE STRING,
INCR_ITEM_PROC TYPE STRING,
INCR_S_ITEM_PROC TYPE STRING,
TEXT_PROCEDURE TYPE STRING,
PART_DETERM_PROC TYPE STRING,
USER_STAT_PROC TYPE STRING,
OBJECT_TYPE TYPE STRING,
ORG_PARTNER_PFT TYPE STRING,
ORG_PROFILID TYPE STRING,
EARLY_ORDER_NO TYPE STRING,
NO_CHANGE_DOCS TYPE STRING,
NO_IMPL_CH_DOCS TYPE STRING,
TIMEPROFILE TYPE STRING,
ACTIONPROFILE TYPE STRING,
CANCPROC TYPE STRING,
PON_VALID TYPE STRING,
PON_PRODID_CHECK TYPE STRING,
COND_GROUP_NAME TYPE STRING,
CUSTMAT_VALID TYPE STRING,
STATUS_OBJ_TYPE TYPE STRING,
CONTRACT_MESSAGE TYPE STRING,
ELIGIBLE_PARTNER TYPE STRING,
GTIN_VALID TYPE STRING,
POSTPROCESS_FROM TYPE STRING,
ALLOW_PART_PROC TYPE STRING,
COMM_DATE TYPE STRING,
ERR_GRP TYPE STRING,
ALTID_PROFILE TYPE STRING,
PROD_DET_PROC TYPE STRING,
OBJREF_PROF_ID TYPE STRING,
TEMPLATE_TYPE TYPE STRING,
REFERRENCE_DOC TYPE STRING,
QUOTATIO_MESSAGE TYPE STRING,
CONTRACT_QUANVAL TYPE STRING,
ELIG_HIER_TYPE TYPE STRING,
CAMPAIGN_DETERM TYPE STRING,
ATP_TYPE TYPE STRING,
TEMPLATE_NAME TYPE STRING,
TEMPLATE_PROFILE TYPE STRING,
AP_DET_PROC TYPE STRING,
EXT_REF_PROFILE TYPE STRING,
AGREEMENT_MSG TYPE STRING,
CREI_PROFILE TYPE STRING,
SC_VALID TYPE STRING,
EXT_PROD_ALLOWED TYPE STRING,
EXT_PROD_ITCATGR TYPE STRING,
TERRITORY_CHECK TYPE STRING,
BTX_CLASS TYPE STRING,
APRV_DET_PROC TYPE STRING,
AUTH_DOM TYPE STRING,
CHECKLIST_PROFIL TYPE STRING,
OBJ_LINKAGE_PROF TYPE STRING,
DEDUP_PROFILE TYPE STRING,
TAX_RELEVANT TYPE STRING,
PROD_DESC_SRCH TYPE STRING,
FOLLOW_WINDOW TYPE STRING,
SERVICE_TEAM_PROFILE TYPE STRING,
PROC_STP_OVW_PRFL TYPE STRING,
REJPROFILE TYPE STRING,
SCENARIO TYPE STRING,
CATEGORY TYPE STRING,
PRIORITY TYPE STRING,
OBJECTIVE TYPE STRING,
DIRECTION TYPE STRING,
TASK TYPE STRING,
PRIVATE_FLAG TYPE STRING,
CALENDAR TYPE STRING,
SUBJECT_PROFILE TYPE STRING,
SEND_EMAIL TYPE STRING,
CLASS TYPE STRING,
MULTIPLE_CLASS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CRMST_PROC_TYPE_ACT_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_CRMST_PROC_TYPE_ACT_STR-CLIENT sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-PROCESS_TYPE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-PROCESS_BLOCKED sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-NUMBER_RANGE_INT sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-NUMBER_RANGE_EXT sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-INCR_ITEM_PROC sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-INCR_S_ITEM_PROC sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-TEXT_PROCEDURE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-PART_DETERM_PROC sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-USER_STAT_PROC sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-OBJECT_TYPE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-ORG_PARTNER_PFT sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-ORG_PROFILID sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-EARLY_ORDER_NO sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-NO_CHANGE_DOCS sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-NO_IMPL_CH_DOCS sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-TIMEPROFILE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-ACTIONPROFILE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-CANCPROC sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-PON_VALID sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-PON_PRODID_CHECK sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-COND_GROUP_NAME sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-CUSTMAT_VALID sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-STATUS_OBJ_TYPE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-CONTRACT_MESSAGE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-ELIGIBLE_PARTNER sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-GTIN_VALID sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-POSTPROCESS_FROM sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-ALLOW_PART_PROC sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-COMM_DATE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-ERR_GRP sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-ALTID_PROFILE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-PROD_DET_PROC sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-OBJREF_PROF_ID sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-TEMPLATE_TYPE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-REFERRENCE_DOC sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-QUOTATIO_MESSAGE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-CONTRACT_QUANVAL sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-ELIG_HIER_TYPE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-CAMPAIGN_DETERM sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-ATP_TYPE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-TEMPLATE_NAME sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-TEMPLATE_PROFILE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-AP_DET_PROC sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-EXT_REF_PROFILE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-AGREEMENT_MSG sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-CREI_PROFILE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-SC_VALID sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-EXT_PROD_ALLOWED sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-EXT_PROD_ITCATGR sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-TERRITORY_CHECK sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-BTX_CLASS sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-APRV_DET_PROC sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-AUTH_DOM sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-CHECKLIST_PROFIL sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-OBJ_LINKAGE_PROF sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-DEDUP_PROFILE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-TAX_RELEVANT sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-PROD_DESC_SRCH sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-FOLLOW_WINDOW sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-SERVICE_TEAM_PROFILE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-PROC_STP_OVW_PRFL sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-REJPROFILE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-SCENARIO sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-CATEGORY sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-PRIORITY sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-OBJECTIVE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-DIRECTION sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-TASK sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-PRIVATE_FLAG sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-CALENDAR sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-SUBJECT_PROFILE sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-SEND_EMAIL sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-CLASS sy-vline 
WA_CRMST_PROC_TYPE_ACT_STR-MULTIPLE_CLASS sy-vline      INTO ld_text SEPARATED BY SPACE.

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