I_MaintOrdToNotifAssignmentVH

DDL: I_MAINTORDTONOTIFASSIGNMENTVH Type: view_entity COMPOSITE

Maintenance Order

I_MaintOrdToNotifAssignmentVH is a Composite CDS View that provides data about "Maintenance Order" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrder) and exposes 13 fields with key field MaintenanceOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrder _MaintenanceOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_OrderStatusClosed _OrderStatusClosed _OrderStatusClosed.StatusObject = $projection.MaintenanceOrderInternalID

Annotations (12)

NameValueLevelField
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey MaintenanceOrder view
Analytics.technicalName IMOTNAVH view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.authorizationCheck #MANDATORY view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Maintenance Order view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
MaintenanceOrderDesc MaintenanceOrderDesc
MaintenanceOrderInternalID MaintenanceOrderInternalID
Equipment Equipment
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
ControllingArea ControllingArea
MaintenanceOrderType MaintenanceOrderType
MaintenancePlannerGroup MaintenancePlannerGroup
MaintenancePlanningPlant MaintenancePlanningPlant
ResponsibleCostCenter ResponsibleCostCenter
MaintOrderProcessingContext MaintOrderProcessingContext
_Equipment _Equipment
_LocationAccountAssignment _LocationAccountAssignment
@VDM.viewType: #COMPOSITE

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'MaintenanceOrder'
@Analytics.technicalName: 'IMOTNAVH'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@AccessControl.authorizationCheck: #MANDATORY

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

@EndUserText.label: 'Maintenance Order'
define view entity I_MaintOrdToNotifAssignmentVH
  as select from I_MaintenanceOrder as _MaintenanceOrder
  association [0..1] to P_OrderStatusClosed as _OrderStatusClosed on _OrderStatusClosed.StatusObject = $projection.MaintenanceOrderInternalID
{
      @Search: { defaultSearchElement: true, ranking: #HIGH }
      @ObjectModel.text.element: ['MaintenanceOrderDesc']
  key MaintenanceOrder,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8 }
      MaintenanceOrderDesc,
      @Consumption.hidden: true
      MaintenanceOrderInternalID,
      @Consumption.hidden: true
      Equipment,
      @Consumption.hidden: true
      MaintObjectLocAcctAssgmtNmbr,
      @Consumption.hidden: true
      ControllingArea,
      @Consumption.hidden: true
      MaintenanceOrderType,
      @Consumption.hidden: true
      MaintenancePlannerGroup,
      @Consumption.hidden: true
      MaintenancePlanningPlant,
      @Consumption.hidden: true
      ResponsibleCostCenter,
      @Consumption.hidden: true
      MaintOrderProcessingContext,
      @Consumption.hidden: true
      _Equipment,
      @Consumption.hidden: true
      _LocationAccountAssignment
}

where
      _OrderStatusClosed.OrderisClosed <> 'X'
  and MaintOrderProcessingContext      <> 'B'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDER",
"P_ORDERSTATUSCLOSED"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_LOCATIONACCOUNTASSIGNMENT"
],
"BASE":
[
"I_MAINTENANCEORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/