C_OperationActyPRTAssignment

DDL: C_OPERATIONACTYPRTASSIGNMENT SQL: CMPEOAPRTA Type: view CONSUMPTION
44 Fields 1 Data Sources 1 Associations

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

Data Sources (1)

SourceAliasJoin Type
P_OperationActyPRTAssignment OperationActyPRTAssignment from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OpActyInstceEquipActvRegn _OpActyInstceEquipActvRegn $projection.OpActyNtwkInstance = _OpActyInstceEquipActvRegn.OpActyNtwkInstance and $projection.OpActyNtwkElement = _OpActyInstceEquipActvRegn.OpActyNtwkElement and $projection.OrderInternalID = _OpActyInstceEquipActvRegn.OrderInternalID and $projection.MfgOrderOpProdnRsceToolIntID = _OpActyInstceEquipActvRegn.MfgOrderOpProdnRsceToolIntID and ( $projection.ProdnRsceToolCategory <> 'E' or $projection.Equipment = _OpActyInstceEquipActvRegn.Equipment )

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CMPEOAPRTA view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY OpActyNtwkInstance P_OperationActyPRTAssignment OpActyNtwkInstance Instance ID
KEY OpActyNtwkElement P_OperationActyPRTAssignment OpActyNtwkElement Element Number
KEY OrderInternalID P_OperationActyPRTAssignment OrderInternalID Plan No.f.Oper.
KEY MfgOrderOpProdnRsceToolIntID P_OperationActyPRTAssignment MfgOrderOpProdnRsceToolIntID
KEY Equipment
KEY ProductionResourceType P_OperationActyPRTAssignment ProductionResourceType Object Type
KEY ProductionResourceInternalID P_OperationActyPRTAssignment ProductionResourceInternalID Object ID
PRTIsUsedAsTestEquipment P_OperationActyPRTAssignment PRTIsUsedAsTestEquipment Test Equipment
ProdnRsceToolCategory
ProdnRsceToolCategoryName
MiscProductionResourceTool P_OperationActyPRTAssignment MiscProductionResourceTool
ProdnRsceToolRegnIsAllowed P_OperationActyPRTAssignment ProdnRsceToolRegnIsAllowed Registrable
Material P_OperationActyPRTAssignment Material Vehicle Model
MaterialName
SerialNumber
UniqueItemIdentifier
DocumentType P_OperationActyPRTAssignment DocumentType Order Type
DocumentInfoRecord P_OperationActyPRTAssignment DocumentInfoRecord Document
DocumentVersion P_OperationActyPRTAssignment DocumentVersion Docu. Version
DocumentPart P_OperationActyPRTAssignment DocumentPart Document Part
PlannedProdnRsceToolQtyUnit P_OperationActyPRTAssignment PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty P_OperationActyPRTAssignment PlannedTotalProdnRsceToolQty
PlannedTotalProdnRsceToolQtythen1red
NumberOfActvEquipRegistrations P_OperationActyPRTAssignment NumberOfActvEquipRegistrations
BaseUnit P_OperationActyPRTAssignment BaseUnit Unit of Measure
RegisteredPRTQtyInBaseUnit
ManufacturingOrderCategory P_OperationActyPRTAssignment ManufacturingOrderCategory
ManufacturingOrderType P_OperationActyPRTAssignment ManufacturingOrderType
ProductionPlant P_OperationActyPRTAssignment ProductionPlant Prod plnt
ProdnRsceToolItemNumber P_OperationActyPRTAssignment ProdnRsceToolItemNumber Item Number
MfgOrderOpPRTItemNumber
BOOOperationPRTInternalID P_OperationActyPRTAssignment BOOOperationPRTInternalID
PRTRegistrationControl P_OperationActyPRTAssignment PRTRegistrationControl Registration Type
PRTRegistrationControlName
_OpActyNtwkInstance
_OperationActivityInstance P_OperationActyPRTAssignment _OperationActivityInstance
_OrdInternalBillOfOperations P_OperationActyPRTAssignment _OrdInternalBillOfOperations
_ProductionResourceType P_OperationActyPRTAssignment _ProductionResourceType
_ProdnRsceToolCategory P_OperationActyPRTAssignment _ProdnRsceToolCategory
_Material P_OperationActyPRTAssignment _Material
_MfgOrderCategory P_OperationActyPRTAssignment _MfgOrderCategory
_MfgOrderType P_OperationActyPRTAssignment _MfgOrderType
_OpActyInstceEquipActvRegn _OpActyInstceEquipActvRegn
_ProductionPlant P_OperationActyPRTAssignment _ProductionPlant

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 C_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.
-- SQL view name: CMPEOAPRTA

CREATE VIEW C_OperationActyPRTAssignment AS
SELECT
  OperationActyPRTAssignment.OpActyNtwkInstance AS OpActyNtwkInstance,
  OperationActyPRTAssignment.OpActyNtwkElement AS OpActyNtwkElement,
  OperationActyPRTAssignment.OrderInternalID AS OrderInternalID,
  OperationActyPRTAssignment.MfgOrderOpProdnRsceToolIntID AS MfgOrderOpProdnRsceToolIntID,
  cast(coalesce(OperationActyPRTAssignment.Equipment, '') as equnr) AS Equipment,
  OperationActyPRTAssignment.ProductionResourceType AS ProductionResourceType,
  OperationActyPRTAssignment.ProductionResourceInternalID AS ProductionResourceInternalID,
  OperationActyPRTAssignment.PRTIsUsedAsTestEquipment AS PRTIsUsedAsTestEquipment,
  cast(OperationActyPRTAssignment.ProdnRsceToolCategory as mpe_fhmar preserving type) AS ProdnRsceToolCategory,
  OperationActyPRTAssignment._ProdnRsceToolCategory._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName AS ProdnRsceToolCategoryName,
  OperationActyPRTAssignment.MiscProductionResourceTool AS MiscProductionResourceTool,
  OperationActyPRTAssignment.ProdnRsceToolRegnIsAllowed AS ProdnRsceToolRegnIsAllowed,
  OperationActyPRTAssignment.Material AS Material,
  OperationActyPRTAssignment._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  OperationActyPRTAssignment._Equipment.SerialNumber AS SerialNumber,
  OperationActyPRTAssignment._Equipment.UniqueItemIdentifier AS UniqueItemIdentifier,
  OperationActyPRTAssignment.DocumentType AS DocumentType,
  OperationActyPRTAssignment.DocumentInfoRecord AS DocumentInfoRecord,
  OperationActyPRTAssignment.DocumentVersion AS DocumentVersion,
  OperationActyPRTAssignment.DocumentPart AS DocumentPart,
  OperationActyPRTAssignment.PlannedProdnRsceToolQtyUnit AS PlannedProdnRsceToolQtyUnit,
  OperationActyPRTAssignment.PlannedTotalProdnRsceToolQty AS PlannedTotalProdnRsceToolQty,
  case when OperationActyPRTAssignment.MfgOrderOpProdnRsceToolIntID = '00000000' then 1 else case when OperationActyPRTAssignment.RegisteredPRTQtyInBaseUnit = 0 or OperationActyPRTAssignment.RegisteredPRTQtyInBaseUnit is null or OperationActyPRTAssignment.PlannedTotalProdnRsceToolQty is null then 0 AS PlannedTotalProdnRsceToolQtythen1red,
  OperationActyPRTAssignment.NumberOfActvEquipRegistrations AS NumberOfActvEquipRegistrations,
  OperationActyPRTAssignment.BaseUnit AS BaseUnit,
  cast( OperationActyPRTAssignment.RegisteredPRTQtyInBaseUnit as mpe_prt_registered_qty preserving type ) AS RegisteredPRTQtyInBaseUnit,
  OperationActyPRTAssignment.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  OperationActyPRTAssignment.ManufacturingOrderType AS ManufacturingOrderType,
  OperationActyPRTAssignment.ProductionPlant AS ProductionPlant,
  OperationActyPRTAssignment.ProdnRsceToolItemNumber AS ProdnRsceToolItemNumber,
  cast(OperationActyPRTAssignment.ProdnRsceToolItemNumber as mpe_psnfh_char) AS MfgOrderOpPRTItemNumber,
  OperationActyPRTAssignment.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  OperationActyPRTAssignment.PRTRegistrationControl AS PRTRegistrationControl,
  OperationActyPRTAssignment._PRTRegistrationControl._PRTRegistrationControlText[1: Language=$session.system_language].PRTRegistrationControlName AS PRTRegistrationControlName,
  OperationActyPRTAssignment._OperationActivityInstance AS _OperationActivityInstance,
  OperationActyPRTAssignment._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  OperationActyPRTAssignment._ProductionResourceType AS _ProductionResourceType,
  OperationActyPRTAssignment._ProdnRsceToolCategory AS _ProdnRsceToolCategory,
  OperationActyPRTAssignment._Material AS _Material,
  OperationActyPRTAssignment._MfgOrderCategory AS _MfgOrderCategory,
  OperationActyPRTAssignment._MfgOrderType AS _MfgOrderType,
  OperationActyPRTAssignment._ProductionPlant AS _ProductionPlant
FROM P_OperationActyPRTAssignment AS OperationActyPRTAssignment
LEFT OUTER JOIN I_OpActyInstceEquipActvRegn AS _OpActyInstceEquipActvRegn ON OpActyNtwkInstance = _OpActyInstceEquipActvRegn.OpActyNtwkInstance AND OpActyNtwkElement = _OpActyInstceEquipActvRegn.OpActyNtwkElement AND OrderInternalID = _OpActyInstceEquipActvRegn.OrderInternalID AND MfgOrderOpProdnRsceToolIntID = _OpActyInstceEquipActvRegn.MfgOrderOpProdnRsceToolIntID AND ( ProdnRsceToolCategory <> 'E' OR Equipment = _OpActyInstceEquipActvRegn.Equipment )  -- association [0..*]
;

Learn More