R_WorkPermitTemplateTP

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 R_WorkPermitTemplateTP.
-- 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.

CREATE VIEW R_WorkPermitTemplateTP AS
SELECT
  WorkPermit,
  WorkPermitInternalID,
  MaintenancePlanningPlant,
  cast ('' as wcewapinr ) AS WorkPermitExternalNumber,
  cast ('' as abap.char(5) ) AS ValidationScenarioID,
  IsApproved,
  WorkPermitType,
  WrkPmtMgmtObjSubType,
  WrkPermitDesc,
  WorkPermitHasLongText,
  WrkPermitIsDeleted,
  MaintenancePlannerGroup,
  ObjectTypeCode,
  OperationWorkCenterInternalID,
  TechObjAuthorizationGroup,
  WrkPermitValidFrmDate,
  WrkPermitValidFrmTime,
  WrkPermitValidToDate,
  WrkPermitValidToTime,
  WorkPermitTmplID,
  FunctionalLocation,
  WrkPermitHasMaintRemark,
  WrkPermitHasOpRemark,
  Equipment,
  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._MaintenancePlant.PlantName when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment._MaintenancePlant.PlantName end as PlantName AS PlantNameendasPlantName,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment.PlantSection when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment.PlantSection end as PlantSection AS PlantSectionendasPlantSection,
  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.AssetRoom when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment.AssetRoom end as AssetRoom AS AssetRoomendasAssetRoom,
  case when _Equipment.Equipment <> '' then _TechnicalObjectEquipVH._LocationAccountAssignment._Location.LocationName when _FunctionalLocation.FunctionalLocation <> '' then _TechnicalObjectVH._LocationAccountAssignment._Location.LocationName end as LocationName AS LocationNameendasLocationName,
  _TechnicalObjectVH._LocationAccountAssignment._MaintenancePlant.PlantName AS MaintenancePlantName,
  WrkPermitHasObjectList,
  CreatedByUserName,
  CreatedByUser,
  UserDescription AS LastChangedByUserName,
  CreationDate,
  CreationTime,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  WrkPermitIsLinkdToDoc,
  StatusProfile,
  WrkPmtCnctntdActvSystStsTxt,
  WrkPmtChgStsActnEnbldVal,
  WorkPermitProcessingStatus,
  cast('' as ptwereferenceobject ) AS WorkPermitReferenceObjectType,
  cast(' ' as cv_orig preserving type ) AS IsAttachmentsEnabled,
  ValidFromDateTime,
  ValidToDateTime,
  cast( '' as aufnr ) AS MaintenanceOrder,
  WorkCenter,
  _PermitPlanningPlant.PlantName AS MaintenancePlanningPlantName,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  _WorkPermitType.WorkPermitTypeDescription AS WorkPermitTypeDescription,
  _WorkPermitLongText._LongText.PlainLongText AS WorkPermitLongText,
  cast( '' as abap.char(1)) AS PrintIsReal,
  _WorkPermitLongText.WorkPermitOperationRemarkText AS WorkPermitOperationRemarkText,
  _WorkPermitLongText.WrkPmtMaintenanceRemarkText AS WrkPmtMaintenanceRemarkText,
  _WorkPermitLongText.WorkPermitCancellationText AS WorkPermitCancellationText,
  _WorkPermitBasic.WorkPermit AS WorkPermitReference,
  _Text.WorkCenterText AS WorkCenterText,
  I_WorkPermitTemplate._CreatedByUser AS _CreatedByUser,
  _MainWorkCenter.Plant AS WorkCenterPlant,
  _WorkCenterPlant.PlantName AS MainWorkCenterPlantName
FROM I_WorkPermitTemplate
LEFT OUTER JOIN I_WorkPermitStatus AS _WorkPermitStatus ON _WorkPermitStatus.WorkPermit = WorkPermit AND _WorkPermitStatus.WorkPermitInternalID = WorkPermitInternalID  -- association [*]
LEFT OUTER JOIN I_WorkPermitLongText AS _WorkPermitLongText ON _WorkPermitLongText.WorkPermit = WorkPermit AND _WorkPermitLongText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_WorkPermitBasic AS _WorkPermitBasic ON _WorkPermitBasic.WorkPermitInternalID = WorkPermitTmplID  -- association [1..1]
LEFT OUTER JOIN I_WorkPermitReferenceObject AS _WorkPermitReferenceObject ON WorkPermitReferenceObjectType = _WorkPermitReferenceObject.WorkPermitReferenceObjectType  -- association [1..1]
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_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_FunctionalLocationText AS _FunctionalLocationText ON FunctionalLocation = _FunctionalLocationText.FunctionalLocation  -- association [0..*]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON FunctionalLocation = _FunctionalLocationLabel.FunctionalLocation  -- association [0..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_TechObjIsEquipOrFuncnlLocT AS _TechObjIsEquipOrFuncnlLocT ON _TechObjIsEquipOrFuncnlLocT.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN E_WorkPermitTemplate AS _WorkPermitTemplateExtension ON _WorkPermitTemplateExtension.WorkPermit = WorkPermit  -- association [0..1]
LEFT OUTER JOIN R_WrkPmtTmplTechnicalObjectTP AS _PermitTmplTechnicalObject ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WrkPmtTemplateNatureOfWorkTP AS _PermitTmplNatureOfWork ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WrkPmtTmplSftyPrecautionTP AS _PermitTmplSftyPrecaution ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WrkPmtTmplPrsnlPrtcvEquipTP AS _PermitTmplProtEquip ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitTemplateLongTextTP AS _PermitTmplLongText ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitTemplatePartnerTP AS _PermitTmplPartner ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitTemplateApprovalTP AS _PermitTmplApproval ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WrkPmtTmplApprovalSegmentTP AS _PermitTmplApprvlSgmt ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WrkPmtTmplSftyCertTemplateTP AS _WrkPmtTmplSftyCertTemplate ON /* condition not available in parsed metadata */  -- association [*]
;