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 39 fields. 19 CDS views read from this table.
CDS Views using this table (19)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
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