I_FMEANODEASSIGNMENT

CDS View

FMEA Node root

I_FMEANODEASSIGNMENT is a CDS View in S/4HANA. FMEA Node root. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FMEANodeText view inner BASIC Text of FMEA Node

Fields (1)

KeyField CDS FieldsUsed in Views
FMEANode FMEANode 1 
@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