P_EquipmentFuncnlLocUnion

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 P_EquipmentFuncnlLocUnion.
-- 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: PEQUIFLOCUNION

CREATE VIEW P_EquipmentFuncnlLocUnion AS
SELECT
  cast ( _EquipmentTimeSeg.Equipment as eams_tec_obj ) AS TechnicalObject,
  cast ( 'EAMS_EQUI' as eams_tec_obj_type_value) AS TechObjIsEquipOrFuncnlLoc,
  _EquipmentTimeSeg.Equipment AS Equipment,
  cast( '' as tplnr ) AS FunctionalLocation,
  cast( I_Equipment.EquipmentCategory as eams_tec_obj_cat ) AS TechnicalObjectCategory,
  I_Equipment.TechnicalObjectType AS TechnicalObjectType,
  I_Equipment.CreatedByUser AS CreatedByUser,
  I_Equipment.CreationDate AS CreationDate,
  I_Equipment.LastChangedByUser AS LastChangedByUser,
  I_Equipment.LastChangeDate AS LastChangeDate,
  I_Equipment.AssetManufacturerName AS AssetManufacturerName,
  I_Equipment.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  _EquipmentTimeSeg.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _EquipmentTimeSeg.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _EquipmentTimeSeg.CatalogProfile AS CatalogProfile,
  I_Equipment.AuthorizationGroup AS AuthorizationGroup,
  _EquipmentTimeSeg.WorkCenterInternalID AS WorkCenterInternalID,
  _EquipmentTimeSeg.WorkCenterTypeCode AS WorkCenterTypeCode,
  _EquipmentTimeSeg.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_Equipment.ManufacturerCountry AS ManufacturerCountry,
  I_Equipment.ConstructionYear AS ConstructionYear,
  I_Equipment.ConstructionMonth AS ConstructionMonth,
  _EquipmentTimeSeg.ConstructionMaterial AS ConstructionMaterial,
  I_Equipment.AcquisitionDate AS AcquisitionDate,
  I_Equipment.Currency AS Currency,
  I_Equipment.AcquisitionValue AS AcquisitionValue,
  I_Equipment.MaintObjectInternalID AS MaintObjectInternalID,
  _EquipmentTimeSeg.TechnicalObjectSortCode AS TechObjectSortCodeSearchable,
  _EquipmentTimeSeg.TechnicalObjectSortCode AS TechnicalObjectSortCode,
  _EquipmentTimeSeg.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  I_Equipment.SizeOrDimensionText AS SizeOrDimensionText,
  I_Equipment.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  I_Equipment.InventoryNumber AS InventoryNumber,
  I_Equipment.GrossWeight AS GrossWeight,
  I_Equipment.GrossWeightUnit AS GrossWeightUnit,
  I_Equipment.OperationStartDate AS OperationStartDate,
  cast ( '00' as ilom_level_kz ) AS FuncLocStrucIdentifyingLevel,
  cast ( '00' as ilom_level_kz2 ) AS FuncLocStruc2ndIdentifyingLvl,
  cast ( ' ' as tplkz ) AS FuncLocationStructure,
  _LocationAccountAssignment.SalesOrganization AS SalesOrganization,
  _LocationAccountAssignment.DistributionChannel AS DistributionChannel,
  _LocationAccountAssignment.SalesOffice AS SalesOffice,
  _LocationAccountAssignment.OrganizationDivision AS OrganizationDivision,
  _LocationAccountAssignment.SalesGroup AS SalesGroup,
  I_Equipment.Material AS Material,
  I_Equipment.SerialNumber AS SerialNumber,
  _EquipmentText[1: Language = $session.system_language].EquipmentHasLongText AS TechnicalObjectHasLongText,
  _LocationAccountAssignment.FunctionalLocation AS SuperiorFunctionalLocation,
  SuperiorFunctionalLocation AS SuperiorTechnicalObject,
  _SuperiorFunctionalLocation._FunctionalLocationLabel.FunctionalLocationLabelName AS SuperiorTechnicalObjectLabel,
  _SupFunctionalLocationText[1: Language = $session.system_language ].FunctionalLocationName AS SuperiorTechnicalObjectName,
  case when SuperiorFunctionalLocation <> '' then 'EAMS_FL' end AS SuperiorObjIsEquipOrFuncnlLoc,
  '' AS SuperordinateEquipment
FROM I_EquipmentTimeSeg AS _EquipmentTimeSeg
-- UNION ALL with additional select branch(es): I_FunctionalLocation
;