ABAP Select data from SAP table COPENDISPUTECASE 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 COPENDISPUTECASE 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 COPENDISPUTECASE. 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 COPENDISPUTECASE 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_COPENDISPUTECASE TYPE STANDARD TABLE OF COPENDISPUTECASE, WA_COPENDISPUTECASE TYPE COPENDISPUTECASE, 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: <COPENDISPUTECASE> TYPE COPENDISPUTECASE. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_COPENDISPUTECASE. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM COPENDISPUTECASE INTO TABLE IT_COPENDISPUTECASE. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM COPENDISPUTECASE * INTO TABLE @DATA(IT_COPENDISPUTECASE2). *--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_COPENDISPUTECASE INDEX 1 INTO DATA(WA_COPENDISPUTECASE2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_COPENDISPUTECASE ASSIGNING <COPENDISPUTECASE>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<COPENDISPUTECASE>-MANDT = 1.
<COPENDISPUTECASE>-DISPUTECASEUUID = 1.
<COPENDISPUTECASE>-CASEID = 1.
<COPENDISPUTECASE>-COMPANYCODE = 1.
<COPENDISPUTECASE>-CUSTOMER = 1.
ENDLOOP. LOOP AT IT_COPENDISPUTECASE INTO WA_COPENDISPUTECASE. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_COPENDISPUTECASE-COMPANYCODENAME, sy-vline,
WA_COPENDISPUTECASE-CUSTOMERNAME, sy-vline,
WA_COPENDISPUTECASE-CUSTOMERCOUNTRY, sy-vline,
WA_COPENDISPUTECASE-COUNTRYNAME, sy-vline,
WA_COPENDISPUTECASE-CUSTOMERREGION, sy-vline,
WA_COPENDISPUTECASE-REGIONNAME, sy-vline.
ENDLOOP. *Add any further fields from structure WA_COPENDISPUTECASE 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_COPENDISPUTECASE 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_COPENDISPUTECASE INTO WA_COPENDISPUTECASE. *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 ALPHA, internal->external for field CASEID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COPENDISPUTECASE-CASEID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COPENDISPUTECASE-CASEID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field CUSTOMER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COPENDISPUTECASE-CUSTOMER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COPENDISPUTECASE-CUSTOMER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit AC152, internal->external for field DISPUTEDAMOUNTINDISPLAYCRCY CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT' EXPORTING input = WA_COPENDISPUTECASE-DISPUTEDAMOUNTINDISPLAYCRCY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COPENDISPUTECASE-DISPUTEDAMOUNTINDISPLAYCRCY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field DISPUTECASE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COPENDISPUTECASE-DISPUTECASE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COPENDISPUTECASE-DISPUTECASE.
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_COPENDISPUTECASE_STR,
MANDT TYPE STRING,
DISPUTECASEUUID TYPE STRING,
CASEID TYPE STRING,
COMPANYCODE TYPE STRING,
CUSTOMER TYPE STRING,
COMPANYCODENAME TYPE STRING,
CUSTOMERNAME TYPE STRING,
CUSTOMERCOUNTRY TYPE STRING,
COUNTRYNAME TYPE STRING,
CUSTOMERREGION TYPE STRING,
REGIONNAME TYPE STRING,
DISPUTECASEPROCESSOR TYPE STRING,
DISPUTECASEPROCESSORFULLNAME TYPE STRING,
DISPUTECASECOORDINATOR TYPE STRING,
DSPUTCASECOORDINATORFULLNAME TYPE STRING,
CASETYPE TYPE STRING,
CASETYPENAME TYPE STRING,
DISPUTECASEREASON TYPE STRING,
DISPUTECASEREASONNAME TYPE STRING,
STATUS TYPE STRING,
STATUSNAME TYPE STRING,
STATUSPROFILE TYPE STRING,
CASESTATUSPROFILE TYPE STRING,
CASEPROCESSINGSTATUS TYPE STRING,
CASEPROCESSINGSTATUSNAME TYPE STRING,
DISPUTECASEPRIORITY TYPE STRING,
DISPUTECASEPRIORITYNAME TYPE STRING,
CUSTOMERBASICAUTHORIZATIONGRP TYPE STRING,
CUSTOMERACCOUNTGROUP TYPE STRING,
CASECREATIONDATE TYPE STRING,
DISPUTEDAMOUNTINDISPLAYCRCY TYPE STRING,
NUMBEROFDISPUTECASES TYPE STRING,
DISPUTECASE TYPE STRING,END OF T_EKKO_STR. DATA: WA_COPENDISPUTECASE_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_COPENDISPUTECASE_STR-MANDT sy-vline
WA_COPENDISPUTECASE_STR-DISPUTECASEUUID sy-vline
WA_COPENDISPUTECASE_STR-CASEID sy-vline
WA_COPENDISPUTECASE_STR-COMPANYCODE sy-vline
WA_COPENDISPUTECASE_STR-CUSTOMER sy-vline
WA_COPENDISPUTECASE_STR-COMPANYCODENAME sy-vline
WA_COPENDISPUTECASE_STR-CUSTOMERNAME sy-vline
WA_COPENDISPUTECASE_STR-CUSTOMERCOUNTRY sy-vline
WA_COPENDISPUTECASE_STR-COUNTRYNAME sy-vline
WA_COPENDISPUTECASE_STR-CUSTOMERREGION sy-vline
WA_COPENDISPUTECASE_STR-REGIONNAME sy-vline
WA_COPENDISPUTECASE_STR-DISPUTECASEPROCESSOR sy-vline
WA_COPENDISPUTECASE_STR-DISPUTECASEPROCESSORFULLNAME sy-vline
WA_COPENDISPUTECASE_STR-DISPUTECASECOORDINATOR sy-vline
WA_COPENDISPUTECASE_STR-DSPUTCASECOORDINATORFULLNAME sy-vline
WA_COPENDISPUTECASE_STR-CASETYPE sy-vline
WA_COPENDISPUTECASE_STR-CASETYPENAME sy-vline
WA_COPENDISPUTECASE_STR-DISPUTECASEREASON sy-vline
WA_COPENDISPUTECASE_STR-DISPUTECASEREASONNAME sy-vline
WA_COPENDISPUTECASE_STR-STATUS sy-vline
WA_COPENDISPUTECASE_STR-STATUSNAME sy-vline
WA_COPENDISPUTECASE_STR-STATUSPROFILE sy-vline
WA_COPENDISPUTECASE_STR-CASESTATUSPROFILE sy-vline
WA_COPENDISPUTECASE_STR-CASEPROCESSINGSTATUS sy-vline
WA_COPENDISPUTECASE_STR-CASEPROCESSINGSTATUSNAME sy-vline
WA_COPENDISPUTECASE_STR-DISPUTECASEPRIORITY sy-vline
WA_COPENDISPUTECASE_STR-DISPUTECASEPRIORITYNAME sy-vline
WA_COPENDISPUTECASE_STR-CUSTOMERBASICAUTHORIZATIONGRP sy-vline
WA_COPENDISPUTECASE_STR-CUSTOMERACCOUNTGROUP sy-vline
WA_COPENDISPUTECASE_STR-CASECREATIONDATE sy-vline
WA_COPENDISPUTECASE_STR-DISPUTEDAMOUNTINDISPLAYCRCY sy-vline
WA_COPENDISPUTECASE_STR-NUMBEROFDISPUTECASES sy-vline
WA_COPENDISPUTECASE_STR-DISPUTECASE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.