I_TechnicalObject

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_TechnicalObject.
-- 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: ITECHNICALOBJECT

CREATE VIEW I_TechnicalObject AS
SELECT
  P_EquipmentFuncnlLocUnion.TechnicalObject AS TechnicalObject,
  P_EquipmentFuncnlLocUnion.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  SuperiorTechnicalObject,
  P_EquipmentFuncnlLocUnion.TechnicalObjectCategory AS TechnicalObjectCategory,
  P_EquipmentFuncnlLocUnion.Equipment AS Equipment,
  P_EquipmentFuncnlLocUnion.FunctionalLocation AS FunctionalLocation,
  P_EquipmentFuncnlLocUnion.TechnicalObjectType AS TechnicalObjectType,
  P_EquipmentFuncnlLocUnion.CreatedByUser AS CreatedByUser,
  P_EquipmentFuncnlLocUnion.CreationDate AS CreationDate,
  P_EquipmentFuncnlLocUnion.LastChangedByUser AS LastChangedByUser,
  P_EquipmentFuncnlLocUnion.LastChangeDate AS LastChangeDate,
  P_EquipmentFuncnlLocUnion.AssetManufacturerName AS AssetManufacturerName,
  P_EquipmentFuncnlLocUnion.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  P_EquipmentFuncnlLocUnion.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  P_EquipmentFuncnlLocUnion.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  P_EquipmentFuncnlLocUnion.CatalogProfile AS CatalogProfile,
  P_EquipmentFuncnlLocUnion.AuthorizationGroup AS AuthorizationGroup,
  P_EquipmentFuncnlLocUnion.WorkCenterInternalID AS WorkCenterInternalID,
  P_EquipmentFuncnlLocUnion.WorkCenterTypeCode AS WorkCenterTypeCode,
  P_EquipmentFuncnlLocUnion.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  P_EquipmentFuncnlLocUnion.ManufacturerCountry AS ManufacturerCountry,
  P_EquipmentFuncnlLocUnion.ConstructionYear AS ConstructionYear,
  P_EquipmentFuncnlLocUnion.ConstructionMonth AS ConstructionMonth,
  P_EquipmentFuncnlLocUnion.ConstructionMaterial AS ConstructionMaterial,
  P_EquipmentFuncnlLocUnion.AcquisitionDate AS AcquisitionDate,
  P_EquipmentFuncnlLocUnion.Currency AS Currency,
  P_EquipmentFuncnlLocUnion.AcquisitionValue AS AcquisitionValue,
  P_EquipmentFuncnlLocUnion.TechnicalObjectSortCode AS TechnicalObjectSortCode,
  P_EquipmentFuncnlLocUnion.MaintObjectInternalID AS MaintObjectInternalID,
  P_EquipmentFuncnlLocUnion.SizeOrDimensionText AS SizeOrDimensionText,
  P_EquipmentFuncnlLocUnion.InventoryNumber AS InventoryNumber,
  P_EquipmentFuncnlLocUnion.GrossWeight AS GrossWeight,
  P_EquipmentFuncnlLocUnion.GrossWeightUnit AS GrossWeightUnit,
  P_EquipmentFuncnlLocUnion.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  P_EquipmentFuncnlLocUnion.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  P_EquipmentFuncnlLocUnion.OperationStartDate AS OperationStartDate,
  P_EquipmentFuncnlLocUnion.FuncLocStrucIdentifyingLevel AS FuncLocStrucIdentifyingLevel,
  P_EquipmentFuncnlLocUnion.FuncLocStruc2ndIdentifyingLvl AS FuncLocStruc2ndIdentifyingLvl,
  P_EquipmentFuncnlLocUnion.FuncLocationStructure AS FuncLocationStructure,
  P_EquipmentFuncnlLocUnion.SuperiorFunctionalLocation AS SuperiorFunctionalLocation,
  TechnicalObjectDescription,
  TechnicalObjectHasLongText,
  SuperiorTechnicalObjectName,
  SuperiorTechnicalObjectLabel,
  P_EquipmentFuncnlLocUnion.SalesOrganization AS SalesOrganization,
  P_EquipmentFuncnlLocUnion.DistributionChannel AS DistributionChannel,
  P_EquipmentFuncnlLocUnion.SalesOffice AS SalesOffice,
  P_EquipmentFuncnlLocUnion.OrganizationDivision AS OrganizationDivision,
  P_EquipmentFuncnlLocUnion.SalesGroup AS SalesGroup,
  P_EquipmentFuncnlLocUnion.Material AS Material,
  P_EquipmentFuncnlLocUnion.SerialNumber AS SerialNumber
FROM P_EquipmentFuncnlLocUnion
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_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON _WorkCenter.WorkCenterInternalID = WorkCenterInternalID AND _WorkCenter.WorkCenterTypeCode = 'A'  -- association [0..1]
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObjectType AS _TechnicalObjectType ON _TechnicalObjectType.TechnicalObjectType = TechnicalObjectType  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON _Equipment.Equipment = Equipment  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON _FunctionalLocation.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _SuperiorFunctionalLocation ON _SuperiorFunctionalLocation.FunctionalLocation = SuperiorFunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = TechnicalObject  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MaintenancePlanningPlant ON _MaintenancePlanningPlant.Plant = MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc ON _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObjectText AS _TechnicalObjectText ON _TechnicalObjectText.TechnicalObject = TechnicalObject AND _TechnicalObjectText.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..*]
LEFT OUTER JOIN I_TechnicalObjectCategory AS _TechnicalObjectCategory ON TechnicalObjectCategory = _TechnicalObjectCategory.TechnicalObjectCategory AND _TechnicalObjectCategory.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlannerGroup AS _MaintenancePlannerGroup ON MaintenancePlannerGroup = _MaintenancePlannerGroup.MaintenancePlannerGroup AND MaintenancePlanningPlant = _MaintenancePlannerGroup.MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_Country AS _ManufacturerCountry ON ManufacturerCountry = _ManufacturerCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _IsDeleted ON IsDeleted = _IsDeleted.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _TechObjStatusIsInactive ON TechObjStatusIsInactive = _TechObjStatusIsInactive.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectActiveStatus AS _StatusObjectActiveStatus ON MaintObjectInternalID = _StatusObjectActiveStatus.StatusObject  -- association [0..*]
LEFT OUTER JOIN I_TechobjNumberOfSubobjects AS _TechobjNumberOfSubobjects ON TechnicalObject = _TechobjNumberOfSubobjects.TechnicalObject AND TechObjIsEquipOrFuncnlLoc = _TechobjNumberOfSubobjects.TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_TechnicalReport AS _TechnicalObjectCodeCatalog ON CatalogProfile = _TechnicalObjectCodeCatalog.CatalogProfile  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObjectHierarchy AS _TechnicalObjectHierarchy ON TechnicalObject = _TechnicalObjectHierarchy.TechnicalObject AND TechObjIsEquipOrFuncnlLoc = _TechnicalObjectHierarchy.TechObjIsEquipOrFuncnlLoc  -- association [1]
LEFT OUTER JOIN I_Material AS _ConstructionMaterial ON ConstructionMaterial = _ConstructionMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_TechObjCustWrntyAssgmt AS _CustWrntyObjAssgmt ON _CustWrntyObjAssgmt.ObjectInternalID = MaintObjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_TechObjVndrWrntyAssgmt AS _VndrWrntyObjAssgmt ON _VndrWrntyObjAssgmt.ObjectInternalID = MaintObjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _SuperFunctionalLocationLabel ON P_EquipmentFuncnlLocUnion.SuperiorFunctionalLocation = _SuperFunctionalLocationLabel.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN E_FunctionalLocation AS _FunctionalLocationExtension ON _FunctionalLocationExtension.FunctionalLocation = FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN E_Equipment AS _EquipmentExtension ON _EquipmentExtension.Equipment = Equipment association[0..1] to I_MaintenancePlanPlant as _MaintenancePlanPlant on MaintenancePlanningPlant = _MaintenancePlanPlant.MaintenancePlanningPlant  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _GrossWeightUnit ON GrossWeightUnit = _GrossWeightUnit.UnitOfMeasure  -- association [0..1]
;