P_OperationActyPRTUnion

DDL: P_OPERATIONACTYPRTUNION Type: view_entity CONSUMPTION
115 Fields 3 Data Sources 3 Associations

P_OperationActyPRTUnion is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (I_OpActyInstceEquipActvRegn, I_OpActyInstcePRTRegnAggrgn, P_OperationActyPlannedPRT) and exposes 115 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, Equipment. It has 3 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_OpActyInstceEquipActvRegn OpActyInstceEquipActvRegn union_all
I_OpActyInstcePRTRegnAggrgn OpActyInstcePRTRegnAggrgn union_all
P_OperationActyPlannedPRT OperationActyPlannedPRT from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Equipment _Equipment $projection.Equipment = _Equipment.Equipment
[0..1] I_PRTRegistrationControl _PRTRegistrationControl $projection.PRTRegistrationControl = _PRTRegistrationControl.PRTRegistrationControl
[0..1] I_Material _Material $projection.Material = _Material.Material

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (115)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_OperationActyPlannedPRT OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_OperationActyPlannedPRT OpActyNtwkElement Element Number
KEY OrderInternalID P_OperationActyPlannedPRT OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID P_OperationActyPlannedPRT MfgOrderOpProdnRsceToolIntID
KEY Equipment P_OperationActyPlannedPRT Equipment Equipment check
KEY ProductionResourceType P_OperationActyPlannedPRT ProductionResourceType Object Type
KEY ProductionResourceInternalID P_OperationActyPlannedPRT ProductionResourceInternalID Object ID
PRTIsUsedAsTestEquipment P_OperationActyPlannedPRT PRTIsUsedAsTestEquipment Test Equipment
ProdnRsceToolCategory P_OperationActyPlannedPRT ProdnRsceToolCategory
Material P_OperationActyPlannedPRT Material Vehicle Model
DocumentType P_OperationActyPlannedPRT DocumentType Order Type
DocumentInfoRecord P_OperationActyPlannedPRT DocumentInfoRecord Document
DocumentVersion P_OperationActyPlannedPRT DocumentVersion Docu. Version
DocumentPart P_OperationActyPlannedPRT DocumentPart Document Part
MiscProductionResourceTool P_OperationActyPlannedPRT MiscProductionResourceTool
ProdnRsceToolStdWorkQtyUnit P_OperationActyPlannedPRT ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty P_OperationActyPlannedPRT ProdnRsceToolStandardWorkQty Quantity
PlannedProdnRsceToolQtyUnit P_OperationActyPlannedPRT PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty P_OperationActyPlannedPRT PlannedTotalProdnRsceToolQty
NumberOfActvEquipRegistrations P_OperationActyPlannedPRT NumberOfActvEquipRegistrations
BaseUnit P_OperationActyPlannedPRT BaseUnit Valuation Unit
RegisteredPRTQtyInBaseUnit P_OperationActyPlannedPRT RegisteredPRTQtyInBaseUnit
OrderProdnRsceToolText P_OperationActyPlannedPRT OrderProdnRsceToolText
ProdnRsceToolRegnIsAllowed P_OperationActyPlannedPRT ProdnRsceToolRegnIsAllowed Registrable
ManufacturingOrderCategory P_OperationActyPlannedPRT ManufacturingOrderCategory
ManufacturingOrderType P_OperationActyPlannedPRT ManufacturingOrderType
ProductionPlant P_OperationActyPlannedPRT ProductionPlant Prod plnt
ProdnRsceToolItemNumber P_OperationActyPlannedPRT ProdnRsceToolItemNumber Item Number
BOOOperationPRTInternalID P_OperationActyPlannedPRT BOOOperationPRTInternalID
ShopFloorRtgPRTIsRegistrable P_OperationActyPlannedPRT ShopFloorRtgPRTIsRegistrable
PRTRegistrationControl P_OperationActyPlannedPRT PRTRegistrationControl
_OpActyNtwkInstance
_OperationActivityInstance P_OperationActyPlannedPRT _OperationActivityInstance
_OrdInternalBillOfOperations P_OperationActyPlannedPRT _OrdInternalBillOfOperations
_Material P_OperationActyPlannedPRT _Material
_Equipment P_OperationActyPlannedPRT _Equipment
_MfgOrderCategory P_OperationActyPlannedPRT _MfgOrderCategory
_MfgOrderType P_OperationActyPlannedPRT _MfgOrderType
OpActyNtwkInstanceasOpActyNtwkInstance
KEY OpActyNtwkElement I_OpActyInstceEquipActvRegn OpActyNtwkElement Element Number
KEY OrderInternalID I_OpActyInstceEquipActvRegn OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID I_OpActyInstceEquipActvRegn MfgOrderOpProdnRsceToolIntID
KEY Equipment I_OpActyInstceEquipActvRegn Equipment Equipment check
KEY ProductionResourceType Object Type
KEY ProductionResourceInternalID Object ID
PRTIsUsedAsTestEquipment Test Equipment
ProdnRsceToolCategory
Material I_OpActyInstceEquipActvRegn EquipmentMaterial Vehicle Model
DocumentType Order Type
DocumentInfoRecord Document
DocumentVersion Docu. Version
DocumentPart Document Part
MiscProductionResourceTool
ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty Quantity
PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty
NumberOfActvEquipRegistrations
BaseUnit Valuation Unit
RegisteredPRTQtyInBaseUnit
OrderProdnRsceToolText
ProdnRsceToolRegnIsAllowed Registrable
ManufacturingOrderCategory
ManufacturingOrderType
ProductionPlant Prod plnt
ProdnRsceToolItemNumber Item Number
BOOOperationPRTInternalID
ShopFloorRtgPRTIsRegistrable
PRTRegistrationControl
_OpActyNtwkInstance
_OperationActivityInstance I_OpActyInstceEquipActvRegn _OperationActivityInstance
_OrdInternalBillOfOperations I_OpActyInstceEquipActvRegn _OrdInternalBillOfOperations
_Material I_OpActyInstceEquipActvRegn _Material
_Equipment _Equipment
_MfgOrderCategory
_MfgOrderType
OpActyNtwkInstanceasOpActyNtwkInstance
KEY OpActyNtwkElement I_OpActyInstcePRTRegnAggrgn OpActyNtwkElement Element Number
KEY OrderInternalID I_OpActyInstcePRTRegnAggrgn OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID I_OpActyInstcePRTRegnAggrgn MfgOrderOpProdnRsceToolIntID
KEY Equipment Equipment check
KEY ProductionResourceType I_OpActyInstcePRTRegnAggrgn ProductionResourceType Object Type
KEY ProductionResourceInternalID I_OpActyInstcePRTRegnAggrgn ProductionResourceInternalID Object ID
PRTIsUsedAsTestEquipment Test Equipment
ProdnRsceToolCategory
Material MaterialPRT Material Vehicle Model
DocumentType Order Type
DocumentInfoRecord Document
DocumentVersion Docu. Version
DocumentPart Document Part
MiscProductionResourceTool
ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty Quantity
PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty
NumberOfActvEquipRegistrations
BaseUnit I_OpActyInstcePRTRegnAggrgn MaterialBaseUnit Valuation Unit
RegisteredPRTQtyInBaseUnit I_OpActyInstcePRTRegnAggrgn SumOfRegtrdPRTQtyInBaseUnit
OrderProdnRsceToolText
ProdnRsceToolRegnIsAllowed Registrable
ManufacturingOrderCategory
ManufacturingOrderType
ProductionPlant Prod plnt
ProdnRsceToolItemNumber Item Number
BOOOperationPRTInternalID
ShopFloorRtgPRTIsRegistrable
PRTRegistrationControl
_OpActyNtwkInstance
_OperationActivityInstance I_OpActyInstcePRTRegnAggrgn _OperationActivityInstance
_OrdInternalBillOfOperations I_OpActyInstcePRTRegnAggrgn _OrdInternalBillOfOperations
_Material _Material
_Equipment _Equipment
_MfgOrderCategory
_MfgOrderType
_PRTRegistrationControl _PRTRegistrationControl

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_OperationActyPRTUnion.
-- 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.

CREATE VIEW P_OperationActyPRTUnion AS
SELECT
  OperationActyPlannedPRT.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActyPlannedPRT.OpActyNtwkElement AS OpActyNtwkElement,
  OperationActyPlannedPRT.OrderInternalID AS OrderInternalID,
  OperationActyPlannedPRT.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  OperationActyPlannedPRT.Equipment AS Equipment,
  OperationActyPlannedPRT.ProductionResourceType AS ProductionResourceType,
  OperationActyPlannedPRT.ProductionResourceInternalID AS ProductionResourceInternalID,
  OperationActyPlannedPRT.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  OperationActyPlannedPRT.ProdnRsceToolCategory AS ProdnRsceToolCategory,
  OperationActyPlannedPRT.Material AS Material,
  OperationActyPlannedPRT.DocumentType AS DocumentType,
  OperationActyPlannedPRT.DocumentInfoRecord AS DocumentInfoRecord,
  OperationActyPlannedPRT.DocumentVersion AS DocumentVersion,
  OperationActyPlannedPRT.DocumentPart AS DocumentPart,
  OperationActyPlannedPRT.MiscProductionResourceTool AS MiscProductionResourceTool,
  OperationActyPlannedPRT.ProdnRsceToolStdWorkQtyUnit AS ProdnRsceToolStdWorkQtyUnit,
  OperationActyPlannedPRT.ProdnRsceToolStandardWorkQty AS ProdnRsceToolStandardWorkQty,
  OperationActyPlannedPRT.PlannedProdnRsceToolQtyUnit AS PlannedProdnRsceToolQtyUnit,
  OperationActyPlannedPRT.PlannedTotalProdnRsceToolQty AS PlannedTotalProdnRsceToolQty,
  OperationActyPlannedPRT.NumberOfActvEquipRegistrations AS NumberOfActvEquipRegistrations,
  OperationActyPlannedPRT.BaseUnit AS BaseUnit,
  OperationActyPlannedPRT.RegisteredPRTQtyInBaseUnit AS RegisteredPRTQtyInBaseUnit,
  OperationActyPlannedPRT.OrderProdnRsceToolText AS OrderProdnRsceToolText,
  OperationActyPlannedPRT.ProdnRsceToolRegnIsAllowed AS ProdnRsceToolRegnIsAllowed,
  OperationActyPlannedPRT.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  OperationActyPlannedPRT.ManufacturingOrderType AS ManufacturingOrderType,
  OperationActyPlannedPRT.ProductionPlant AS ProductionPlant,
  OperationActyPlannedPRT.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  OperationActyPlannedPRT.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  OperationActyPlannedPRT.ShopFloorRtgPRTIsRegistrable AS ShopFloorRtgPRTIsRegistrable,
  OperationActyPlannedPRT.PRTRegistrationControl AS PRTRegistrationControl,
  OperationActyPlannedPRT._OperationActivityInstance AS _OperationActivityInstance,
  OperationActyPlannedPRT._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  OperationActyPlannedPRT._Material AS _Material,
  OperationActyPlannedPRT._Equipment AS _Equipment,
  OperationActyPlannedPRT._MfgOrderCategory AS _MfgOrderCategory,
  OperationActyPlannedPRT._MfgOrderType AS _MfgOrderType,
  OperationActyPlannedPRT._PRTRegistrationControl AS OpActyNtwkInstanceasOpActyNtwkInstance
FROM P_OperationActyPlannedPRT AS OperationActyPlannedPRT
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [0..1]
LEFT OUTER JOIN I_PRTRegistrationControl AS _PRTRegistrationControl ON PRTRegistrationControl = _PRTRegistrationControl.PRTRegistrationControl  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
-- UNION ALL with additional select branch(es): I_OpActyInstceEquipActvRegn, I_OpActyInstcePRTRegnAggrgn
;

Learn More