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

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

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

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


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/PF1/STR_NONFIN_INVEST_REL_PI ASSIGNING </PF1/STR_NONFIN_INVEST_REL_PI>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</PF1/STR_NONFIN_INVEST_REL_PI>-CLIENT = 1.
</PF1/STR_NONFIN_INVEST_REL_PI>-GUID = 1.
</PF1/STR_NONFIN_INVEST_REL_PI>-CLEARING_AREA = 1.
</PF1/STR_NONFIN_INVEST_REL_PI>-PI_DATE = 1.
</PF1/STR_NONFIN_INVEST_REL_PI>-PI_NO = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/PF1/STR_NONFIN_INVEST_REL_PI-SEGMENTATION_KEY, sy-vline,
WA_/PF1/STR_NONFIN_INVEST_REL_PI-TIME_PART, sy-vline,
WA_/PF1/STR_NONFIN_INVEST_REL_PI-PI_STAT, sy-vline,
WA_/PF1/STR_NONFIN_INVEST_REL_PI-TECH_STAT, sy-vline,
WA_/PF1/STR_NONFIN_INVEST_REL_PI-PREV_TECH_STAT, sy-vline,
WA_/PF1/STR_NONFIN_INVEST_REL_PI-PI_KIND, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/PF1/STR_NONFIN_INVEST_REL_PI 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_/PF1/STR_NONFIN_INVEST_REL_PI 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_/PF1/STR_NONFIN_INVEST_REL_PI INTO WA_/PF1/STR_NONFIN_INVEST_REL_PI. *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 ACCOUNT_HOLDER_ID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/PF1/STR_NONFIN_INVEST_REL_PI-ACCOUNT_HOLDER_ID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/PF1/STR_NONFIN_INVEST_REL_PI-ACCOUNT_HOLDER_ID.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit _UNIT, internal->external for field UNIT CALL FUNCTION 'CONVERSION_EXIT__UNIT_OUTPUT' EXPORTING input = WA_/PF1/STR_NONFIN_INVEST_REL_PI-UNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/PF1/STR_NONFIN_INVEST_REL_PI-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_/PF1/STR_NONFIN_INVEST_REL_PI_STR,
CLIENT TYPE STRING,
GUID TYPE STRING,
CLEARING_AREA TYPE STRING,
PI_DATE TYPE STRING,
PI_NO TYPE STRING,
SEGMENTATION_KEY TYPE STRING,
TIME_PART TYPE STRING,
PI_STAT TYPE STRING,
TECH_STAT TYPE STRING,
PREV_TECH_STAT TYPE STRING,
PI_KIND TYPE STRING,
FLG_POSTED TYPE STRING,
FLG_RESERVED TYPE STRING,
FLG_ERROR TYPE STRING,
FLG_FH_ERROR TYPE STRING,
FLG_DISP_SUCCESS TYPE STRING,
FLG_A_RETURNED TYPE STRING,
FLG_EH_ERROR TYPE STRING,
DISP_STAT TYPE STRING,
FLG_LISTENER_REG TYPE STRING,
UPDATE_COUNTER TYPE STRING,
FLG_REMITTANCE TYPE STRING,
FLG_TCHAIN TYPE STRING,
TECH_PRIORITY TYPE STRING,
REF_ROUTE TYPE STRING,
REF_CLEARING TYPE STRING,
REF_AM_AREA TYPE STRING,
PREDETERM_ROUTE TYPE STRING,
RP_TO_DETERMINE TYPE STRING,
REF_ACCT_LOC_SRV TYPE STRING,
REF_ITEM_EXT TYPE STRING,
FLG_ADD_INFO TYPE STRING,
REF_PI_AM_AREA TYPE STRING,
REF_PRED_PI_DATE TYPE STRING,
REF_PRED_PI_NO TYPE STRING,
REF_SUCC_PI_DATE TYPE STRING,
REF_SUCC_PI_NO TYPE STRING,
REF_INP_PO_DATE TYPE STRING,
REF_INP_PO_NO TYPE STRING,
REF_OUTP_PO_DATE TYPE STRING,
REF_OUTP_PO_NO TYPE STRING,
REF_COLL_DATE TYPE STRING,
REF_COLL_NO TYPE STRING,
REF_COLL_SEQ_NO TYPE STRING,
COLL_ENT_DATE TYPE STRING,
COLL_ENT_TIME TYPE STRING,
REF_PRENOTE_ID TYPE STRING,
REF_ITEM_EXT_OUT TYPE STRING,
REF_ITEM_EXT_IN TYPE STRING,
REF_CUST_GRP TYPE STRING,
REF_CUSTOMER TYPE STRING,
REF_CUST_SGM TYPE STRING,
UETR TYPE STRING,
COUNTRY TYPE STRING,
BANKKEY TYPE STRING,
BIC TYPE STRING,
IBAN TYPE STRING,
ACCT_NO TYPE STRING,
ACCT_CUR TYPE STRING,
HOLDER TYPE STRING,
CLRSYSIDCD TYPE STRING,
REF_COUNTRY TYPE STRING,
REF_BANKKEY TYPE STRING,
REF_BIC TYPE STRING,
REF_IBAN TYPE STRING,
REF_ACCT_NO TYPE STRING,
REF_ACCT_CUR TYPE STRING,
REF_HOLDER TYPE STRING,
REF_CLRSYSIDCD TYPE STRING,
ORIG_VAL_DATE TYPE STRING,
ORIG_VAL_TIME TYPE STRING,
VAL_DATE TYPE STRING,
VAL_TIME TYPE STRING,
REF_VALUTA_ID TYPE STRING,
REF_RULESET_ID TYPE STRING,
VALUE_DATE_STAT TYPE STRING,
FLG_HLD_VAL_DATE TYPE STRING,
ACT_VAL_DATE TYPE STRING,
PI_POST_DATE TYPE STRING,
PI_POST_TIME TYPE STRING,
PL_CLR_DATE TYPE STRING,
PL_CLR_TIME TYPE STRING,
PI_PROCESS_DATE TYPE STRING,
PI_PROCESS_TIME TYPE STRING,
ACT_POST_DATE TYPE STRING,
TR_CURR TYPE STRING,
TR_AMOUNT TYPE STRING,
TR_DEBCREDIND TYPE STRING,
TR_FEE TYPE STRING,
FEE_DEBCRED TYPE STRING,
FEE_INFO TYPE STRING,
ORIGINAL_CURR TYPE STRING,
ORIGINAL_AMOUNT TYPE STRING,
NOM_AMOUNT_CHNG TYPE STRING,
A_AMOUNT TYPE STRING,
A_AMOUNT_FEE TYPE STRING,
A_AMOUNT_CURR TYPE STRING,
EXCHNGRATE TYPE STRING,
TRANS_TYPE TYPE STRING,
PROCESS TYPE STRING,
PRIORITY TYPE STRING,
FLG_ENFORCE_POST TYPE STRING,
CHEQUE_NO TYPE STRING,
RETURN_CODE TYPE STRING,
RELEASE_ACTIVITY TYPE STRING,
RELEASE_STATUS TYPE STRING,
FLG_EV_STATUS TYPE STRING,
EV_ID TYPE STRING,
FLG_INTERNAL TYPE STRING,
SPLIT_INDI TYPE STRING,
ITEM_GROUP TYPE STRING,
FLG_ITEM_AUTH TYPE STRING,
FLG_EV_STATUS_OPO TYPE STRING,
EV_ID_OPO TYPE STRING,
CONTINUE_EV_OPO TYPE STRING,
ACCOUNT_HOLDER_ID TYPE STRING,
RISK_SCORE TYPE STRING,
BAM_ID TYPE STRING,
REF_RECALL_DATE TYPE STRING,
REF_RECALL_NO TYPE STRING,
PI_RANGE TYPE STRING,
PI_KIND_003 TYPE STRING,
PI_RANGE_003 TYPE STRING,
PI_KIND_004 TYPE STRING,
PI_RANGE_004 TYPE STRING,
PI_KIND_ACQ TYPE STRING,
PI_RANGE_ACQ TYPE STRING,
DUE_DATE TYPE STRING,
MANDATE_ID TYPE STRING,
UCI TYPE STRING,
END_TO_END_ID TYPE STRING,
DIRECT_DEB_TYPE TYPE STRING,
LCL_INSTRUMENT TYPE STRING,
CATEGORY_PURPOSE_CODE TYPE STRING,
SERVICE_LEVEL TYPE STRING,
FLG_INP_PO_ARC TYPE STRING,
FLG_OUTP_PO_ARC TYPE STRING,
FLG_OUT_INF_ARC TYPE STRING,
FLG_RECALL_ARC TYPE STRING,
COSTCENTER TYPE STRING,
BUS_AREA TYPE STRING,
UNIT TYPE STRING,
PN_NUMBER TYPE STRING,
PN_YEAR TYPE STRING,
PAYMENT_METHOD TYPE STRING,
PAYMENT_METHOD_SUPPLEMENT TYPE STRING,
CRUSR TYPE STRING,
CRDAT TYPE STRING,
CRTIM TYPE STRING,
CHUSR TYPE STRING,
CHDAT TYPE STRING,
CHTIM TYPE STRING,
RLUSR TYPE STRING,
RLDAT TYPE STRING,
RLTIM TYPE STRING,
RETURNED_PI_DATE TYPE STRING,
RETURNED_PI_NO TYPE STRING,
RETURNING_PIDATE TYPE STRING,
RETURNING_PI_NO TYPE STRING,
TEXT_TRANSTYPE TYPE STRING,
TEXT_ROUTE TYPE STRING,
TEXT_CA TYPE STRING,
TEXT_VA TYPE STRING,
TEXT_VA_RULESET TYPE STRING,
TEXT_AM_AREA TYPE STRING,
TEXT_BANK TYPE STRING,
TEXT_BANK_ORIG TYPE STRING,
TEXT_BANK_REF TYPE STRING,
STRUCTURE TYPE STRING,
CURRENCY_FEE TYPE STRING,
FEE_DEBCRED_ACC TYPE STRING,
ACCT_CURRENCY_FEE TYPE STRING,
TR_DEBCREDIND_ACC TYPE STRING,
TEXT_ORIG_TRANSTYPE TYPE STRING,
TEXT_ERROR TYPE STRING,
CUST_SLA_ID TYPE STRING,
CUST_SLA_DATE TYPE STRING,
SEG_SLA_ID TYPE STRING,
SEG_SLA_DATE TYPE STRING,
CA_SLA_ID TYPE STRING,
CA_SLA_DATE TYPE STRING,
GRP_SLA_ID TYPE STRING,
GRP_SLA_DATE TYPE STRING,
EXCHNGRATE_NW TYPE STRING,
EXCHNGRATE_NWN TYPE STRING,
EXCHNGRATE_CUST TYPE STRING,
TXT_LCL_INSTR TYPE STRING,
TXT_SERVICE_LEVEL TYPE STRING,
TXT_PURPOSE_CODE TYPE STRING,
REF_CMMR_IDENR TYPE STRING,
REF_CMMR_BUKRS TYPE STRING,
OPERATION TYPE STRING,END OF T_EKKO_STR. DATA: WA_/PF1/STR_NONFIN_INVEST_REL_PI_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_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CLIENT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-GUID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CLEARING_AREA sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-SEGMENTATION_KEY sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TIME_PART sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_STAT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TECH_STAT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PREV_TECH_STAT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_KIND sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_POSTED sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_RESERVED sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_ERROR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_FH_ERROR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_DISP_SUCCESS sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_A_RETURNED sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_EH_ERROR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-DISP_STAT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_LISTENER_REG sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-UPDATE_COUNTER sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_REMITTANCE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_TCHAIN sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TECH_PRIORITY sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_ROUTE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_CLEARING sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_AM_AREA sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PREDETERM_ROUTE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RP_TO_DETERMINE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_ACCT_LOC_SRV sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_ITEM_EXT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_ADD_INFO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_PI_AM_AREA sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_PRED_PI_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_PRED_PI_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_SUCC_PI_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_SUCC_PI_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_INP_PO_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_INP_PO_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_OUTP_PO_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_OUTP_PO_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_COLL_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_COLL_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_COLL_SEQ_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-COLL_ENT_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-COLL_ENT_TIME sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_PRENOTE_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_ITEM_EXT_OUT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_ITEM_EXT_IN sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_CUST_GRP sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_CUSTOMER sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_CUST_SGM sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-UETR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-COUNTRY sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-BANKKEY sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-BIC sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-IBAN sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ACCT_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ACCT_CUR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-HOLDER sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CLRSYSIDCD sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_COUNTRY sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_BANKKEY sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_BIC sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_IBAN sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_ACCT_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_ACCT_CUR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_HOLDER sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_CLRSYSIDCD sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ORIG_VAL_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ORIG_VAL_TIME sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-VAL_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-VAL_TIME sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_VALUTA_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_RULESET_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-VALUE_DATE_STAT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_HLD_VAL_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ACT_VAL_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_POST_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_POST_TIME sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PL_CLR_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PL_CLR_TIME sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_PROCESS_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_PROCESS_TIME sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ACT_POST_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TR_CURR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TR_AMOUNT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TR_DEBCREDIND sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TR_FEE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FEE_DEBCRED sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FEE_INFO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ORIGINAL_CURR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ORIGINAL_AMOUNT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-NOM_AMOUNT_CHNG sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-A_AMOUNT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-A_AMOUNT_FEE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-A_AMOUNT_CURR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-EXCHNGRATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TRANS_TYPE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PROCESS sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PRIORITY sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_ENFORCE_POST sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CHEQUE_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RETURN_CODE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RELEASE_ACTIVITY sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RELEASE_STATUS sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_EV_STATUS sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-EV_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_INTERNAL sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-SPLIT_INDI sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ITEM_GROUP sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_ITEM_AUTH sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_EV_STATUS_OPO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-EV_ID_OPO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CONTINUE_EV_OPO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ACCOUNT_HOLDER_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RISK_SCORE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-BAM_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_RECALL_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_RECALL_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_RANGE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_KIND_003 sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_RANGE_003 sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_KIND_004 sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_RANGE_004 sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_KIND_ACQ sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PI_RANGE_ACQ sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-DUE_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-MANDATE_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-UCI sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-END_TO_END_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-DIRECT_DEB_TYPE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-LCL_INSTRUMENT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CATEGORY_PURPOSE_CODE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-SERVICE_LEVEL sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_INP_PO_ARC sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_OUTP_PO_ARC sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_OUT_INF_ARC sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FLG_RECALL_ARC sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-COSTCENTER sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-BUS_AREA sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-UNIT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PN_NUMBER sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PN_YEAR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PAYMENT_METHOD sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-PAYMENT_METHOD_SUPPLEMENT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CRUSR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CRDAT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CRTIM sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CHUSR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CHDAT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CHTIM sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RLUSR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RLDAT sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RLTIM sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RETURNED_PI_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RETURNED_PI_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RETURNING_PIDATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-RETURNING_PI_NO sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_TRANSTYPE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_ROUTE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_CA sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_VA sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_VA_RULESET sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_AM_AREA sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_BANK sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_BANK_ORIG sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_BANK_REF sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-STRUCTURE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CURRENCY_FEE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-FEE_DEBCRED_ACC sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-ACCT_CURRENCY_FEE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TR_DEBCREDIND_ACC sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_ORIG_TRANSTYPE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TEXT_ERROR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CUST_SLA_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CUST_SLA_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-SEG_SLA_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-SEG_SLA_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CA_SLA_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-CA_SLA_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-GRP_SLA_ID sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-GRP_SLA_DATE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-EXCHNGRATE_NW sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-EXCHNGRATE_NWN sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-EXCHNGRATE_CUST sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TXT_LCL_INSTR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TXT_SERVICE_LEVEL sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-TXT_PURPOSE_CODE sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_CMMR_IDENR sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-REF_CMMR_BUKRS sy-vline
WA_/PF1/STR_NONFIN_INVEST_REL_PI_STR-OPERATION sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.