I_FMEAText

DDL: I_FMEATEXT SQL: IFMEATXT Type: view BASIC

Text of FMEA

I_FMEAText is a Basic CDS View that provides data about "Text of FMEA" in SAP S/4HANA. It reads from 1 data source (cgpl_text) and exposes 4 fields with key fields Language, FMEAHeaderUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
cgpl_text cgpl_text from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FailureModeEffectAnalysis _FailureModeEffectAnalysis $projection.FMEAHeaderUUID = _FailureModeEffectAnalysis.FMEAHeaderUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFMEATXT view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Text of FMEA view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey FMEAHeaderUUID view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Language langu
KEY FMEAHeaderUUID
FMEADescription text1
_FailureModeEffectAnalysis _FailureModeEffectAnalysis
@AbapCatalog.sqlViewName: 'IFMEATXT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Text of FMEA'
@ObjectModel: {
    usageType: { 
        serviceQuality: #B,
        sizeCategory: #M,
        dataClass: #TRANSACTIONAL },
    dataCategory: #TEXT,
    representativeKey: 'FMEAHeaderUUID'    
} 

define view I_FMEAText as select from cgpl_text
  association [0..1] to I_FailureModeEffectAnalysis as _FailureModeEffectAnalysis
    on $projection.FMEAHeaderUUID = _FailureModeEffectAnalysis.FMEAHeaderUUID
{
  @Semantics.language: true
  key langu as Language,
  key cast( cgpl_text.guid as plmt_fmea_node_guid preserving type ) as FMEAHeaderUUID,
  @Semantics.text: true
  text1 as FMEADescription,
  _FailureModeEffectAnalysis
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CGPL_TEXT"
],
"ASSOCIATED":
[
"I_FAILUREMODEEFFECTANALYSIS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/