I_FMEATaskPartner

DDL: I_FMEATASKPARTNER Type: view_entity BASIC Package: PLM_FMEA

Partner of FMEA Task

I_FMEATaskPartner is a Basic CDS View that provides data about "Partner of FMEA Task" in SAP S/4HANA. It reads from 2 data sources (cgpl_project, plmm_audit_roles) and exposes 11 fields with key field FMEAPartnerUUID. It has 3 associations to related views. Part of development package PLM_FMEA.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
cgpl_project cgpl_project inner
plmm_audit_roles plmm_audit_roles from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_FMEATask _FMEATask $projection.FMEATaskUUID = _FMEATask.FMEATaskUUID
[0..1] I_BusinessUser _Employee $projection.BusinessPartnerUUID = _Employee.BusinessPartnerUUID
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID

Annotations (8)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Partner of FMEA Task view
ObjectModel.representativeKey FMEAPartnerUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY FMEAPartnerUUID
FMEATask cgpl_project external_id
FMEATaskUUID
FMEAPartnerRole plmm_audit_roles role
BusinessPartnerUUID plmm_audit_roles partner_guid
FMEAPartnerUUIDHex
BusinessPartnerUUIDHex
FMEAPartnerSortNumber plmm_audit_roles role_sortnr
_FMEATask _FMEATask
_BusinessPartner _BusinessPartner
_Employee _Employee 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Partner of FMEA Task'
@ObjectModel.representativeKey: 'FMEAPartnerUUID'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #TRANSACTIONAL }
define view entity I_FMEATaskPartner
  as select from plmm_audit_roles
    inner join   cgpl_project on plmm_audit_roles.object_guid = cgpl_project.guid
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] } */
  association [0..1] to I_FMEATask        as _FMEATask        on $projection.FMEATaskUUID = _FMEATask.FMEATaskUUID
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] } */
  association [0..1] to I_BusinessUser    as _Employee        on $projection.BusinessPartnerUUID = _Employee.BusinessPartnerUUID
  /*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] } */
  association [0..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartnerUUID = _BusinessPartner.BusinessPartnerUUID


{
  key cast( plmm_audit_roles.guid as plmt_fmea_node_guid preserving type )        as FMEAPartnerUUID,
      cgpl_project.external_id                                                    as FMEATask,
      cast( plmm_audit_roles.object_guid as plmt_fmea_node_guid preserving type ) as FMEATaskUUID,
      plmm_audit_roles.role                                                       as FMEAPartnerRole,
      plmm_audit_roles.partner_guid                                               as BusinessPartnerUUID,
      bintohex( plmm_audit_roles.guid )                                           as FMEAPartnerUUIDHex,
      bintohex( plmm_audit_roles.partner_guid )                                   as BusinessPartnerUUIDHex,
      plmm_audit_roles.role_sortnr                                                as FMEAPartnerSortNumber,
      //Association

      _FMEATask,
      _BusinessPartner,
      _Employee
}
where cgpl_project.object_type = 'COR'

Learn More