R_ProductionModelOperationTP

DDL: R_PRODUCTIONMODELOPERATIONTP Type: view_entity TRANSACTIONAL

Production Model Operation

R_ProductionModelOperationTP is a Transactional CDS View that provides data about "Production Model Operation" in SAP S/4HANA. It reads from 1 data source (I_ProductionModelOperation) and exposes 139 fields with key fields ProductionModelUUID, BillOfOperationsVersion, BOOOperationInternalID. It has 2 associations to related views.

1 data source(s) 139 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductionModelOperation I_ProductionModelOperation from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_ProdnModOperationActivityTP _Activity
[0..*] R_ProdnModOperationComponentTP _OperationComponent

Annotations (7)

NameValueLevelField
EndUserText.label Production Model Operation view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (139)

KeyFieldSource TableSource FieldDescription
KEY ProductionModelUUID ProductionModelUUID
KEY BillOfOperationsVersion BillOfOperationsVersion
KEY BOOOperationInternalID BOOOperationInternalID
BOOOpInternalVersionCounter BOOOpInternalVersionCounter
BillOfMaterialCategory BillOfMaterialCategory
BillOfMaterialVariantUsage BillOfMaterialVariantUsage
Plant Plant
BillOfOperationsType BillOfOperationsType
OperationExternalID OperationExternalID
Operation Operation
OperationText OperationText
LongTextLanguageCode LongTextLanguageCode
WorkCenter WorkCenter
BOOOperationPlant BOOOperationPlant
OperationControlProfile OperationControlProfile
OperationReferenceQuantity OperationReferenceQuantity
OperationUnit OperationUnit
BillOfOperationsBreakDuration BillOfOperationsBreakDuration
BillOfOperationsBreakDurnUnit BillOfOperationsBreakDurnUnit
BusinessProcess BusinessProcess
LeadTimeReductionStrategy LeadTimeReductionStrategy
TeardownAndWaitIsParallel TeardownAndWaitIsParallel
MinimumWaitDuration MinimumWaitDuration
MinimumWaitDurationUnit MinimumWaitDurationUnit
MaximumWaitDuration MaximumWaitDuration
MaximumWaitDurationUnit MaximumWaitDurationUnit
MinimumQueueDuration MinimumQueueDuration
MinimumQueueDurationUnit MinimumQueueDurationUnit
StandardQueueDuration StandardQueueDuration
StandardQueueDurationUnit StandardQueueDurationUnit
MinimumMoveDuration MinimumMoveDuration
MinimumMoveDurationUnit MinimumMoveDurationUnit
StandardMoveDuration StandardMoveDuration
StandardMoveDurationUnit StandardMoveDurationUnit
WorkCenterStandardQueueDurn WorkCenterStandardQueueDurn
WorkCenterStdQueueDurnUnit WorkCenterStdQueueDurnUnit
WorkCenterMinimumQueueDuration WorkCenterMinimumQueueDuration
WorkCenterMinimumQueueDurnUnit WorkCenterMinimumQueueDurnUnit
OperationSplitIsRequired OperationSplitIsRequired
MaximumNumberOfSplits MaximumNumberOfSplits
MinProcessingDurationPerSplit MinProcessingDurationPerSplit
MinProcessingDurnPerSplitUnit MinProcessingDurnPerSplitUnit
BOOOperationOverlapping BOOOperationOverlapping
OverlapMinimumDuration OverlapMinimumDuration
OverlapMinimumDurationUnit OverlapMinimumDurationUnit
OverlapMinimumTransferQty OverlapMinimumTransferQty
OverlapMinimumTransferQtyUnit OverlapMinimumTransferQtyUnit
OperationScrapPercent OperationScrapPercent
NumberOfTimeTickets NumberOfTimeTickets
NumberOfConfirmationSlips NumberOfConfirmationSlips
EmployeeWageGroup EmployeeWageGroup
EmployeeWageType EmployeeWageType
NumberOfEmployees NumberOfEmployees
OperationSetupType OperationSetupType
OperationSetupGroupCategory OperationSetupGroupCategory
OperationSetupGroup OperationSetupGroup
OperationCostingRelevancyType OperationCostingRelevancyType
NmbrOfTimeTicketsIsReferenced NmbrOfTimeTicketsIsReferenced
NumberOfConfSlipsIsReferenced NumberOfConfSlipsIsReferenced
EmployeeWageGroupIsReferenced EmployeeWageGroupIsReferenced
EmployeeWageTypeIsReferenced EmployeeWageTypeIsReferenced
WorkCenterSetpTypeIsReferenced WorkCenterSetpTypeIsReferenced
StandardWorkFormulaParamName1 StandardWorkFormulaParamName1
StandardWorkFormulaParamName2 StandardWorkFormulaParamName2
StandardWorkFormulaParamName3 StandardWorkFormulaParamName3
StandardWorkFormulaParamName4 StandardWorkFormulaParamName4
StandardWorkFormulaParamName5 StandardWorkFormulaParamName5
StandardWorkFormulaParamName6 StandardWorkFormulaParamName6
StandardWorkQuantity1 StandardWorkQuantity1
StandardWorkQuantity2 StandardWorkQuantity2
StandardWorkQuantity3 StandardWorkQuantity3
StandardWorkQuantity4 StandardWorkQuantity4
StandardWorkQuantity5 StandardWorkQuantity5
StandardWorkQuantity6 StandardWorkQuantity6
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6
CostCtrActivityType1 CostCtrActivityType1
CostCtrActivityType2 CostCtrActivityType2
CostCtrActivityType3 CostCtrActivityType3
CostCtrActivityType4 CostCtrActivityType4
CostCtrActivityType5 CostCtrActivityType5
CostCtrActivityType6 CostCtrActivityType6
CostCtrActyType1IsReferenced CostCtrActyType1IsReferenced
CostCtrActyType2IsReferenced CostCtrActyType2IsReferenced
CostCtrActyType3IsReferenced CostCtrActyType3IsReferenced
CostCtrActyType4IsReferenced CostCtrActyType4IsReferenced
CostCtrActyType5IsReferenced CostCtrActyType5IsReferenced
CostCtrActyType6IsReferenced CostCtrActyType6IsReferenced
PurchasingInfoRecord PurchasingInfoRecord
PurchaseContract PurchaseContract
PurchasingInfoRecdAddlGrpgName PurchasingInfoRecdAddlGrpgName
MaterialGroup MaterialGroup
PurchasingGroup PurchasingGroup
Supplier Supplier
PlannedDeliveryDuration PlannedDeliveryDuration
NumberOfOperationPriceUnits NumberOfOperationPriceUnits
OpExternalProcessingPrice OpExternalProcessingPrice
InspectionLotType InspectionLotType
PurchasingOrganization PurchasingOrganization
PurchaseContractItem PurchaseContractItem
CostElement CostElement
OpExternalProcessingCurrency OpExternalProcessingCurrency
GoodsRecipientName GoodsRecipientName
UnloadingPointName UnloadingPointName
ShopFloorRoutingTemplateType ShopFloorRoutingTemplateType
ShopFloorRtgTemplateGroup ShopFloorRtgTemplateGroup
ShopFloorRtgTemplateGrpVariant ShopFloorRtgTemplateGrpVariant
ShopFloorRtgTemplateVersion ShopFloorRtgTemplateVersion
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
_Activity _Activity
_OperationComponent _OperationComponent
_WorkCenterText _WorkCenterText
_ControlProfileText _ControlProfileText
_Plant _Plant
_LeadTimeReductionStrategyText _LeadTimeReductionStrategyText
_EmployeeWageGroupText _EmployeeWageGroupText
_OperationSetupTypeText _OperationSetupTypeText
_OperationSetupGroupCatText _OperationSetupGroupCatText
_OperationSetupGroupText _OperationSetupGroupText
_CostRelevancyText _CostRelevancyText
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_ProductionModel _ProductionModel
_OperationControlProfile _OperationControlProfile
_ProdnModelBOOOpOvrlpngText _ProdnModelBOOOpOvrlpngText
_PurchasingOrganization _PurchasingOrganization
_MaterialGroupText _MaterialGroupText
_PurchasingGroup _PurchasingGroup
_Supplier _Supplier
_OpExtProcessingCurrencyText _OpExtProcessingCurrencyText
_InspectionLotTypeText _InspectionLotTypeText
_PurchasingGroupText _PurchasingGroupText 
@EndUserText.label: 'Production Model Operation'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
define view entity R_ProductionModelOperationTP
  as select from I_ProductionModelOperation
  composition [0..*] of R_ProdnModOperationActivityTP  as _Activity
  composition [0..*] of R_ProdnModOperationComponentTP as _OperationComponent
  association to parent R_ProductionModelTP            as _ProductionModel on  _ProductionModel.ProductionModelUUID     = $projection.ProductionModelUUID
                                                                           and _ProductionModel.BillOfOperationsVersion = $projection.BillOfOperationsVersion
{
  key ProductionModelUUID,
  key BillOfOperationsVersion,
  key BOOOperationInternalID,
      BOOOpInternalVersionCounter,
      BillOfMaterialCategory,
      BillOfMaterialVariantUsage,
      Plant,
      BillOfOperationsType,
      OperationExternalID,
      Operation,
      OperationText,
      LongTextLanguageCode,
      WorkCenter,
      BOOOperationPlant,
      OperationControlProfile,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OperationReferenceQuantity,
      OperationUnit,
      @Semantics.quantity.unitOfMeasure: 'BillOfOperationsBreakDurnUnit'
      BillOfOperationsBreakDuration,
      BillOfOperationsBreakDurnUnit,
      BusinessProcess,
      LeadTimeReductionStrategy,
      TeardownAndWaitIsParallel,
      @Semantics.quantity.unitOfMeasure: 'MinimumWaitDurationUnit'
      MinimumWaitDuration,
      MinimumWaitDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'MaximumWaitDurationUnit'
      MaximumWaitDuration,
      MaximumWaitDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'MinimumQueueDurationUnit'
      MinimumQueueDuration,
      MinimumQueueDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'StandardQueueDurationUnit'
      StandardQueueDuration,
      StandardQueueDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'MinimumMoveDurationUnit'
      MinimumMoveDuration,
      MinimumMoveDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'StandardMoveDurationUnit'
      StandardMoveDuration,
      StandardMoveDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'WorkCenterStdQueueDurnUnit'
      WorkCenterStandardQueueDurn,
      WorkCenterStdQueueDurnUnit,
      @Semantics.quantity.unitOfMeasure: 'WorkCenterMinimumQueueDurnUnit'
      WorkCenterMinimumQueueDuration,
      WorkCenterMinimumQueueDurnUnit,
      OperationSplitIsRequired,
      MaximumNumberOfSplits,
      @Semantics.quantity.unitOfMeasure: 'MinProcessingDurnPerSplitUnit'
      MinProcessingDurationPerSplit,
      MinProcessingDurnPerSplitUnit,
      BOOOperationOverlapping,
      @Semantics.quantity.unitOfMeasure: 'OverlapMinimumDurationUnit'
      OverlapMinimumDuration,
      OverlapMinimumDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'OverlapMinimumTransferQtyUnit'
      OverlapMinimumTransferQty,
      OverlapMinimumTransferQtyUnit,
      OperationScrapPercent,
      NumberOfTimeTickets,
      NumberOfConfirmationSlips,
      EmployeeWageGroup,
      EmployeeWageType,
      NumberOfEmployees,
      OperationSetupType,
      OperationSetupGroupCategory,
      OperationSetupGroup,
      OperationCostingRelevancyType,
      NmbrOfTimeTicketsIsReferenced,
      NumberOfConfSlipsIsReferenced,
      EmployeeWageGroupIsReferenced,
      EmployeeWageTypeIsReferenced,
      WorkCenterSetpTypeIsReferenced,
      StandardWorkFormulaParamName1,
      StandardWorkFormulaParamName2,
      StandardWorkFormulaParamName3,
      StandardWorkFormulaParamName4,
      StandardWorkFormulaParamName5,
      StandardWorkFormulaParamName6,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit1'
      StandardWorkQuantity1,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit2'
      StandardWorkQuantity2,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit3'
      StandardWorkQuantity3,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit4'
      StandardWorkQuantity4,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit5'
      StandardWorkQuantity5,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit6'
      StandardWorkQuantity6,
      StandardWorkQuantityUnit1,
      StandardWorkQuantityUnit2,
      StandardWorkQuantityUnit3,
      StandardWorkQuantityUnit4,
      StandardWorkQuantityUnit5,
      StandardWorkQuantityUnit6,
      CostCtrActivityType1,
      CostCtrActivityType2,
      CostCtrActivityType3,
      CostCtrActivityType4,
      CostCtrActivityType5,
      CostCtrActivityType6,
      CostCtrActyType1IsReferenced,
      CostCtrActyType2IsReferenced,
      CostCtrActyType3IsReferenced,
      CostCtrActyType4IsReferenced,
      CostCtrActyType5IsReferenced,
      CostCtrActyType6IsReferenced,
      PurchasingInfoRecord,
      PurchaseContract,
      PurchasingInfoRecdAddlGrpgName,
      MaterialGroup,
      PurchasingGroup,
      Supplier,
      PlannedDeliveryDuration,
      NumberOfOperationPriceUnits,
      @Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
      OpExternalProcessingPrice,
      InspectionLotType,
      PurchasingOrganization,
      PurchaseContractItem,
      CostElement,
      OpExternalProcessingCurrency,
      GoodsRecipientName,
      UnloadingPointName,
      ShopFloorRoutingTemplateType,
      ShopFloorRtgTemplateGroup,
      ShopFloorRtgTemplateGrpVariant,
      ShopFloorRtgTemplateVersion,
      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDate.createdAt: true
      CreationDate,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,
      @Semantics.systemDate.lastChangedAt: true
      LastChangeDate,
      //Compositions

      _Activity,
      _OperationComponent,
      /* Associations */
      _WorkCenterText,
      _ControlProfileText,
      _Plant,
      _LeadTimeReductionStrategyText,
      _EmployeeWageGroupText,
      _OperationSetupTypeText,
      _OperationSetupGroupCatText,
      _OperationSetupGroupText,
      _CostRelevancyText,
      _CreatedByUser,
      _ChangedByUser,
      _ProductionModel,
      _OperationControlProfile,
      _ProdnModelBOOOpOvrlpngText,
      _PurchasingOrganization,
      _MaterialGroupText,
      _PurchasingGroup,
      _Supplier,
      _OpExtProcessingCurrencyText,
      _InspectionLotTypeText,
      _PurchasingGroupText
}

Learn More