ABAP Select data from SAP table FCLM_BAM_S_ACLINK2_ATT 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 FCLM_BAM_S_ACLINK2_ATT 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 FCLM_BAM_S_ACLINK2_ATT. 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 FCLM_BAM_S_ACLINK2_ATT 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_FCLM_BAM_S_ACLINK2_ATT TYPE STANDARD TABLE OF FCLM_BAM_S_ACLINK2_ATT,
      WA_FCLM_BAM_S_ACLINK2_ATT TYPE FCLM_BAM_S_ACLINK2_ATT,
      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: <FCLM_BAM_S_ACLINK2_ATT> TYPE FCLM_BAM_S_ACLINK2_ATT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FCLM_BAM_S_ACLINK2_ATT
*  INTO TABLE @DATA(IT_FCLM_BAM_S_ACLINK2_ATT2).
*--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_FCLM_BAM_S_ACLINK2_ATT INDEX 1 INTO DATA(WA_FCLM_BAM_S_ACLINK2_ATT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FCLM_BAM_S_ACLINK2_ATT>-MANDT = 1.
<FCLM_BAM_S_ACLINK2_ATT>-ACC_ID = 1.
<FCLM_BAM_S_ACLINK2_ATT>-GUID = 1.
<FCLM_BAM_S_ACLINK2_ATT>-REVISION = 1.
<FCLM_BAM_S_ACLINK2_ATT>-VALID_FROM = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FCLM_BAM_S_ACLINK2_ATT-VALID_TO, sy-vline,
  WA_FCLM_BAM_S_ACLINK2_ATT-HERKU, sy-vline,
  WA_FCLM_BAM_S_ACLINK2_ATT-BUKRS, sy-vline,
  WA_FCLM_BAM_S_ACLINK2_ATT-HBKID, sy-vline,
  WA_FCLM_BAM_S_ACLINK2_ATT-HKTID, sy-vline,
  WA_FCLM_BAM_S_ACLINK2_ATT-REMOTEACCOUNT, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FCLM_BAM_S_ACLINK2_ATT 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_FCLM_BAM_S_ACLINK2_ATT 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_FCLM_BAM_S_ACLINK2_ATT INTO WA_FCLM_BAM_S_ACLINK2_ATT.


*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 HERKU
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FCLM_BAM_S_ACLINK2_ATT-HERKU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FCLM_BAM_S_ACLINK2_ATT-HERKU.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field FDGRP
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FCLM_BAM_S_ACLINK2_ATT-FDGRP
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FCLM_BAM_S_ACLINK2_ATT-FDGRP.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field HKONT
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FCLM_BAM_S_ACLINK2_ATT-HKONT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FCLM_BAM_S_ACLINK2_ATT-HKONT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field WEKON
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FCLM_BAM_S_ACLINK2_ATT-WEKON
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FCLM_BAM_S_ACLINK2_ATT-WEKON.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field WKKON
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FCLM_BAM_S_ACLINK2_ATT-WKKON
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FCLM_BAM_S_ACLINK2_ATT-WKKON.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field WIKON
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FCLM_BAM_S_ACLINK2_ATT-WIKON
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FCLM_BAM_S_ACLINK2_ATT-WIKON.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field OLD_HKONT
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FCLM_BAM_S_ACLINK2_ATT-OLD_HKONT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FCLM_BAM_S_ACLINK2_ATT-OLD_HKONT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field TARGET_HKONT
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FCLM_BAM_S_ACLINK2_ATT-TARGET_HKONT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FCLM_BAM_S_ACLINK2_ATT-TARGET_HKONT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field EDIPN
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_FCLM_BAM_S_ACLINK2_ATT-EDIPN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FCLM_BAM_S_ACLINK2_ATT-EDIPN.
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_FCLM_BAM_S_ACLINK2_ATT_STR, 
MANDT TYPE STRING,
ACC_ID TYPE STRING,
GUID TYPE STRING,
REVISION TYPE STRING,
VALID_FROM TYPE STRING,
VALID_TO TYPE STRING,
HERKU TYPE STRING,
BUKRS TYPE STRING,
HBKID TYPE STRING,
HKTID TYPE STRING,
REMOTEACCOUNT TYPE STRING,
BANKN TYPE STRING,
BKONT TYPE STRING,
REFZL TYPE STRING,
DTAAI TYPE STRING,
BNKN2 TYPE STRING,
IS_REUSED TYPE STRING,
FDGRP TYPE STRING,
ABWAE TYPE STRING,
HKONT TYPE STRING,
WEKON TYPE STRING,
MINDT TYPE STRING,
HBID1 TYPE STRING,
HKID1 TYPE STRING,
HBID2 TYPE STRING,
HKID2 TYPE STRING,
WKKON TYPE STRING,
WIKON TYPE STRING,
NEW_BACL_FLAG TYPE STRING,
OLD_HKONT TYPE STRING,
MIGRATION_STATUS TYPE STRING,
CASH_POOLING_FLAG TYPE STRING,
BANK_ACCOUNT_AUTH_GROUP TYPE STRING,
NETTING_GROUP TYPE STRING,
TOGRU TYPE STRING,
XSPEB TYPE STRING,
POSTING_BLOCK_DATE TYPE STRING,
TARGET_HKONT TYPE STRING,
BALANCE_TRANSFER_DATE TYPE STRING,
BS_POST_CAT TYPE STRING,
BS2FQM_MODE TYPE STRING,
REQUEST_ID TYPE STRING,
TEMP_ID TYPE STRING,
LINE_ID TYPE STRING,
BANKS TYPE STRING,
BANKL TYPE STRING,
BANKA TYPE STRING,
PROVZ TYPE STRING,
STRAS TYPE STRING,
ORT01 TYPE STRING,
BRNCH TYPE STRING,
SWIFT TYPE STRING,
BGRUP TYPE STRING,
BNKLZ TYPE STRING,
XPGRO TYPE STRING,
IDCATEGORY TYPE STRING,
LANDX50 TYPE STRING,
BEZEI TYPE STRING,
TEXT_SAKNR TYPE STRING,
TEXT_BOE_PAYABLE TYPE STRING,
TEXT_DISCOUNT_ACCT TYPE STRING,
TEXT_COLLECTION_ACCT TYPE STRING,
TEXT_HBK1 TYPE STRING,
TEXT_HBK_ACCT_1 TYPE STRING,
TEXT_HBK2 TYPE STRING,
TEXT_HBK_ACCT_2 TYPE STRING,
EDIPN TYPE STRING,
EDISN TYPE STRING,
DTBID TYPE STRING,
DTELZ TYPE STRING,
DTKID TYPE STRING,
DTFIN TYPE STRING,
DTGLZ TYPE STRING,
DTGBK TYPE STRING,
DTGKO TYPE STRING,
DTGIS TYPE STRING,
DTAWS TYPE STRING,
DTVTA TYPE STRING,
DTXBB TYPE STRING,
DTLBE TYPE STRING,
DTXMS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FCLM_BAM_S_ACLINK2_ATT_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_FCLM_BAM_S_ACLINK2_ATT_STR-MANDT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-ACC_ID sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-GUID sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-REVISION sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-VALID_FROM sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-VALID_TO sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-HERKU sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BUKRS sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-HBKID sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-HKTID sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-REMOTEACCOUNT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BANKN sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BKONT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-REFZL sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTAAI sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BNKN2 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-IS_REUSED sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-FDGRP sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-ABWAE sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-HKONT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-WEKON sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-MINDT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-HBID1 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-HKID1 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-HBID2 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-HKID2 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-WKKON sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-WIKON sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-NEW_BACL_FLAG sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-OLD_HKONT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-MIGRATION_STATUS sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-CASH_POOLING_FLAG sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BANK_ACCOUNT_AUTH_GROUP sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-NETTING_GROUP sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TOGRU sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-XSPEB sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-POSTING_BLOCK_DATE sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TARGET_HKONT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BALANCE_TRANSFER_DATE sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BS_POST_CAT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BS2FQM_MODE sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-REQUEST_ID sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TEMP_ID sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-LINE_ID sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BANKS sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BANKL sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BANKA sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-PROVZ sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-STRAS sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-ORT01 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BRNCH sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-SWIFT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BGRUP sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BNKLZ sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-XPGRO sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-IDCATEGORY sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-LANDX50 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-BEZEI sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TEXT_SAKNR sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TEXT_BOE_PAYABLE sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TEXT_DISCOUNT_ACCT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TEXT_COLLECTION_ACCT sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TEXT_HBK1 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TEXT_HBK_ACCT_1 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TEXT_HBK2 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-TEXT_HBK_ACCT_2 sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-EDIPN sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-EDISN sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTBID sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTELZ sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTKID sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTFIN sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTGLZ sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTGBK sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTGKO sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTGIS sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTAWS sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTVTA sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTXBB sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTLBE sy-vline 
WA_FCLM_BAM_S_ACLINK2_ATT_STR-DTXMS sy-vline      INTO ld_text SEPARATED BY SPACE.

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