I_FMEATASKPARTNER

CDS View

Partner of FMEA Task

I_FMEATASKPARTNER is a CDS View in S/4HANA. Partner of FMEA Task. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FMEATaskPartnerTP view_entity from TRANSACTIONAL Transact. Proc. for FMEA Task Partner
@AbapCatalog.sqlViewName: 'IFMEATSKPRTNR'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Partner of FMEA Task'
@ObjectModel.representativeKey: 'FMEAPartnerUUID'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #TRANSACTIONAL }
define view I_FMEATaskPartner as select from plmm_audit_roles
  left outer 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,
  
  //Association

  _FMEATask,
  _BusinessPartner,
  _Employee
}
where cgpl_project.object_type = 'COR'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CGPL_PROJECT",
"PLMM_AUDIT_ROLES"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_BUSINESSUSER",
"I_FMEATASK"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/