ABAP Select data from SAP table /SAPAPO/PBDVIEW_TAB 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 /SAPAPO/PBDVIEW_TAB 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 /SAPAPO/PBDVIEW_TAB. 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 /SAPAPO/PBDVIEW_TAB 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_/SAPAPO/PBDVIEW_TAB TYPE STANDARD TABLE OF /SAPAPO/PBDVIEW_TAB,
      WA_/SAPAPO/PBDVIEW_TAB TYPE /SAPAPO/PBDVIEW_TAB,
      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: </SAPAPO/PBDVIEW_TAB> TYPE /SAPAPO/PBDVIEW_TAB.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /SAPAPO/PBDVIEW_TAB
  INTO TABLE IT_/SAPAPO/PBDVIEW_TAB.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /SAPAPO/PBDVIEW_TAB
*  INTO TABLE @DATA(IT_/SAPAPO/PBDVIEW_TAB2).
*--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_/SAPAPO/PBDVIEW_TAB INDEX 1 INTO DATA(WA_/SAPAPO/PBDVIEW_TAB2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SAPAPO/PBDVIEW_TAB ASSIGNING </SAPAPO/PBDVIEW_TAB>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</SAPAPO/PBDVIEW_TAB>-LAYOUT = 1.
</SAPAPO/PBDVIEW_TAB>-SCTYP = 1.
</SAPAPO/PBDVIEW_TAB>-FCODE = 1.
</SAPAPO/PBDVIEW_TAB>-TAB_VARI = 1.
</SAPAPO/PBDVIEW_TAB>-TAB_TEXT = 1.

ENDLOOP.

LOOP AT IT_/SAPAPO/PBDVIEW_TAB INTO WA_/SAPAPO/PBDVIEW_TAB.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SAPAPO/PBDVIEW_TAB-GRIDNR, sy-vline,
  WA_/SAPAPO/PBDVIEW_TAB-FLG_USED_FOR, sy-vline,
  WA_/SAPAPO/PBDVIEW_TAB-PLBEG, sy-vline,
  WA_/SAPAPO/PBDVIEW_TAB-REPER, sy-vline,
  WA_/SAPAPO/PBDVIEW_TAB-HINPU, sy-vline,
  WA_/SAPAPO/PBDVIEW_TAB-FPRAST, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/SAPAPO/PBDVIEW_TAB 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_/SAPAPO/PBDVIEW_TAB 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_/SAPAPO/PBDVIEW_TAB INTO WA_/SAPAPO/PBDVIEW_TAB.


*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_/SAPAPO/PBDVIEW_TAB_STR, 
LAYOUT TYPE STRING,
SCTYP TYPE STRING,
FCODE TYPE STRING,
TAB_VARI TYPE STRING,
TAB_TEXT TYPE STRING,
GRIDNR TYPE STRING,
FLG_USED_FOR TYPE STRING,
PLBEG TYPE STRING,
REPER TYPE STRING,
HINPU TYPE STRING,
FPRAST TYPE STRING,
HPRAST TYPE STRING,
PERLY TYPE STRING,
FLG_NO_H_INPUT TYPE STRING,
FIRSTCIN TYPE STRING,
FLG_NO_H_VISIBLE TYPE STRING,
FIRSTVIS TYPE STRING,
FORM_ID TYPE STRING,
CDAT TYPE STRING,
CTIME TYPE STRING,
AUTOR TYPE STRING,
UDAT TYPE STRING,
UPNAM TYPE STRING,
UTIME TYPE STRING,
GRID TYPE STRING,
CHART TYPE STRING,
STATUSBAR TYPE STRING,
HIDDEN_LIST TYPE STRING,
GRID_LOCKED TYPE STRING,
NOAUTO_POPUP TYPE STRING,
NOMOVE_ALLOWED TYPE STRING,
NORESIZE_ALLOWED TYPE STRING,
DRAGDROP_ALLOWED TYPE STRING,
SINGLEVALUE TYPE STRING,
VIEW3D TYPE STRING,
BGCOLOR TYPE STRING,
FLG_BY_RGB TYPE STRING,
BGCOLOR_R TYPE STRING,
BGCOLOR_G TYPE STRING,
BGCOLOR_B TYPE STRING,
GRIDLINE_COLOR TYPE STRING,
BGCOLOR_LT TYPE STRING,
FGCOLOR_LT TYPE STRING,
BGCOLOR_RB TYPE STRING,
FGCOLOR_RB TYPE STRING,
FONT_LT TYPE STRING,
FONT_RB TYPE STRING,
SWITCHED TYPE STRING,
ZOOMED TYPE STRING,
FIRST_COL TYPE STRING,
FIRST_ROW TYPE STRING,
EXPERT TYPE STRING,
TITEL TYPE STRING,
TITELTEXT TYPE STRING,
LEGENDE TYPE STRING,
CHART_TYPE TYPE STRING,
NO_AUTOMIN TYPE STRING,
MINVALUE TYPE STRING,
NO_AUTOMAX TYPE STRING,
MAXVALUE TYPE STRING,
MINRANGE TYPE STRING,
MAXRANGE TYPE STRING,
OPTIMUM TYPE STRING,
LABELCOL_WIDTH TYPE STRING,
LAYOUT_MODE TYPE STRING,
FLG_INIT TYPE STRING,
BORDER_DIST TYPE STRING,
EVENT_DELAY TYPE STRING,
CHANGE_CONTROL TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/SAPAPO/PBDVIEW_TAB_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_/SAPAPO/PBDVIEW_TAB_STR-LAYOUT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-SCTYP sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FCODE sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-TAB_VARI sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-TAB_TEXT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-GRIDNR sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FLG_USED_FOR sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-PLBEG sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-REPER sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-HINPU sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FPRAST sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-HPRAST sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-PERLY sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FLG_NO_H_INPUT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FIRSTCIN sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FLG_NO_H_VISIBLE sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FIRSTVIS sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FORM_ID sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-CDAT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-CTIME sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-AUTOR sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-UDAT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-UPNAM sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-UTIME sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-GRID sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-CHART sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-STATUSBAR sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-HIDDEN_LIST sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-GRID_LOCKED sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-NOAUTO_POPUP sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-NOMOVE_ALLOWED sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-NORESIZE_ALLOWED sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-DRAGDROP_ALLOWED sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-SINGLEVALUE sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-VIEW3D sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-BGCOLOR sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FLG_BY_RGB sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-BGCOLOR_R sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-BGCOLOR_G sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-BGCOLOR_B sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-GRIDLINE_COLOR sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-BGCOLOR_LT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FGCOLOR_LT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-BGCOLOR_RB sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FGCOLOR_RB sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FONT_LT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FONT_RB sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-SWITCHED sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-ZOOMED sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FIRST_COL sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FIRST_ROW sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-EXPERT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-TITEL sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-TITELTEXT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-LEGENDE sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-CHART_TYPE sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-NO_AUTOMIN sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-MINVALUE sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-NO_AUTOMAX sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-MAXVALUE sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-MINRANGE sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-MAXRANGE sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-OPTIMUM sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-LABELCOL_WIDTH sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-LAYOUT_MODE sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-FLG_INIT sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-BORDER_DIST sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-EVENT_DELAY sy-vline 
WA_/SAPAPO/PBDVIEW_TAB_STR-CHANGE_CONTROL sy-vline      INTO ld_text SEPARATED BY SPACE.

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