P_OperationActyPRTAssignment

DDL: P_OPERATIONACTYPRTASSIGNMENT Type: view_entity CONSUMPTION
42 Fields 1 Data Sources 4 Associations

P_OperationActyPRTAssignment is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_OperationActyPRTUnion) and exposes 42 fields with key fields OpActyNtwkInstance, OpActyNtwkElement, OrderInternalID, MfgOrderOpProdnRsceToolIntID, Equipment. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_OperationActyPRTUnion OperationActyPRTAssignment from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ProdnRsceToolCategory_2 _ProdnRsceToolCategory $projection.ProdnRsceToolCategory = _ProdnRsceToolCategory.ProdnRsceToolCategory
[1..1] I_ProductionResourceType _ProductionResourceType $projection.ProductionResourceType = _ProductionResourceType.ProductionResourceType
[0..1] I_Plant _Plant $projection.ProductionPlant = _Plant.Plant
[0..*] I_MiscProdnRsceToolText _MiscProdnRsceToolText $projection.ProductionResourceType = _MiscProdnRsceToolText.ProductionResourceType and $projection.ProductionResourceInternalID = _MiscProdnRsceToolText.ProductionResourceInternalID

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 (42)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_OperationActyPRTUnion OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_OperationActyPRTUnion OpActyNtwkElement Element Number
KEY OrderInternalID P_OperationActyPRTUnion OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID P_OperationActyPRTUnion MfgOrderOpProdnRsceToolIntID
KEY Equipment P_OperationActyPRTUnion Equipment Equipment check
KEY ProductionResourceType P_OperationActyPRTUnion ProductionResourceType Object Type
KEY ProductionResourceInternalID P_OperationActyPRTUnion ProductionResourceInternalID Object ID
PRTIsUsedAsTestEquipment P_OperationActyPRTUnion PRTIsUsedAsTestEquipment Test Equipment
ProdnRsceToolCategory P_OperationActyPRTUnion ProdnRsceToolCategory
Material P_OperationActyPRTUnion Material Vehicle Model
DocumentType P_OperationActyPRTUnion DocumentType Order Type
DocumentInfoRecord P_OperationActyPRTUnion DocumentInfoRecord Document
DocumentVersion P_OperationActyPRTUnion DocumentVersion Docu. Version
DocumentPart P_OperationActyPRTUnion DocumentPart Document Part
MiscProductionResourceTool P_OperationActyPRTUnion MiscProductionResourceTool
ProdnRsceToolStdWorkQtyUnit P_OperationActyPRTUnion ProdnRsceToolStdWorkQtyUnit Unit
ProdnRsceToolStandardWorkQty P_OperationActyPRTUnion ProdnRsceToolStandardWorkQty Quantity
PlannedProdnRsceToolQtyUnit P_OperationActyPRTUnion PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty P_OperationActyPRTUnion PlannedTotalProdnRsceToolQty
NumberOfActvEquipRegistrations P_OperationActyPRTUnion NumberOfActvEquipRegistrations
BaseUnit P_OperationActyPRTUnion BaseUnit Unit of Measure
RegisteredPRTQtyInBaseUnit P_OperationActyPRTUnion RegisteredPRTQtyInBaseUnit
OrderProdnRsceToolText P_OperationActyPRTUnion OrderProdnRsceToolText
ProdnRsceToolRegnIsAllowed P_OperationActyPRTUnion ProdnRsceToolRegnIsAllowed Registrable
ManufacturingOrderCategory P_OperationActyPRTUnion ManufacturingOrderCategory
ManufacturingOrderType P_OperationActyPRTUnion ManufacturingOrderType
ProductionPlant P_OperationActyPRTUnion ProductionPlant Prod plnt
ProdnRsceToolItemNumber P_OperationActyPRTUnion ProdnRsceToolItemNumber Item Number
BOOOperationPRTInternalID P_OperationActyPRTUnion BOOOperationPRTInternalID
ShopFloorRtgPRTIsRegistrable P_OperationActyPRTUnion ShopFloorRtgPRTIsRegistrable
_OpActyNtwkInstance
_OperationActivityInstance P_OperationActyPRTUnion _OperationActivityInstance
_OrdInternalBillOfOperations P_OperationActyPRTUnion _OrdInternalBillOfOperations
_ProductionResourceType _ProductionResourceType
_ProdnRsceToolCategory _ProdnRsceToolCategory
_MfgOrderCategory P_OperationActyPRTUnion _MfgOrderCategory
_MfgOrderType P_OperationActyPRTUnion _MfgOrderType
_ProductionPlant _Plant
_Material P_OperationActyPRTUnion _Material
_Equipment P_OperationActyPRTUnion _Equipment
_PRTRegistrationControl P_OperationActyPRTUnion _PRTRegistrationControl
_MiscProdnRsceToolText _MiscProdnRsceToolText

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_OperationActyPRTAssignment.
-- 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_OperationActyPRTAssignment AS
SELECT
  OperationActyPRTAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActyPRTAssignment.OpActyNtwkElement AS OpActyNtwkElement,
  OperationActyPRTAssignment.OrderInternalID AS OrderInternalID,
  OperationActyPRTAssignment.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  OperationActyPRTAssignment.Equipment AS Equipment,
  OperationActyPRTAssignment.ProductionResourceType AS ProductionResourceType,
  OperationActyPRTAssignment.ProductionResourceInternalID AS ProductionResourceInternalID,
  OperationActyPRTAssignment.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  OperationActyPRTAssignment.ProdnRsceToolCategory AS ProdnRsceToolCategory,
  OperationActyPRTAssignment.Material AS Material,
  OperationActyPRTAssignment.DocumentType AS DocumentType,
  OperationActyPRTAssignment.DocumentInfoRecord AS DocumentInfoRecord,
  OperationActyPRTAssignment.DocumentVersion AS DocumentVersion,
  OperationActyPRTAssignment.DocumentPart AS DocumentPart,
  OperationActyPRTAssignment.MiscProductionResourceTool AS MiscProductionResourceTool,
  OperationActyPRTAssignment.ProdnRsceToolStdWorkQtyUnit AS ProdnRsceToolStdWorkQtyUnit,
  OperationActyPRTAssignment.ProdnRsceToolStandardWorkQty AS ProdnRsceToolStandardWorkQty,
  OperationActyPRTAssignment.PlannedProdnRsceToolQtyUnit AS PlannedProdnRsceToolQtyUnit,
  OperationActyPRTAssignment.PlannedTotalProdnRsceToolQty AS PlannedTotalProdnRsceToolQty,
  OperationActyPRTAssignment.NumberOfActvEquipRegistrations AS NumberOfActvEquipRegistrations,
  OperationActyPRTAssignment.BaseUnit AS BaseUnit,
  OperationActyPRTAssignment.RegisteredPRTQtyInBaseUnit AS RegisteredPRTQtyInBaseUnit,
  OperationActyPRTAssignment.OrderProdnRsceToolText AS OrderProdnRsceToolText,
  OperationActyPRTAssignment.ProdnRsceToolRegnIsAllowed AS ProdnRsceToolRegnIsAllowed,
  OperationActyPRTAssignment.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  OperationActyPRTAssignment.ManufacturingOrderType AS ManufacturingOrderType,
  OperationActyPRTAssignment.ProductionPlant AS ProductionPlant,
  OperationActyPRTAssignment.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  OperationActyPRTAssignment.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  OperationActyPRTAssignment.ShopFloorRtgPRTIsRegistrable AS ShopFloorRtgPRTIsRegistrable,
  OperationActyPRTAssignment._OperationActivityInstance AS _OperationActivityInstance,
  OperationActyPRTAssignment._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  OperationActyPRTAssignment._MfgOrderCategory AS _MfgOrderCategory,
  OperationActyPRTAssignment._MfgOrderType AS _MfgOrderType,
  OperationActyPRTAssignment._Material AS _Material,
  OperationActyPRTAssignment._Equipment AS _Equipment,
  OperationActyPRTAssignment._PRTRegistrationControl AS _PRTRegistrationControl
FROM P_OperationActyPRTUnion AS OperationActyPRTAssignment
LEFT OUTER JOIN I_ProdnRsceToolCategory_2 AS _ProdnRsceToolCategory ON ProdnRsceToolCategory = _ProdnRsceToolCategory.ProdnRsceToolCategory  -- association [1..1]
LEFT OUTER JOIN I_ProductionResourceType AS _ProductionResourceType ON ProductionResourceType = _ProductionResourceType.ProductionResourceType  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON ProductionPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MiscProdnRsceToolText AS _MiscProdnRsceToolText ON ProductionResourceType = _MiscProdnRsceToolText.ProductionResourceType AND ProductionResourceInternalID = _MiscProdnRsceToolText.ProductionResourceInternalID  -- association [0..*]
;

Learn More