C_MfgOrderObjPgPRT

DDL: C_MFGORDEROBJPGPRT Type: view_entity CONSUMPTION Package: PP_MFGORDER_UI

PRT for Orders

C_MfgOrderObjPgPRT is a Consumption CDS View (Dimension) that provides data about "PRT for Orders" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderOperationPRT) and exposes 27 fields with key fields OrderInternalBillOfOperations, MfgOrderOpProdnRsceToolIntID. It has 1 association to related views. Part of development package PP_MFGORDER_UI.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderOperationPRT I_MfgOrderOperationPRT from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_OrdInternalBillOfOperations _OrdInternalBillOfOperations $projection.OrderInternalBillOfOperations = _OrdInternalBillOfOperations.OrderInternalBillOfOperations

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
Analytics.dataCategory #DIMENSION view
ObjectModel.representativeKey MfgOrderOpProdnRsceToolIntID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
EndUserText.label PRT for Orders view
UI.headerInfo.typeName PRT view
UI.headerInfo.typeNamePlural PRTs view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalBillOfOperations MfgOrderInternalID Operation Task List No.
KEY MfgOrderOpProdnRsceToolIntID MfgOrderOpProdnRsceToolIntID PRT Item Counter
ManufacturingOrder ManufacturingOrder
ProdnRsceToolCategory ProdnRsceToolCategory_2
ProdnRsceToolCategoryName
PlannedProdnRsceToolQtyUnit PlannedProdnRsceToolQtyUnit
PlannedTotalProdnRsceToolQty PlannedTotalProdnRsceToolQty
ConfirmedProdnRsceToolQtyUnit ConfirmedProdnRsceToolQtyUnit
ConfirmedProdnRsceToolQty ConfirmedProdnRsceToolQty
ProdnRsceToolUsageQuantityUnit ProdnRsceToolUsageQuantityUnit
ProdnRsceToolUsageQuantity ProdnRsceToolUsageQuantity
EarliestSchedldUsageStartDate EarliestSchedldUsageStartDate
EarliestSchedldUsageStartTime EarliestSchedldUsageStartTime
EarliestSchedldUsageEndDate EarliestSchedldUsageEndDate
EarliestSchedldUsageEndTime EarliestSchedldUsageEndTime
LatestSchedldUsageStartDate LatestSchedldUsageStartDate
LatestSchedldUsageStartTime LatestSchedldUsageStartTime
LatestSchedldUsageEndDate LatestSchedldUsageEndDate
LatestSchedldUsageEndTime LatestSchedldUsageEndTime
ManufacturingOrderType ManufacturingOrderType
ManufacturingOrderCategory ManufacturingOrderCategory
ProductionPlant ProductionPlant
_ProdnRsceToolCategory _ProdnRsceToolCategory_2
_MfgOrderCategory _MfgOrderCategory
_MfgOrderType _MfgOrderType
_ProductionPlant _ProductionPlant
_OrdInternalBillOfOperations _OrdInternalBillOfOperations 
@AccessControl.authorizationCheck: #CHECK
@Metadata.allowExtensions: true
@Analytics:{dataCategory:#DIMENSION }
@ObjectModel.representativeKey: 'MfgOrderOpProdnRsceToolIntID'
@ObjectModel.semanticKey: ['OrderInternalBillOfOperations' , 'MfgOrderOpProdnRsceToolIntID'  ]
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #L, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'PRT for Orders'
@UI.headerInfo.typeName: 'PRT'
@UI.headerInfo.typeNamePlural: 'PRTs'
define view entity C_MfgOrderObjPgPRT
  as select from I_MfgOrderOperationPRT
  
  association [1..1] to I_OrdInternalBillOfOperations as _OrdInternalBillOfOperations   on  $projection.OrderInternalBillOfOperations = _OrdInternalBillOfOperations.OrderInternalBillOfOperations  
{
       // Key

       @UI.hidden
       @EndUserText.label: 'Operation Task List No.'
       @ObjectModel.foreignKey.association: '_OrdInternalBillOfOperations'
  key  MfgOrderInternalID as OrderInternalBillOfOperations,
       @EndUserText.label: 'PRT Item Counter'
       @UI.lineItem: [{position:10, exclude: true }]
  key  MfgOrderOpProdnRsceToolIntID,
       @UI.hidden
       ManufacturingOrder,
       @UI.lineItem: [{position:20}]
       @ObjectModel.text.element: [ 'ProdnRsceToolCategoryName' ]
       @Consumption.valueHelpDefinition: [ { entity: { name: 'I_ProdnRsceToolCategory_2', element: 'ProdnRsceToolCategory' } } ]
       ProdnRsceToolCategory_2 as ProdnRsceToolCategory,
       _ProdnRsceToolCategory_2._Text[1: Language=$session.system_language].ProdnRsceToolCategoryName,
       PlannedProdnRsceToolQtyUnit,
//       @DefaultAggregation: #SUM

       @UI.lineItem: [{position:30}]
       @Semantics.quantity.unitOfMeasure: 'PlannedProdnRsceToolQtyUnit'
       PlannedTotalProdnRsceToolQty,
       ConfirmedProdnRsceToolQtyUnit,
       @UI.lineItem: [{position:40}]
       @Semantics.quantity.unitOfMeasure: 'ConfirmedProdnRsceToolQtyUnit'
//       @DefaultAggregation: #SUM

       ConfirmedProdnRsceToolQty,
       ProdnRsceToolUsageQuantityUnit,
       @UI.lineItem: [{position:50}]
       @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolUsageQuantityUnit'
//       @DefaultAggregation: #SUM

       ProdnRsceToolUsageQuantity,
       @Semantics.calendarItem.dtEnd: true
       @UI.lineItem: [{position:60}]
       EarliestSchedldUsageStartDate,
       EarliestSchedldUsageStartTime,
       @Semantics.calendarItem.dtEnd: true
       @UI.lineItem: [{position:70}]
       EarliestSchedldUsageEndDate,
       EarliestSchedldUsageEndTime,
       @Semantics.calendarItem.dtEnd: true
       @UI.lineItem: [{position:80}]
       LatestSchedldUsageStartDate,
       LatestSchedldUsageStartTime,
       @Semantics.calendarItem.dtEnd: true
       @UI.lineItem: [{position:90}]
       LatestSchedldUsageEndDate,
       LatestSchedldUsageEndTime,
       @ObjectModel.foreignKey.association: '_MfgOrderType'
       @Consumption.valueHelpDefinition: [ { entity: { name: 'I_OrderTypeVH', element: 'OrderType' } } ]
       ManufacturingOrderType,
       @ObjectModel.foreignKey.association: '_MfgOrderCategory'
       ManufacturingOrderCategory,
       @ObjectModel.foreignKey.association: '_ProductionPlant'
       ProductionPlant,

       _ProdnRsceToolCategory_2 as _ProdnRsceToolCategory,
       _MfgOrderCategory,
       _MfgOrderType,
       _ProductionPlant,
       _OrdInternalBillOfOperations
}
where
  IsDeleted != 'X';

Learn More