I_FMEAHeader

DDL: I_FMEAHEADER Type: view_entity BASIC Package: PLM_FMEA

FMEA Header

I_FMEAHeader is a Basic CDS View that provides data about "FMEA Header" in SAP S/4HANA. It reads from 1 data source (cgpl_project) and exposes 10 fields with key field FMEAHeaderUUID. It has 3 associations to related views. Part of development package PLM_FMEA.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
cgpl_project cgpl_project from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_FMEAText _FMEAText $projection.FMEAHeaderUUID = _FMEAText.FMEAHeaderUUID
[0..1] I_UserContactCard _CreatedByUserContactCard $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID
[0..1] I_UserContactCard _LastChangedByUserContactCard $projection.LastChangedByUser = _LastChangedByUserContactCard.ContactCardID

Annotations (6)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label FMEA Header view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY FMEAHeaderUUID
FMEAHeader
CreatedByUser
CreationDate
LastChangedByUser
LastChangedDate
FMEAActualStartDateTime
_FMEAText _FMEAText
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'FMEA Header'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #TRANSACTIONAL }
define view entity I_FMEAHeader
  as select from cgpl_project
  
  association [0..*] to I_FMEAText as _FMEAText on $projection.FMEAHeaderUUID = _FMEAText.FMEAHeaderUUID
  /* Contact Card */
  association [0..1] to I_UserContactCard as _CreatedByUserContactCard     on $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID
  association [0..1] to I_UserContactCard as _LastChangedByUserContactCard on $projection.LastChangedByUser = _LastChangedByUserContactCard.ContactCardID

{
  key cast( guid as plmt_fmea_node_guid preserving type )                          as FMEAHeaderUUID,
      cast( external_id as plmt_tv_fmea_id preserving type )                       as FMEAHeader,
      @ObjectModel.foreignKey.association: '_CreatedByUserContactCard'
      cast( cgpl_project.created_by as plmt_created_by preserving type )           as CreatedByUser,
      @Semantics.systemDate.createdAt: true
      cast( cgpl_project.created_on as plmt_created_on preserving type )           as CreationDate,
      @ObjectModel.foreignKey.association: '_LastChangedByUserContactCard'
      cast( cgpl_project.changed_by as plmt_changed_by preserving type )           as LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      cast( cgpl_project.changed_on as plmt_changed_on preserving type )           as LastChangedDate,
      cast( cgpl_project.actualstart as plmt_actualstartdatetime preserving type ) as FMEAActualStartDateTime,

      //Associations

      _FMEAText,
      _CreatedByUserContactCard,
      _LastChangedByUserContactCard
      
}
where
      application = 'AUD'
  and object_type = 'FMA'

Learn More