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_entity inner BASIC Text of FMEA Node

Fields (1)

KeyField CDS FieldsUsed in Views
FMEANode FMEANode 1 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'FMEA Node root'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #TRANSACTIONAL } 
define view entity 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'

Learn More