I_FMEAHEADER

CDS View

FMEA Header

I_FMEAHEADER is a CDS View in S/4HANA. FMEA Header. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FMEATextTP view_entity inner TRANSACTIONAL Trans. Processing for Text of FMEA 
@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