ABAP Select data from SAP table CRAPO_BAPI_RES_HEAD 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 CRAPO_BAPI_RES_HEAD 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 CRAPO_BAPI_RES_HEAD. 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 CRAPO_BAPI_RES_HEAD 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_CRAPO_BAPI_RES_HEAD TYPE STANDARD TABLE OF CRAPO_BAPI_RES_HEAD,
      WA_CRAPO_BAPI_RES_HEAD TYPE CRAPO_BAPI_RES_HEAD,
      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: <CRAPO_BAPI_RES_HEAD> TYPE CRAPO_BAPI_RES_HEAD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CRAPO_BAPI_RES_HEAD
*  INTO TABLE @DATA(IT_CRAPO_BAPI_RES_HEAD2).
*--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_CRAPO_BAPI_RES_HEAD INDEX 1 INTO DATA(WA_CRAPO_BAPI_RES_HEAD2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CRAPO_BAPI_RES_HEAD>-RESOURCE = 1.
<CRAPO_BAPI_RES_HEAD>-RESOURCE_INT = 1.
<CRAPO_BAPI_RES_HEAD>-RESUID = 1.
<CRAPO_BAPI_RES_HEAD>-RESTYPE = 1.
<CRAPO_BAPI_RES_HEAD>-LOCATION = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CRAPO_BAPI_RES_HEAD-LOCTYPE, sy-vline,
  WA_CRAPO_BAPI_RES_HEAD-CALENDAR, sy-vline,
  WA_CRAPO_BAPI_RES_HEAD-TYPE, sy-vline,
  WA_CRAPO_BAPI_RES_HEAD-BEGTI, sy-vline,
  WA_CRAPO_BAPI_RES_HEAD-ENDTI, sy-vline,
  WA_CRAPO_BAPI_RES_HEAD-BREAKTIME, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CRAPO_BAPI_RES_HEAD 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_CRAPO_BAPI_RES_HEAD 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_CRAPO_BAPI_RES_HEAD INTO WA_CRAPO_BAPI_RES_HEAD.


*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_CRAPO_BAPI_RES_HEAD_STR, 
RESOURCE TYPE STRING,
RESOURCE_INT TYPE STRING,
RESUID TYPE STRING,
RESTYPE TYPE STRING,
LOCATION TYPE STRING,
LOCTYPE TYPE STRING,
CALENDAR TYPE STRING,
TYPE TYPE STRING,
BEGTI TYPE STRING,
ENDTI TYPE STRING,
BREAKTIME TYPE STRING,
BUFFERTIME TYPE STRING,
BUFFERTIME_UNIT TYPE STRING,
BUFFERTIME_UNITI_ TYPE STRING,
NOINDIVRES TYPE STRING,
NOINDIVRES_UNIT TYPE STRING,
NOINDIVRES_UNITI TYPE STRING,
INDIVRES_CAP TYPE STRING,
UTILIZATION TYPE STRING,
DIMENSION TYPE STRING,
CAPACITY_A TYPE STRING,
CAPACITY_A_UNIT TYPE STRING,
CAPACITY_A_UNITI TYPE STRING,
NUM_OF_PERIODS TYPE STRING,
PERIOD TYPE STRING,
PLANNER TYPE STRING,
VERSION_ACTIVE TYPE STRING,
FINITE_PLANNING TYPE STRING,
IS_BOTTLENECK TYPE STRING,
MIN_GAPS TYPE STRING,
OVERLOAD TYPE STRING,
UNDERLOAD TYPE STRING,
OVERLAP_BUCKETS TYPE STRING,
START_ON_GRID TYPE STRING,
MIN_OVERLAP TYPE STRING,
MIN_OVERLAP_UNIT TYPE STRING,
MIN_OVERLAP_UNIIT TYPE STRING,
MATRIX_NAME TYPE STRING,
MATRIX_LOCATION TYPE STRING,
MATRIX_LOCTYPE TYPE STRING,
REF_RESOURCE TYPE STRING,
REF_RESOURCE_INT TYPE STRING,
CHANGEUSER TYPE STRING,
CHANGEDATE TYPE STRING,
TIMEZONE TYPE STRING,
SHORT_TEXT TYPE STRING,
LOSS_FACTOR TYPE STRING,
REF_PROCTIME TYPE STRING,
REF_PROCTIME_UN TYPE STRING,
REF_PROCTIME_UNI TYPE STRING,
TAKTS TYPE STRING,
BASE_RATE_QUANT TYPE STRING,
BASE_RATE_QUANTUI TYPE STRING,
BASE_RATE_QUANTI TYPE STRING,
BASE_RATE_TIME TYPE STRING,
BASE_RATE_TIME_U TYPE STRING,
BASE_RATE_TIME_I TYPE STRING,
RITT_FLG TYPE STRING,
SORT TYPE STRING,
SYNC_START TYPE STRING,
SYNC_COMPATIBLE TYPE STRING,
MDRMODEL TYPE STRING,
DEFINE_BUCKETS TYPE STRING,
DAYS_MINUS TYPE STRING,
DAYS_PLUS TYPE STRING,
TRATY TYPE STRING,
STORAGE_CAPABLE TYPE STRING,
MIN_STORAGE TYPE STRING,
MAX_STORAGE TYPE STRING,
MIN_REPLENISHMNT TYPE STRING,
STORAGE_UNIT TYPE STRING,
STORAGE_UNIT_ISO TYPE STRING,
DIM_STORAGE TYPE STRING,
SNPLC TYPE STRING,
ADD_PLAN_BUCKET TYPE STRING,
DIMENSION_BUCKET TYPE STRING,
UTIL_BUCKET TYPE STRING,
MIX_PLAN_TYPE TYPE STRING,
CAMPAIGN_PPDS TYPE STRING,
CAMPAIGN_SNP TYPE STRING,
STORAGE_TO_ZERO TYPE STRING,
TSW_VEH_ID TYPE STRING,
TSW_HEIGHT TYPE STRING,
TSW_WIDTH TYPE STRING,
TSW_LENGTH TYPE STRING,
TSW_DRAFT_L TYPE STRING,
TSW_DRAFT_U TYPE STRING,
TSW_L_UNIT TYPE STRING,
TSW_L_UNIT_ISO TYPE STRING,
TSW_SPEED_N TYPE STRING,
TSW_SPEED_MAX TYPE STRING,
TSW_SPEED_UNIT TYPE STRING,
TSW_SPEED_UNIT_I TYPE STRING,
TSW_WEIGHT_UNL TYPE STRING,
TSW_WEIGHT_UNIT TYPE STRING,
TSW_WEIGHT_UNIT_ TYPE STRING,
TSW_CARRIER TYPE STRING,
TSW_DUMMY_VEH TYPE STRING,
TSW_PR_COMP_GRP TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CRAPO_BAPI_RES_HEAD_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_CRAPO_BAPI_RES_HEAD_STR-RESOURCE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-RESOURCE_INT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-RESUID sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-RESTYPE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-LOCATION sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-LOCTYPE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-CALENDAR sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TYPE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BEGTI sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-ENDTI sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BREAKTIME sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BUFFERTIME sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BUFFERTIME_UNIT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BUFFERTIME_UNITI_ sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-NOINDIVRES sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-NOINDIVRES_UNIT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-NOINDIVRES_UNITI sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-INDIVRES_CAP sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-UTILIZATION sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-DIMENSION sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-CAPACITY_A sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-CAPACITY_A_UNIT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-CAPACITY_A_UNITI sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-NUM_OF_PERIODS sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-PERIOD sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-PLANNER sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-VERSION_ACTIVE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-FINITE_PLANNING sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-IS_BOTTLENECK sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MIN_GAPS sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-OVERLOAD sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-UNDERLOAD sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-OVERLAP_BUCKETS sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-START_ON_GRID sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MIN_OVERLAP sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MIN_OVERLAP_UNIT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MIN_OVERLAP_UNIIT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MATRIX_NAME sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MATRIX_LOCATION sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MATRIX_LOCTYPE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-REF_RESOURCE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-REF_RESOURCE_INT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-CHANGEUSER sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-CHANGEDATE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TIMEZONE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-SHORT_TEXT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-LOSS_FACTOR sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-REF_PROCTIME sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-REF_PROCTIME_UN sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-REF_PROCTIME_UNI sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TAKTS sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BASE_RATE_QUANT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BASE_RATE_QUANTUI sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BASE_RATE_QUANTI sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BASE_RATE_TIME sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BASE_RATE_TIME_U sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-BASE_RATE_TIME_I sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-RITT_FLG sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-SORT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-SYNC_START sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-SYNC_COMPATIBLE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MDRMODEL sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-DEFINE_BUCKETS sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-DAYS_MINUS sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-DAYS_PLUS sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TRATY sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-STORAGE_CAPABLE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MIN_STORAGE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MAX_STORAGE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MIN_REPLENISHMNT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-STORAGE_UNIT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-STORAGE_UNIT_ISO sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-DIM_STORAGE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-SNPLC sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-ADD_PLAN_BUCKET sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-DIMENSION_BUCKET sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-UTIL_BUCKET sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-MIX_PLAN_TYPE sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-CAMPAIGN_PPDS sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-CAMPAIGN_SNP sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-STORAGE_TO_ZERO sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_VEH_ID sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_HEIGHT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_WIDTH sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_LENGTH sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_DRAFT_L sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_DRAFT_U sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_L_UNIT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_L_UNIT_ISO sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_SPEED_N sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_SPEED_MAX sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_SPEED_UNIT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_SPEED_UNIT_I sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_WEIGHT_UNL sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_WEIGHT_UNIT sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_WEIGHT_UNIT_ sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_CARRIER sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_DUMMY_VEH sy-vline 
WA_CRAPO_BAPI_RES_HEAD_STR-TSW_PR_COMP_GRP sy-vline      INTO ld_text SEPARATED BY SPACE.

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