ABAP Select data from SAP table E1P0764 into internal table
Get Example source ABAP code based on a different SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP E1P0764 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 E1P0764. 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 E1P0764 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_E1P0764 TYPE STANDARD TABLE OF E1P0764,
WA_E1P0764 TYPE E1P0764,
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: <E1P0764> TYPE E1P0764.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_E1P0764.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM E1P0764
INTO TABLE IT_E1P0764.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM E1P0764
* INTO TABLE @DATA(IT_E1P07642).
*--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_E1P0764 INDEX 1 INTO DATA(WA_E1P07642).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_E1P0764 ASSIGNING <E1P0764>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<E1P0764>-PERNR = 1.
<E1P0764>-INFTY = 1.
<E1P0764>-SUBTY = 1.
<E1P0764>-OBJPS = 1.
<E1P0764>-SPRPS = 1.
ENDLOOP. LOOP AT IT_E1P0764 INTO WA_E1P0764. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_E1P0764-ENDDA, sy-vline,
WA_E1P0764-BEGDA, sy-vline,
WA_E1P0764-SEQNR, sy-vline,
WA_E1P0764-AEDTM, sy-vline,
WA_E1P0764-UNAME, sy-vline,
WA_E1P0764-HISTO, sy-vline.
ENDLOOP. *Add any further fields from structure WA_E1P0764 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_E1P0764 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_E1P0764 INTO WA_E1P0764. *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_E1P0764_STR,
PERNR TYPE STRING,
INFTY TYPE STRING,
SUBTY TYPE STRING,
OBJPS TYPE STRING,
SPRPS TYPE STRING,
ENDDA TYPE STRING,
BEGDA TYPE STRING,
SEQNR TYPE STRING,
AEDTM TYPE STRING,
UNAME TYPE STRING,
HISTO TYPE STRING,
ITXEX TYPE STRING,
REFEX TYPE STRING,
ORDEX TYPE STRING,
ITBLD TYPE STRING,
PREAS TYPE STRING,
FLAG1 TYPE STRING,
FLAG2 TYPE STRING,
FLAG3 TYPE STRING,
FLAG4 TYPE STRING,
RESE1 TYPE STRING,
RESE2 TYPE STRING,
GRPVL TYPE STRING,
SBMOD TYPE STRING,
SACHC TYPE STRING,
LGEDT TYPE STRING,
VANPW TYPE STRING,
ACT01 TYPE STRING,
UTD01 TYPE STRING,
END01 TYPE STRING,
BEV01 TYPE STRING,
ACT02 TYPE STRING,
UTD02 TYPE STRING,
END02 TYPE STRING,
BEV02 TYPE STRING,
ACT03 TYPE STRING,
UTD03 TYPE STRING,
END03 TYPE STRING,
BEV03 TYPE STRING,
ACT04 TYPE STRING,
UTD04 TYPE STRING,
END04 TYPE STRING,
BEV04 TYPE STRING,
ACT05 TYPE STRING,
UTD05 TYPE STRING,
END05 TYPE STRING,
BEV05 TYPE STRING,
ACT06 TYPE STRING,
UTD06 TYPE STRING,
END06 TYPE STRING,
BEV06 TYPE STRING,
ACT07 TYPE STRING,
UTD07 TYPE STRING,
END07 TYPE STRING,
BEV07 TYPE STRING,
ACT08 TYPE STRING,
UTD08 TYPE STRING,
END08 TYPE STRING,
BEV08 TYPE STRING,
ACT09 TYPE STRING,
UTD09 TYPE STRING,
END09 TYPE STRING,
BEV09 TYPE STRING,
ACT10 TYPE STRING,
UTD10 TYPE STRING,
END10 TYPE STRING,
BEV10 TYPE STRING,
ACT11 TYPE STRING,
UTD11 TYPE STRING,
END11 TYPE STRING,
BEV11 TYPE STRING,
ACT12 TYPE STRING,
UTD12 TYPE STRING,
END12 TYPE STRING,
BEV12 TYPE STRING,
ACT13 TYPE STRING,
UTD13 TYPE STRING,
END13 TYPE STRING,
BEV13 TYPE STRING,
ACT14 TYPE STRING,
UTD14 TYPE STRING,
END14 TYPE STRING,
BEV14 TYPE STRING,
ACT15 TYPE STRING,
UTD15 TYPE STRING,
END15 TYPE STRING,
BEV15 TYPE STRING,
ACT16 TYPE STRING,
UTD16 TYPE STRING,
END16 TYPE STRING,
BEV16 TYPE STRING,
ACT17 TYPE STRING,
UTD17 TYPE STRING,
END17 TYPE STRING,
BEV17 TYPE STRING,
ACT18 TYPE STRING,
UTD18 TYPE STRING,
END18 TYPE STRING,
BEV18 TYPE STRING,
ACT19 TYPE STRING,
UTD19 TYPE STRING,
END19 TYPE STRING,
BEV19 TYPE STRING,
ACT20 TYPE STRING,
UTD20 TYPE STRING,
END20 TYPE STRING,
BEV20 TYPE STRING,
ACT21 TYPE STRING,
UTD21 TYPE STRING,
END21 TYPE STRING,
BEV21 TYPE STRING,
ACT22 TYPE STRING,
UTD22 TYPE STRING,
END22 TYPE STRING,
BEV22 TYPE STRING,
ACT23 TYPE STRING,
UTD23 TYPE STRING,
END23 TYPE STRING,
BEV23 TYPE STRING,
ACT24 TYPE STRING,
UTD24 TYPE STRING,
END24 TYPE STRING,
BEV24 TYPE STRING,
ACT25 TYPE STRING,
UTD25 TYPE STRING,
END25 TYPE STRING,
BEV25 TYPE STRING,
ACT26 TYPE STRING,
UTD26 TYPE STRING,
END26 TYPE STRING,
BEV26 TYPE STRING,
ACT27 TYPE STRING,
UTD27 TYPE STRING,
END27 TYPE STRING,
BEV27 TYPE STRING,
ACT28 TYPE STRING,
UTD28 TYPE STRING,
END28 TYPE STRING,
BEV28 TYPE STRING,
ACT29 TYPE STRING,
UTD29 TYPE STRING,
END29 TYPE STRING,
BEV29 TYPE STRING,
ACT30 TYPE STRING,
UTD30 TYPE STRING,
END30 TYPE STRING,
BEV30 TYPE STRING,
ACT31 TYPE STRING,
UTD31 TYPE STRING,
END31 TYPE STRING,
BEV31 TYPE STRING,
ACT32 TYPE STRING,
UTD32 TYPE STRING,
END32 TYPE STRING,
BEV32 TYPE STRING,
ACT33 TYPE STRING,
UTD33 TYPE STRING,
END33 TYPE STRING,
BEV33 TYPE STRING,
ACT34 TYPE STRING,
UTD34 TYPE STRING,
END34 TYPE STRING,
BEV34 TYPE STRING,
ACT35 TYPE STRING,
UTD35 TYPE STRING,
END35 TYPE STRING,
BEV35 TYPE STRING,
ACT36 TYPE STRING,
UTD36 TYPE STRING,
END36 TYPE STRING,
BEV36 TYPE STRING,
ACT37 TYPE STRING,
UTD37 TYPE STRING,
END37 TYPE STRING,
BEV37 TYPE STRING,
ACT38 TYPE STRING,
UTD38 TYPE STRING,
END38 TYPE STRING,
BEV38 TYPE STRING,
ACT39 TYPE STRING,
UTD39 TYPE STRING,
END39 TYPE STRING,
BEV39 TYPE STRING,
ACT40 TYPE STRING,
UTD40 TYPE STRING,
END40 TYPE STRING,
BEV40 TYPE STRING,
ACT41 TYPE STRING,
UTD41 TYPE STRING,
END41 TYPE STRING,
BEV41 TYPE STRING,
ACT42 TYPE STRING,
UTD42 TYPE STRING,
END42 TYPE STRING,
BEV42 TYPE STRING,
ACT43 TYPE STRING,
UTD43 TYPE STRING,
END43 TYPE STRING,
BEV43 TYPE STRING,
ACT44 TYPE STRING,
ACT45 TYPE STRING,
UTD44 TYPE STRING,
UTD45 TYPE STRING,
END44 TYPE STRING,
END45 TYPE STRING,
BEV44 TYPE STRING,
BEV45 TYPE STRING,
ACT46 TYPE STRING,
ACT47 TYPE STRING,END OF T_EKKO_STR. DATA: WA_E1P0764_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_E1P0764_STR-PERNR sy-vline
WA_E1P0764_STR-INFTY sy-vline
WA_E1P0764_STR-SUBTY sy-vline
WA_E1P0764_STR-OBJPS sy-vline
WA_E1P0764_STR-SPRPS sy-vline
WA_E1P0764_STR-ENDDA sy-vline
WA_E1P0764_STR-BEGDA sy-vline
WA_E1P0764_STR-SEQNR sy-vline
WA_E1P0764_STR-AEDTM sy-vline
WA_E1P0764_STR-UNAME sy-vline
WA_E1P0764_STR-HISTO sy-vline
WA_E1P0764_STR-ITXEX sy-vline
WA_E1P0764_STR-REFEX sy-vline
WA_E1P0764_STR-ORDEX sy-vline
WA_E1P0764_STR-ITBLD sy-vline
WA_E1P0764_STR-PREAS sy-vline
WA_E1P0764_STR-FLAG1 sy-vline
WA_E1P0764_STR-FLAG2 sy-vline
WA_E1P0764_STR-FLAG3 sy-vline
WA_E1P0764_STR-FLAG4 sy-vline
WA_E1P0764_STR-RESE1 sy-vline
WA_E1P0764_STR-RESE2 sy-vline
WA_E1P0764_STR-GRPVL sy-vline
WA_E1P0764_STR-SBMOD sy-vline
WA_E1P0764_STR-SACHC sy-vline
WA_E1P0764_STR-LGEDT sy-vline
WA_E1P0764_STR-VANPW sy-vline
WA_E1P0764_STR-ACT01 sy-vline
WA_E1P0764_STR-UTD01 sy-vline
WA_E1P0764_STR-END01 sy-vline
WA_E1P0764_STR-BEV01 sy-vline
WA_E1P0764_STR-ACT02 sy-vline
WA_E1P0764_STR-UTD02 sy-vline
WA_E1P0764_STR-END02 sy-vline
WA_E1P0764_STR-BEV02 sy-vline
WA_E1P0764_STR-ACT03 sy-vline
WA_E1P0764_STR-UTD03 sy-vline
WA_E1P0764_STR-END03 sy-vline
WA_E1P0764_STR-BEV03 sy-vline
WA_E1P0764_STR-ACT04 sy-vline
WA_E1P0764_STR-UTD04 sy-vline
WA_E1P0764_STR-END04 sy-vline
WA_E1P0764_STR-BEV04 sy-vline
WA_E1P0764_STR-ACT05 sy-vline
WA_E1P0764_STR-UTD05 sy-vline
WA_E1P0764_STR-END05 sy-vline
WA_E1P0764_STR-BEV05 sy-vline
WA_E1P0764_STR-ACT06 sy-vline
WA_E1P0764_STR-UTD06 sy-vline
WA_E1P0764_STR-END06 sy-vline
WA_E1P0764_STR-BEV06 sy-vline
WA_E1P0764_STR-ACT07 sy-vline
WA_E1P0764_STR-UTD07 sy-vline
WA_E1P0764_STR-END07 sy-vline
WA_E1P0764_STR-BEV07 sy-vline
WA_E1P0764_STR-ACT08 sy-vline
WA_E1P0764_STR-UTD08 sy-vline
WA_E1P0764_STR-END08 sy-vline
WA_E1P0764_STR-BEV08 sy-vline
WA_E1P0764_STR-ACT09 sy-vline
WA_E1P0764_STR-UTD09 sy-vline
WA_E1P0764_STR-END09 sy-vline
WA_E1P0764_STR-BEV09 sy-vline
WA_E1P0764_STR-ACT10 sy-vline
WA_E1P0764_STR-UTD10 sy-vline
WA_E1P0764_STR-END10 sy-vline
WA_E1P0764_STR-BEV10 sy-vline
WA_E1P0764_STR-ACT11 sy-vline
WA_E1P0764_STR-UTD11 sy-vline
WA_E1P0764_STR-END11 sy-vline
WA_E1P0764_STR-BEV11 sy-vline
WA_E1P0764_STR-ACT12 sy-vline
WA_E1P0764_STR-UTD12 sy-vline
WA_E1P0764_STR-END12 sy-vline
WA_E1P0764_STR-BEV12 sy-vline
WA_E1P0764_STR-ACT13 sy-vline
WA_E1P0764_STR-UTD13 sy-vline
WA_E1P0764_STR-END13 sy-vline
WA_E1P0764_STR-BEV13 sy-vline
WA_E1P0764_STR-ACT14 sy-vline
WA_E1P0764_STR-UTD14 sy-vline
WA_E1P0764_STR-END14 sy-vline
WA_E1P0764_STR-BEV14 sy-vline
WA_E1P0764_STR-ACT15 sy-vline
WA_E1P0764_STR-UTD15 sy-vline
WA_E1P0764_STR-END15 sy-vline
WA_E1P0764_STR-BEV15 sy-vline
WA_E1P0764_STR-ACT16 sy-vline
WA_E1P0764_STR-UTD16 sy-vline
WA_E1P0764_STR-END16 sy-vline
WA_E1P0764_STR-BEV16 sy-vline
WA_E1P0764_STR-ACT17 sy-vline
WA_E1P0764_STR-UTD17 sy-vline
WA_E1P0764_STR-END17 sy-vline
WA_E1P0764_STR-BEV17 sy-vline
WA_E1P0764_STR-ACT18 sy-vline
WA_E1P0764_STR-UTD18 sy-vline
WA_E1P0764_STR-END18 sy-vline
WA_E1P0764_STR-BEV18 sy-vline
WA_E1P0764_STR-ACT19 sy-vline
WA_E1P0764_STR-UTD19 sy-vline
WA_E1P0764_STR-END19 sy-vline
WA_E1P0764_STR-BEV19 sy-vline
WA_E1P0764_STR-ACT20 sy-vline
WA_E1P0764_STR-UTD20 sy-vline
WA_E1P0764_STR-END20 sy-vline
WA_E1P0764_STR-BEV20 sy-vline
WA_E1P0764_STR-ACT21 sy-vline
WA_E1P0764_STR-UTD21 sy-vline
WA_E1P0764_STR-END21 sy-vline
WA_E1P0764_STR-BEV21 sy-vline
WA_E1P0764_STR-ACT22 sy-vline
WA_E1P0764_STR-UTD22 sy-vline
WA_E1P0764_STR-END22 sy-vline
WA_E1P0764_STR-BEV22 sy-vline
WA_E1P0764_STR-ACT23 sy-vline
WA_E1P0764_STR-UTD23 sy-vline
WA_E1P0764_STR-END23 sy-vline
WA_E1P0764_STR-BEV23 sy-vline
WA_E1P0764_STR-ACT24 sy-vline
WA_E1P0764_STR-UTD24 sy-vline
WA_E1P0764_STR-END24 sy-vline
WA_E1P0764_STR-BEV24 sy-vline
WA_E1P0764_STR-ACT25 sy-vline
WA_E1P0764_STR-UTD25 sy-vline
WA_E1P0764_STR-END25 sy-vline
WA_E1P0764_STR-BEV25 sy-vline
WA_E1P0764_STR-ACT26 sy-vline
WA_E1P0764_STR-UTD26 sy-vline
WA_E1P0764_STR-END26 sy-vline
WA_E1P0764_STR-BEV26 sy-vline
WA_E1P0764_STR-ACT27 sy-vline
WA_E1P0764_STR-UTD27 sy-vline
WA_E1P0764_STR-END27 sy-vline
WA_E1P0764_STR-BEV27 sy-vline
WA_E1P0764_STR-ACT28 sy-vline
WA_E1P0764_STR-UTD28 sy-vline
WA_E1P0764_STR-END28 sy-vline
WA_E1P0764_STR-BEV28 sy-vline
WA_E1P0764_STR-ACT29 sy-vline
WA_E1P0764_STR-UTD29 sy-vline
WA_E1P0764_STR-END29 sy-vline
WA_E1P0764_STR-BEV29 sy-vline
WA_E1P0764_STR-ACT30 sy-vline
WA_E1P0764_STR-UTD30 sy-vline
WA_E1P0764_STR-END30 sy-vline
WA_E1P0764_STR-BEV30 sy-vline
WA_E1P0764_STR-ACT31 sy-vline
WA_E1P0764_STR-UTD31 sy-vline
WA_E1P0764_STR-END31 sy-vline
WA_E1P0764_STR-BEV31 sy-vline
WA_E1P0764_STR-ACT32 sy-vline
WA_E1P0764_STR-UTD32 sy-vline
WA_E1P0764_STR-END32 sy-vline
WA_E1P0764_STR-BEV32 sy-vline
WA_E1P0764_STR-ACT33 sy-vline
WA_E1P0764_STR-UTD33 sy-vline
WA_E1P0764_STR-END33 sy-vline
WA_E1P0764_STR-BEV33 sy-vline
WA_E1P0764_STR-ACT34 sy-vline
WA_E1P0764_STR-UTD34 sy-vline
WA_E1P0764_STR-END34 sy-vline
WA_E1P0764_STR-BEV34 sy-vline
WA_E1P0764_STR-ACT35 sy-vline
WA_E1P0764_STR-UTD35 sy-vline
WA_E1P0764_STR-END35 sy-vline
WA_E1P0764_STR-BEV35 sy-vline
WA_E1P0764_STR-ACT36 sy-vline
WA_E1P0764_STR-UTD36 sy-vline
WA_E1P0764_STR-END36 sy-vline
WA_E1P0764_STR-BEV36 sy-vline
WA_E1P0764_STR-ACT37 sy-vline
WA_E1P0764_STR-UTD37 sy-vline
WA_E1P0764_STR-END37 sy-vline
WA_E1P0764_STR-BEV37 sy-vline
WA_E1P0764_STR-ACT38 sy-vline
WA_E1P0764_STR-UTD38 sy-vline
WA_E1P0764_STR-END38 sy-vline
WA_E1P0764_STR-BEV38 sy-vline
WA_E1P0764_STR-ACT39 sy-vline
WA_E1P0764_STR-UTD39 sy-vline
WA_E1P0764_STR-END39 sy-vline
WA_E1P0764_STR-BEV39 sy-vline
WA_E1P0764_STR-ACT40 sy-vline
WA_E1P0764_STR-UTD40 sy-vline
WA_E1P0764_STR-END40 sy-vline
WA_E1P0764_STR-BEV40 sy-vline
WA_E1P0764_STR-ACT41 sy-vline
WA_E1P0764_STR-UTD41 sy-vline
WA_E1P0764_STR-END41 sy-vline
WA_E1P0764_STR-BEV41 sy-vline
WA_E1P0764_STR-ACT42 sy-vline
WA_E1P0764_STR-UTD42 sy-vline
WA_E1P0764_STR-END42 sy-vline
WA_E1P0764_STR-BEV42 sy-vline
WA_E1P0764_STR-ACT43 sy-vline
WA_E1P0764_STR-UTD43 sy-vline
WA_E1P0764_STR-END43 sy-vline
WA_E1P0764_STR-BEV43 sy-vline
WA_E1P0764_STR-ACT44 sy-vline
WA_E1P0764_STR-ACT45 sy-vline
WA_E1P0764_STR-UTD44 sy-vline
WA_E1P0764_STR-UTD45 sy-vline
WA_E1P0764_STR-END44 sy-vline
WA_E1P0764_STR-END45 sy-vline
WA_E1P0764_STR-BEV44 sy-vline
WA_E1P0764_STR-BEV45 sy-vline
WA_E1P0764_STR-ACT46 sy-vline
WA_E1P0764_STR-ACT47 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
