P_OpActyComponentAssignmentDMU

DDL: P_OPACTYCOMPONENTASSIGNMENTDMU SQL: PMPECOMPDMUA Type: view COMPOSITE
20 Fields 2 Data Sources

P_OpActyComponentAssignmentDMU is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_OpActyComponentAssignment, I_MfgOrderOperationComponent) and exposes 20 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, Reservation, ReservationItem, RecordType.

Data Sources (2)

SourceAliasJoin Type
I_OpActyComponentAssignment comp from
I_MfgOrderOperationComponent resb inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMPECOMPDMUA view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OpActyComponentAssignment OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OpActyComponentAssignment OpActyNtwkElement Element Number
KEY Reservation I_OpActyComponentAssignment Reservation Reservation
KEY ReservationItem I_OpActyComponentAssignment ReservationItem Reservation Item
KEY RecordType I_OpActyComponentAssignment RecordType Reservation Record Type
MaterialComponent I_MfgOrderOperationComponent Material Vehicle Model
ProductionPlant I_MfgOrderOperationComponent Plant Valuation Area
StorageLocation I_MfgOrderOperationComponent StorageLocation StorageLocation
MfgOrderComponentUsageQuantity I_OpActyComponentAssignment MfgOrderComponentUsageQuantity Usage qty - UoM
MfgOrderComponentUsageNetQty I_OpActyComponentAssignment MfgOrderComponentUsageNetQty Usage qty - UoM
AssemblySequenceNumber I_OpActyComponentAssignment AssemblySequenceNumber Assembly Sequence
MatlCompIsMarkedForBackflush I_MfgOrderOperationComponent MatlCompIsMarkedForBackflush Backflush
BillOfMaterialItemUUID stpo BillOfMaterialItemUUID Guid
_OpActyNtwkInstance _OpActyNtwkInstance
_OperationActivityInstance _OperationActivityInstance
_ReservationHeader _ReservationHeader
_Material _Material
_MaterialPlant
_Plant _Plant
_StorageLocation _StorageLocation

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_OpActyComponentAssignmentDMU.
-- 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: PMPECOMPDMUA

CREATE VIEW P_OpActyComponentAssignmentDMU AS
SELECT
  comp.OpActyNtwkInstance AS OpActyNtwkInstance,
  comp.OpActyNtwkElement AS OpActyNtwkElement,
  comp.Reservation AS Reservation,
  comp.ReservationItem AS ReservationItem,
  comp.RecordType AS RecordType,
  resb.Material AS MaterialComponent,
  resb.Plant AS ProductionPlant,
  resb.StorageLocation AS StorageLocation,
  comp.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageQuantity,
  comp.MfgOrderComponentUsageNetQty AS MfgOrderComponentUsageNetQty,
  comp.AssemblySequenceNumber AS AssemblySequenceNumber,
  resb.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  stpo.BillOfMaterialItemUUID AS BillOfMaterialItemUUID
FROM I_OpActyComponentAssignment AS comp
INNER JOIN I_MfgOrderOperationComponent AS resb ON /* join condition not captured in parsed metadata */
;

Learn More