R_IsolationCertificateItemTP

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_IsolationCertificateItemTP.
-- 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_IsolationCertificateItemTP AS
SELECT
  IsolationCertificate,
  IsolationCertificateItem,
  _IsltnCertificate.SftyCertDesc AS IsltnCertificateDescription,
  OutputControlApplicationObject,
  OutputControlApplObjectType,
  cast( 'IsolationCertificateItem' as abap.char( 30)) AS SAPObjectNodeType,
  IsolationCertItemInternalID,
  IsltnCertItmCategory,
  IsolationCertificateType,
  IsltnCertItemSequenceNumber,
  FunctionalLocation,
  MaintenancePlanningPlant,
  IsltnCertItmCatType,
  IsltnCertItmSwitchingLocation AS IsltnCertItemDescription,
  IsltnCertItemOperationalGroup,
  _IsltnCertItmOplGroup.IsltnCertItemOplGroupText AS IsltnCertItemOplGroupText,
  IsltnCertItemTaggingStep,
  IsltnCertItmTaggingCondition,
  IsltnCertItmTaggingType,
  _IsltnCertItmTagConditionText.IsltnCertItmTagConditionText AS IsltnCertItmTagConditionText,
  _IsltnCertItmTagTypeText.IsltnCertItmTagTypeText AS IsltnCertItmTagTypeText,
  IsltnCertItmTaggingSequence,
  IsltnCertItmTaggingComment,
  IsltnCertItemLockNumber,
  IsltnCertItmUntaggingStep,
  IsltnCertItmUntaggingCondition,
  IsltnCertItmUntaggingType,
  _IsltnCertItmUntagConditionT.IsltnCertItmUntagConditionText AS IsltnCertItmUntagConditionText,
  _IsltnCertItmUntagTypeText.IsltnCertItmUntagTypeText AS IsltnCertItmUntagTypeText,
  IsltnCertItmUntaggingSequence,
  _IsolationCertificateItem.IsltnCertItmUntaggingComment AS IsltnCertItmUntaggingComment,
  IsltnCertItemTagIsRequired,
  IsltnCertItemTagPrintFormat,
  IsolationCertificateItemTag,
  IsltnCertItmTestTagPrintFormat,
  IsltnCertItmTestTag,
  _IsltnCertItemCategoryType.IsltnCertItmCatTypeText AS IsltnCertItmCatTypeText,
  IsltnCertItmPhysBlkIsRqd,
  IsltnCertItmPhysicalBlockType,
  _IsltnCertItmPhysBlockType.IsltnCertItmPhysBlockTypeText AS IsltnCertItmPhysBlockTypeText,
  IsltnCertItmSwitchingLocation,
  IsltnCertItmLocation,
  IsltnCertItmHasLongText,
  TechObjIsEquipOrFuncnlLoc,
  _IsltnCertItemLongText._LongText.PlainLongText AS IsltnCertItemLongText,
  IsltnCertItmProcessingStatus,
  _IsltnCertItemProcgStatusText.IsltnCertItmProcgStatusText AS IsltnCertItmProcgStatusText,
  IsltnCertItmPersonResponsible,
  cast( '' as ad_smtpadr ) AS EmailAddress,
  cast( '' as ad_tlnmbr ) AS MobilePhoneNumber,
  _WorkAssignment.PersonFullName AS PersonFullName,
  IsltnCertItmIsTestingRequired,
  IsltnCertItmAdditionalComment,
  cast( concat( '/sap/opu/odata/sap/EAM_OBJPG_TECHNICALOBJECT_SRV/', concat( concat( concat( 'TechnicalObjectTypeImageSet(TechObjIsEquipOrFuncnlLoc=''', techobjisequiporfuncnlloc ), ''', '), concat( concat( 'TechnicalObject=''', replace(functionallocation,'?', '%3F')), ''')/$value' ))) as sxms_char273 ) AS IsltnCertThumbnailURL
FROM I_IsolationCertificateItem AS _IsolationCertificateItem
LEFT OUTER JOIN I_TechnicalObject AS _TechnicalObject ON FunctionalLocation = _TechnicalObject.TechnicalObject AND TechObjIsEquipOrFuncnlLoc = _TechnicalObject.TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON FunctionalLocation = _FunctionalLocationLabel.FunctionalLocationLabelName  -- association [0..*]
LEFT OUTER JOIN I_TechnicalObject AS _FunctionalLocation ON FunctionalLocation = _FunctionalLocation.TechnicalObjectLabel AND TechObjIsEquipOrFuncnlLoc = _FunctionalLocation.TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN I_IsltnCertItmOperationalGroup AS _IsltnCertItmOplGroup ON _IsltnCertItmOplGroup.IsltnCertItemOperationalGroup = IsltnCertItemOperationalGroup  -- association [0..1]
LEFT OUTER JOIN I_IsltnCertItemCategoryTypeT AS _IsltnCertItemCategoryType ON IsltnCertItmCatType = _IsltnCertItemCategoryType.IsltnCertItmCatType AND _IsltnCertItemCategoryType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IsltnCertItemLongText AS _IsltnCertItemLongText ON _IsltnCertItemLongText.IsolationCertificate = IsolationCertificate AND _IsltnCertItemLongText.IsolationCertItemInternalID = IsolationCertItemInternalID AND _IsltnCertItemLongText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_IsltnCertItemProcgStatusText AS _IsltnCertItemProcgStatusText ON _IsltnCertItemProcgStatusText.IsltnCertItmProcessingStatus = IsltnCertItmProcessingStatus AND _IsltnCertItemProcgStatusText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_IsltnCertificateItemStatus AS _IsltnCertificateItemStatus ON _IsltnCertificateItemStatus.IsolationCertificate = IsolationCertificate AND _IsltnCertificateItemStatus.IsolationCertItemInternalID = IsolationCertItemInternalID AND _IsltnCertificateItemStatus.StatusCode = 'I0175' AND _IsltnCertificateItemStatus.StatusIsInactive = ''  -- association [0..1]
LEFT OUTER JOIN I_IsltnCertItmOplGroupTagUntag AS _IsltnCertItmTagConditionText ON _IsltnCertItmTagConditionText.MaintenancePlanningPlant = MaintenancePlanningPlant AND _IsltnCertItmTagConditionText.IsltnCertItemOperationalGroup = IsltnCertItemOperationalGroup AND _IsltnCertItmTagConditionText.IsltnCertItmTaggingCondition = IsltnCertItmTaggingCondition  -- association [0..1]
LEFT OUTER JOIN I_IsltnCertItmOplGroupTagUntag AS _IsltnCertItmUntagConditionT ON _IsltnCertItmUntagConditionT.MaintenancePlanningPlant = MaintenancePlanningPlant AND _IsltnCertItmUntagConditionT.IsltnCertItemOperationalGroup = IsltnCertItemOperationalGroup AND _IsltnCertItmUntagConditionT.IsltnCertItmTaggingCondition = IsltnCertItmTaggingCondition AND _IsltnCertItmUntagConditionT.IsltnCertItmUntaggingCondition = IsltnCertItmUntaggingCondition  -- association [0..*]
LEFT OUTER JOIN I_IsltnCertItmOplGroupTagUntag AS _IsltnCertItmTagTypeText ON _IsltnCertItmTagTypeText.IsltnCertItemOperationalGroup = IsltnCertItemOperationalGroup AND _IsltnCertItmTagTypeText.IsltnCertItmTaggingCondition = IsltnCertItmTaggingCondition AND _IsltnCertItmTagTypeText.IsltnCertItmTaggingType = IsltnCertItmTaggingType AND _IsltnCertItmTagTypeText.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..*]
LEFT OUTER JOIN I_IsltnCertItmOplGroupTagUntag AS _IsltnCertItmUntagTypeText ON _IsltnCertItmUntagTypeText.IsltnCertItemOperationalGroup = IsltnCertItemOperationalGroup AND _IsltnCertItmUntagTypeText.IsltnCertItmTaggingCondition = IsltnCertItmTaggingCondition AND _IsltnCertItmUntagTypeText.IsltnCertItmUntaggingCondition = IsltnCertItmUntaggingCondition AND _IsltnCertItmUntagTypeText.IsltnCertItmUntaggingType = IsltnCertItmUntaggingType AND _IsltnCertItmUntagTypeText.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..*]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLocVH ON _TechObjIsEquipOrFuncnlLocVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_IsltnCertItmPhysBlockType AS _IsltnCertItmPhysBlockType ON _IsltnCertItmPhysBlockType.MaintenancePlanningPlant = MaintenancePlanningPlant AND _IsltnCertItmPhysBlockType.IsltnCertItmPhysicalBlockType = IsltnCertItmPhysicalBlockType AND _IsltnCertItmPhysBlockType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_OutputRequestTP AS _OutputRequest ON _OutputRequest.OutputControlApplicationObject = OutputControlApplicationObject AND _OutputRequest.OutputControlApplObjectType = OutputControlApplObjectType  -- association [0..1]
LEFT OUTER JOIN I_HDMRelationTP AS _HDMRelation ON IsolationCertItemInternalID = _HDMRelation.LinkedSAPObjectKey AND SAPObjectNodeType = _HDMRelation.SAPObjectNodeType  -- association [0..*]
LEFT OUTER JOIN I_SafetyCertificate AS _IsltnCertificate ON IsolationCertificate = _IsltnCertificate.SafetyCertificate  -- association [0..1]
LEFT OUTER JOIN I_IsltnCertItemConflictStatusT AS _IsltnCertItemConflictStatusT ON _IsltnCertItemConflictStatusT.IsltnCertItemConflictIsIgnored = IsltnCertItemConflictIsIgnored AND _IsltnCertItemConflictStatusT.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WorkAssignment AS _WorkAssignment ON _WorkAssignment.WorkAssignment = IsltnCertItmPersonResponsible  -- association [0..1]
LEFT OUTER JOIN R_IsltnCertItmLongTextTP AS _IsltnCertItemLongTextTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_IsltnCertItmConflictCheckTP AS _IsltnCertItmConflictCheckTP ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_IsltnCertItmTimeFrameCheckTP AS _IsltnCertItmTimeFrameCheckTP ON /* condition not available in parsed metadata */  -- association [*]
;