ABAP Select data from SAP table FTI_BIW_ODS_0CFM_O01_ATTR 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 FTI_BIW_ODS_0CFM_O01_ATTR 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 FTI_BIW_ODS_0CFM_O01_ATTR. 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 FTI_BIW_ODS_0CFM_O01_ATTR 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_FTI_BIW_ODS_0CFM_O01_ATTR TYPE STANDARD TABLE OF FTI_BIW_ODS_0CFM_O01_ATTR,
      WA_FTI_BIW_ODS_0CFM_O01_ATTR TYPE FTI_BIW_ODS_0CFM_O01_ATTR,
      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: <FTI_BIW_ODS_0CFM_O01_ATTR> TYPE FTI_BIW_ODS_0CFM_O01_ATTR.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FTI_BIW_ODS_0CFM_O01_ATTR
*  INTO TABLE @DATA(IT_FTI_BIW_ODS_0CFM_O01_ATTR2).
*--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_FTI_BIW_ODS_0CFM_O01_ATTR INDEX 1 INTO DATA(WA_FTI_BIW_ODS_0CFM_O01_ATTR2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FTI_BIW_ODS_0CFM_O01_ATTR ASSIGNING <FTI_BIW_ODS_0CFM_O01_ATTR>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<FTI_BIW_ODS_0CFM_O01_ATTR>-OS_GUID = 1.
<FTI_BIW_ODS_0CFM_O01_ATTR>-POSITION_OID = 1.
<FTI_BIW_ODS_0CFM_O01_ATTR>-SUBPOSITION_OID = 1.
<FTI_BIW_ODS_0CFM_O01_ATTR>-BUKRS = 1.
<FTI_BIW_ODS_0CFM_O01_ATTR>-TR_ACC_CODE = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FTI_BIW_ODS_0CFM_O01_ATTR-VALUATION_CLASS, sy-vline,
WA_FTI_BIW_ODS_0CFM_O01_ATTR-GSART, sy-vline,
WA_FTI_BIW_ODS_0CFM_O01_ATTR-PORTFOLIO, sy-vline,
WA_FTI_BIW_ODS_0CFM_O01_ATTR-SECURITY_ID, sy-vline,
WA_FTI_BIW_ODS_0CFM_O01_ATTR-LOANS_CONTRACT, sy-vline,
WA_FTI_BIW_ODS_0CFM_O01_ATTR-DEAL_NUMBER, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FTI_BIW_ODS_0CFM_O01_ATTR 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_FTI_BIW_ODS_0CFM_O01_ATTR 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_FTI_BIW_ODS_0CFM_O01_ATTR INTO WA_FTI_BIW_ODS_0CFM_O01_ATTR. *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 SECURITY_ID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FTI_BIW_ODS_0CFM_O01_ATTR-SECURITY_ID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FTI_BIW_ODS_0CFM_O01_ATTR-SECURITY_ID.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit GJAHR, internal->external for field FISCAL_YEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_FTI_BIW_ODS_0CFM_O01_ATTR-FISCAL_YEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FTI_BIW_ODS_0CFM_O01_ATTR-FISCAL_YEAR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit TRLBS, internal->external for field TRL_BOOKINGSTATE CALL FUNCTION 'CONVERSION_EXIT_TRLBS_OUTPUT' EXPORTING input = WA_FTI_BIW_ODS_0CFM_O01_ATTR-TRL_BOOKINGSTATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FTI_BIW_ODS_0CFM_O01_ATTR-TRL_BOOKINGSTATE.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit GJAHR, internal->external for field DGJAHR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_FTI_BIW_ODS_0CFM_O01_ATTR-DGJAHR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FTI_BIW_ODS_0CFM_O01_ATTR-DGJAHR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PERI7, internal->external for field PERIO CALL FUNCTION 'CONVERSION_EXIT_PERI7_OUTPUT' EXPORTING input = WA_FTI_BIW_ODS_0CFM_O01_ATTR-PERIO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FTI_BIW_ODS_0CFM_O01_ATTR-PERIO.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ALPHA, internal->external for field RPZAHL CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_FTI_BIW_ODS_0CFM_O01_ATTR-RPZAHL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FTI_BIW_ODS_0CFM_O01_ATTR-RPZAHL.
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_FTI_BIW_ODS_0CFM_O01_ATTR_STR,
OS_GUID TYPE STRING,
POSITION_OID TYPE STRING,
SUBPOSITION_OID TYPE STRING,
BUKRS TYPE STRING,
TR_ACC_CODE TYPE STRING,
VALUATION_CLASS TYPE STRING,
GSART TYPE STRING,
PORTFOLIO TYPE STRING,
SECURITY_ID TYPE STRING,
LOANS_CONTRACT TYPE STRING,
DEAL_NUMBER TYPE STRING,
HEDGE_ID TYPE STRING,
ACCOUNT_GROUP TYPE STRING,
SECURITY_ACCOUNT TYPE STRING,
POSITION_ACCOUNT TYPE STRING,
EXTERNAL_ACCOUNT TYPE STRING,
DIFF_CURRENCY TYPE STRING,
FLAG_LONG_SHORT TYPE STRING,
LOT_ID TYPE STRING,
DLOTGENERATION TYPE STRING,
TLOTGENERATION TYPE STRING,
LOTGENERATION_US TYPE STRING,
LOTGENERATION_CT TYPE STRING,
LOTPOS_INIT_DATE TYPE STRING,
LOTPOS_ORG_DATE TYPE STRING,
LOTGEN_DEALNR TYPE STRING,
HREL_NUMBER TYPE STRING,
FISCAL_YEAR TYPE STRING,
HITEM_NUMBER TYPE STRING,
HINST_NUMBER TYPE STRING,
FIKRS TYPE STRING,
FUND TYPE STRING,
GRANT_NBR TYPE STRING,
ACC_ASS_REF TYPE STRING,
HKONT TYPE STRING,
DBESTAND TYPE STRING,
SE_DEAL_NUMBER TYPE STRING,
RKONTRA TYPE STRING,
FLOW_TYPE TYPE STRING,
BUSTRANSCAT TYPE STRING,
GEN_BUSTRANSCAT TYPE STRING,
SOURCETARGET_FLG TYPE STRING,
QUANT_CAT TYPE STRING,
AMOUNT_CAT TYPE STRING,
TRL_BOOKINGSTATE TYPE STRING,
PL_CATEGORY TYPE STRING,
LEDGER_POST_STAT TYPE STRING,
BELNR TYPE STRING,
AWKEY TYPE STRING,
GL_ACCOUNT_D TYPE STRING,
GL_ACCOUNT_C TYPE STRING,
DBUDAT TYPE STRING,
DGJAHR TYPE STRING,
DMONAT TYPE STRING,
PERIO TYPE STRING,
SZBMETH TYPE STRING,
DBERVON TYPE STRING,
DBERBIS TYPE STRING,
SINCLVON TYPE STRING,
SINCLBIS TYPE STRING,
SSOLHAB TYPE STRING,
IGT_STATUS TYPE STRING,
PARTNER_COMP_ID TYPE STRING,
ORIGIN_DATE TYPE STRING,
KUNNR_D TYPE STRING,
KUNNR_C TYPE STRING,
RPZAHL TYPE STRING,
RPBANK TYPE STRING,
PAYMENT_DATE TYPE STRING,
SBILK TYPE STRING,END OF T_EKKO_STR. DATA: WA_FTI_BIW_ODS_0CFM_O01_ATTR_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_FTI_BIW_ODS_0CFM_O01_ATTR_STR-OS_GUID sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-POSITION_OID sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-SUBPOSITION_OID sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-BUKRS sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-TR_ACC_CODE sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-VALUATION_CLASS sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-GSART sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-PORTFOLIO sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-SECURITY_ID sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-LOANS_CONTRACT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-DEAL_NUMBER sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-HEDGE_ID sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-ACCOUNT_GROUP sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-SECURITY_ACCOUNT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-POSITION_ACCOUNT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-EXTERNAL_ACCOUNT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-DIFF_CURRENCY sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-FLAG_LONG_SHORT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-LOT_ID sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-DLOTGENERATION sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-TLOTGENERATION sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-LOTGENERATION_US sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-LOTGENERATION_CT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-LOTPOS_INIT_DATE sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-LOTPOS_ORG_DATE sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-LOTGEN_DEALNR sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-HREL_NUMBER sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-FISCAL_YEAR sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-HITEM_NUMBER sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-HINST_NUMBER sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-FIKRS sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-FUND sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-GRANT_NBR sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-ACC_ASS_REF sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-HKONT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-DBESTAND sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-SE_DEAL_NUMBER sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-RKONTRA sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-FLOW_TYPE sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-BUSTRANSCAT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-GEN_BUSTRANSCAT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-SOURCETARGET_FLG sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-QUANT_CAT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-AMOUNT_CAT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-TRL_BOOKINGSTATE sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-PL_CATEGORY sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-LEDGER_POST_STAT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-BELNR sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-AWKEY sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-GL_ACCOUNT_D sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-GL_ACCOUNT_C sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-DBUDAT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-DGJAHR sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-DMONAT sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-PERIO sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-SZBMETH sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-DBERVON sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-DBERBIS sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-SINCLVON sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-SINCLBIS sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-SSOLHAB sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-IGT_STATUS sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-PARTNER_COMP_ID sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-ORIGIN_DATE sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-KUNNR_D sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-KUNNR_C sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-RPZAHL sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-RPBANK sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-PAYMENT_DATE sy-vline
WA_FTI_BIW_ODS_0CFM_O01_ATTR_STR-SBILK sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.