P_OPERATIONACTYPRTASSIGNMENT

CDS View

P_OPERATIONACTYPRTASSIGNMENT is a CDS View in S/4HANA. It contains 33 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_OperationActyPRTAssignment view from CONSUMPTION
P_OperationActyPRTAssignment2 view from CONSUMPTION
P_TrackToolUsageEquipPRTOpActy view from CONSUMPTION

Fields (33)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 1
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID 2
KEY OpActyNtwkElement OpActyNtwkElement 2
KEY OpActyNtwkInstance OpActyNtwkInstance 2
KEY OrderInternalID OrderInternalID 2
KEY ProductionResourceInternalID ProductionResourceInternalID 1
KEY ProductionResourceType ProductionResourceType 1
_Material _Material 1
_MfgOrderCategory _MfgOrderCategory 1
_MfgOrderType _MfgOrderType 1
_OperationActivityInstance _OperationActivityInstance 1
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 1
_ProdnRsceToolCategory _ProdnRsceToolCategory 1
_ProductionPlant _ProductionPlant 1
_ProductionResourceType _ProductionResourceType 1
BaseUnit BaseUnit 1
BOOOperationPRTInternalID BOOOperationPRTInternalID 1
DocumentInfoRecord DocumentInfoRecord 1
DocumentPart DocumentPart 1
DocumentType DocumentType 1
DocumentVersion DocumentVersion 1
ManufacturingOrderCategory ManufacturingOrderCategory 1
ManufacturingOrderType ManufacturingOrderType 1
Material Material 1
MiscProductionResourceTool MiscProductionResourceTool 1
NumberOfActvEquipRegistrations NumberOfActvEquipRegistrations 1
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit 1
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty 1
ProdnRsceToolItemNumber ProdnRsceToolItemNumber 1
ProdnRsceToolRegnIsAllowed ProdnRsceToolRegnIsAllowed 1
ProductionPlant ProductionPlant 1
PRTIsUsedAsTestEquipment PRTIsUsedAsTestEquipment 1
PRTRegistrationControl PRTRegistrationControl 1
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@VDM.private: true
define view entity P_OperationActyPRTAssignment
  as select from P_OperationActyPRTUnion as OperationActyPRTAssignment
  association [1..1] to I_ProdnRsceToolCategory_2 as _ProdnRsceToolCategory  on  $projection.ProdnRsceToolCategory = _ProdnRsceToolCategory.ProdnRsceToolCategory
  association [1..1] to I_ProductionResourceType  as _ProductionResourceType on  $projection.ProductionResourceType = _ProductionResourceType.ProductionResourceType
  association [0..1] to I_Plant                   as _Plant                  on  $projection.ProductionPlant = _Plant.Plant
  association [0..*] to I_MiscProdnRsceToolText   as _MiscProdnRsceToolText  on  $projection.ProductionResourceType       = _MiscProdnRsceToolText.ProductionResourceType
                                                                             and $projection.ProductionResourceInternalID = _MiscProdnRsceToolText.ProductionResourceInternalID
{
  key OperationActyPRTAssignment.OpActyNtwkInstance             as OpActyNtwkInstance,
  key OperationActyPRTAssignment.OpActyNtwkElement              as OpActyNtwkElement,
  key OperationActyPRTAssignment.OrderInternalID                as OrderInternalID,
  key OperationActyPRTAssignment.MfgOrderOpProdnRsceToolIntID   as MfgOrderOpProdnRsceToolIntID,
  key OperationActyPRTAssignment.Equipment                      as Equipment,
  key OperationActyPRTAssignment.ProductionResourceType         as ProductionResourceType,
  key OperationActyPRTAssignment.ProductionResourceInternalID   as ProductionResourceInternalID,
      OperationActyPRTAssignment.PRTIsUsedAsTestEquipment       as PRTIsUsedAsTestEquipment,
      @ObjectModel.foreignKey.association: '_ProdnRsceToolCategory'
      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,
      @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolStdWorkQtyUnit'
      OperationActyPRTAssignment.ProdnRsceToolStandardWorkQty   as ProdnRsceToolStandardWorkQty,
      OperationActyPRTAssignment.PlannedProdnRsceToolQtyUnit    as PlannedProdnRsceToolQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'PlannedProdnRsceToolQtyUnit'
      OperationActyPRTAssignment.PlannedTotalProdnRsceToolQty   as PlannedTotalProdnRsceToolQty,
      OperationActyPRTAssignment.NumberOfActvEquipRegistrations as NumberOfActvEquipRegistrations,
      OperationActyPRTAssignment.BaseUnit                       as BaseUnit,
      @Semantics.quantity.unitOfMeasure: '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,
      ---PRT Registration Control
      OperationActyPRTAssignment.PRTRegistrationControl         as PRTRegistrationControl,

      -- Associations
      OperationActyPRTAssignment._OpActyNtwkInstance,
      OperationActyPRTAssignment._OperationActivityInstance,
      OperationActyPRTAssignment._OrdInternalBillOfOperations,
      _ProductionResourceType,
      _ProdnRsceToolCategory,
      //PRT can be Registered at Production Execution

      OperationActyPRTAssignment._MfgOrderCategory,
      OperationActyPRTAssignment._MfgOrderType,
      _Plant                                                    as _ProductionPlant,
      OperationActyPRTAssignment._Material,
      OperationActyPRTAssignment._Equipment,
      OperationActyPRTAssignment._PRTRegistrationControl,
      _MiscProdnRsceToolText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_OPERATIONACTYPRTUNION"
],
"ASSOCIATED":
[
"I_EQUIPMENT",
"I_MATERIAL",
"I_MFGORDERCATEGORY",
"I_MFGORDERTYPE",
"I_MISCPRODNRSCETOOLTEXT",
"I_OPACTYNTWKINSTANCE",
"I_OPERATIONACTIVITYINSTANCE",
"I_ORDINTERNALBILLOFOPERATIONS",
"I_PLANT",
"I_PRODNRSCETOOLCATEGORY_2",
"I_PRODUCTIONRESOURCETYPE",
"I_PRTREGISTRATIONCONTROL"
],
"BASE":
[
"P_OPERATIONACTYPRTUNION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/