I_FMEATypeText

DDL: I_FMEATYPETEXT SQL: IFMEATYPET Type: view BASIC

FMEA Type - Text

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

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
plmc_audit_typet plmc_audit_typet from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FMEAType _FMEAType $projection.FMEAType = _FMEAType.FMEAType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IFMEATYPET 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 Type - Text view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey FMEAType view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Language langu
KEY FMEAType audit_type
FMEATypeDescription
_FMEAType _FMEAType 
@AbapCatalog.sqlViewName: 'IFMEATYPET'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType:#BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'FMEA Type - Text'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #S, dataClass: #CUSTOMIZING }
@ObjectModel.dataCategory: #TEXT 
@ObjectModel.representativeKey: 'FMEAType'
define view I_FMEATypeText as select from plmc_audit_typet 
association [0..1] to I_FMEAType as _FMEAType on $projection.FMEAType = _FMEAType.FMEAType
{
  @Semantics.language: true
  key langu as Language,
  key audit_type as FMEAType,  
  @Semantics.text: true
  cast( audit_type_text as plmt_tv_fmea_type_text preserving type ) as FMEATypeDescription,
  
  //Association

  _FMEAType
}

Learn More