I_TechnicalobjectTP

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_TechnicalobjectTP.
-- 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: ITECHNICALO000TP

CREATE VIEW I_TechnicalobjectTP AS
SELECT
  I_TechnicalObject.TechnicalObject AS TechnicalObject,
  I_TechnicalObject.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_TechnicalObject.TechnicalObjectLabel AS TechnicalObjectLabel,
  I_TechnicalObject.TechObjIsEquipOrFuncnlLoc AS IsEquipOrFuncnlLocForEdit,
  I_TechnicalObject.TechnicalObject AS TechnicalObjectForEdit,
  I_TechnicalObject.TechnicalObjectCategory AS TechnicalObjectCategory,
  I_TechnicalObject.Equipment AS Equipment,
  I_TechnicalObject.FunctionalLocation AS FunctionalLocation,
  I_TechnicalObject.TechnicalObjectType AS TechnicalObjectType,
  I_TechnicalObject.CreatedByUser AS CreatedByUser,
  I_TechnicalObject.CreationDate AS CreationDate,
  I_TechnicalObject.LastChangedByUser AS LastChangedByUser,
  I_TechnicalObject.LastChangeDate AS LastChangeDate,
  I_TechnicalObject.AssetManufacturerName AS AssetManufacturerName,
  I_TechnicalObject.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_TechnicalObject.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_TechnicalObject.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  I_TechnicalObject.CatalogProfile AS CatalogProfile,
  I_TechnicalObject.AuthorizationGroup AS AuthorizationGroup,
  I_TechnicalObject.WorkCenterInternalID AS WorkCenterInternalID,
  I_TechnicalObject.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_TechnicalObject.MaintObjectLocAcctAssgmtNmbr AS MaintObjectLocAcctAssgmtNmbr,
  I_TechnicalObject.ManufacturerCountry AS ManufacturerCountry,
  I_TechnicalObject.ConstructionYear AS ConstructionYear,
  I_TechnicalObject.ConstructionMonth AS ConstructionMonth,
  I_TechnicalObject.AcquisitionDate AS AcquisitionDate,
  I_TechnicalObject.Currency AS Currency,
  I_TechnicalObject.AcquisitionValue AS AcquisitionValue,
  I_TechnicalObject.TechnicalObjectSortCode AS TechnicalObjectSortCode,
  I_TechnicalObject.TechObjectSortCodeSearchable AS TechObjectSortCodeSearchable,
  I_TechnicalObject.MaintObjectInternalID AS MaintObjectInternalID,
  I_TechnicalObject.IsDeleted AS IsDeleted,
  I_TechnicalObject.SizeOrDimensionText AS SizeOrDimensionText,
  I_TechnicalObject.InventoryNumber AS InventoryNumber,
  I_TechnicalObject.GrossWeight AS GrossWeight,
  I_TechnicalObject.GrossWeightUnit AS GrossWeightUnit,
  I_TechnicalObject.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  I_TechnicalObject.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  I_TechnicalObject.TechnicalObjectDescription AS TechnicalObjectDescription,
  I_TechnicalObject.TechnicalObjectHasLongText AS TechnicalObjectHasLongText,
  I_TechnicalObject.SuperiorTechnicalObject AS SuperiorTechnicalObject,
  I_TechnicalObject.SuperiorTechnicalObjectLabel AS SuperiorTechnicalObjectLabel,
  I_TechnicalObject.SuperiorTechnicalObjectName AS SuperiorTechnicalObjectName,
  I_TechnicalObject.SuperiorObjIsEquipOrFuncnlLoc AS SuperiorObjIsEquipOrFuncnlLoc,
  _CustWrntyObjAssgmt.TechObjCustomerMasterWarranty AS TechObjCustomerMasterWarranty,
  _CustWrntyObjAssgmt.TechObjCustWarrantyStartDate AS TechObjCustWarrantyStartDate,
  _CustWrntyObjAssgmt.TechObjCustWarrantyEndDate AS TechObjCustWarrantyEndDate,
  _CustWrntyObjAssgmt.TechObjIsCustWarrantyPassedOn AS TechObjIsCustWarrantyPassedOn,
  _CustWrntyObjAssgmt.TechObjIsCustWarrantyInherited AS TechObjIsCustWarrantyInherited,
  _VndrWrntyObjAssgmt.TechObjSupplierMasterWarranty AS TechObjSupplierMasterWarranty,
  _VndrWrntyObjAssgmt.TechObjSuplrWarrantyStartDate AS TechObjSuplrWarrantyStartDate,
  _VndrWrntyObjAssgmt.TechObjSuplrWarrantyEndDate AS TechObjSuplrWarrantyEndDate,
  _VndrWrntyObjAssgmt.TechObjIsSuplrWarrantyPassedOn AS TechObjIsSuplrWarrantyPassedOn,
  _VndrWrntyObjAssgmt.TechObjIsSuplrWrntyInherited AS TechObjIsSuplrWrntyInherited,
  I_TechnicalObject._CreatedByUser AS _CreatedByUser,
  I_TechnicalObject._LastChangedByUser AS _LastChangedByUser,
  I_TechnicalObject._WorkCenterType AS _WorkCenterType,
  I_TechnicalObject._WorkCenter AS _WorkCenter,
  I_TechnicalObject._LocationAccountAssignment AS _LocationAccountAssignment,
  I_TechnicalObject._TechnicalObjectType AS _TechnicalObjectType,
  I_TechnicalObject._Equipment AS _Equipment,
  I_TechnicalObject._FunctionalLocation AS _FunctionalLocation,
  I_TechnicalObject._FunctionalLocationLabel AS _FunctionalLocationLabel,
  I_TechnicalObject._MaintenancePlanningPlant AS _MaintenancePlanningPlant,
  I_TechnicalObject._TechObjIsEquipOrFuncnlLoc AS _TechObjIsEquipOrFuncnlLoc,
  I_TechnicalObject._TechnicalObjectText AS _TechnicalObjectText,
  I_TechnicalObject._TechnicalObjectCategory AS _TechnicalObjectCategory,
  I_TechnicalObject._MaintenancePlannerGroup AS _MaintenancePlannerGroup,
  I_TechnicalObject._ManufacturerCountry AS _ManufacturerCountry,
  I_TechnicalObject._Currency AS _Currency,
  I_TechnicalObject._TechnicalObjectHierarchy AS _TechnicalObjectHierarchy,
  I_TechnicalObject._IsDeleted AS _IsDeleted,
  I_TechnicalObject._StatusObjectActiveStatus AS _StatusObjectActiveStatus,
  I_TechnicalObject.Material AS Material,
  I_TechnicalObject.SerialNumber AS SerialNumber
FROM I_TechnicalObject
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]
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]
;