I_FMEANodeAssignment

DDL: I_FMEANODEASSIGNMENT SQL: IFMEANDRT Type: view BASIC

FMEA Node root

I_FMEANodeAssignment is a Basic CDS View that provides data about "FMEA Node root" in SAP S/4HANA. It reads from 1 data source (cgpl_task) and exposes 9 fields with key field FMEANodeUUID. It has 2 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
cgpl_task cgpl_task 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 IFMEANDRT 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 Node root view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY FMEANodeUUID
FMEANode external_id
FMEAHeaderUUID
CreatedByUser created_by
CreationDate created_on
LastChangedByUser changed_by
LastChangedDate changed_on
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard 
@AbapCatalog.sqlViewName: 'IFMEANDRT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'FMEA Node root'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #TRANSACTIONAL } 
define view I_FMEANodeAssignment as select from cgpl_task 
  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 FMEANodeUUID,
    external_id as FMEANode,
    cast( project_guid as plmt_fmea_node_guid preserving type ) as FMEAHeaderUUID,
    created_by as CreatedByUser,
    created_on as CreationDate,
    changed_by as LastChangedByUser,
    changed_on as LastChangedDate,
    
    //Associations

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

Learn More