P_AssldReltdComponentInstance

DDL: P_ASSLDRELTDCOMPONENTINSTANCE SQL: PMPEASSRLTDINST Type: view COMPOSITE
24 Fields 5 Data Sources

P_AssldReltdComponentInstance is a Composite CDS View 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.

Data Sources (5)

SourceAliasJoin Type
of of inner
I_OpActyCompInstceAssignment OpActyCompInstceAssignment inner
I_OpActyComponentAssignment OpActyComponentAssignment from
I_MfgOrderCompAssemblyInstce ReltdMfgOrderCompAssyInstce inner
to to left_outer

Annotations (10)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_OpActyComponentAssignment Reservation Reservation
KEY ReservationItem I_OpActyComponentAssignment ReservationItem Reservation Item
KEY RecordType I_OpActyComponentAssignment RecordType Reservation Record Type
KEY OpActyNtwkInstance I_OpActyComponentAssignment OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OpActyComponentAssignment OpActyNtwkElement Element Number
KEY AssemblyShopFloorItem I_MfgOrderCompAssemblyInstce AssemblyShopFloorItem
KEY OriglDgtlMockUpCharcsUUID I_OpActyCompInstceAssignment OriglDgtlMockUpCharcsUUID DMU GUID
ReltdOriglDgtlMockUpCharcsUUID I_OpActyCompInstceAssignment ReltdOriglDgtlMockUpCharcsUUID DMU GUID
Material I_MfgOrderCompAssemblyInstce Material Vehicle Model
Plant I_MfgOrderCompAssemblyInstce Plant Valuation Area
ReferenceDesignatorValue InstanceReferenceDesignator ReferenceDesignatorValue Ref. Designator
Batch I_MfgOrderCompAssemblyInstce Batch Lot No.
ShopFloorItem I_MfgOrderCompAssemblyInstce ShopFloorItem Serial.Mat. ID
RelatedReservation I_OpActyComponentAssignment RelatedReservation Reservation
RelatedReservationItem I_OpActyComponentAssignment RelatedReservationItem Item no.
RelatedRecordType I_OpActyComponentAssignment RelatedRecordType Record type
RelatedOpActyNtwkInstance I_OpActyComponentAssignment RelatedOpActyNtwkInstance Instance ID
RelatedOpActyNtwkElement I_OpActyComponentAssignment RelatedOpActyNtwkElement Element Number
_ReservationHeader I_OpActyComponentAssignment _ReservationHeader
_OpActyNtwkInstance I_OpActyComponentAssignment _OpActyNtwkInstance
_OperationActivityInstance I_OpActyComponentAssignment _OperationActivityInstance
_ParentShopFloorItem I_MfgOrderCompAssemblyInstce _ParentShopFloorItem
_ShopFloorItem I_MfgOrderCompAssemblyInstce _ShopFloorItem
_BatchDistinct I_MfgOrderCompAssemblyInstce _BatchDistinct

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_AssldReltdComponentInstance.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PMPEASSRLTDINST

CREATE VIEW P_AssldReltdComponentInstance AS
SELECT
  OpActyComponentAssignment.Reservation AS Reservation,
  OpActyComponentAssignment.ReservationItem AS ReservationItem,
  OpActyComponentAssignment.RecordType AS RecordType,
  OpActyComponentAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyComponentAssignment.OpActyNtwkElement AS OpActyNtwkElement,
  ReltdMfgOrderCompAssyInstce.AssemblyShopFloorItem AS AssemblyShopFloorItem,
  OpActyCompInstceAssignment.OriglDgtlMockUpCharcsUUID AS OriglDgtlMockUpCharcsUUID,
  OpActyCompInstceAssignment.ReltdOriglDgtlMockUpCharcsUUID AS ReltdOriglDgtlMockUpCharcsUUID,
  ReltdMfgOrderCompAssyInstce.Material AS Material,
  ReltdMfgOrderCompAssyInstce.Plant AS Plant,
  InstanceReferenceDesignator.ReferenceDesignatorValue AS ReferenceDesignatorValue,
  ReltdMfgOrderCompAssyInstce.Batch AS Batch,
  ReltdMfgOrderCompAssyInstce.ShopFloorItem AS ShopFloorItem,
  OpActyComponentAssignment.RelatedReservation AS RelatedReservation,
  OpActyComponentAssignment.RelatedReservationItem AS RelatedReservationItem,
  OpActyComponentAssignment.RelatedRecordType AS RelatedRecordType,
  OpActyComponentAssignment.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OpActyComponentAssignment.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OpActyComponentAssignment._ReservationHeader AS _ReservationHeader,
  OpActyComponentAssignment._OpActyNtwkInstance AS _OpActyNtwkInstance,
  OpActyComponentAssignment._OperationActivityInstance AS _OperationActivityInstance,
  ReltdMfgOrderCompAssyInstce._ParentShopFloorItem AS _ParentShopFloorItem,
  ReltdMfgOrderCompAssyInstce._ShopFloorItem AS _ShopFloorItem,
  ReltdMfgOrderCompAssyInstce._BatchDistinct AS _BatchDistinct
FROM I_OpActyComponentAssignment AS OpActyComponentAssignment
INNER JOIN I_OpActyCompInstceAssignment AS OpActyCompInstceAssignment ON /* join condition not captured in parsed metadata */
INNER JOIN of ON /* join condition not captured in parsed metadata */
INNER JOIN I_MfgOrderCompAssemblyInstce AS ReltdMfgOrderCompAssyInstce ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN to ON /* join condition not captured in parsed metadata */
;

Learn More