I_WorkPermitCube

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_WorkPermitCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IWRKPMTCUBE

CREATE VIEW I_WorkPermitCube AS
SELECT
  WorkPermit,
  WorkPermitType,
  _WorkPermitTypeText.WorkPermitTypeDescription AS WorkPermitTypeDescription,
  MaintenancePlanningPlant,
  _PermitPlanningPlant.PlantName AS MaintenancePlanningPlantName,
  MaintenancePlannerGroup,
  TechObjAuthorizationGroup,
  FunctionalLocation,
  Equipment,
  _MainWorkCenter.WorkCenter AS WorkCenter,
  _Text.WorkCenterText AS WorkCenterText,
  OperationWorkCenterInternalID,
  ObjectTypeCode,
  WrkPermitValidFrmDate,
  WrkPermitValidToDate,
  WorkPermitInternalID,
  WorkPermitProcessingStatus,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment.MaintenancePlant when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment.MaintenancePlant end as MaintenancePlant AS MaintenancePlantendasMaintenancePlant,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment.AssetLocation when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment.AssetLocation end as AssetLocation AS AssetLocationendasAssetLocation,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment._Location.LocationName when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment._Location.LocationName end as LocationName AS LocationNameendasLocationName,
  cast( _IssueHist.WorkPermitIssuedTo as eams_person_responsible) AS MaintOrdPersonResponsible,
  _IssueHist._PersonWorkAgreement.PersonFullName AS PersonFullName,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment.PlantSection when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment.PlantSection end as PlantSection AS PlantSectionendasPlantSection,
  NumberOfOpenWorkPermits,
  _WrkPmtProcessingStatusText.WorkPermitProcessingStatusText AS WorkPermitProcessingStatusText
FROM P_WorkPermitCube
LEFT OUTER JOIN I_WorkPermitType AS _WorkPermitType ON WorkPermitType = _WorkPermitType.WorkPermitType AND MaintenancePlanningPlant = _WorkPermitType.MaintenancePlanningPlant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PermitPlanningPlant ON MaintenancePlanningPlant = _PermitPlanningPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlannerGroup AS _MaintenancePlannerGroup ON MaintenancePlannerGroup = _MaintenancePlannerGroup.MaintenancePlannerGroup AND MaintenancePlanningPlant = _MaintenancePlannerGroup.MaintenancePlanningPlant  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _MainWorkCenter ON OperationWorkCenterInternalID = _MainWorkCenter.WorkCenterInternalID AND ObjectTypeCode = _MainWorkCenter.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON Equipment = _EquipmentText.Equipment  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON FunctionalLocation = _FunctionalLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON FunctionalLocation = _FunctionalLocationText.FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObjectVH ON _TechnicalObjectVH.MaintenancePlanningPlant = MaintenancePlanningPlant AND ( FunctionalLocation = _TechnicalObjectVH.TechnicalObject )  -- association [1..1]
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObjectEquipVH ON _TechnicalObjectEquipVH.MaintenancePlanningPlant = MaintenancePlanningPlant AND ( Equipment = _TechnicalObjectEquipVH.TechnicalObject )  -- association [1..1]
LEFT OUTER JOIN I_WorkCenterText AS _Text ON OperationWorkCenterInternalID = _Text.WorkCenterInternalID AND ObjectTypeCode = _Text.WorkCenterTypeCode AND _Text.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_WorkPermitTypeText AS _WorkPermitTypeText ON WorkPermitType = _WorkPermitTypeText.WorkPermitType AND MaintenancePlanningPlant = _WorkPermitTypeText.MaintenancePlanningPlant AND _WorkPermitTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_WrkPmtProcessingStatusText AS _WrkPmtProcessingStatusText ON _WrkPmtProcessingStatusText.WorkPermitProcessingStatus = WorkPermitProcessingStatus AND _WrkPmtProcessingStatusText.Language = $session.system_language AND _WrkPmtProcessingStatusText.Name = 'PTWDWORKPERMITPROCESSINGSTATUS'  -- association [1..1]
LEFT OUTER JOIN I_WorkPermitIssueHistory AS _IssueHist ON _IssueHist.WorkPermitInternalID = WorkPermitInternalID AND _IssueHist.WorkPermit = WorkPermit AND _IssueHist.WorkPermitReturnedTo = ''  -- association [1..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLocT AS _TechObjIsEquipOrFuncnlLocT ON _TechObjIsEquipOrFuncnlLocT.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..*]
;