ABAP Select data from SAP table LESHP_00002184 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 LESHP_00002184 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 LESHP_00002184. 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 LESHP_00002184 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_LESHP_00002184 TYPE STANDARD TABLE OF LESHP_00002184,
      WA_LESHP_00002184 TYPE LESHP_00002184,
      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: <LESHP_00002184> TYPE LESHP_00002184.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM LESHP_00002184
*  INTO TABLE @DATA(IT_LESHP_000021842).
*--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_LESHP_00002184 INDEX 1 INTO DATA(WA_LESHP_000021842).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<LESHP_00002184>-STOSU = 1.
<LESHP_00002184>-COTMP = 1.
<LESHP_00002184>-TPCUN = 1.
<LESHP_00002184>-EMTMP = 1.
<LESHP_00002184>-TPEUN = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_LESHP_00002184-FLTMP, sy-vline,
  WA_LESHP_00002184-TPFUN, sy-vline,
  WA_LESHP_00002184-TPSNL, sy-vline,
  WA_LESHP_00002184-TPSLU, sy-vline,
  WA_LESHP_00002184-TPSNH, sy-vline,
  WA_LESHP_00002184-TPSHU, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_LESHP_00002184 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_LESHP_00002184 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_LESHP_00002184 INTO WA_LESHP_00002184.


*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_LESHP_00002184_STR, 
STOSU TYPE STRING,
COTMP TYPE STRING,
TPCUN TYPE STRING,
EMTMP TYPE STRING,
TPEUN TYPE STRING,
FLTMP TYPE STRING,
TPFUN TYPE STRING,
TPSNL TYPE STRING,
TPSLU TYPE STRING,
TPSNH TYPE STRING,
TPSHU TYPE STRING,
COWE TYPE STRING,
VBFC TYPE STRING,
SDCL TYPE STRING,
SOOWA TYPE STRING,
USOOW TYPE STRING,
DENFEE TYPE STRING,
UDENFE TYPE STRING,
DENTWE TYPE STRING,
UDENTWE TYPE STRING,
DENFIF TYPE STRING,
UDENFI TYPE STRING,
BUDEN TYPE STRING,
UBUDE TYPE STRING,
BOPOI TYPE STRING,
UBOPO TYPE STRING,
VISCO TYPE STRING,
UVISC TYPE STRING,
STPRES TYPE STRING,
USTPRE TYPE STRING,
HYGRO TYPE STRING,
MEPOI TYPE STRING,
UMEPO TYPE STRING,
COOEX TYPE STRING,
UCOOE TYPE STRING,
MTMPF TYPE STRING,
UMTMP TYPE STRING,
PAI TYPE STRING,
PAIU TYPE STRING,
PAO TYPE STRING,
PAOU TYPE STRING,
RQA TYPE STRING,
RQU TYPE STRING,
MINQ TYPE STRING,
MINU TYPE STRING,
MAXQ TYPE STRING,
MAXU TYPE STRING,
RELQ TYPE STRING,
RELU TYPE STRING,
MULRQ TYPE STRING,
RCHEM TYPE STRING,
STOPA TYPE STRING,
PASI TYPE STRING,
UPASI TYPE STRING,
PAGW TYPE STRING,
UPAGW TYPE STRING,
MIOWA TYPE STRING,
UMIOW TYPE STRING,
RQA2 TYPE STRING,
RQU2 TYPE STRING,
EXPL_NET TYPE STRING,
EXPL_NET_U TYPE STRING,
EXPL_REL_PERCENT TYPE STRING,
ACTVTY_MAX TYPE STRING,
ACTVTY_MAX_U TYPE STRING,
ACTVTY_MAX_REL TYPE STRING,
ACTVTY_MAX_REL_U TYPE STRING,
TRANSP_INDEX TYPE STRING,
CRIT_SAF_INDEX TYPE STRING,
PACKAGE_CAT TYPE STRING,
ACTVTY_SINGLE_A2 TYPE STRING,
LTSK TYPE STRING,
EMV TYPE STRING,
FSAK TYPE STRING,
SFK TYPE STRING,
MUNAKODE TYPE STRING,
EXNUMBER TYPE STRING,
PINEQ TYPE STRING,
EXC_QUANT_IP TYPE STRING,
EXC_QUANT_IP_U TYPE STRING,
EXC_QUANT_OP TYPE STRING,
EXC_QUANT_OP_U TYPE STRING,
DANLAB01 TYPE STRING,
DANLAB02 TYPE STRING,
DANLAB03 TYPE STRING,
DANLAB04 TYPE STRING,
DANLAB05 TYPE STRING,
DANLAB06 TYPE STRING,
DANLAB07 TYPE STRING,
E1EDD16 TYPE STRING,
AGGRT TYPE STRING,
COWED TYPE STRING,
FORM_PHYS_CHEM_D TYPE STRING,
TUNNEL_RESTRICTION_CODE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_LESHP_00002184_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_LESHP_00002184_STR-STOSU sy-vline 
WA_LESHP_00002184_STR-COTMP sy-vline 
WA_LESHP_00002184_STR-TPCUN sy-vline 
WA_LESHP_00002184_STR-EMTMP sy-vline 
WA_LESHP_00002184_STR-TPEUN sy-vline 
WA_LESHP_00002184_STR-FLTMP sy-vline 
WA_LESHP_00002184_STR-TPFUN sy-vline 
WA_LESHP_00002184_STR-TPSNL sy-vline 
WA_LESHP_00002184_STR-TPSLU sy-vline 
WA_LESHP_00002184_STR-TPSNH sy-vline 
WA_LESHP_00002184_STR-TPSHU sy-vline 
WA_LESHP_00002184_STR-COWE sy-vline 
WA_LESHP_00002184_STR-VBFC sy-vline 
WA_LESHP_00002184_STR-SDCL sy-vline 
WA_LESHP_00002184_STR-SOOWA sy-vline 
WA_LESHP_00002184_STR-USOOW sy-vline 
WA_LESHP_00002184_STR-DENFEE sy-vline 
WA_LESHP_00002184_STR-UDENFE sy-vline 
WA_LESHP_00002184_STR-DENTWE sy-vline 
WA_LESHP_00002184_STR-UDENTWE sy-vline 
WA_LESHP_00002184_STR-DENFIF sy-vline 
WA_LESHP_00002184_STR-UDENFI sy-vline 
WA_LESHP_00002184_STR-BUDEN sy-vline 
WA_LESHP_00002184_STR-UBUDE sy-vline 
WA_LESHP_00002184_STR-BOPOI sy-vline 
WA_LESHP_00002184_STR-UBOPO sy-vline 
WA_LESHP_00002184_STR-VISCO sy-vline 
WA_LESHP_00002184_STR-UVISC sy-vline 
WA_LESHP_00002184_STR-STPRES sy-vline 
WA_LESHP_00002184_STR-USTPRE sy-vline 
WA_LESHP_00002184_STR-HYGRO sy-vline 
WA_LESHP_00002184_STR-MEPOI sy-vline 
WA_LESHP_00002184_STR-UMEPO sy-vline 
WA_LESHP_00002184_STR-COOEX sy-vline 
WA_LESHP_00002184_STR-UCOOE sy-vline 
WA_LESHP_00002184_STR-MTMPF sy-vline 
WA_LESHP_00002184_STR-UMTMP sy-vline 
WA_LESHP_00002184_STR-PAI sy-vline 
WA_LESHP_00002184_STR-PAIU sy-vline 
WA_LESHP_00002184_STR-PAO sy-vline 
WA_LESHP_00002184_STR-PAOU sy-vline 
WA_LESHP_00002184_STR-RQA sy-vline 
WA_LESHP_00002184_STR-RQU sy-vline 
WA_LESHP_00002184_STR-MINQ sy-vline 
WA_LESHP_00002184_STR-MINU sy-vline 
WA_LESHP_00002184_STR-MAXQ sy-vline 
WA_LESHP_00002184_STR-MAXU sy-vline 
WA_LESHP_00002184_STR-RELQ sy-vline 
WA_LESHP_00002184_STR-RELU sy-vline 
WA_LESHP_00002184_STR-MULRQ sy-vline 
WA_LESHP_00002184_STR-RCHEM sy-vline 
WA_LESHP_00002184_STR-STOPA sy-vline 
WA_LESHP_00002184_STR-PASI sy-vline 
WA_LESHP_00002184_STR-UPASI sy-vline 
WA_LESHP_00002184_STR-PAGW sy-vline 
WA_LESHP_00002184_STR-UPAGW sy-vline 
WA_LESHP_00002184_STR-MIOWA sy-vline 
WA_LESHP_00002184_STR-UMIOW sy-vline 
WA_LESHP_00002184_STR-RQA2 sy-vline 
WA_LESHP_00002184_STR-RQU2 sy-vline 
WA_LESHP_00002184_STR-EXPL_NET sy-vline 
WA_LESHP_00002184_STR-EXPL_NET_U sy-vline 
WA_LESHP_00002184_STR-EXPL_REL_PERCENT sy-vline 
WA_LESHP_00002184_STR-ACTVTY_MAX sy-vline 
WA_LESHP_00002184_STR-ACTVTY_MAX_U sy-vline 
WA_LESHP_00002184_STR-ACTVTY_MAX_REL sy-vline 
WA_LESHP_00002184_STR-ACTVTY_MAX_REL_U sy-vline 
WA_LESHP_00002184_STR-TRANSP_INDEX sy-vline 
WA_LESHP_00002184_STR-CRIT_SAF_INDEX sy-vline 
WA_LESHP_00002184_STR-PACKAGE_CAT sy-vline 
WA_LESHP_00002184_STR-ACTVTY_SINGLE_A2 sy-vline 
WA_LESHP_00002184_STR-LTSK sy-vline 
WA_LESHP_00002184_STR-EMV sy-vline 
WA_LESHP_00002184_STR-FSAK sy-vline 
WA_LESHP_00002184_STR-SFK sy-vline 
WA_LESHP_00002184_STR-MUNAKODE sy-vline 
WA_LESHP_00002184_STR-EXNUMBER sy-vline 
WA_LESHP_00002184_STR-PINEQ sy-vline 
WA_LESHP_00002184_STR-EXC_QUANT_IP sy-vline 
WA_LESHP_00002184_STR-EXC_QUANT_IP_U sy-vline 
WA_LESHP_00002184_STR-EXC_QUANT_OP sy-vline 
WA_LESHP_00002184_STR-EXC_QUANT_OP_U sy-vline 
WA_LESHP_00002184_STR-DANLAB01 sy-vline 
WA_LESHP_00002184_STR-DANLAB02 sy-vline 
WA_LESHP_00002184_STR-DANLAB03 sy-vline 
WA_LESHP_00002184_STR-DANLAB04 sy-vline 
WA_LESHP_00002184_STR-DANLAB05 sy-vline 
WA_LESHP_00002184_STR-DANLAB06 sy-vline 
WA_LESHP_00002184_STR-DANLAB07 sy-vline 
WA_LESHP_00002184_STR-E1EDD16 sy-vline 
WA_LESHP_00002184_STR-AGGRT sy-vline 
WA_LESHP_00002184_STR-COWED sy-vline 
WA_LESHP_00002184_STR-FORM_PHYS_CHEM_D sy-vline 
WA_LESHP_00002184_STR-TUNNEL_RESTRICTION_CODE sy-vline      INTO ld_text SEPARATED BY SPACE.

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