@EndUserText.label: 'Equipment Data'
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IEQUIPMENTATTR'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'Equipment'
@AccessControl: {
authorizationCheck: #CHECK,
privilegedAssociations: ['_Location', '_Address', '_EquipmentHierarchyNode','_LOCATIONACCOUNTASSIGNMENT',
'_Address2'] // 2302 CE - Consider I_Address_2
}
@Analytics: {
dataCategory: #DIMENSION,
dataExtraction: {
enabled: true,
delta.byElement: {
name: 'LastChangeDateTime'
}
}
}
@ObjectModel: {
usageType: {
dataClass: #MASTER,
serviceQuality: #C,
sizeCategory: #L
},
supportedCapabilities: [ #EXTRACTION_DATA_SOURCE ]
}
@Metadata: {
ignorePropagatedAnnotations,
allowExtensions
}
// A more comprehensive view for equipment data, created as a replacement for BW extractor 0EQUIPMENT_ATTR
define view I_EquipmentData
as select from I_EquipmentTimeSeg
inner join I_Equipment on I_Equipment.Equipment = I_EquipmentTimeSeg.Equipment
association [0..1] to I_WorkCenterBySemanticKey as _MainWorkCenterBySemanticKey on $projection.MainWorkCenter = _MainWorkCenterBySemanticKey.WorkCenter
and $projection.MainWorkCenterPlant = _MainWorkCenterBySemanticKey.Plant
association [0..1] to I_WorkCenterBySemanticKey as _WorkCenterBySemanticKey on $projection.workcenter = _WorkCenterBySemanticKey.WorkCenter
and $projection.WorkCenterPlant = _WorkCenterBySemanticKey.Plant
association [0..1] to I_WorkCenter as _WorkCenter on $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
and _WorkCenter.WorkCenterTypeCode = 'A'
association [0..1] to I_Plant as _WorkCenterPlant on $projection.WorkCenterPlant = _WorkCenterPlant.Plant
association [0..1] to I_FunctionalLocationData as _FunctionalLocation on $projection.functionallocation = _FunctionalLocation.FunctionalLocation
association [0..1] to I_Indicator as _EquipmentIsMarkedForDeletion on $projection.EquipmentIsMarkedForDeletion = _EquipmentIsMarkedForDeletion.IndicatorValue
association [0..*] to I_EquipmentHierarchyNode as _EquipmentHierarchyNode on $projection.Equipment = _EquipmentHierarchyNode.Equipment
association [0..1] to I_WBSElementBasicData as _WBSElementBasicData on $projection.WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID
association [0..*] to I_EquipmentText as _EquipmentText on $projection.Equipment = _EquipmentText.Equipment
-- Extensions, do not expose as association:
association [0..1] to E_Equipment as _EquipmentExtension on _EquipmentExtension.Equipment = $projection.Equipment
{
@ObjectModel.text.association: '_EquipmentText'
@ObjectModel.hierarchy.association: '_EquipmentHierarchyNode'
key I_EquipmentTimeSeg.Equipment,
@Semantics.businessDate.to: true
key I_EquipmentTimeSeg.ValidityEndDate,
I_EquipmentTimeSeg.EquipUsagePeriodSequenceNumber,
/* Fields, as they appear in InfoObject 0EQUIPMENT */
@ObjectModel.foreignKey.association: '_ABCIndicator'
I_EquipmentTimeSeg._LocationAccountAssignment.ABCIndicator,
@Semantics.amount.currencyCode: 'Currency'
I_Equipment.AcquisitionValue,
// @ObjectModel.foreignKey.association: '_Address'
@ObjectModel.foreignKey.association: '_Address2' //2302 CE - Consider I_Address_2
I_EquipmentTimeSeg._LocationAccountAssignment.AddressID,
@ObjectModel.foreignKey.association: '_MasterFixedAsset'
I_EquipmentTimeSeg._LocationAccountAssignment.MasterFixedAsset,
@ObjectModel.foreignKey.association: '_CompanyCode'
I_EquipmentTimeSeg._LocationAccountAssignment.CompanyCode,
@ObjectModel.foreignKey.association: '_CostCenter'
I_EquipmentTimeSeg._LocationAccountAssignment.CostCenter,
@ObjectModel.foreignKey.association: '_ControllingArea'
I_EquipmentTimeSeg._LocationAccountAssignment.ControllingArea,
@Semantics.currencyCode:true
I_Equipment.Currency,
I_Equipment.OperationStartDate,
@ObjectModel.foreignKey.association: '_TechnicalObjectType'
I_Equipment.TechnicalObjectType,
@ObjectModel.foreignKey.association: '_FunctionalLocation'
I_EquipmentTimeSeg._LocationAccountAssignment.FunctionalLocation,
I_Equipment.InventoryNumber,
@ObjectModel.foreignKey.association: '_Location'
I_EquipmentTimeSeg._LocationAccountAssignment.AssetLocation,
@ObjectModel.foreignKey.association: '_MaintenancePlant'
I_EquipmentTimeSeg._LocationAccountAssignment.MaintenancePlant,
I_EquipmentTimeSeg._LocationAccountAssignment.AssetRoom,
@ObjectModel.foreignKey.association: '_Material'
I_Equipment.Material,
@ObjectModel.foreignKey.association: '_MaintenancePlanningPlant'
I_EquipmentTimeSeg.MaintenancePlanningPlant,
@ObjectModel.foreignKey.association: '_PlantSection'
I_EquipmentTimeSeg._LocationAccountAssignment.PlantSection,
I_EquipmentTimeSeg.MaintenancePlannerGroup,
cast( I_EquipmentTimeSeg._LocationAccountAssignment._WBSElementBasicData.WBSElement as ps_posid preserving type ) as WBSElement,
@ObjectModel.foreignKey.association: '_EquipmentCategory'
I_Equipment.EquipmentCategory,
@Semantics.systemDate.createdAt: true
I_Equipment.CreationDate,
@ObjectModel.foreignKey.association: '_Plant'
I_Equipment.Plant,
@ObjectModel.foreignKey.association: '_MainWorkCenter'
I_EquipmentTimeSeg.WorkCenterInternalID as MainWorkCenterInternalID,
@ObjectModel.foreignKey.association: '_MainWorkCenterBySemanticKey'
cast( I_EquipmentTimeSeg._WorkCenter.WorkCenter as gewrk preserving type ) as MainWorkCenter,
@ObjectModel.foreignKey.association: '_MainWorkCenterPlant'
cast( I_EquipmentTimeSeg._WorkCenter.Plant as wergw preserving type ) as MainWorkCenterPlant,
@ObjectModel.foreignKey.association: '_SettlementOrder'
I_EquipmentTimeSeg._LocationAccountAssignment.SettlementOrder,
@ObjectModel.foreignKey.association: '_WorkCenter'
I_EquipmentTimeSeg._LocationAccountAssignment.WorkCenterInternalID,
@ObjectModel.foreignKey.association: '_WorkCenterBySemanticKey'
I_EquipmentTimeSeg._LocationAccountAssignment._WorkCenter.WorkCenter,
@ObjectModel.foreignKey.association: '_WorkCenterPlant'
I_EquipmentTimeSeg._LocationAccountAssignment._WorkCenter.Plant as WorkCenterPlant,
/* Additional fields */
/* If record is latest record (today's), then the timestamp comes from equipment.
This is because timestamp on equipment catches changes done to EQUI AND EQUZ. Example: AcquisitionValue changed
If record is an old record (i.e. its validity end date is not in the future), then that time segments timestamp is used.
This will also prevent any later changes of EQUI to be detected by ODP extractor. However this was discussed to be intended. */
@Semantics.systemDateTime.lastChangedAt: true
case when I_EquipmentTimeSeg.ValidityEndDate = '99991231' then I_Equipment.LastChangeDateTime
else I_EquipmentTimeSeg.LastChangeDateTime end as LastChangeDateTime,
@ObjectModel.foreignKey.association: '_EquipmentIsMarkedForDeletion'
--@Semantics.booleanIndicator: true
cast( case when _Status[ StatusCode = 'I0076' and StatusIsInactive = '' ].StatusCode is not null then 'X' else ' ' end as eam_is_deleted preserving type ) as EquipmentIsMarkedForDeletion,
//I_EquipmentTimeSeg
I_EquipmentTimeSeg.NextEquipUsagePeriodSqncNmbr,
I_EquipmentTimeSeg.MaintObjectLocAcctAssgmtNmbr,
@ObjectModel.foreignKey.association: '_WorkCenterType'
I_EquipmentTimeSeg.WorkCenterTypeCode,
I_EquipmentTimeSeg.CatalogProfile,
I_EquipmentTimeSeg.SuperordinateEquipment,
I_EquipmentTimeSeg.TechnicalObjectSortCode,
@ObjectModel.foreignKey.association: '_ConstructionMaterial'
I_EquipmentTimeSeg.ConstructionMaterial,
@Semantics.businessDate.from: true
I_EquipmentTimeSeg.ValidityStartDate,
I_EquipmentTimeSeg.ValidityEndTime,
I_EquipmentTimeSeg.ManufacturerPartNmbr,
//I_Equipment
@ObjectModel.foreignKey.association: '_Division'
I_Equipment.Division,
@ObjectModel.foreignKey.association: '_StorageLocation'
I_Equipment.StorageLocation,
I_Equipment.AssetManufacturerName,
I_Equipment.ManufacturerPartTypeName,
@Semantics.address.country: true
@ObjectModel.foreignKey.association: '_ManufacturerCountry'
I_Equipment.ManufacturerCountry,
I_Equipment.ConstructionYear,
I_Equipment.ConstructionMonth,
I_Equipment.AcquisitionDate,
I_Equipment.MaintObjectInternalID,
I_Equipment.SerialNumber,
@ObjectModel.foreignKey.association: '_Customer'
I_Equipment.Customer,
I_Equipment.AuthorizationGroup,
@Semantics.quantity.unitOfMeasure: 'GrossWeightUnit'
I_Equipment.GrossWeight,
@ObjectModel.foreignKey.association: '_GrossWeightUnit'
@Semantics.unitOfMeasure: true
I_Equipment.GrossWeightUnit,
I_Equipment.SizeOrDimensionText,
I_Equipment.Batch,
@ObjectModel.foreignKey.association: '_Supplier'
I_Equipment.Supplier,
//Adding EndOfUseDate field - 2308
I_Equipment.EquipmentEndOfUseDate,
//I_LocationAccountAssignment
_LocationAccountAssignment.MaintObjectFreeDefinedAttrib,
_LocationAccountAssignment.BusinessArea,
@ObjectModel.foreignKey.association: '_WBSElementBasicData'
cast( I_EquipmentTimeSeg._LocationAccountAssignment.WBSElementInternalID as ps_psp_pnr preserving type ) as WBSElementInternalID,
I_EquipmentTimeSeg._LocationAccountAssignment.FixedAsset,
//I_LinearAssetManagementData
cast( cast( I_Equipment._LinearAssetManagementData.LinearDataStartPoint as abap.dec(11, 3) ) as eaml_start_point ) as LinearDataStartPoint,
cast( cast( I_Equipment._LinearAssetManagementData.LinearDataEndPoint as abap.dec(11, 3) ) as eaml_end_point ) as LinearDataEndPoint,
@Semantics.quantity.unitOfMeasure: 'LinearDataUnitOfMeasure'
I_Equipment._LinearAssetManagementData.LinearDataLength,
@Semantics.unitOfMeasure: true
I_Equipment._LinearAssetManagementData.LinearDataUnitOfMeasure,
/* Associations */
//I_EquipmentTimeSeg
I_EquipmentTimeSeg._WorkCenter as _MainWorkCenter,
I_EquipmentTimeSeg._Equipment,
I_EquipmentTimeSeg._ConstructionMaterial,
I_EquipmentTimeSeg._LocationAccountAssignment,
I_EquipmentTimeSeg._MaintenancePlanningPlant,
I_EquipmentTimeSeg._WorkCenterType,
I_EquipmentTimeSeg._WorkCenter._Plant as _MainWorkCenterPlant,
//I_Equipment
I_Equipment._ManufacturerCountry,
I_Equipment._StorageLocation,
I_Equipment._Division,
I_Equipment._EquipmentCategory,
I_Equipment._Material,
I_Equipment._Plant,
I_Equipment._Currency,
I_Equipment._TechnicalObjectType,
I_Equipment._GrossWeightUnit,
I_Equipment._Customer,
I_Equipment._Supplier,
//I_LocationAccountAssignment
I_EquipmentTimeSeg._LocationAccountAssignment._ABCIndicator,
@API.element.releaseState: #DEPRECATED
@API.element.successor: '_Address2'
I_EquipmentTimeSeg._LocationAccountAssignment._Address,
I_EquipmentTimeSeg._LocationAccountAssignment._Address2, //Added : 2302 CE - Consider fields from I_Address_2
I_EquipmentTimeSeg._LocationAccountAssignment._CompanyCode,
I_EquipmentTimeSeg._LocationAccountAssignment._ControllingArea,
I_EquipmentTimeSeg._LocationAccountAssignment._CostCenter,
I_EquipmentTimeSeg._LocationAccountAssignment._Location,
I_EquipmentTimeSeg._LocationAccountAssignment._MaintenancePlant,
I_EquipmentTimeSeg._LocationAccountAssignment._MasterFixedAsset,
I_EquipmentTimeSeg._LocationAccountAssignment._PlantSection,
I_EquipmentTimeSeg._LocationAccountAssignment._SettlementOrder,
_WBSElementBasicData,
_WorkCenterBySemanticKey,
_WorkCenterPlant,
_WorkCenter,
_MainWorkCenterBySemanticKey,
_FunctionalLocation,
_EquipmentHierarchyNode,
_EquipmentIsMarkedForDeletion,
_EquipmentText
}
where
I_EquipmentTimeSeg.EquipUsagePeriodSequenceNumber = '001'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EQUIPMENT",
"I_EQUIPMENTTIMESEG",
"I_LINEARASSETMANAGEMENTDATA",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_STATUSOBJECTSTATUS",
"I_WBSELEMENTBASICDATA",
"I_WORKCENTER"
],
"ASSOCIATED":
[
"E_EQUIPMENT",
"I_ABCINDICATOR",
"I_ADDRESS",
"I_ADDRESSDEFAULTREPRESENTATION",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COUNTRY",
"I_CURRENCY",
"I_CUSTOMER",
"I_DIVISION",
"I_EQUIPMENT",
"I_EQUIPMENTCATEGORY",
"I_EQUIPMENTHIERARCHYNODE",
"I_EQUIPMENTTEXT",
"I_FUNCTIONALLOCATIONDATA",
"I_INDICATOR",
"I_LOCATION",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEPLANPLANT",
"I_MASTERFIXEDASSET",
"I_MATERIAL",
"I_ORDER",
"I_PLANT",
"I_PLANTSECTION",
"I_PRODUCT",
"I_STORAGELOCATION",
"I_SUPPLIER",
"I_TECHNICALOBJECTTYPE",
"I_UNITOFMEASURE",
"I_WBSELEMENTBASICDATA",
"I_WORKCENTER",
"I_WORKCENTERBYSEMANTICKEY",
"I_WORKCENTERTYPE"
],
"BASE":
[
"I_EQUIPMENT",
"I_EQUIPMENTTIMESEG",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_WORKCENTER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/