ABAP Select data from SAP table BBP_IMS_IV_ADS_TXT 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 BBP_IMS_IV_ADS_TXT 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 BBP_IMS_IV_ADS_TXT. 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 BBP_IMS_IV_ADS_TXT 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_BBP_IMS_IV_ADS_TXT TYPE STANDARD TABLE OF BBP_IMS_IV_ADS_TXT,
WA_BBP_IMS_IV_ADS_TXT TYPE BBP_IMS_IV_ADS_TXT,
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: <BBP_IMS_IV_ADS_TXT> TYPE BBP_IMS_IV_ADS_TXT.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_BBP_IMS_IV_ADS_TXT.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM BBP_IMS_IV_ADS_TXT
INTO TABLE IT_BBP_IMS_IV_ADS_TXT.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM BBP_IMS_IV_ADS_TXT
* INTO TABLE @DATA(IT_BBP_IMS_IV_ADS_TXT2).
*--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_BBP_IMS_IV_ADS_TXT INDEX 1 INTO DATA(WA_BBP_IMS_IV_ADS_TXT2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_BBP_IMS_IV_ADS_TXT ASSIGNING <BBP_IMS_IV_ADS_TXT>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<BBP_IMS_IV_ADS_TXT>-GUID_HDR = 1.
<BBP_IMS_IV_ADS_TXT>-REF_DOC_NO_HDR = 1.
<BBP_IMS_IV_ADS_TXT>-OBJECT_ID_HDR = 1.
<BBP_IMS_IV_ADS_TXT>-POSTING_DATE_HDR = 1.
<BBP_IMS_IV_ADS_TXT>-POSTING_DATE_FI_HDR = 1.
ENDLOOP. LOOP AT IT_BBP_IMS_IV_ADS_TXT INTO WA_BBP_IMS_IV_ADS_TXT. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_BBP_IMS_IV_ADS_TXT-CURRENCY_HDR, sy-vline,
WA_BBP_IMS_IV_ADS_TXT-GROSS_AMOUNT_HDR, sy-vline,
WA_BBP_IMS_IV_ADS_TXT-IMS_SOURCE_HDR, sy-vline,
WA_BBP_IMS_IV_ADS_TXT-IMS_SUBTOTAL_HDR, sy-vline,
WA_BBP_IMS_IV_ADS_TXT-IMS_TAX_HDR, sy-vline,
WA_BBP_IMS_IV_ADS_TXT-IMS_SHIPPING_HDR, sy-vline.
ENDLOOP. *Add any further fields from structure WA_BBP_IMS_IV_ADS_TXT 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_BBP_IMS_IV_ADS_TXT 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_BBP_IMS_IV_ADS_TXT INTO WA_BBP_IMS_IV_ADS_TXT. *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_BBP_IMS_IV_ADS_TXT_STR,
GUID_HDR TYPE STRING,
REF_DOC_NO_HDR TYPE STRING,
OBJECT_ID_HDR TYPE STRING,
POSTING_DATE_HDR TYPE STRING,
POSTING_DATE_FI_HDR TYPE STRING,
CURRENCY_HDR TYPE STRING,
GROSS_AMOUNT_HDR TYPE STRING,
IMS_SOURCE_HDR TYPE STRING,
IMS_SUBTOTAL_HDR TYPE STRING,
IMS_TAX_HDR TYPE STRING,
IMS_SHIPPING_HDR TYPE STRING,
IMS_BUKRS_HDR TYPE STRING,
IMS_BELNR_HDR TYPE STRING,
IMS_GJAHR_HDR TYPE STRING,
IMS_NAME_HDR TYPE STRING,
IMS_SOURCE_DOC_HDR TYPE STRING,
IMS_SOURCE_URL_HDR TYPE STRING,
PMNTTRMS_HDR TYPE STRING,
IMS_COMP_DESC_COMP TYPE STRING,
CITY_COMP TYPE STRING,
POSTL_COD1_COMP TYPE STRING,
STREET_COMP TYPE STRING,
HOUSE_NO_COMP TYPE STRING,
REGION_COMP TYPE STRING,
COUNTRY_COMP TYPE STRING,
IMS_COMP_TEL_COMP TYPE STRING,
IMS_COMP_FAX_COMP TYPE STRING,
IMS_PAYMENT_ID_PAY TYPE STRING,
CITY_PAY TYPE STRING,
POSTL_COD1_PAY TYPE STRING,
HOUSE_NO_PAY TYPE STRING,
STREET_PAY TYPE STRING,
REGION_PAY TYPE STRING,
TEL1_NUMBR__PAY TYPE STRING,
TEL1_EXT_PAY TYPE STRING,
FAX_NUMBER_PAY TYPE STRING,
COUNTRY_PAY TYPE STRING,
FAX_EXTENS_PAY TYPE STRING,
IMS_PAYMENT_DESC_PAY TYPE STRING,
IMS_ADDRESS_PAY TYPE STRING,
IMS_REQUESTER_ID_REQ TYPE STRING,
IMS_VENDOR_ID_VEND TYPE STRING,
IMS_VENDOR_DESC_VEND TYPE STRING,
CITY_VEND TYPE STRING,
POSTL_COD1_VEND TYPE STRING,
HOUSE_NO_VEND TYPE STRING,
STREET_VEND TYPE STRING,
REGION_VEND TYPE STRING,
TEL1_NUMBR_VEND TYPE STRING,
TEL1_EXT_VEND TYPE STRING,
FAX_NUMBER_VEND TYPE STRING,
COUNTRY_VEND TYPE STRING,
FAX_EXTENS_VEND TYPE STRING,
IMS_ADDRESS_VEND TYPE STRING,
IMS_INVOICE_ID_ITEM TYPE STRING,
NUMBER_INT_ITEM TYPE STRING,
BE_REFOBJ_ITEM TYPE STRING,
BE_REFOBJ_ITEM_ITEM TYPE STRING,
QUANTITY_ITEM TYPE STRING,
UNIT_ITEM TYPE STRING,
PRICE_ITEM TYPE STRING,
CURRENCY_ITEM TYPE STRING,
VALUE_ITEM TYPE STRING,
ORDERED_PROD_ITEM TYPE STRING,
DESCRIPTION_ITEM TYPE STRING,
IMS_INVOICE_NO_ITEM TYPE STRING,
IMS_IV_ITM_VD_ID_ITEM TYPE STRING,
PRODUCT_ITEM TYPE STRING,
IMS_QTY_ORDERED_ITEM TYPE STRING,
IMS_QTY_RECEIVED_ITEM TYPE STRING,
PO_PRICE_ITEM TYPE STRING,
IMS_ITEM_PROP_ITEM TYPE STRING,
ACC_CAT_ITEM TYPE STRING,
G_L_ACCT_ITEM TYPE STRING,
GENERIC_ACC_ITEM TYPE STRING,
IMS_STATUS_FEED TYPE STRING,
IMS_COMMENT_FEED TYPE STRING,
IMS_SIGNATURE_FEED TYPE STRING,
MESSAGE_TXT TYPE STRING,
MESSAGE_NR_TXT TYPE STRING,
MESSAGE_TITLE TYPE STRING,
DELIV_DATE_ITEM TYPE STRING,
NEW_DELIV_DATE_ITEM TYPE STRING,
FIRSTNAME_EXT TYPE STRING,
LASTNAME_EXT TYPE STRING,
CITY_EXT TYPE STRING,
POSTL_COD1_EXT TYPE STRING,
HOUSE_NO_EXT TYPE STRING,
STREET_EXT TYPE STRING,
REGION_EXT TYPE STRING,
TEL1_NUMBR_EXT TYPE STRING,
TEL1_EXT_EXT TYPE STRING,
FAX_NUMBER_EXT TYPE STRING,
COUNTRY_EXT TYPE STRING,
FAX_EXTENS_EXT TYPE STRING,
E_MAIL_EXT TYPE STRING,
COUNTRYISO_EXT TYPE STRING,
FULLNAME_EXT TYPE STRING,
C_O_NAME_EXT TYPE STRING,
DISTRICT_EXT TYPE STRING,
PO_BOX_EXT TYPE STRING,END OF T_EKKO_STR. DATA: WA_BBP_IMS_IV_ADS_TXT_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_BBP_IMS_IV_ADS_TXT_STR-GUID_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-REF_DOC_NO_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-OBJECT_ID_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-POSTING_DATE_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-POSTING_DATE_FI_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-CURRENCY_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-GROSS_AMOUNT_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_SOURCE_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_SUBTOTAL_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_TAX_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_SHIPPING_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_BUKRS_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_BELNR_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_GJAHR_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_NAME_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_SOURCE_DOC_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_SOURCE_URL_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-PMNTTRMS_HDR sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_COMP_DESC_COMP sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-CITY_COMP sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-POSTL_COD1_COMP sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-STREET_COMP sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-HOUSE_NO_COMP sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-REGION_COMP sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-COUNTRY_COMP sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_COMP_TEL_COMP sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_COMP_FAX_COMP sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_PAYMENT_ID_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-CITY_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-POSTL_COD1_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-HOUSE_NO_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-STREET_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-REGION_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-TEL1_NUMBR__PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-TEL1_EXT_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-FAX_NUMBER_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-COUNTRY_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-FAX_EXTENS_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_PAYMENT_DESC_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_ADDRESS_PAY sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_REQUESTER_ID_REQ sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_VENDOR_ID_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_VENDOR_DESC_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-CITY_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-POSTL_COD1_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-HOUSE_NO_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-STREET_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-REGION_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-TEL1_NUMBR_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-TEL1_EXT_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-FAX_NUMBER_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-COUNTRY_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-FAX_EXTENS_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_ADDRESS_VEND sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_INVOICE_ID_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-NUMBER_INT_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-BE_REFOBJ_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-BE_REFOBJ_ITEM_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-QUANTITY_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-UNIT_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-PRICE_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-CURRENCY_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-VALUE_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-ORDERED_PROD_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-DESCRIPTION_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_INVOICE_NO_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_IV_ITM_VD_ID_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-PRODUCT_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_QTY_ORDERED_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_QTY_RECEIVED_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-PO_PRICE_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_ITEM_PROP_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-ACC_CAT_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-G_L_ACCT_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-GENERIC_ACC_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_STATUS_FEED sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_COMMENT_FEED sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-IMS_SIGNATURE_FEED sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-MESSAGE_TXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-MESSAGE_NR_TXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-MESSAGE_TITLE sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-DELIV_DATE_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-NEW_DELIV_DATE_ITEM sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-FIRSTNAME_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-LASTNAME_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-CITY_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-POSTL_COD1_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-HOUSE_NO_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-STREET_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-REGION_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-TEL1_NUMBR_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-TEL1_EXT_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-FAX_NUMBER_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-COUNTRY_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-FAX_EXTENS_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-E_MAIL_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-COUNTRYISO_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-FULLNAME_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-C_O_NAME_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-DISTRICT_EXT sy-vline
WA_BBP_IMS_IV_ADS_TXT_STR-PO_BOX_EXT sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
