R_WorkPermitTP

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_WorkPermitTP.
-- 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_WorkPermitTP AS
SELECT
  WorkPermit,
  WorkPermitInternalID,
  MaintenancePlanningPlant,
  cast ('' as wcewapinr ) AS WorkPermitExternalNumber,
  cast ('' as abap.char(5) ) AS ValidationScenarioID,
  WrkPmtSftyCertAssgmtCtrlCode,
  IsApproved,
  WrkPmtIssueHistoryIsAllowed,
  WrkPmtOrdOpAssgmtIsAllowed,
  WorkPermitType,
  WrkPmtMgmtObjSubType,
  WrkPermitDesc,
  WorkPermitHasLongText,
  WrkPermitIsDeleted,
  MaintenancePlannerGroup,
  ObjectTypeCode,
  OperationWorkCenterInternalID,
  TechObjAuthorizationGroup,
  WrkPermitValidFrmDate,
  WrkPermitValidFrmTime,
  WrkPermitValidToDate,
  WrkPermitValidToTime,
  WorkPermitTmplID,
  FunctionalLocation,
  WrkPermitHasMaintRemark,
  WrkPermitHasOpRemark,
  Equipment,
  _FunctionalLocationLabel.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  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,
  _IssueHist.WorkPermitIssuedTo AS MaintOrdPersonResponsible,
  WrkPermitHasObjectList,
  CreatedByUserName,
  CreatedByUser,
  UserDescription AS LastChangedByUserName,
  CreationDate,
  CreationTime,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  WrkPermitIsLinkdToDoc,
  StatusProfile,
  WorkPermitReferenceObjectType,
  case when _WorkPermitBasic.WrkPmtMgmtObjSubType = 'M' then _WorkPermitBasic.WorkPermit else ''end AS WorkPermitReference,
  case when _WorkPermitBasic.WrkPmtMgmtObjSubType = 'P' then _WorkPermitBasic.WorkPermit else ''end AS WorkPermitReferenceWorkPermit,
  cast(' ' as cv_orig preserving type ) AS IsAttachmentsEnabled,
  PlantTimeZone,
  ValidFromDateTime,
  ValidToDateTime,
  _MainWorkCenter.Plant AS WorkCenterPlant,
  _WorkCenterPlant.PlantName AS MainWorkCenterPlantName,
  _WorkPermitOrderRef.MaintenanceOrder AS MaintenanceOrder,
  _IssueHist.UserCommentsText AS UserCommentsText,
  _PermitPlanningPlant.PlantName AS MaintenancePlanningPlantName,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  _WorkPermitType.WorkPermitTypeDescription AS WorkPermitTypeDescription,
  _WrkPmtLongText._LongText.PlainLongText AS WorkPermitLongText,
  cast( '' as abap.char(1)) AS PrintIsReal,
  _WrkPmtLongText.WorkPermitOperationRemarkText AS WorkPermitOperationRemarkText,
  _WrkPmtLongText.WrkPmtMaintenanceRemarkText AS WrkPmtMaintenanceRemarkText,
  _WrkPmtLongText.WorkPermitCancellationText AS WorkPermitCancellationText,
  WorkCenter,
  WorkPermitProcessingStatusText,
  _Text.WorkCenterText AS WorkCenterText,
  I_WorkPermit._CreatedByUser AS _CreatedByUser,
  WrkPmtCnctntdActvSystStsTxt,
  ProductImageURL,
  WrkPmtChgStsActnEnbldVal,
  WrkPmtExtensionValidToDateTime,
  WorkPermitProcessingStatus
FROM I_WorkPermit
LEFT OUTER JOIN I_WorkPermitBasic AS _WorkPermitBasic ON _WorkPermitBasic.WorkPermitInternalID = WorkPermitTmplID  -- association [1..1]
LEFT OUTER JOIN I_WorkPermitApprvlSgmt AS _WrkPmtApprvlSgmtDet ON _WrkPmtApprvlSgmtDet.WorkPermit = WorkPermit AND _WrkPmtApprvlSgmtDet.WorkPermitInternalID = WorkPermitInternalID  -- association [*]
LEFT OUTER JOIN I_WorkPermitStatus AS _WorkPermitStatus ON _WorkPermitStatus.WorkPermit = WorkPermit AND _WorkPermitStatus.WorkPermitInternalID = WorkPermitInternalID  -- association [*]
LEFT OUTER JOIN I_WorkPermitLongText AS _WrkPmtLongText ON _WrkPmtLongText.WorkPermit = WorkPermit AND _WrkPmtLongText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_WorkPermitReferenceObject AS _WorkPermitReferenceObject ON WorkPermitReferenceObjectType = _WorkPermitReferenceObject.WorkPermitReferenceObjectType AND _WorkPermitReferenceObject.WorkPermitReferenceObjectType <> '10'  -- association [1..1]
LEFT OUTER JOIN I_WrkPmtReferenceObjectText AS _WrkPmtReferenceObjectText ON _WrkPmtReferenceObjectText.WorkPermitReferenceObjectType = WorkPermitProcessingStatus AND _WrkPmtReferenceObjectText.Language = $session.system_language AND _WrkPmtReferenceObjectText.Name = 'PTWDWORKPERMITPROCESSINGSTATUS'  -- 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_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_TechObjIsEquipOrFuncnlLocT AS _TechObjIsEquipOrFuncnlLocT ON _TechObjIsEquipOrFuncnlLocT.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..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_WorkPermitOrder AS _WorkPermitOrderRef ON _WorkPermitOrderRef.WorkPermit = WorkPermit AND _WorkPermitOrderRef.IsReferenceDocument = 'X'  -- association [0..1]
LEFT OUTER JOIN E_WorkPermit AS _WorkPermitExtension ON _WorkPermitExtension.WorkPermit = WorkPermit  -- association [0..1]
LEFT OUTER JOIN R_WorkPermitNatureOfWorkTP AS _PermitNatureOfWork ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitSafetyPrecautionTP AS _PermitSftyPrecaution ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WrkPmtPrsnlPrtcvEquipmentTP AS _PermitProtEquip ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitOrderOperationTP AS _WorkPermitOrderOperation ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitOrderTP AS _WorkPermitOrder ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitTechnicalObjectTP AS _TechnicalObject ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitPartnerTP AS _WorkPermitPartner ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitLongTextTP AS _WorkPermitLongTxt ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitApprovalTP AS _WorkPermitApproval ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitApprovalSegmentTP AS _WrkPmtApprvlSgmt ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WorkPermitIssueHistoryTP AS _WorkPermitIssHist ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WrkPmtSafetyCertificateTP AS _WrkPmtSafetyCertificate ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_WrkPmtSftyCertApprovalTP AS _WrkPmtSftyCertApproval ON /* condition not available in parsed metadata */  -- association [*]
;