ABAP Select data from SAP table E1BPDELICIOUSREQUEST 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 E1BPDELICIOUSREQUEST 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 E1BPDELICIOUSREQUEST. 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 E1BPDELICIOUSREQUEST 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_E1BPDELICIOUSREQUEST TYPE STANDARD TABLE OF E1BPDELICIOUSREQUEST,
WA_E1BPDELICIOUSREQUEST TYPE E1BPDELICIOUSREQUEST,
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: <E1BPDELICIOUSREQUEST> TYPE E1BPDELICIOUSREQUEST.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_E1BPDELICIOUSREQUEST.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM E1BPDELICIOUSREQUEST
INTO TABLE IT_E1BPDELICIOUSREQUEST.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM E1BPDELICIOUSREQUEST
* INTO TABLE @DATA(IT_E1BPDELICIOUSREQUEST2).
*--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_E1BPDELICIOUSREQUEST INDEX 1 INTO DATA(WA_E1BPDELICIOUSREQUEST2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_E1BPDELICIOUSREQUEST ASSIGNING <E1BPDELICIOUSREQUEST>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<E1BPDELICIOUSREQUEST>-ID = 1.
<E1BPDELICIOUSREQUEST>-DOCUMENT_SYSTEM = 1.
<E1BPDELICIOUSREQUEST>-DOCUMENT_NUMB = 1.
<E1BPDELICIOUSREQUEST>-DOCUMENT_ITEM = 1.
<E1BPDELICIOUSREQUEST>-DOCUMENT_ITEM_GUID = 1.
ENDLOOP. LOOP AT IT_E1BPDELICIOUSREQUEST INTO WA_E1BPDELICIOUSREQUEST. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_E1BPDELICIOUSREQUEST-EXTDELV_NO, sy-vline,
WA_E1BPDELICIOUSREQUEST-HIGHER_LEVEL_ITEM, sy-vline,
WA_E1BPDELICIOUSREQUEST-HIGHER_LEVEL_ITEM_USAGE, sy-vline,
WA_E1BPDELICIOUSREQUEST-SHIP_TO, sy-vline,
WA_E1BPDELICIOUSREQUEST-SOLD_TO, sy-vline,
WA_E1BPDELICIOUSREQUEST-VENDOR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_E1BPDELICIOUSREQUEST 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_E1BPDELICIOUSREQUEST 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_E1BPDELICIOUSREQUEST INTO WA_E1BPDELICIOUSREQUEST. *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_E1BPDELICIOUSREQUEST_STR,
ID TYPE STRING,
DOCUMENT_SYSTEM TYPE STRING,
DOCUMENT_NUMB TYPE STRING,
DOCUMENT_ITEM TYPE STRING,
DOCUMENT_ITEM_GUID TYPE STRING,
EXTDELV_NO TYPE STRING,
HIGHER_LEVEL_ITEM TYPE STRING,
HIGHER_LEVEL_ITEM_USAGE TYPE STRING,
SHIP_TO TYPE STRING,
SOLD_TO TYPE STRING,
VENDOR TYPE STRING,
FORWARDING_AGENT TYPE STRING,
CUST_GROUP TYPE STRING,
CUST_GRP1 TYPE STRING,
CUST_GRP2 TYPE STRING,
CUST_GRP3 TYPE STRING,
CUST_GRP4 TYPE STRING,
CUST_GRP5 TYPE STRING,
SALES_ORGANISATION TYPE STRING,
DISTRIBUTION_CHANNEL TYPE STRING,
DIVISION TYPE STRING,
PLANT TYPE STRING,
STGE_LOC TYPE STRING,
SALES_OFFICE TYPE STRING,
RECEIVING_POINT TYPE STRING,
DEPARTMENT_NO TYPE STRING,
PURCHASE_ORGANISATION TYPE STRING,
PURCHASE_GROUP TYPE STRING,
QUANTITY_SALES_UOM TYPE STRING,
QUANTITY_BASE__UOM TYPE STRING,
COMPONENT_RATIO TYPE STRING,
SALES_UNIT TYPE STRING,
SALES_UNIT_ISO TYPE STRING,
BASE_UOM TYPE STRING,
SALES_QTY_NUM TYPE STRING,
SALES_QTY_DENOM TYPE STRING,
TARE_WGHT TYPE STRING,
GROSS_WT TYPE STRING,
NET_WEIGHT TYPE STRING,
VOLUME TYPE STRING,
TARE_VOL TYPE STRING,
UNIT_OF_WT TYPE STRING,
UNIT_OF_WT_ISO TYPE STRING,
VOLUMEUNIT TYPE STRING,
VOLUMEUNIT_ISO TYPE STRING,
MATERIAL TYPE STRING,
MATERIAL_SHORTTEXT TYPE STRING,
MATERIAL_ENTERED TYPE STRING,
MATERIAL_CUSTOMER TYPE STRING,
MATERIAL_EAN_UPC TYPE STRING,
BATCH TYPE STRING,
MATL_GROUP TYPE STRING,
PRODUCT_HIERARCHY TYPE STRING,
TRANS_GRP TYPE STRING,
LOADINGGRP TYPE STRING,
MATFRGTGRP TYPE STRING,
MAT_GRP_SM TYPE STRING,
PROMOTION TYPE STRING,
PRC_GROUP1 TYPE STRING,
PRC_GROUP2 TYPE STRING,
PRC_GROUP3 TYPE STRING,
PRC_GROUP4 TYPE STRING,
PRC_GROUP5 TYPE STRING,
MAT_AVAILABIL_DATE TYPE STRING,
MAT_AVAILABIL_TIME TYPE STRING,
MAT_AVAILABIL_TIME_STAMP TYPE STRING,
MAT_AVAILABIL_TIME_ZONE TYPE STRING,
TRANSP_PLAN_DATE TYPE STRING,
TRANSP_PLAN_TIME TYPE STRING,
TRANSP_PLAN_TIME_STAMP TYPE STRING,
TRANSP_PLAN_TIME_ZONE TYPE STRING,
LOADING_DATE TYPE STRING,
LOADING_TIME TYPE STRING,
LOADING_TIME_STAMP TYPE STRING,
LOADING_TIME_ZONE TYPE STRING,
GOODS_ISSUE_DATE TYPE STRING,
GOODS_ISSUE_TIME TYPE STRING,
GOODS_ISSUE_TIME_STAMP TYPE STRING,
GOODS_ISSUE_TIME_ZONE TYPE STRING,
DELIVERY_DATE TYPE STRING,
DELIVERY_TIME TYPE STRING,
DELIVERY_ARRIVAL_TIME_STAMP TYPE STRING,
DELIVERY_ARRIVAL_TIME_ZONE TYPE STRING,
DATE_USAGE TYPE STRING,
DATE TYPE STRING,
TIME TYPE STRING,
TIME_STAMP TYPE STRING,
TIME_ZONE TYPE STRING,
NO_MORE_DELIVERIES TYPE STRING,
QUAN_NO_CHECK TYPE STRING,
DOCUMENT_TYPE TYPE STRING,
DOCUMENT_CATEGORY_SD TYPE STRING,
DOCUMENT_TYPE_PREDECESSOR TYPE STRING,
DOCUMENT_TYPE_DELIVERY TYPE STRING,
ITEM_TYPE TYPE STRING,
ITEM_CATEGORY_PREDECESSOR TYPE STRING,
ITEM_CATEGORY_DELIVERY TYPE STRING,
FLG_LEAD_UNIT TYPE STRING,
ORDCOMBIND TYPE STRING,
PARTIAL_DELIVERY TYPE STRING,
DELIVERY_PRIO TYPE STRING,
DELIVERY_BLOCK TYPE STRING,
DELIVERY_GROUP TYPE STRING,
SHIPPING_CONDITION TYPE STRING,
INCOTERMS1 TYPE STRING,
INCOTERMS2 TYPE STRING,
UNLOAD_POINT TYPE STRING,
TRANSP_ID TYPE STRING,
TRANS_CAT TYPE STRING,
TRANSPORT_MEANS TYPE STRING,
BILLOFLADING TYPE STRING,
ROUTE TYPE STRING,END OF T_EKKO_STR. DATA: WA_E1BPDELICIOUSREQUEST_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_E1BPDELICIOUSREQUEST_STR-ID sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DOCUMENT_SYSTEM sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DOCUMENT_NUMB sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DOCUMENT_ITEM sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DOCUMENT_ITEM_GUID sy-vline
WA_E1BPDELICIOUSREQUEST_STR-EXTDELV_NO sy-vline
WA_E1BPDELICIOUSREQUEST_STR-HIGHER_LEVEL_ITEM sy-vline
WA_E1BPDELICIOUSREQUEST_STR-HIGHER_LEVEL_ITEM_USAGE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-SHIP_TO sy-vline
WA_E1BPDELICIOUSREQUEST_STR-SOLD_TO sy-vline
WA_E1BPDELICIOUSREQUEST_STR-VENDOR sy-vline
WA_E1BPDELICIOUSREQUEST_STR-FORWARDING_AGENT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-CUST_GROUP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-CUST_GRP1 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-CUST_GRP2 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-CUST_GRP3 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-CUST_GRP4 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-CUST_GRP5 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-SALES_ORGANISATION sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DISTRIBUTION_CHANNEL sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DIVISION sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PLANT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-STGE_LOC sy-vline
WA_E1BPDELICIOUSREQUEST_STR-SALES_OFFICE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-RECEIVING_POINT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DEPARTMENT_NO sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PURCHASE_ORGANISATION sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PURCHASE_GROUP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-QUANTITY_SALES_UOM sy-vline
WA_E1BPDELICIOUSREQUEST_STR-QUANTITY_BASE__UOM sy-vline
WA_E1BPDELICIOUSREQUEST_STR-COMPONENT_RATIO sy-vline
WA_E1BPDELICIOUSREQUEST_STR-SALES_UNIT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-SALES_UNIT_ISO sy-vline
WA_E1BPDELICIOUSREQUEST_STR-BASE_UOM sy-vline
WA_E1BPDELICIOUSREQUEST_STR-SALES_QTY_NUM sy-vline
WA_E1BPDELICIOUSREQUEST_STR-SALES_QTY_DENOM sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TARE_WGHT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-GROSS_WT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-NET_WEIGHT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-VOLUME sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TARE_VOL sy-vline
WA_E1BPDELICIOUSREQUEST_STR-UNIT_OF_WT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-UNIT_OF_WT_ISO sy-vline
WA_E1BPDELICIOUSREQUEST_STR-VOLUMEUNIT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-VOLUMEUNIT_ISO sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MATERIAL sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MATERIAL_SHORTTEXT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MATERIAL_ENTERED sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MATERIAL_CUSTOMER sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MATERIAL_EAN_UPC sy-vline
WA_E1BPDELICIOUSREQUEST_STR-BATCH sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MATL_GROUP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PRODUCT_HIERARCHY sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TRANS_GRP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-LOADINGGRP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MATFRGTGRP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MAT_GRP_SM sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PROMOTION sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PRC_GROUP1 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PRC_GROUP2 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PRC_GROUP3 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PRC_GROUP4 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PRC_GROUP5 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MAT_AVAILABIL_DATE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MAT_AVAILABIL_TIME sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MAT_AVAILABIL_TIME_STAMP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-MAT_AVAILABIL_TIME_ZONE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TRANSP_PLAN_DATE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TRANSP_PLAN_TIME sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TRANSP_PLAN_TIME_STAMP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TRANSP_PLAN_TIME_ZONE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-LOADING_DATE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-LOADING_TIME sy-vline
WA_E1BPDELICIOUSREQUEST_STR-LOADING_TIME_STAMP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-LOADING_TIME_ZONE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-GOODS_ISSUE_DATE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-GOODS_ISSUE_TIME sy-vline
WA_E1BPDELICIOUSREQUEST_STR-GOODS_ISSUE_TIME_STAMP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-GOODS_ISSUE_TIME_ZONE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DELIVERY_DATE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DELIVERY_TIME sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DELIVERY_ARRIVAL_TIME_STAMP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DELIVERY_ARRIVAL_TIME_ZONE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DATE_USAGE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DATE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TIME sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TIME_STAMP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TIME_ZONE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-NO_MORE_DELIVERIES sy-vline
WA_E1BPDELICIOUSREQUEST_STR-QUAN_NO_CHECK sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DOCUMENT_TYPE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DOCUMENT_CATEGORY_SD sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DOCUMENT_TYPE_PREDECESSOR sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DOCUMENT_TYPE_DELIVERY sy-vline
WA_E1BPDELICIOUSREQUEST_STR-ITEM_TYPE sy-vline
WA_E1BPDELICIOUSREQUEST_STR-ITEM_CATEGORY_PREDECESSOR sy-vline
WA_E1BPDELICIOUSREQUEST_STR-ITEM_CATEGORY_DELIVERY sy-vline
WA_E1BPDELICIOUSREQUEST_STR-FLG_LEAD_UNIT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-ORDCOMBIND sy-vline
WA_E1BPDELICIOUSREQUEST_STR-PARTIAL_DELIVERY sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DELIVERY_PRIO sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DELIVERY_BLOCK sy-vline
WA_E1BPDELICIOUSREQUEST_STR-DELIVERY_GROUP sy-vline
WA_E1BPDELICIOUSREQUEST_STR-SHIPPING_CONDITION sy-vline
WA_E1BPDELICIOUSREQUEST_STR-INCOTERMS1 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-INCOTERMS2 sy-vline
WA_E1BPDELICIOUSREQUEST_STR-UNLOAD_POINT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TRANSP_ID sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TRANS_CAT sy-vline
WA_E1BPDELICIOUSREQUEST_STR-TRANSPORT_MEANS sy-vline
WA_E1BPDELICIOUSREQUEST_STR-BILLOFLADING sy-vline
WA_E1BPDELICIOUSREQUEST_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.
