C_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 C_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 C_WorkPermitTP AS
SELECT
  WorkPermit,
  WorkPermitInternalID,
  MaintenancePlanningPlant,
  WrkPmtOrdOpAssgmtIsAllowed,
  WrkPmtIssueHistoryIsAllowed,
  WrkPmtSftyCertAssgmtCtrlCode,
  WorkPermitExternalNumber,
  ValidationScenarioID,
  IsApproved,
  WorkPermitType,
  WrkPermitDesc,
  WrkPermitValidFrmDate,
  WrkPermitValidFrmTime,
  WrkPermitValidToDate,
  WrkPermitValidToTime,
  MaintenancePlannerGroup,
  WorkCenter,
  WorkCenterText,
  ObjectTypeCode,
  OperationWorkCenterInternalID,
  WorkCenterPlant,
  MainWorkCenterPlantName,
  TechObjAuthorizationGroup,
  CreatedByUser,
  CreatedByUserName,
  CreationDateTime,
  LastChangedByUser,
  LastChangedByUserName,
  LastChangeDateTime,
  WrkPmtMgmtObjSubType,
  PlantTimeZone,
  ValidFromDateTime,
  ValidToDateTime,
  IsExpired,
  WorkPermit.Equipment AS Equipment,
  _EquipmentText.EquipmentName as EquipmentName : localized AS EquipmentNameasEquipmentNamelocalized,
  FunctionalLocation,
  _FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  WrkPermitHasMaintRemark,
  WrkPermitHasOpRemark,
  TechnicalObject,
  TechnicalObjectLabel,
  TechnicalObjectDescription,
  TechObjIsEquipOrFuncnlLoc,
  _TechObjIsEquipOrFuncnlLocT[1:Language = $session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  MaintenancePlant,
  MaintenancePlantName,
  IsAttachmentsEnabled,
  PlantSection,
  PlantSectionDesc,
  AssetLocation,
  MaintOrdPersonResponsible,
  LocationName,
  AssetRoom,
  MaintenancePlanningPlantName,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  WorkPermitHasLongText,
  WorkPermitLongText,
  WorkPermitOperationRemarkText,
  WrkPmtMaintenanceRemarkText,
  WorkPermitCancellationText,
  WorkPermitTypeDescription,
  MaintenanceOrder,
  MaintenanceOrderDesc,
  virtual ActiveMaintenanceOrder : aufnr AS virtualActiveMaintenanceOrderaufnr,
  virtual NumberOfOrders : eam_num_orders AS virtualNumberOfOrderseam_num_orders,
  _IssueHist._PersonWorkAgreement.PersonFullName AS PersonFullName,
  UserCommentsText,
  WorkPermitReference,
  WorkPermitReferenceWorkPermit,
  WrkPmtCnctntdActvSystStsTxt,
  virtual SystemStatusText : abap.char(40) AS char40,
  ProductImageURL,
  WrkPmtChgStsActnEnbldVal,
  WorkPermitProcessingStatus,
  _WrkPmtProcessingStatusText.WorkPermitProcessingStatusText AS WorkPermitProcessingStatusText,
  WorkPermitReferenceObjectType,
  _WorkPermitReferenceObject._Text.WorkPermitReferenceObjTypeDesc AS WorkPermitReferenceObjTypeDesc
FROM R_WorkPermitTP
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLocVH ON _TechObjIsEquipOrFuncnlLocVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN C_WrkPmtTechnicalObjectVH AS _TechnicalObjectVH ON _TechnicalObjectVH.TechnicalObjectLabel = TechnicalObjectLabel AND _TechnicalObjectVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjectVH.TechnicalObject = TechnicalObject  -- association [0..1]
;