I_FMEATASKPARTNER
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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":""
}
}*/