ABAP Select data from SAP table /BOFU/ADDRS_ADDRESS_COMPLETE 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 /BOFU/ADDRS_ADDRESS_COMPLETE 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 /BOFU/ADDRS_ADDRESS_COMPLETE. 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 /BOFU/ADDRS_ADDRESS_COMPLETE 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_/BOFU/ADDRS_ADDRESS_COMPLETE TYPE STANDARD TABLE OF /BOFU/ADDRS_ADDRESS_COMPLETE,
      WA_/BOFU/ADDRS_ADDRESS_COMPLETE TYPE /BOFU/ADDRS_ADDRESS_COMPLETE,
      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: </BOFU/ADDRS_ADDRESS_COMPLETE> TYPE /BOFU/ADDRS_ADDRESS_COMPLETE.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /BOFU/ADDRS_ADDRESS_COMPLETE
  INTO TABLE IT_/BOFU/ADDRS_ADDRESS_COMPLETE.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /BOFU/ADDRS_ADDRESS_COMPLETE
*  INTO TABLE @DATA(IT_/BOFU/ADDRS_ADDRESS_COMPLETE2).
*--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_/BOFU/ADDRS_ADDRESS_COMPLETE INDEX 1 INTO DATA(WA_/BOFU/ADDRS_ADDRESS_COMPLETE2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/BOFU/ADDRS_ADDRESS_COMPLETE ASSIGNING </BOFU/ADDRS_ADDRESS_COMPLETE>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</BOFU/ADDRS_ADDRESS_COMPLETE>-ADDRESS_ID = 1.
</BOFU/ADDRS_ADDRESS_COMPLETE>-DATA = 1.
</BOFU/ADDRS_ADDRESS_COMPLETE>-COMMUNICATION_DATA = 1.
</BOFU/ADDRS_ADDRESS_COMPLETE>-TELEPHONE = 1.
</BOFU/ADDRS_ADDRESS_COMPLETE>-FACSIMILE = 1.

ENDLOOP.

LOOP AT IT_/BOFU/ADDRS_ADDRESS_COMPLETE INTO WA_/BOFU/ADDRS_ADDRESS_COMPLETE.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/BOFU/ADDRS_ADDRESS_COMPLETE-EMAIL, sy-vline,
  WA_/BOFU/ADDRS_ADDRESS_COMPLETE-WEB, sy-vline,
  WA_/BOFU/ADDRS_ADDRESS_COMPLETE-TELEX, sy-vline,
  WA_/BOFU/ADDRS_ADDRESS_COMPLETE-TELETEX, sy-vline,
  WA_/BOFU/ADDRS_ADDRESS_COMPLETE-RML, sy-vline,
  WA_/BOFU/ADDRS_ADDRESS_COMPLETE-X400, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/BOFU/ADDRS_ADDRESS_COMPLETE 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_/BOFU/ADDRS_ADDRESS_COMPLETE 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_/BOFU/ADDRS_ADDRESS_COMPLETE INTO WA_/BOFU/ADDRS_ADDRESS_COMPLETE.


*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_/BOFU/ADDRS_ADDRESS_COMPLETE_STR, 
ADDRESS_ID TYPE STRING,
DATA TYPE STRING,
COMMUNICATION_DATA TYPE STRING,
TELEPHONE TYPE STRING,
FACSIMILE TYPE STRING,
EMAIL TYPE STRING,
WEB TYPE STRING,
TELEX TYPE STRING,
TELETEX TYPE STRING,
RML TYPE STRING,
X400 TYPE STRING,
PRINTER TYPE STRING,
SSF TYPE STRING,
PAGER TYPE STRING,
UPDATEFLAG TYPE STRING,
ERROR_STATUS TYPE STRING,
INSERT_INFORMATION TYPE STRING,
ADDRESS_TYPE TYPE STRING,
ADDR_GROUP TYPE STRING,
PERS_GROUP TYPE STRING,
ORGANIZATION_ID TYPE STRING,
PERSON_ID TYPE STRING,
UPDATE_INFORMATION TYPE STRING,
CURRENT_STATE TYPE STRING,
DELETE_INFORMATION TYPE STRING,
ADDRESS_REFERENCE TYPE STRING,
APPL_TABLE TYPE STRING,
APPL_FIELD TYPE STRING,
APPL_KEY TYPE STRING,
ADDR_GROUP TYPE STRING,
OWNER TYPE STRING,
PERSON_REFERENCE TYPE STRING,
APPL_TABLE TYPE STRING,
APPL_FIELD TYPE STRING,
APPL_KEY TYPE STRING,
PERS_ADDR TYPE STRING,
PERS_GROUP TYPE STRING,
ORGANIZATION_ADDRESS_ID TYPE STRING,
OWNER TYPE STRING,
RETAIN_PERSON TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/BOFU/ADDRS_ADDRESS_COMPLETE_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_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-ADDRESS_ID sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-DATA sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-COMMUNICATION_DATA sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-TELEPHONE sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-FACSIMILE sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-EMAIL sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-WEB sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-TELEX sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-TELETEX sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-RML sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-X400 sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-PRINTER sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-SSF sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-PAGER sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-UPDATEFLAG sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-ERROR_STATUS sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-INSERT_INFORMATION sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-ADDRESS_TYPE sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-ADDR_GROUP sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-PERS_GROUP sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-ORGANIZATION_ID sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-PERSON_ID sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-UPDATE_INFORMATION sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-CURRENT_STATE sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-DELETE_INFORMATION sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-ADDRESS_REFERENCE sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-APPL_TABLE sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-APPL_FIELD sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-APPL_KEY sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-ADDR_GROUP sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-OWNER sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-PERSON_REFERENCE sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-APPL_TABLE sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-APPL_FIELD sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-APPL_KEY sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-PERS_ADDR sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-PERS_GROUP sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-ORGANIZATION_ADDRESS_ID sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-OWNER sy-vline 
WA_/BOFU/ADDRS_ADDRESS_COMPLETE_STR-RETAIN_PERSON sy-vline      INTO ld_text SEPARATED BY SPACE.

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