P_SFITrcblComponentAssembly

DDL: P_SFITRCBLCOMPONENTASSEMBLY Type: view_entity COMPOSITE Package: MPE_EXEC_SFI

SFI Traceable Component Assembly

P_SFITrcblComponentAssembly is a Composite CDS View that provides data about "SFI Traceable Component Assembly" in SAP S/4HANA. It reads from 2 data sources (I_ShopFloorItem, I_MfgOrderCompAssemblyInstce) and exposes 35 fields with key fields AssemblyDocument, AssemblyDocumentItem, OriglDgtlMockUpCharcsUUID, Reservation, ReservationItem. It has 4 associations to related views. Part of development package MPE_EXEC_SFI.

2 data source(s) 35 fields

Data Sources (2)

SourceAliasJoin Type
I_ShopFloorItem AssemblyShopFloorItem from
I_MfgOrderCompAssemblyInstce MfgOrderCompAssemblyInstce inner

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_ProductPlantBasic _ProductPlantBasic $projection.Material = _ProductPlantBasic.Product and $projection.Plant = _ProductPlantBasic.Plant
[1..1] I_OpActyNtwkInstance _OpActyNtwkInstance $projection.OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance
[1..1] I_OperationActivityInstance _OperationActivityInstance $projection.OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY AssemblyDocument I_MfgOrderCompAssemblyInstce AssemblyDocument
KEY AssemblyDocumentItem I_MfgOrderCompAssemblyInstce AssemblyDocumentItem
KEY OriglDgtlMockUpCharcsUUID I_MfgOrderCompAssemblyInstce OriglDgtlMockUpCharcsUUID
KEY Reservation I_MfgOrderCompAssemblyInstce Reservation
KEY ReservationItem I_MfgOrderCompAssemblyInstce ReservationItem
KEY RecordType I_MfgOrderCompAssemblyInstce RecordType
KEY OpActyNtwkInstance I_MfgOrderCompAssemblyInstce OpActyNtwkInstance
KEY OpActyNtwkElement I_MfgOrderCompAssemblyInstce OpActyNtwkElement
KEY AssemblyShopFloorItem I_MfgOrderCompAssemblyInstce AssemblyShopFloorItem
KEY ShopFloorItem I_MfgOrderCompAssemblyInstce ShopFloorItem
KEY Batch I_MfgOrderCompAssemblyInstce Batch
KEY Material I_MfgOrderCompAssemblyInstce Material
KEY Plant I_MfgOrderCompAssemblyInstce Plant
ManufacturingOrder I_ShopFloorItem ManufacturingOrder
OriginalReplacedShopFloorItem
OriginalManufacturingOrder
StorageLocation I_MfgOrderCompAssemblyInstce StorageLocation
InventoryUsabilityCode I_MfgOrderCompAssemblyInstce InventoryUsabilityCode
DgtlMockUpCharcsUUID OpActyCompInstceAssignment DgtlMockUpCharcsUUID
MaterialComponentQuantity I_MfgOrderCompAssemblyInstce MaterialComponentQuantity
MaterialBaseUnit I_MfgOrderCompAssemblyInstce MaterialBaseUnit
QuantityInEntryUnit I_MfgOrderCompAssemblyInstce QuantityInEntryUnit
EntryUnit I_MfgOrderCompAssemblyInstce EntryUnit
DebitCreditCode I_MfgOrderCompAssemblyInstce DebitCreditCode
ComponentAssemblyType OpActyComponentAssignment ComponentAssemblyType
LeadingReservation OpActyComponentAssignment LeadingReservation
LeadingReservationItem OpActyComponentAssignment LeadingReservationItem
LeadingReservationRecordType OpActyComponentAssignment LeadingReservationRecordType
LeadingOpActyNtwkInstance OpActyComponentAssignment LeadingOpActyNtwkInstance
LeadingOpActyNtwkElement OpActyComponentAssignment LeadingOpActyNtwkElement
_Material I_MfgOrderCompAssemblyInstce _Material
_Plant _Plant
_ProductPlantBasic _ProductPlantBasic
_OpActyNtwkInstance _OpActyNtwkInstance
_OperationActivityInstance _OperationActivityInstance 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_SFITrcblComponentAssembly
  as select from           I_ShopFloorItem              as AssemblyShopFloorItem
    inner join             I_MfgOrderCompAssemblyInstce as MfgOrderCompAssemblyInstce    on MfgOrderCompAssemblyInstce.AssemblyShopFloorItem = AssemblyShopFloorItem.ShopFloorItem
    left outer to one join I_ShopFloorItem              as OriginalReplacedShopFloorItem on AssemblyShopFloorItem.OriginalReplacedShopFloorItem = OriginalReplacedShopFloorItem.ShopFloorItem
    left outer to one join I_OpActyComponentAssignment  as OpActyComponentAssignment     on  OpActyComponentAssignment.OpActyNtwkInstance = MfgOrderCompAssemblyInstce.OpActyNtwkInstance
                                                                                         and OpActyComponentAssignment.OpActyNtwkElement  = MfgOrderCompAssemblyInstce.OpActyNtwkElement
                                                                                         and OpActyComponentAssignment.Reservation        = MfgOrderCompAssemblyInstce.Reservation
                                                                                         and OpActyComponentAssignment.ReservationItem    = MfgOrderCompAssemblyInstce.ReservationItem
                                                                                         and OpActyComponentAssignment.RecordType         = MfgOrderCompAssemblyInstce.RecordType
    left outer to one join I_OpActyCompInstceAssignment as OpActyCompInstceAssignment    on  OpActyCompInstceAssignment.OpActyNtwkInstance        = MfgOrderCompAssemblyInstce.OpActyNtwkInstance
                                                                                         and OpActyCompInstceAssignment.OpActyNtwkElement         = MfgOrderCompAssemblyInstce.OpActyNtwkElement
                                                                                         and OpActyCompInstceAssignment.Reservation               = MfgOrderCompAssemblyInstce.Reservation
                                                                                         and OpActyCompInstceAssignment.ReservationItem           = MfgOrderCompAssemblyInstce.ReservationItem
                                                                                         and OpActyCompInstceAssignment.RecordType                = MfgOrderCompAssemblyInstce.RecordType
                                                                                         and OpActyCompInstceAssignment.OriglDgtlMockUpCharcsUUID = MfgOrderCompAssemblyInstce.OriglDgtlMockUpCharcsUUID
  association [0..1] to I_Plant                     as _Plant                     on  $projection.Plant = _Plant.Plant
  association [0..1] to I_ProductPlantBasic         as _ProductPlantBasic         on  $projection.Material = _ProductPlantBasic.Product
                                                                                  and $projection.Plant    = _ProductPlantBasic.Plant
  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
{
  key MfgOrderCompAssemblyInstce.AssemblyDocument                                                                                                  as AssemblyDocument,
  key MfgOrderCompAssemblyInstce.AssemblyDocumentItem                                                                                              as AssemblyDocumentItem,
  key MfgOrderCompAssemblyInstce.OriglDgtlMockUpCharcsUUID                                                                                         as OriglDgtlMockUpCharcsUUID,
  key MfgOrderCompAssemblyInstce.Reservation                                                                                                       as Reservation,
  key MfgOrderCompAssemblyInstce.ReservationItem                                                                                                   as ReservationItem,
  key MfgOrderCompAssemblyInstce.RecordType                                                                                                        as RecordType,
      @ObjectModel.foreignKey.association: '_OpActyNtwkInstance'
  key MfgOrderCompAssemblyInstce.OpActyNtwkInstance                                                                                                as OpActyNtwkInstance,
      @ObjectModel.foreignKey.association: '_OperationActivityInstance'
  key MfgOrderCompAssemblyInstce.OpActyNtwkElement                                                                                                 as OpActyNtwkElement,
  key MfgOrderCompAssemblyInstce.AssemblyShopFloorItem                                                                                             as AssemblyShopFloorItem,
  key MfgOrderCompAssemblyInstce.ShopFloorItem                                                                                                     as ShopFloorItem,
  key MfgOrderCompAssemblyInstce.Batch                                                                                                             as Batch,
  key MfgOrderCompAssemblyInstce.Material                                                                                                          as Material,
      @ObjectModel.foreignKey.association: '_Plant'
  key MfgOrderCompAssemblyInstce.Plant                                                                                                             as Plant,
      AssemblyShopFloorItem.ManufacturingOrder                                                                                                     as ManufacturingOrder,
      cast(coalesce(OriginalReplacedShopFloorItem.ShopFloorItem, AssemblyShopFloorItem.ShopFloorItem) as mpe_top_replaced_sfi_id preserving type ) as OriginalReplacedShopFloorItem,
      cast(coalesce(OriginalReplacedShopFloorItem.ManufacturingOrder, AssemblyShopFloorItem.ManufacturingOrder) as co_aufnr preserving type )      as OriginalManufacturingOrder,
      MfgOrderCompAssemblyInstce.StorageLocation                                                                                                   as StorageLocation,
      MfgOrderCompAssemblyInstce.InventoryUsabilityCode                                                                                            as InventoryUsabilityCode,
      OpActyCompInstceAssignment.DgtlMockUpCharcsUUID                                                                                              as DgtlMockUpCharcsUUID,
      cast( case
        when OpActyCompInstceAssignment.MfgRefStrucBOMLeafAssgmtUUID is null then OpActyComponentAssignment.MfgRefStrucBOMLeafAssgmtUUID
        else OpActyCompInstceAssignment.MfgRefStrucBOMLeafAssgmtUUID
      end as mpe_mrs_leaf_assignment_uuid preserving type)                                                                                         as MfgRefStrucBOMLeafAssgmtUUID,
      cast( case
        when OpActyCompInstceAssignment.MfgRefStructureItemDetailUUID is null then OpActyComponentAssignment.MfgRefStructureItemDetailUUID
        else OpActyCompInstceAssignment.MfgRefStructureItemDetailUUID
      end as mpe_mrs_item_uuid preserving type)                                                                                                    as MfgRefStructureItemDetailUUID,
      cast( case
        when OpActyCompInstceAssignment.MfgRefStructureItemDetailUUID is null then OpActyComponentAssignment.MfgRefStrucItmDetIsContextual
        else OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual
      end as xfeld preserving type)                                                                                                                as MfgRefStrucItmDetIsContextual,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      cast(round(fltp_to_dec( OpActyComponentAssignment.MfgOrderComponentUsageNetQty as abap.dec(13,4) ), 3)
        as mpe_planned_qty )                                                                                                                       as RequiredQuantity,
      @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
      MfgOrderCompAssemblyInstce.MaterialComponentQuantity                                                                                         as MaterialComponentQuantity,
      MfgOrderCompAssemblyInstce.MaterialBaseUnit                                                                                                  as MaterialBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'EntryUnit'
      MfgOrderCompAssemblyInstce.QuantityInEntryUnit                                                                                               as QuantityInEntryUnit,
      MfgOrderCompAssemblyInstce.EntryUnit                                                                                                         as EntryUnit,
      MfgOrderCompAssemblyInstce.DebitCreditCode                                                                                                   as DebitCreditCode,
      OpActyComponentAssignment.ComponentAssemblyType                                                                                              as ComponentAssemblyType,
      OpActyComponentAssignment.LeadingReservation                                                                                                 as LeadingReservation,
      OpActyComponentAssignment.LeadingReservationItem                                                                                             as LeadingReservationItem,
      OpActyComponentAssignment.LeadingReservationRecordType                                                                                       as LeadingReservationRecordType,
      OpActyComponentAssignment.LeadingOpActyNtwkInstance                                                                                          as LeadingOpActyNtwkInstance,
      OpActyComponentAssignment.LeadingOpActyNtwkElement                                                                                           as LeadingOpActyNtwkElement,

      MfgOrderCompAssemblyInstce._Material,
      _Plant,
      _ProductPlantBasic,
      _OpActyNtwkInstance,
      _OperationActivityInstance

}

Learn More