ABAP Select data from SAP table ECRMIN 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 ECRMIN 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 ECRMIN. 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 ECRMIN 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_ECRMIN TYPE STANDARD TABLE OF ECRMIN,
      WA_ECRMIN TYPE ECRMIN,
      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: <ECRMIN> TYPE ECRMIN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM ECRMIN
*  INTO TABLE @DATA(IT_ECRMIN2).
*--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_ECRMIN INDEX 1 INTO DATA(WA_ECRMIN2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_ECRMIN ASSIGNING <ECRMIN>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<ECRMIN>-FIRSTTRY = 1.
<ECRMIN>-COMPLETED = 1.
<ECRMIN>-RETRY = 1.
<ECRMIN>-CRM_BUG = 1.
<ECRMIN>-FAILED = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_ECRMIN-CONTRACT, sy-vline,
WA_ECRMIN-EXT_UI, sy-vline,
WA_ECRMIN-INT_UI, sy-vline,
WA_ECRMIN-PARTNER_GUID, sy-vline,
WA_ECRMIN-VKONTO_GUID, sy-vline,
WA_ECRMIN-AB, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ECRMIN 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_ECRMIN 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_ECRMIN INTO WA_ECRMIN. *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 UCAMP, internal->external for field CAMPAIGN CALL FUNCTION 'CONVERSION_EXIT_UCAMP_OUTPUT' EXPORTING input = WA_ECRMIN-CAMPAIGN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ECRMIN-CAMPAIGN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit UCAMP, internal->external for field CAMPAIGN CALL FUNCTION 'CONVERSION_EXIT_UCAMP_OUTPUT' EXPORTING input = WA_ECRMIN-CAMPAIGN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ECRMIN-CAMPAIGN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit TPLNR, internal->external for field HAUS CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT' EXPORTING input = WA_ECRMIN-HAUS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ECRMIN-HAUS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ISOLA, internal->external for field TXTLANGU CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT' EXPORTING input = WA_ECRMIN-TXTLANGU IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ECRMIN-TXTLANGU.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit TPLNR, internal->external for field TPLNUMMER CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT' EXPORTING input = WA_ECRMIN-TPLNUMMER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ECRMIN-TPLNUMMER.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit UCAMP, internal->external for field CAMPAIGN CALL FUNCTION 'CONVERSION_EXIT_UCAMP_OUTPUT' EXPORTING input = WA_ECRMIN-CAMPAIGN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ECRMIN-CAMPAIGN.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit TPLNR, internal->external for field SERVLOC CALL FUNCTION 'CONVERSION_EXIT_TPLNR_OUTPUT' EXPORTING input = WA_ECRMIN-SERVLOC IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ECRMIN-SERVLOC.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPHA, internal->external for field PARTNER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ECRMIN-PARTNER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ECRMIN-PARTNER.
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_ECRMIN_STR,
FIRSTTRY TYPE STRING,
COMPLETED TYPE STRING,
RETRY TYPE STRING,
CRM_BUG TYPE STRING,
FAILED TYPE STRING,
CONTRACT TYPE STRING,
EXT_UI TYPE STRING,
INT_UI TYPE STRING,
PARTNER_GUID TYPE STRING,
VKONTO_GUID TYPE STRING,
AB TYPE STRING,
BIS TYPE STRING,
CONTRACTHEAD TYPE STRING,
CONTRACTPOS TYPE STRING,
CRM_PRODUCT TYPE STRING,
PRODID TYPE STRING,
PRODUCT_GUID TYPE STRING,
CAMPAIGN TYPE STRING,
NUM TYPE STRING,
CRM_OBJECT_ID TYPE STRING,
CRM_OBJECT_POS TYPE STRING,
CANCREASON_NEW TYPE STRING,
CAMPAIGN_TO_DATE TYPE STRING,
OUCONTRACT TYPE STRING,
OUCONTRACT_I TYPE STRING,
VERTRAG TYPE STRING,
BLOCKED_GUID_I TYPE STRING,
BLOCKED_BUAG_GUID TYPE STRING,
BLOCKED_BUAG_ID TYPE STRING,
BLOCKED_STARTDATE TYPE STRING,
CHANGE_TICKET1 TYPE STRING,
ACT_SWTCMSG TYPE STRING,
DEACT_SWTCMSG TYPE STRING,
RELTOPREV TYPE STRING,
RELTONEXT TYPE STRING,
PREV_TS_GUID TYPE STRING,
NEXT_TS_GUID TYPE STRING,
DELETED TYPE STRING,
BUNDLE_GUID TYPE STRING,
PRODCH_BEG TYPE STRING,
PRODCH_END TYPE STRING,
VKONTO TYPE STRING,
PARTNER TYPE STRING,
CANCELED TYPE STRING,
ACT_SWTCDOC TYPE STRING,
DEACT_SWTCDOC TYPE STRING,
CRM_ITEM_DESCR TYPE STRING,
CONTRACT_OLD TYPE STRING,
EXT_UI TYPE STRING,
INT_UI TYPE STRING,
PARTNER_GUID TYPE STRING,
VKONTO_GUID TYPE STRING,
AB TYPE STRING,
BIS TYPE STRING,
CONTRACTHEAD TYPE STRING,
CONTRACTPOS TYPE STRING,
CRM_PRODUCT TYPE STRING,
PRODID TYPE STRING,
PRODUCT_GUID TYPE STRING,
CAMPAIGN TYPE STRING,
NUM TYPE STRING,
CRM_OBJECT_ID TYPE STRING,
CRM_OBJECT_POS TYPE STRING,
CANCREASON_NEW TYPE STRING,
CAMPAIGN_TO_DATE TYPE STRING,
OUCONTRACT TYPE STRING,
OUCONTRACT_I TYPE STRING,
VERTRAG TYPE STRING,
BLOCKED_GUID_I TYPE STRING,
BLOCKED_BUAG_GUID TYPE STRING,
BLOCKED_BUAG_ID TYPE STRING,
BLOCKED_STARTDATE TYPE STRING,
CHANGE_TICKET1 TYPE STRING,
ACT_SWTCMSG TYPE STRING,
DEACT_SWTCMSG TYPE STRING,
RELTOPREV TYPE STRING,
RELTONEXT TYPE STRING,
PREV_TS_GUID TYPE STRING,
NEXT_TS_GUID TYPE STRING,
DELETED TYPE STRING,
BUNDLE_GUID TYPE STRING,
PRODCH_BEG TYPE STRING,
PRODCH_END TYPE STRING,
VKONTO TYPE STRING,
PARTNER TYPE STRING,
CANCELED TYPE STRING,
ACT_SWTCDOC TYPE STRING,
DEACT_SWTCDOC TYPE STRING,
CRM_ITEM_DESCR TYPE STRING,
PROCESSNUMBER TYPE STRING,
T_VERTRAG TYPE STRING,
T_EVERH_CRM TYPE STRING,
T_EANLS_UI TYPE STRING,
T_ENVCRMCONTR TYPE STRING,
CONTR TYPE STRING,
MO_CREATE TYPE STRING,
MO_DATECHANGE TYPE STRING,
MO_REVERSE TYPE STRING,
MI_CREATE TYPE STRING,
MI_DATECHANGE TYPE STRING,
MI_REVERSE TYPE STRING,
GENERATE TYPE STRING,
FULL_GENERATION TYPE STRING,
MO_CREATEH TYPE STRING,
MO_DATECHANGEH TYPE STRING,
MO_REVERSEH TYPE STRING,
MI_CREATEH TYPE STRING,
MI_DATECHANGEH TYPE STRING,
MI_REVERSEH TYPE STRING,
MI_NOCONTRGEN TYPE STRING,
MI_INSERT TYPE STRING,
MI_INSERT_REV TYPE STRING,
PC_ADJUSTBBP TYPE STRING,
PC_PRINTDOC TYPE STRING,
VK_CHANGED TYPE STRING,
CONTRACT_CHANGE TYPE STRING,
REV_INVOICE TYPE STRING,
GENERATE_FROM TYPE STRING,
GENERATE_TO TYPE STRING,
EVERH_CHANGE TYPE STRING,
PRODCH_BEG TYPE STRING,
PRODCH_END TYPE STRING,
PRODCLR TYPE STRING,
PRODCLR_AB TYPE STRING,
PRODCLR_BIS TYPE STRING,
ERRORLOG TYPE STRING,
CRMLOG TYPE STRING,
ERRORCONTR TYPE STRING,
ERROR TYPE STRING,
MO_CREATE TYPE STRING,
MO_DATECHANGE TYPE STRING,
MO_REVERSE TYPE STRING,
MI_CREATE TYPE STRING,
MI_DATECHANGE TYPE STRING,
MI_REVERSE TYPE STRING,
GENERATE TYPE STRING,
FULL_GENERATION TYPE STRING,
MO_CREATEH TYPE STRING,
MO_DATECHANGEH TYPE STRING,
MO_REVERSEH TYPE STRING,
MI_CREATEH TYPE STRING,
MI_DATECHANGEH TYPE STRING,
MI_REVERSEH TYPE STRING,
MI_NOCONTRGEN TYPE STRING,
MI_INSERT TYPE STRING,
MI_INSERT_REV TYPE STRING,
PC_ADJUSTBBP TYPE STRING,
PC_PRINTDOC TYPE STRING,
MO_BILLED TYPE STRING,
MI_BILLED TYPE STRING,
MDG_CREATE TYPE STRING,
MDG_INCOMPLETE TYPE STRING,
TEMPORARY TYPE STRING,
LOGHANDLE TYPE STRING,
VERTRAG TYPE STRING,
CRMBUGCONFIRM TYPE STRING,
INFORMCONFIRM TYPE STRING,
CRMDATAINCMPLT TYPE STRING,
MDG_LOGID TYPE STRING,
MDGDATA TYPE STRING,
CRMPRODUCT TYPE STRING,
PRODID TYPE STRING,
CONST_TAB TYPE STRING,
PARAM_TAB TYPE STRING,
PARAMCONT TYPE STRING,
TOP_NODE_READ TYPE STRING,
EVBS TYPE STRING,
MANDT TYPE STRING,
VSTELLE TYPE STRING,
HAUS TYPE STRING,
STR_ERG2 TYPE STRING,
HAUS_NUM2 TYPE STRING,
TXTLANGU TYPE STRING,
LGZUSATZ TYPE STRING,
VBSART TYPE STRING,
EIGENT TYPE STRING,
OBJNR TYPE STRING,
TPLNUMMER TYPE STRING,
ERDAT TYPE STRING,
ERNAM TYPE STRING,
AEDAT TYPE STRING,
AENAM TYPE STRING,
BEGRU TYPE STRING,
LOEVM TYPE STRING,
ANZPERS TYPE STRING,
FLOOR TYPE STRING,
ROOMNUMBER TYPE STRING,
HPTWHNSITZ TYPE STRING,
STR_ERG4 TYPE STRING,
MDGDATA_OLD TYPE STRING,
DATE TYPE STRING,
EHAU TYPE STRING,
CONTAINER TYPE STRING,
CONTAINER_OLD TYPE STRING,
T_CONTRACT_STATUS TYPE STRING,
T_NEW_KEYS_TAB TYPE STRING,
CRMQ TYPE STRING,
RESTART TYPE STRING,
RESTART_CRMQ TYPE STRING,
MANDT TYPE STRING,
CONTRACTPOS TYPE STRING,
NUM TYPE STRING,
VERTRAG TYPE STRING,
ANLAGE TYPE STRING,
AB TYPE STRING,
BIS TYPE STRING,
CRM_PRODUCT TYPE STRING,
PRODID TYPE STRING,
PRODUCT_GUID TYPE STRING,
CAMPAIGN TYPE STRING,
CAMPAIGN_TO_DATE TYPE STRING,
IN_PROGRESS TYPE STRING,
GEN_AB TYPE STRING,
GEN_BIS TYPE STRING,
BILLED TYPE STRING,
INT_UI TYPE STRING,
PARTNER_GUID TYPE STRING,
VKONTO_GUID TYPE STRING,
CRM_OBJECT_ID TYPE STRING,
CRM_OBJECT_POS TYPE STRING,
CANCREASON_NEW TYPE STRING,
ERRORDATE TYPE STRING,
ERRORTIME TYPE STRING,
MDG_CREATE TYPE STRING,
LOGHANDLE TYPE STRING,
MDG_LOG TYPE STRING,
CONTRACTHEAD TYPE STRING,
MO_CREATE TYPE STRING,
MO_DATECHANGE TYPE STRING,
MO_REVERSE TYPE STRING,
MI_CREATE TYPE STRING,
MI_DATECHANGE TYPE STRING,
MI_REVERSE TYPE STRING,
GENERATE TYPE STRING,
FULL_GENERATION TYPE STRING,
MO_CREATEH TYPE STRING,
MO_DATECHANGEH TYPE STRING,
MO_REVERSEH TYPE STRING,
MI_CREATEH TYPE STRING,
MI_DATECHANGEH TYPE STRING,
MI_REVERSEH TYPE STRING,
MI_NOCONTRGEN TYPE STRING,
MI_INSERT TYPE STRING,
MI_INSERT_REV TYPE STRING,
PC_ADJUSTBBP TYPE STRING,
PC_PRINTDOC TYPE STRING,
CRMBUGCONFIRM TYPE STRING,
INFORMCONFIRM TYPE STRING,
CRMDATAINCMPLT TYPE STRING,
MO_BILLED TYPE STRING,
MI_BILLED TYPE STRING,
MD_ORIGOBJ TYPE STRING,
PRECOND_GUID TYPE STRING,
XREPLCNTL TYPE STRING,
NOD TYPE STRING,
OUCONTRACT TYPE STRING,
INACTIVE TYPE STRING,
IN_BCKGRDPRC TYPE STRING,
NUM_RESTART TYPE STRING,
BBP_ADJUST TYPE STRING,
RTC_PRINT TYPE STRING,
RTC_FORMKEY TYPE STRING,
BBP_ADJUST_FLG TYPE STRING,
RTC_PRINT_FLG TYPE STRING,
AMIO_PRDOC TYPE STRING,
OUCONTRACT_I TYPE STRING,
VBELN TYPE STRING,
POSNR TYPE STRING,
PROP TYPE STRING,
SERVLOC TYPE STRING,
ACT_SWTCMSG TYPE STRING,
DEACT_SWTCMSG TYPE STRING,
RELTOPREV TYPE STRING,
RELTONEXT TYPE STRING,
PREV_TS_GUID TYPE STRING,
NEXT_TS_GUID TYPE STRING,
DELETED TYPE STRING,
BUNDLE_GUID TYPE STRING,
PRODCH_BEG TYPE STRING,
PRODCH_END TYPE STRING,
VKONTO TYPE STRING,
PARTNER TYPE STRING,
CANCELED TYPE STRING,
ACT_SWTCDOC TYPE STRING,
DEACT_SWTCDOC TYPE STRING,
CRM_ITEM_DESCR TYPE STRING,
EMMA_RUNID TYPE STRING,
EMMA_INTNR TYPE STRING,
CASE_VIA_BADI TYPE STRING,
RESTART_WF_CONT TYPE STRING,
ECRM_CRM_UPLOAD TYPE STRING,END OF T_EKKO_STR. DATA: WA_ECRMIN_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_ECRMIN_STR-FIRSTTRY sy-vline
WA_ECRMIN_STR-COMPLETED sy-vline
WA_ECRMIN_STR-RETRY sy-vline
WA_ECRMIN_STR-CRM_BUG sy-vline
WA_ECRMIN_STR-FAILED sy-vline
WA_ECRMIN_STR-CONTRACT sy-vline
WA_ECRMIN_STR-EXT_UI sy-vline
WA_ECRMIN_STR-INT_UI sy-vline
WA_ECRMIN_STR-PARTNER_GUID sy-vline
WA_ECRMIN_STR-VKONTO_GUID sy-vline
WA_ECRMIN_STR-AB sy-vline
WA_ECRMIN_STR-BIS sy-vline
WA_ECRMIN_STR-CONTRACTHEAD sy-vline
WA_ECRMIN_STR-CONTRACTPOS sy-vline
WA_ECRMIN_STR-CRM_PRODUCT sy-vline
WA_ECRMIN_STR-PRODID sy-vline
WA_ECRMIN_STR-PRODUCT_GUID sy-vline
WA_ECRMIN_STR-CAMPAIGN sy-vline
WA_ECRMIN_STR-NUM sy-vline
WA_ECRMIN_STR-CRM_OBJECT_ID sy-vline
WA_ECRMIN_STR-CRM_OBJECT_POS sy-vline
WA_ECRMIN_STR-CANCREASON_NEW sy-vline
WA_ECRMIN_STR-CAMPAIGN_TO_DATE sy-vline
WA_ECRMIN_STR-OUCONTRACT sy-vline
WA_ECRMIN_STR-OUCONTRACT_I sy-vline
WA_ECRMIN_STR-VERTRAG sy-vline
WA_ECRMIN_STR-BLOCKED_GUID_I sy-vline
WA_ECRMIN_STR-BLOCKED_BUAG_GUID sy-vline
WA_ECRMIN_STR-BLOCKED_BUAG_ID sy-vline
WA_ECRMIN_STR-BLOCKED_STARTDATE sy-vline
WA_ECRMIN_STR-CHANGE_TICKET1 sy-vline
WA_ECRMIN_STR-ACT_SWTCMSG sy-vline
WA_ECRMIN_STR-DEACT_SWTCMSG sy-vline
WA_ECRMIN_STR-RELTOPREV sy-vline
WA_ECRMIN_STR-RELTONEXT sy-vline
WA_ECRMIN_STR-PREV_TS_GUID sy-vline
WA_ECRMIN_STR-NEXT_TS_GUID sy-vline
WA_ECRMIN_STR-DELETED sy-vline
WA_ECRMIN_STR-BUNDLE_GUID sy-vline
WA_ECRMIN_STR-PRODCH_BEG sy-vline
WA_ECRMIN_STR-PRODCH_END sy-vline
WA_ECRMIN_STR-VKONTO sy-vline
WA_ECRMIN_STR-PARTNER sy-vline
WA_ECRMIN_STR-CANCELED sy-vline
WA_ECRMIN_STR-ACT_SWTCDOC sy-vline
WA_ECRMIN_STR-DEACT_SWTCDOC sy-vline
WA_ECRMIN_STR-CRM_ITEM_DESCR sy-vline
WA_ECRMIN_STR-CONTRACT_OLD sy-vline
WA_ECRMIN_STR-EXT_UI sy-vline
WA_ECRMIN_STR-INT_UI sy-vline
WA_ECRMIN_STR-PARTNER_GUID sy-vline
WA_ECRMIN_STR-VKONTO_GUID sy-vline
WA_ECRMIN_STR-AB sy-vline
WA_ECRMIN_STR-BIS sy-vline
WA_ECRMIN_STR-CONTRACTHEAD sy-vline
WA_ECRMIN_STR-CONTRACTPOS sy-vline
WA_ECRMIN_STR-CRM_PRODUCT sy-vline
WA_ECRMIN_STR-PRODID sy-vline
WA_ECRMIN_STR-PRODUCT_GUID sy-vline
WA_ECRMIN_STR-CAMPAIGN sy-vline
WA_ECRMIN_STR-NUM sy-vline
WA_ECRMIN_STR-CRM_OBJECT_ID sy-vline
WA_ECRMIN_STR-CRM_OBJECT_POS sy-vline
WA_ECRMIN_STR-CANCREASON_NEW sy-vline
WA_ECRMIN_STR-CAMPAIGN_TO_DATE sy-vline
WA_ECRMIN_STR-OUCONTRACT sy-vline
WA_ECRMIN_STR-OUCONTRACT_I sy-vline
WA_ECRMIN_STR-VERTRAG sy-vline
WA_ECRMIN_STR-BLOCKED_GUID_I sy-vline
WA_ECRMIN_STR-BLOCKED_BUAG_GUID sy-vline
WA_ECRMIN_STR-BLOCKED_BUAG_ID sy-vline
WA_ECRMIN_STR-BLOCKED_STARTDATE sy-vline
WA_ECRMIN_STR-CHANGE_TICKET1 sy-vline
WA_ECRMIN_STR-ACT_SWTCMSG sy-vline
WA_ECRMIN_STR-DEACT_SWTCMSG sy-vline
WA_ECRMIN_STR-RELTOPREV sy-vline
WA_ECRMIN_STR-RELTONEXT sy-vline
WA_ECRMIN_STR-PREV_TS_GUID sy-vline
WA_ECRMIN_STR-NEXT_TS_GUID sy-vline
WA_ECRMIN_STR-DELETED sy-vline
WA_ECRMIN_STR-BUNDLE_GUID sy-vline
WA_ECRMIN_STR-PRODCH_BEG sy-vline
WA_ECRMIN_STR-PRODCH_END sy-vline
WA_ECRMIN_STR-VKONTO sy-vline
WA_ECRMIN_STR-PARTNER sy-vline
WA_ECRMIN_STR-CANCELED sy-vline
WA_ECRMIN_STR-ACT_SWTCDOC sy-vline
WA_ECRMIN_STR-DEACT_SWTCDOC sy-vline
WA_ECRMIN_STR-CRM_ITEM_DESCR sy-vline
WA_ECRMIN_STR-PROCESSNUMBER sy-vline
WA_ECRMIN_STR-T_VERTRAG sy-vline
WA_ECRMIN_STR-T_EVERH_CRM sy-vline
WA_ECRMIN_STR-T_EANLS_UI sy-vline
WA_ECRMIN_STR-T_ENVCRMCONTR sy-vline
WA_ECRMIN_STR-CONTR sy-vline
WA_ECRMIN_STR-MO_CREATE sy-vline
WA_ECRMIN_STR-MO_DATECHANGE sy-vline
WA_ECRMIN_STR-MO_REVERSE sy-vline
WA_ECRMIN_STR-MI_CREATE sy-vline
WA_ECRMIN_STR-MI_DATECHANGE sy-vline
WA_ECRMIN_STR-MI_REVERSE sy-vline
WA_ECRMIN_STR-GENERATE sy-vline
WA_ECRMIN_STR-FULL_GENERATION sy-vline
WA_ECRMIN_STR-MO_CREATEH sy-vline
WA_ECRMIN_STR-MO_DATECHANGEH sy-vline
WA_ECRMIN_STR-MO_REVERSEH sy-vline
WA_ECRMIN_STR-MI_CREATEH sy-vline
WA_ECRMIN_STR-MI_DATECHANGEH sy-vline
WA_ECRMIN_STR-MI_REVERSEH sy-vline
WA_ECRMIN_STR-MI_NOCONTRGEN sy-vline
WA_ECRMIN_STR-MI_INSERT sy-vline
WA_ECRMIN_STR-MI_INSERT_REV sy-vline
WA_ECRMIN_STR-PC_ADJUSTBBP sy-vline
WA_ECRMIN_STR-PC_PRINTDOC sy-vline
WA_ECRMIN_STR-VK_CHANGED sy-vline
WA_ECRMIN_STR-CONTRACT_CHANGE sy-vline
WA_ECRMIN_STR-REV_INVOICE sy-vline
WA_ECRMIN_STR-GENERATE_FROM sy-vline
WA_ECRMIN_STR-GENERATE_TO sy-vline
WA_ECRMIN_STR-EVERH_CHANGE sy-vline
WA_ECRMIN_STR-PRODCH_BEG sy-vline
WA_ECRMIN_STR-PRODCH_END sy-vline
WA_ECRMIN_STR-PRODCLR sy-vline
WA_ECRMIN_STR-PRODCLR_AB sy-vline
WA_ECRMIN_STR-PRODCLR_BIS sy-vline
WA_ECRMIN_STR-ERRORLOG sy-vline
WA_ECRMIN_STR-CRMLOG sy-vline
WA_ECRMIN_STR-ERRORCONTR sy-vline
WA_ECRMIN_STR-ERROR sy-vline
WA_ECRMIN_STR-MO_CREATE sy-vline
WA_ECRMIN_STR-MO_DATECHANGE sy-vline
WA_ECRMIN_STR-MO_REVERSE sy-vline
WA_ECRMIN_STR-MI_CREATE sy-vline
WA_ECRMIN_STR-MI_DATECHANGE sy-vline
WA_ECRMIN_STR-MI_REVERSE sy-vline
WA_ECRMIN_STR-GENERATE sy-vline
WA_ECRMIN_STR-FULL_GENERATION sy-vline
WA_ECRMIN_STR-MO_CREATEH sy-vline
WA_ECRMIN_STR-MO_DATECHANGEH sy-vline
WA_ECRMIN_STR-MO_REVERSEH sy-vline
WA_ECRMIN_STR-MI_CREATEH sy-vline
WA_ECRMIN_STR-MI_DATECHANGEH sy-vline
WA_ECRMIN_STR-MI_REVERSEH sy-vline
WA_ECRMIN_STR-MI_NOCONTRGEN sy-vline
WA_ECRMIN_STR-MI_INSERT sy-vline
WA_ECRMIN_STR-MI_INSERT_REV sy-vline
WA_ECRMIN_STR-PC_ADJUSTBBP sy-vline
WA_ECRMIN_STR-PC_PRINTDOC sy-vline
WA_ECRMIN_STR-MO_BILLED sy-vline
WA_ECRMIN_STR-MI_BILLED sy-vline
WA_ECRMIN_STR-MDG_CREATE sy-vline
WA_ECRMIN_STR-MDG_INCOMPLETE sy-vline
WA_ECRMIN_STR-TEMPORARY sy-vline
WA_ECRMIN_STR-LOGHANDLE sy-vline
WA_ECRMIN_STR-VERTRAG sy-vline
WA_ECRMIN_STR-CRMBUGCONFIRM sy-vline
WA_ECRMIN_STR-INFORMCONFIRM sy-vline
WA_ECRMIN_STR-CRMDATAINCMPLT sy-vline
WA_ECRMIN_STR-MDG_LOGID sy-vline
WA_ECRMIN_STR-MDGDATA sy-vline
WA_ECRMIN_STR-CRMPRODUCT sy-vline
WA_ECRMIN_STR-PRODID sy-vline
WA_ECRMIN_STR-CONST_TAB sy-vline
WA_ECRMIN_STR-PARAM_TAB sy-vline
WA_ECRMIN_STR-PARAMCONT sy-vline
WA_ECRMIN_STR-TOP_NODE_READ sy-vline
WA_ECRMIN_STR-EVBS sy-vline
WA_ECRMIN_STR-MANDT sy-vline
WA_ECRMIN_STR-VSTELLE sy-vline
WA_ECRMIN_STR-HAUS sy-vline
WA_ECRMIN_STR-STR_ERG2 sy-vline
WA_ECRMIN_STR-HAUS_NUM2 sy-vline
WA_ECRMIN_STR-TXTLANGU sy-vline
WA_ECRMIN_STR-LGZUSATZ sy-vline
WA_ECRMIN_STR-VBSART sy-vline
WA_ECRMIN_STR-EIGENT sy-vline
WA_ECRMIN_STR-OBJNR sy-vline
WA_ECRMIN_STR-TPLNUMMER sy-vline
WA_ECRMIN_STR-ERDAT sy-vline
WA_ECRMIN_STR-ERNAM sy-vline
WA_ECRMIN_STR-AEDAT sy-vline
WA_ECRMIN_STR-AENAM sy-vline
WA_ECRMIN_STR-BEGRU sy-vline
WA_ECRMIN_STR-LOEVM sy-vline
WA_ECRMIN_STR-ANZPERS sy-vline
WA_ECRMIN_STR-FLOOR sy-vline
WA_ECRMIN_STR-ROOMNUMBER sy-vline
WA_ECRMIN_STR-HPTWHNSITZ sy-vline
WA_ECRMIN_STR-STR_ERG4 sy-vline
WA_ECRMIN_STR-MDGDATA_OLD sy-vline
WA_ECRMIN_STR-DATE sy-vline
WA_ECRMIN_STR-EHAU sy-vline
WA_ECRMIN_STR-CONTAINER sy-vline
WA_ECRMIN_STR-CONTAINER_OLD sy-vline
WA_ECRMIN_STR-T_CONTRACT_STATUS sy-vline
WA_ECRMIN_STR-T_NEW_KEYS_TAB sy-vline
WA_ECRMIN_STR-CRMQ sy-vline
WA_ECRMIN_STR-RESTART sy-vline
WA_ECRMIN_STR-RESTART_CRMQ sy-vline
WA_ECRMIN_STR-MANDT sy-vline
WA_ECRMIN_STR-CONTRACTPOS sy-vline
WA_ECRMIN_STR-NUM sy-vline
WA_ECRMIN_STR-VERTRAG sy-vline
WA_ECRMIN_STR-ANLAGE sy-vline
WA_ECRMIN_STR-AB sy-vline
WA_ECRMIN_STR-BIS sy-vline
WA_ECRMIN_STR-CRM_PRODUCT sy-vline
WA_ECRMIN_STR-PRODID sy-vline
WA_ECRMIN_STR-PRODUCT_GUID sy-vline
WA_ECRMIN_STR-CAMPAIGN sy-vline
WA_ECRMIN_STR-CAMPAIGN_TO_DATE sy-vline
WA_ECRMIN_STR-IN_PROGRESS sy-vline
WA_ECRMIN_STR-GEN_AB sy-vline
WA_ECRMIN_STR-GEN_BIS sy-vline
WA_ECRMIN_STR-BILLED sy-vline
WA_ECRMIN_STR-INT_UI sy-vline
WA_ECRMIN_STR-PARTNER_GUID sy-vline
WA_ECRMIN_STR-VKONTO_GUID sy-vline
WA_ECRMIN_STR-CRM_OBJECT_ID sy-vline
WA_ECRMIN_STR-CRM_OBJECT_POS sy-vline
WA_ECRMIN_STR-CANCREASON_NEW sy-vline
WA_ECRMIN_STR-ERRORDATE sy-vline
WA_ECRMIN_STR-ERRORTIME sy-vline
WA_ECRMIN_STR-MDG_CREATE sy-vline
WA_ECRMIN_STR-LOGHANDLE sy-vline
WA_ECRMIN_STR-MDG_LOG sy-vline
WA_ECRMIN_STR-CONTRACTHEAD sy-vline
WA_ECRMIN_STR-MO_CREATE sy-vline
WA_ECRMIN_STR-MO_DATECHANGE sy-vline
WA_ECRMIN_STR-MO_REVERSE sy-vline
WA_ECRMIN_STR-MI_CREATE sy-vline
WA_ECRMIN_STR-MI_DATECHANGE sy-vline
WA_ECRMIN_STR-MI_REVERSE sy-vline
WA_ECRMIN_STR-GENERATE sy-vline
WA_ECRMIN_STR-FULL_GENERATION sy-vline
WA_ECRMIN_STR-MO_CREATEH sy-vline
WA_ECRMIN_STR-MO_DATECHANGEH sy-vline
WA_ECRMIN_STR-MO_REVERSEH sy-vline
WA_ECRMIN_STR-MI_CREATEH sy-vline
WA_ECRMIN_STR-MI_DATECHANGEH sy-vline
WA_ECRMIN_STR-MI_REVERSEH sy-vline
WA_ECRMIN_STR-MI_NOCONTRGEN sy-vline
WA_ECRMIN_STR-MI_INSERT sy-vline
WA_ECRMIN_STR-MI_INSERT_REV sy-vline
WA_ECRMIN_STR-PC_ADJUSTBBP sy-vline
WA_ECRMIN_STR-PC_PRINTDOC sy-vline
WA_ECRMIN_STR-CRMBUGCONFIRM sy-vline
WA_ECRMIN_STR-INFORMCONFIRM sy-vline
WA_ECRMIN_STR-CRMDATAINCMPLT sy-vline
WA_ECRMIN_STR-MO_BILLED sy-vline
WA_ECRMIN_STR-MI_BILLED sy-vline
WA_ECRMIN_STR-MD_ORIGOBJ sy-vline
WA_ECRMIN_STR-PRECOND_GUID sy-vline
WA_ECRMIN_STR-XREPLCNTL sy-vline
WA_ECRMIN_STR-NOD sy-vline
WA_ECRMIN_STR-OUCONTRACT sy-vline
WA_ECRMIN_STR-INACTIVE sy-vline
WA_ECRMIN_STR-IN_BCKGRDPRC sy-vline
WA_ECRMIN_STR-NUM_RESTART sy-vline
WA_ECRMIN_STR-BBP_ADJUST sy-vline
WA_ECRMIN_STR-RTC_PRINT sy-vline
WA_ECRMIN_STR-RTC_FORMKEY sy-vline
WA_ECRMIN_STR-BBP_ADJUST_FLG sy-vline
WA_ECRMIN_STR-RTC_PRINT_FLG sy-vline
WA_ECRMIN_STR-AMIO_PRDOC sy-vline
WA_ECRMIN_STR-OUCONTRACT_I sy-vline
WA_ECRMIN_STR-VBELN sy-vline
WA_ECRMIN_STR-POSNR sy-vline
WA_ECRMIN_STR-PROP sy-vline
WA_ECRMIN_STR-SERVLOC sy-vline
WA_ECRMIN_STR-ACT_SWTCMSG sy-vline
WA_ECRMIN_STR-DEACT_SWTCMSG sy-vline
WA_ECRMIN_STR-RELTOPREV sy-vline
WA_ECRMIN_STR-RELTONEXT sy-vline
WA_ECRMIN_STR-PREV_TS_GUID sy-vline
WA_ECRMIN_STR-NEXT_TS_GUID sy-vline
WA_ECRMIN_STR-DELETED sy-vline
WA_ECRMIN_STR-BUNDLE_GUID sy-vline
WA_ECRMIN_STR-PRODCH_BEG sy-vline
WA_ECRMIN_STR-PRODCH_END sy-vline
WA_ECRMIN_STR-VKONTO sy-vline
WA_ECRMIN_STR-PARTNER sy-vline
WA_ECRMIN_STR-CANCELED sy-vline
WA_ECRMIN_STR-ACT_SWTCDOC sy-vline
WA_ECRMIN_STR-DEACT_SWTCDOC sy-vline
WA_ECRMIN_STR-CRM_ITEM_DESCR sy-vline
WA_ECRMIN_STR-EMMA_RUNID sy-vline
WA_ECRMIN_STR-EMMA_INTNR sy-vline
WA_ECRMIN_STR-CASE_VIA_BADI sy-vline
WA_ECRMIN_STR-RESTART_WF_CONT sy-vline
WA_ECRMIN_STR-ECRM_CRM_UPLOAD sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.