ABAP Select data from SAP table CRM_PROVIDER_ITEM_WRAPPER_ATTR 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 CRM_PROVIDER_ITEM_WRAPPER_ATTR 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 CRM_PROVIDER_ITEM_WRAPPER_ATTR. 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 CRM_PROVIDER_ITEM_WRAPPER_ATTR 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_CRM_PROVIDER_ITEM_WRAPPER_ATTR TYPE STANDARD TABLE OF CRM_PROVIDER_ITEM_WRAPPER_ATTR, WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR TYPE CRM_PROVIDER_ITEM_WRAPPER_ATTR, 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: <CRM_PROVIDER_ITEM_WRAPPER_ATTR> TYPE CRM_PROVIDER_ITEM_WRAPPER_ATTR. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_CRM_PROVIDER_ITEM_WRAPPER_ATTR. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM CRM_PROVIDER_ITEM_WRAPPER_ATTR INTO TABLE IT_CRM_PROVIDER_ITEM_WRAPPER_ATTR. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM CRM_PROVIDER_ITEM_WRAPPER_ATTR * INTO TABLE @DATA(IT_CRM_PROVIDER_ITEM_WRAPPER_ATTR2). *--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_CRM_PROVIDER_ITEM_WRAPPER_ATTR INDEX 1 INTO DATA(WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_CRM_PROVIDER_ITEM_WRAPPER_ATTR ASSIGNING <CRM_PROVIDER_ITEM_WRAPPER_ATTR>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<CRM_PROVIDER_ITEM_WRAPPER_ATTR>-GUID = 1.
<CRM_PROVIDER_ITEM_WRAPPER_ATTR>-OBJECT_TYPE = 1.
<CRM_PROVIDER_ITEM_WRAPPER_ATTR>-ORDERED_PROD = 1.
<CRM_PROVIDER_ITEM_WRAPPER_ATTR>-DESCRIPTION = 1.
<CRM_PROVIDER_ITEM_WRAPPER_ATTR>-OPTIONAL = 1.
ENDLOOP. LOOP AT IT_CRM_PROVIDER_ITEM_WRAPPER_ATTR INTO WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CHECKED, sy-vline,
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-OPTIONGROUP, sy-vline,
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-IS_CONTRACT, sy-vline,
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-IS_CONFIGURABLE, sy-vline,
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CONFIG_ICON, sy-vline,
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CONFIG_TEXT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR 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_CRM_PROVIDER_ITEM_WRAPPER_ATTR 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_CRM_PROVIDER_ITEM_WRAPPER_ATTR INTO WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR. *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.
*Conversion exit TSTPS, internal->external for field ISTCONTSRTTS CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-ISTCONTSRTTS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-ISTCONTSRTTS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTPS, internal->external for field ISTCONTENDTS CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-ISTCONTENDTS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-ISTCONTENDTS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTPS, internal->external for field CANCRECEIVE CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CANCRECEIVE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CANCRECEIVE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTPS, internal->external for field CANCREQUEST CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CANCREQUEST IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CANCREQUEST.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTPS, internal->external for field CANCDATE CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CANCDATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CANCDATE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTPS, internal->external for field ISTRUNTMBEG CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-ISTRUNTMBEG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-ISTRUNTMBEG.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTPS, internal->external for field ISTRUNTMEND CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-ISTRUNTMEND IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-ISTRUNTMEND.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTPS, internal->external for field CONTEND CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CONTEND IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CONTEND.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTPS, internal->external for field CONTSTART CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CONTSTART IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CONTSTART.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field CONTDURA_UNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CONTDURA_UNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CONTDURA_UNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field A3EXTREF CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-A3EXTREF IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-A3EXTREF.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field PROCESS_QTY_UNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-PROCESS_QTY_UNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-PROCESS_QTY_UNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTPS, internal->external for field REQ_DELIVERY_DATE CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-REQ_DELIVERY_DATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-REQ_DELIVERY_DATE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTPS, internal->external for field CON_DELIVERY_DATE CALL FUNCTION 'CONVERSION_EXIT_TSTPS_OUTPUT' EXPORTING input = WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CON_DELIVERY_DATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR-CON_DELIVERY_DATE.
WRITE:/ 'New Value:', ld_input.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR,
GUID TYPE STRING,
OBJECT_TYPE TYPE STRING,
ORDERED_PROD TYPE STRING,
DESCRIPTION TYPE STRING,
OPTIONAL TYPE STRING,
CHECKED TYPE STRING,
OPTIONGROUP TYPE STRING,
IS_CONTRACT TYPE STRING,
IS_CONFIGURABLE TYPE STRING,
CONFIG_ICON TYPE STRING,
CONFIG_TEXT TYPE STRING,
CONFIG_TOOLTIP TYPE STRING,
SERVICE_ICON TYPE STRING,
SERVICE_TEXT TYPE STRING,
SERVICE_TOOLTIP TYPE STRING,
STATUS_ICON TYPE STRING,
STATUS_TOOLTIP TYPE STRING,
NET_VALUE TYPE STRING,
TAX_AMOUNT TYPE STRING,
GROSS_VALUE TYPE STRING,
CURRENCY TYPE STRING,
ISTCONTSRTTS TYPE STRING,
ISTCONTENDTS TYPE STRING,
CANCRECEIVE TYPE STRING,
CANCREQUEST TYPE STRING,
CANCDATE TYPE STRING,
ISTRUNTMBEG TYPE STRING,
ISTRUNTMEND TYPE STRING,
CONTEND TYPE STRING,
CONTSTART TYPE STRING,
CONTDURA TYPE STRING,
CONTDURA_UNIT TYPE STRING,
A3EXTREF TYPE STRING,
A3PRCPROC TYPE STRING,
A3PROCESS TYPE STRING,
A3PROC_ID TYPE STRING,
A3SCGROUP TYPE STRING,
A3SELTYPE TYPE STRING,
A3SELTYPET TYPE STRING,
A3SERVTYP TYPE STRING,
QUANTITY TYPE STRING,
PROCESS_QTY_UNIT TYPE STRING,
REQ_DELIVERY_DATE TYPE STRING,
CON_DELIVERY_DATE TYPE STRING,
ATP_STATUS TYPE STRING,
STATUS_EXT TYPE STRING,
LOCK TYPE STRING,
CHANG_SCHED TYPE STRING,
SERVICE_ID TYPE STRING,
PACKAGE_DESCR TYPE STRING,
RECURRING_CHARGE TYPE STRING,
RECURRING_TAX TYPE STRING,
RECURRING_GROSS TYPE STRING,
REC_DURATION TYPE STRING,
REC_TIME_UNIT TYPE STRING,
REC_MAIN_ITM_CUM TYPE STRING,
A3SCDOCID TYPE STRING,
SERVICE_LOCATION_SHORT TYPE STRING,
DOC_STATUS TYPE STRING,
DOC_STATUS_ICON TYPE STRING,
NUMBER_INT TYPE STRING,
PROCESSING_STATUS TYPE STRING,
ACTIVATION_STATUS TYPE STRING,
ORDERADM_I_DUMMY TYPE STRING,END OF T_EKKO_STR. DATA: WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_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_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-GUID sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-OBJECT_TYPE sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-ORDERED_PROD sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-DESCRIPTION sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-OPTIONAL sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CHECKED sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-OPTIONGROUP sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-IS_CONTRACT sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-IS_CONFIGURABLE sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CONFIG_ICON sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CONFIG_TEXT sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CONFIG_TOOLTIP sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-SERVICE_ICON sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-SERVICE_TEXT sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-SERVICE_TOOLTIP sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-STATUS_ICON sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-STATUS_TOOLTIP sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-NET_VALUE sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-TAX_AMOUNT sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-GROSS_VALUE sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CURRENCY sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-ISTCONTSRTTS sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-ISTCONTENDTS sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CANCRECEIVE sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CANCREQUEST sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CANCDATE sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-ISTRUNTMBEG sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-ISTRUNTMEND sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CONTEND sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CONTSTART sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CONTDURA sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CONTDURA_UNIT sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-A3EXTREF sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-A3PRCPROC sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-A3PROCESS sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-A3PROC_ID sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-A3SCGROUP sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-A3SELTYPE sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-A3SELTYPET sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-A3SERVTYP sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-QUANTITY sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-PROCESS_QTY_UNIT sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-REQ_DELIVERY_DATE sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CON_DELIVERY_DATE sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-ATP_STATUS sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-STATUS_EXT sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-LOCK sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-CHANG_SCHED sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-SERVICE_ID sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-PACKAGE_DESCR sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-RECURRING_CHARGE sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-RECURRING_TAX sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-RECURRING_GROSS sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-REC_DURATION sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-REC_TIME_UNIT sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-REC_MAIN_ITM_CUM sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-A3SCDOCID sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-SERVICE_LOCATION_SHORT sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-DOC_STATUS sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-DOC_STATUS_ICON sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-NUMBER_INT sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-PROCESSING_STATUS sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-ACTIVATION_STATUS sy-vline
WA_CRM_PROVIDER_ITEM_WRAPPER_ATTR_STR-ORDERADM_I_DUMMY sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.