C_MalfunctionReportMyWorkItems

DDL: C_MALFUNCTIONREPORTMYWORKITEMS SQL: CMFREPMYWORKIT Type: view CONSUMPTION Package: ODATA_EAM_MALFUNCTION_MANAGE

Repair Malfunction: My work items

C_MalfunctionReportMyWorkItems is a Consumption CDS View that provides data about "Repair Malfunction: My work items" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderOperAndSubOper) and exposes 5 fields with key fields MaintenanceOrder, MaintenanceOrderOperation, MaintenanceOrderSubOperation. It has 1 association to related views. Part of development package ODATA_EAM_MALFUNCTION_MANAGE.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderOperAndSubOper I_MaintOrderOperAndSubOper from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Employment _Employment _Employment.EmploymentInternalID = $projection.OperationPersonResponsible

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.sqlViewName CMFREPMYWORKIT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Repair Malfunction: My work items view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder I_MaintOrderOperAndSubOper MaintenanceOrder
KEY MaintenanceOrderOperation I_MaintOrderOperAndSubOper MaintenanceOrderOperation
KEY MaintenanceOrderSubOperation I_MaintOrderOperAndSubOper MaintenanceOrderSubOperation
MaintOrderOperationInternalID I_MaintOrderOperAndSubOper MaintOrderOperationInternalID
OperationPersonResponsible I_MaintOrderOperAndSubOper OperationPersonResponsible 
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL

@AbapCatalog.sqlViewName: 'CMFREPMYWORKIT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA') 
@EndUserText.label: 'Repair Malfunction: My work items'

define view C_MalfunctionReportMyWorkItems
  as select from I_MaintOrderOperAndSubOper
  association [0..1] to I_Employment as _Employment on _Employment.EmploymentInternalID = $projection.OperationPersonResponsible
{
  key I_MaintOrderOperAndSubOper.MaintenanceOrder,
  key I_MaintOrderOperAndSubOper.MaintenanceOrderOperation,
  key I_MaintOrderOperAndSubOper.MaintenanceOrderSubOperation,

      I_MaintOrderOperAndSubOper.MaintOrderOperationInternalID,

      I_MaintOrderOperAndSubOper.OperationPersonResponsible
}
where
  _Employment._Employee.UserID = $session.user

Learn More