ABAP Select data from SAP table JBSSTEFE 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 JBSSTEFE 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 JBSSTEFE. 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 JBSSTEFE 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_JBSSTEFE TYPE STANDARD TABLE OF JBSSTEFE,
      WA_JBSSTEFE TYPE JBSSTEFE,
      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: <JBSSTEFE> TYPE JBSSTEFE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM JBSSTEFE
*  INTO TABLE @DATA(IT_JBSSTEFE2).
*--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_JBSSTEFE INDEX 1 INTO DATA(WA_JBSSTEFE2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<JBSSTEFE>-SPGRUP = 1.
<JBSSTEFE>-SSART1 = 1.
<JBSSTEFE>-SSART2 = 1.
<JBSSTEFE>-SSART3 = 1.
<JBSSTEFE>-SSART4 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_JBSSTEFE-SSART5, sy-vline,
  WA_JBSSTEFE-SAMRFR, sy-vline,
  WA_JBSSTEFE-SAMRKZ, sy-vline,
  WA_JBSSTEFE-SAMRKR, sy-vline,
  WA_JBSSTEFE-SAMRSN, sy-vline,
  WA_JBSSTEFE-SBEBGB, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_JBSSTEFE 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_JBSSTEFE 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_JBSSTEFE INTO WA_JBSSTEFE.


*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.

*Conversion exit ALPHA, internal->external for field SKNEIN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_JBSSTEFE-SKNEIN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_JBSSTEFE-SKNEIN.
WRITE:/ 'New Value:', ld_input.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_JBSSTEFE_STR, 
SPGRUP TYPE STRING,
SSART1 TYPE STRING,
SSART2 TYPE STRING,
SSART3 TYPE STRING,
SSART4 TYPE STRING,
SSART5 TYPE STRING,
SAMRFR TYPE STRING,
SAMRKZ TYPE STRING,
SAMRKR TYPE STRING,
SAMRSN TYPE STRING,
SBEBGB TYPE STRING,
SBZLND TYPE STRING,
SGMPAP TYPE STRING,
SHYPKR TYPE STRING,
SKNLND TYPE STRING,
SKNSKZ TYPE STRING,
SSNDLZ TYPE STRING,
SREIHN TYPE STRING,
SSNDER TYPE STRING,
SVRARB TYPE STRING,
SVRBRT TYPE STRING,
SVRSIC TYPE STRING,
SWPART TYPE STRING,
SWPVRZ TYPE STRING,
SFNLFZ TYPE STRING,
SIA1PN TYPE STRING,
SIA3GE TYPE STRING,
SKTKLS TYPE STRING,
SMICRO TYPE STRING,
SWPVAL TYPE STRING,
SMRGIN TYPE STRING,
SRSAKT TYPE STRING,
SZUSKC TYPE STRING,
SUEBKZ TYPE STRING,
SABTRT TYPE STRING,
SEMITL TYPE STRING,
SGESAR TYPE STRING,
SKNZHL TYPE STRING,
SKZMEL TYPE STRING,
SLAUFG TYPE STRING,
SWPBRN TYPE STRING,
SWPEIN TYPE STRING,
SZABER TYPE STRING,
SSIART TYPE STRING,
SPFAND TYPE STRING,
SBONKD TYPE STRING,
SKUEFR TYPE STRING,
SKUEND TYPE STRING,
SMUTLD TYPE STRING,
S13AWV TYPE STRING,
SABZUG TYPE STRING,
SANART TYPE STRING,
SANWKA TYPE STRING,
SANWZ1 TYPE STRING,
SANWZ2 TYPE STRING,
SAUFRE TYPE STRING,
SBERBN TYPE STRING,
SBNKVR TYPE STRING,
SBOEKZ TYPE STRING,
SBOERS TYPE STRING,
SBUEKZ TYPE STRING,
SKDREF TYPE STRING,
SDUPLK TYPE STRING,
BUKRS TYPE STRING,
SEBENI TYPE STRING,
SFOART TYPE STRING,
SGEART TYPE STRING,
SGEMKR TYPE STRING,
SGEWKZ TYPE STRING,
SKNEIN TYPE STRING,
SKNSVR TYPE STRING,
SKNZKD TYPE STRING,
SKREDT TYPE STRING,
SKTART TYPE STRING,
SKTAUS TYPE STRING,
SKVKKZ TYPE STRING,
SLKFIN TYPE STRING,
SLNZON TYPE STRING,
SNDLLD TYPE STRING,
SNERWR TYPE STRING,
SNETAR TYPE STRING,
SNRANG TYPE STRING,
SRDISK TYPE STRING,
SREFIN TYPE STRING,
SRLAND TYPE STRING,
SSICHA TYPE STRING,
SSWPFZ TYPE STRING,
STRHND TYPE STRING,
SUTRAG TYPE STRING,
SVERWZ TYPE STRING,
SWPDIF TYPE STRING,
SWPDOP TYPE STRING,
SZNSAN TYPE STRING,
SZUSKZ TYPE STRING,
SGOLDD TYPE STRING,
SHANDW TYPE STRING,
SOPTMO TYPE STRING,
SKRART TYPE STRING,
SWEART TYPE STRING,
SDUPPF TYPE STRING,END OF T_EKKO_STR.
DATA: WA_JBSSTEFE_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_JBSSTEFE_STR-SPGRUP sy-vline 
WA_JBSSTEFE_STR-SSART1 sy-vline 
WA_JBSSTEFE_STR-SSART2 sy-vline 
WA_JBSSTEFE_STR-SSART3 sy-vline 
WA_JBSSTEFE_STR-SSART4 sy-vline 
WA_JBSSTEFE_STR-SSART5 sy-vline 
WA_JBSSTEFE_STR-SAMRFR sy-vline 
WA_JBSSTEFE_STR-SAMRKZ sy-vline 
WA_JBSSTEFE_STR-SAMRKR sy-vline 
WA_JBSSTEFE_STR-SAMRSN sy-vline 
WA_JBSSTEFE_STR-SBEBGB sy-vline 
WA_JBSSTEFE_STR-SBZLND sy-vline 
WA_JBSSTEFE_STR-SGMPAP sy-vline 
WA_JBSSTEFE_STR-SHYPKR sy-vline 
WA_JBSSTEFE_STR-SKNLND sy-vline 
WA_JBSSTEFE_STR-SKNSKZ sy-vline 
WA_JBSSTEFE_STR-SSNDLZ sy-vline 
WA_JBSSTEFE_STR-SREIHN sy-vline 
WA_JBSSTEFE_STR-SSNDER sy-vline 
WA_JBSSTEFE_STR-SVRARB sy-vline 
WA_JBSSTEFE_STR-SVRBRT sy-vline 
WA_JBSSTEFE_STR-SVRSIC sy-vline 
WA_JBSSTEFE_STR-SWPART sy-vline 
WA_JBSSTEFE_STR-SWPVRZ sy-vline 
WA_JBSSTEFE_STR-SFNLFZ sy-vline 
WA_JBSSTEFE_STR-SIA1PN sy-vline 
WA_JBSSTEFE_STR-SIA3GE sy-vline 
WA_JBSSTEFE_STR-SKTKLS sy-vline 
WA_JBSSTEFE_STR-SMICRO sy-vline 
WA_JBSSTEFE_STR-SWPVAL sy-vline 
WA_JBSSTEFE_STR-SMRGIN sy-vline 
WA_JBSSTEFE_STR-SRSAKT sy-vline 
WA_JBSSTEFE_STR-SZUSKC sy-vline 
WA_JBSSTEFE_STR-SUEBKZ sy-vline 
WA_JBSSTEFE_STR-SABTRT sy-vline 
WA_JBSSTEFE_STR-SEMITL sy-vline 
WA_JBSSTEFE_STR-SGESAR sy-vline 
WA_JBSSTEFE_STR-SKNZHL sy-vline 
WA_JBSSTEFE_STR-SKZMEL sy-vline 
WA_JBSSTEFE_STR-SLAUFG sy-vline 
WA_JBSSTEFE_STR-SWPBRN sy-vline 
WA_JBSSTEFE_STR-SWPEIN sy-vline 
WA_JBSSTEFE_STR-SZABER sy-vline 
WA_JBSSTEFE_STR-SSIART sy-vline 
WA_JBSSTEFE_STR-SPFAND sy-vline 
WA_JBSSTEFE_STR-SBONKD sy-vline 
WA_JBSSTEFE_STR-SKUEFR sy-vline 
WA_JBSSTEFE_STR-SKUEND sy-vline 
WA_JBSSTEFE_STR-SMUTLD sy-vline 
WA_JBSSTEFE_STR-S13AWV sy-vline 
WA_JBSSTEFE_STR-SABZUG sy-vline 
WA_JBSSTEFE_STR-SANART sy-vline 
WA_JBSSTEFE_STR-SANWKA sy-vline 
WA_JBSSTEFE_STR-SANWZ1 sy-vline 
WA_JBSSTEFE_STR-SANWZ2 sy-vline 
WA_JBSSTEFE_STR-SAUFRE sy-vline 
WA_JBSSTEFE_STR-SBERBN sy-vline 
WA_JBSSTEFE_STR-SBNKVR sy-vline 
WA_JBSSTEFE_STR-SBOEKZ sy-vline 
WA_JBSSTEFE_STR-SBOERS sy-vline 
WA_JBSSTEFE_STR-SBUEKZ sy-vline 
WA_JBSSTEFE_STR-SKDREF sy-vline 
WA_JBSSTEFE_STR-SDUPLK sy-vline 
WA_JBSSTEFE_STR-BUKRS sy-vline 
WA_JBSSTEFE_STR-SEBENI sy-vline 
WA_JBSSTEFE_STR-SFOART sy-vline 
WA_JBSSTEFE_STR-SGEART sy-vline 
WA_JBSSTEFE_STR-SGEMKR sy-vline 
WA_JBSSTEFE_STR-SGEWKZ sy-vline 
WA_JBSSTEFE_STR-SKNEIN sy-vline 
WA_JBSSTEFE_STR-SKNSVR sy-vline 
WA_JBSSTEFE_STR-SKNZKD sy-vline 
WA_JBSSTEFE_STR-SKREDT sy-vline 
WA_JBSSTEFE_STR-SKTART sy-vline 
WA_JBSSTEFE_STR-SKTAUS sy-vline 
WA_JBSSTEFE_STR-SKVKKZ sy-vline 
WA_JBSSTEFE_STR-SLKFIN sy-vline 
WA_JBSSTEFE_STR-SLNZON sy-vline 
WA_JBSSTEFE_STR-SNDLLD sy-vline 
WA_JBSSTEFE_STR-SNERWR sy-vline 
WA_JBSSTEFE_STR-SNETAR sy-vline 
WA_JBSSTEFE_STR-SNRANG sy-vline 
WA_JBSSTEFE_STR-SRDISK sy-vline 
WA_JBSSTEFE_STR-SREFIN sy-vline 
WA_JBSSTEFE_STR-SRLAND sy-vline 
WA_JBSSTEFE_STR-SSICHA sy-vline 
WA_JBSSTEFE_STR-SSWPFZ sy-vline 
WA_JBSSTEFE_STR-STRHND sy-vline 
WA_JBSSTEFE_STR-SUTRAG sy-vline 
WA_JBSSTEFE_STR-SVERWZ sy-vline 
WA_JBSSTEFE_STR-SWPDIF sy-vline 
WA_JBSSTEFE_STR-SWPDOP sy-vline 
WA_JBSSTEFE_STR-SZNSAN sy-vline 
WA_JBSSTEFE_STR-SZUSKZ sy-vline 
WA_JBSSTEFE_STR-SGOLDD sy-vline 
WA_JBSSTEFE_STR-SHANDW sy-vline 
WA_JBSSTEFE_STR-SOPTMO sy-vline 
WA_JBSSTEFE_STR-SKRART sy-vline 
WA_JBSSTEFE_STR-SWEART sy-vline 
WA_JBSSTEFE_STR-SDUPPF sy-vline      INTO ld_text SEPARATED BY SPACE.

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