ABAP Select data from SAP table CMS_STR_BII_CAG_DETAIL_SNG 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 CMS_STR_BII_CAG_DETAIL_SNG 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 CMS_STR_BII_CAG_DETAIL_SNG. 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 CMS_STR_BII_CAG_DETAIL_SNG 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_CMS_STR_BII_CAG_DETAIL_SNG TYPE STANDARD TABLE OF CMS_STR_BII_CAG_DETAIL_SNG,
      WA_CMS_STR_BII_CAG_DETAIL_SNG TYPE CMS_STR_BII_CAG_DETAIL_SNG,
      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: <CMS_STR_BII_CAG_DETAIL_SNG> TYPE CMS_STR_BII_CAG_DETAIL_SNG.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CMS_STR_BII_CAG_DETAIL_SNG
*  INTO TABLE @DATA(IT_CMS_STR_BII_CAG_DETAIL_SNG2).
*--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_CMS_STR_BII_CAG_DETAIL_SNG INDEX 1 INTO DATA(WA_CMS_STR_BII_CAG_DETAIL_SNG2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CMS_STR_BII_CAG_DETAIL_SNG>-COLLATERAL_AGREEMENT_KEY = 1.
<CMS_STR_BII_CAG_DETAIL_SNG>-COLLATERAL_AGREEMENT_ID = 1.
<CMS_STR_BII_CAG_DETAIL_SNG>-COLLATERAL_AGREEMENT_TYPE = 1.
<CMS_STR_BII_CAG_DETAIL_SNG>-EXTENSIONIN = 1.
<CMS_STR_BII_CAG_DETAIL_SNG>-AGREEMENT_BASIC_DATA = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CMS_STR_BII_CAG_DETAIL_SNG-COLLATERAL_AGREEMENT_ID, sy-vline,
  WA_CMS_STR_BII_CAG_DETAIL_SNG-CATEGORYID, sy-vline,
  WA_CMS_STR_BII_CAG_DETAIL_SNG-COLLATERAL_AGREEMENT_TYPE, sy-vline,
  WA_CMS_STR_BII_CAG_DETAIL_SNG-CAGMT_TYPE_NAME, sy-vline,
  WA_CMS_STR_BII_CAG_DETAIL_SNG-NOMINAL_VALUE, sy-vline,
  WA_CMS_STR_BII_CAG_DETAIL_SNG-NOMINAL_VALUE_CURRENCY, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CMS_STR_BII_CAG_DETAIL_SNG 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_CMS_STR_BII_CAG_DETAIL_SNG 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_CMS_STR_BII_CAG_DETAIL_SNG INTO WA_CMS_STR_BII_CAG_DETAIL_SNG.


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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field COLLATERAL_AGREEMENT_ID
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CMS_STR_BII_CAG_DETAIL_SNG-COLLATERAL_AGREEMENT_ID
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CMS_STR_BII_CAG_DETAIL_SNG-COLLATERAL_AGREEMENT_ID.
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_CMS_STR_BII_CAG_DETAIL_SNG_STR, 
COLLATERAL_AGREEMENT_KEY TYPE STRING,
COLLATERAL_AGREEMENT_ID TYPE STRING,
COLLATERAL_AGREEMENT_TYPE TYPE STRING,
EXTENSIONIN TYPE STRING,
AGREEMENT_BASIC_DATA TYPE STRING,
COLLATERAL_AGREEMENT_ID TYPE STRING,
CATEGORYID TYPE STRING,
COLLATERAL_AGREEMENT_TYPE TYPE STRING,
CAGMT_TYPE_NAME TYPE STRING,
NOMINAL_VALUE TYPE STRING,
NOMINAL_VALUE_CURRENCY TYPE STRING,
NOMINAL_VALUE_CURRENCY_ISO TYPE STRING,
COLLATERAL_AGREEMENT_DATE TYPE STRING,
COLLATERAL_AGREMENT_VALID_FROM TYPE STRING,
COLLATERAL_AGREEMENT_VALID_TO TYPE STRING,
COUNTRY_KEY TYPE STRING,
COUNTRY_KEY_ISO TYPE STRING,
IS_GLOBAL_COLLATERAL_AGREEMENT TYPE STRING,
PERCENTAGE_ASSET_VALUE TYPE STRING,
GUARANTEE_RATE TYPE STRING,
SPECIAL_MARKDOWN_PERCENT TYPE STRING,
SPECIAL_MARKDOWN_AMOUNT TYPE STRING,
SPECIAL_MARKDOWN_CURRENCY TYPE STRING,
SPECIAL_MARKDOWN_CURRENCY_ISO TYPE STRING,
COLLATERAL_AGMT_DESCRIPTION TYPE STRING,
RELEASE_FREQUENCY_UNIT TYPE STRING,
RELEASE_FREQUENCY_PERIOD TYPE STRING,
OLD_COLLATERAL_AGREEMENT_ID TYPE STRING,
MIN_QUALITATIVE_EXCEPTION_TYPE TYPE STRING,
MIN_QUALITATIVE_REASON TYPE STRING,
MIN_QUALITATIVE_RQMT_FULFILLED TYPE STRING,
MIN_QUALITATIVE_CRITERION TYPE STRING,
TERMINATION_RIGHT_TYPE TYPE STRING,
TERMINATION_FREQUENCY_UNIT TYPE STRING,
NOTICE_PERIOD_UNIT TYPE STRING,
REQUIRED_NOTICE_PERIOD TYPE STRING,
TERMINATION_NOTICE_DATE TYPE STRING,
TERMINATION_REASON TYPE STRING,
GUARANTEED_TERMINATION_AMOUNT TYPE STRING,
TERMINATION_AMOUNT_CURRENCY TYPE STRING,
TERMINATION_AMOUNT_CURRENCY_IS TYPE STRING,
MINIMUM_STOCK_AMOUNT TYPE STRING,
MINIMUM_STOCK_CURRENCY TYPE STRING,
MINIMUM_STOCK_CURRENCY_ISO TYPE STRING,
ADDITIONAL_RECEIVABLE_ALLOWED TYPE STRING,
ADDITIONAL_RECEIVABLE_DATE TYPE STRING,
SCOPE_OF_INSURANCE_COVER TYPE STRING,
POOL_LIQUIDATION_MODE TYPE STRING,
RELEASE_THRESHOLD TYPE STRING,
CORRESPONDENCE_ROLE TYPE STRING,
BUPR_ID TYPE STRING,
BUPR_TYPE_CODE TYPE STRING,
AGREEMENT_ADMIN_DATA TYPE STRING,
COLLATERAL_AGREEMENT_ID TYPE STRING,
COLLATERAL_AGREEMENT_TYPE TYPE STRING,
ADMIN_ORGANIZATIONAL_UNIT TYPE STRING,
BANK_AREA TYPE STRING,
ORGANIZATION_UNIT1 TYPE STRING,
ORGANIZATION_UNIT2 TYPE STRING,
ORGANIZATION_UNIT3 TYPE STRING,
ORGANIZATION_UNIT4 TYPE STRING,
ORGANIZATION_UNIT5 TYPE STRING,
GUARANTEE_DATA TYPE STRING,
COLLATERAL_AGREEMENT_ID TYPE STRING,
COLLATERAL_AGREEMENT_TYPE TYPE STRING,
IS_COUNTER_GUARANTEE TYPE STRING,
IS_CO_GUARANTEE TYPE STRING,
IS_FIXED_LIABILITY_GUARANTEE TYPE STRING,
IS_DEFAULT_LIABILITY_GUARANTEE TYPE STRING,
DEFAULT_LIABILITY_PERCENTAGE TYPE STRING,
INCLUDE_LINKED_AGREEMENTS TYPE STRING,
AUTHORITIES_APPROVAL TYPE STRING,
IS_ENFORCEABLE TYPE STRING,
LENDING_RATE TYPE STRING,
REDUCTION_FREQUENCY_UNIT TYPE STRING,
REDUCTION_FREQUENCY_PERIOD TYPE STRING,
REDUCTION_AMOUNT TYPE STRING,
REDUCTION_CURRENCY TYPE STRING,
REDUCTION_CURRENCY_ISO TYPE STRING,
REDUCTION_PERCENT TYPE STRING,
ORIGINAL_PROTECTION_VALUE TYPE STRING,
ORIGINAL_PROTECT_CURRENCY TYPE STRING,
ORIGINAL_PROTECT_CURRENCY_ISO TYPE STRING,
TRANSFER_DATA TYPE STRING,
COLLATERAL_AGREEMENT_ID TYPE STRING,
COLLATERAL_AGREEMENT_TYPE TYPE STRING,
IS_PART_OF_LEASING_TRANSACTION TYPE STRING,
LESSOR_LIEN_ON_AGREEMENT TYPE STRING,
ACCESSORIES_LIABILITY TYPE STRING,
AR_FROM_SALE_ASSIGNED TYPE STRING,
LAND_CHARGE_DATA TYPE STRING,
COLLATERAL_AGREEMENT_ID TYPE STRING,
COLLATERAL_AGREEMENT_TYPE TYPE STRING,
LAND_CHARGE_INTEREST_RATE TYPE STRING,
LAND_CHARGE_INCIDENTAL_PAYMENT TYPE STRING,
PAYMENT_FREQUENCY_UNIT TYPE STRING,
PAYMENT_FREQUENCY_PERIOD TYPE STRING,
INTEREST_START_DATE TYPE STRING,
LAND_CHARGE_NO_OF_YRS_INT_CAPT TYPE STRING,
ENFORCEMENT_TYPE TYPE STRING,
ENFORCEMENT_AMOUNT TYPE STRING,
ENFORCEMENT_CURRENCY TYPE STRING,
ENFORCEMENT_CURRENCY_ISO TYPE STRING,
REFERENCE_ENFORCEMENT_AMOUNT TYPE STRING,
ENFORCEMENT_RANK TYPE STRING,
ENFORCEMENT_TITLE TYPE STRING,
INTEREST_FREQUENCY_UNIT TYPE STRING,
HBR_INT_PMT_FREQUENCY_PERIOD TYPE STRING,
INCREASE_HBR_INTEREST TYPE STRING,
INCREASE_HBR_INT_FREQUENC_UNIT TYPE STRING,
INCREASE_HBR_INT_FREQUENCY_PRD TYPE STRING,
INCREASE_HBR_INT_PERCENTAGE TYPE STRING,
INCREASE_HBR_INT_AMOUNT TYPE STRING,
INCREASE_HBR_INT_CURRENCY TYPE STRING,
INCREASE_HBR_INT_CURRENCY_ISO TYPE STRING,
INCREASE_HBR_INT_START_DATE TYPE STRING,
HBR_ENFORCEMENT_WAIVER TYPE STRING,
INCREASE_HBR_INT_LAST_DATE TYPE STRING,
IS_COLLECTIVE_LANDCHARGE TYPE STRING,
CHARGE_CERTIFICATE_EXISTS TYPE STRING,
CHARGE_CERTIFICATE_NUMBER TYPE STRING,
FILE_NUMBER TYPE STRING,
ASSIGMENT_PLEDGE_DATA TYPE STRING,
COLLATERAL_AGREEMENT_ID TYPE STRING,
COLLATERAL_AGREEMENT_TYPE TYPE STRING,
GBC_LIEN_WAIVER_AVAILABLE TYPE STRING,
DISCLOSED TYPE STRING,
IS_DISCLOSED_ON_DATE TYPE STRING,
ASSIGNMENT_REASON TYPE STRING,
AGREEMENT_PORTION_DATA TYPE STRING,
AGREEMENT_RULES_DATA TYPE STRING,
AGREEMENT_RECEIVABLE_LINK TYPE STRING,
CHARGES_DATA TYPE STRING,
AGREEMENT_PARTNER_LINK TYPE STRING,
AGREEMENT_DOCUMENT_LINK TYPE STRING,
PORTION_PARTNER_LINK TYPE STRING,
AGREEMENT_RELATIONS_FROM TYPE STRING,
AGREEMENT_RELATIONS_TO TYPE STRING,
USER_STATUS TYPE STRING,
SYSTEM_STATUS TYPE STRING,
SPECIAL_AGREEMENT_DATA TYPE STRING,
PARTNER_TERMINATION_DATA TYPE STRING,
AGREEMENT_COST_DATA TYPE STRING,
AGREEMENT_NOTES TYPE STRING,
ASSESMENT_VALUE_DATA TYPE STRING,
COLLATERAL_AGREEMENT_ID TYPE STRING,
COLLATERAL_AGREEMENT_TYPE TYPE STRING,
ASSESSMENT_AMOUNT TYPE STRING,
ASSESSMENT_CURRENCY TYPE STRING,
ASSESSMENT_CURRENCY_ISO TYPE STRING,
ASSESSMENT_DATE TYPE STRING,
PRIOR_CHARGE_DATA TYPE STRING,
GUARANTEE_LENDING_VALUE TYPE STRING,
GUARANTEE_LENDING_LIMIT TYPE STRING,
CALCULATION_DATA TYPE STRING,
PRIOR_CHARGE_LOAN_TO_VALUE TYPE STRING,
DISTRIBUTION_COLLATERAL_VALUE TYPE STRING,
RELATION_COLLATERAL_VALUE_FROM TYPE STRING,
RELATION_COLLATERAL_VALUE_TO TYPE STRING,
FREE_COLLATERAL TYPE STRING,
EXTENSIONOUT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CMS_STR_BII_CAG_DETAIL_SNG_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_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_KEY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_ID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-EXTENSIONIN sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_BASIC_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_ID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-CATEGORYID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-CAGMT_TYPE_NAME sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-NOMINAL_VALUE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-NOMINAL_VALUE_CURRENCY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-NOMINAL_VALUE_CURRENCY_ISO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_DATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREMENT_VALID_FROM sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_VALID_TO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COUNTRY_KEY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COUNTRY_KEY_ISO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-IS_GLOBAL_COLLATERAL_AGREEMENT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-PERCENTAGE_ASSET_VALUE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-GUARANTEE_RATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-SPECIAL_MARKDOWN_PERCENT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-SPECIAL_MARKDOWN_AMOUNT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-SPECIAL_MARKDOWN_CURRENCY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-SPECIAL_MARKDOWN_CURRENCY_ISO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGMT_DESCRIPTION sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-RELEASE_FREQUENCY_UNIT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-RELEASE_FREQUENCY_PERIOD sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-OLD_COLLATERAL_AGREEMENT_ID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-MIN_QUALITATIVE_EXCEPTION_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-MIN_QUALITATIVE_REASON sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-MIN_QUALITATIVE_RQMT_FULFILLED sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-MIN_QUALITATIVE_CRITERION sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-TERMINATION_RIGHT_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-TERMINATION_FREQUENCY_UNIT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-NOTICE_PERIOD_UNIT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-REQUIRED_NOTICE_PERIOD sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-TERMINATION_NOTICE_DATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-TERMINATION_REASON sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-GUARANTEED_TERMINATION_AMOUNT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-TERMINATION_AMOUNT_CURRENCY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-TERMINATION_AMOUNT_CURRENCY_IS sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-MINIMUM_STOCK_AMOUNT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-MINIMUM_STOCK_CURRENCY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-MINIMUM_STOCK_CURRENCY_ISO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ADDITIONAL_RECEIVABLE_ALLOWED sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ADDITIONAL_RECEIVABLE_DATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-SCOPE_OF_INSURANCE_COVER sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-POOL_LIQUIDATION_MODE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-RELEASE_THRESHOLD sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-CORRESPONDENCE_ROLE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-BUPR_ID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-BUPR_TYPE_CODE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_ADMIN_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_ID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ADMIN_ORGANIZATIONAL_UNIT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-BANK_AREA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ORGANIZATION_UNIT1 sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ORGANIZATION_UNIT2 sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ORGANIZATION_UNIT3 sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ORGANIZATION_UNIT4 sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ORGANIZATION_UNIT5 sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-GUARANTEE_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_ID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-IS_COUNTER_GUARANTEE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-IS_CO_GUARANTEE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-IS_FIXED_LIABILITY_GUARANTEE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-IS_DEFAULT_LIABILITY_GUARANTEE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-DEFAULT_LIABILITY_PERCENTAGE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INCLUDE_LINKED_AGREEMENTS sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AUTHORITIES_APPROVAL sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-IS_ENFORCEABLE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-LENDING_RATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-REDUCTION_FREQUENCY_UNIT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-REDUCTION_FREQUENCY_PERIOD sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-REDUCTION_AMOUNT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-REDUCTION_CURRENCY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-REDUCTION_CURRENCY_ISO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-REDUCTION_PERCENT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ORIGINAL_PROTECTION_VALUE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ORIGINAL_PROTECT_CURRENCY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ORIGINAL_PROTECT_CURRENCY_ISO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-TRANSFER_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_ID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-IS_PART_OF_LEASING_TRANSACTION sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-LESSOR_LIEN_ON_AGREEMENT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ACCESSORIES_LIABILITY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AR_FROM_SALE_ASSIGNED sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-LAND_CHARGE_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_ID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-LAND_CHARGE_INTEREST_RATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-LAND_CHARGE_INCIDENTAL_PAYMENT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-PAYMENT_FREQUENCY_UNIT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-PAYMENT_FREQUENCY_PERIOD sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INTEREST_START_DATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-LAND_CHARGE_NO_OF_YRS_INT_CAPT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ENFORCEMENT_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ENFORCEMENT_AMOUNT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ENFORCEMENT_CURRENCY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ENFORCEMENT_CURRENCY_ISO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-REFERENCE_ENFORCEMENT_AMOUNT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ENFORCEMENT_RANK sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ENFORCEMENT_TITLE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INTEREST_FREQUENCY_UNIT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-HBR_INT_PMT_FREQUENCY_PERIOD sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INCREASE_HBR_INTEREST sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INCREASE_HBR_INT_FREQUENC_UNIT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INCREASE_HBR_INT_FREQUENCY_PRD sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INCREASE_HBR_INT_PERCENTAGE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INCREASE_HBR_INT_AMOUNT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INCREASE_HBR_INT_CURRENCY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INCREASE_HBR_INT_CURRENCY_ISO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INCREASE_HBR_INT_START_DATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-HBR_ENFORCEMENT_WAIVER sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-INCREASE_HBR_INT_LAST_DATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-IS_COLLECTIVE_LANDCHARGE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-CHARGE_CERTIFICATE_EXISTS sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-CHARGE_CERTIFICATE_NUMBER sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-FILE_NUMBER sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ASSIGMENT_PLEDGE_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_ID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-GBC_LIEN_WAIVER_AVAILABLE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-DISCLOSED sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-IS_DISCLOSED_ON_DATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ASSIGNMENT_REASON sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_PORTION_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_RULES_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_RECEIVABLE_LINK sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-CHARGES_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_PARTNER_LINK sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_DOCUMENT_LINK sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-PORTION_PARTNER_LINK sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_RELATIONS_FROM sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_RELATIONS_TO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-USER_STATUS sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-SYSTEM_STATUS sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-SPECIAL_AGREEMENT_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-PARTNER_TERMINATION_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_COST_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-AGREEMENT_NOTES sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ASSESMENT_VALUE_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_ID sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-COLLATERAL_AGREEMENT_TYPE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ASSESSMENT_AMOUNT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ASSESSMENT_CURRENCY sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ASSESSMENT_CURRENCY_ISO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-ASSESSMENT_DATE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-PRIOR_CHARGE_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-GUARANTEE_LENDING_VALUE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-GUARANTEE_LENDING_LIMIT sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-CALCULATION_DATA sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-PRIOR_CHARGE_LOAN_TO_VALUE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-DISTRIBUTION_COLLATERAL_VALUE sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-RELATION_COLLATERAL_VALUE_FROM sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-RELATION_COLLATERAL_VALUE_TO sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-FREE_COLLATERAL sy-vline 
WA_CMS_STR_BII_CAG_DETAIL_SNG_STR-EXTENSIONOUT sy-vline      INTO ld_text SEPARATED BY SPACE.

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