I_FMEAObjectTP

DDL: I_FMEAOBJECTTP Type: view_entity TRANSACTIONAL
13 Fields 1 Data Sources 3 Associations

Transactional Processing for FMEA Object

I_FMEAObjectTP is a Transactional CDS View that provides data about "Transactional Processing for FMEA Object" in SAP S/4HANA. It reads from 1 data source (I_FMEAObject) and exposes 13 fields with key field FMEAObjectUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FMEAObject I_FMEAObject from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_FMEAObjectText _FMEAObjectText $projection.FMEAObjectUUID = _FMEAObjectText.FMEAObjectUUID
[0..1] I_Product _Product $projection.Material = _Product.Product
[0..1] I_MfgBOOOperationChangeState _BOOOperationChangeState $projection.BillOfOperationsType = _BOOOperationChangeState.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOOperationChangeState.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BOOOperationChangeState.BillOfOperationsVariant and $projection.BillOfOperationsSequence = _BOOOperationChangeState.BillOfOperationsSequence and $projection.BOOOperationInternalID = _BOOOperationChangeState.BOOOperationInternalID and $projection.BOOOpInternalVersionCounter = _BOOOperationChangeState.BOOOpInternalVersionCounter

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transactional Processing for FMEA Object view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY FMEAObjectUUID FMEAObjectUUID
FMEAHeaderUUID FMEAHeaderUUID
FMEAType FMEAType Audit Type
FMEATypeObjectType FMEATypeObjectType Type
FMEAObject FMEAObject Allowed Value
BusinessObjectType _FMEATypeObjectType BusinessObjectType Object Type
_FailureModeEffectAnalysisTP _FailureModeEffectAnalysisTP
_FailureModeEffectAnalysis _FailureModeEffectAnalysis
_FMEAType _FMEAType
_FMEATypeObjectType _FMEATypeObjectType
_BOOOperationChangeState _BOOOperationChangeState
_Product _Product
_FMEAObjectText _FMEAObjectText

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 I_FMEAObjectTP.
-- 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 I_FMEAObjectTP AS
SELECT
  FMEAObjectUUID,
  FMEAHeaderUUID,
  FMEAType,
  FMEATypeObjectType,
  FMEAObject,
  _FMEATypeObjectType.BusinessObjectType AS BusinessObjectType
FROM I_FMEAObject
LEFT OUTER JOIN I_FMEAObjectText AS _FMEAObjectText ON FMEAObjectUUID = _FMEAObjectText.FMEAObjectUUID  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_MfgBOOOperationChangeState AS _BOOOperationChangeState ON BillOfOperationsType = _BOOOperationChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOOperationChangeState.BillOfOperationsVariant AND BillOfOperationsSequence = _BOOOperationChangeState.BillOfOperationsSequence AND BOOOperationInternalID = _BOOOperationChangeState.BOOOperationInternalID AND BOOOpInternalVersionCounter = _BOOOperationChangeState.BOOOpInternalVersionCounter  -- association [0..1]
;

Learn More