C_MaintAstEquipmentObjectPage

DDL: C_MAINTASTEQUIPMENTOBJECTPAGE Type: view_entity CONSUMPTION Package: IEQM
120 Fields 1 Data Sources 8 Associations 1 OData Services

Tech Obj Hierarchy Equipment details

C_MaintAstEquipmentObjectPage is a Consumption CDS View that provides data about "Tech Obj Hierarchy Equipment details" in SAP S/4HANA. It reads from 1 data source (I_EquipmentTimeSeg) and exposes 120 fields with key field Equipment. It has 8 associations to related views. It is exposed through 1 OData service (EAM_SD_ASSETOVERVIEW). Part of development package IEQM.

Data Sources (1)

SourceAliasJoin Type
I_EquipmentTimeSeg I_EquipmentTimeSeg from

Associations (8)

CardinalityTargetAliasCondition
[0..*] C_MaintAstMaintNotifList _TechObjMaintNotification _TechObjMaintNotification.TechnicalObject = $projection.Equipment and _TechObjMaintNotification.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'
[0..*] C_MaintAstMaintenanceOrderList _TechObjMaintenanceOrder _TechObjMaintenanceOrder.TechnicalObject = $projection.Equipment and _TechObjMaintenanceOrder.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'
[0..1] I_MasterWrntyObjectAssgmt _EquipMatlSrlNmbrCustWrnty $projection.MaintObjectInternalID = _EquipMatlSrlNmbrCustWrnty.ObjectInternalID and _EquipMatlSrlNmbrCustWrnty.WarrantyType = '1'
[0..1] I_MasterWrntyObjectAssgmt _EquipMatlSrlNmbrVndrWrnty $projection.MaintObjectInternalID = _EquipMatlSrlNmbrVndrWrnty.ObjectInternalID and _EquipMatlSrlNmbrVndrWrnty.WarrantyType = '2'
[0..*] C_MaintenanceObjectStatus _SystemStatus _SystemStatus.StatusObject = $projection.MaintObjectInternalID and _SystemStatus.IsUserStatus = ' '
[0..1] I_TextObjectPlainLongText _TextObjectPlainLongText _TextObjectPlainLongText.TextObjectKey = $projection.Equipment and _TextObjectPlainLongText.TextObjectType = 'LTXT' and _TextObjectPlainLongText.TextObjectCategory = 'EQUI' and _TextObjectPlainLongText.Language = $session.system_language
[0..1] I_MaintenancePlannerGroup _MaintenancePlannerGroup _MaintenancePlannerGroup.MaintenancePlannerGroup = $projection.MaintenancePlannerGroup and _MaintenancePlannerGroup.MaintenancePlanningPlant = $projection.MaintenancePlanningPlant association[0..1] to I_TechObjIsEquipOrFuncnlLoc as _TechObjIsEquipOrFuncnlLoc on _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'
[0..*] I_TechObjIsEquipOrFuncnlLocT _TechObjIsEquipOrFuncnlLocDesc _TechObjIsEquipOrFuncnlLocDesc.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Tech Obj Hierarchy Equipment details view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
UI.headerInfo.typeName Technical Objects view
UI.headerInfo.typeNamePlural Technical Objects view
UI.headerInfo.title.value EquipmentName view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.description.value Equipment view
UI.headerInfo.description.type #STANDARD view

OData Services (1)

ServiceBindingVersionContractRelease
EAM_SD_ASSETOVERVIEW EAM_SB_ASSETOVERVIEW V4 C1 NOT_RELEASED

Fields (120)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_Equipment Equipment Equipment check
TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Asset Type
EquipmentName
EquipmentOID I_Equipment EquipmentOID Equip Obj Instce ID
EquipmentCategory I_Equipment EquipmentCategory Object Category
EquipmentCategoryDesc
TechObjIsEquipOrFuncnlLocDesc
TechnicalObjectType I_Equipment TechnicalObjectType Object Type
TechnicalObjectTypeDesc
TechnicalObjectLongText _TextObjectPlainLongText PlainLongText Long Text
MaintObjectFreeDefinedAttrib Sort Field
Plant I_Equipment Plant Valuation Area
Division I_Equipment Division Internal Division ID
StorageLocation I_Equipment StorageLocation StorageLocation
AssetLocation Location
LocationName
CreatedByUser I_Equipment CreatedByUser Created By
LastChangedByUser I_Equipment LastChangedByUser User Name
CreationDate I_Equipment CreationDate Created On
LastChangeDate I_EquipmentTimeSeg LastChangeDate Time Stamp
AssetManufacturerName I_Equipment AssetManufacturerName Manufacturer
ManufacturerPartTypeName I_Equipment ManufacturerPartTypeName Model Number
ManufacturerCountry I_Equipment ManufacturerCountry Mnf. Cntry/Regn
ConstructionYear I_Equipment ConstructionYear
ConstructionMonth I_Equipment ConstructionMonth
AcquisitionDate I_Equipment AcquisitionDate Date Entered
Currency I_Equipment Currency Valuation Crcy
MainWorkCenter Main Work Center
MainWorkCenterText
MaintObjectInternalID I_Equipment MaintObjectInternalID Technical Identification Number
SerialNumber I_Equipment SerialNumber Serial Number
EquipUsagePeriodSequenceNumber I_EquipmentTimeSeg EquipUsagePeriodSequenceNumber ConsecNumber
Material I_Equipment Material Vehicle Model
Customer I_Equipment Customer Sold-to Party
AuthorizationGroup I_Equipment AuthorizationGroup AuthorizGroup
SuperordinateEquipment I_EquipmentTimeSeg SuperordinateEquipment Superior Asset
ManufacturerPartNmbr Manufacturer Part Number
ManufacturerSerialNumber I_Equipment ManufacturerSerialNumber Manufacturer Serial Number
InventoryNumber I_Equipment InventoryNumber
GrossWeightUnit I_Equipment GrossWeightUnit
SizeOrDimensionText I_Equipment SizeOrDimensionText Size/dimensions
LastChangeDateTime I_EquipmentTimeSeg LastChangeDateTime Timestamp
ValidityStartDate I_EquipmentTimeSeg ValidityStartDate Validity Start Date
ValidityEndDate I_EquipmentTimeSeg ValidityEndDate ValidTo
Supplier I_Equipment Supplier Supplier
MaintenancePlannerGroup I_EquipmentTimeSeg MaintenancePlannerGroup Planner Group
MaintenancePlannerGroupName _MaintenancePlannerGroup MaintenancePlannerGroupName Planner Group Name
MaintenancePlanningPlant I_EquipmentTimeSeg MaintenancePlanningPlant Planning Plant
MaintenancePlanningPlantName
MaintenancePlant Maintenance Plant
PlantName
TechObjCustomerMasterWarranty _EquipMatlSrlNmbrCustWrnty MasterWarranty Warranty Number
WarrantyName
TechObjCustWarrantyStartDate _EquipMatlSrlNmbrCustWrnty WarrantyStartDate Warranty Start Date
TechObjCustWarrantyEndDate _EquipMatlSrlNmbrCustWrnty WarrantyEndDate Warranty End Date
TechObjIsCustWarrantyInherited _EquipMatlSrlNmbrCustWrnty WrntyIsPassedOnToChildObject Pass On Warranty
TechObjIsCustWarrantyPassedOn _EquipMatlSrlNmbrCustWrnty WrntyIsInhtdFromSuperiorObject Inherit Warranty
TechObjSupplierMasterWarranty Warranty Number
SupplierWarrantyName
TechObjSuplrWarrantyStartDate _EquipMatlSrlNmbrVndrWrnty WarrantyStartDate Warranty Start Date
TechObjSuplrWarrantyEndDate _EquipMatlSrlNmbrVndrWrnty WarrantyEndDate Warranty End Date
TechObjIsSuplrWarrantyPassedOn _EquipMatlSrlNmbrVndrWrnty WrntyIsInhtdFromSuperiorObject Inherit Warranty
TechObjIsSuplrWrntyInherited _EquipMatlSrlNmbrVndrWrnty WrntyIsPassedOnToChildObject Pass On Warranty
MainWorkCenterPlant Main Work Center Plant
MaintenanceWorkCenterPlantName
CompanyCode Company Code
CompanyCodeName
CostCenter Cost Center
CostCenterName
ControllingArea Controlling Area
ControllingAreaName
BusinessArea Business Area
BusinessAreaName
WBSElementExternalID WBS Element
WBSDescription
StandingOrderNumber Standing Order
MaintenanceOrderDesc
SettlementOrder Settlement Order
OrderDescription
AssetRoom Room
ABCIndicator ABC Indicator
ABCIndicatorDesc
PlantSection Plant Section
WorkCenter Production Work Center
WorkCenterText
BusinessPartnerName1 Name 1
BusinessPartnerName2 Name 2
StreetName Street
HouseNumber Number
PostalCode Postal Code
CityName City
Country Country
CountryName
Region Region
RegionName
PhoneNumber Telephone Number
AddressFaxNumber Fax Number
_CreatedByUser I_Equipment _CreatedByUser
_Customer I_Equipment _Customer
_Currency I_Equipment _Currency
_Division I_Equipment _Division
_EquipmentCategory I_Equipment _EquipmentCategory
_GrossWeightUnit I_Equipment _GrossWeightUnit
_LastChangedByUser I_Equipment _LastChangedByUser
_ManufacturerCountry I_Equipment _ManufacturerCountry
_MasterWrntyObjectAssgmt I_Equipment _MasterWrntyObjectAssgmt
_Material I_Equipment _Material
_Plant I_Equipment _Plant
_PlantMaintenancePartner I_Equipment _PlantMaintenancePartner
_Status I_Equipment _Status
_StorageLocation I_Equipment _StorageLocation
_Supplier I_Equipment _Supplier
_TechnicalObjectType I_Equipment _TechnicalObjectType
_TechObjMaintNotification _TechObjMaintNotification
_TechObjMaintenanceOrder _TechObjMaintenanceOrder
_EquipMatlSrlNmbrCustWrnty _EquipMatlSrlNmbrCustWrnty
_EquipMatlSrlNmbrVndrWrnty _EquipMatlSrlNmbrVndrWrnty
_SystemStatus _SystemStatus
_TextObjectPlainLongText _TextObjectPlainLongText
_TechObjIsEquipOrFuncnlLoc _TechObjIsEquipOrFuncnlLoc

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_MaintAstEquipmentObjectPage.
-- 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 C_MaintAstEquipmentObjectPage AS
SELECT
  I_Equipment.Equipment AS Equipment,
  _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc AS TechObjIsEquipOrFuncnlLoc,
  I_Equipment._EquipmentText[1:Language=$session.system_language].EquipmentName AS EquipmentName,
  I_Equipment.EquipmentOID AS EquipmentOID,
  I_Equipment.EquipmentCategory AS EquipmentCategory,
  I_Equipment._EquipmentCategory._Text[1:Language=$session.system_language].EquipmentCategoryDesc AS EquipmentCategoryDesc,
  cast ( 'Equipment' as eams_tec_obj_type_desc) AS TechObjIsEquipOrFuncnlLocDesc,
  I_Equipment.TechnicalObjectType AS TechnicalObjectType,
  I_Equipment._TechnicalObjectType._Text[1:Language=$session.system_language].TechnicalObjectTypeDesc AS TechnicalObjectTypeDesc,
  _TextObjectPlainLongText.PlainLongText AS TechnicalObjectLongText,
  I_EquipmentTimeSeg._LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  I_Equipment.Plant AS Plant,
  I_Equipment.Division AS Division,
  I_Equipment.StorageLocation AS StorageLocation,
  I_EquipmentTimeSeg._LocationAccountAssignment.AssetLocation AS AssetLocation,
  I_EquipmentTimeSeg._LocationAccountAssignment._Location.LocationName AS LocationName,
  I_Equipment.CreatedByUser AS CreatedByUser,
  I_Equipment.LastChangedByUser AS LastChangedByUser,
  I_Equipment.CreationDate AS CreationDate,
  I_EquipmentTimeSeg.LastChangeDate AS LastChangeDate,
  I_Equipment.AssetManufacturerName AS AssetManufacturerName,
  I_Equipment.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  I_Equipment.ManufacturerCountry AS ManufacturerCountry,
  I_Equipment.ConstructionYear AS ConstructionYear,
  I_Equipment.ConstructionMonth AS ConstructionMonth,
  I_Equipment.AcquisitionDate AS AcquisitionDate,
  I_Equipment.Currency AS Currency,
  I_EquipmentTimeSeg._WorkCenter.WorkCenter AS MainWorkCenter,
  I_EquipmentTimeSeg._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS MainWorkCenterText,
  I_Equipment.MaintObjectInternalID AS MaintObjectInternalID,
  I_Equipment.SerialNumber AS SerialNumber,
  I_EquipmentTimeSeg.EquipUsagePeriodSequenceNumber AS EquipUsagePeriodSequenceNumber,
  I_Equipment.Material AS Material,
  I_Equipment.Customer AS Customer,
  I_Equipment.AuthorizationGroup AS AuthorizationGroup,
  I_EquipmentTimeSeg.SuperordinateEquipment AS SuperordinateEquipment,
  cast ( I_EquipmentTimeSeg.ManufacturerPartNmbr as mfrpn ) AS ManufacturerPartNmbr,
  I_Equipment.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  I_Equipment.InventoryNumber AS InventoryNumber,
  I_Equipment.GrossWeightUnit AS GrossWeightUnit,
  I_Equipment.SizeOrDimensionText AS SizeOrDimensionText,
  I_EquipmentTimeSeg.LastChangeDateTime AS LastChangeDateTime,
  I_EquipmentTimeSeg.ValidityStartDate AS ValidityStartDate,
  I_EquipmentTimeSeg.ValidityEndDate AS ValidityEndDate,
  I_Equipment.Supplier AS Supplier,
  I_EquipmentTimeSeg.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  I_EquipmentTimeSeg.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_EquipmentTimeSeg._MaintenancePlanningPlant.PlantName1 AS MaintenancePlanningPlantName,
  I_EquipmentTimeSeg._LocationAccountAssignment.MaintenancePlant AS MaintenancePlant,
  I_EquipmentTimeSeg._LocationAccountAssignment._MaintenancePlant.PlantName AS PlantName,
  _EquipMatlSrlNmbrCustWrnty.MasterWarranty AS TechObjCustomerMasterWarranty,
  _EquipMatlSrlNmbrCustWrnty._MasterWarranty._MasterWarrantyText[1:Language=$session.system_language].WarrantyName AS WarrantyName,
  _EquipMatlSrlNmbrCustWrnty.WarrantyStartDate AS TechObjCustWarrantyStartDate,
  _EquipMatlSrlNmbrCustWrnty.WarrantyEndDate AS TechObjCustWarrantyEndDate,
  _EquipMatlSrlNmbrCustWrnty.WrntyIsPassedOnToChildObject AS TechObjIsCustWarrantyInherited,
  _EquipMatlSrlNmbrCustWrnty.WrntyIsInhtdFromSuperiorObject AS TechObjIsCustWarrantyPassedOn,
  cast ( _EquipMatlSrlNmbrVndrWrnty.MasterWarranty as mganr ) AS TechObjSupplierMasterWarranty,
  _EquipMatlSrlNmbrVndrWrnty._MasterWarranty._MasterWarrantyText[1:Language=$session.system_language].WarrantyName AS SupplierWarrantyName,
  _EquipMatlSrlNmbrVndrWrnty.WarrantyStartDate AS TechObjSuplrWarrantyStartDate,
  _EquipMatlSrlNmbrVndrWrnty.WarrantyEndDate AS TechObjSuplrWarrantyEndDate,
  _EquipMatlSrlNmbrVndrWrnty.WrntyIsInhtdFromSuperiorObject AS TechObjIsSuplrWarrantyPassedOn,
  _EquipMatlSrlNmbrVndrWrnty.WrntyIsPassedOnToChildObject AS TechObjIsSuplrWrntyInherited,
  I_EquipmentTimeSeg._WorkCenter.Plant AS MainWorkCenterPlant,
  I_EquipmentTimeSeg._WorkCenter._Plant.PlantName AS MaintenanceWorkCenterPlantName,
  I_EquipmentTimeSeg._LocationAccountAssignment.CompanyCode AS CompanyCode,
  I_EquipmentTimeSeg._LocationAccountAssignment._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_EquipmentTimeSeg._LocationAccountAssignment.CostCenter AS CostCenter,
  I_EquipmentTimeSeg._LocationAccountAssignment._CostCenterText[1:Language=$session.system_language].CostCenterName AS CostCenterName,
  I_EquipmentTimeSeg._LocationAccountAssignment.ControllingArea AS ControllingArea,
  I_EquipmentTimeSeg._LocationAccountAssignment._ControllingArea.ControllingAreaName AS ControllingAreaName,
  I_EquipmentTimeSeg._LocationAccountAssignment.BusinessArea AS BusinessArea,
  I_EquipmentTimeSeg._LocationAccountAssignment._BusinessArea._Text[1:Language=$session.system_language].BusinessAreaName AS BusinessAreaName,
  I_EquipmentTimeSeg._LocationAccountAssignment._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  I_EquipmentTimeSeg._LocationAccountAssignment._WBSElementBasicData.WBSDescription AS WBSDescription,
  I_EquipmentTimeSeg._LocationAccountAssignment.StandingOrderNumber AS StandingOrderNumber,
  I_EquipmentTimeSeg._LocationAccountAssignment._StandingOrderNumber.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  I_EquipmentTimeSeg._LocationAccountAssignment.SettlementOrder AS SettlementOrder,
  I_EquipmentTimeSeg._LocationAccountAssignment._SettlementOrder.OrderDescription AS OrderDescription,
  I_EquipmentTimeSeg._LocationAccountAssignment.AssetRoom AS AssetRoom,
  I_EquipmentTimeSeg._LocationAccountAssignment.ABCIndicator AS ABCIndicator,
  I_EquipmentTimeSeg._LocationAccountAssignment._ABCIndicator._Text[1:Language=$session.system_language].ABCIndicatorDesc AS ABCIndicatorDesc,
  I_EquipmentTimeSeg._LocationAccountAssignment.PlantSection AS PlantSection,
  I_EquipmentTimeSeg._LocationAccountAssignment._WorkCenter.WorkCenter AS WorkCenter,
  I_EquipmentTimeSeg._LocationAccountAssignment._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  I_EquipmentTimeSeg._LocationAccountAssignment._Address2.OrganizationName1 AS BusinessPartnerName1,
  I_EquipmentTimeSeg._LocationAccountAssignment._Address2.OrganizationName2 AS BusinessPartnerName2,
  I_EquipmentTimeSeg._LocationAccountAssignment._Address2.StreetName AS StreetName,
  I_EquipmentTimeSeg._LocationAccountAssignment._Address2.HouseNumber AS HouseNumber,
  I_EquipmentTimeSeg._LocationAccountAssignment._Address2.PostalCode AS PostalCode,
  I_EquipmentTimeSeg._LocationAccountAssignment._Address2.CityName AS CityName,
  I_EquipmentTimeSeg._LocationAccountAssignment._Address2.Country AS Country,
  I_EquipmentTimeSeg._LocationAccountAssignment._Address2._Country._Text[1:Language=$session.system_language].CountryName AS CountryName,
  I_EquipmentTimeSeg._LocationAccountAssignment._Address2.Region AS Region,
  I_EquipmentTimeSeg._LocationAccountAssignment._Address2._Region._RegionText[1:Language=$session.system_language].RegionName AS RegionName,
  I_EquipmentTimeSeg._LocationAccountAssignment._PhoneNumber.PhoneAreaCodeSubscriberNumber AS PhoneNumber,
  I_EquipmentTimeSeg._LocationAccountAssignment._FaxNumber.FaxAreaCodeSubscriberNumber AS AddressFaxNumber,
  I_Equipment._CreatedByUser AS _CreatedByUser,
  I_Equipment._Customer AS _Customer,
  I_Equipment._Currency AS _Currency,
  I_Equipment._Division AS _Division,
  I_Equipment._EquipmentCategory AS _EquipmentCategory,
  I_Equipment._GrossWeightUnit AS _GrossWeightUnit,
  I_Equipment._LastChangedByUser AS _LastChangedByUser,
  I_Equipment._ManufacturerCountry AS _ManufacturerCountry,
  I_Equipment._MasterWrntyObjectAssgmt AS _MasterWrntyObjectAssgmt,
  I_Equipment._Material AS _Material,
  I_Equipment._Plant AS _Plant,
  I_Equipment._PlantMaintenancePartner AS _PlantMaintenancePartner,
  I_Equipment._Status AS _Status,
  I_Equipment._StorageLocation AS _StorageLocation,
  I_Equipment._Supplier AS _Supplier,
  I_Equipment._TechnicalObjectType AS _TechnicalObjectType
FROM I_EquipmentTimeSeg
LEFT OUTER JOIN C_MaintAstMaintNotifList AS _TechObjMaintNotification ON _TechObjMaintNotification.TechnicalObject = Equipment AND _TechObjMaintNotification.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'  -- association [0..*]
LEFT OUTER JOIN C_MaintAstMaintenanceOrderList AS _TechObjMaintenanceOrder ON _TechObjMaintenanceOrder.TechnicalObject = Equipment AND _TechObjMaintenanceOrder.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'  -- association [0..*]
LEFT OUTER JOIN I_MasterWrntyObjectAssgmt AS _EquipMatlSrlNmbrCustWrnty ON MaintObjectInternalID = _EquipMatlSrlNmbrCustWrnty.ObjectInternalID AND _EquipMatlSrlNmbrCustWrnty.WarrantyType = '1'  -- association [0..1]
LEFT OUTER JOIN I_MasterWrntyObjectAssgmt AS _EquipMatlSrlNmbrVndrWrnty ON MaintObjectInternalID = _EquipMatlSrlNmbrVndrWrnty.ObjectInternalID AND _EquipMatlSrlNmbrVndrWrnty.WarrantyType = '2'  -- association [0..1]
LEFT OUTER JOIN C_MaintenanceObjectStatus AS _SystemStatus ON _SystemStatus.StatusObject = MaintObjectInternalID AND _SystemStatus.IsUserStatus = ' '  -- association [0..*]
LEFT OUTER JOIN I_TextObjectPlainLongText AS _TextObjectPlainLongText ON _TextObjectPlainLongText.TextObjectKey = Equipment AND _TextObjectPlainLongText.TextObjectType = 'LTXT' AND _TextObjectPlainLongText.TextObjectCategory = 'EQUI' AND _TextObjectPlainLongText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlannerGroup AS _MaintenancePlannerGroup ON _MaintenancePlannerGroup.MaintenancePlannerGroup = MaintenancePlannerGroup AND _MaintenancePlannerGroup.MaintenancePlanningPlant = MaintenancePlanningPlant association[0..1] to I_TechObjIsEquipOrFuncnlLoc as _TechObjIsEquipOrFuncnlLoc on _TechObjIsEquipOrFuncnlLoc.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'  -- association [0..1]
LEFT OUTER JOIN I_TechObjIsEquipOrFuncnlLocT AS _TechObjIsEquipOrFuncnlLocDesc ON _TechObjIsEquipOrFuncnlLocDesc.TechObjIsEquipOrFuncnlLoc = 'EAMS_EQUI'  -- association [0..*]
;

Learn More