P_SFOTrcblComponentAssembly

Q: Which tables does P_SFOTrcblComponentAssembly use?

P_SFOTrcblComponentAssembly reads from 3 data source(s): I_LogisticsOrder, I_MfgOrderCompAssemblyInstce, I_OpActyNtwkInstanceBasic.

Q: How many fields does P_SFOTrcblComponentAssembly have?

P_SFOTrcblComponentAssembly has 35 fields. Key fields: AssemblyDocument, AssemblyDocumentItem, OriglDgtlMockUpCharcsUUID, Reservation, ReservationItem.

DDL: P_SFOTRCBLCOMPONENTASSEMBLY Type: view_entity COMPOSITE Package: MPE_EXEC_COMMON

SFO Assembled or Backflushed Component

P_SFOTrcblComponentAssembly is a Composite CDS View that provides data about "SFO Assembled or Backflushed Component" in SAP S/4HANA. It reads from 3 data sources (I_LogisticsOrder, I_MfgOrderCompAssemblyInstce, I_OpActyNtwkInstanceBasic) 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_COMMON.

Data Sources (3)

Source	Alias	Join Type
I_LogisticsOrder	LogisticsOrder	inner
I_MfgOrderCompAssemblyInstce	MfgOrderCompAssemblyInstce	from
I_OpActyNtwkInstanceBasic	OpActyNtwkInstanceBasic	inner

Associations (4)

Cardinality	Target	Alias	Condition
[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)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
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
	StorageLocation	I_MfgOrderCompAssemblyInstce	StorageLocation
	InventoryUsabilityCode	I_MfgOrderCompAssemblyInstce	InventoryUsabilityCode
	DgtlMockUpCharcsUUID	OpActyCompInstceAssignment	DgtlMockUpCharcsUUID
	RequiredQuantity
	MaterialComponentQuantity	I_MfgOrderCompAssemblyInstce	MaterialComponentQuantity
	MaterialBaseUnit	I_MfgOrderCompAssemblyInstce	MaterialBaseUnit
	QuantityInEntryUnit	I_MfgOrderCompAssemblyInstce	QuantityInEntryUnit
	EntryUnit	I_MfgOrderCompAssemblyInstce	EntryUnit
	DebitCreditCode	I_MfgOrderCompAssemblyInstce	DebitCreditCode
	ComponentAssemblyType	OpActyComponentAssignment	ComponentAssemblyType
	ManufacturingOrder	I_OpActyNtwkInstanceBasic	ManufacturingOrder
	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
	_ManufacturingOrder	I_OpActyNtwkInstanceBasic	_ManufacturingOrder

@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_SFOTrcblComponentAssembly
  as select from           I_MfgOrderCompAssemblyInstce as MfgOrderCompAssemblyInstce
    inner join             I_OpActyNtwkInstanceBasic    as OpActyNtwkInstanceBasic    on OpActyNtwkInstanceBasic.OpActyNtwkInstance = MfgOrderCompAssemblyInstce.OpActyNtwkInstance
    inner join             I_LogisticsOrder             as LogisticsOrder             on LogisticsOrder.OrderID = OpActyNtwkInstanceBasic.ManufacturingOrder
    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,
      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(LogisticsOrder.OrderPlannedTotalQty as esmng) * OpActyComponentAssignment.MfgOrderComponentUsageNetQty 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,
      OpActyNtwkInstanceBasic.ManufacturingOrder                                                                  as ManufacturingOrder,
      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,
      OpActyNtwkInstanceBasic._ManufacturingOrder
}

Depth:

P_SFOTrcblComponentAssembly view_entity

P_SFOAssldTrcblCompLdngResvn view_entity