I_FMEATaskPartner

DDL: I_FMEATASKPARTNER SQL: IFMEATSKPRTNR Type: view BASIC

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 8 fields with key field FMEAPartnerUUID. It has 3 associations to related views.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
cgpl_project cgpl_project left_outer
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 (11)

NameValueLevelField
AbapCatalog.sqlViewName IFMEATSKPRTNR view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK 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 (8)

KeyFieldSource TableSource FieldDescription
KEY FMEAPartnerUUID
FMEATask cgpl_project external_id
FMEATaskUUID
FMEAPartnerRole plmm_audit_roles role
BusinessPartnerUUID plmm_audit_roles partner_guid
_FMEATask _FMEATask
_BusinessPartner _BusinessPartner
_Employee _Employee 
@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":""
}
}*/

Learn More