C_FMEAMng

DDL: C_FMEAMNG Type: view_entity CONSUMPTION
36 Fields 1 Data Sources

Manage FMEA Projection

C_FMEAMng is a Consumption CDS View that provides data about "Manage FMEA Projection" in SAP S/4HANA. It reads from 1 data source (I_FailureModeEffectAnalysisTP) and exposes 36 fields with key field FMEAHeaderUUID.

Data Sources (1)

SourceAliasJoin Type
I_FailureModeEffectAnalysisTP I_FailureModeEffectAnalysisTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Manage FMEA Projection view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
Search.searchable true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
VDM.viewType #CONSUMPTION view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY FMEAHeaderUUID FMEAHeaderUUID
FMEAHeader FMEAHeader
FMEAType FMEAType
FMEATypeDescriptionlocalized
FMEAAuthorizationGroup FMEAAuthorizationGroup
FMEAAuthorizationGroupTextlocalized
FMEAInCurLangDescription FMEAInCurLangDescription
FMEADescriptionlocalized
FMEALongTextDesc FMEALongTextDesc
NumberOfMaterials _FMEAObjectAggregate NumberOfMaterials Materials
NumberOfOperations _FMEAObjectAggregate NumberOfOperations Operations
NumberOfOpenTasks _FMEATaskAggregate NumberOfOpenTasks Open Actions
NumberOfTasks _FMEATaskAggregate NumberOfTasks Actions
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangedDate LastChangedDate Created On
ChangedDateTime ChangedDateTime Time Stamp
FMEAActualStartDate FMEAActualStartDate
OriginalLanguage OriginalLanguage Original Language
FMEAValuationProcedure FMEAValuationProcedure
FMEAValuationProcedureText _FMEAValuationProcedure FMEAValuationProcedureText
FMEAValuationResultValue FMEAValuationResultValue
FMEARatingProfile FMEARatingProfile
FMEARatingProfileTextlocalized
FMEARating FMEARating
FMEARatingTextlocalized
FMEAGroup FMEAGroup
FMEASearchTermValue FMEASearchTermValue
FMEACalculationStatus FMEACalculationStatus
FMEAIsHeaderFMEA FMEAIsHeaderFMEA
FMEAConfidentialityLevel FMEAConfidentialityLevel
FMEAConfidentialityLevelTextlocalized
OutputControlApplicationObject OutputControlApplicationObject Appl. Object ID
_CreatedByUserContactCard _CreatedByUserContactCard
_LastChangedByUserContactCard _LastChangedByUserContactCard

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_FMEAMng.
-- 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_FMEAMng AS
SELECT
  FMEAHeaderUUID,
  FMEAHeader,
  FMEAType,
  _FMEATypeText.FMEATypeDescription : localized AS FMEATypeDescriptionlocalized,
  FMEAAuthorizationGroup,
  _FMEAAuthorizationGroupT.FMEAAuthorizationGroupText : localized AS FMEAAuthorizationGroupTextlocalized,
  FMEAInCurLangDescription,
  _FMEAText.FMEADescription : localized AS FMEADescriptionlocalized,
  FMEALongTextDesc,
  _FMEAObjectAggregate.NumberOfMaterials AS NumberOfMaterials,
  _FMEAObjectAggregate.NumberOfOperations AS NumberOfOperations,
  _FMEATaskAggregate.NumberOfOpenTasks AS NumberOfOpenTasks,
  _FMEATaskAggregate.NumberOfTasks AS NumberOfTasks,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangedDate,
  ChangedDateTime,
  FMEAActualStartDate,
  OriginalLanguage,
  FMEAValuationProcedure,
  _FMEAValuationProcedure.FMEAValuationProcedureText AS FMEAValuationProcedureText,
  FMEAValuationResultValue,
  FMEARatingProfile,
  _FMEARatingProfile._Text.FMEARatingProfileText : localized AS FMEARatingProfileTextlocalized,
  FMEARating,
  _FMEARating._Text.FMEARatingText : localized AS FMEARatingTextlocalized,
  FMEAGroup,
  FMEASearchTermValue,
  FMEACalculationStatus,
  FMEAIsHeaderFMEA,
  FMEAConfidentialityLevel,
  _FMEAConfidentialityLevelText.FMEAConfidentialityLevelText : localized AS FMEAConfidentialityLevelTextlocalized,
  OutputControlApplicationObject
FROM I_FailureModeEffectAnalysisTP
;

Learn More