ABAP Select data from SAP table SNIWE9 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 SNIWE9 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 SNIWE9. 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 SNIWE9 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_SNIWE9 TYPE STANDARD TABLE OF SNIWE9,
      WA_SNIWE9 TYPE SNIWE9,
      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: <SNIWE9> TYPE SNIWE9.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM SNIWE9
*  INTO TABLE @DATA(IT_SNIWE92).
*--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_SNIWE9 INDEX 1 INTO DATA(WA_SNIWE92).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<SNIWE9>-TITLE1 = 1.
<SNIWE9>-XCAB1 = 1.
<SNIWE9>-TITLE2 = 1.
<SNIWE9>-XCAB2 = 1.
<SNIWE9>-TITLE3 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_SNIWE9-XCAB3, sy-vline,
  WA_SNIWE9-TITLE4, sy-vline,
  WA_SNIWE9-XCAB4, sy-vline,
  WA_SNIWE9-TITLE5, sy-vline,
  WA_SNIWE9-XCAB5, sy-vline,
  WA_SNIWE9-TITLE6, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_SNIWE9 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_SNIWE9 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_SNIWE9 INTO WA_SNIWE9.


*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_SNIWE9_STR, 
TITLE1 TYPE STRING,
XCAB1 TYPE STRING,
TITLE2 TYPE STRING,
XCAB2 TYPE STRING,
TITLE3 TYPE STRING,
XCAB3 TYPE STRING,
TITLE4 TYPE STRING,
XCAB4 TYPE STRING,
TITLE5 TYPE STRING,
XCAB5 TYPE STRING,
TITLE6 TYPE STRING,
XCAB6 TYPE STRING,
CBPRS TYPE STRING,
NULLPRS1 TYPE STRING,
STUFES1 TYPE STRING,
CBPS1 TYPE STRING,
NULLPRS2 TYPE STRING,
STUFES2 TYPE STRING,
CVJBS TYPE STRING,
NULLPRS3 TYPE STRING,
STUFES3 TYPE STRING,
CBPRH TYPE STRING,
NULLPRH1 TYPE STRING,
STUFEH1 TYPE STRING,
CBPH1 TYPE STRING,
NULLPRH2 TYPE STRING,
STUFEH2 TYPE STRING,
CVJBH TYPE STRING,
NULLPRH3 TYPE STRING,
STUFEH3 TYPE STRING,
STEP1 TYPE STRING,
STEP2 TYPE STRING,
STEP3 TYPE STRING,
STEP4 TYPE STRING,
STEP5 TYPE STRING,
STEP6 TYPE STRING,
SBSTP1 TYPE STRING,
SBSTP2 TYPE STRING,
SBSTP3 TYPE STRING,
SBSTP4 TYPE STRING,
SBSTP5 TYPE STRING,
SBSTP6 TYPE STRING,
BBSTP0 TYPE STRING,
BBSTP1 TYPE STRING,
BBSTP2 TYPE STRING,
BBSTP3 TYPE STRING,
BBSTP4 TYPE STRING,
BBSTP5 TYPE STRING,
BBSTP6 TYPE STRING,
NONEG TYPE STRING,END OF T_EKKO_STR.
DATA: WA_SNIWE9_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_SNIWE9_STR-TITLE1 sy-vline 
WA_SNIWE9_STR-XCAB1 sy-vline 
WA_SNIWE9_STR-TITLE2 sy-vline 
WA_SNIWE9_STR-XCAB2 sy-vline 
WA_SNIWE9_STR-TITLE3 sy-vline 
WA_SNIWE9_STR-XCAB3 sy-vline 
WA_SNIWE9_STR-TITLE4 sy-vline 
WA_SNIWE9_STR-XCAB4 sy-vline 
WA_SNIWE9_STR-TITLE5 sy-vline 
WA_SNIWE9_STR-XCAB5 sy-vline 
WA_SNIWE9_STR-TITLE6 sy-vline 
WA_SNIWE9_STR-XCAB6 sy-vline 
WA_SNIWE9_STR-CBPRS sy-vline 
WA_SNIWE9_STR-NULLPRS1 sy-vline 
WA_SNIWE9_STR-STUFES1 sy-vline 
WA_SNIWE9_STR-CBPS1 sy-vline 
WA_SNIWE9_STR-NULLPRS2 sy-vline 
WA_SNIWE9_STR-STUFES2 sy-vline 
WA_SNIWE9_STR-CVJBS sy-vline 
WA_SNIWE9_STR-NULLPRS3 sy-vline 
WA_SNIWE9_STR-STUFES3 sy-vline 
WA_SNIWE9_STR-CBPRH sy-vline 
WA_SNIWE9_STR-NULLPRH1 sy-vline 
WA_SNIWE9_STR-STUFEH1 sy-vline 
WA_SNIWE9_STR-CBPH1 sy-vline 
WA_SNIWE9_STR-NULLPRH2 sy-vline 
WA_SNIWE9_STR-STUFEH2 sy-vline 
WA_SNIWE9_STR-CVJBH sy-vline 
WA_SNIWE9_STR-NULLPRH3 sy-vline 
WA_SNIWE9_STR-STUFEH3 sy-vline 
WA_SNIWE9_STR-STEP1 sy-vline 
WA_SNIWE9_STR-STEP2 sy-vline 
WA_SNIWE9_STR-STEP3 sy-vline 
WA_SNIWE9_STR-STEP4 sy-vline 
WA_SNIWE9_STR-STEP5 sy-vline 
WA_SNIWE9_STR-STEP6 sy-vline 
WA_SNIWE9_STR-SBSTP1 sy-vline 
WA_SNIWE9_STR-SBSTP2 sy-vline 
WA_SNIWE9_STR-SBSTP3 sy-vline 
WA_SNIWE9_STR-SBSTP4 sy-vline 
WA_SNIWE9_STR-SBSTP5 sy-vline 
WA_SNIWE9_STR-SBSTP6 sy-vline 
WA_SNIWE9_STR-BBSTP0 sy-vline 
WA_SNIWE9_STR-BBSTP1 sy-vline 
WA_SNIWE9_STR-BBSTP2 sy-vline 
WA_SNIWE9_STR-BBSTP3 sy-vline 
WA_SNIWE9_STR-BBSTP4 sy-vline 
WA_SNIWE9_STR-BBSTP5 sy-vline 
WA_SNIWE9_STR-BBSTP6 sy-vline 
WA_SNIWE9_STR-NONEG sy-vline      INTO ld_text SEPARATED BY SPACE.

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