P_SFOTraceableAssldComp

DDL: P_SFOTRACEABLEASSLDCOMP Type: view_entity CONSUMPTION Package: MPE_EXEC_COMMON

SFO Assembled Traceable Component

P_SFOTraceableAssldComp is a Consumption CDS View that provides data about "SFO Assembled Traceable Component" in SAP S/4HANA. It reads from 3 data sources (I_MatlPlntCompAssembleControl, P_SFOAssldCompByLdngResvnNoIn, P_SFOAssldTrcblCompByLdngResvn) and exposes 63 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. It has 6 associations to related views. Part of development package MPE_EXEC_COMMON.

3 data source(s) 63 fields

Data Sources (3)

SourceAliasJoin Type
I_MatlPlntCompAssembleControl MatlPlntCompAssembleControl inner
P_SFOAssldCompByLdngResvnNoIn SFOAssldCompByLdngResvnNoIn inner
P_SFOAssldTrcblCompByLdngResvn SFOAssldTrcblCompByLdngResvn from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_ReservationDocumentHeader _Reservation $projection.Reservation = _Reservation.Reservation
[1..1] I_OpActyNtwkInstance _OpActyNtwkInstance $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
[1..1] I_OperationActivityInstance _OperationActivityInstance $projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement
[1..1] I_ShopFloorItem _ShopFloorItem $projection.ShopFloorItem = _ShopFloorItem.ShopFloorItem
[0..1] I_BillOfMaterialItemBasic _BillOfMaterialItemBasic $projection.BillOfMaterialCategory = _BillOfMaterialItemBasic.BillOfMaterialCategory and $projection.BillOfMaterialInternalID = _BillOfMaterialItemBasic.BillOfMaterial and $projection.BOMItem = _BillOfMaterialItemBasic.BillOfMaterialItemNodeNumber and $projection.BOMItemInternalChangeCount = _BillOfMaterialItemBasic.BOMItemInternalChangeCount
[0..1] I_MfgBOMItemWithPhantomHier _MfgBOMItemWithPhantomHier $projection.BillOfMaterialCategory = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory and $projection.BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial and $projection.BillOfMaterialVariant = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant and $projection.BillOfMaterialVersion = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion and $projection.InheritedBOMItemNode = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY Reservation P_SFOAssldTrcblCompByLdngResvn Reservation
KEY ReservationItem P_SFOAssldTrcblCompByLdngResvn ReservationItem
KEY RecordType P_SFOAssldTrcblCompByLdngResvn RecordType
KEY OpActyNtwkInstance P_SFOAssldTrcblCompByLdngResvn OpActyNtwkInstance
KEY OpActyNtwkElement P_SFOAssldTrcblCompByLdngResvn OpActyNtwkElement
KEY ShopFloorItem P_SFOAssldTrcblCompByLdngResvn ShopFloorItem
KEY Batch P_SFOAssldTrcblCompByLdngResvn Batch
KEY Material
KEY Plant P_SFOAssldTrcblCompByLdngResvn Plant
KEY DgtlMockUpCharcsUUID P_SFOAssldTrcblCompByLdngResvn DgtlMockUpCharcsUUID
KEY MfgRefStrucBOMLeafAssgmtUUID P_SFOAssldTrcblCompByLdngResvn MfgRefStrucBOMLeafAssgmtUUID
KEY MfgRefStructureItemDetailUUID P_SFOAssldTrcblCompByLdngResvn MfgRefStructureItemDetailUUID
KEY MfgRefStrucItmDetIsContextual P_SFOAssldTrcblCompByLdngResvn MfgRefStrucItmDetIsContextual
BillOfMaterialItemNumber OpActyInstceComponentDetail BillOfMaterialItemNumber
BillOfMaterialCategory OpActyInstceComponentDetail BillOfMaterialCategory
BillOfMaterialInternalID OpActyInstceComponentDetail BillOfMaterialInternalID
BOMItem OpActyInstceComponentDetail BOMItem
BOMItemInternalChangeCount OpActyInstceComponentDetail BOMItemInternalChangeCount
BillOfMaterialVariant OpActyInstceComponentDetail BillOfMaterialVariant
BillOfMaterialVersion OpActyInstceComponentDetail BillOfMaterialVersion
BOMItemCategory OpActyInstceComponentDetail BOMItemCategory
InheritedBOMItemNode OpActyInstceComponentDetail InheritedBOMItemNode
EffectivityParameterVariant OpActyInstceComponentDetail EffectivityParameterVariant
InheritedNodeNumberForBOMItem _BillOfMaterialItemBasic InheritedNodeNumberForBOMItem
InheritedNodeNumberVersionBOM _BillOfMaterialItemBasic InheritedNodeNumberVersionBOM
Assembly OpActyInstceComponentDetail Assembly
RequiredQuantity OpActyInstceComponentDetail RequiredQuantity
RequiredQuantityInBaseUnit OpActyInstceComponentDetail RequiredQuantityInBaseUnit
ResvnItmWithdrawnQtyInBaseUnit
ResvnItmTotalWithdrawnQty
MaterialBaseUnit P_SFOAssldTrcblCompByLdngResvn MaterialBaseUnit
EntryUnit P_SFOAssldTrcblCompByLdngResvn EntryUnit
MaterialCompIsVariableSized
FormulaKey OpActyInstceComponentDetail FormulaKey
VariableSizeDimension1 OpActyInstceComponentDetail VariableSizeDimension1
VariableSizeDimension2 OpActyInstceComponentDetail VariableSizeDimension2
VariableSizeDimension3 OpActyInstceComponentDetail VariableSizeDimension3
VariableSizeDimensionUnit OpActyInstceComponentDetail VariableSizeDimensionUnit
VariableSizeComponentQuantity OpActyInstceComponentDetail VariableSizeComponentQuantity
VariableSizeComponentUnit OpActyInstceComponentDetail VariableSizeComponentUnit
ManufacturingOrder P_SFOAssldTrcblCompByLdngResvn ManufacturingOrder
Operation
OperationText OrderOperationBasic OperationText
OrderInternalID OpActyNtwkInstanceBasic OrderInternalID
OrderOperationInternalID OpActyNtwkInstanceBasic OrderOperationInternalID
OperationActivityNetwork OpActyNtwkInstanceBasic OperationActivityNetwork
OpActyNtwkVersionCounter OpActyNtwkInstanceBasic OpActyNtwkVersionCounter
SerialNumber _ShopFloorItem SerialNumber
ManufacturerSerialNumber
ReferenceDesignatorValue InstanceReferenceDesignator ReferenceDesignatorValue
MatlCompAssembleControl I_MatlPlntCompAssembleControl MatlCompAssembleControl
DebitCreditCode OpActyInstceComponentDetail DebitCreditCode
_Reservation _Reservation
_OpActyNtwkInstance _OpActyNtwkInstance
_OperationActivityInstance _OperationActivityInstance
_ManufacturingOrder P_SFOAssldTrcblCompByLdngResvn _ManufacturingOrder
_ShopFloorItem _ShopFloorItem
_Material P_SFOAssldTrcblCompByLdngResvn _Material
_Plant P_SFOAssldTrcblCompByLdngResvn _Plant
_ProductPlantBasic P_SFOAssldTrcblCompByLdngResvn _ProductPlantBasic
_MatlCompAssembleControl I_MatlPlntCompAssembleControl _MatlCompAssembleControl
_BOMItemCategory OpActyInstceComponentDetail _BOMItemCategory
_MfgBOMItemWithPhantomHier _MfgBOMItemWithPhantomHier 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_SFOTraceableAssldComp
  as select from           P_SFOAssldTrcblCompByLdngResvn as SFOAssldTrcblCompByLdngResvn
    inner join             P_SFOAssldCompByLdngResvnNoIn  as SFOAssldCompByLdngResvnNoIn on  SFOAssldCompByLdngResvnNoIn.Reservation        = SFOAssldTrcblCompByLdngResvn.Reservation
                                                                                         and SFOAssldCompByLdngResvnNoIn.ReservationItem    = SFOAssldTrcblCompByLdngResvn.ReservationItem
                                                                                         and SFOAssldCompByLdngResvnNoIn.RecordType         = SFOAssldTrcblCompByLdngResvn.RecordType
                                                                                         and SFOAssldCompByLdngResvnNoIn.OpActyNtwkInstance = SFOAssldTrcblCompByLdngResvn.OpActyNtwkInstance
                                                                                         and SFOAssldCompByLdngResvnNoIn.OpActyNtwkElement  = SFOAssldTrcblCompByLdngResvn.OpActyNtwkElement
                                                                                         and SFOAssldCompByLdngResvnNoIn.Material           = SFOAssldTrcblCompByLdngResvn.Material
                                                                                         and SFOAssldCompByLdngResvnNoIn.Plant              = SFOAssldTrcblCompByLdngResvn.Plant
    inner join             I_MatlPlntCompAssembleControl  as MatlPlntCompAssembleControl on  MatlPlntCompAssembleControl.Product = SFOAssldTrcblCompByLdngResvn.Material
                                                                                         and MatlPlntCompAssembleControl.Plant   = SFOAssldTrcblCompByLdngResvn.Plant
    left outer to one join I_OpActyInstceComponentDetail  as OpActyInstceComponentDetail on  OpActyInstceComponentDetail.OpActyNtwkInstance = SFOAssldTrcblCompByLdngResvn.OpActyNtwkInstance
                                                                                         and OpActyInstceComponentDetail.OpActyNtwkElement  = SFOAssldTrcblCompByLdngResvn.OpActyNtwkElement
                                                                                         and OpActyInstceComponentDetail.Reservation        = SFOAssldTrcblCompByLdngResvn.Reservation
                                                                                         and OpActyInstceComponentDetail.ReservationItem    = SFOAssldTrcblCompByLdngResvn.ReservationItem
                                                                                         and OpActyInstceComponentDetail.RecordType         = SFOAssldTrcblCompByLdngResvn.RecordType
    left outer to one join I_OpActyNtwkInstanceBasic      as OpActyNtwkInstanceBasic     on OpActyNtwkInstanceBasic.OpActyNtwkInstance = SFOAssldTrcblCompByLdngResvn.OpActyNtwkInstance
    left outer to one join I_OrderOperationBasic          as OrderOperationBasic         on  OpActyNtwkInstanceBasic.OrderInternalID          = OrderOperationBasic.OrderInternalID
                                                                                         and OpActyNtwkInstanceBasic.OrderOperationInternalID = OrderOperationBasic.OrderOperationInternalID
    left outer to one join I_InstanceReferenceDesignator  as InstanceReferenceDesignator on InstanceReferenceDesignator.DgtlMockUpCharcsUUID = SFOAssldTrcblCompByLdngResvn.DgtlMockUpCharcsUUID

  association [0..1] to I_ReservationDocumentHeader as _Reservation               on  $projection.Reservation = _Reservation.Reservation
  association [1..1] to I_OpActyNtwkInstance        as _OpActyNtwkInstance        on  $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
  association [1..1] to I_OperationActivityInstance as _OperationActivityInstance on  $projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance
                                                                                  and $projection.OpActyNtwkElement  = _OperationActivityInstance.OpActyNtwkElement
  association [1..1] to I_ShopFloorItem             as _ShopFloorItem             on  $projection.ShopFloorItem = _ShopFloorItem.ShopFloorItem

  association [0..1] to I_BillOfMaterialItemBasic   as _BillOfMaterialItemBasic   on  $projection.BillOfMaterialCategory     = _BillOfMaterialItemBasic.BillOfMaterialCategory
                                                                                  and $projection.BillOfMaterialInternalID   = _BillOfMaterialItemBasic.BillOfMaterial
                                                                                  and $projection.BOMItem                    = _BillOfMaterialItemBasic.BillOfMaterialItemNodeNumber
                                                                                  and $projection.BOMItemInternalChangeCount = _BillOfMaterialItemBasic.BOMItemInternalChangeCount
  association [0..1] to I_MfgBOMItemWithPhantomHier as _MfgBOMItemWithPhantomHier on  $projection.BillOfMaterialCategory   = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialCategory
                                                                                  and $projection.BillOfMaterialInternalID = _MfgBOMItemWithPhantomHier.MfgBillOfMaterial
                                                                                  and $projection.BillOfMaterialVariant    = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVariant
                                                                                  and $projection.BillOfMaterialVersion    = _MfgBOMItemWithPhantomHier.MfgBillOfMaterialVersion
                                                                                  and $projection.InheritedBOMItemNode     = _MfgBOMItemWithPhantomHier.MfgBOMItmInhtdNodeNmbr
{
  key SFOAssldTrcblCompByLdngResvn.Reservation,
  key SFOAssldTrcblCompByLdngResvn.ReservationItem,
  key SFOAssldTrcblCompByLdngResvn.RecordType,
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
  key SFOAssldTrcblCompByLdngResvn.OpActyNtwkInstance,
      @ObjectModel.foreignKey.association: '_OperationActivityInstance'
  key SFOAssldTrcblCompByLdngResvn.OpActyNtwkElement,
  key SFOAssldTrcblCompByLdngResvn.ShopFloorItem,
  key SFOAssldTrcblCompByLdngResvn.Batch,
  key cast(SFOAssldTrcblCompByLdngResvn.Material as mpe_component_matnr preserving type )                           as Material,
      @ObjectModel.foreignKey.association: '_Plant'
  key SFOAssldTrcblCompByLdngResvn.Plant,
  key SFOAssldTrcblCompByLdngResvn.DgtlMockUpCharcsUUID,
  key SFOAssldTrcblCompByLdngResvn.MfgRefStrucBOMLeafAssgmtUUID,
  key SFOAssldTrcblCompByLdngResvn.MfgRefStructureItemDetailUUID,
  key SFOAssldTrcblCompByLdngResvn.MfgRefStrucItmDetIsContextual,
      OpActyInstceComponentDetail.BillOfMaterialItemNumber                                                          as BillOfMaterialItemNumber,
      OpActyInstceComponentDetail.BillOfMaterialCategory                                                            as BillOfMaterialCategory,
      OpActyInstceComponentDetail.BillOfMaterialInternalID                                                          as BillOfMaterialInternalID,
      OpActyInstceComponentDetail.BOMItem                                                                           as BOMItem,
      OpActyInstceComponentDetail.BOMItemInternalChangeCount                                                        as BOMItemInternalChangeCount,
      OpActyInstceComponentDetail.BillOfMaterialVariant                                                             as BillOfMaterialVariant,
      OpActyInstceComponentDetail.BillOfMaterialVersion                                                             as BillOfMaterialVersion,
      OpActyInstceComponentDetail.BOMItemCategory                                                                   as BOMItemCategory,
      OpActyInstceComponentDetail.InheritedBOMItemNode                                                              as InheritedBOMItemNode,
      OpActyInstceComponentDetail.EffectivityParameterVariant                                                       as EffectivityParameterVariant,
      _BillOfMaterialItemBasic.InheritedNodeNumberForBOMItem                                                        as InheritedNodeNumberForBOMItem,
      _BillOfMaterialItemBasic.InheritedNodeNumberVersionBOM                                                        as InheritedNodeNumberVersionBOM,
      OpActyInstceComponentDetail.Assembly                                                                          as Assembly,

      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      OpActyInstceComponentDetail.RequiredQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      OpActyInstceComponentDetail.RequiredQuantityInBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      cast(case OpActyInstceComponentDetail.MaterialCompIsVariableSized
        when 'X' then SFOAssldTrcblCompByLdngResvn.QuantityInEntryUnit
        else SFOAssldTrcblCompByLdngResvn.MaterialComponentQuantity
      end as mpe_consumed_qty preserving type)                                                                      as MaterialComponentQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(SFOAssldTrcblCompByLdngResvn.MaterialComponentQuantity as mpe_consumed_qty_in_base_unit preserving type) as ResvnItmWithdrawnQtyInBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(SFOAssldCompByLdngResvnNoIn.MaterialComponentQuantity as enmng preserving type)                          as ResvnItmTotalWithdrawnQty,
      SFOAssldTrcblCompByLdngResvn.MaterialBaseUnit,
      SFOAssldTrcblCompByLdngResvn.EntryUnit,

      -- Variable-Size Item Fields
      OpActyInstceComponentDetail.MaterialCompIsVariableSized,
      OpActyInstceComponentDetail.FormulaKey,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      OpActyInstceComponentDetail.VariableSizeDimension1,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      OpActyInstceComponentDetail.VariableSizeDimension2,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeDimensionUnit'
      OpActyInstceComponentDetail.VariableSizeDimension3,
      OpActyInstceComponentDetail.VariableSizeDimensionUnit,
      @Semantics.quantity.unitOfMeasure: 'VariableSizeComponentUnit'
      OpActyInstceComponentDetail.VariableSizeComponentQuantity,
      OpActyInstceComponentDetail.VariableSizeComponentUnit,

      SFOAssldTrcblCompByLdngResvn.ManufacturingOrder,
      cast(OrderOperationBasic.Operation_2 as mpe_vornr_char preserving type)                                       as Operation,
      OrderOperationBasic.OperationText,
      OpActyNtwkInstanceBasic.OrderInternalID,
      OpActyNtwkInstanceBasic.OrderOperationInternalID,
      OpActyNtwkInstanceBasic.OperationActivityNetwork,
      OpActyNtwkInstanceBasic.OpActyNtwkVersionCounter,
      _ShopFloorItem.SerialNumber,
      cast(_ShopFloorItem._Equipment.ManufacturerSerialNumber as mpe_mfr_sernr preserving type)                     as ManufacturerSerialNumber,
      InstanceReferenceDesignator.ReferenceDesignatorValue,
      @ObjectModel.foreignKey.association: '_MatlCompAssembleControl'
      MatlPlntCompAssembleControl.MatlCompAssembleControl,
      OpActyInstceComponentDetail.DebitCreditCode,

      _Reservation,
      _OpActyNtwkInstance,
      _OperationActivityInstance,
      SFOAssldTrcblCompByLdngResvn._ManufacturingOrder,
      _ShopFloorItem,
      SFOAssldTrcblCompByLdngResvn._Material,
      SFOAssldTrcblCompByLdngResvn._Plant,
      SFOAssldTrcblCompByLdngResvn._ProductPlantBasic,
      MatlPlntCompAssembleControl._MatlCompAssembleControl,
      OpActyInstceComponentDetail._BOMItemCategory,
      _MfgBOMItemWithPhantomHier
}

Learn More