I_FMEANODE

CDS View

Function or other node of FMEA

I_FMEANODE is a CDS View in S/4HANA. Function or other node of FMEA. It contains 39 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
C_FMEANodeFDP view_entity from CONSUMPTION Form Data Provider for FMEA Node
I_FMEACauseNodeTP view_entity from TRANSACTIONAL FMEA Node - TP
I_FMEACauseTaskTP view_entity from TRANSACTIONAL FMEA Cause Task Node - TP
I_FMEAEffectNode view from COMPOSITE FMEA Effect Node
I_FMEAEffectNode view inner COMPOSITE FMEA Effect Node
I_FMEAEffectNode view union COMPOSITE FMEA Effect Node
I_FMEAElementNodeTP view_entity from TRANSACTIONAL Transactional Processing for FMEA Node
I_FMEAFailureNet view from COMPOSITE FMEA Failure Mode Net
I_FMEAFailureNet view left_outer COMPOSITE FMEA Failure Mode Net
I_FMEAFailureNodeTP view_entity from TRANSACTIONAL Transactional Processing for FMEA Node
I_FMEAFunctionNet view left_outer COMPOSITE FMEA Function Net
I_FMEAFunctionNet view from COMPOSITE FMEA Function Net
I_FMEAFunctionNodeTP view_entity from TRANSACTIONAL Transactional Processing for FMEA Node
I_FMEAInternalFunctionNet view from COMPOSITE FMEA Function Net
I_FMEAInternalFunctionNet view left_outer COMPOSITE FMEA Function Net
I_FMEANodeTP view_entity from TRANSACTIONAL Transactional Processing for FMEA Node
I_FMEANodeUsage view_entity from COMPOSITE Usages for FMEA as Reference
I_FMEASubordStrucHierNode view left_outer COMPOSITE Node of a subordinate Element of FMEA
I_FMEASuprordStrucHierNode view left_outer COMPOSITE Node of a superordinate Element of FMEA

Fields (39)

KeyField CDS FieldsUsed in Views
KEY FMEAHeaderUUID FMEAHeaderUUID 7
KEY FMEANodeUUID FMEAFunctionUUID,FMEANodeUUID,FMEAPreconditionUUID 9
_FailureModeEffectAnalysis _FailureModeEffectAnalysis 4
_FMEAHeader _FMEAHeader 2
_FMEANodeChild _FMEANodeChild 3
_FMEANodeLongText _FMEANodeLongText 1
_FMEANodeParent _FMEANodeParent 3
_FMEANodeText _FMEANodeText 2
_FMEAReferenceNode _FMEAReferenceNode 1
_FMEATask _FMEATask 3
_InspectionCode _InspectionCode 1
_InspectionCodeGroup _InspectionCodeGroup 1
ChangedDateTime ChangedDateTime 4
DefectCauseCodeCatalog DefectCauseCodeCatalog 1
DefectCodeCatalog DefectCodeCatalog 1
FMEACharacteristicType FMEACharacteristicType 1
FMEAEffectCodeCatalog FMEAEffectCodeCatalog 1
FMEAFunctionCodeCatalog FMEAFunctionCodeCatalog 1
FMEAHasValuation FMEAHasValuation 1
FMEAHierarchyProfile FMEAHierarchyProfile 1
FMEAHierarchyProfileLevel FMEAHierarchyProfileLevel 1
FMEAItemType FMEAItemType 6
FMEANodeListType FMEANodeListType 6
FMEANodeReferenceObjectType FMEANodeReferenceObjectType 6
FMEANodeReferenceUUID FMEANodeReferenceUUID 6
FMEANodeType FMEANodeType 4
FMEARating FMEARating 3
FMEAValnProfileValuation FMEAValnProfileValuation 1
FMEAValuationProcedure FMEAValuationProcedure 1
FMEAValuationProfile FMEAValuationProfile 1
FMEAValuationResultValue FMEAValuationResultValue 3
FMEAValuationScoreValue FMEAValuationScoreValue 1
InspectionCatalog InspectionCatalog 2
InspectionCode InspectionCode 2
InspectionCodeGroup InspectionCodeGroup 2
InspectionSpecification InspectionSpecification 1
InspectionSpecificationPlant InspectionSpecificationPlant 1
InspSpecImportanceCode InspSpecImportanceCode 1
QualityTaskCodeCatalog QualityTaskCodeCatalog 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Function or other node of FMEA
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_FMEANODE (
    FMEAHEADERUUID,
    FMEANODEUUID,
    _FAILUREMODEEFFECTANALYSIS,
    _FMEAHEADER,
    _FMEANODECHILD,
    _FMEANODELONGTEXT,
    _FMEANODEPARENT,
    _FMEANODETEXT,
    _FMEAREFERENCENODE,
    _FMEATASK,
    _INSPECTIONCODE,
    _INSPECTIONCODEGROUP,
    CHANGEDDATETIME,
    DEFECTCAUSECODECATALOG,
    DEFECTCODECATALOG,
    FMEACHARACTERISTICTYPE,
    FMEAEFFECTCODECATALOG,
    FMEAFUNCTIONCODECATALOG,
    FMEAHASVALUATION,
    FMEAHIERARCHYPROFILE,
    FMEAHIERARCHYPROFILELEVEL,
    FMEAITEMTYPE,
    FMEANODELISTTYPE,
    FMEANODEREFERENCEOBJECTTYPE,
    FMEANODEREFERENCEUUID,
    FMEANODETYPE,
    FMEARATING,
    FMEAVALNPROFILEVALUATION,
    FMEAVALUATIONPROCEDURE,
    FMEAVALUATIONPROFILE,
    FMEAVALUATIONRESULTVALUE,
    FMEAVALUATIONSCOREVALUE,
    INSPECTIONCATALOG,
    INSPECTIONCODE,
    INSPECTIONCODEGROUP,
    INSPECTIONSPECIFICATION,
    INSPECTIONSPECIFICATIONPLANT,
    INSPSPECIMPORTANCECODE,
    QUALITYTASKCODECATALOG,
    PRIMARY KEY (FMEAHEADERUUID, FMEANODEUUID)
);