P_WorkPermitCube

DDL: P_WORKPERMITCUBE Type: view_entity COMPOSITE Package: VDM_EAM_WCM_PERMIT_TO_WORK

Work Permit - Cube

P_WorkPermitCube is a Composite CDS View that provides data about "Work Permit - Cube" in SAP S/4HANA. It reads from 1 data source (I_WorkPermitBasic) and exposes 15 fields with key field WorkPermit. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkPermitBasic I_WorkPermitBasic from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY WorkPermit WorkPermit
WorkPermitType WorkPermitType
WrkPmtMgmtObjSubType WrkPmtMgmtObjSubType
MaintenancePlanningPlant MaintenancePlanningPlant
MaintenancePlannerGroup MaintenancePlannerGroup
TechObjAuthorizationGroup TechObjAuthorizationGroup
FunctionalLocation FunctionalLocation
Equipment Equipment
ObjectTypeCode ObjectTypeCode
OperationWorkCenterInternalID OperationWorkCenterInternalID
WrkPermitValidFrmDate WrkPermitValidFrmDate
WrkPermitValidToDate WrkPermitValidToDate
WorkPermitInternalID WorkPermitInternalID
WorkPermitProcessingStatus WorkPermitProcessingStatus
NumberOfOpenWorkPermits 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
//@EndUserText.label: 'Work Permit - Cube'

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private:true
//@Analytics.dataCategory: #CUBE

//@Analytics.internalName:#LOCAL

//@ObjectModel.supportedCapabilities:

//   [ #ANALYTICAL_PROVIDER, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ]

//@ObjectModel.modelingPattern: #ANALYTICAL_CUBE


define view entity P_WorkPermitCube
  as select from I_WorkPermitBasic

{

  key WorkPermit,
      WorkPermitType,
      WrkPmtMgmtObjSubType,
      MaintenancePlanningPlant,
      MaintenancePlannerGroup,
      TechObjAuthorizationGroup,
      FunctionalLocation,
      Equipment,
      ObjectTypeCode,
      OperationWorkCenterInternalID,
      WrkPermitValidFrmDate,
      WrkPermitValidToDate,
      WorkPermitInternalID,

      WorkPermitProcessingStatus,

      cast(1 as nmbr_of_opn_wrk_pmts) as NumberOfOpenWorkPermits

}
where
  WrkPmtMgmtObjSubType = 'P'

Learn More