P_MaintJobMsrgPtAndDocTechObj

DDL: P_MAINTJOBMSRGPTANDDOCTECHOBJ SQL: PMAINTTECHOBJVH Type: view CONSUMPTION Package: VDM_EAM_MAINTJOB_MANAGE_MPD

Value Help for Technical Object

P_MaintJobMsrgPtAndDocTechObj is a Consumption CDS View that provides data about "Value Help for Technical Object" in SAP S/4HANA. It reads from 1 data source (I_TechnicalObject) and exposes 16 fields with key fields TechnicalObject, TechObjIsEquipOrFuncnlLoc. It has 1 association to related views. Part of development package VDM_EAM_MAINTJOB_MANAGE_MPD.

Data Sources (1)

SourceAliasJoin Type
I_TechnicalObject I_TechnicalObject from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Equipment _EquipmentSearch $projection.EquipmentWithLeadingZeros = _EquipmentSearch.Equipment

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PMAINTTECHOBJVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Value Help for Technical Object view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Consumption.ranked true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY TechnicalObject I_TechnicalObject TechnicalObject
KEY TechObjIsEquipOrFuncnlLoc I_TechnicalObject TechObjIsEquipOrFuncnlLoc
EquipmentWithLeadingZeros I_TechnicalObject Equipment
FunctionalLocationLabelName
TechnicalObjectDescription
Equipment _EquipmentSearch Equipment
MaintenancePlanningPlant
MaintenancePlannerGroup I_TechnicalObject MaintenancePlannerGroup
AuthorizationGroup I_TechnicalObject AuthorizationGroup
TechnicalObjectCategory TechnicalObjectCategory
TechnicalObjectType TechnicalObjectType
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
MaintenancePlant _LocationAccountAssignment MaintenancePlant
CostCenter _LocationAccountAssignment CostCenter
ControllingArea _LocationAccountAssignment ControllingArea
TechObjInstallationLocation
@AbapCatalog.sqlViewName: 'PMAINTTECHOBJVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private:true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck:#MANDATORY
@EndUserText.label: 'Value Help for Technical Object'

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Consumption.ranked: true
//This view is created with reference to C_TechnicalObjectVH, for MP section to use MaintenancePlanningPlant field which is not available for consumption from UI in C_TechnicalObjectVH.

define view P_MaintJobMsrgPtAndDocTechObj
  as select from I_TechnicalObject
  association [0..1] to I_Equipment as _EquipmentSearch on $projection.EquipmentWithLeadingZeros = _EquipmentSearch.Equipment
{
            @UI.hidden: true
  key       I_TechnicalObject.TechnicalObject,
            @UI.hidden: true
  key       I_TechnicalObject.TechObjIsEquipOrFuncnlLoc,
            @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,
            @Consumption.hidden: true
            I_TechnicalObject.Equipment                                                          as EquipmentWithLeadingZeros,
            @Consumption.hidden: true
            I_TechnicalObject._FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName,
            @Consumption.filter.hidden: true
            I_TechnicalObject._TechnicalObjectText[1: Language = $session.system_language ].TechnicalObjectDescription,
            @UI.hidden: true
            @Consumption.hidden: true
            _EquipmentSearch.Equipment,
            -- DCL:Fields required for DCL
            //consumption hidden is set to false to use this field in UI for additionally binding  with the plant field In All measuring point(Measurment Point section) 

            //to filter technical object on the basis of plant associated with the maintenance order

            @UI.hidden: true
            @Consumption.hidden: false
            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,
            @UI.hidden: true
            @ObjectModel.virtualElement
            @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EAM_MALFUNC_TECHOBJ_EXIT'
            cast ( '' as eam_techobj_installation_loc )                                                             as TechObjInstallationLocation
}