R_WORKPERMITORDEROPERATIONTP

CDS View

Work Permit Order and Operations

R_WORKPERMITORDEROPERATIONTP is a CDS View in S/4HANA. Work Permit Order and Operations. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_WorkPermitOrderOperation view_entity projection CONSUMPTION WorkPermitOrderOperation
C_WorkPermitOrderOperationTP view_entity projection CONSUMPTION Work Permit Order and Operations
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Permit Order and Operations'
@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity R_WorkPermitOrderOperationTP
  as select from I_WorkPermitOrderOperation
  association to parent R_WorkPermitTP as _WorkPermit on $projection.WorkPermit = _WorkPermit.WorkPermit
  -- Extensions, do not expose as association:
  association [0..1] to E_WorkPermitOrderOperation as  _WorkPermitOrderOpExtension on  $projection.WorkPermit = _WorkPermitOrderOpExtension.WorkPermit
                                                                                   and $projection.OperationOrderRoutingNumber = _WorkPermitOrderOpExtension.OperationOrderRoutingNumber
                                                                                   and $projection.MaintOrderOperationCounter = _WorkPermitOrderOpExtension.MaintOrderOperationCounter
{
  key WorkPermit,
  key OperationOrderRoutingNumber,
  key MaintOrderOperationCounter,
      MaintenanceOrder,
      cast ('' as vdm_j_system_status_concat_t)     as ConcatenatedActiveSystStsName,
      _WorkPermit.MaintenancePlanningPlant,
      /* Associations */
      _WorkPermit,
      _MaintenanceOrderOperation

}