C_FMEAMngElement

DDL: C_FMEAMNGELEMENT Type: view_entity CONSUMPTION

FMEA Element Projection

C_FMEAMngElement is a Consumption CDS View that provides data about "FMEA Element Projection" in SAP S/4HANA. It reads from 1 data source (I_FMEAElementNodeTP) and exposes 14 fields with key field FMEANodeUUID.

Data Sources (1)

SourceAliasJoin Type
I_FMEAElementNodeTP I_FMEAElementNodeTP projection

Annotations (6)

NameValueLevelField
EndUserText.label FMEA Element Projection view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY FMEANodeUUID FMEANodeUUID
FMEANode FMEANode
FMEAHeaderUUID FMEAHeaderUUID
FMEANodeType FMEANodeType
FMEANodeListType FMEANodeListType
FMEAItemType FMEAItemType
FMEAParentNodeUUID FMEAParentNodeUUID
FMEANodeReferenceUUID FMEANodeReferenceUUID
FMEANodeReference _FMEAReferenceHeader FMEAHeader
FMEAChangedDateTime _FMEAReference ChangedDateTime Time Stamp
FMEANodeDescriptionlocalized
FMEAElementLongText FMEAElementLongText
FMEALongText FMEALongText
_FailureModeEffectAnalysis _FailureModeEffectAnalysis

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FMEAMngElement.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_FMEAMngElement AS
SELECT
  FMEANodeUUID,
  FMEANode,
  FMEAHeaderUUID,
  FMEANodeType,
  FMEANodeListType,
  FMEAItemType,
  FMEAParentNodeUUID,
  FMEANodeReferenceUUID,
  _FMEAReferenceHeader.FMEAHeader AS FMEANodeReference,
  _FMEAReference.ChangedDateTime AS FMEAChangedDateTime,
  _FMEANodeText.FMEANodeDescription :localized AS FMEANodeDescriptionlocalized,
  FMEAElementLongText,
  FMEALongText
FROM I_FMEAElementNodeTP
;