C_ObjPgTechnicalObject

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_ObjPgTechnicalObject.
-- 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: COPTECHOBJ

CREATE VIEW C_ObjPgTechnicalObject AS
SELECT
  TechObjIsEquipOrFuncnlLoc,
  TechnicalObject,
  Equipment,
  FunctionalLocation,
  TechnicalObjectLabel,
  TechnicalObjectDescription,
  _TechObjIsEquipOrFuncnlLocT[1:Language = $session.system_language].TechObjIsEquipOrFuncnlLocDesc AS TechObjIsEquipOrFuncnlLocDesc,
  TechnicalObjectCategory,
  _TechnicalObjectCategory._Text[1:Language = $session.system_language].TechnicalObjectCategoryDesc AS TechnicalObjectCategoryDesc,
  TechnicalObjectType,
  _TechnicalObjectType._Text[1:Language = $session.system_language].TechnicalObjectTypeDesc AS TechnicalObjectTypeDesc,
  AssetManufacturerName,
  ManufacturerPartTypeName,
  ManufacturerPartNmbr,
  ManufacturerSerialNumber,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  IsDeleted,
  TechnicalObjectHasLongText,
  InventoryNumber,
  GrossWeight,
  GrossWeightUnit,
  SizeOrDimensionText,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  _TechnicalObjectTP._WorkCenter.WorkCenter AS MainWorkCenter,
  _TechnicalObjectTP._WorkCenter._Text[ 1:Language = $session.system_language ].WorkCenterText AS MainWorkCenterDescription,
  _TechnicalObjectTP._WorkCenter.Plant AS MainWorkCenterPlant,
  _TechnicalObjectTP._WorkCenter._Plant.PlantName AS MainWorkCenterPlantName,
  _LocationAccountAssignment._MaintenancePlant.PlantName AS MaintenancePlantName,
  _LocationAccountAssignment._WorkCenter.WorkCenter AS WorkCenter,
  _LocationAccountAssignment._WorkCenter._Text[ 1:Language = $session.system_language ].WorkCenterText AS WorkCenterText,
  _LocationAccountAssignment._PlantSection.PlantSectionPersonRespName AS PlantSectionPersonRespName,
  _LocationAccountAssignment._PlantSection.PlantSectionPersonRespPhone AS PlantSectionPersonRespPhone,
  _LocationAccountAssignment._Location.LocationName AS LocationName,
  _LocationAccountAssignment._ABCIndicator._Text[1:Language=$session.system_language].ABCIndicatorDesc AS ABCIndicatorDesc,
  _LocationAccountAssignment._Address2.OrganizationName1 AS BusinessPartnerName1,
  _LocationAccountAssignment._Address2.OrganizationName2 AS BusinessPartnerName2,
  _LocationAccountAssignment._Address2.StreetName AS StreetName,
  _LocationAccountAssignment._Address2.PostalCode AS PostalCode,
  _LocationAccountAssignment._Address2.CityName AS CityName,
  _LocationAccountAssignment._Address2.HouseNumberSupplementText AS HouseNumberSupplementText,
  _LocationAccountAssignment._Address2.Floor AS Floor,
  _LocationAccountAssignment._Address2.RoomNumber AS RoomNumber,
  _LocationAccountAssignment._Address2.FormOfAddress AS FormOfAddress,
  _LocationAccountAssignment._Address2.Building AS Building,
  SuperiorTechnicalObject,
  SuperiorTechnicalObjectLabel,
  SuperiorTechnicalObjectName,
  SuperiorObjIsEquipOrFuncnlLoc,
  TechnicalObjectSortCode,
  TechObjectSortCodeSearchable,
  cast( case FunctionalLocation when '' then '1' else '0' end as abap.int1 ) AS UICT_TechnicalObjectSortCode,
  _LocationAccountAssignment._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _LocationAccountAssignment._BusinessArea._Text[1:Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
  _LocationAccountAssignment._MasterFixedAsset.MasterFixedAssetDescription AS MasterFixedAssetDescription,
  _LocationAccountAssignment._CostCenter[1:ValidityEndDate>=$session.system_date and ValidityStartDate<=$session.system_date]._Text[1:Language=$session.system_language].CostCenterName AS CostCenterName,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  _LocationAccountAssignment._ControllingArea.ControllingAreaName AS ControllingAreaName,
  _LocationAccountAssignment._WBSElementBasicData.WBSElement AS WBSElement,
  _LocationAccountAssignment._WBSElementBasicData.WBSDescription AS WBSDescription,
  _LocationAccountAssignment._StandingOrderNumber.MaintenanceOrderDesc AS StandingOrderDesc,
  _LocationAccountAssignment._SettlementOrder.OrderDescription AS SettlementOrderDesc,
  concat( '/sap/opu/odata/sap/EAM_OBJPG_TECHNICALOBJECT_SRV/', concat( concat( concat( 'TechnicalObjectTypeImageSet(TechObjIsEquipOrFuncnlLoc=''', TechObjIsEquipOrFuncnlLoc ), ''', '), concat( concat( 'TechnicalObject=''', replace(TechnicalObject,'?', '%3F')), ''')/$value'))) AS TechnicalObjectThumbnailURL,
  AuthorizationGroup,
  cast( '' as xfeld ) AS UICT_MaintenanceOrder,
  cast( '' as xfeld ) AS UICT_MaintenanceNotification,
  cast( '' as xfeld ) AS UICT_MaintenanceItem,
  cast( '' as xfeld ) AS UICT_ServiceOrder,
  cast(TechnicalObject as char40) AS TechObjectWithLeadingZeros,
  _TechnicalObjectTP._FunctionalLocationLabel._FuncLocationLabelSearch.FunctionalLocationLabelName AS FunctionalLocationLabelName,
  MaintObjectInternalID,
  _LocationAccountAssignment._WorkCenter.Plant AS Plant,
  _EquipmentPRT._ProdnRsceToolUsageQtyCalcFmla._Text[1:Language = $session.system_language].ProdnRsceToolQtyCalcFmlaName AS ProdnRsceToolQtyCalcFmlaName,
  _EquipmentPRT._ProductionResourceUsage._Text[1:Language = $session.system_language].ProductionResourceUsageDesc AS ProductionResourceUsageDesc,
  _EquipmentPRT._ProdnRsceToolControlProfile._Text[1:Language = $session.system_language].ProdnRsceToolControlPrflName AS ProdnRsceToolControlPrflName,
  CatalogProfile,
  TechObjCustomerMasterWarranty,
  TechObjCustWarrantyStartDate,
  TechObjCustWarrantyEndDate,
  cast( TechObjIsCustWarrantyInherited as boole_d ) AS TechObjIsCustWarrantyInherited,
  cast( TechObjIsCustWarrantyPassedOn as boole_d) AS TechObjIsCustWarrantyPassedOn,
  TechObjSupplierMasterWarranty,
  TechObjSuplrWarrantyStartDate,
  TechObjSuplrWarrantyEndDate,
  cast( TechObjIsSuplrWrntyInherited as boole_d ) AS TechObjIsSuplrWrntyInherited,
  cast( TechObjIsSuplrWarrantyPassedOn as boole_d ) AS TechObjIsSuplrWarrantyPassedOn,
  cast( ' ' as abap.numc( 12 ) ) AS InspectionLot,
  _LocationAccountAssignment._WorkCenter._Plant AS _WorkCenterPlant,
  _TechnicalObjectTP.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  _AssetIntelNtwkObjectLink.AssetIntelNtwkObjectID AS AssetIntelNtwkObjectID,
  _EquipmentPRT.ProdnRsceToolUsageQtyCalcFmla AS ProdnRsceToolUsageQtyCalcFmla,
  _EquipmentPRT.ProductionResourceUsage AS ProductionResourceUsage,
  _EquipmentPRT.ProdnRsceToolControlProfile AS ProdnRsceToolControlProfile,
  _LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  _LocationAccountAssignment.PlantSection AS PlantSection,
  _LocationAccountAssignment.AssetRoom AS AssetRoom,
  _LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  _LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  _LocationAccountAssignment.CompanyCode AS CompanyCode,
  _LocationAccountAssignment.BusinessArea AS BusinessArea,
  _LocationAccountAssignment.MasterFixedAsset AS MasterFixedAsset,
  _LocationAccountAssignment.FixedAsset AS FixedAsset,
  _LocationAccountAssignment.CostCenter AS CostCenter,
  _LocationAccountAssignment.ControllingArea AS ControllingArea,
  _LocationAccountAssignment.StandingOrderNumber AS StandingOrderNumber,
  _LocationAccountAssignment.SettlementOrder AS SettlementOrder,
  _LocationAccountAssignment.SalesOrganization AS SalesOrganization,
  _LocationAccountAssignment.DistributionChannel AS DistributionChannel,
  _LocationAccountAssignment.OrganizationDivision AS Division,
  _LocationAccountAssignment.SalesOffice AS SalesOffice,
  _LocationAccountAssignment.SalesGroup AS SalesGroup,
  _LocationAccountAssignment._MasterFixedAsset AS _MasterFixedAsset,
  _LocationAccountAssignment._FixedAsset AS _FixedAsset,
  _LocationAccountAssignment._MaintenancePlant AS _MaintenancePlant,
  _LocationAccountAssignment._PlantSection AS _PlantSection,
  _LocationAccountAssignment._CompanyCode AS _CompanyCode,
  _LocationAccountAssignment._BusinessArea AS _BusinessArea,
  _LocationAccountAssignment._CostCenter AS _CostCenter,
  _LocationAccountAssignment._SalesOrganization AS _SalesOrganization,
  _LocationAccountAssignment._SettlementOrder AS _SettlementOrder,
  _LocationAccountAssignment._Location AS _Location,
  _LocationAccountAssignment._ControllingArea AS _ControllingArea,
  _LocationAccountAssignment._StandingOrderNumber AS _StandingOrderNumber,
  _LocationAccountAssignment._ABCIndicator AS _ABCIndicator,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  _MaintenancePlanningPlant.PlantName AS MaintenancePlanningPlantName,
  _TechObjNoOfCheckList.NrOfOpenMaintenanceChecklists AS NrOfOpenMaintenanceChecklists,
  _TechObjNoOfCheckList.TechnicalObjectHasChecklist AS TechnicalObjectHasChecklist,
  _WorkCenter._Plant AS _Plant
FROM I_TechnicalobjectTP AS _TechnicalObjectTP
LEFT OUTER JOIN C_TechObjMaintNotification AS _TechObjMaintNotification ON _TechObjMaintNotification.TechnicalObject = TechnicalObject AND _TechObjMaintNotification.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN C_TechnicalObjectChgHistory AS _TechnicalObjectChgHistory ON TechObjectWithLeadingZeros = _TechnicalObjectChgHistory.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _SystemStatus ON _SystemStatus.StatusObject = MaintObjectInternalID AND _SystemStatus.IsUserStatus = ' '  -- association [0..*]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _UserStatusWthoutStsNmbr ON _UserStatusWthoutStsNmbr.StatusObject = MaintObjectInternalID AND _UserStatusWthoutStsNmbr.StatusSequenceNumber = '00' AND _UserStatusWthoutStsNmbr.IsUserStatus = 'X'  -- association [0..*]
LEFT OUTER JOIN C_MaintObjUserStatusWthStsNmbr AS _UserStatusWithStatusNumber ON _UserStatusWithStatusNumber.StatusObject = MaintObjectInternalID AND _UserStatusWithStatusNumber.StatusSequenceNumber != '00' AND _UserStatusWithStatusNumber.IsUserStatus = 'X'  -- association [0..1]
LEFT OUTER JOIN C_TechObjMaintenanceItem AS _ObjPgMaintenanceItem ON _ObjPgMaintenanceItem.TechnicalObject = TechnicalObject AND _ObjPgMaintenanceItem.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN C_TechObjSrvcMaintenanceItem AS _SrvcMaintenanceItem ON _SrvcMaintenanceItem.TechnicalObject = TechnicalObject AND _SrvcMaintenanceItem.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN C_TechObjMaintenanceOrder AS _TechObjMaintenanceOrder ON _TechObjMaintenanceOrder.TechnicalObject = TechnicalObject AND _TechObjMaintenanceOrder.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN C_TechObjServiceOrder AS _TechObjServiceOrder ON _TechObjServiceOrder.TechnicalObject = TechnicalObject AND _TechObjServiceOrder.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN C_ObjPgTechnicalObjectWthDesc AS _ObjPgTechnicalObjectWthDesc ON _ObjPgTechnicalObjectWthDesc.TechnicalObject = TechnicalObject AND _ObjPgTechnicalObjectWthDesc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [1..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLocVH ON _TechObjIsEquipOrFuncnlLocVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectLabelVH AS _TechnicalObjectLabelVH ON _TechnicalObjectLabelVH.TechnicalObjectLabel = TechnicalObjectLabel AND _TechnicalObjectLabelVH.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc AND _TechnicalObjectLabelVH.TechnicalObject = TechnicalObject  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _MainWorkCenterVH ON _MainWorkCenterVH.Plant = MainWorkCenterPlant AND _MainWorkCenterVH.WorkCenter = MainWorkCenter  -- association [0..1]
LEFT OUTER JOIN C_TechnicalObjectLabelVH AS _SuperiorTechnicalObject ON _SuperiorTechnicalObject.TechnicalObjectLabel = SuperiorTechnicalObjectLabel AND _SuperiorTechnicalObject.TechObjIsEquipOrFuncnlLoc = SuperiorObjIsEquipOrFuncnlLoc AND _SuperiorTechnicalObject.TechnicalObject = SuperiorTechnicalObject  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterVH ON _WorkCenterVH.Plant = plant AND _WorkCenterVH.WorkCenter = workcenter  -- association [0..1]
LEFT OUTER JOIN P_AstIntelNtwkObjLinkForNavgn AS _AssetIntelNtwkObjectLink ON _AssetIntelNtwkObjectLink.AssetIntelNtwkSyncedObjectID = TechnicalObject AND ( _AssetIntelNtwkObjectLink.AssetIntelNtwkSyncedObjectType = 'EQUI' OR _AssetIntelNtwkObjectLink.AssetIntelNtwkSyncedObjectType = 'FL' ) AND _AssetIntelNtwkObjectLink.AssetIntelNtwkObjectType = 'EQUI'  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsSyncedWthAstIntelNtwk ON _IsSyncedWthAstIntelNtwk.IndicatorValue = TechObjIsSyncedWthAstIntelNtwk  -- association [0..1]
LEFT OUTER JOIN C_MaintenancePlanPlantVH AS _MaintenancePlanningPlantVH ON _MaintenancePlanningPlantVH.MaintenancePlanningPlant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN C_PMAssetLocationVH AS _AssetLocationVH ON _AssetLocationVH.Location = assetlocation AND _AssetLocationVH.Plant = maintenanceplant  -- association [0..1]
LEFT OUTER JOIN C_TechObjQuickVw AS _SuperiorTechnicalObjQuickVw ON _SuperiorTechnicalObjQuickVw.TechnicalObject = SuperiorTechnicalObject AND _SuperiorTechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = SuperiorObjIsEquipOrFuncnlLoc AND _SuperiorTechnicalObjQuickVw.TechnicalObjectLabel = SuperiorTechnicalObjectLabel  -- association [0..1]
LEFT OUTER JOIN C_StsObjActiveStatusCodeText AS _ActiveSystemStatus ON _ActiveSystemStatus.StatusObject = MaintObjectInternalID AND _ActiveSystemStatus.IsUserStatus = ' '  -- association [0..*]
LEFT OUTER JOIN C_StsObjActiveStatusCodeText AS _ActiveUserStatus ON _ActiveUserStatus.StatusObject = MaintObjectInternalID AND _ActiveUserStatus.IsUserStatus = 'X'  -- association [0..*]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLocT AS _TechObjIsEquipOrFuncnlLocT ON _TechObjIsEquipOrFuncnlLocT.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrgText ON _SalesOrgText.SalesOrganization = SalesOrganization  -- association [0..*]
LEFT OUTER JOIN I_DistributionChannelText AS _DistributionChannelText ON _DistributionChannelText.DistributionChannel = DistributionChannel  -- association [0..*]
LEFT OUTER JOIN I_DivisionText AS _DivisionText ON _DivisionText.Division = Division  -- association [0..*]
LEFT OUTER JOIN I_SalesOfficeText AS _SalesOfficeText ON _SalesOfficeText.SalesOffice = SalesOffice  -- association [0..*]
LEFT OUTER JOIN I_SalesGroupText AS _SalesGroupText ON _SalesGroupText.SalesGroup = SalesGroup  -- association [0..*]
LEFT OUTER JOIN I_Location AS _LocationText ON _LocationText.Location = assetlocation AND _LocationText.Plant = maintenanceplant  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlannerGroup AS _MaintenancePlannerGroupText ON _MaintenancePlannerGroupText.MaintenancePlanningPlant = MaintenancePlanningPlant AND _MaintenancePlannerGroupText.MaintenancePlannerGroup = MaintenancePlannerGroup  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintenancePlantText ON _MaintenancePlantText.Plant = maintenanceplant  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObjectTypeText AS _TechnicalObjectTypeText ON _TechnicalObjectTypeText.TechnicalObjectType = TechnicalObjectType  -- association [0..*]
LEFT OUTER JOIN I_TechObjAuthznGrp AS _AuthorizationGroup ON _AuthorizationGroup.TechObjAuthorizationGroup = AuthorizationGroup  -- association [0..1]
LEFT OUTER JOIN I_EquipmentProdnRsceTool AS _EquipmentPRT ON _EquipmentPRT.Equipment = TechnicalObject AND TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'  -- association [0..1]
LEFT OUTER JOIN C_CostCtrHierarchyInnerNodeVH AS _CostCenterHierarchyInnerVH ON _CostCenterHierarchyInnerVH.UniversalHierarchy = costcenter  -- association [0..*]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _CostCenterHierarchyLeafNode ON costcenter = _CostCenterHierarchyLeafNode.UnivHierarchyBusinessEntity AND controllingarea = _CostCenterHierarchyLeafNode.HierarchyNodeClass AND _CostCenterHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _CostCenterHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _CostCenterHierarchyLeafNode.HierarchyType = '0101'  -- association [0..*]
LEFT OUTER JOIN C_MasterWarrantyNumberVH AS _CustomerMasterWarrantyVH ON TechObjCustomerMasterWarranty = _CustomerMasterWarrantyVH.MasterWarranty  -- association [0..1]
LEFT OUTER JOIN C_MasterWarrantyNumberVH AS _SupplierMasterWarrantyVH ON TechObjSupplierMasterWarranty = _SupplierMasterWarrantyVH.MasterWarranty  -- association [0..1]
LEFT OUTER JOIN C_MaintenanceCatalogProfileVH AS _CatalogProfileVH ON CatalogProfile = _CatalogProfileVH.CatalogProfile  -- association [0..1]
LEFT OUTER JOIN C_ObjPgTechObjectCheckList AS _ObjPgOpenTechObjCheckList ON TechnicalObject = _ObjPgOpenTechObjCheckList.TechnicalObject AND _ObjPgOpenTechObjCheckList.InspectionLotHasUsageDecision = ' '  -- association [0..*]
LEFT OUTER JOIN C_ObjPgTechObjectCheckList AS _ObjPgTechObjCheckList ON TechnicalObject = _ObjPgTechObjCheckList.TechnicalObject  -- association [0..*]
LEFT OUTER JOIN P_TechObjNoOfCheckList AS _TechObjNoOfCheckList ON TechnicalObject = _TechObjNoOfCheckList.TechnicalObject  -- association [0..1]
LEFT OUTER JOIN C_TechObjectRecommendation AS _TechObjectRecommendation ON TechObjIsEquipOrFuncnlLoc = _TechObjectRecommendation.TechObjIsEquipOrFuncnlLoc AND TechnicalObject = _TechObjectRecommendation.TechnicalObject  -- association [0..*]
;