P_WorkPermitCube

DDL: P_WORKPERMITCUBE SQL: PWRKPMTCUBE Type: view COMPOSITE

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 14 fields with key field WorkPermit.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkPermitBasic I_WorkPermitBasic from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PWRKPMTCUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work Permit - Cube 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 (14)

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
WorkPermitProcessingStatus WorkPermitProcessingStatus
NumberOfOpenWorkPermits 
@AbapCatalog.sqlViewName: 'PWRKPMTCUBE'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@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 P_WorkPermitCube
  as select from I_WorkPermitBasic

{

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

      WorkPermitProcessingStatus,

      cast(1 as nmbr_of_opn_wrk_pmts) as NumberOfOpenWorkPermits

}
where
  WrkPmtMgmtObjSubType = 'P'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKPERMITBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More