C_MaintOrderForSafetyInsights

DDL: C_MAINTORDERFORSAFETYINSIGHTS SQL: CMAINTORDRFORSI Type: view CONSUMPTION

Maintenance Orders for Safety Insights

C_MaintOrderForSafetyInsights is a Consumption CDS View that provides data about "Maintenance Orders for Safety Insights" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceOrder) and exposes 15 fields with key field MaintenanceOrder. It has 1 association to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceOrder I_MaintenanceOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MaintenanceActivityTypeText _MaintenanceActivityTypeText $projection.MaintenanceActivityType = _MaintenanceActivityTypeText.MaintenanceActivityType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMAINTORDRFORSI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Orders for Safety Insights view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey MaintenanceOrder view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
Equipment Equipment
MaintenanceOrderDesc MaintenanceOrderDesc
MaintOrdBasicStartDate MaintOrdBasicStartDate
MaintOrdBasicEndDate MaintOrdBasicEndDate
MaintenanceActivityType MaintenanceActivityType
_MaintenanceActivityTypeText _MaintenanceActivityTypeText
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
MaintenancePlanningPlant MaintenancePlanningPlant
MaintenanceOrderType MaintenanceOrderType
MaintenancePlannerGroup MaintenancePlannerGroup
ControllingArea ControllingArea
ResponsibleCostCenter ResponsibleCostCenter
_Equipment _Equipment
_LocationAccountAssignment _LocationAccountAssignment 
@AbapCatalog.sqlViewName: 'CMAINTORDRFORSI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:['_LocationAccountAssignment']
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA') 
@EndUserText.label: 'Maintenance Orders for Safety Insights'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
  representativeKey: 'MaintenanceOrder',
  usageType:{ serviceQuality: #D,         
              sizeCategory:   #L,         
              dataClass:      #TRANSACTIONAL }
}
define view C_MaintOrderForSafetyInsights as select from I_MaintenanceOrder 
  association [0..*] to I_MaintenanceActivityTypeText as _MaintenanceActivityTypeText on $projection.MaintenanceActivityType = _MaintenanceActivityTypeText.MaintenanceActivityType
{
  key MaintenanceOrder,
      //--[ GENERATED:012:29JlHNUf7jY4oS0yl5vKTW

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_EquipmentStdVH',
                     element: 'Equipment' }
        }]
      // ]--GENERATED

  Equipment,
  MaintenanceOrderDesc,
  MaintOrdBasicStartDate,
  MaintOrdBasicEndDate,
  @ObjectModel.text.association: '_MaintenanceActivityTypeText'
  MaintenanceActivityType,
  _MaintenanceActivityTypeText,
  
  // attributes and assosiations required for authority check on maintnance order

  @Consumption.hidden: true 
  MaintObjectLocAcctAssgmtNmbr,
  @Consumption.hidden: true 
  MaintenancePlanningPlant, 
  @Consumption.hidden: true 
  MaintenanceOrderType,
  @Consumption.hidden: true 
  MaintenancePlannerGroup,
  @Consumption.hidden: true 
  ControllingArea, 
  @Consumption.hidden: true 
  ResponsibleCostCenter,
  @Consumption.hidden: true 
  _Equipment,
  @Consumption.hidden: true 
  _LocationAccountAssignment
  
} where Equipment != ''
  and MaintOrdBasicEndDate >= $session.system_date //consider current maintenance orders only

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDER"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEACTIVITYTYPETEXT"
],
"BASE":
[
"I_MAINTENANCEORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More