ABAP Select data from SAP table P_SIFEE 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 P_SIFEE 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 P_SIFEE. 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 P_SIFEE 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_P_SIFEE TYPE STANDARD TABLE OF P_SIFEE,
      WA_P_SIFEE TYPE P_SIFEE,
      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: <P_SIFEE> TYPE P_SIFEE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM P_SIFEE
*  INTO TABLE @DATA(IT_P_SIFEE2).
*--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_P_SIFEE INDEX 1 INTO DATA(WA_P_SIFEE2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<P_SIFEE>-MANDT = 1.
<P_SIFEE>-DOCTYPE = 1.
<P_SIFEE>-DOCID = 1.
<P_SIFEE>-DOCITEM = 1.
<P_SIFEE>-DOCSUBITEM = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_P_SIFEE-DOCYEAR, sy-vline,
  WA_P_SIFEE-SEQUENCE_NO, sy-vline,
  WA_P_SIFEE-FEE_ID, sy-vline,
  WA_P_SIFEE-VERSION, sy-vline,
  WA_P_SIFEE-FEE_OBSOLETE, sy-vline,
  WA_P_SIFEE-FEE_MANUAL_CHG, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_P_SIFEE 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_P_SIFEE 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_P_SIFEE INTO WA_P_SIFEE.


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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field FEE_RATE_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-FEE_RATE_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-FEE_RATE_UOM.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field IN_CHARGE_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-IN_CHARGE_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-IN_CHARGE_UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field REC_CHARGE_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-REC_CHARGE_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-REC_CHARGE_UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field MAX_CHARGE_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-MAX_CHARGE_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-MAX_CHARGE_UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field PREMIUM_CREDIT_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-PREMIUM_CREDIT_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-PREMIUM_CREDIT_UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field PREPAYMENTDISTRUOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-PREPAYMENTDISTRUOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-PREPAYMENTDISTRUOM.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit CUNIT, internal->external for field GROSS_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-GROSS_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-GROSS_UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field LAQ_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-LAQ_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-LAQ_UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field MATERIAL
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-MATERIAL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-MATERIAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field CREATED_ON
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-CREATED_ON
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-CREATED_ON.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field CHANGED_ON
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-CHANGED_ON
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-CHANGED_ON.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit CUNIT, internal->external for field PRXFX_ASG_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-PRXFX_ASG_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-PRXFX_ASG_UOM.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit CUNIT, internal->external for field ADJ_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-ADJ_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-ADJ_UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field UNIT_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-UNIT_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-UNIT_UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field CONTRACT_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-CONTRACT_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-CONTRACT_UOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field DOCUMENT_UOM
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_P_SIFEE-DOCUMENT_UOM
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P_SIFEE-DOCUMENT_UOM.
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_P_SIFEE_STR, 
MANDT TYPE STRING,
DOCTYPE TYPE STRING,
DOCID TYPE STRING,
DOCITEM TYPE STRING,
DOCSUBITEM TYPE STRING,
DOCYEAR TYPE STRING,
SEQUENCE_NO TYPE STRING,
FEE_ID TYPE STRING,
VERSION TYPE STRING,
FEE_OBSOLETE TYPE STRING,
FEE_MANUAL_CHG TYPE STRING,
ALLOC_MODE TYPE STRING,
VALID_STATUS TYPE STRING,
CALONGQ TYPE STRING,
DUPLMSG TYPE STRING,
NOT_RELEVANT TYPE STRING,
ADD_GROSS TYPE STRING,
INCLD_NS TYPE STRING,
REL_ACCRUAL TYPE STRING,
RATE_ASSIGN TYPE STRING,
NON_MODIFIABLE TYPE STRING,
ACCRUAL_PURCHASE TYPE STRING,
ACCRUAL_TIME_SALES TYPE STRING,
RATE TYPE STRING,
CURRENCY_EXT TYPE STRING,
CURRENCY TYPE STRING,
QUANTITY TYPE STRING,
FEE_RATE_UOM TYPE STRING,
DECIMAL_PLACE TYPE STRING,
RATE_TYPE TYPE STRING,
DOCTYPEREF TYPE STRING,
DOCIDREF TYPE STRING,
DOCITEMREF TYPE STRING,
DOCSUBITEMREF TYPE STRING,
DOCYEARREF TYPE STRING,
SEQUENCE_NOREF TYPE STRING,
FEE_CALC_AMT TYPE STRING,
FEE_AMT_CURR TYPE STRING,
FX_RATE TYPE STRING,
AMT_TYPE_GUID TYPE STRING,
MANUAL_OVR_IND TYPE STRING,
APP_FIRST_UNIT TYPE STRING,
IN_CHARGE_RATE TYPE STRING,
IN_CHARGE_CURR TYPE STRING,
IN_CHARGE_QTY TYPE STRING,
IN_CHARGE_UOM TYPE STRING,
IN_CHARGE_GRACE_PERIOD TYPE STRING,
IN_CHARGE_DURATION TYPE STRING,
IN_CHARGE_BEGIN_DATE TYPE STRING,
IN_CHARGE_END_DATE TYPE STRING,
REC_CHARG_BEGDATE_EVENT TYPE STRING,
REC_CHARGE_BEGIN_DATE TYPE STRING,
REC_CHARG_ENDDATE_EVENT TYPE STRING,
REC_CHARGE_RATE TYPE STRING,
REC_CHARGE_CURR TYPE STRING,
REC_CHARGE_QTY TYPE STRING,
REC_CHARGE_UOM TYPE STRING,
REC_CHARGE_RATE_DUR TYPE STRING,
REC_CHARGE_GRACE_PERIOD TYPE STRING,
REC_CHARGE_DURATION TYPE STRING,
PRORATE_TO_DAILY TYPE STRING,
MAX_CHARGE_RATE TYPE STRING,
MAX_CHARGE_CURR TYPE STRING,
MAX_CHARGE_QTY TYPE STRING,
MAX_CHARGE_UOM TYPE STRING,
PRICE_BY_DATE TYPE STRING,
GOV_DATE_EVENT TYPE STRING,
GOV_ENDDATE_EVENT TYPE STRING,
REL_SEP_TIME TYPE STRING,
PREMIUM_CREDIT_GOV_EVNT TYPE STRING,
PRE_CREDIT_ENDDATE_EVNT TYPE STRING,
PREMIUM_CREDIT_RATE TYPE STRING,
PREMIUM_CREDIT_CURR TYPE STRING,
PREMIUM_CREDIT_QTY TYPE STRING,
PREMIUM_CREDIT_UOM TYPE STRING,
PRE_CREDIT_GRACE_PERIOD TYPE STRING,
PREMIUM_CREDIT_DURATION TYPE STRING,
CHARACTERISTIC TYPE STRING,
FEE_NAME TYPE STRING,
FEE_NAME_EXT TYPE STRING,
FEE_TYPE TYPE STRING,
INT_DESC TYPE STRING,
EXT_DESC TYPE STRING,
STATUS TYPE STRING,
VALID_FROM TYPE STRING,
VALID_TO TYPE STRING,
GL_SOURCE TYPE STRING,
PCF_FLAT_FEE TYPE STRING,
PCF_FLAT_FEE_CURR TYPE STRING,
PCF_PERCENT_FEE TYPE STRING,
PCF_STAGGERED TYPE STRING,
PCF_NON_STAGGERED TYPE STRING,
PCF_CALC_REF TYPE STRING,
REL_PP_STL TYPE STRING,
PREPAYMENT_AMT TYPE STRING,
PREPAYMENT_CURR TYPE STRING,
PREPAYMENTDISTRQUANTITY TYPE STRING,
PREPAYMENTDISTRUOM TYPE STRING,
PREPAYMENTDISTRAMOUNT TYPE STRING,
PREPAYMENTDISTRCURRENCY TYPE STRING,
SIDE TYPE STRING,
APPLDOC TYPE STRING,
ITEM TYPE STRING,
SUB_ITEM TYPE STRING,
APPLDOC_TYPE TYPE STRING,
REF_APP_DOC TYPE STRING,
REF_APP_DOC_TYP TYPE STRING,
CONTRACT TYPE STRING,
CONTRACT_ITM TYPE STRING,
CONTRACT_SUBITEM TYPE STRING,
CONTRACT_CURR TYPE STRING,
CONTRACT_DOC_TYPE TYPE STRING,
APPL_STATUS_OBJNR TYPE STRING,
STL_STATUS_OBJNR TYPE STRING,
UIS_EVNT_ID TYPE STRING,
UIS_EVNT_GUID TYPE STRING,
DELIVERY_TYPE TYPE STRING,
OB_DELIVERY TYPE STRING,
DELIVERY_ITEM TYPE STRING,
DELIVERY_SIDE TYPE STRING,
ORDER_TYPE TYPE STRING,
ORDER_NO TYPE STRING,
ORDER_ITM TYPE STRING,
ORDER_SIDE TYPE STRING,
GROSS_QTY TYPE STRING,
GROSS_UOM TYPE STRING,
LAQ_QTY TYPE STRING,
LAQ_UOM TYPE STRING,
MATERIAL TYPE STRING,
CREATED_BY TYPE STRING,
CREATED_ON TYPE STRING,
CHANGED_BY TYPE STRING,
CHANGED_ON TYPE STRING,
PLANT TYPE STRING,
COMPANY_CODE TYPE STRING,
SALES_ORG TYPE STRING,
PURCH_ORG TYPE STRING,
DIST_CHNL TYPE STRING,
DIVISION TYPE STRING,
PURCH_GRP TYPE STRING,
CONTRACT_TYPE TYPE STRING,
PROFIT_CENTER TYPE STRING,
SUPPLIER TYPE STRING,
SOLD_TO_PARTY TYPE STRING,
NOMTK TYPE STRING,
NOMNR TYPE STRING,
NOMIT TYPE STRING,
PRCFX_ASG_QTY TYPE STRING,
ASSGD_QUAN_ORIG TYPE STRING,
PRXFX_ASG_UOM TYPE STRING,
ASSGMT_GUID TYPE STRING,
PRICING_ASPECT_ID TYPE STRING,
PRICING_ASPECT_COUNTER TYPE STRING,
PRICE_FIXATION_NUMBER TYPE STRING,
SETTL_DOC TYPE STRING,
SETTL_YR TYPE STRING,
SETTL_CAT TYPE STRING,
SETTL_TYPE TYPE STRING,
SETTL_SIDE TYPE STRING,
DOC_TYP TYPE STRING,
SETTL_SCENARIO TYPE STRING,
SETTL_ITEM TYPE STRING,
FULL_SHIP_QTY TYPE STRING,
TOT_QUANTITY_ADJ TYPE STRING,
ADJ_UOM TYPE STRING,
DOC_CURR TYPE STRING,
UNIT_QUANTITY TYPE STRING,
UNIT_UOM TYPE STRING,
CONTRACT_QTY TYPE STRING,
CONTRACT_UOM TYPE STRING,
DOCUMENT_QTY TYPE STRING,
DOCUMENT_UOM TYPE STRING,
QREP_GUID TYPE STRING,
QREP_VERSION TYPE STRING,
CONTRACT_STATUS TYPE STRING,
PREPAYMENTAGRMTREFDOCUMENT TYPE STRING,
PREPAYMENTAGRMTREFDOCITEM TYPE STRING,
PREPAYMENTAGREEMENT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_P_SIFEE_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_P_SIFEE_STR-MANDT sy-vline 
WA_P_SIFEE_STR-DOCTYPE sy-vline 
WA_P_SIFEE_STR-DOCID sy-vline 
WA_P_SIFEE_STR-DOCITEM sy-vline 
WA_P_SIFEE_STR-DOCSUBITEM sy-vline 
WA_P_SIFEE_STR-DOCYEAR sy-vline 
WA_P_SIFEE_STR-SEQUENCE_NO sy-vline 
WA_P_SIFEE_STR-FEE_ID sy-vline 
WA_P_SIFEE_STR-VERSION sy-vline 
WA_P_SIFEE_STR-FEE_OBSOLETE sy-vline 
WA_P_SIFEE_STR-FEE_MANUAL_CHG sy-vline 
WA_P_SIFEE_STR-ALLOC_MODE sy-vline 
WA_P_SIFEE_STR-VALID_STATUS sy-vline 
WA_P_SIFEE_STR-CALONGQ sy-vline 
WA_P_SIFEE_STR-DUPLMSG sy-vline 
WA_P_SIFEE_STR-NOT_RELEVANT sy-vline 
WA_P_SIFEE_STR-ADD_GROSS sy-vline 
WA_P_SIFEE_STR-INCLD_NS sy-vline 
WA_P_SIFEE_STR-REL_ACCRUAL sy-vline 
WA_P_SIFEE_STR-RATE_ASSIGN sy-vline 
WA_P_SIFEE_STR-NON_MODIFIABLE sy-vline 
WA_P_SIFEE_STR-ACCRUAL_PURCHASE sy-vline 
WA_P_SIFEE_STR-ACCRUAL_TIME_SALES sy-vline 
WA_P_SIFEE_STR-RATE sy-vline 
WA_P_SIFEE_STR-CURRENCY_EXT sy-vline 
WA_P_SIFEE_STR-CURRENCY sy-vline 
WA_P_SIFEE_STR-QUANTITY sy-vline 
WA_P_SIFEE_STR-FEE_RATE_UOM sy-vline 
WA_P_SIFEE_STR-DECIMAL_PLACE sy-vline 
WA_P_SIFEE_STR-RATE_TYPE sy-vline 
WA_P_SIFEE_STR-DOCTYPEREF sy-vline 
WA_P_SIFEE_STR-DOCIDREF sy-vline 
WA_P_SIFEE_STR-DOCITEMREF sy-vline 
WA_P_SIFEE_STR-DOCSUBITEMREF sy-vline 
WA_P_SIFEE_STR-DOCYEARREF sy-vline 
WA_P_SIFEE_STR-SEQUENCE_NOREF sy-vline 
WA_P_SIFEE_STR-FEE_CALC_AMT sy-vline 
WA_P_SIFEE_STR-FEE_AMT_CURR sy-vline 
WA_P_SIFEE_STR-FX_RATE sy-vline 
WA_P_SIFEE_STR-AMT_TYPE_GUID sy-vline 
WA_P_SIFEE_STR-MANUAL_OVR_IND sy-vline 
WA_P_SIFEE_STR-APP_FIRST_UNIT sy-vline 
WA_P_SIFEE_STR-IN_CHARGE_RATE sy-vline 
WA_P_SIFEE_STR-IN_CHARGE_CURR sy-vline 
WA_P_SIFEE_STR-IN_CHARGE_QTY sy-vline 
WA_P_SIFEE_STR-IN_CHARGE_UOM sy-vline 
WA_P_SIFEE_STR-IN_CHARGE_GRACE_PERIOD sy-vline 
WA_P_SIFEE_STR-IN_CHARGE_DURATION sy-vline 
WA_P_SIFEE_STR-IN_CHARGE_BEGIN_DATE sy-vline 
WA_P_SIFEE_STR-IN_CHARGE_END_DATE sy-vline 
WA_P_SIFEE_STR-REC_CHARG_BEGDATE_EVENT sy-vline 
WA_P_SIFEE_STR-REC_CHARGE_BEGIN_DATE sy-vline 
WA_P_SIFEE_STR-REC_CHARG_ENDDATE_EVENT sy-vline 
WA_P_SIFEE_STR-REC_CHARGE_RATE sy-vline 
WA_P_SIFEE_STR-REC_CHARGE_CURR sy-vline 
WA_P_SIFEE_STR-REC_CHARGE_QTY sy-vline 
WA_P_SIFEE_STR-REC_CHARGE_UOM sy-vline 
WA_P_SIFEE_STR-REC_CHARGE_RATE_DUR sy-vline 
WA_P_SIFEE_STR-REC_CHARGE_GRACE_PERIOD sy-vline 
WA_P_SIFEE_STR-REC_CHARGE_DURATION sy-vline 
WA_P_SIFEE_STR-PRORATE_TO_DAILY sy-vline 
WA_P_SIFEE_STR-MAX_CHARGE_RATE sy-vline 
WA_P_SIFEE_STR-MAX_CHARGE_CURR sy-vline 
WA_P_SIFEE_STR-MAX_CHARGE_QTY sy-vline 
WA_P_SIFEE_STR-MAX_CHARGE_UOM sy-vline 
WA_P_SIFEE_STR-PRICE_BY_DATE sy-vline 
WA_P_SIFEE_STR-GOV_DATE_EVENT sy-vline 
WA_P_SIFEE_STR-GOV_ENDDATE_EVENT sy-vline 
WA_P_SIFEE_STR-REL_SEP_TIME sy-vline 
WA_P_SIFEE_STR-PREMIUM_CREDIT_GOV_EVNT sy-vline 
WA_P_SIFEE_STR-PRE_CREDIT_ENDDATE_EVNT sy-vline 
WA_P_SIFEE_STR-PREMIUM_CREDIT_RATE sy-vline 
WA_P_SIFEE_STR-PREMIUM_CREDIT_CURR sy-vline 
WA_P_SIFEE_STR-PREMIUM_CREDIT_QTY sy-vline 
WA_P_SIFEE_STR-PREMIUM_CREDIT_UOM sy-vline 
WA_P_SIFEE_STR-PRE_CREDIT_GRACE_PERIOD sy-vline 
WA_P_SIFEE_STR-PREMIUM_CREDIT_DURATION sy-vline 
WA_P_SIFEE_STR-CHARACTERISTIC sy-vline 
WA_P_SIFEE_STR-FEE_NAME sy-vline 
WA_P_SIFEE_STR-FEE_NAME_EXT sy-vline 
WA_P_SIFEE_STR-FEE_TYPE sy-vline 
WA_P_SIFEE_STR-INT_DESC sy-vline 
WA_P_SIFEE_STR-EXT_DESC sy-vline 
WA_P_SIFEE_STR-STATUS sy-vline 
WA_P_SIFEE_STR-VALID_FROM sy-vline 
WA_P_SIFEE_STR-VALID_TO sy-vline 
WA_P_SIFEE_STR-GL_SOURCE sy-vline 
WA_P_SIFEE_STR-PCF_FLAT_FEE sy-vline 
WA_P_SIFEE_STR-PCF_FLAT_FEE_CURR sy-vline 
WA_P_SIFEE_STR-PCF_PERCENT_FEE sy-vline 
WA_P_SIFEE_STR-PCF_STAGGERED sy-vline 
WA_P_SIFEE_STR-PCF_NON_STAGGERED sy-vline 
WA_P_SIFEE_STR-PCF_CALC_REF sy-vline 
WA_P_SIFEE_STR-REL_PP_STL sy-vline 
WA_P_SIFEE_STR-PREPAYMENT_AMT sy-vline 
WA_P_SIFEE_STR-PREPAYMENT_CURR sy-vline 
WA_P_SIFEE_STR-PREPAYMENTDISTRQUANTITY sy-vline 
WA_P_SIFEE_STR-PREPAYMENTDISTRUOM sy-vline 
WA_P_SIFEE_STR-PREPAYMENTDISTRAMOUNT sy-vline 
WA_P_SIFEE_STR-PREPAYMENTDISTRCURRENCY sy-vline 
WA_P_SIFEE_STR-SIDE sy-vline 
WA_P_SIFEE_STR-APPLDOC sy-vline 
WA_P_SIFEE_STR-ITEM sy-vline 
WA_P_SIFEE_STR-SUB_ITEM sy-vline 
WA_P_SIFEE_STR-APPLDOC_TYPE sy-vline 
WA_P_SIFEE_STR-REF_APP_DOC sy-vline 
WA_P_SIFEE_STR-REF_APP_DOC_TYP sy-vline 
WA_P_SIFEE_STR-CONTRACT sy-vline 
WA_P_SIFEE_STR-CONTRACT_ITM sy-vline 
WA_P_SIFEE_STR-CONTRACT_SUBITEM sy-vline 
WA_P_SIFEE_STR-CONTRACT_CURR sy-vline 
WA_P_SIFEE_STR-CONTRACT_DOC_TYPE sy-vline 
WA_P_SIFEE_STR-APPL_STATUS_OBJNR sy-vline 
WA_P_SIFEE_STR-STL_STATUS_OBJNR sy-vline 
WA_P_SIFEE_STR-UIS_EVNT_ID sy-vline 
WA_P_SIFEE_STR-UIS_EVNT_GUID sy-vline 
WA_P_SIFEE_STR-DELIVERY_TYPE sy-vline 
WA_P_SIFEE_STR-OB_DELIVERY sy-vline 
WA_P_SIFEE_STR-DELIVERY_ITEM sy-vline 
WA_P_SIFEE_STR-DELIVERY_SIDE sy-vline 
WA_P_SIFEE_STR-ORDER_TYPE sy-vline 
WA_P_SIFEE_STR-ORDER_NO sy-vline 
WA_P_SIFEE_STR-ORDER_ITM sy-vline 
WA_P_SIFEE_STR-ORDER_SIDE sy-vline 
WA_P_SIFEE_STR-GROSS_QTY sy-vline 
WA_P_SIFEE_STR-GROSS_UOM sy-vline 
WA_P_SIFEE_STR-LAQ_QTY sy-vline 
WA_P_SIFEE_STR-LAQ_UOM sy-vline 
WA_P_SIFEE_STR-MATERIAL sy-vline 
WA_P_SIFEE_STR-CREATED_BY sy-vline 
WA_P_SIFEE_STR-CREATED_ON sy-vline 
WA_P_SIFEE_STR-CHANGED_BY sy-vline 
WA_P_SIFEE_STR-CHANGED_ON sy-vline 
WA_P_SIFEE_STR-PLANT sy-vline 
WA_P_SIFEE_STR-COMPANY_CODE sy-vline 
WA_P_SIFEE_STR-SALES_ORG sy-vline 
WA_P_SIFEE_STR-PURCH_ORG sy-vline 
WA_P_SIFEE_STR-DIST_CHNL sy-vline 
WA_P_SIFEE_STR-DIVISION sy-vline 
WA_P_SIFEE_STR-PURCH_GRP sy-vline 
WA_P_SIFEE_STR-CONTRACT_TYPE sy-vline 
WA_P_SIFEE_STR-PROFIT_CENTER sy-vline 
WA_P_SIFEE_STR-SUPPLIER sy-vline 
WA_P_SIFEE_STR-SOLD_TO_PARTY sy-vline 
WA_P_SIFEE_STR-NOMTK sy-vline 
WA_P_SIFEE_STR-NOMNR sy-vline 
WA_P_SIFEE_STR-NOMIT sy-vline 
WA_P_SIFEE_STR-PRCFX_ASG_QTY sy-vline 
WA_P_SIFEE_STR-ASSGD_QUAN_ORIG sy-vline 
WA_P_SIFEE_STR-PRXFX_ASG_UOM sy-vline 
WA_P_SIFEE_STR-ASSGMT_GUID sy-vline 
WA_P_SIFEE_STR-PRICING_ASPECT_ID sy-vline 
WA_P_SIFEE_STR-PRICING_ASPECT_COUNTER sy-vline 
WA_P_SIFEE_STR-PRICE_FIXATION_NUMBER sy-vline 
WA_P_SIFEE_STR-SETTL_DOC sy-vline 
WA_P_SIFEE_STR-SETTL_YR sy-vline 
WA_P_SIFEE_STR-SETTL_CAT sy-vline 
WA_P_SIFEE_STR-SETTL_TYPE sy-vline 
WA_P_SIFEE_STR-SETTL_SIDE sy-vline 
WA_P_SIFEE_STR-DOC_TYP sy-vline 
WA_P_SIFEE_STR-SETTL_SCENARIO sy-vline 
WA_P_SIFEE_STR-SETTL_ITEM sy-vline 
WA_P_SIFEE_STR-FULL_SHIP_QTY sy-vline 
WA_P_SIFEE_STR-TOT_QUANTITY_ADJ sy-vline 
WA_P_SIFEE_STR-ADJ_UOM sy-vline 
WA_P_SIFEE_STR-DOC_CURR sy-vline 
WA_P_SIFEE_STR-UNIT_QUANTITY sy-vline 
WA_P_SIFEE_STR-UNIT_UOM sy-vline 
WA_P_SIFEE_STR-CONTRACT_QTY sy-vline 
WA_P_SIFEE_STR-CONTRACT_UOM sy-vline 
WA_P_SIFEE_STR-DOCUMENT_QTY sy-vline 
WA_P_SIFEE_STR-DOCUMENT_UOM sy-vline 
WA_P_SIFEE_STR-QREP_GUID sy-vline 
WA_P_SIFEE_STR-QREP_VERSION sy-vline 
WA_P_SIFEE_STR-CONTRACT_STATUS sy-vline 
WA_P_SIFEE_STR-PREPAYMENTAGRMTREFDOCUMENT sy-vline 
WA_P_SIFEE_STR-PREPAYMENTAGRMTREFDOCITEM sy-vline 
WA_P_SIFEE_STR-PREPAYMENTAGREEMENT sy-vline      INTO ld_text SEPARATED BY SPACE.

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