I_FMEANODE
Function or other node of FMEA
I_FMEANODE is a CDS View in S/4HANA. Function or other node of FMEA. It contains 22 fields. 20 CDS views read from this table.
CDS Views using this table (20)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_FMEAFailureModeFDP | view_entity | from | CONSUMPTION | Failure Modes of FMEA |
| I_FMEACauseNode | view_entity | from | COMPOSITE | Causes in FMEA |
| I_FMEACauseNodeTP | view_entity | from | TRANSACTIONAL | FMEA Node - TP |
| I_FMEACauseTaskTP | view_entity | from | TRANSACTIONAL | FMEA Cause Task Node - TP |
| I_FMEAEffectNode | view_entity | from | COMPOSITE | FMEA Effect Node |
| I_FMEAEffectNode | view_entity | inner | COMPOSITE | FMEA Effect Node |
| I_FMEAEffectNode | view_entity | union | COMPOSITE | FMEA Effect Node |
| I_FMEAElementNodeTP | view_entity | from | TRANSACTIONAL | Transactional Processing for FMEA Node |
| I_FMEAFailureNet | view_entity | from | COMPOSITE | FMEA Failure Mode Net |
| I_FMEAFailureNet | view_entity | left_outer | COMPOSITE | FMEA Failure Mode Net |
| I_FMEAFailureNodeTP | view_entity | from | TRANSACTIONAL | Transactional Processing for FMEA Node |
| I_FMEAFunctionNet | view_entity | from | COMPOSITE | FMEA Function Net |
| I_FMEAFunctionNet | view_entity | left_outer | COMPOSITE | FMEA Function Net |
| I_FMEAFunctionNodeTP | view_entity | from | TRANSACTIONAL | Transactional Processing for FMEA Node |
| I_FMEAInternalFunctionNet | view_entity | from | COMPOSITE | FMEA Function Net |
| I_FMEAInternalFunctionNet | view_entity | 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_entity | left_outer | COMPOSITE | Node of a subordinate Element of FMEA |
| I_FMEASuprordStrucHierNode | view_entity | left_outer | COMPOSITE | Node of a superordinate Element of FMEA |
Fields (22)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | FMEAHeaderUUID | FMEAHeaderUUID | 6 |
| KEY | FMEANodeUUID | FMEAFailureModeUUID,FMEAFunctionUUID,FMEANodeUUID,FMEAPreconditionUUID | 9 |
| _FailureModeEffectAnalysis | _FailureModeEffectAnalysis | 3 | |
| _FMEAHeader | _FMEAHeader | 2 | |
| _FMEANodeChild | _FMEANodeChild | 3 | |
| _FMEANodeHierarchy | _FMEANodeHierarchy | 3 | |
| _FMEANodeLongText | _FMEANodeLongText | 1 | |
| _FMEANodeText | _FMEANodeText | 2 | |
| _FMEATask | _FMEATask | 3 | |
| _InspectionCode | _InspectionCode | 1 | |
| _InspectionCodeGroup | _InspectionCodeGroup | 1 | |
| ChangedDateTime | ChangedDateTime | 2 | |
| FMEAItemType | FMEAItemType | 5 | |
| FMEANodeListType | FMEANodeListType | 5 | |
| FMEANodeReferenceObjectType | FMEANodeReferenceObjectType | 5 | |
| FMEANodeReferenceUUID | FMEANodeReferenceUUID | 5 | |
| FMEANodeType | FMEANodeType | 3 | |
| FMEARating | FMEARating | 2 | |
| FMEAValuationResultValue | FMEAValuationResultValue | 2 | |
| InspectionCatalog | InspectionCatalog | 1 | |
| InspectionCode | InspectionCode | 1 | |
| InspectionCodeGroup | InspectionCodeGroup | 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,
_FMEANODEHIERARCHY,
_FMEANODELONGTEXT,
_FMEANODETEXT,
_FMEATASK,
_INSPECTIONCODE,
_INSPECTIONCODEGROUP,
CHANGEDDATETIME,
FMEAITEMTYPE,
FMEANODELISTTYPE,
FMEANODEREFERENCEOBJECTTYPE,
FMEANODEREFERENCEUUID,
FMEANODETYPE,
FMEARATING,
FMEAVALUATIONRESULTVALUE,
INSPECTIONCATALOG,
INSPECTIONCODE,
INSPECTIONCODEGROUP,
PRIMARY KEY (FMEAHEADERUUID, FMEANODEUUID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA