C_TechnicalObjectVH

@AbapCatalog.sqlViewName: 'CTECHOBJVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Value Help for Technical Object'


@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

@Search.searchable: true
@Consumption.ranked:true

define view C_TechnicalObjectVH
  as select from I_TechnicalObject
  association [0..1] to I_Equipment as _EquipmentSearch on $projection.EquipmentWithLeadingZeros = _EquipmentSearch.Equipment
{

            @UI.hidden: true
            @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }

  key       I_TechnicalObject.TechnicalObject,
            @UI.hidden: true
  key       I_TechnicalObject.TechObjIsEquipOrFuncnlLoc,


            //            @Search: {

            //                fuzzinessThreshold: 0.9

            //              }


            @ObjectModel.filter.transformedBy: 'cl_eam_techobjlabel_exit'
            @ObjectModel.text.element: 'TechnicalObjectDescription'
//            cast( case when I_TechnicalObject.TechObjIsEquipOrFuncnlLoc = 'EAMS_FL' then // Functional Location

//                             I_TechnicalObject._FunctionalLocationLabel.FunctionalLocationLabelName

//                        else I_TechnicalObject.TechnicalObject end as eams_tech_obj_alpha_conv ) as TechnicalObjectLabel,


//            cast (case when I_TechnicalObject.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI' // Equipment

//                       then cast ( I_TechnicalObject.TechnicalObject as eams_tech_obj_alpha_conv )

//                       else I_TechnicalObject._FunctionalLocationLabel.FunctionalLocationLabelName

//                       end as eams_tec_obj )                                                                as TechnicalObjectLabel,


            cast ( case when I_TechnicalObject.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'
                        then ltrim( I_TechnicalObject.Equipment , '0' )
                        when I_TechnicalObject.TechObjIsEquipOrFuncnlLoc != 'EAMS_EQUI'
                        then I_TechnicalObject._FunctionalLocationLabel.FunctionalLocationLabelName  end as eams_tec_obj preserving type) as TechnicalObjectLabel, //Technical Object Label


            @Consumption.hidden: true
            I_TechnicalObject.Equipment                                                          as EquipmentWithLeadingZeros,

            //---------- Search scope (start) ----------


            @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }
            @Consumption.hidden: true
            I_TechnicalObject._FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName,

            @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
            @EndUserText.label: 'Technical Object Description'
            I_TechnicalObject._TechnicalObjectText[1: Language = $session.system_language ].TechnicalObjectDescription,

            @UI.hidden: true
            @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }
            @Consumption.hidden: true
            _EquipmentSearch.Equipment,
            //---------- Search scope (end) ----------


            -- DCL:
            @Consumption.hidden: true
            I_TechnicalObject.MaintenancePlanningPlant,
            @Consumption.hidden: true
            I_TechnicalObject.MaintenancePlannerGroup,
            @Consumption.hidden: true
            I_TechnicalObject.AuthorizationGroup,
            @Consumption.hidden: true
            TechnicalObjectCategory,
            @Consumption.hidden: true
            TechnicalObjectType,
            @Consumption.hidden: true
            MaintObjectLocAcctAssgmtNmbr,
            @Consumption.hidden: true
            _LocationAccountAssignment.MaintenancePlant,
            @Consumption.hidden: true
            _LocationAccountAssignment.CostCenter,
            @Consumption.hidden: true
            _LocationAccountAssignment.ControllingArea,
            @ObjectModel.virtualElement
            @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EAM_MALFUNC_TECHOBJ_EXIT'
            @UI.hidden: true
            cast ( '' as eam_techobj_installation_loc )                                          as TechObjInstallationLocation
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EQUIPMENT",
"I_FUNCLOCATIONLABELSEARCH",
"I_FUNCTIONALLOCATIONLABEL",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_TECHNICALOBJECT",
"I_TECHNICALOBJECTTEXT"
],
"ASSOCIATED":
[
"I_EQUIPMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/