I_FMEALONGTEXT

CDS View

Long Text for FMEA

I_FMEALONGTEXT is a CDS View in S/4HANA. Long Text for FMEA. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_FMEADescriptionTP view_entity from TRANSACTIONAL Trans. Proc. of FMEA Detailed Desc.
I_FMEANodeDescriptionTextTP view_entity from TRANSACTIONAL FMEA Node Description - TP
I_FMEATaskDescriptionTextTP view_entity from TRANSACTIONAL FMEA Task Description - TP 
@AbapCatalog.sqlViewName: 'IFMEALTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Long Text for FMEA'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel: {
    dataCategory: #TEXT,
    usageType: {
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L,
        serviceQuality: #C
    }
}
define view I_FMEALongText as select from plmm_audit_ltext 
    association [0..1] to I_FMEANodeHierarchy as _FMEANodeHierarchy
    on $projection.FMEANodeUUID = _FMEANodeHierarchy.FMEANodeUUID
    association [1..1] to I_Language as _Language            
      on $projection.Language = _Language.Language
{
    @ObjectModel.foreignKey.association: '_FMEANodeHierarchy'
    key cast( guid as plmt_fmea_node_guid preserving type ) as FMEANodeUUID,
    key counter as LongTextInternalNumber,
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key langu as Language,
    textid as LongTextID,
  
    content     as FMEALongText, 
    created_by  as LongTextCreatedByUser,
    created_at  as LongTextCreatedAt,
    changed_by  as LongTextLastChangedByUser,
    changed_at  as LongTextLastChangedAt,
    
    //Association

    _FMEANodeHierarchy,
    _Language
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PLMM_AUDIT_LTEXT"
],
"ASSOCIATED":
[
"I_FMEANODEHIERARCHY",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More