ABAP Select data from SAP table SINOBJATTR 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 SINOBJATTR 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 SINOBJATTR. 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 SINOBJATTR 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_SINOBJATTR TYPE STANDARD TABLE OF SINOBJATTR,
      WA_SINOBJATTR TYPE SINOBJATTR,
      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: <SINOBJATTR> TYPE SINOBJATTR.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM SINOBJATTR
*  INTO TABLE @DATA(IT_SINOBJATTR2).
*--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_SINOBJATTR INDEX 1 INTO DATA(WA_SINOBJATTR2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<SINOBJATTR>-MANDT = 1.
<SINOBJATTR>-SEL = 1.
<SINOBJATTR>-SEL1 = 1.
<SINOBJATTR>-POS = 1.
<SINOBJATTR>-FOLRG = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_SINOBJATTR-RSYSTEM, sy-vline,
  WA_SINOBJATTR-RFCDES, sy-vline,
  WA_SINOBJATTR-CLASS, sy-vline,
  WA_SINOBJATTR-CLDES, sy-vline,
  WA_SINOBJATTR-OBJTP, sy-vline,
  WA_SINOBJATTR-TPDES, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_SINOBJATTR 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_SINOBJATTR 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_SINOBJATTR INTO WA_SINOBJATTR.


*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 ISOLA, internal->external for field OBJLA
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_SINOBJATTR-OBJLA
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SINOBJATTR-OBJLA.
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_SINOBJATTR_STR, 
MANDT TYPE STRING,
SEL TYPE STRING,
SEL1 TYPE STRING,
POS TYPE STRING,
FOLRG TYPE STRING,
RSYSTEM TYPE STRING,
RFCDES TYPE STRING,
CLASS TYPE STRING,
CLDES TYPE STRING,
OBJTP TYPE STRING,
TPDES TYPE STRING,
OBJNAM TYPE STRING,
OBJDES TYPE STRING,
INDAT TYPE STRING,
INTIM TYPE STRING,
CRDAT TYPE STRING,
CRTIM TYPE STRING,
REDAT TYPE STRING,
RETIM TYPE STRING,
CHDAT TYPE STRING,
CHTIM TYPE STRING,
OBJPR TYPE STRING,
RECPR TYPE STRING,
FORADR TYPE STRING,
CRADR TYPE STRING,
ACDAT TYPE STRING,
ACTIM TYPE STRING,
OWNTP TYPE STRING,
STATSO TYPE STRING,
STATWF TYPE STRING,
PROCESS TYPE STRING,
OBJAC TYPE STRING,
ACDO TYPE STRING,
ATTACH TYPE STRING,
WIOBJID TYPE STRING,
WIOBJID_K TYPE STRING,
GROUPID TYPE STRING,
GROUPID_K TYPE STRING,
WIREJECT TYPE STRING,
TASK TYPE STRING,
DHSTAT TYPE STRING,
DISTRIB TYPE STRING,
TOLATE TYPE STRING,
SUBST TYPE STRING,
OBJSND TYPE STRING,
OBJCHN TYPE STRING,
OBJRD TYPE STRING,
RESUB TYPE STRING,
SNDEX TYPE STRING,
SNDCP TYPE STRING,
SNDBC TYPE STRING,
OBJRR TYPE STRING,
PRIFB TYPE STRING,
FORFB TYPE STRING,
OBJLA TYPE STRING,
RECCNT TYPE STRING,
RRDCNT TYPE STRING,
RRRCNT TYPE STRING,
RRPCNT TYPE STRING,
RARCNT TYPE STRING,
RAPCNT TYPE STRING,
RATCNT TYPE STRING,
RCPCNT TYPE STRING,
RBCCNT TYPE STRING,
SDDAT TYPE STRING,
SDTIM TYPE STRING,
RBDAT TYPE STRING,
RBTIM TYPE STRING,
FOLNAM TYPE STRING,
FOLDES TYPE STRING,
OBJRS TYPE STRING,
DLDAT TYPE STRING,
OBJLEN TYPE STRING,
FOLRGTP TYPE STRING,
CLDEP TYPE STRING,
DYNCOL1 TYPE STRING,
DYNCOL2 TYPE STRING,
DYNCOL3 TYPE STRING,
DYNCOL4 TYPE STRING,
DYNCOL5 TYPE STRING,
DYNCOL6 TYPE STRING,
DYNTYP1 TYPE STRING,
DYNTYP2 TYPE STRING,
DYNTYP3 TYPE STRING,
DYNTYP4 TYPE STRING,
DYNTYP5 TYPE STRING,
DYNTYP6 TYPE STRING,
DYNLEN1 TYPE STRING,
DYNLEN2 TYPE STRING,
DYNLEN3 TYPE STRING,
DYNLEN4 TYPE STRING,
DYNLEN5 TYPE STRING,
DYNLEN6 TYPE STRING,
CRADR_X TYPE STRING,
FORADR_X TYPE STRING,
WLC_DISPL TYPE STRING,
WF_TYPE TYPE STRING,
WI_CLASS TYPE STRING,
TOP_WI_ID TYPE STRING,
DEF_GUID TYPE STRING,
EXEC_TIME TYPE STRING,
NOTE_COUNT TYPE STRING,
PRS_PROFIL TYPE STRING,
CREA_TMP TYPE STRING,
CHECK_STAT TYPE STRING,
DYNCOL7 TYPE STRING,
DYNCOL8 TYPE STRING,
DYNCOL9 TYPE STRING,
DYNCOL10 TYPE STRING,
DYNCOL11 TYPE STRING,
DYNCOL12 TYPE STRING,
DYNTYP7 TYPE STRING,
DYNTYP8 TYPE STRING,
DYNTYP9 TYPE STRING,
DYNTYP10 TYPE STRING,
DYNTYP11 TYPE STRING,
DYNTYP12 TYPE STRING,
DYNLEN7 TYPE STRING,
DYNLEN8 TYPE STRING,
DYNLEN9 TYPE STRING,
DYNLEN10 TYPE STRING,
DYNLEN11 TYPE STRING,
DYNLEN12 TYPE STRING,
DYNCOL13 TYPE STRING,
DYNCOL14 TYPE STRING,
DYNCOL15 TYPE STRING,
DYNCOL16 TYPE STRING,
DYNCOL17 TYPE STRING,
DYNCOL18 TYPE STRING,
DYNCOL19 TYPE STRING,
DYNCOL20 TYPE STRING,
DYNTYP13 TYPE STRING,
DYNTYP14 TYPE STRING,
DYNTYP15 TYPE STRING,
DYNTYP16 TYPE STRING,
DYNTYP17 TYPE STRING,
DYNTYP18 TYPE STRING,
DYNTYP19 TYPE STRING,
DYNTYP20 TYPE STRING,
DYNLEN13 TYPE STRING,
DYNLEN14 TYPE STRING,
DYNLEN15 TYPE STRING,
DYNLEN16 TYPE STRING,
DYNLEN17 TYPE STRING,
DYNLEN18 TYPE STRING,
DYNLEN19 TYPE STRING,
DYNLEN20 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_SINOBJATTR_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_SINOBJATTR_STR-MANDT sy-vline 
WA_SINOBJATTR_STR-SEL sy-vline 
WA_SINOBJATTR_STR-SEL1 sy-vline 
WA_SINOBJATTR_STR-POS sy-vline 
WA_SINOBJATTR_STR-FOLRG sy-vline 
WA_SINOBJATTR_STR-RSYSTEM sy-vline 
WA_SINOBJATTR_STR-RFCDES sy-vline 
WA_SINOBJATTR_STR-CLASS sy-vline 
WA_SINOBJATTR_STR-CLDES sy-vline 
WA_SINOBJATTR_STR-OBJTP sy-vline 
WA_SINOBJATTR_STR-TPDES sy-vline 
WA_SINOBJATTR_STR-OBJNAM sy-vline 
WA_SINOBJATTR_STR-OBJDES sy-vline 
WA_SINOBJATTR_STR-INDAT sy-vline 
WA_SINOBJATTR_STR-INTIM sy-vline 
WA_SINOBJATTR_STR-CRDAT sy-vline 
WA_SINOBJATTR_STR-CRTIM sy-vline 
WA_SINOBJATTR_STR-REDAT sy-vline 
WA_SINOBJATTR_STR-RETIM sy-vline 
WA_SINOBJATTR_STR-CHDAT sy-vline 
WA_SINOBJATTR_STR-CHTIM sy-vline 
WA_SINOBJATTR_STR-OBJPR sy-vline 
WA_SINOBJATTR_STR-RECPR sy-vline 
WA_SINOBJATTR_STR-FORADR sy-vline 
WA_SINOBJATTR_STR-CRADR sy-vline 
WA_SINOBJATTR_STR-ACDAT sy-vline 
WA_SINOBJATTR_STR-ACTIM sy-vline 
WA_SINOBJATTR_STR-OWNTP sy-vline 
WA_SINOBJATTR_STR-STATSO sy-vline 
WA_SINOBJATTR_STR-STATWF sy-vline 
WA_SINOBJATTR_STR-PROCESS sy-vline 
WA_SINOBJATTR_STR-OBJAC sy-vline 
WA_SINOBJATTR_STR-ACDO sy-vline 
WA_SINOBJATTR_STR-ATTACH sy-vline 
WA_SINOBJATTR_STR-WIOBJID sy-vline 
WA_SINOBJATTR_STR-WIOBJID_K sy-vline 
WA_SINOBJATTR_STR-GROUPID sy-vline 
WA_SINOBJATTR_STR-GROUPID_K sy-vline 
WA_SINOBJATTR_STR-WIREJECT sy-vline 
WA_SINOBJATTR_STR-TASK sy-vline 
WA_SINOBJATTR_STR-DHSTAT sy-vline 
WA_SINOBJATTR_STR-DISTRIB sy-vline 
WA_SINOBJATTR_STR-TOLATE sy-vline 
WA_SINOBJATTR_STR-SUBST sy-vline 
WA_SINOBJATTR_STR-OBJSND sy-vline 
WA_SINOBJATTR_STR-OBJCHN sy-vline 
WA_SINOBJATTR_STR-OBJRD sy-vline 
WA_SINOBJATTR_STR-RESUB sy-vline 
WA_SINOBJATTR_STR-SNDEX sy-vline 
WA_SINOBJATTR_STR-SNDCP sy-vline 
WA_SINOBJATTR_STR-SNDBC sy-vline 
WA_SINOBJATTR_STR-OBJRR sy-vline 
WA_SINOBJATTR_STR-PRIFB sy-vline 
WA_SINOBJATTR_STR-FORFB sy-vline 
WA_SINOBJATTR_STR-OBJLA sy-vline 
WA_SINOBJATTR_STR-RECCNT sy-vline 
WA_SINOBJATTR_STR-RRDCNT sy-vline 
WA_SINOBJATTR_STR-RRRCNT sy-vline 
WA_SINOBJATTR_STR-RRPCNT sy-vline 
WA_SINOBJATTR_STR-RARCNT sy-vline 
WA_SINOBJATTR_STR-RAPCNT sy-vline 
WA_SINOBJATTR_STR-RATCNT sy-vline 
WA_SINOBJATTR_STR-RCPCNT sy-vline 
WA_SINOBJATTR_STR-RBCCNT sy-vline 
WA_SINOBJATTR_STR-SDDAT sy-vline 
WA_SINOBJATTR_STR-SDTIM sy-vline 
WA_SINOBJATTR_STR-RBDAT sy-vline 
WA_SINOBJATTR_STR-RBTIM sy-vline 
WA_SINOBJATTR_STR-FOLNAM sy-vline 
WA_SINOBJATTR_STR-FOLDES sy-vline 
WA_SINOBJATTR_STR-OBJRS sy-vline 
WA_SINOBJATTR_STR-DLDAT sy-vline 
WA_SINOBJATTR_STR-OBJLEN sy-vline 
WA_SINOBJATTR_STR-FOLRGTP sy-vline 
WA_SINOBJATTR_STR-CLDEP sy-vline 
WA_SINOBJATTR_STR-DYNCOL1 sy-vline 
WA_SINOBJATTR_STR-DYNCOL2 sy-vline 
WA_SINOBJATTR_STR-DYNCOL3 sy-vline 
WA_SINOBJATTR_STR-DYNCOL4 sy-vline 
WA_SINOBJATTR_STR-DYNCOL5 sy-vline 
WA_SINOBJATTR_STR-DYNCOL6 sy-vline 
WA_SINOBJATTR_STR-DYNTYP1 sy-vline 
WA_SINOBJATTR_STR-DYNTYP2 sy-vline 
WA_SINOBJATTR_STR-DYNTYP3 sy-vline 
WA_SINOBJATTR_STR-DYNTYP4 sy-vline 
WA_SINOBJATTR_STR-DYNTYP5 sy-vline 
WA_SINOBJATTR_STR-DYNTYP6 sy-vline 
WA_SINOBJATTR_STR-DYNLEN1 sy-vline 
WA_SINOBJATTR_STR-DYNLEN2 sy-vline 
WA_SINOBJATTR_STR-DYNLEN3 sy-vline 
WA_SINOBJATTR_STR-DYNLEN4 sy-vline 
WA_SINOBJATTR_STR-DYNLEN5 sy-vline 
WA_SINOBJATTR_STR-DYNLEN6 sy-vline 
WA_SINOBJATTR_STR-CRADR_X sy-vline 
WA_SINOBJATTR_STR-FORADR_X sy-vline 
WA_SINOBJATTR_STR-WLC_DISPL sy-vline 
WA_SINOBJATTR_STR-WF_TYPE sy-vline 
WA_SINOBJATTR_STR-WI_CLASS sy-vline 
WA_SINOBJATTR_STR-TOP_WI_ID sy-vline 
WA_SINOBJATTR_STR-DEF_GUID sy-vline 
WA_SINOBJATTR_STR-EXEC_TIME sy-vline 
WA_SINOBJATTR_STR-NOTE_COUNT sy-vline 
WA_SINOBJATTR_STR-PRS_PROFIL sy-vline 
WA_SINOBJATTR_STR-CREA_TMP sy-vline 
WA_SINOBJATTR_STR-CHECK_STAT sy-vline 
WA_SINOBJATTR_STR-DYNCOL7 sy-vline 
WA_SINOBJATTR_STR-DYNCOL8 sy-vline 
WA_SINOBJATTR_STR-DYNCOL9 sy-vline 
WA_SINOBJATTR_STR-DYNCOL10 sy-vline 
WA_SINOBJATTR_STR-DYNCOL11 sy-vline 
WA_SINOBJATTR_STR-DYNCOL12 sy-vline 
WA_SINOBJATTR_STR-DYNTYP7 sy-vline 
WA_SINOBJATTR_STR-DYNTYP8 sy-vline 
WA_SINOBJATTR_STR-DYNTYP9 sy-vline 
WA_SINOBJATTR_STR-DYNTYP10 sy-vline 
WA_SINOBJATTR_STR-DYNTYP11 sy-vline 
WA_SINOBJATTR_STR-DYNTYP12 sy-vline 
WA_SINOBJATTR_STR-DYNLEN7 sy-vline 
WA_SINOBJATTR_STR-DYNLEN8 sy-vline 
WA_SINOBJATTR_STR-DYNLEN9 sy-vline 
WA_SINOBJATTR_STR-DYNLEN10 sy-vline 
WA_SINOBJATTR_STR-DYNLEN11 sy-vline 
WA_SINOBJATTR_STR-DYNLEN12 sy-vline 
WA_SINOBJATTR_STR-DYNCOL13 sy-vline 
WA_SINOBJATTR_STR-DYNCOL14 sy-vline 
WA_SINOBJATTR_STR-DYNCOL15 sy-vline 
WA_SINOBJATTR_STR-DYNCOL16 sy-vline 
WA_SINOBJATTR_STR-DYNCOL17 sy-vline 
WA_SINOBJATTR_STR-DYNCOL18 sy-vline 
WA_SINOBJATTR_STR-DYNCOL19 sy-vline 
WA_SINOBJATTR_STR-DYNCOL20 sy-vline 
WA_SINOBJATTR_STR-DYNTYP13 sy-vline 
WA_SINOBJATTR_STR-DYNTYP14 sy-vline 
WA_SINOBJATTR_STR-DYNTYP15 sy-vline 
WA_SINOBJATTR_STR-DYNTYP16 sy-vline 
WA_SINOBJATTR_STR-DYNTYP17 sy-vline 
WA_SINOBJATTR_STR-DYNTYP18 sy-vline 
WA_SINOBJATTR_STR-DYNTYP19 sy-vline 
WA_SINOBJATTR_STR-DYNTYP20 sy-vline 
WA_SINOBJATTR_STR-DYNLEN13 sy-vline 
WA_SINOBJATTR_STR-DYNLEN14 sy-vline 
WA_SINOBJATTR_STR-DYNLEN15 sy-vline 
WA_SINOBJATTR_STR-DYNLEN16 sy-vline 
WA_SINOBJATTR_STR-DYNLEN17 sy-vline 
WA_SINOBJATTR_STR-DYNLEN18 sy-vline 
WA_SINOBJATTR_STR-DYNLEN19 sy-vline 
WA_SINOBJATTR_STR-DYNLEN20 sy-vline      INTO ld_text SEPARATED BY SPACE.

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