ABAP Select data from SAP table SMYPUOROUX 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 SMYPUOROUX 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 SMYPUOROUX. 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 SMYPUOROUX 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_SMYPUOROUX TYPE STANDARD TABLE OF SMYPUOROUX,
      WA_SMYPUOROUX TYPE SMYPUOROUX,
      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: <SMYPUOROUX> TYPE SMYPUOROUX.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM SMYPUOROUX
*  INTO TABLE @DATA(IT_SMYPUOROUX2).
*--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_SMYPUOROUX INDEX 1 INTO DATA(WA_SMYPUOROUX2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<SMYPUOROUX>-ROWUUID = 1.
<SMYPUOROUX>-METHOD = 1.
<SMYPUOROUX>-DOC = 1.
<SMYPUOROUX>-ITEM = 1.
<SMYPUOROUX>-SCHED = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_SMYPUOROUX-MATERIAL, sy-vline,
  WA_SMYPUOROUX-PLANT, sy-vline,
  WA_SMYPUOROUX-STORAGELOC, sy-vline,
  WA_SMYPUOROUX-SP_STK_IND, sy-vline,
  WA_SMYPUOROUX-SPEC_STOCK, sy-vline,
  WA_SMYPUOROUX-SP_STK_EXP, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_SMYPUOROUX 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_SMYPUOROUX 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_SMYPUOROUX INTO WA_SMYPUOROUX.


*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_SMYPUOROUX_STR, 
ROWUUID TYPE STRING,
METHOD TYPE STRING,
DOC TYPE STRING,
ITEM TYPE STRING,
SCHED TYPE STRING,
MATERIAL TYPE STRING,
PLANT TYPE STRING,
STORAGELOC TYPE STRING,
SP_STK_IND TYPE STRING,
SPEC_STOCK TYPE STRING,
SP_STK_EXP TYPE STRING,
VENDOR TYPE STRING,
GR_PROC_TI TYPE STRING,
UNITOFMEAS TYPE STRING,
UOM_ISO TYPE STRING,
BATCH TYPE STRING,
QUANTITY TYPE STRING,
REQ_TSTAMP TYPE STRING,
FIXED TYPE STRING,
ATPCAT TYPE STRING,
RES_NO_O TYPE STRING,
RES_ITEM_O TYPE STRING,
PROC_TYPE TYPE STRING,
ORDID TYPE STRING,
SCHEDID TYPE STRING,
STLTY TYPE STRING,
STLNR TYPE STRING,
STLKN TYPE STRING,
STPOZ TYPE STRING,
STVKN TYPE STRING,
LOGCOMP TYPE STRING,
RES_NO TYPE STRING,
RES_ITEM TYPE STRING,
PURCH_ORG TYPE STRING,
CON_NUMBER TYPE STRING,
CON_ITEM TYPE STRING,
DOC_SRC TYPE STRING,
SUBCO TYPE STRING,
CONSI TYPE STRING,
CONF TYPE STRING,
CUOBJ TYPE STRING,
MATID TYPE STRING,
LOCID TYPE STRING,
CNVIN TYPE STRING,
STATUS TYPE STRING,
CONFQUANTO TYPE STRING,
XBLNR TYPE STRING,
CUOBJ_TYPE TYPE STRING,
CUOBJ_ID TYPE STRING,
ORDER_QUAN TYPE STRING,
REDUC_QUAN TYPE STRING,
FINAL_DELI TYPE STRING,
LOGQS TYPE STRING,
DOC_LOGSYS TYPE STRING,
CON_LOGSYS TYPE STRING,
SUPPL_VEND TYPE STRING,
CONF_QUAN TYPE STRING,
PRE_LOGSYS TYPE STRING,
PRE_DOC TYPE STRING,
PRE_ITEM TYPE STRING,
POSGUID TYPE STRING,
PAR_POSNR TYPE STRING,
PHANTOMFLG TYPE STRING,
RETURNFLG TYPE STRING,
INFO_ONLY TYPE STRING,
REL_TSTAMP TYPE STRING,
CONFQUANAC TYPE STRING,
CONF_VBELN TYPE STRING,
CONF_VBELP TYPE STRING,
XBLNR_ACT TYPE STRING,
CONFDATE TYPE STRING,
VERID TYPE STRING,
ORDNO TYPE STRING,
LOGSYSK TYPE STRING,
EKGRP TYPE STRING,
MATKL TYPE STRING,
KUNNR TYPE STRING,
LPRIO TYPE STRING,
VKORG TYPE STRING,
VTWEG TYPE STRING,
SPART TYPE STRING,
ATPCHECKED TYPE STRING,
ATPTRGUID TYPE STRING,
BOPSTATUS TYPE STRING,
R3_UPDCNTR TYPE STRING,
ALLOC_QUAN TYPE STRING,
PLANT_D TYPE STRING,
LIFNR TYPE STRING,
MEINS TYPE STRING,
LFIMG_BME TYPE STRING,
TOTQTY_POS TYPE STRING,
QTY_POST_B TYPE STRING,
TMSTTYPE TYPE STRING,
TMSTMP TYPE STRING,
TRATY TYPE STRING,
TRAID TYPE STRING,
MDIFF_COMPL TYPE STRING,
VBELN_REF TYPE STRING,
VBELP_REF TYPE STRING,
LIFEX TYPE STRING,
TMSTTYPE2 TYPE STRING,
TMSTMP2 TYPE STRING,
TMSTTYPE3 TYPE STRING,
TMSTMP3 TYPE STRING,
TMSTTYPE4 TYPE STRING,
TMSTMP4 TYPE STRING,
BOLNR TYPE STRING,
CUM_VEND TYPE STRING,
CUM_ITQS TYPE STRING,
CUM_SA TYPE STRING,
BUYTYPE_CODE TYPE STRING,
TTYPE TYPE STRING,
PRIOP TYPE STRING,
UPVOR TYPE STRING,
UPTYP TYPE STRING,
NO_NEW_SCHEDULING TYPE STRING,
REQ_QUANTITY TYPE STRING,
GROUP_ID TYPE STRING,
GROUP_NO TYPE STRING,
MBDAT TYPE STRING,
WADAT TYPE STRING,
ELDAT TYPE STRING,
ADVCODE TYPE STRING,
PRIO_REQ TYPE STRING,
XBLNR35 TYPE STRING,
XBLNR35_ACT TYPE STRING,
TDDAT TYPE STRING,
LDDAT TYPE STRING,
BSART TYPE STRING,
PSTYP TYPE STRING,
NO_SUBST TYPE STRING,
SCHED_BWLPROCESS TYPE STRING,
PARENT_POSGUID TYPE STRING,
UEBPO TYPE STRING,
REQPRF TYPE STRING,
RESMOD TYPE STRING,
PROCESS_TYPE TYPE STRING,
SCMPROC TYPE STRING,
PRREG TYPE STRING,
CQU_SAR TYPE STRING,
VSTEL TYPE STRING,
VSBED TYPE STRING,
NEW_SCHD_HDLG TYPE STRING,
SHLF_MIN TYPE STRING,
NO_REQ TYPE STRING,
GEO_ROUTE TYPE STRING,
ROUTE_GTS TYPE STRING,
GTS_IND TYPE STRING,
TSP TYPE STRING,
CD_LOCNO TYPE STRING,
CD_LOCTYPE TYPE STRING,
CIF_PROC TYPE STRING,
STOCKTYPE TYPE STRING,
FIXMG TYPE STRING,
CONF_REQ_RELEVANT TYPE STRING,
VEN_NAME1 TYPE STRING,
VEN_NAME2 TYPE STRING,
VEN_CITY1 TYPE STRING,
VEN_COUNTRY TYPE STRING,
ROUTE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_SMYPUOROUX_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_SMYPUOROUX_STR-ROWUUID sy-vline 
WA_SMYPUOROUX_STR-METHOD sy-vline 
WA_SMYPUOROUX_STR-DOC sy-vline 
WA_SMYPUOROUX_STR-ITEM sy-vline 
WA_SMYPUOROUX_STR-SCHED sy-vline 
WA_SMYPUOROUX_STR-MATERIAL sy-vline 
WA_SMYPUOROUX_STR-PLANT sy-vline 
WA_SMYPUOROUX_STR-STORAGELOC sy-vline 
WA_SMYPUOROUX_STR-SP_STK_IND sy-vline 
WA_SMYPUOROUX_STR-SPEC_STOCK sy-vline 
WA_SMYPUOROUX_STR-SP_STK_EXP sy-vline 
WA_SMYPUOROUX_STR-VENDOR sy-vline 
WA_SMYPUOROUX_STR-GR_PROC_TI sy-vline 
WA_SMYPUOROUX_STR-UNITOFMEAS sy-vline 
WA_SMYPUOROUX_STR-UOM_ISO sy-vline 
WA_SMYPUOROUX_STR-BATCH sy-vline 
WA_SMYPUOROUX_STR-QUANTITY sy-vline 
WA_SMYPUOROUX_STR-REQ_TSTAMP sy-vline 
WA_SMYPUOROUX_STR-FIXED sy-vline 
WA_SMYPUOROUX_STR-ATPCAT sy-vline 
WA_SMYPUOROUX_STR-RES_NO_O sy-vline 
WA_SMYPUOROUX_STR-RES_ITEM_O sy-vline 
WA_SMYPUOROUX_STR-PROC_TYPE sy-vline 
WA_SMYPUOROUX_STR-ORDID sy-vline 
WA_SMYPUOROUX_STR-SCHEDID sy-vline 
WA_SMYPUOROUX_STR-STLTY sy-vline 
WA_SMYPUOROUX_STR-STLNR sy-vline 
WA_SMYPUOROUX_STR-STLKN sy-vline 
WA_SMYPUOROUX_STR-STPOZ sy-vline 
WA_SMYPUOROUX_STR-STVKN sy-vline 
WA_SMYPUOROUX_STR-LOGCOMP sy-vline 
WA_SMYPUOROUX_STR-RES_NO sy-vline 
WA_SMYPUOROUX_STR-RES_ITEM sy-vline 
WA_SMYPUOROUX_STR-PURCH_ORG sy-vline 
WA_SMYPUOROUX_STR-CON_NUMBER sy-vline 
WA_SMYPUOROUX_STR-CON_ITEM sy-vline 
WA_SMYPUOROUX_STR-DOC_SRC sy-vline 
WA_SMYPUOROUX_STR-SUBCO sy-vline 
WA_SMYPUOROUX_STR-CONSI sy-vline 
WA_SMYPUOROUX_STR-CONF sy-vline 
WA_SMYPUOROUX_STR-CUOBJ sy-vline 
WA_SMYPUOROUX_STR-MATID sy-vline 
WA_SMYPUOROUX_STR-LOCID sy-vline 
WA_SMYPUOROUX_STR-CNVIN sy-vline 
WA_SMYPUOROUX_STR-STATUS sy-vline 
WA_SMYPUOROUX_STR-CONFQUANTO sy-vline 
WA_SMYPUOROUX_STR-XBLNR sy-vline 
WA_SMYPUOROUX_STR-CUOBJ_TYPE sy-vline 
WA_SMYPUOROUX_STR-CUOBJ_ID sy-vline 
WA_SMYPUOROUX_STR-ORDER_QUAN sy-vline 
WA_SMYPUOROUX_STR-REDUC_QUAN sy-vline 
WA_SMYPUOROUX_STR-FINAL_DELI sy-vline 
WA_SMYPUOROUX_STR-LOGQS sy-vline 
WA_SMYPUOROUX_STR-DOC_LOGSYS sy-vline 
WA_SMYPUOROUX_STR-CON_LOGSYS sy-vline 
WA_SMYPUOROUX_STR-SUPPL_VEND sy-vline 
WA_SMYPUOROUX_STR-CONF_QUAN sy-vline 
WA_SMYPUOROUX_STR-PRE_LOGSYS sy-vline 
WA_SMYPUOROUX_STR-PRE_DOC sy-vline 
WA_SMYPUOROUX_STR-PRE_ITEM sy-vline 
WA_SMYPUOROUX_STR-POSGUID sy-vline 
WA_SMYPUOROUX_STR-PAR_POSNR sy-vline 
WA_SMYPUOROUX_STR-PHANTOMFLG sy-vline 
WA_SMYPUOROUX_STR-RETURNFLG sy-vline 
WA_SMYPUOROUX_STR-INFO_ONLY sy-vline 
WA_SMYPUOROUX_STR-REL_TSTAMP sy-vline 
WA_SMYPUOROUX_STR-CONFQUANAC sy-vline 
WA_SMYPUOROUX_STR-CONF_VBELN sy-vline 
WA_SMYPUOROUX_STR-CONF_VBELP sy-vline 
WA_SMYPUOROUX_STR-XBLNR_ACT sy-vline 
WA_SMYPUOROUX_STR-CONFDATE sy-vline 
WA_SMYPUOROUX_STR-VERID sy-vline 
WA_SMYPUOROUX_STR-ORDNO sy-vline 
WA_SMYPUOROUX_STR-LOGSYSK sy-vline 
WA_SMYPUOROUX_STR-EKGRP sy-vline 
WA_SMYPUOROUX_STR-MATKL sy-vline 
WA_SMYPUOROUX_STR-KUNNR sy-vline 
WA_SMYPUOROUX_STR-LPRIO sy-vline 
WA_SMYPUOROUX_STR-VKORG sy-vline 
WA_SMYPUOROUX_STR-VTWEG sy-vline 
WA_SMYPUOROUX_STR-SPART sy-vline 
WA_SMYPUOROUX_STR-ATPCHECKED sy-vline 
WA_SMYPUOROUX_STR-ATPTRGUID sy-vline 
WA_SMYPUOROUX_STR-BOPSTATUS sy-vline 
WA_SMYPUOROUX_STR-R3_UPDCNTR sy-vline 
WA_SMYPUOROUX_STR-ALLOC_QUAN sy-vline 
WA_SMYPUOROUX_STR-PLANT_D sy-vline 
WA_SMYPUOROUX_STR-LIFNR sy-vline 
WA_SMYPUOROUX_STR-MEINS sy-vline 
WA_SMYPUOROUX_STR-LFIMG_BME sy-vline 
WA_SMYPUOROUX_STR-TOTQTY_POS sy-vline 
WA_SMYPUOROUX_STR-QTY_POST_B sy-vline 
WA_SMYPUOROUX_STR-TMSTTYPE sy-vline 
WA_SMYPUOROUX_STR-TMSTMP sy-vline 
WA_SMYPUOROUX_STR-TRATY sy-vline 
WA_SMYPUOROUX_STR-TRAID sy-vline 
WA_SMYPUOROUX_STR-MDIFF_COMPL sy-vline 
WA_SMYPUOROUX_STR-VBELN_REF sy-vline 
WA_SMYPUOROUX_STR-VBELP_REF sy-vline 
WA_SMYPUOROUX_STR-LIFEX sy-vline 
WA_SMYPUOROUX_STR-TMSTTYPE2 sy-vline 
WA_SMYPUOROUX_STR-TMSTMP2 sy-vline 
WA_SMYPUOROUX_STR-TMSTTYPE3 sy-vline 
WA_SMYPUOROUX_STR-TMSTMP3 sy-vline 
WA_SMYPUOROUX_STR-TMSTTYPE4 sy-vline 
WA_SMYPUOROUX_STR-TMSTMP4 sy-vline 
WA_SMYPUOROUX_STR-BOLNR sy-vline 
WA_SMYPUOROUX_STR-CUM_VEND sy-vline 
WA_SMYPUOROUX_STR-CUM_ITQS sy-vline 
WA_SMYPUOROUX_STR-CUM_SA sy-vline 
WA_SMYPUOROUX_STR-BUYTYPE_CODE sy-vline 
WA_SMYPUOROUX_STR-TTYPE sy-vline 
WA_SMYPUOROUX_STR-PRIOP sy-vline 
WA_SMYPUOROUX_STR-UPVOR sy-vline 
WA_SMYPUOROUX_STR-UPTYP sy-vline 
WA_SMYPUOROUX_STR-NO_NEW_SCHEDULING sy-vline 
WA_SMYPUOROUX_STR-REQ_QUANTITY sy-vline 
WA_SMYPUOROUX_STR-GROUP_ID sy-vline 
WA_SMYPUOROUX_STR-GROUP_NO sy-vline 
WA_SMYPUOROUX_STR-MBDAT sy-vline 
WA_SMYPUOROUX_STR-WADAT sy-vline 
WA_SMYPUOROUX_STR-ELDAT sy-vline 
WA_SMYPUOROUX_STR-ADVCODE sy-vline 
WA_SMYPUOROUX_STR-PRIO_REQ sy-vline 
WA_SMYPUOROUX_STR-XBLNR35 sy-vline 
WA_SMYPUOROUX_STR-XBLNR35_ACT sy-vline 
WA_SMYPUOROUX_STR-TDDAT sy-vline 
WA_SMYPUOROUX_STR-LDDAT sy-vline 
WA_SMYPUOROUX_STR-BSART sy-vline 
WA_SMYPUOROUX_STR-PSTYP sy-vline 
WA_SMYPUOROUX_STR-NO_SUBST sy-vline 
WA_SMYPUOROUX_STR-SCHED_BWLPROCESS sy-vline 
WA_SMYPUOROUX_STR-PARENT_POSGUID sy-vline 
WA_SMYPUOROUX_STR-UEBPO sy-vline 
WA_SMYPUOROUX_STR-REQPRF sy-vline 
WA_SMYPUOROUX_STR-RESMOD sy-vline 
WA_SMYPUOROUX_STR-PROCESS_TYPE sy-vline 
WA_SMYPUOROUX_STR-SCMPROC sy-vline 
WA_SMYPUOROUX_STR-PRREG sy-vline 
WA_SMYPUOROUX_STR-CQU_SAR sy-vline 
WA_SMYPUOROUX_STR-VSTEL sy-vline 
WA_SMYPUOROUX_STR-VSBED sy-vline 
WA_SMYPUOROUX_STR-NEW_SCHD_HDLG sy-vline 
WA_SMYPUOROUX_STR-SHLF_MIN sy-vline 
WA_SMYPUOROUX_STR-NO_REQ sy-vline 
WA_SMYPUOROUX_STR-GEO_ROUTE sy-vline 
WA_SMYPUOROUX_STR-ROUTE_GTS sy-vline 
WA_SMYPUOROUX_STR-GTS_IND sy-vline 
WA_SMYPUOROUX_STR-TSP sy-vline 
WA_SMYPUOROUX_STR-CD_LOCNO sy-vline 
WA_SMYPUOROUX_STR-CD_LOCTYPE sy-vline 
WA_SMYPUOROUX_STR-CIF_PROC sy-vline 
WA_SMYPUOROUX_STR-STOCKTYPE sy-vline 
WA_SMYPUOROUX_STR-FIXMG sy-vline 
WA_SMYPUOROUX_STR-CONF_REQ_RELEVANT sy-vline 
WA_SMYPUOROUX_STR-VEN_NAME1 sy-vline 
WA_SMYPUOROUX_STR-VEN_NAME2 sy-vline 
WA_SMYPUOROUX_STR-VEN_CITY1 sy-vline 
WA_SMYPUOROUX_STR-VEN_COUNTRY sy-vline 
WA_SMYPUOROUX_STR-ROUTE sy-vline      INTO ld_text SEPARATED BY SPACE.

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