ABAP Select data from SAP table PRU_4FSS_FORM_V3_TEXT 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 PRU_4FSS_FORM_V3_TEXT 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 PRU_4FSS_FORM_V3_TEXT. 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 PRU_4FSS_FORM_V3_TEXT 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_PRU_4FSS_FORM_V3_TEXT TYPE STANDARD TABLE OF PRU_4FSS_FORM_V3_TEXT,
      WA_PRU_4FSS_FORM_V3_TEXT TYPE PRU_4FSS_FORM_V3_TEXT,
      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: <PRU_4FSS_FORM_V3_TEXT> TYPE PRU_4FSS_FORM_V3_TEXT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM PRU_4FSS_FORM_V3_TEXT
*  INTO TABLE @DATA(IT_PRU_4FSS_FORM_V3_TEXT2).
*--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_PRU_4FSS_FORM_V3_TEXT INDEX 1 INTO DATA(WA_PRU_4FSS_FORM_V3_TEXT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<PRU_4FSS_FORM_V3_TEXT>-JUPER = 1.
<PRU_4FSS_FORM_V3_TEXT>-OBJID = 1.
<PRU_4FSS_FORM_V3_TEXT>-INSTL = 1.
<PRU_4FSS_FORM_V3_TEXT>-SOORT = 1.
<PRU_4FSS_FORM_V3_TEXT>-GPVAL = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_PRU_4FSS_FORM_V3_TEXT-HEAD, sy-vline,
  WA_PRU_4FSS_FORM_V3_TEXT-DATUM, sy-vline,
  WA_PRU_4FSS_FORM_V3_TEXT-FODAT, sy-vline,
  WA_PRU_4FSS_FORM_V3_TEXT-FOPER, sy-vline,
  WA_PRU_4FSS_FORM_V3_TEXT-MON, sy-vline,
  WA_PRU_4FSS_FORM_V3_TEXT-FOYAR, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_PRU_4FSS_FORM_V3_TEXT 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_PRU_4FSS_FORM_V3_TEXT 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_PRU_4FSS_FORM_V3_TEXT INTO WA_PRU_4FSS_FORM_V3_TEXT.


*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_PRU_4FSS_FORM_V3_TEXT_STR, 
JUPER TYPE STRING,
OBJID TYPE STRING,
INSTL TYPE STRING,
SOORT TYPE STRING,
GPVAL TYPE STRING,
HEAD TYPE STRING,
DATUM TYPE STRING,
FODAT TYPE STRING,
FOPER TYPE STRING,
MON TYPE STRING,
FOYAR TYPE STRING,
FIOBH TYPE STRING,
FIOMN TYPE STRING,
NMCOR TYPE STRING,
NMAPL TYPE STRING,
INRTP TYPE STRING,
RPDOC TYPE STRING,
ATDOC TYPE STRING,
FPPER TYPE STRING,
ER00 TYPE STRING,
OADR1 TYPE STRING,
OADR2 TYPE STRING,
OADR3 TYPE STRING,
OGRN TYPE STRING,
OKDP TYPE STRING,
OKFS TYPE STRING,
OKONH TYPE STRING,
OKOPF TYPE STRING,
OKPO TYPE STRING,
OKVED TYPE STRING,
ORGNA TYPE STRING,
ORINN TYPE STRING,
ORKPP TYPE STRING,
REGNO TYPE STRING,
OKFST TYPE STRING,
WRKVD TYPE STRING,
CONTC TYPE STRING,
SBCOD TYPE STRING,
REGN1 TYPE STRING,
OKATO TYPE STRING,
SFCOD TYPE STRING,
CONTN TYPE STRING,
CONTP TYPE STRING,
ENTPN TYPE STRING,
TAXRG TYPE STRING,
TXSRG TYPE STRING,
TXBRG TYPE STRING,
ELCMP TYPE STRING,
ISINV TYPE STRING,
ISBUD TYPE STRING,
BORTY TYPE STRING,
PRT1 TYPE STRING,
PRT2 TYPE STRING,
T8 TYPE STRING,
T8103 TYPE STRING,
T8104 TYPE STRING,
T8105 TYPE STRING,
T8106 TYPE STRING,
T8107 TYPE STRING,
T8108 TYPE STRING,
T8109 TYPE STRING,
T8110 TYPE STRING,
T8111 TYPE STRING,
T8112 TYPE STRING,
T8113 TYPE STRING,
T8114 TYPE STRING,
T8115 TYPE STRING,
T8116 TYPE STRING,
T8117 TYPE STRING,
T8118 TYPE STRING,
T8119 TYPE STRING,
T8120 TYPE STRING,
T8203 TYPE STRING,
T8204 TYPE STRING,
T8205 TYPE STRING,
T8206 TYPE STRING,
T8207 TYPE STRING,
T8208 TYPE STRING,
T8209 TYPE STRING,
T8210 TYPE STRING,
T8211 TYPE STRING,
T8215 TYPE STRING,
T8216 TYPE STRING,
T8217 TYPE STRING,
T8218 TYPE STRING,
T8219 TYPE STRING,
T8220 TYPE STRING,
T8303 TYPE STRING,
T8304 TYPE STRING,
T8305 TYPE STRING,
T8306 TYPE STRING,
T8307 TYPE STRING,
T8308 TYPE STRING,
T8309 TYPE STRING,
T8310 TYPE STRING,
T8311 TYPE STRING,
T8315 TYPE STRING,
T8316 TYPE STRING,
T8317 TYPE STRING,
T8403 TYPE STRING,
T8404 TYPE STRING,
T8405 TYPE STRING,
T8406 TYPE STRING,
T8407 TYPE STRING,
T8408 TYPE STRING,
T8409 TYPE STRING,
T8410 TYPE STRING,
T8411 TYPE STRING,
T8415 TYPE STRING,
T8416 TYPE STRING,
T8417 TYPE STRING,
T8503 TYPE STRING,
T8504 TYPE STRING,
T8505 TYPE STRING,
T8506 TYPE STRING,
T8507 TYPE STRING,
T8508 TYPE STRING,
T8509 TYPE STRING,
T8510 TYPE STRING,
T8511 TYPE STRING,
T8515 TYPE STRING,
T8516 TYPE STRING,
T8517 TYPE STRING,
T8603 TYPE STRING,
T8604 TYPE STRING,
T8605 TYPE STRING,
T8606 TYPE STRING,
T8607 TYPE STRING,
T8608 TYPE STRING,
T8609 TYPE STRING,
T8610 TYPE STRING,
T8611 TYPE STRING,
T8615 TYPE STRING,
T8616 TYPE STRING,
T8617 TYPE STRING,
T8703 TYPE STRING,
T8705 TYPE STRING,
T8706 TYPE STRING,
T8708 TYPE STRING,
T8709 TYPE STRING,
T8711 TYPE STRING,
T8712 TYPE STRING,
T8714 TYPE STRING,
T8715 TYPE STRING,
T8717 TYPE STRING,
T8718 TYPE STRING,
T8720 TYPE STRING,
PRT3 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_PRU_4FSS_FORM_V3_TEXT_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_PRU_4FSS_FORM_V3_TEXT_STR-JUPER sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OBJID sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-INSTL sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-SOORT sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-GPVAL sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-HEAD sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-DATUM sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-FODAT sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-FOPER sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-MON sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-FOYAR sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-FIOBH sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-FIOMN sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-NMCOR sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-NMAPL sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-INRTP sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-RPDOC sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-ATDOC sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-FPPER sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-ER00 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OADR1 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OADR2 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OADR3 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OGRN sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OKDP sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OKFS sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OKONH sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OKOPF sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OKPO sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OKVED sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-ORGNA sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-ORINN sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-ORKPP sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-REGNO sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OKFST sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-WRKVD sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-CONTC sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-SBCOD sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-REGN1 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-OKATO sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-SFCOD sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-CONTN sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-CONTP sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-ENTPN sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-TAXRG sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-TXSRG sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-TXBRG sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-ELCMP sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-ISINV sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-ISBUD sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-BORTY sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-PRT1 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-PRT2 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8103 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8104 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8105 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8106 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8107 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8108 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8109 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8110 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8111 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8112 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8113 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8114 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8115 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8116 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8117 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8118 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8119 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8120 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8203 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8204 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8205 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8206 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8207 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8208 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8209 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8210 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8211 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8215 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8216 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8217 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8218 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8219 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8220 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8303 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8304 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8305 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8306 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8307 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8308 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8309 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8310 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8311 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8315 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8316 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8317 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8403 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8404 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8405 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8406 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8407 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8408 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8409 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8410 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8411 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8415 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8416 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8417 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8503 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8504 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8505 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8506 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8507 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8508 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8509 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8510 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8511 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8515 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8516 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8517 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8603 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8604 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8605 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8606 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8607 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8608 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8609 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8610 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8611 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8615 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8616 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8617 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8703 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8705 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8706 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8708 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8709 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8711 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8712 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8714 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8715 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8717 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8718 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-T8720 sy-vline 
WA_PRU_4FSS_FORM_V3_TEXT_STR-PRT3 sy-vline      INTO ld_text SEPARATED BY SPACE.

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