P_OperationActivityCompUnion

DDL: P_OPERATIONACTIVITYCOMPUNION SQL: PMPEOACOMPUNION Type: view CONSUMPTION
136 Fields 5 Data Sources 1 Associations

P_OperationActivityCompUnion is a Consumption CDS View in SAP S/4HANA. It reads from 5 data sources (I_OpActyAssemblyByComponent, I_EAMMaterialItemCategory, I_MfgOrderOperationComponent, I_OpActyComponentAssignment, I_OrderOperation) and exposes 136 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, Reservation, ReservationItem, RecordType. It has 1 association to related views.

Data Sources (5)

SourceAliasJoin Type
I_OpActyAssemblyByComponent Agg union_all
I_EAMMaterialItemCategory MaterialItemCategory inner
I_MfgOrderOperationComponent MfgOrderOperationComponent inner
I_OpActyComponentAssignment OpActyComponentAssignment from
I_OrderOperation OrderOperation inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_OpActyAssemblyByComponent _OpActyAssemblyByComponent $projection.Reservation = _OpActyAssemblyByComponent.Reservation and $projection.ReservationItem = _OpActyAssemblyByComponent.ReservationItem and $projection.RecordType = _OpActyAssemblyByComponent.RecordType and $projection.OpActyNtwkInstance = _OpActyAssemblyByComponent.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OpActyAssemblyByComponent.OpActyNtwkElement and $projection.Material = _OpActyAssemblyByComponent.Material and $projection.Plant = _OpActyAssemblyByComponent.Plant

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PMPEOACOMPUNION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (136)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance I_OpActyComponentAssignment OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OpActyComponentAssignment OpActyNtwkElement Element Number
KEY Reservation I_MfgOrderOperationComponent Reservation Reservation
KEY ReservationItem I_MfgOrderOperationComponent ReservationItem Reservation Item
KEY RecordType I_MfgOrderOperationComponent RecordType Reservation Record Type
KEY Material I_MfgOrderOperationComponent Material Vehicle Model
KEY Plant I_MfgOrderOperationComponent Plant Valuation Area
StorageLocation I_MfgOrderOperationComponent StorageLocation StorageLocation
ProductionPlant I_MfgOrderOperationComponent ProductionPlant Prod plnt
AssemblySequenceNumber I_OpActyComponentAssignment AssemblySequenceNumber Assembly Sequence
BaseUnit I_MfgOrderOperationComponent BaseUnit Valuation Unit
MfgOrderComponentUsageQuantity I_OpActyComponentAssignment MfgOrderComponentUsageQuantity Usage qty - UoM
MaterialComponentQuantity _OpActyAssemblyByComponent MaterialComponentQuantity
QuantityInEntryUnit
EntryUnit _OpActyAssemblyByComponent EntryUnit Unit of Entry
BillOfMaterialItemNumber I_MfgOrderOperationComponent BillOfMaterialItemNumber_2
IsBulkMaterialComponent
MatlCompIsMarkedForBackflush
GoodsMovementIsAllowed I_MfgOrderOperationComponent GoodsMovementIsAllowed Mvt Allowed
MaterialComponentIsMissing I_MfgOrderOperationComponent MaterialComponentIsMissing Missing Part
ReservationIsFinallyIssued I_MfgOrderOperationComponent ReservationIsFinallyIssued Res Final Issue
MatlCompDiscontinuationType I_MfgOrderOperationComponent MatlCompDiscontinuationType Share of scrap
Batch I_MfgOrderOperationComponent Batch Lot No.
BatchSplitType I_MfgOrderOperationComponent BatchSplitType Checkbox
MaterialCompIsVariableSized
VariableSizeItemUnit I_MfgOrderOperationComponent VariableSizeItemUnit VSI unit
FormulaKey I_MfgOrderOperationComponent FormulaKey VSI Formula
VariableSizeDimension1 I_MfgOrderOperationComponent VariableSizeDimension1 Size 1
VariableSizeDimension2 I_MfgOrderOperationComponent VariableSizeDimension2 Size 2
VariableSizeDimension3 I_MfgOrderOperationComponent VariableSizeDimension3 Size 3
VariableSizeDimensionUnit I_MfgOrderOperationComponent VariableSizeDimensionUnit Size unit
VariableSizeComponentQuantity I_MfgOrderOperationComponent VariableSizeComponentQuantity VSI Quantity
VariableSizeComponentUnit I_MfgOrderOperationComponent VariableSizeComponentUnit VSI UoM
RelatedReservation
RelatedReservationItem I_OpActyComponentAssignment RelatedReservationItem Item no.
RelatedRecordType I_OpActyComponentAssignment RelatedRecordType Record type
RelatedOpActyNtwkInstance I_OpActyComponentAssignment RelatedOpActyNtwkInstance Instance ID
RelatedOpActyNtwkElement I_OpActyComponentAssignment RelatedOpActyNtwkElement Element Number
LeadingReservation I_OpActyComponentAssignment LeadingReservation Reservation
LeadingReservationItem I_OpActyComponentAssignment LeadingReservationItem Item no.
LeadingReservationRecordType I_OpActyComponentAssignment LeadingReservationRecordType Record type
LeadingOpActyNtwkInstance I_OpActyComponentAssignment LeadingOpActyNtwkInstance Instance ID
LeadingOpActyNtwkElement I_OpActyComponentAssignment LeadingOpActyNtwkElement Element Number
MaterialCompIsAlternativeItem
AlternativeItemGroup I_MfgOrderOperationComponent AlternativeItemGroup AltItemGroup
AlternativeItemStrategy I_MfgOrderOperationComponent AlternativeItemStrategy Strategy
AlternativeItemPriority I_MfgOrderOperationComponent AlternativeItemPriority Priority
UsageProbabilityPercent I_MfgOrderOperationComponent UsageProbabilityPercent Usage Prob.
OriginalReservation I_MfgOrderOperationComponent OriginalReservation Origl.Resv.no.
OriginalReservationItem I_MfgOrderOperationComponent OriginalReservationItem Origl. Item
BillOfMaterialCategory
BillOfMaterial I_MfgOrderOperationComponent BillOfMaterial BOM
BOMItem I_MfgOrderOperationComponent BOMItem
BOMItemInternalChangeCount I_MfgOrderOperationComponent BOMItemInternalChangeCount Counter
BillOfMaterialInternalID I_MfgOrderOperationComponent BillOfMaterialInternalID BOM
BillOfMaterialVariant I_MfgOrderOperationComponent BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion I_MfgOrderOperationComponent BillOfMaterialVersion BOM Version
InheritedBOMItemNode I_MfgOrderOperationComponent InheritedBOMItemNode Nodes
BOMItemCategory I_MfgOrderOperationComponent BOMItemCategory Item Category
BillOfMaterialItemUUID
BillOfOperationsType
BillOfOperationsGroup
BOOOpBOMItemInternalID I_OpActyComponentAssignment BOOOpBOMItemInternalID Allocation no.
LogicalComponent I_OpActyComponentAssignment LogicalComponent Logical Component
MfgRefStrucBOMLeafAssgmtUUID I_OpActyComponentAssignment MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID I_OpActyComponentAssignment MfgRefStructureItemDetailUUID MRS Item UUID
MfgRefStrucItmDetIsContextual I_OpActyComponentAssignment MfgRefStrucItmDetIsContextual Contextual
MatlCompInstceAssyIsRequired I_OpActyComponentAssignment MatlCompInstceAssyIsRequired Instances Exist
OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement I_OpActyAssemblyByComponent OpActyNtwkElement Element Number
KEY Reservation I_OpActyAssemblyByComponent Reservation Reservation
KEY ReservationItem I_OpActyAssemblyByComponent ReservationItem Reservation Item
KEY RecordType I_OpActyAssemblyByComponent RecordType Reservation Record Type
KEY Material I_OpActyAssemblyByComponent Material Vehicle Model
KEY Plant I_OpActyAssemblyByComponent Plant Valuation Area
StorageLocation StorageLocation
ProductionPlant Prod plnt
AssemblySequenceNumber Assembly Sequence
BaseUnit I_OpActyAssemblyByComponent MaterialBaseUnit Valuation Unit
MfgOrderComponentUsageQuantity Usage qty - UoM
RequiredQuantity
MaterialComponentQuantity I_OpActyAssemblyByComponent MaterialComponentQuantity
QuantityInEntryUnit
EntryUnit I_OpActyAssemblyByComponent EntryUnit Unit of Entry
BillOfMaterialItemNumber
IsBulkMaterialComponent
MatlCompIsMarkedForBackflush
GoodsMovementIsAllowed Mvt Allowed
MaterialComponentIsMissing Missing Part
ReservationIsFinallyIssued Res Final Issue
MatlCompDiscontinuationType Share of scrap
Batch Lot No.
BatchSplitType Checkbox
VariableSizeItemUnit VSI unit
FormulaKey VSI Formula
VariableSizeDimension1 Size 1
VariableSizeDimension2 Size 2
VariableSizeDimension3 Size 3
VariableSizeDimensionUnit Size unit
VariableSizeComponentQuantity VSI Quantity
VariableSizeComponentUnit VSI UoM
RelatedReservationItem Item no.
RelatedRecordType Record type
RelatedOpActyNtwkInstance Instance ID
RelatedOpActyNtwkElement Element Number
LeadingReservation Reservation
LeadingReservationItem Item no.
LeadingReservationRecordType Record type
LeadingOpActyNtwkInstance Instance ID
LeadingOpActyNtwkElement Element Number
MaterialCompIsAlternativeItem
AlternativeItemGroup AltItemGroup
AlternativeItemStrategy Strategy
AlternativeItemPriority Priority
UsageProbabilityPercent Usage Prob.
OriginalReservation Origl.Resv.no.
OriginalReservationItem Origl. Item
BillOfMaterialCategory
BillOfMaterial BOM
BOMItem
BOMItemInternalChangeCount Counter
BillOfMaterialInternalID BOM
BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion BOM Version
InheritedBOMItemNode Nodes
BOMItemCategory Item Category
BillOfMaterialItemUUID
BillOfOperationsType
BillOfOperationsGroup
BOOOpBOMItemInternalID Allocation no.
LogicalComponent Logical Component
MfgRefStrucBOMLeafAssgmtUUID Leaf Assignment UUID
MfgRefStructureItemDetailUUID MRS Item UUID
MfgRefStrucItmDetIsContextual Contextual
MatlCompInstceAssyIsRequired Instances Exist
MatlCompAssemblyIsNotRequired

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_OperationActivityCompUnion.
-- 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: PMPEOACOMPUNION

CREATE VIEW P_OperationActivityCompUnion AS
SELECT
  OpActyComponentAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyComponentAssignment.OpActyNtwkElement AS OpActyNtwkElement,
  MfgOrderOperationComponent.Reservation AS Reservation,
  MfgOrderOperationComponent.ReservationItem AS ReservationItem,
  MfgOrderOperationComponent.RecordType AS RecordType,
  MfgOrderOperationComponent.Material AS Material,
  MfgOrderOperationComponent.Plant AS Plant,
  MfgOrderOperationComponent.StorageLocation AS StorageLocation,
  MfgOrderOperationComponent.ProductionPlant AS ProductionPlant,
  OpActyComponentAssignment.AssemblySequenceNumber AS AssemblySequenceNumber,
  MfgOrderOperationComponent.BaseUnit AS BaseUnit,
  OpActyComponentAssignment.MfgOrderComponentUsageQuantity AS MfgOrderComponentUsageQuantity,
  _OpActyAssemblyByComponent.MaterialComponentQuantity AS MaterialComponentQuantity,
  _OpActyAssemblyByComponent.EntryUnit AS EntryUnit,
  MfgOrderOperationComponent.BillOfMaterialItemNumber_2 AS BillOfMaterialItemNumber,
  cast( MfgOrderOperationComponent.IsBulkMaterialComponent as boolean preserving type ) AS IsBulkMaterialComponent,
  cast( MfgOrderOperationComponent.MatlCompIsMarkedForBackflush as boolean preserving type ) AS MatlCompIsMarkedForBackflush,
  MfgOrderOperationComponent.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  MfgOrderOperationComponent.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  MfgOrderOperationComponent.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  MfgOrderOperationComponent.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  MfgOrderOperationComponent.Batch AS Batch,
  MfgOrderOperationComponent.BatchSplitType AS BatchSplitType,
  MfgOrderOperationComponent.VariableSizeItemUnit AS VariableSizeItemUnit,
  MfgOrderOperationComponent.FormulaKey AS FormulaKey,
  MfgOrderOperationComponent.VariableSizeDimension1 AS VariableSizeDimension1,
  MfgOrderOperationComponent.VariableSizeDimension2 AS VariableSizeDimension2,
  MfgOrderOperationComponent.VariableSizeDimension3 AS VariableSizeDimension3,
  MfgOrderOperationComponent.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  MfgOrderOperationComponent.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  MfgOrderOperationComponent.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  OpActyComponentAssignment.RelatedReservationItem AS RelatedReservationItem,
  OpActyComponentAssignment.RelatedRecordType AS RelatedRecordType,
  OpActyComponentAssignment.RelatedOpActyNtwkInstance AS RelatedOpActyNtwkInstance,
  OpActyComponentAssignment.RelatedOpActyNtwkElement AS RelatedOpActyNtwkElement,
  OpActyComponentAssignment.LeadingReservation AS LeadingReservation,
  OpActyComponentAssignment.LeadingReservationItem AS LeadingReservationItem,
  OpActyComponentAssignment.LeadingReservationRecordType AS LeadingReservationRecordType,
  OpActyComponentAssignment.LeadingOpActyNtwkInstance AS LeadingOpActyNtwkInstance,
  OpActyComponentAssignment.LeadingOpActyNtwkElement AS LeadingOpActyNtwkElement,
  MfgOrderOperationComponent.AlternativeItemGroup AS AlternativeItemGroup,
  MfgOrderOperationComponent.AlternativeItemStrategy AS AlternativeItemStrategy,
  MfgOrderOperationComponent.AlternativeItemPriority AS AlternativeItemPriority,
  MfgOrderOperationComponent.UsageProbabilityPercent AS UsageProbabilityPercent,
  MfgOrderOperationComponent.OriginalReservation AS OriginalReservation,
  MfgOrderOperationComponent.OriginalReservationItem AS OriginalReservationItem,
  MfgOrderOperationComponent.BillOfMaterial AS BillOfMaterial,
  MfgOrderOperationComponent.BOMItem AS BOMItem,
  MfgOrderOperationComponent.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  MfgOrderOperationComponent.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  MfgOrderOperationComponent.BillOfMaterialVariant AS BillOfMaterialVariant,
  MfgOrderOperationComponent.BillOfMaterialVersion AS BillOfMaterialVersion,
  MfgOrderOperationComponent.InheritedBOMItemNode AS InheritedBOMItemNode,
  MfgOrderOperationComponent.BOMItemCategory AS BOMItemCategory,
  OpActyComponentAssignment.BOOOpBOMItemInternalID AS BOOOpBOMItemInternalID,
  OpActyComponentAssignment.LogicalComponent AS LogicalComponent,
  OpActyComponentAssignment.MfgRefStrucBOMLeafAssgmtUUID AS MfgRefStrucBOMLeafAssgmtUUID,
  OpActyComponentAssignment.MfgRefStructureItemDetailUUID AS MfgRefStructureItemDetailUUID,
  OpActyComponentAssignment.MfgRefStrucItmDetIsContextual AS MfgRefStrucItmDetIsContextual,
  OpActyComponentAssignment.MatlCompInstceAssyIsRequired AS MatlCompInstceAssyIsRequired,
  cast('' as altps preserving type ) AS MaterialCompIsAlternativeItem,
  cast('' as pph_stlty preserving type) AS BillOfMaterialCategory,
  cast('' as mpe_not_assembly_relevant preserving type) AS MatlCompAssemblyIsNotRequired
FROM I_OpActyComponentAssignment AS OpActyComponentAssignment
INNER JOIN I_MfgOrderOperationComponent AS MfgOrderOperationComponent ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderOperation AS OrderOperation ON /* join condition not captured in parsed metadata */
INNER JOIN I_EAMMaterialItemCategory AS MaterialItemCategory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_OpActyAssemblyByComponent AS _OpActyAssemblyByComponent ON Reservation = _OpActyAssemblyByComponent.Reservation AND ReservationItem = _OpActyAssemblyByComponent.ReservationItem AND RecordType = _OpActyAssemblyByComponent.RecordType AND OpActyNtwkInstance = _OpActyAssemblyByComponent.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyAssemblyByComponent.OpActyNtwkElement AND Material = _OpActyAssemblyByComponent.Material AND Plant = _OpActyAssemblyByComponent.Plant  -- association [0..1]
-- UNION ALL with additional select branch(es): I_OpActyAssemblyByComponent
;

Learn More