I_WorkPermitTemplate

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_WorkPermitTemplate.
-- 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: IWRKPMTTEMPLATE

CREATE VIEW I_WorkPermitTemplate AS
SELECT
  _PermitBasic.WorkPermit AS WorkPermit,
  _PermitBasic.WorkPermitInternalID AS WorkPermitInternalID,
  _PermitBasic.WrkPmtMgmtObjSubType AS WrkPmtMgmtObjSubType,
  _PermitBasic.WorkPermitType AS WorkPermitType,
  _PermitBasic.WrkPermitDesc AS WrkPermitDesc,
  _PermitBasic.WorkPermitHasLongText AS WorkPermitHasLongText,
  _PermitBasic.WorkPermitTmplID AS WorkPermitTmplID,
  _PermitBasic.WrkPermitIsDeleted AS WrkPermitIsDeleted,
  _PermitBasic.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _PermitBasic.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _PermitBasic.ObjectTypeCode AS ObjectTypeCode,
  _PermitBasic.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  _PermitBasic.TechObjAuthorizationGroup AS TechObjAuthorizationGroup,
  _PermitBasic.WrkPermitValidFrmDate AS WrkPermitValidFrmDate,
  _PermitBasic.WrkPermitValidFrmTime AS WrkPermitValidFrmTime,
  _PermitBasic.WrkPermitValidToDate AS WrkPermitValidToDate,
  $session. system_date AS CurrentDate,
  cast ( tstmp_current_utctimestamp() as tzntstmps ) AS CurrentDateTime,
  _PermitBasic.WrkPermitValidToTime AS WrkPermitValidToTime,
  _PermitBasic.WrkPmtMgmtPriority AS WrkPmtMgmtPriority,
  _PermitBasic.FunctionalLocation AS FunctionalLocation,
  _PermitBasic.Equipment AS Equipment,
  _PermitBasic.WrkPermitHasObjectList AS WrkPermitHasObjectList,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  _LastChangedByUser.UserDescription AS UserDescription,
  _PermitBasic.CreatedByUser AS CreatedByUser,
  _PermitBasic.CreationDate AS CreationDate,
  _PermitBasic.CreationTime AS CreationTime,
  _PermitBasic.CreationDateTime AS CreationDateTime,
  _PermitBasic.LastChangedByUser AS LastChangedByUser,
  _PermitBasic.LastChangeDate AS LastChangeDate,
  _PermitBasic.LastChangeTime AS LastChangeTime,
  _PermitBasic.LastChangeDateTime AS LastChangeDateTime,
  _PermitBasic.ValidFromDateTime AS ValidFromDateTime,
  _PermitBasic.ValidToDateTime AS ValidToDateTime,
  _PermitBasic.WrkPermitIsLinkdToDoc AS WrkPermitIsLinkdToDoc,
  _PermitBasic.StatusProfile AS StatusProfile,
  _PermitBasic.WrkPermitHasMaintRemark AS WrkPermitHasMaintRemark,
  _PermitBasic.WrkPermitHasOpRemark AS WrkPermitHasOpRemark,
  _PermitBasic.WorkPermitOperationLongTextKey AS WorkPermitOperationLongTextKey,
  _PermitBasic.WrkPmtMaintenanceLongTextKey AS WrkPmtMaintenanceLongTextKey,
  _PermitBasic.LongTextKey AS LongTextKey,
  _MainWorkCenter.WorkCenter AS WorkCenter,
  _MainWorkCenter._Text[1: Language = $session.system_language ].WorkCenterText AS WorkCenterText,
  _MainWorkCenter.Plant AS WorkCenterPlant,
  cast ('' as vdm_j_system_status_concat_t) AS WrkPmtCnctntdActvSystStsTxt,
  cast( '' as abap.char( 1333 ) ) AS WrkPmtChgStsActnEnbldVal,
  _PermitBasic.WorkPermitProcessingStatus AS WorkPermitProcessingStatus,
  _WrkPmtProcessingStatusText.WorkPermitProcessingStatusText AS WorkPermitProcessingStatusText
FROM I_WorkPermitBasic AS _PermitBasic
LEFT OUTER JOIN I_WorkPermitTemplateType 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_PermitToWorkProfile AS _PermitToWorkProfile ON MaintenancePlanningPlant = _PermitToWorkProfile.MaintenancePlanningPlant  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..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_WorkPermitStatus AS _WorkPermitStatus ON _WorkPermitStatus.WorkPermit = WorkPermit AND _WorkPermitStatus.WorkPermitInternalID = WorkPermitInternalID AND _WorkPermitStatus.StatusCode = 'I0175'  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _WorkCenterPlant ON WorkCenterPlant = _WorkCenterPlant.Plant  -- association [0..1]
;