ABAP Select data from SAP table UASTPOX 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 UASTPOX 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 UASTPOX. 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 UASTPOX 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_UASTPOX TYPE STANDARD TABLE OF UASTPOX,
      WA_UASTPOX TYPE UASTPOX,
      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: <UASTPOX> TYPE UASTPOX.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM UASTPOX
*  INTO TABLE @DATA(IT_UASTPOX2).
*--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_UASTPOX INDEX 1 INTO DATA(WA_UASTPOX2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<UASTPOX>-STUFE = 1.
<UASTPOX>-WEGXX = 1.
<UASTPOX>-BMTYP = 1.
<UASTPOX>-TTIDX = 1.
<UASTPOX>-VWEGX = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_UASTPOX-OJTXB, sy-vline,
  WA_UASTPOX-BAUSF, sy-vline,
  WA_UASTPOX-STLAN, sy-vline,
  WA_UASTPOX-STLAL, sy-vline,
  WA_UASTPOX-ALTST, sy-vline,
  WA_UASTPOX-VARST, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_UASTPOX 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_UASTPOX 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_UASTPOX INTO WA_UASTPOX.


*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_UASTPOX_STR, 
STUFE TYPE STRING,
WEGXX TYPE STRING,
BMTYP TYPE STRING,
TTIDX TYPE STRING,
VWEGX TYPE STRING,
OJTXB TYPE STRING,
BAUSF TYPE STRING,
STLAN TYPE STRING,
STLAL TYPE STRING,
ALTST TYPE STRING,
VARST TYPE STRING,
KBAUS TYPE STRING,
LOEKZ TYPE STRING,
OJTXP TYPE STRING,
MTART TYPE STRING,
WERKS TYPE STRING,
VERID TYPE STRING,
VPSTA TYPE STRING,
FSTAT TYPE STRING,
MMEIN TYPE STRING,
BWTTY TYPE STRING,
VPRSV TYPE STRING,
STPRS TYPE STRING,
VERPR TYPE STRING,
PREIH TYPE STRING,
SBDKZ TYPE STRING,
XCHAR TYPE STRING,
KZECH TYPE STRING,
KZWSM TYPE STRING,
MMSTA TYPE STRING,
MMSTD TYPE STRING,
MSTAE TYPE STRING,
MSTDE TYPE STRING,
ZEINR TYPE STRING,
ZEIVR TYPE STRING,
ZEIAR TYPE STRING,
ZEIFO TYPE STRING,
BLATT TYPE STRING,
BLANZ TYPE STRING,
DISST TYPE STRING,
DISMM TYPE STRING,
SERNP TYPE STRING,
MNGLG TYPE STRING,
MNGKO TYPE STRING,
MSIGN TYPE STRING,
AUSSS TYPE STRING,
KAUSF TYPE STRING,
SOBSL TYPE STRING,
SOBSK TYPE STRING,
KZAUS TYPE STRING,
AUSDT TYPE STRING,
NFMAT TYPE STRING,
RGEKZ TYPE STRING,
KZDKZ TYPE STRING,
UMREZ TYPE STRING,
UMREN TYPE STRING,
LGPRO TYPE STRING,
PRCTR TYPE STRING,
REVLV TYPE STRING,
KZEFF TYPE STRING,
KZKFG TYPE STRING,
MCUOB TYPE STRING,
CUOBJ TYPE STRING,
NCONF TYPE STRING,
FBSKZ TYPE STRING,
STAWN TYPE STRING,
PREFE TYPE STRING,
MSCHG TYPE STRING,
FXPRU TYPE STRING,
MATMK TYPE STRING,
STABK TYPE STRING,
DOSTX TYPE STRING,
STLTY TYPE STRING,
STLNR TYPE STRING,
STLKN TYPE STRING,
STPOZ TYPE STRING,
STVKN TYPE STRING,
DATUV TYPE STRING,
TECHV TYPE STRING,
AENNR TYPE STRING,
ANDAT TYPE STRING,
ANNAM TYPE STRING,
AEDAT TYPE STRING,
AENAM TYPE STRING,
IDNRK TYPE STRING,
PSWRK TYPE STRING,
POSTP TYPE STRING,
POSNR TYPE STRING,
SORTF TYPE STRING,
MEINS TYPE STRING,
MENGE TYPE STRING,
FMENG TYPE STRING,
AUSCH TYPE STRING,
AVOAU TYPE STRING,
NETAU TYPE STRING,
SCHGT TYPE STRING,
BEIKZ TYPE STRING,
ERSKZ TYPE STRING,
RVREL TYPE STRING,
SANFE TYPE STRING,
SANIN TYPE STRING,
SANKA TYPE STRING,
SANKO TYPE STRING,
SANVS TYPE STRING,
STKKZ TYPE STRING,
REKRI TYPE STRING,
REKRS TYPE STRING,
CADPO TYPE STRING,
NLFZT TYPE STRING,
NLFZV TYPE STRING,
NLFMV TYPE STRING,
VERTI TYPE STRING,
ALPOS TYPE STRING,
EWAHR TYPE STRING,
EKGRP TYPE STRING,
LIFZT TYPE STRING,
LIFNR TYPE STRING,
PREIS TYPE STRING,
PEINH TYPE STRING,
WAERS TYPE STRING,
SAKTO TYPE STRING,
ROANZ TYPE STRING,
ROMS1 TYPE STRING,
ROMS2 TYPE STRING,
ROMS3 TYPE STRING,
ROMEI TYPE STRING,
ROMEN TYPE STRING,
RFORM TYPE STRING,
UPSKZ TYPE STRING,
LTXSP TYPE STRING,
POTX1 TYPE STRING,
POTX2 TYPE STRING,
OBJTY TYPE STRING,
ITMMK TYPE STRING,
WEBAZ TYPE STRING,
DOKAR TYPE STRING,
DOKNR TYPE STRING,
DOKVR TYPE STRING,
DOKTL TYPE STRING,
CSSTR TYPE STRING,
CLASS TYPE STRING,
KLART TYPE STRING,
INTRM TYPE STRING,
POTPR TYPE STRING,
EKORG TYPE STRING,
CLOBK TYPE STRING,
CLMUL TYPE STRING,
CVIEW TYPE STRING,
KNOBJ TYPE STRING,
LGORT TYPE STRING,
PRVBE TYPE STRING,
KZKUP TYPE STRING,
DATUB TYPE STRING,
AENRA TYPE STRING,
AMGLG TYPE STRING,
AMGKO TYPE STRING,
DUMPS TYPE STRING,
XTLTY TYPE STRING,
XTLNR TYPE STRING,
XTLAN TYPE STRING,
XTLAL TYPE STRING,
XISDT TYPE STRING,
XISSR TYPE STRING,
XMENG TYPE STRING,
XMEIN TYPE STRING,
XALTS TYPE STRING,
XVARS TYPE STRING,
XKBAU TYPE STRING,
XLOEK TYPE STRING,
AUSNM TYPE STRING,
HDNFO TYPE STRING,
AFFLG TYPE STRING,
LTFLG TYPE STRING,
NLFLG TYPE STRING,
INDEX TYPE STRING,
SUMKZ TYPE STRING,
AUFST TYPE STRING,
AUFWG TYPE STRING,
BAUST TYPE STRING,
BAUWG TYPE STRING,
ASTOV TYPE STRING,
AWGOV TYPE STRING,
BSTOV TYPE STRING,
BWGOV TYPE STRING,
NLINK TYPE STRING,
ALPST TYPE STRING,
ALPRF TYPE STRING,
ALPGR TYPE STRING,
DSPST TYPE STRING,
KZNFP TYPE STRING,
NFGRP TYPE STRING,
NFEAG TYPE STRING,
KZCLB TYPE STRING,
CLSZU TYPE STRING,
ITMID TYPE STRING,
ALEKZ TYPE STRING,
GUIDX TYPE STRING,
ITSOB TYPE STRING,
RFPNT TYPE STRING,
SOBMX TYPE STRING,
MATKL TYPE STRING,
INSTS TYPE STRING,
INSTP TYPE STRING,
KSTTY TYPE STRING,
KSTNR TYPE STRING,
KSTKN TYPE STRING,
KSTPZ TYPE STRING,
CAALT TYPE STRING,
STLTY_W TYPE STRING,
STLNR_W TYPE STRING,END OF T_EKKO_STR.
DATA: WA_UASTPOX_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_UASTPOX_STR-STUFE sy-vline 
WA_UASTPOX_STR-WEGXX sy-vline 
WA_UASTPOX_STR-BMTYP sy-vline 
WA_UASTPOX_STR-TTIDX sy-vline 
WA_UASTPOX_STR-VWEGX sy-vline 
WA_UASTPOX_STR-OJTXB sy-vline 
WA_UASTPOX_STR-BAUSF sy-vline 
WA_UASTPOX_STR-STLAN sy-vline 
WA_UASTPOX_STR-STLAL sy-vline 
WA_UASTPOX_STR-ALTST sy-vline 
WA_UASTPOX_STR-VARST sy-vline 
WA_UASTPOX_STR-KBAUS sy-vline 
WA_UASTPOX_STR-LOEKZ sy-vline 
WA_UASTPOX_STR-OJTXP sy-vline 
WA_UASTPOX_STR-MTART sy-vline 
WA_UASTPOX_STR-WERKS sy-vline 
WA_UASTPOX_STR-VERID sy-vline 
WA_UASTPOX_STR-VPSTA sy-vline 
WA_UASTPOX_STR-FSTAT sy-vline 
WA_UASTPOX_STR-MMEIN sy-vline 
WA_UASTPOX_STR-BWTTY sy-vline 
WA_UASTPOX_STR-VPRSV sy-vline 
WA_UASTPOX_STR-STPRS sy-vline 
WA_UASTPOX_STR-VERPR sy-vline 
WA_UASTPOX_STR-PREIH sy-vline 
WA_UASTPOX_STR-SBDKZ sy-vline 
WA_UASTPOX_STR-XCHAR sy-vline 
WA_UASTPOX_STR-KZECH sy-vline 
WA_UASTPOX_STR-KZWSM sy-vline 
WA_UASTPOX_STR-MMSTA sy-vline 
WA_UASTPOX_STR-MMSTD sy-vline 
WA_UASTPOX_STR-MSTAE sy-vline 
WA_UASTPOX_STR-MSTDE sy-vline 
WA_UASTPOX_STR-ZEINR sy-vline 
WA_UASTPOX_STR-ZEIVR sy-vline 
WA_UASTPOX_STR-ZEIAR sy-vline 
WA_UASTPOX_STR-ZEIFO sy-vline 
WA_UASTPOX_STR-BLATT sy-vline 
WA_UASTPOX_STR-BLANZ sy-vline 
WA_UASTPOX_STR-DISST sy-vline 
WA_UASTPOX_STR-DISMM sy-vline 
WA_UASTPOX_STR-SERNP sy-vline 
WA_UASTPOX_STR-MNGLG sy-vline 
WA_UASTPOX_STR-MNGKO sy-vline 
WA_UASTPOX_STR-MSIGN sy-vline 
WA_UASTPOX_STR-AUSSS sy-vline 
WA_UASTPOX_STR-KAUSF sy-vline 
WA_UASTPOX_STR-SOBSL sy-vline 
WA_UASTPOX_STR-SOBSK sy-vline 
WA_UASTPOX_STR-KZAUS sy-vline 
WA_UASTPOX_STR-AUSDT sy-vline 
WA_UASTPOX_STR-NFMAT sy-vline 
WA_UASTPOX_STR-RGEKZ sy-vline 
WA_UASTPOX_STR-KZDKZ sy-vline 
WA_UASTPOX_STR-UMREZ sy-vline 
WA_UASTPOX_STR-UMREN sy-vline 
WA_UASTPOX_STR-LGPRO sy-vline 
WA_UASTPOX_STR-PRCTR sy-vline 
WA_UASTPOX_STR-REVLV sy-vline 
WA_UASTPOX_STR-KZEFF sy-vline 
WA_UASTPOX_STR-KZKFG sy-vline 
WA_UASTPOX_STR-MCUOB sy-vline 
WA_UASTPOX_STR-CUOBJ sy-vline 
WA_UASTPOX_STR-NCONF sy-vline 
WA_UASTPOX_STR-FBSKZ sy-vline 
WA_UASTPOX_STR-STAWN sy-vline 
WA_UASTPOX_STR-PREFE sy-vline 
WA_UASTPOX_STR-MSCHG sy-vline 
WA_UASTPOX_STR-FXPRU sy-vline 
WA_UASTPOX_STR-MATMK sy-vline 
WA_UASTPOX_STR-STABK sy-vline 
WA_UASTPOX_STR-DOSTX sy-vline 
WA_UASTPOX_STR-STLTY sy-vline 
WA_UASTPOX_STR-STLNR sy-vline 
WA_UASTPOX_STR-STLKN sy-vline 
WA_UASTPOX_STR-STPOZ sy-vline 
WA_UASTPOX_STR-STVKN sy-vline 
WA_UASTPOX_STR-DATUV sy-vline 
WA_UASTPOX_STR-TECHV sy-vline 
WA_UASTPOX_STR-AENNR sy-vline 
WA_UASTPOX_STR-ANDAT sy-vline 
WA_UASTPOX_STR-ANNAM sy-vline 
WA_UASTPOX_STR-AEDAT sy-vline 
WA_UASTPOX_STR-AENAM sy-vline 
WA_UASTPOX_STR-IDNRK sy-vline 
WA_UASTPOX_STR-PSWRK sy-vline 
WA_UASTPOX_STR-POSTP sy-vline 
WA_UASTPOX_STR-POSNR sy-vline 
WA_UASTPOX_STR-SORTF sy-vline 
WA_UASTPOX_STR-MEINS sy-vline 
WA_UASTPOX_STR-MENGE sy-vline 
WA_UASTPOX_STR-FMENG sy-vline 
WA_UASTPOX_STR-AUSCH sy-vline 
WA_UASTPOX_STR-AVOAU sy-vline 
WA_UASTPOX_STR-NETAU sy-vline 
WA_UASTPOX_STR-SCHGT sy-vline 
WA_UASTPOX_STR-BEIKZ sy-vline 
WA_UASTPOX_STR-ERSKZ sy-vline 
WA_UASTPOX_STR-RVREL sy-vline 
WA_UASTPOX_STR-SANFE sy-vline 
WA_UASTPOX_STR-SANIN sy-vline 
WA_UASTPOX_STR-SANKA sy-vline 
WA_UASTPOX_STR-SANKO sy-vline 
WA_UASTPOX_STR-SANVS sy-vline 
WA_UASTPOX_STR-STKKZ sy-vline 
WA_UASTPOX_STR-REKRI sy-vline 
WA_UASTPOX_STR-REKRS sy-vline 
WA_UASTPOX_STR-CADPO sy-vline 
WA_UASTPOX_STR-NLFZT sy-vline 
WA_UASTPOX_STR-NLFZV sy-vline 
WA_UASTPOX_STR-NLFMV sy-vline 
WA_UASTPOX_STR-VERTI sy-vline 
WA_UASTPOX_STR-ALPOS sy-vline 
WA_UASTPOX_STR-EWAHR sy-vline 
WA_UASTPOX_STR-EKGRP sy-vline 
WA_UASTPOX_STR-LIFZT sy-vline 
WA_UASTPOX_STR-LIFNR sy-vline 
WA_UASTPOX_STR-PREIS sy-vline 
WA_UASTPOX_STR-PEINH sy-vline 
WA_UASTPOX_STR-WAERS sy-vline 
WA_UASTPOX_STR-SAKTO sy-vline 
WA_UASTPOX_STR-ROANZ sy-vline 
WA_UASTPOX_STR-ROMS1 sy-vline 
WA_UASTPOX_STR-ROMS2 sy-vline 
WA_UASTPOX_STR-ROMS3 sy-vline 
WA_UASTPOX_STR-ROMEI sy-vline 
WA_UASTPOX_STR-ROMEN sy-vline 
WA_UASTPOX_STR-RFORM sy-vline 
WA_UASTPOX_STR-UPSKZ sy-vline 
WA_UASTPOX_STR-LTXSP sy-vline 
WA_UASTPOX_STR-POTX1 sy-vline 
WA_UASTPOX_STR-POTX2 sy-vline 
WA_UASTPOX_STR-OBJTY sy-vline 
WA_UASTPOX_STR-ITMMK sy-vline 
WA_UASTPOX_STR-WEBAZ sy-vline 
WA_UASTPOX_STR-DOKAR sy-vline 
WA_UASTPOX_STR-DOKNR sy-vline 
WA_UASTPOX_STR-DOKVR sy-vline 
WA_UASTPOX_STR-DOKTL sy-vline 
WA_UASTPOX_STR-CSSTR sy-vline 
WA_UASTPOX_STR-CLASS sy-vline 
WA_UASTPOX_STR-KLART sy-vline 
WA_UASTPOX_STR-INTRM sy-vline 
WA_UASTPOX_STR-POTPR sy-vline 
WA_UASTPOX_STR-EKORG sy-vline 
WA_UASTPOX_STR-CLOBK sy-vline 
WA_UASTPOX_STR-CLMUL sy-vline 
WA_UASTPOX_STR-CVIEW sy-vline 
WA_UASTPOX_STR-KNOBJ sy-vline 
WA_UASTPOX_STR-LGORT sy-vline 
WA_UASTPOX_STR-PRVBE sy-vline 
WA_UASTPOX_STR-KZKUP sy-vline 
WA_UASTPOX_STR-DATUB sy-vline 
WA_UASTPOX_STR-AENRA sy-vline 
WA_UASTPOX_STR-AMGLG sy-vline 
WA_UASTPOX_STR-AMGKO sy-vline 
WA_UASTPOX_STR-DUMPS sy-vline 
WA_UASTPOX_STR-XTLTY sy-vline 
WA_UASTPOX_STR-XTLNR sy-vline 
WA_UASTPOX_STR-XTLAN sy-vline 
WA_UASTPOX_STR-XTLAL sy-vline 
WA_UASTPOX_STR-XISDT sy-vline 
WA_UASTPOX_STR-XISSR sy-vline 
WA_UASTPOX_STR-XMENG sy-vline 
WA_UASTPOX_STR-XMEIN sy-vline 
WA_UASTPOX_STR-XALTS sy-vline 
WA_UASTPOX_STR-XVARS sy-vline 
WA_UASTPOX_STR-XKBAU sy-vline 
WA_UASTPOX_STR-XLOEK sy-vline 
WA_UASTPOX_STR-AUSNM sy-vline 
WA_UASTPOX_STR-HDNFO sy-vline 
WA_UASTPOX_STR-AFFLG sy-vline 
WA_UASTPOX_STR-LTFLG sy-vline 
WA_UASTPOX_STR-NLFLG sy-vline 
WA_UASTPOX_STR-INDEX sy-vline 
WA_UASTPOX_STR-SUMKZ sy-vline 
WA_UASTPOX_STR-AUFST sy-vline 
WA_UASTPOX_STR-AUFWG sy-vline 
WA_UASTPOX_STR-BAUST sy-vline 
WA_UASTPOX_STR-BAUWG sy-vline 
WA_UASTPOX_STR-ASTOV sy-vline 
WA_UASTPOX_STR-AWGOV sy-vline 
WA_UASTPOX_STR-BSTOV sy-vline 
WA_UASTPOX_STR-BWGOV sy-vline 
WA_UASTPOX_STR-NLINK sy-vline 
WA_UASTPOX_STR-ALPST sy-vline 
WA_UASTPOX_STR-ALPRF sy-vline 
WA_UASTPOX_STR-ALPGR sy-vline 
WA_UASTPOX_STR-DSPST sy-vline 
WA_UASTPOX_STR-KZNFP sy-vline 
WA_UASTPOX_STR-NFGRP sy-vline 
WA_UASTPOX_STR-NFEAG sy-vline 
WA_UASTPOX_STR-KZCLB sy-vline 
WA_UASTPOX_STR-CLSZU sy-vline 
WA_UASTPOX_STR-ITMID sy-vline 
WA_UASTPOX_STR-ALEKZ sy-vline 
WA_UASTPOX_STR-GUIDX sy-vline 
WA_UASTPOX_STR-ITSOB sy-vline 
WA_UASTPOX_STR-RFPNT sy-vline 
WA_UASTPOX_STR-SOBMX sy-vline 
WA_UASTPOX_STR-MATKL sy-vline 
WA_UASTPOX_STR-INSTS sy-vline 
WA_UASTPOX_STR-INSTP sy-vline 
WA_UASTPOX_STR-KSTTY sy-vline 
WA_UASTPOX_STR-KSTNR sy-vline 
WA_UASTPOX_STR-KSTKN sy-vline 
WA_UASTPOX_STR-KSTPZ sy-vline 
WA_UASTPOX_STR-CAALT sy-vline 
WA_UASTPOX_STR-STLTY_W sy-vline 
WA_UASTPOX_STR-STLNR_W sy-vline      INTO ld_text SEPARATED BY SPACE.

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