P_AssldReltdComponentInstance

Q: Which tables does P_AssldReltdComponentInstance use?

P_AssldReltdComponentInstance reads from 5 data source(s): of, I_OpActyCompInstceAssignment, I_OpActyComponentAssignment, I_MfgOrderCompAssemblyInstce, to.

Q: How many fields does P_AssldReltdComponentInstance have?

P_AssldReltdComponentInstance has 24 fields. Key fields: Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement.

DDL: P_ASSLDRELTDCOMPONENTINSTANCE SQL: PMPEASSRLTDINST Type: view COMPOSITE Package: MPE_EXEC_SFO

Assembled Related Component Instance

P_AssldReltdComponentInstance is a Composite CDS View that provides data about "Assembled Related Component Instance" in SAP S/4HANA. It reads from 5 data sources (of, I_OpActyCompInstceAssignment, I_OpActyComponentAssignment, I_MfgOrderCompAssemblyInstce, to) and exposes 24 fields with key fields Reservation, ReservationItem, RecordType, OpActyNtwkInstance, OpActyNtwkElement. Part of development package MPE_EXEC_SFO.

Data Sources (5)

Source	Alias	Join Type
of	of	inner
I_OpActyCompInstceAssignment	OpActyCompInstceAssignment	inner
I_OpActyComponentAssignment	OpActyComponentAssignment	from
I_MfgOrderCompAssemblyInstce	ReltdMfgOrderCompAssyInstce	inner
to	to	left_outer

Annotations (10)

Name	Value	Level
AbapCatalog.sqlViewName	PMPEASSRLTDINST	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view

Fields (24)

Key	Field	Source Table	Source Field
KEY	Reservation	I_OpActyComponentAssignment	Reservation
KEY	ReservationItem	I_OpActyComponentAssignment	ReservationItem
KEY	RecordType	I_OpActyComponentAssignment	RecordType
KEY	OpActyNtwkInstance	I_OpActyComponentAssignment	OpActyNtwkInstance
KEY	OpActyNtwkElement	I_OpActyComponentAssignment	OpActyNtwkElement
KEY	AssemblyShopFloorItem	I_MfgOrderCompAssemblyInstce	AssemblyShopFloorItem
KEY	OriglDgtlMockUpCharcsUUID	I_OpActyCompInstceAssignment	OriglDgtlMockUpCharcsUUID
	ReltdOriglDgtlMockUpCharcsUUID	I_OpActyCompInstceAssignment	ReltdOriglDgtlMockUpCharcsUUID
	Material	I_MfgOrderCompAssemblyInstce	Material
	Plant	I_MfgOrderCompAssemblyInstce	Plant
	ReferenceDesignatorValue	InstanceReferenceDesignator	ReferenceDesignatorValue
	Batch	I_MfgOrderCompAssemblyInstce	Batch
	ShopFloorItem	I_MfgOrderCompAssemblyInstce	ShopFloorItem
	RelatedReservation	I_OpActyComponentAssignment	RelatedReservation
	RelatedReservationItem	I_OpActyComponentAssignment	RelatedReservationItem
	RelatedRecordType	I_OpActyComponentAssignment	RelatedRecordType
	RelatedOpActyNtwkInstance	I_OpActyComponentAssignment	RelatedOpActyNtwkInstance
	RelatedOpActyNtwkElement	I_OpActyComponentAssignment	RelatedOpActyNtwkElement
	_ReservationHeader	I_OpActyComponentAssignment	_ReservationHeader
	_OpActyNtwkInstance	I_OpActyComponentAssignment	_OpActyNtwkInstance
	_OperationActivityInstance	I_OpActyComponentAssignment	_OperationActivityInstance
	_ParentShopFloorItem	I_MfgOrderCompAssemblyInstce	_ParentShopFloorItem
	_ShopFloorItem	I_MfgOrderCompAssemblyInstce	_ShopFloorItem
	_BatchDistinct	I_MfgOrderCompAssemblyInstce	_BatchDistinct

@AbapCatalog.sqlViewName: 'PMPEASSRLTDINST'
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_AssldReltdComponentInstance
  -- Fetch the current reservation instance
  as select from           I_OpActyComponentAssignment   as OpActyComponentAssignment
    inner join             I_OpActyCompInstceAssignment  as OpActyCompInstceAssignment  on  OpActyCompInstceAssignment.Reservation        = OpActyComponentAssignment.Reservation
                                                                                        and OpActyCompInstceAssignment.ReservationItem    = OpActyComponentAssignment.ReservationItem
                                                                                        and OpActyCompInstceAssignment.RecordType         = OpActyComponentAssignment.RecordType
                                                                                        and OpActyCompInstceAssignment.OpActyNtwkInstance = OpActyComponentAssignment.OpActyNtwkInstance
                                                                                        and OpActyCompInstceAssignment.OpActyNtwkElement  = OpActyComponentAssignment.OpActyNtwkElement
  -- Inner join of referenced reservation instances which have been assembled
    inner join             I_MfgOrderCompAssemblyInstce  as ReltdMfgOrderCompAssyInstce on  ReltdMfgOrderCompAssyInstce.Reservation               = OpActyComponentAssignment.RelatedReservation
                                                                                        and ReltdMfgOrderCompAssyInstce.ReservationItem           = OpActyComponentAssignment.RelatedReservationItem
                                                                                        and ReltdMfgOrderCompAssyInstce.RecordType                = OpActyComponentAssignment.RelatedRecordType
                                                                                        and ReltdMfgOrderCompAssyInstce.OpActyNtwkInstance        = OpActyComponentAssignment.RelatedOpActyNtwkInstance
                                                                                        and ReltdMfgOrderCompAssyInstce.OpActyNtwkElement         = OpActyComponentAssignment.RelatedOpActyNtwkElement
                                                                                        and ReltdMfgOrderCompAssyInstce.OriglDgtlMockUpCharcsUUID = OpActyCompInstceAssignment.ReltdOriglDgtlMockUpCharcsUUID
                                                                                        and ReltdMfgOrderCompAssyInstce.IsReversed                = ''
                                                                                        and ReltdMfgOrderCompAssyInstce.IsReversal                = ''
  -- Left outer join to reservation instances required for for where-statement
    left outer to one join I_MfgOrderCompAssemblyInstce  as MfgOrderCompAssemblyInstce  on  MfgOrderCompAssemblyInstce.Reservation               = OpActyComponentAssignment.Reservation
                                                                                        and MfgOrderCompAssemblyInstce.ReservationItem           = OpActyComponentAssignment.ReservationItem
                                                                                        and MfgOrderCompAssemblyInstce.RecordType                = OpActyComponentAssignment.RecordType
                                                                                        and MfgOrderCompAssemblyInstce.OpActyNtwkInstance        = OpActyComponentAssignment.OpActyNtwkInstance
                                                                                        and MfgOrderCompAssemblyInstce.OpActyNtwkElement         = OpActyComponentAssignment.OpActyNtwkElement
                                                                                        and MfgOrderCompAssemblyInstce.AssemblyShopFloorItem     = ReltdMfgOrderCompAssyInstce.AssemblyShopFloorItem
                                                                                        and MfgOrderCompAssemblyInstce.OriglDgtlMockUpCharcsUUID = OpActyCompInstceAssignment.OriglDgtlMockUpCharcsUUID
                                                                                        and MfgOrderCompAssemblyInstce.IsReversed                = ''
                                                                                        and MfgOrderCompAssemblyInstce.IsReversal                = ''
    left outer to one join I_InstanceReferenceDesignator as InstanceReferenceDesignator on  InstanceReferenceDesignator.DgtlMockUpCharcsUUID  = OpActyCompInstceAssignment.DgtlMockUpCharcsUUID

{
  key OpActyComponentAssignment.Reservation,
  key OpActyComponentAssignment.ReservationItem,
  key OpActyComponentAssignment.RecordType,
  key OpActyComponentAssignment.OpActyNtwkInstance,
  key OpActyComponentAssignment.OpActyNtwkElement,
  key ReltdMfgOrderCompAssyInstce.AssemblyShopFloorItem,
  key OpActyCompInstceAssignment.OriglDgtlMockUpCharcsUUID,
      OpActyCompInstceAssignment.ReltdOriglDgtlMockUpCharcsUUID,
      ReltdMfgOrderCompAssyInstce.Material,
      ReltdMfgOrderCompAssyInstce.Plant,
      cast(case
        when OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual = 'X'
        and OpActyCompInstceAssignment._MfgRefHierItemWithDetails.HierMfgReferenceDesignatorName is not null
        and OpActyCompInstceAssignment._MfgRefHierItemWithDetails.HierMfgReferenceDesignatorName <> ''
          then OpActyCompInstceAssignment._MfgRefHierItemWithDetails.HierMfgReferenceDesignatorName
        when OpActyCompInstceAssignment.MfgRefStrucItmDetIsContextual = ''
        and OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDsgntrName is not null
        and OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDsgntrName <> ''
          then OpActyCompInstceAssignment._MfgRefStrucItemWithDetails.MfgRefStrucItmRefDsgntrName
        when OpActyCompInstceAssignment._InstanceReferenceDesignator.ReferenceDesignatorValue is not null
        or   OpActyCompInstceAssignment._InstanceReferenceDesignator.ReferenceDesignatorValue <> ''
          then OpActyCompInstceAssignment._InstanceReferenceDesignator.ReferenceDesignatorValue
      -- If no RefDes exists, use GUID as Fallback (instead of having empty RefDes)
        else bintohex( OpActyCompInstceAssignment.OriglDgtlMockUpCharcsUUID )
      end as vmp_ref_des) as ReferenceDesignatorName,
      InstanceReferenceDesignator.ReferenceDesignatorValue,
      ReltdMfgOrderCompAssyInstce.Batch,
      ReltdMfgOrderCompAssyInstce.ShopFloorItem,
      OpActyComponentAssignment.RelatedReservation,
      OpActyComponentAssignment.RelatedReservationItem,
      OpActyComponentAssignment.RelatedRecordType,
      OpActyComponentAssignment.RelatedOpActyNtwkInstance,
      OpActyComponentAssignment.RelatedOpActyNtwkElement,

      OpActyComponentAssignment._ReservationHeader,
      OpActyComponentAssignment._OpActyNtwkInstance,
      OpActyComponentAssignment._OperationActivityInstance,
      ReltdMfgOrderCompAssyInstce._ParentShopFloorItem,
      ReltdMfgOrderCompAssyInstce._ShopFloorItem,
      ReltdMfgOrderCompAssyInstce._BatchDistinct
}
where
      OpActyComponentAssignment.MatlCompInstceAssyIsRequired = 'X'   --Only components with assemblies on instance-level
  and MfgOrderCompAssemblyInstce.OriglDgtlMockUpCharcsUUID   is null --Only those referenced reservation instances that have not yet been "reprocessed"

Depth:

P_AssldReltdComponentInstance view

I_AssldReltdCompInstceSrlNmbr view