ABAP Select data from SAP table COBJPGMAINTORD 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 COBJPGMAINTORD 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 COBJPGMAINTORD. 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 COBJPGMAINTORD 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_COBJPGMAINTORD TYPE STANDARD TABLE OF COBJPGMAINTORD,
      WA_COBJPGMAINTORD TYPE COBJPGMAINTORD,
      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: <COBJPGMAINTORD> TYPE COBJPGMAINTORD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM COBJPGMAINTORD
*  INTO TABLE @DATA(IT_COBJPGMAINTORD2).
*--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_COBJPGMAINTORD INDEX 1 INTO DATA(WA_COBJPGMAINTORD2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_COBJPGMAINTORD ASSIGNING <COBJPGMAINTORD>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<COBJPGMAINTORD>-MANDT = 1.
<COBJPGMAINTORD>-MAINTENANCEORDER = 1.
<COBJPGMAINTORD>-MAINTORDERWITHLEADINGZEROS = 1.
<COBJPGMAINTORD>-MAINTENANCEORDERDESC = 1.
<COBJPGMAINTORD>-MAINTENANCEORDERINTERNALID = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_COBJPGMAINTORD-MAINTENANCEORDERTYPE, sy-vline,
WA_COBJPGMAINTORD-MAINTENANCEORDERTYPENAME, sy-vline,
WA_COBJPGMAINTORD-MAINTENANCEPROCESSINGPHASE, sy-vline,
WA_COBJPGMAINTORD-MAINTENANCEPROCESSINGPHASEDESC, sy-vline,
WA_COBJPGMAINTORD-MAINTPRIORITY, sy-vline,
WA_COBJPGMAINTORD-LATESTACCEPTABLECOMPLETIONDATE, sy-vline.
ENDLOOP. *Add any further fields from structure WA_COBJPGMAINTORD 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_COBJPGMAINTORD 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_COBJPGMAINTORD INTO WA_COBJPGMAINTORD. *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 MAINTENANCEORDER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COBJPGMAINTORD-MAINTENANCEORDER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COBJPGMAINTORD-MAINTENANCEORDER.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit TECHO, internal->external for field TECHNICALOBJECTLABEL CALL FUNCTION 'CONVERSION_EXIT_TECHO_OUTPUT' EXPORTING input = WA_COBJPGMAINTORD-TECHNICALOBJECTLABEL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COBJPGMAINTORD-TECHNICALOBJECTLABEL.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit GERNR, internal->external for field SERIALNUMBER CALL FUNCTION 'CONVERSION_EXIT_GERNR_OUTPUT' EXPORTING input = WA_COBJPGMAINTORD-SERIALNUMBER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COBJPGMAINTORD-SERIALNUMBER.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit ABPSN, internal->external for field PROJECT CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_COBJPGMAINTORD-PROJECT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COBJPGMAINTORD-PROJECT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ABPSN, internal->external for field WBSELEMENT CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_COBJPGMAINTORD-WBSELEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COBJPGMAINTORD-WBSELEMENT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

*Conversion exit ABPSN, internal->external for field LOCACCTASSGMTWBSELEMENT CALL FUNCTION 'CONVERSION_EXIT_ABPSN_OUTPUT' EXPORTING input = WA_COBJPGMAINTORD-LOCACCTASSGMTWBSELEMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COBJPGMAINTORD-LOCACCTASSGMTWBSELEMENT.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ABPSP, internal->external for field WBSELEMENTINTERNALID CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT' EXPORTING input = WA_COBJPGMAINTORD-WBSELEMENTINTERNALID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COBJPGMAINTORD-WBSELEMENTINTERNALID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit PARVW, internal->external for field MAINTORDERRESPPARTNERFUNCTION CALL FUNCTION 'CONVERSION_EXIT_PARVW_OUTPUT' EXPORTING input = WA_COBJPGMAINTORD-MAINTORDERRESPPARTNERFUNCTION IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COBJPGMAINTORD-MAINTORDERRESPPARTNERFUNCTION.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field EQUIPMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_COBJPGMAINTORD-EQUIPMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_COBJPGMAINTORD-EQUIPMENT.
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_COBJPGMAINTORD_STR,
MANDT TYPE STRING,
MAINTENANCEORDER TYPE STRING,
MAINTORDERWITHLEADINGZEROS TYPE STRING,
MAINTENANCEORDERDESC TYPE STRING,
MAINTENANCEORDERINTERNALID TYPE STRING,
MAINTENANCEORDERTYPE TYPE STRING,
MAINTENANCEORDERTYPENAME TYPE STRING,
MAINTENANCEPROCESSINGPHASE TYPE STRING,
MAINTENANCEPROCESSINGPHASEDESC TYPE STRING,
MAINTPRIORITY TYPE STRING,
LATESTACCEPTABLECOMPLETIONDATE TYPE STRING,
MAINTPRIORITYCOLORCODE TYPE STRING,
MAINTPRIORITYDESC TYPE STRING,
MAINTENANCENOTIFICATION TYPE STRING,
MAINTENANCENOTIFICATIONTEXT TYPE STRING,
TASKLISTGROUP TYPE STRING,
TASKLISTTYPE TYPE STRING,
TASKLISTGROUPCOUNTER TYPE STRING,
TASKLISTKEYDATE TYPE STRING,
TASKLIST TYPE STRING,
TASKLISTDESC TYPE STRING,
MAINTENANCEPLAN TYPE STRING,
MAINTENANCEPLANDESC TYPE STRING,
MAINTENANCEITEM TYPE STRING,
MAINTENANCEITEMDESCRIPTION TYPE STRING,
TECHNICALOBJECTLABEL TYPE STRING,
TECHNICALOBJECTDESCRIPTION TYPE STRING,
FUNCTIONALLOCATIONNAME TYPE STRING,
EQUIPMENTNAME TYPE STRING,
TECHOBJISEQUIPORFUNCNLLOC TYPE STRING,
TECHOBJISEQUIPORFUNCNLLOCDESC TYPE STRING,
ORDERHASLONGTEXT TYPE STRING,
MAINWORKCENTER TYPE STRING,
MAINWORKCENTERTEXT TYPE STRING,
MAINTORDBASICSTARTDATE TYPE STRING,
MAINTORDBASICENDDATE TYPE STRING,
MAINTORDSCHEDBASICSTARTDATE TYPE STRING,
SCHEDULEDBASICENDDATE TYPE STRING,
MAINTORDSCHEDBASICSTARTTIME TYPE STRING,
MAINTORDERREFERENCEDATE TYPE STRING,
CONCATENATEDACTIVESYSTSTSNAME TYPE STRING,
CONCATENATEDACTIVEUSERSTSNAME TYPE STRING,
CONCATENATEDORDERPHASECTRLTEXT TYPE STRING,
MAINTOBJNMBROFPHASECTRLCODES TYPE STRING,
MAINTORDHASOPENMAINWORK TYPE STRING,
ORDERNMBROFATTACHEDDOCUMENTS TYPE STRING,
MAINTORDERNUMBEROFOPERATIONS TYPE STRING,
MAINWORKCENTERPLANT TYPE STRING,
MAINWORKCENTERPLANTNAME TYPE STRING,
MAINTENANCEPLANNERGROUP TYPE STRING,
MAINTENANCEPLANNERGROUPNAME TYPE STRING,
MAINTENANCEPLANNINGPLANT TYPE STRING,
MAINTENANCEPLANNINGPLANTNAME TYPE STRING,
MAINTORDPERSONRESPONSIBLE_H TYPE STRING,
MAINTORDPERSONRESPONSIBLE TYPE STRING,
PERSONRESPONSIBLENAME TYPE STRING,
CREATIONDATE TYPE STRING,
CREATEDBYUSER TYPE STRING,
CREATEDBYUSERDESCRIPTION TYPE STRING,
MATERIAL TYPE STRING,
MATERIALNAME TYPE STRING,
SERIALNUMBER TYPE STRING,
ASSEMBLY TYPE STRING,
ASSEMBLYNAME TYPE STRING,
OPERATIONSYSTEMCONDITION TYPE STRING,
OPERATIONSYSTEMCONDITIONTEXT TYPE STRING,
MAINTENANCEORDERPLANNINGCODE TYPE STRING,
MAINTORDERPLANNINGCODENAME TYPE STRING,
MAINTENANCEREVISION TYPE STRING,
MAINTENANCEACTIVITYTYPE TYPE STRING,
MAINTENANCEACTIVITYTYPENAME TYPE STRING,
MAINTENANCEPLANT TYPE STRING,
PLANTNAME TYPE STRING,
ASSETLOCATION TYPE STRING,
ASSETLOCATIONNAME TYPE STRING,
ASSETROOM TYPE STRING,
PLANTSECTION TYPE STRING,
PLANTSECTIONPERSONRESPNAME TYPE STRING,
PLANTSECTIONPERSONRESPPHONE TYPE STRING,
WORKCENTER TYPE STRING,
WORKCENTERTEXT TYPE STRING,
ABCINDICATOR TYPE STRING,
ABCINDICATORDESC TYPE STRING,
SORTFIELD TYPE STRING,
COMPANYCODE TYPE STRING,
COMPANYCODENAME TYPE STRING,
BUSINESSAREA TYPE STRING,
BUSINESSAREANAME TYPE STRING,
CONTROLLINGAREA TYPE STRING,
CONTROLLINGAREANAME TYPE STRING,
RESPONSIBLECOSTCENTER TYPE STRING,
COSTCENTERNAME TYPE STRING,
PROFITCENTER TYPE STRING,
PROFITCENTERNAME TYPE STRING,
CONTROLLINGOBJECTCLASS TYPE STRING,
CONTROLLINGOBJECTCLASSNAME TYPE STRING,
ORDERPROCESSINGGROUP TYPE STRING,
ORDERPROCESSINGGROUPNAME TYPE STRING,
PROJECT TYPE STRING,
PROJECTDESCRIPTION TYPE STRING,
WBSELEMENT TYPE STRING,
WBSDESCRIPTION TYPE STRING,
LOCACCTASSGMTCOMPANYCODE TYPE STRING,
LOCACCTASSGMTCOMPANYCODENAME TYPE STRING,
LOCACCTASSGMTBUSINESSAREA TYPE STRING,
LOCACCTASSGMTBUSINESSAREADESC TYPE STRING,
LOCACCTASSGMTCONTROLLINGAREA TYPE STRING,
LOCACCTASSGMTCTRLGAREADESC TYPE STRING,
LOCACCTASSGMTCOSTCENTER TYPE STRING,
LOCACCTASSGMTCOSTCENTERDESC TYPE STRING,
CITYNAME TYPE STRING,
SETTLEMENTORDER TYPE STRING,
MASTERFIXEDASSET TYPE STRING,
MASTERFIXEDASSETDESCRIPTION TYPE STRING,
FIXEDASSET TYPE STRING,
LOCACCTASSGMTWBSELEMENT TYPE STRING,
LOCACCTASSGMTWBSELEMENTDESC TYPE STRING,
TECHNICALOBJECT TYPE STRING,
FUNCTIONALLOCATION TYPE STRING,
MAINTPRIORITYTYPE TYPE STRING,
WBSELEMENTINTERNALID TYPE STRING,
PLANT TYPE STRING,
MAINTORDERRESPPARTNERFUNCTION TYPE STRING,
REFTIMEFORORDERCOMPLETION TYPE STRING,
MAINTENANCEORDERTHUMBNAILURL TYPE STRING,
MAINTORDERISFINALLYCONFIRMED TYPE STRING,
USERSTATUS TYPE STRING,
STATUSNAME TYPE STRING,
STATUSPROFILE TYPE STRING,
MAINTORDERHASOPENRESERVATIONS TYPE STRING,
MAINTORDHASOPENPURCHASEORDERS TYPE STRING,
MAINTORDHASOPENSERVICES TYPE STRING,
MAINTORDCOSTCRITICALITY TYPE STRING,
MAINTORDTOTALCOST TYPE STRING,
CURRENCY TYPE STRING,
WORKCENTERINTERNALID TYPE STRING,
MAINTORDPROCESSPHASECODE TYPE STRING,
MAINTORDPROCESSSUBPHASECODE TYPE STRING,
MAINTORDTYPEHASACTVPHASEMODEL TYPE STRING,
ISCLOUDSYSTEM TYPE STRING,
COMPLETEBUSINESSANDSETNOTIFSTS TYPE STRING,
COMPLETETECHLYANDSETNOTIFSTS TYPE STRING,
DONOTEXECTORDERANDSETNOTIFSTS TYPE STRING,
RESETTECHCOMPLTNANDSETNOTIFSTS TYPE STRING,
MAINTOBJECTLOCACCTASSGMTNMBR TYPE STRING,
EQUIPMENT TYPE STRING,
FUNCTIONALLOCATIONLABELNAME TYPE STRING,
BASICSCHEDULINGTYPE TYPE STRING,
ORDISNOTSCHEDLDAUTOMATICALLY TYPE STRING,
MAINTORDERHASACTIVEWORKFLOW TYPE STRING,END OF T_EKKO_STR. DATA: WA_COBJPGMAINTORD_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_COBJPGMAINTORD_STR-MANDT sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEORDER sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDERWITHLEADINGZEROS sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEORDERDESC sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEORDERINTERNALID sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEORDERTYPE sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEORDERTYPENAME sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEPROCESSINGPHASE sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEPROCESSINGPHASEDESC sy-vline
WA_COBJPGMAINTORD_STR-MAINTPRIORITY sy-vline
WA_COBJPGMAINTORD_STR-LATESTACCEPTABLECOMPLETIONDATE sy-vline
WA_COBJPGMAINTORD_STR-MAINTPRIORITYCOLORCODE sy-vline
WA_COBJPGMAINTORD_STR-MAINTPRIORITYDESC sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCENOTIFICATION sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCENOTIFICATIONTEXT sy-vline
WA_COBJPGMAINTORD_STR-TASKLISTGROUP sy-vline
WA_COBJPGMAINTORD_STR-TASKLISTTYPE sy-vline
WA_COBJPGMAINTORD_STR-TASKLISTGROUPCOUNTER sy-vline
WA_COBJPGMAINTORD_STR-TASKLISTKEYDATE sy-vline
WA_COBJPGMAINTORD_STR-TASKLIST sy-vline
WA_COBJPGMAINTORD_STR-TASKLISTDESC sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEPLAN sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEPLANDESC sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEITEM sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEITEMDESCRIPTION sy-vline
WA_COBJPGMAINTORD_STR-TECHNICALOBJECTLABEL sy-vline
WA_COBJPGMAINTORD_STR-TECHNICALOBJECTDESCRIPTION sy-vline
WA_COBJPGMAINTORD_STR-FUNCTIONALLOCATIONNAME sy-vline
WA_COBJPGMAINTORD_STR-EQUIPMENTNAME sy-vline
WA_COBJPGMAINTORD_STR-TECHOBJISEQUIPORFUNCNLLOC sy-vline
WA_COBJPGMAINTORD_STR-TECHOBJISEQUIPORFUNCNLLOCDESC sy-vline
WA_COBJPGMAINTORD_STR-ORDERHASLONGTEXT sy-vline
WA_COBJPGMAINTORD_STR-MAINWORKCENTER sy-vline
WA_COBJPGMAINTORD_STR-MAINWORKCENTERTEXT sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDBASICSTARTDATE sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDBASICENDDATE sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDSCHEDBASICSTARTDATE sy-vline
WA_COBJPGMAINTORD_STR-SCHEDULEDBASICENDDATE sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDSCHEDBASICSTARTTIME sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDERREFERENCEDATE sy-vline
WA_COBJPGMAINTORD_STR-CONCATENATEDACTIVESYSTSTSNAME sy-vline
WA_COBJPGMAINTORD_STR-CONCATENATEDACTIVEUSERSTSNAME sy-vline
WA_COBJPGMAINTORD_STR-CONCATENATEDORDERPHASECTRLTEXT sy-vline
WA_COBJPGMAINTORD_STR-MAINTOBJNMBROFPHASECTRLCODES sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDHASOPENMAINWORK sy-vline
WA_COBJPGMAINTORD_STR-ORDERNMBROFATTACHEDDOCUMENTS sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDERNUMBEROFOPERATIONS sy-vline
WA_COBJPGMAINTORD_STR-MAINWORKCENTERPLANT sy-vline
WA_COBJPGMAINTORD_STR-MAINWORKCENTERPLANTNAME sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEPLANNERGROUP sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEPLANNERGROUPNAME sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEPLANNINGPLANT sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEPLANNINGPLANTNAME sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDPERSONRESPONSIBLE_H sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDPERSONRESPONSIBLE sy-vline
WA_COBJPGMAINTORD_STR-PERSONRESPONSIBLENAME sy-vline
WA_COBJPGMAINTORD_STR-CREATIONDATE sy-vline
WA_COBJPGMAINTORD_STR-CREATEDBYUSER sy-vline
WA_COBJPGMAINTORD_STR-CREATEDBYUSERDESCRIPTION sy-vline
WA_COBJPGMAINTORD_STR-MATERIAL sy-vline
WA_COBJPGMAINTORD_STR-MATERIALNAME sy-vline
WA_COBJPGMAINTORD_STR-SERIALNUMBER sy-vline
WA_COBJPGMAINTORD_STR-ASSEMBLY sy-vline
WA_COBJPGMAINTORD_STR-ASSEMBLYNAME sy-vline
WA_COBJPGMAINTORD_STR-OPERATIONSYSTEMCONDITION sy-vline
WA_COBJPGMAINTORD_STR-OPERATIONSYSTEMCONDITIONTEXT sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEORDERPLANNINGCODE sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDERPLANNINGCODENAME sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEREVISION sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEACTIVITYTYPE sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEACTIVITYTYPENAME sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEPLANT sy-vline
WA_COBJPGMAINTORD_STR-PLANTNAME sy-vline
WA_COBJPGMAINTORD_STR-ASSETLOCATION sy-vline
WA_COBJPGMAINTORD_STR-ASSETLOCATIONNAME sy-vline
WA_COBJPGMAINTORD_STR-ASSETROOM sy-vline
WA_COBJPGMAINTORD_STR-PLANTSECTION sy-vline
WA_COBJPGMAINTORD_STR-PLANTSECTIONPERSONRESPNAME sy-vline
WA_COBJPGMAINTORD_STR-PLANTSECTIONPERSONRESPPHONE sy-vline
WA_COBJPGMAINTORD_STR-WORKCENTER sy-vline
WA_COBJPGMAINTORD_STR-WORKCENTERTEXT sy-vline
WA_COBJPGMAINTORD_STR-ABCINDICATOR sy-vline
WA_COBJPGMAINTORD_STR-ABCINDICATORDESC sy-vline
WA_COBJPGMAINTORD_STR-SORTFIELD sy-vline
WA_COBJPGMAINTORD_STR-COMPANYCODE sy-vline
WA_COBJPGMAINTORD_STR-COMPANYCODENAME sy-vline
WA_COBJPGMAINTORD_STR-BUSINESSAREA sy-vline
WA_COBJPGMAINTORD_STR-BUSINESSAREANAME sy-vline
WA_COBJPGMAINTORD_STR-CONTROLLINGAREA sy-vline
WA_COBJPGMAINTORD_STR-CONTROLLINGAREANAME sy-vline
WA_COBJPGMAINTORD_STR-RESPONSIBLECOSTCENTER sy-vline
WA_COBJPGMAINTORD_STR-COSTCENTERNAME sy-vline
WA_COBJPGMAINTORD_STR-PROFITCENTER sy-vline
WA_COBJPGMAINTORD_STR-PROFITCENTERNAME sy-vline
WA_COBJPGMAINTORD_STR-CONTROLLINGOBJECTCLASS sy-vline
WA_COBJPGMAINTORD_STR-CONTROLLINGOBJECTCLASSNAME sy-vline
WA_COBJPGMAINTORD_STR-ORDERPROCESSINGGROUP sy-vline
WA_COBJPGMAINTORD_STR-ORDERPROCESSINGGROUPNAME sy-vline
WA_COBJPGMAINTORD_STR-PROJECT sy-vline
WA_COBJPGMAINTORD_STR-PROJECTDESCRIPTION sy-vline
WA_COBJPGMAINTORD_STR-WBSELEMENT sy-vline
WA_COBJPGMAINTORD_STR-WBSDESCRIPTION sy-vline
WA_COBJPGMAINTORD_STR-LOCACCTASSGMTCOMPANYCODE sy-vline
WA_COBJPGMAINTORD_STR-LOCACCTASSGMTCOMPANYCODENAME sy-vline
WA_COBJPGMAINTORD_STR-LOCACCTASSGMTBUSINESSAREA sy-vline
WA_COBJPGMAINTORD_STR-LOCACCTASSGMTBUSINESSAREADESC sy-vline
WA_COBJPGMAINTORD_STR-LOCACCTASSGMTCONTROLLINGAREA sy-vline
WA_COBJPGMAINTORD_STR-LOCACCTASSGMTCTRLGAREADESC sy-vline
WA_COBJPGMAINTORD_STR-LOCACCTASSGMTCOSTCENTER sy-vline
WA_COBJPGMAINTORD_STR-LOCACCTASSGMTCOSTCENTERDESC sy-vline
WA_COBJPGMAINTORD_STR-CITYNAME sy-vline
WA_COBJPGMAINTORD_STR-SETTLEMENTORDER sy-vline
WA_COBJPGMAINTORD_STR-MASTERFIXEDASSET sy-vline
WA_COBJPGMAINTORD_STR-MASTERFIXEDASSETDESCRIPTION sy-vline
WA_COBJPGMAINTORD_STR-FIXEDASSET sy-vline
WA_COBJPGMAINTORD_STR-LOCACCTASSGMTWBSELEMENT sy-vline
WA_COBJPGMAINTORD_STR-LOCACCTASSGMTWBSELEMENTDESC sy-vline
WA_COBJPGMAINTORD_STR-TECHNICALOBJECT sy-vline
WA_COBJPGMAINTORD_STR-FUNCTIONALLOCATION sy-vline
WA_COBJPGMAINTORD_STR-MAINTPRIORITYTYPE sy-vline
WA_COBJPGMAINTORD_STR-WBSELEMENTINTERNALID sy-vline
WA_COBJPGMAINTORD_STR-PLANT sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDERRESPPARTNERFUNCTION sy-vline
WA_COBJPGMAINTORD_STR-REFTIMEFORORDERCOMPLETION sy-vline
WA_COBJPGMAINTORD_STR-MAINTENANCEORDERTHUMBNAILURL sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDERISFINALLYCONFIRMED sy-vline
WA_COBJPGMAINTORD_STR-USERSTATUS sy-vline
WA_COBJPGMAINTORD_STR-STATUSNAME sy-vline
WA_COBJPGMAINTORD_STR-STATUSPROFILE sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDERHASOPENRESERVATIONS sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDHASOPENPURCHASEORDERS sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDHASOPENSERVICES sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDCOSTCRITICALITY sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDTOTALCOST sy-vline
WA_COBJPGMAINTORD_STR-CURRENCY sy-vline
WA_COBJPGMAINTORD_STR-WORKCENTERINTERNALID sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDPROCESSPHASECODE sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDPROCESSSUBPHASECODE sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDTYPEHASACTVPHASEMODEL sy-vline
WA_COBJPGMAINTORD_STR-ISCLOUDSYSTEM sy-vline
WA_COBJPGMAINTORD_STR-COMPLETEBUSINESSANDSETNOTIFSTS sy-vline
WA_COBJPGMAINTORD_STR-COMPLETETECHLYANDSETNOTIFSTS sy-vline
WA_COBJPGMAINTORD_STR-DONOTEXECTORDERANDSETNOTIFSTS sy-vline
WA_COBJPGMAINTORD_STR-RESETTECHCOMPLTNANDSETNOTIFSTS sy-vline
WA_COBJPGMAINTORD_STR-MAINTOBJECTLOCACCTASSGMTNMBR sy-vline
WA_COBJPGMAINTORD_STR-EQUIPMENT sy-vline
WA_COBJPGMAINTORD_STR-FUNCTIONALLOCATIONLABELNAME sy-vline
WA_COBJPGMAINTORD_STR-BASICSCHEDULINGTYPE sy-vline
WA_COBJPGMAINTORD_STR-ORDISNOTSCHEDLDAUTOMATICALLY sy-vline
WA_COBJPGMAINTORD_STR-MAINTORDERHASACTIVEWORKFLOW sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.