ABAP Select data from SAP table BBPS_PROCTYPE_DATA 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 BBPS_PROCTYPE_DATA 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 BBPS_PROCTYPE_DATA. 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 BBPS_PROCTYPE_DATA 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_BBPS_PROCTYPE_DATA TYPE STANDARD TABLE OF BBPS_PROCTYPE_DATA,
      WA_BBPS_PROCTYPE_DATA TYPE BBPS_PROCTYPE_DATA,
      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: <BBPS_PROCTYPE_DATA> TYPE BBPS_PROCTYPE_DATA.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM BBPS_PROCTYPE_DATA
*  INTO TABLE @DATA(IT_BBPS_PROCTYPE_DATA2).
*--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_BBPS_PROCTYPE_DATA INDEX 1 INTO DATA(WA_BBPS_PROCTYPE_DATA2).


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

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

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_BBPS_PROCTYPE_DATA-PROCESS_BLOCKED, sy-vline,
  WA_BBPS_PROCTYPE_DATA-BUP_SCHEMA_ID, sy-vline,
  WA_BBPS_PROCTYPE_DATA-TEXT_SCHEME_ID, sy-vline,
  WA_BBPS_PROCTYPE_DATA-EVENT_SCHEMA_ID, sy-vline,
  WA_BBPS_PROCTYPE_DATA-SIG_CONF_OPT, sy-vline,
  WA_BBPS_PROCTYPE_DATA-USER_STAT_PROC, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_BBPS_PROCTYPE_DATA 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_BBPS_PROCTYPE_DATA 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_BBPS_PROCTYPE_DATA INTO WA_BBPS_PROCTYPE_DATA.


*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_BBPS_PROCTYPE_DATA_STR, 
CLIENT TYPE STRING,
PROCESS_TYPE TYPE STRING,
P_DESCRIPTION_20 TYPE STRING,
NUMBER_RANGE_INT TYPE STRING,
NUMBER_RANGE_EXT TYPE STRING,
PROCESS_BLOCKED TYPE STRING,
BUP_SCHEMA_ID TYPE STRING,
TEXT_SCHEME_ID TYPE STRING,
EVENT_SCHEMA_ID TYPE STRING,
SIG_CONF_OPT TYPE STRING,
USER_STAT_PROC TYPE STRING,
OBJECT_TYPE TYPE STRING,
S_DESCRIPTION_20 TYPE STRING,
SUBTYPE TYPE STRING,
CTR_IND TYPE STRING,
PO_IND TYPE STRING,
BID_TYPE TYPE STRING,
USE_CONDITIONS TYPE STRING,
QUAN_CONTROL TYPE STRING,
ADD_ITEMS_IND TYPE STRING,
SHOW_WEIGHIN_IND TYPE STRING,
BID_ALL_ITMS_IND TYPE STRING,
BID_VALIDATION TYPE STRING,
DECR_TYPE TYPE STRING,
BID_CHG_ALLOWED TYPE STRING,
INRPRC TYPE STRING,
INRANK TYPE STRING,
INCRNK TYPE STRING,
INBSBD TYPE STRING,
INCBSB TYPE STRING,
INNXBD TYPE STRING,
INFRST TYPE STRING,
INHUFB TYPE STRING,
INCOMP TYPE STRING,
INBIDN TYPE STRING,
INBDPR TYPE STRING,
INAEXT TYPE STRING,
INNMBD TYPE STRING,
INCBID TYPE STRING,
CTBDNR TYPE STRING,
CTBDVL TYPE STRING,
CTBDBS TYPE STRING,
RNOTIE TYPE STRING,
RWTTIE TYPE STRING,
SNDCHT TYPE STRING,
COMP_MULTI_BID TYPE STRING,
FULL_QTY_IND TYPE STRING,
INCLPR TYPE STRING,
ALLOW_TEAM_PURCH TYPE STRING,
BEGDA TYPE STRING,
ENDDA TYPE STRING,
TP_CRSORG_ASSGMT TYPE STRING,
OFFLINE_IND TYPE STRING,
BIDDING_SYSTEM TYPE STRING,
LIMIT_CTRL_FLAG TYPE STRING,
BBP_MENV_SCHEMA TYPE STRING,END OF T_EKKO_STR.
DATA: WA_BBPS_PROCTYPE_DATA_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_BBPS_PROCTYPE_DATA_STR-CLIENT sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-PROCESS_TYPE sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-P_DESCRIPTION_20 sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-NUMBER_RANGE_INT sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-NUMBER_RANGE_EXT sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-PROCESS_BLOCKED sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-BUP_SCHEMA_ID sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-TEXT_SCHEME_ID sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-EVENT_SCHEMA_ID sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-SIG_CONF_OPT sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-USER_STAT_PROC sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-OBJECT_TYPE sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-S_DESCRIPTION_20 sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-SUBTYPE sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-CTR_IND sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-PO_IND sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-BID_TYPE sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-USE_CONDITIONS sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-QUAN_CONTROL sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-ADD_ITEMS_IND sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-SHOW_WEIGHIN_IND sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-BID_ALL_ITMS_IND sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-BID_VALIDATION sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-DECR_TYPE sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-BID_CHG_ALLOWED sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INRPRC sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INRANK sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INCRNK sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INBSBD sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INCBSB sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INNXBD sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INFRST sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INHUFB sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INCOMP sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INBIDN sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INBDPR sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INAEXT sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INNMBD sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INCBID sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-CTBDNR sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-CTBDVL sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-CTBDBS sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-RNOTIE sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-RWTTIE sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-SNDCHT sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-COMP_MULTI_BID sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-FULL_QTY_IND sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-INCLPR sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-ALLOW_TEAM_PURCH sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-BEGDA sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-ENDDA sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-TP_CRSORG_ASSGMT sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-OFFLINE_IND sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-BIDDING_SYSTEM sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-LIMIT_CTRL_FLAG sy-vline 
WA_BBPS_PROCTYPE_DATA_STR-BBP_MENV_SCHEMA sy-vline      INTO ld_text SEPARATED BY SPACE.

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