P_ASSLDRELTDCOMPONENTINSTANCE
Assembled Related Component Instance
P_ASSLDRELTDCOMPONENTINSTANCE is a CDS View in S/4HANA. Assembled Related Component Instance. It contains 16 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_AssldReltdCompInstceSrlNmbr | view | from | COMPOSITE | Assembled Related Component Instance and/or Serial Number |
Fields (16)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AssemblyShopFloorItem | AssemblyShopFloorItem | 1 |
| KEY | OpActyNtwkElement | OpActyNtwkElement | 1 |
| KEY | OpActyNtwkInstance | OpActyNtwkInstance | 1 |
| KEY | OriglDgtlMockUpCharcsUUID | OriglDgtlMockUpCharcsUUID | 1 |
| KEY | RecordType | RecordType | 1 |
| KEY | Reservation | Reservation | 1 |
| KEY | ReservationItem | ReservationItem | 1 |
| KEY | ShopFloorItem | ShopFloorItem | 1 |
| _OpActyNtwkInstance | _OpActyNtwkInstance | 1 | |
| _OperationActivityInstance | _OperationActivityInstance | 1 | |
| _ParentShopFloorItem | _ParentShopFloorItem | 1 | |
| _ReservationHeader | _ReservationHeader | 1 | |
| Batch | Batch | 1 | |
| ReferenceDesignatorName | ReferenceDesignatorName | 1 | |
| ReferenceDesignatorValue | ReferenceDesignatorValue | 1 | |
| ReltdOriglDgtlMockUpCharcsUUID | ReltdOriglDgtlMockUpCharcsUUID | 1 |
@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"