ABAP Select data from SAP table CTTTUTRACKTOOLTP 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 CTTTUTRACKTOOLTP 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 CTTTUTRACKTOOLTP. 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 CTTTUTRACKTOOLTP 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_CTTTUTRACKTOOLTP TYPE STANDARD TABLE OF CTTTUTRACKTOOLTP,
      WA_CTTTUTRACKTOOLTP TYPE CTTTUTRACKTOOLTP,
      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: <CTTTUTRACKTOOLTP> TYPE CTTTUTRACKTOOLTP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CTTTUTRACKTOOLTP
*  INTO TABLE @DATA(IT_CTTTUTRACKTOOLTP2).
*--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_CTTTUTRACKTOOLTP INDEX 1 INTO DATA(WA_CTTTUTRACKTOOLTP2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_CTTTUTRACKTOOLTP ASSIGNING <CTTTUTRACKTOOLTP>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<CTTTUTRACKTOOLTP>-MANDT = 1.
<CTTTUTRACKTOOLTP>-EQUIPMENT = 1.
<CTTTUTRACKTOOLTP>-MATERIAL = 1.
<CTTTUTRACKTOOLTP>-EQUIPMENTNAME = 1.
<CTTTUTRACKTOOLTP>-MATERIALNAME = 1.
ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CTTTUTRACKTOOLTP-SERIALNUMBER, sy-vline,
WA_CTTTUTRACKTOOLTP-UNIQUEITEMIDENTIFIER, sy-vline,
WA_CTTTUTRACKTOOLTP-PLANT, sy-vline,
WA_CTTTUTRACKTOOLTP-PLANTNAME, sy-vline,
WA_CTTTUTRACKTOOLTP-MAINTENANCEPLANT, sy-vline,
WA_CTTTUTRACKTOOLTP-MAINTENANCEPLANTNAME, sy-vline.
ENDLOOP. *Add any further fields from structure WA_CTTTUTRACKTOOLTP 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_CTTTUTRACKTOOLTP 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_CTTTUTRACKTOOLTP INTO WA_CTTTUTRACKTOOLTP. *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 EQUIPMENT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CTTTUTRACKTOOLTP-EQUIPMENT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CTTTUTRACKTOOLTP-EQUIPMENT.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit NUMCV, internal->external for field OPERATION CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_CTTTUTRACKTOOLTP-OPERATION IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CTTTUTRACKTOOLTP-OPERATION.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field GROSSWEIGHTUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CTTTUTRACKTOOLTP-GROSSWEIGHTUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CTTTUTRACKTOOLTP-GROSSWEIGHTUNIT.
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_CTTTUTRACKTOOLTP_STR,
MANDT TYPE STRING,
EQUIPMENT TYPE STRING,
MATERIAL TYPE STRING,
EQUIPMENTNAME TYPE STRING,
MATERIALNAME TYPE STRING,
SERIALNUMBER TYPE STRING,
UNIQUEITEMIDENTIFIER TYPE STRING,
PLANT TYPE STRING,
PLANTNAME TYPE STRING,
MAINTENANCEPLANT TYPE STRING,
MAINTENANCEPLANTNAME TYPE STRING,
STORAGELOCATION TYPE STRING,
STORAGELOCATIONNAME TYPE STRING,
CONCATENATEDACTIVESYSTSTSNAME TYPE STRING,
EQUIPMENTCLAIMEDBYUSER TYPE STRING,
USERDESCRIPTION TYPE STRING,
EQUIPMENTCLAIMTYPE TYPE STRING,
EQUIPMENTCLAIMTYPENAME TYPE STRING,
EQUIPMENTHISTORYDOCUMENT TYPE STRING,
EQUIPMENTCLAIMEDFORTEXT TYPE STRING,
PERSONFULLNAME TYPE STRING,
ORDERID TYPE STRING,
OPERATION TYPE STRING,
OPACTYNTWKELEMENTEXTERNALID TYPE STRING,
OPERATIONACTIVITYNAME TYPE STRING,
WORKCENTER TYPE STRING,
WORKCENTERTEXT TYPE STRING,
NMBROFOBJECTSCLAIMINGEQUIPMENT TYPE STRING,
EQUIPCLAIMDURATIONINSECONDS TYPE STRING,
EQUIPMENTCLAIMDURATIONTEXT TYPE STRING,
EQUIPLASTCLAIMDATETIME TYPE STRING,
EQUIPLASTUNCLAIMDATETIME TYPE STRING,
WORKCENTERINTERNALID TYPE STRING,
EQUIPMENTCATEGORY TYPE STRING,
MAINTOBJECTINTERNALID TYPE STRING,
EQUIPMENTCLAIMISAVAILABLE TYPE STRING,
EQUIPMENTISCLAIMED TYPE STRING,
EQUIPMENTISONHOLD TYPE STRING,
CRITICALITY TYPE STRING,
TECHOBJISEQUIPORFUNCNLLOC TYPE STRING,
BUSINESSPARTNER TYPE STRING,
TECHNICALOBJECT TYPE STRING,
TECHNICALOBJECTCATEGORY TYPE STRING,
TECHNICALOBJECTCATEGORYDESC TYPE STRING,
ASSETMANUFACTURERNAME TYPE STRING,
CONCATENATEDACTIVEUSERSTSNAME TYPE STRING,
MANUFACTURERPARTTYPENAME TYPE STRING,
MANUFACTURERPARTNMBR TYPE STRING,
MANUFACTURERSERIALNUMBER TYPE STRING,
PLANTSECTION TYPE STRING,
PLANTSECTIONPERSONRESPNAME TYPE STRING,
PLANTSECTIONPERSONRESPPHONE TYPE STRING,
ASSETLOCATION TYPE STRING,
LOCATIONNAME TYPE STRING,
ASSETROOM TYPE STRING,
ABCINDICATOR TYPE STRING,
ABCINDICATORDESC TYPE STRING,
POSTALCODE TYPE STRING,
CITYNAME TYPE STRING,
SUPERIORTECHNICALOBJECTLABEL TYPE STRING,
SUPERIORTECHNICALOBJECTNAME TYPE STRING,
SUPERIOROBJISEQUIPORFUNCNLLOC TYPE STRING,
TECHNICALOBJECTSORTCODE TYPE STRING,
MAINTENANCEPLANNINGPLANT TYPE STRING,
MAINTENANCEPLANNINGPLANTNAME TYPE STRING,
MAINTENANCEPLANNERGROUP TYPE STRING,
MAINTENANCEPLANNERGROUPNAME TYPE STRING,
MAINWORKCENTER TYPE STRING,
MAINWORKCENTERDESCRIPTION TYPE STRING,
MAINWORKCENTERPLANT TYPE STRING,
MAINWORKCENTERPLANTNAME TYPE STRING,
COMPANYCODE TYPE STRING,
COMPANYCODENAME TYPE STRING,
BUSINESSAREA TYPE STRING,
BUSINESSAREANAME TYPE STRING,
MASTERFIXEDASSET TYPE STRING,
MASTERFIXEDASSETDESCRIPTION TYPE STRING,
FIXEDASSET TYPE STRING,
COSTCENTER TYPE STRING,
COSTCENTERNAME TYPE STRING,
CONTROLLINGAREA TYPE STRING,
CONTROLLINGAREANAME TYPE STRING,
WBSELEMENT TYPE STRING,
WBSDESCRIPTION TYPE STRING,
STANDINGORDERNUMBER TYPE STRING,
STANDINGORDERDESC TYPE STRING,
SETTLEMENTORDER TYPE STRING,
SETTLEMENTORDERDESC TYPE STRING,
CREATEDBYUSER TYPE STRING,
CREATIONDATE TYPE STRING,
LASTCHANGEDBYUSER TYPE STRING,
LASTCHANGEDATE TYPE STRING,
TECHNICALOBJECTHASLONGTEXT TYPE STRING,
INVENTORYNUMBER TYPE STRING,
GROSSWEIGHT TYPE STRING,
GROSSWEIGHTUNIT TYPE STRING,
SIZEORDIMENSIONTEXT TYPE STRING,
MAINTOBJECTFREEDEFINEDATTRIB TYPE STRING,
SALESORGANIZATION TYPE STRING,
DISTRIBUTIONCHANNEL TYPE STRING,
DIVISION TYPE STRING,
SALESOFFICE TYPE STRING,
SALESGROUP TYPE STRING,
AUTHORIZATIONGROUP TYPE STRING,END OF T_EKKO_STR. DATA: WA_CTTTUTRACKTOOLTP_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_CTTTUTRACKTOOLTP_STR-MANDT sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENT sy-vline
WA_CTTTUTRACKTOOLTP_STR-MATERIAL sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-MATERIALNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-SERIALNUMBER sy-vline
WA_CTTTUTRACKTOOLTP_STR-UNIQUEITEMIDENTIFIER sy-vline
WA_CTTTUTRACKTOOLTP_STR-PLANT sy-vline
WA_CTTTUTRACKTOOLTP_STR-PLANTNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINTENANCEPLANT sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINTENANCEPLANTNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-STORAGELOCATION sy-vline
WA_CTTTUTRACKTOOLTP_STR-STORAGELOCATIONNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-CONCATENATEDACTIVESYSTSTSNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTCLAIMEDBYUSER sy-vline
WA_CTTTUTRACKTOOLTP_STR-USERDESCRIPTION sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTCLAIMTYPE sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTCLAIMTYPENAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTHISTORYDOCUMENT sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTCLAIMEDFORTEXT sy-vline
WA_CTTTUTRACKTOOLTP_STR-PERSONFULLNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-ORDERID sy-vline
WA_CTTTUTRACKTOOLTP_STR-OPERATION sy-vline
WA_CTTTUTRACKTOOLTP_STR-OPACTYNTWKELEMENTEXTERNALID sy-vline
WA_CTTTUTRACKTOOLTP_STR-OPERATIONACTIVITYNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-WORKCENTER sy-vline
WA_CTTTUTRACKTOOLTP_STR-WORKCENTERTEXT sy-vline
WA_CTTTUTRACKTOOLTP_STR-NMBROFOBJECTSCLAIMINGEQUIPMENT sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPCLAIMDURATIONINSECONDS sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTCLAIMDURATIONTEXT sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPLASTCLAIMDATETIME sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPLASTUNCLAIMDATETIME sy-vline
WA_CTTTUTRACKTOOLTP_STR-WORKCENTERINTERNALID sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTCATEGORY sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINTOBJECTINTERNALID sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTCLAIMISAVAILABLE sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTISCLAIMED sy-vline
WA_CTTTUTRACKTOOLTP_STR-EQUIPMENTISONHOLD sy-vline
WA_CTTTUTRACKTOOLTP_STR-CRITICALITY sy-vline
WA_CTTTUTRACKTOOLTP_STR-TECHOBJISEQUIPORFUNCNLLOC sy-vline
WA_CTTTUTRACKTOOLTP_STR-BUSINESSPARTNER sy-vline
WA_CTTTUTRACKTOOLTP_STR-TECHNICALOBJECT sy-vline
WA_CTTTUTRACKTOOLTP_STR-TECHNICALOBJECTCATEGORY sy-vline
WA_CTTTUTRACKTOOLTP_STR-TECHNICALOBJECTCATEGORYDESC sy-vline
WA_CTTTUTRACKTOOLTP_STR-ASSETMANUFACTURERNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-CONCATENATEDACTIVEUSERSTSNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-MANUFACTURERPARTTYPENAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-MANUFACTURERPARTNMBR sy-vline
WA_CTTTUTRACKTOOLTP_STR-MANUFACTURERSERIALNUMBER sy-vline
WA_CTTTUTRACKTOOLTP_STR-PLANTSECTION sy-vline
WA_CTTTUTRACKTOOLTP_STR-PLANTSECTIONPERSONRESPNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-PLANTSECTIONPERSONRESPPHONE sy-vline
WA_CTTTUTRACKTOOLTP_STR-ASSETLOCATION sy-vline
WA_CTTTUTRACKTOOLTP_STR-LOCATIONNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-ASSETROOM sy-vline
WA_CTTTUTRACKTOOLTP_STR-ABCINDICATOR sy-vline
WA_CTTTUTRACKTOOLTP_STR-ABCINDICATORDESC sy-vline
WA_CTTTUTRACKTOOLTP_STR-POSTALCODE sy-vline
WA_CTTTUTRACKTOOLTP_STR-CITYNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-SUPERIORTECHNICALOBJECTLABEL sy-vline
WA_CTTTUTRACKTOOLTP_STR-SUPERIORTECHNICALOBJECTNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-SUPERIOROBJISEQUIPORFUNCNLLOC sy-vline
WA_CTTTUTRACKTOOLTP_STR-TECHNICALOBJECTSORTCODE sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINTENANCEPLANNINGPLANT sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINTENANCEPLANNINGPLANTNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINTENANCEPLANNERGROUP sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINTENANCEPLANNERGROUPNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINWORKCENTER sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINWORKCENTERDESCRIPTION sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINWORKCENTERPLANT sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINWORKCENTERPLANTNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-COMPANYCODE sy-vline
WA_CTTTUTRACKTOOLTP_STR-COMPANYCODENAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-BUSINESSAREA sy-vline
WA_CTTTUTRACKTOOLTP_STR-BUSINESSAREANAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-MASTERFIXEDASSET sy-vline
WA_CTTTUTRACKTOOLTP_STR-MASTERFIXEDASSETDESCRIPTION sy-vline
WA_CTTTUTRACKTOOLTP_STR-FIXEDASSET sy-vline
WA_CTTTUTRACKTOOLTP_STR-COSTCENTER sy-vline
WA_CTTTUTRACKTOOLTP_STR-COSTCENTERNAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-CONTROLLINGAREA sy-vline
WA_CTTTUTRACKTOOLTP_STR-CONTROLLINGAREANAME sy-vline
WA_CTTTUTRACKTOOLTP_STR-WBSELEMENT sy-vline
WA_CTTTUTRACKTOOLTP_STR-WBSDESCRIPTION sy-vline
WA_CTTTUTRACKTOOLTP_STR-STANDINGORDERNUMBER sy-vline
WA_CTTTUTRACKTOOLTP_STR-STANDINGORDERDESC sy-vline
WA_CTTTUTRACKTOOLTP_STR-SETTLEMENTORDER sy-vline
WA_CTTTUTRACKTOOLTP_STR-SETTLEMENTORDERDESC sy-vline
WA_CTTTUTRACKTOOLTP_STR-CREATEDBYUSER sy-vline
WA_CTTTUTRACKTOOLTP_STR-CREATIONDATE sy-vline
WA_CTTTUTRACKTOOLTP_STR-LASTCHANGEDBYUSER sy-vline
WA_CTTTUTRACKTOOLTP_STR-LASTCHANGEDATE sy-vline
WA_CTTTUTRACKTOOLTP_STR-TECHNICALOBJECTHASLONGTEXT sy-vline
WA_CTTTUTRACKTOOLTP_STR-INVENTORYNUMBER sy-vline
WA_CTTTUTRACKTOOLTP_STR-GROSSWEIGHT sy-vline
WA_CTTTUTRACKTOOLTP_STR-GROSSWEIGHTUNIT sy-vline
WA_CTTTUTRACKTOOLTP_STR-SIZEORDIMENSIONTEXT sy-vline
WA_CTTTUTRACKTOOLTP_STR-MAINTOBJECTFREEDEFINEDATTRIB sy-vline
WA_CTTTUTRACKTOOLTP_STR-SALESORGANIZATION sy-vline
WA_CTTTUTRACKTOOLTP_STR-DISTRIBUTIONCHANNEL sy-vline
WA_CTTTUTRACKTOOLTP_STR-DIVISION sy-vline
WA_CTTTUTRACKTOOLTP_STR-SALESOFFICE sy-vline
WA_CTTTUTRACKTOOLTP_STR-SALESGROUP sy-vline
WA_CTTTUTRACKTOOLTP_STR-AUTHORIZATIONGROUP sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.