I_FMEAHeader

DDL: I_FMEAHEADER SQL: IFMEAHDR Type: view BASIC

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 9 fields with key field FMEAHeaderUUID. It has 2 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
cgpl_project cgpl_project from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _CreatedByUserContactCard $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID
[0..1] I_UserContactCard _LastChangedByUserContactCard $projection.LastChangedByUser = _LastChangedByUserContactCard.ContactCardID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFMEAHDR view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true 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 (9)

KeyFieldSource TableSource FieldDescription
KEY FMEAHeaderUUID
FMEAHeader
CreatedByUser
CreationDate
LastChangedByUser
LastChangedDate
FMEAActualStartDateTime
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard 
@AbapCatalog.sqlViewName: 'IFMEAHDR'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'FMEA Header'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #TRANSACTIONAL }
define view I_FMEAHeader
  as select from cgpl_project
  /* 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

      _CreatedByUserContactCard,
      _LastChangedByUserContactCard
      
}
where
      application = 'AUD'
  and object_type = 'FMA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CGPL_PROJECT"
],
"ASSOCIATED":
[
"I_USERCONTACTCARD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More