ABAP Select data from SAP table UAB_S_RFC_OBJECT_DATA_PDCE into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP UAB_S_RFC_OBJECT_DATA_PDCE 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 UAB_S_RFC_OBJECT_DATA_PDCE. 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 UAB_S_RFC_OBJECT_DATA_PDCE 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_UAB_S_RFC_OBJECT_DATA_PDCE TYPE STANDARD TABLE OF UAB_S_RFC_OBJECT_DATA_PDCE,
      WA_UAB_S_RFC_OBJECT_DATA_PDCE TYPE UAB_S_RFC_OBJECT_DATA_PDCE,
      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: <UAB_S_RFC_OBJECT_DATA_PDCE> TYPE UAB_S_RFC_OBJECT_DATA_PDCE.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_UAB_S_RFC_OBJECT_DATA_PDCE.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM UAB_S_RFC_OBJECT_DATA_PDCE
  INTO TABLE IT_UAB_S_RFC_OBJECT_DATA_PDCE.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM UAB_S_RFC_OBJECT_DATA_PDCE
*  INTO TABLE @DATA(IT_UAB_S_RFC_OBJECT_DATA_PDCE2).
*--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_UAB_S_RFC_OBJECT_DATA_PDCE INDEX 1 INTO DATA(WA_UAB_S_RFC_OBJECT_DATA_PDCE2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_UAB_S_RFC_OBJECT_DATA_PDCE ASSIGNING <UAB_S_RFC_OBJECT_DATA_PDCE>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<UAB_S_RFC_OBJECT_DATA_PDCE>-ACC_OBJ_STATUS = 1.
<UAB_S_RFC_OBJECT_DATA_PDCE>-UAB_NOT_PUBLISH = 1.
<UAB_S_RFC_OBJECT_DATA_PDCE>-CO_AREA = 1.
<UAB_S_RFC_OBJECT_DATA_PDCE>-COSTCENTER = 1.
<UAB_S_RFC_OBJECT_DATA_PDCE>-PROFIT_CTR = 1.

ENDLOOP.

LOOP AT IT_UAB_S_RFC_OBJECT_DATA_PDCE INTO WA_UAB_S_RFC_OBJECT_DATA_PDCE.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_UAB_S_RFC_OBJECT_DATA_PDCE-COMP_CODE, sy-vline,
  WA_UAB_S_RFC_OBJECT_DATA_PDCE-BUS_AREA, sy-vline,
  WA_UAB_S_RFC_OBJECT_DATA_PDCE-COSTELMNT, sy-vline,
  WA_UAB_S_RFC_OBJECT_DATA_PDCE-ABCPROCESS, sy-vline,
  WA_UAB_S_RFC_OBJECT_DATA_PDCE-ACTTYPE, sy-vline,
  WA_UAB_S_RFC_OBJECT_DATA_PDCE-PCPITEMCAT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_UAB_S_RFC_OBJECT_DATA_PDCE 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_UAB_S_RFC_OBJECT_DATA_PDCE 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_UAB_S_RFC_OBJECT_DATA_PDCE INTO WA_UAB_S_RFC_OBJECT_DATA_PDCE.


*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 CUNIT, internal->external for field UNIT
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_UAB_S_RFC_OBJECT_DATA_PDCE-UNIT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_UAB_S_RFC_OBJECT_DATA_PDCE-UNIT.
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_UAB_S_RFC_OBJECT_DATA_PDCE_STR, 
ACC_OBJ_STATUS TYPE STRING,
UAB_NOT_PUBLISH TYPE STRING,
CO_AREA TYPE STRING,
COSTCENTER TYPE STRING,
PROFIT_CTR TYPE STRING,
COMP_CODE TYPE STRING,
BUS_AREA TYPE STRING,
COSTELMNT TYPE STRING,
ABCPROCESS TYPE STRING,
ACTTYPE TYPE STRING,
PCPITEMCAT TYPE STRING,
CPR_EXT_ID TYPE STRING,
CPR_VRSN TYPE STRING,
COSTVAR TYPE STRING,
CEVERS TYPE STRING,
PLANT TYPE STRING,
MATERIAL TYPE STRING,
PRICE_TYPE TYPE STRING,
COS_DATVAL TYPE STRING,
ORIGINGRP TYPE STRING,
VAL_CLASS TYPE STRING,
PURCH_ORG TYPE STRING,
INFO_REC TYPE STRING,
MATL_GROUP TYPE STRING,
VENDOR TYPE STRING,
CEPCCENT TYPE STRING,
CEPACTT TYPE STRING,
CEPMAT TYPE STRING,
SERVICE TYPE STRING,
CESNUM TYPE STRING,
RESP_PERS TYPE STRING,
DUEDATE TYPE STRING,
CEDELSTATE TYPE STRING,
CEDELPCODE TYPE STRING,
CEDELCNTRY TYPE STRING,
CEDELCITY TYPE STRING,
CECNTRYPRP TYPE STRING,
CECNTRYREQ TYPE STRING,
COUNTRY TYPE STRING,
CESAMPLE TYPE STRING,
CESAMPLEPB TYPE STRING,
CEREQUOTE TYPE STRING,
CERISK TYPE STRING,
CEASGNTYPE TYPE STRING,
CECETYPE TYPE STRING,
CUSTOMER TYPE STRING,
ORGUNIT TYPE STRING,
CPR_PRIO TYPE STRING,
CERECDATE TYPE STRING,
CEIMPTNC TYPE STRING,
ACC_LOGICSYS TYPE STRING,
CEPRTYPE TYPE STRING,
CECUSTRFQ TYPE STRING,
CEREFOBJID TYPE STRING,
CEBULK TYPE STRING,
MANU_MATNR TYPE STRING,
MANUFACTOR TYPE STRING,
PROD_HIER TYPE STRING,
CEMEASURE TYPE STRING,
CEMSRTYPE TYPE STRING,
CEMSRGRD TYPE STRING,
CEMSRITEM TYPE STRING,
CETOOL TYPE STRING,
CETOOLTYP TYPE STRING,
TXTLG TYPE STRING,
CEESTPR TYPE STRING,
CEPRSIZE TYPE STRING,
UNIT TYPE STRING,
CURRENCY TYPE STRING,END OF T_EKKO_STR.
DATA: WA_UAB_S_RFC_OBJECT_DATA_PDCE_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_UAB_S_RFC_OBJECT_DATA_PDCE_STR-ACC_OBJ_STATUS sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-UAB_NOT_PUBLISH sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CO_AREA sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-COSTCENTER sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-PROFIT_CTR sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-COMP_CODE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-BUS_AREA sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-COSTELMNT sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-ABCPROCESS sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-ACTTYPE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-PCPITEMCAT sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CPR_EXT_ID sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CPR_VRSN sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-COSTVAR sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEVERS sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-PLANT sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-MATERIAL sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-PRICE_TYPE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-COS_DATVAL sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-ORIGINGRP sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-VAL_CLASS sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-PURCH_ORG sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-INFO_REC sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-MATL_GROUP sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-VENDOR sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEPCCENT sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEPACTT sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEPMAT sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-SERVICE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CESNUM sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-RESP_PERS sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-DUEDATE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEDELSTATE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEDELPCODE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEDELCNTRY sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEDELCITY sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CECNTRYPRP sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CECNTRYREQ sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-COUNTRY sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CESAMPLE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CESAMPLEPB sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEREQUOTE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CERISK sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEASGNTYPE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CECETYPE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CUSTOMER sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-ORGUNIT sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CPR_PRIO sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CERECDATE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEIMPTNC sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-ACC_LOGICSYS sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEPRTYPE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CECUSTRFQ sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEREFOBJID sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEBULK sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-MANU_MATNR sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-MANUFACTOR sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-PROD_HIER sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEMEASURE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEMSRTYPE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEMSRGRD sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEMSRITEM sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CETOOL sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CETOOLTYP sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-TXTLG sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEESTPR sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CEPRSIZE sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-UNIT sy-vline 
WA_UAB_S_RFC_OBJECT_DATA_PDCE_STR-CURRENCY sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.