C_TechnicalObjectHierVH

@EndUserText.label: 'Technical Object Hierarchical Value Help'
@AbapCatalog.sqlViewName: 'CTECHOBJHIERVH'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.representativeKey: 'TechnicalObject'
@ObjectModel.semanticKey:  [ 'TechnicalObject', 'TechObjIsEquipOrFuncnlLoc' ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

define view C_TechnicalObjectHierVH
  as select from I_TechnicalObject
{

  key I_TechnicalObject.TechnicalObject,

      @ObjectModel.foreignKey.association: '_TechObjIsEquipOrFuncnlLoc'
  key I_TechnicalObject.TechObjIsEquipOrFuncnlLoc,

      I_TechnicalObject.TechnicalObjectLabel,

      I_TechnicalObject._TechnicalObjectText[1: Language = $session.system_language ].TechnicalObjectDescription,


      @Consumption.hidden: true
      I_TechnicalObject.Equipment,

      @Consumption.hidden: true
      I_TechnicalObject.FunctionalLocation,


      @ObjectModel.text.element:  [ 'ABCIndicatorDesc' ]
      I_TechnicalObject._LocationAccountAssignment.ABCIndicator,
      @Semantics.text: true
      I_TechnicalObject._LocationAccountAssignment._ABCIndicator._Text[1: Language = $session.system_language ].ABCIndicatorDesc,

      I_TechnicalObject.AuthorizationGroup,

      @ObjectModel.text.element:  [ 'BusinessAreaName' ]
      I_TechnicalObject._LocationAccountAssignment.BusinessArea,
      @Semantics.text: true
      I_TechnicalObject._LocationAccountAssignment._BusinessArea._Text[1: Language = $session.system_language ].BusinessAreaName,


      I_TechnicalObject.CatalogProfile,

      @ObjectModel.text.element:  [ 'CompanyCodeName' ]
      I_TechnicalObject._LocationAccountAssignment.CompanyCode,
      @Semantics.text: true
      I_TechnicalObject._LocationAccountAssignment._CompanyCode.CompanyCodeName,

      @ObjectModel.text.element:  [ 'ControllingAreaName' ]
      I_TechnicalObject._LocationAccountAssignment.ControllingArea,
      @Semantics.text: true
      I_TechnicalObject._LocationAccountAssignment._ControllingArea.ControllingAreaName,

      @ObjectModel.text.element:  [ 'CostCenterDescription' ]
      I_TechnicalObject._LocationAccountAssignment.CostCenter,
      @Semantics.text: true
      I_TechnicalObject._LocationAccountAssignment._CostCenterText[1: Language = $session.system_language ].CostCenterDescription,

      @ObjectModel.text.element:  [ 'WorkCenterText' ]
      I_TechnicalObject._LocationAccountAssignment._WorkCenter.WorkCenter,
      @Semantics.text: true
      I_TechnicalObject._LocationAccountAssignment._WorkCenter._Text[1: Language = $session.system_language ].WorkCenterText,


      @ObjectModel.text.element:  [ 'MainWorkCenterText' ]
      cast( I_TechnicalObject._WorkCenter.WorkCenter as gewrk )                                                                                              as MainWorkCenter,
      @Semantics.text: true
      I_TechnicalObject._WorkCenter._Text[1: Language = $session.system_language ].WorkCenterText                                                            as MainWorkCenterText,


      @ObjectModel.text.element:  [ 'MaintenancePlantName' ]
      I_TechnicalObject._LocationAccountAssignment.MaintenancePlant,
      @Semantics.text: true
      I_TechnicalObject._LocationAccountAssignment._MaintenancePlant.PlantName                                                                               as MaintenancePlantName,

      I_TechnicalObject.AssetManufacturerName,

      I_TechnicalObject.ManufacturerPartTypeName,

      I_TechnicalObject.MaintenancePlanningPlant,

      @ObjectModel.text.element:  [ 'MaintenancePlannerGroupName' ]
      I_TechnicalObject.MaintenancePlannerGroup,
      @Semantics.text: true
      I_TechnicalObject._MaintenancePlannerGroup.MaintenancePlannerGroupName,

      @ObjectModel.text.element:  [ 'PlantSectionPersonRespName' ]
      I_TechnicalObject._LocationAccountAssignment.PlantSection,
      @Semantics.text: true
      I_TechnicalObject._LocationAccountAssignment._PlantSection.PlantSectionPersonRespName,

      I_TechnicalObject._LocationAccountAssignment.AssetRoom,

      I_TechnicalObject._LocationAccountAssignment.MaintObjectFreeDefinedAttrib,

      @ObjectModel.text.element:  [ 'TechnicalObjectCategoryDesc' ]
      I_TechnicalObject.TechnicalObjectCategory,
      @Semantics.text: true
      I_TechnicalObject._TechnicalObjectCategory._Text[1: Language = $session.system_language ].TechnicalObjectCategoryDesc,

      @ObjectModel.text.element: [ 'TechnicalObjectTypeDesc' ]
      I_TechnicalObject.TechnicalObjectType,
      @Semantics.text: true
      I_TechnicalObject._TechnicalObjectType._Text[1: Language = $session.system_language ].TechnicalObjectTypeDesc,

      @Semantics.amount.currencyCode: 'Currency'
      @DefaultAggregation: #NONE
      I_TechnicalObject.AcquisitionValue,
      @Semantics.currencyCode: true
      I_TechnicalObject.Currency,

      @Semantics.user.createdBy: true
      I_TechnicalObject.CreatedByUser,
      @Semantics.businessDate.createdAt: true
      I_TechnicalObject.CreationDate,
      @Semantics.user.lastChangedBy: true
      I_TechnicalObject.LastChangedByUser,
      @Semantics.businessDate.lastChangedAt: true
      I_TechnicalObject.LastChangeDate,

      @ObjectModel.text.element:  [ 'DivisionName' ]
      I_TechnicalObject._LocationAccountAssignment.Division,
      @Semantics.text: true
      I_TechnicalObject._LocationAccountAssignment._Division._Text[1: Language = $session.system_language ].DivisionName,

      @ObjectModel.text.element:  [ 'LocationName' ]
      I_TechnicalObject._LocationAccountAssignment.AssetLocation,
      @Semantics.text: true
      I_TechnicalObject._LocationAccountAssignment._Location.LocationName,


      I_TechnicalObject._TechObjIsEquipOrFuncnlLoc._Text[1: Language = $session.system_language ].TechObjIsEquipOrFuncnlLocDesc,



      cast ( '' as abap.char( 10 ) )                                                                                                                         as DrillDownState,
      0                                                                                                                                                      as HierarchyNodeLevel,

      CONCAT(I_TechnicalObject._TechnicalObjectHierarchy.SuperiorTechnicalObject, I_TechnicalObject._TechnicalObjectHierarchy.SuperiorObjIsEquipOrFuncnlLoc) as ParentNodeUniqueID,
      case when I_TechnicalObject._TechnicalObjectHierarchy.TechnicalObject is null
      then      CONCAT(I_TechnicalObject.TechnicalObject, I_TechnicalObject.TechObjIsEquipOrFuncnlLoc)
      else      CONCAT(I_TechnicalObject._TechnicalObjectHierarchy.TechnicalObject, I_TechnicalObject._TechnicalObjectHierarchy.TechObjIsEquipOrFuncnlLoc)
      end                                                                                                                                                    as HierarchyNodeUniqueID,
      //

      //      case when I_Technicalobject._TechobjNumberOfSubobjects.NumberOfSubObjects is null

      //              or I_Technicalobject._TechobjNumberOfSubobjects.NumberOfSubObjects  = 0

      //       then 'leaf'

      //       else 'collapsed'

      //       end                                                                                                                                                   as DrillDownState,

      //

      //      case when I_Technicalobject._TechnicalObjectHierarchy.SuperiorTechnicalObject is null

      //             or I_Technicalobject._TechnicalObjectHierarchy.SuperiorTechnicalObject = ''

      //      then 0

      //      else 1

      //      end as HierarchyNodeLevel,


      I_TechnicalObject._TechObjIsEquipOrFuncnlLoc

}