P_PRODNMODBOOOPERATION
Prodn Model Bill of Operations Operation
P_PRODNMODBOOOPERATION is a CDS View in S/4HANA. Prodn Model Bill of Operations Operation. It contains 75 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProdnModOpActyCompInstance | view_entity | inner | COMPOSITE | Prodn Model Op Acty Component Instance |
| I_ProdnModOperationActivity | view_entity | inner | COMPOSITE | Production Model Operation Activity |
| I_ProdnModOperationComponent | view_entity | inner | COMPOSITE | Production Model Operation Component |
| I_ProductionModelOperation | view_entity | from | COMPOSITE | Production Model Operation |
Fields (75)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillOfOperationsVersion | BillOfOperationsVersion | 1 |
| KEY | BOOOperationInternalID | BOOOperationInternalID | 3 |
| BillOfOperationsBreakDuration | BillOfOperationsBreakDuration | 1 | |
| BillOfOperationsBreakDurnUnit | BillOfOperationsBreakDurnUnit | 1 | |
| BOOOpInternalVersionCounter | BOOOpInternalVersionCounter | 4 | |
| BusinessProcess | BusinessProcess | 1 | |
| CostElement | CostElement | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| InspectionLotType | InspectionLotType | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LeadTimeReductionStrategy | LeadTimeReductionStrategy | 1 | |
| LongTextLanguageCode | LongTextLanguageCode | 2 | |
| MaterialGroup | MaterialGroup | 1 | |
| MaximumNumberOfSplits | MaximumNumberOfSplits | 1 | |
| MaximumWaitDuration | MaximumWaitDuration | 1 | |
| MaximumWaitDurationUnit | MaximumWaitDurationUnit | 1 | |
| MinimumMoveDuration | MinimumMoveDuration | 1 | |
| MinimumMoveDurationUnit | MinimumMoveDurationUnit | 1 | |
| MinimumQueueDuration | MinimumQueueDuration | 1 | |
| MinimumQueueDurationUnit | MinimumQueueDurationUnit | 1 | |
| MinimumWaitDuration | MinimumWaitDuration | 1 | |
| MinimumWaitDurationUnit | MinimumWaitDurationUnit | 1 | |
| MinProcessingDurationPerSplit | MinProcessingDurationPerSplit | 1 | |
| MinProcessingDurnPerSplitUnit | MinProcessingDurnPerSplitUnit | 1 | |
| NumberOfEmployees | NumberOfEmployees | 1 | |
| NumberOfOperationPriceUnits | NumberOfOperationPriceUnits | 1 | |
| Operation_2 | Operation | 3 | |
| OperationControlProfile | OperationControlProfile | 2 | |
| OperationCostingRelevancyType | OperationCostingRelevancyType | 1 | |
| OperationExternalID | OperationExternalID | 2 | |
| OperationOverlappingIsPossible | OperationOverlappingIsPossible | 1 | |
| OperationOverlappingIsRequired | OperationOverlappingIsRequired | 1 | |
| OperationReferenceQuantity | OperationReferenceQuantity | 1 | |
| OperationScrapPercent | OperationScrapPercent | 1 | |
| OperationSetupGroup | OperationSetupGroup | 1 | |
| OperationSetupGroupCategory | OperationSetupGroupCategory | 1 | |
| OperationsIsAlwaysOverlapping | OperationsIsAlwaysOverlapping | 1 | |
| OperationSplitIsRequired | OperationSplitIsRequired | 1 | |
| OperationText | OperationText | 1 | |
| OperationUnit | OperationUnit | 1 | |
| OpExternalProcessingCurrency | OpExternalProcessingCurrency | 1 | |
| OpExternalProcessingPrice | OpExternalProcessingPrice | 1 | |
| OverlapMinimumDuration | OverlapMinimumDuration | 1 | |
| OverlapMinimumDurationUnit | OverlapMinimumDurationUnit | 1 | |
| OverlapMinimumTransferQty | OverlapMinimumTransferQty | 1 | |
| OverlapMinimumTransferQtyUnit | OverlapMinimumTransferQtyUnit | 1 | |
| PlannedDeliveryDuration | PlannedDeliveryDuration | 1 | |
| PurchaseContract | PurchaseContract | 1 | |
| PurchaseContractItem | PurchaseContractItem | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingInfoRecdAddlGrpgName | PurchasingInfoRecdAddlGrpgName | 1 | |
| PurchasingInfoRecord | PurchasingInfoRecord | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| StandardMoveDuration | StandardMoveDuration | 1 | |
| StandardMoveDurationUnit | StandardMoveDurationUnit | 1 | |
| StandardQueueDuration | StandardQueueDuration | 1 | |
| StandardQueueDurationUnit | StandardQueueDurationUnit | 1 | |
| StandardWorkQuantity1 | StandardWorkQuantity1 | 1 | |
| StandardWorkQuantity2 | StandardWorkQuantity2 | 1 | |
| StandardWorkQuantity3 | StandardWorkQuantity3 | 1 | |
| StandardWorkQuantity4 | StandardWorkQuantity4 | 1 | |
| StandardWorkQuantity5 | StandardWorkQuantity5 | 1 | |
| StandardWorkQuantity6 | StandardWorkQuantity6 | 1 | |
| StandardWorkQuantityUnit1 | StandardWorkQuantityUnit1 | 1 | |
| StandardWorkQuantityUnit2 | StandardWorkQuantityUnit2 | 1 | |
| StandardWorkQuantityUnit3 | StandardWorkQuantityUnit3 | 1 | |
| StandardWorkQuantityUnit4 | StandardWorkQuantityUnit4 | 1 | |
| StandardWorkQuantityUnit5 | StandardWorkQuantityUnit5 | 1 | |
| StandardWorkQuantityUnit6 | StandardWorkQuantityUnit6 | 1 | |
| Supplier | Supplier | 1 | |
| TeardownAndWaitIsParallel | TeardownAndWaitIsParallel | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 1 | |
| WorkCenterTypeCode | WorkCenterTypeCode | 1 |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@EndUserText.label: 'Prodn Model Bill of Operations Operation'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #A,
sizeCategory: #L,
dataClass: #MASTER
}
define view entity P_ProdnModBOOOperation
as select from I_BillOfOperationsOpBasic as plpo
inner join I_BOOSqncOperationAssgmtChgSt as plas on plas.BillOfOperationsType = plpo.BillOfOperationsType
and plas.BillOfOperationsGroup = plpo.BillOfOperationsGroup
and plas.BOOOperationInternalID = plpo.BOOOperationInternalID
and plas.BOOSqncOpAssgmtIntVersionCntr = plpo.BOOOpInternalVersionCounter
and plas.ValidityEndDate <= plpo.ValidityEndDate
and plas.ValidityStartDate >= plpo.ValidityStartDate
{
key plas.BillOfOperationsType,
key plas.BillOfOperationsGroup,
key plas.BillOfOperationsVariant,
key plas.BillOfOperationsVersion,
key plas.BillOfOperationsSequence,
key plas.BOOOperationInternalID,
plpo.BOOOpInternalVersionCounter,
plpo.WorkCenterInternalID,
plpo.WorkCenterTypeCode,
plpo.OperationExternalID,
plpo.Operation,
plpo.Operation_2,
plpo.OperationText,
plpo.LongTextLanguageCode,
plpo.Plant,
plpo.OperationControlProfile,
@Semantics.quantity.unitOfMeasure: 'OperationUnit'
plpo.OperationReferenceQuantity,
plpo.OperationUnit,
@Semantics.quantity.unitOfMeasure: 'BillOfOperationsBreakDurnUnit'
plpo.BillOfOperationsBreakDuration,
plpo.BillOfOperationsBreakDurnUnit,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit1'
plpo.StandardWorkQuantity1,
plpo.StandardWorkQuantityUnit1,
plpo.CostCtrActivityType1,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit2'
plpo.StandardWorkQuantity2,
plpo.StandardWorkQuantityUnit2,
plpo.CostCtrActivityType2,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit3'
plpo.StandardWorkQuantity3,
plpo.StandardWorkQuantityUnit3,
plpo.CostCtrActivityType3,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit4'
plpo.StandardWorkQuantity4,
plpo.StandardWorkQuantityUnit4,
plpo.CostCtrActivityType4,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit5'
plpo.StandardWorkQuantity5,
plpo.StandardWorkQuantityUnit5,
plpo.CostCtrActivityType5,
@Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit6'
plpo.StandardWorkQuantity6,
plpo.StandardWorkQuantityUnit6,
plpo.CostCtrActivityType6,
plpo.BusinessProcess,
plpo.LeadTimeReductionStrategy,
plpo.TeardownAndWaitIsParallel,
@Semantics.quantity.unitOfMeasure: 'MaximumWaitDurationUnit'
plpo.MaximumWaitDuration,
plpo.MaximumWaitDurationUnit,
@Semantics.quantity.unitOfMeasure: 'MinimumWaitDurationUnit'
plpo.MinimumWaitDuration,
plpo.MinimumWaitDurationUnit,
@Semantics.quantity.unitOfMeasure: 'StandardQueueDurationUnit'
plpo.StandardQueueDuration,
plpo.StandardQueueDurationUnit,
@Semantics.quantity.unitOfMeasure: 'MinimumQueueDurationUnit'
plpo.MinimumQueueDuration,
plpo.MinimumQueueDurationUnit,
@Semantics.quantity.unitOfMeasure: 'StandardMoveDurationUnit'
plpo.StandardMoveDuration,
plpo.StandardMoveDurationUnit,
@Semantics.quantity.unitOfMeasure: 'MinimumMoveDurationUnit'
plpo.MinimumMoveDuration,
plpo.MinimumMoveDurationUnit,
plpo.OperationSplitIsRequired,
plpo.MaximumNumberOfSplits,
@Semantics.quantity.unitOfMeasure: 'MinProcessingDurnPerSplitUnit'
plpo.MinProcessingDurationPerSplit,
plpo.MinProcessingDurnPerSplitUnit,
plpo.OperationOverlappingIsRequired,
plpo.OperationOverlappingIsPossible,
plpo.OperationsIsAlwaysOverlapping,
@Semantics.quantity.unitOfMeasure: 'OverlapMinimumDurationUnit'
plpo.OverlapMinimumDuration,
plpo.OverlapMinimumDurationUnit,
@Semantics.quantity.unitOfMeasure: 'OverlapMinimumTransferQtyUnit'
plpo.OverlapMinimumTransferQty,
plpo.OverlapMinimumTransferQtyUnit,
plpo.OperationScrapPercent,
plpo.NumberOfTimeTickets,
plpo.NumberOfConfirmationSlips,
plpo.EmployeeWageGroup,
plpo.EmployeeWageType,
plpo.NumberOfEmployees,
plpo.OperationSetupType,
plpo.OperationSetupGroupCategory,
plpo.OperationSetupGroup,
plpo.OperationCostingRelevancyType,
plpo.PurchasingInfoRecord,
plpo.PurchaseContract,
plpo.PurchasingInfoRecdAddlGrpgName,
plpo.MaterialGroup,
plpo.PurchasingGroup,
plpo.Supplier,
plpo.PlannedDeliveryDuration,
plpo.NumberOfOperationPriceUnits,
@Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
plpo.OpExternalProcessingPrice,
plpo.OpExternalProcessingCurrency,
plpo.InspectionLotType,
plpo.PurchasingOrganization,
plpo.PurchaseContractItem,
plpo.CostElement,
plpo.CreationDate,
plpo.CreatedByUser,
plpo.LastChangeDate,
plpo.LastChangedByUser
}
where
plpo.BillOfOperationsType = 'V'