I_FMEAObjectTP

DDL: I_FMEAOBJECTTP Type: view_entity TRANSACTIONAL

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.

1 data source(s) 13 fields

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
FMEATypeObjectType FMEATypeObjectType
FMEAObject FMEAObject
BusinessObjectType _FMEATypeObjectType BusinessObjectType
_FailureModeEffectAnalysisTP _FailureModeEffectAnalysisTP
_FailureModeEffectAnalysis _FailureModeEffectAnalysis
_FMEAType _FMEAType
_FMEATypeObjectType _FMEATypeObjectType
_BOOOperationChangeState _BOOOperationChangeState
_Product _Product
_FMEAObjectText _FMEAObjectText 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Transactional Processing for FMEA Object'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #M,
    serviceQuality: #B
}
define view entity I_FMEAObjectTP
  as select from I_FMEAObject
  association        to parent I_FailureModeEffectAnalysisTP as _FailureModeEffectAnalysisTP on  $projection.FMEAHeaderUUID = _FailureModeEffectAnalysisTP.FMEAHeaderUUID
  association [0..1] to I_FMEAObjectText                     as _FMEAObjectText              on  $projection.FMEAObjectUUID = _FMEAObjectText.FMEAObjectUUID
  association [0..1] to I_Product                            as _Product                    on  $projection.Material = _Product.Product
  association [0..1] to I_MfgBOOOperationChangeState         as _BOOOperationChangeState     on  $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
{
  key FMEAObjectUUID,
      FMEAHeaderUUID,
      FMEAType,
      FMEATypeObjectType,
      FMEAObject,
      _FMEATypeObjectType.BusinessObjectType,
      case when  _FMEATypeObjectType.BusinessObjectType = 'BUS1001006'
           then FMEAObject else '' end as Material,
      case when _FMEATypeObjectType.BusinessObjectType = 'BUS1012'
           then cast(substring(FMEAObject,1,1) as plnty preserving type )
           else ''  end                as BillOfOperationsType,
      case when _FMEATypeObjectType.BusinessObjectType = 'BUS1012'
           then cast(substring(FMEAObject,2,8) as plnnr preserving type )
       else ''  end                    as BillOfOperationsGroup,
      case when _FMEATypeObjectType.BusinessObjectType = 'BUS1012'
           then cast(substring(FMEAObject,10,8) as plnkn )
       else '00000000' end                     as BOOOperationInternalID,
      case when _FMEATypeObjectType.BusinessObjectType = 'BUS1012'
           then cast(substring(FMEAObject,18,8) as cim_count )
       else '00000000' end                     as BOOOpInternalVersionCounter,
      case when _FMEATypeObjectType.BusinessObjectType = 'BUS1012'
           then cast(substring(FMEAObject,26,2) as plnal preserving type )
       else '' end                     as BillOfOperationsVariant,
      case when _FMEATypeObjectType.BusinessObjectType = 'BUS1012'
           then cast(substring(FMEAObject,28,6) as plnfolge preserving type )
       else '' end                     as BillOfOperationsSequence,

      //Associations

      _FailureModeEffectAnalysisTP,
      _FailureModeEffectAnalysis,
      _FMEAType,
      _FMEATypeObjectType,
      _BOOOperationChangeState,
      _Product,
      _FMEAObjectText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FMEAOBJECT",
"I_FMEATYPEOBJECTTYPE"
],
"ASSOCIATED":
[
"I_FAILUREMODEEFFECTANALYSIS",
"I_FAILUREMODEEFFECTANALYSISTP",
"I_FMEAOBJECTTEXT",
"I_FMEATYPE",
"I_FMEATYPEOBJECTTYPE",
"I_MFGBOOOPERATIONCHANGESTATE",
"I_PRODUCT"
],
"BASE":
[
"I_FMEAOBJECT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More