I_FMEAObject

DDL: I_FMEAOBJECT SQL: IFMEAOBJ Type: view BASIC

Objects of an FMEA

I_FMEAObject is a Basic CDS View that provides data about "Objects of an FMEA" in SAP S/4HANA. It reads from 1 data source (plmm_audit_obj) and exposes 8 fields with key field FMEAObjectUUID. It has 4 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
plmm_audit_obj plmm_audit_obj from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_FailureModeEffectAnalysis _FailureModeEffectAnalysis $projection.FMEAHeaderUUID = _FailureModeEffectAnalysis.FMEAHeaderUUID
[0..1] I_FMEAType _FMEAType $projection.FMEAType = _FMEAType.FMEAType
[0..1] I_FMEATypeObjectType _FMEATypeObjectType $projection.FMEAType = _FMEATypeObjectType.FMEAType and $projection.FMEATypeObjectType = _FMEATypeObjectType.FMEATypeObjectType
[1..1] E_FMEAObject _Extension $projection.FMEAObjectUUID = _Extension.FMEAObjectUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IFMEAOBJ view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Objects of an FMEA view
ObjectModel.representativeKey FMEAObjectUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY FMEAObjectUUID
FMEAHeaderUUID
FMEAType plmm_audit_obj audit_type
FMEATypeObjectType plmm_audit_obj object_type
FMEAObject plmm_audit_obj object_value
_FailureModeEffectAnalysis _FailureModeEffectAnalysis
_FMEAType _FMEAType
_FMEATypeObjectType _FMEATypeObjectType 
@AbapCatalog.sqlViewName: 'IFMEAOBJ'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Objects of an FMEA'
@ObjectModel.representativeKey: 'FMEAObjectUUID'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #TRANSACTIONAL } 
define view I_FMEAObject as select from plmm_audit_obj
   association [0..1] to I_FailureModeEffectAnalysis as _FailureModeEffectAnalysis
     on $projection.FMEAHeaderUUID = _FailureModeEffectAnalysis.FMEAHeaderUUID 
   association [0..1] to I_FMEAType as _FMEAType on $projection.FMEAType = _FMEAType.FMEAType 
   association [0..1] to I_FMEATypeObjectType as _FMEATypeObjectType on $projection.FMEAType = _FMEATypeObjectType.FMEAType
                                                          and $projection.FMEATypeObjectType = _FMEATypeObjectType.FMEATypeObjectType
                                                          
   //Extension

   association [1..1] to E_FMEAObject as _Extension on $projection.FMEAObjectUUID = _Extension.FMEAObjectUUID
{
  key cast( plmm_audit_obj.guid as plmt_fmea_node_guid preserving type ) as FMEAObjectUUID,
  cast( plmm_audit_obj.project_guid as plmt_fmea_node_guid preserving type ) as FMEAHeaderUUID,
  plmm_audit_obj.audit_type as FMEAType,
  plmm_audit_obj.object_type as FMEATypeObjectType,
  plmm_audit_obj.object_value as FMEAObject,
  
  //Associations

  _FailureModeEffectAnalysis,
  _FMEAType,
  _FMEATypeObjectType
}

Learn More