P_ProdnModBOOOperation
Prodn Model Bill of Operations Operation
P_ProdnModBOOOperation is a Composite CDS View that provides data about "Prodn Model Bill of Operations Operation" in SAP S/4HANA. It reads from 2 data sources (I_BOOSqncOperationAssgmtChgSt, I_BillOfOperationsOpBasic) and exposes 92 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsVersion, BillOfOperationsSequence.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_BOOSqncOperationAssgmtChgSt | plas | inner |
| I_BillOfOperationsOpBasic | plpo | from |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view | |
| EndUserText.label | Prodn Model Bill of Operations Operation | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MASTER | view |
Fields (92)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | BillOfOperationsType | I_BOOSqncOperationAssgmtChgSt | BillOfOperationsType | |
| KEY | BillOfOperationsGroup | I_BOOSqncOperationAssgmtChgSt | BillOfOperationsGroup | |
| KEY | BillOfOperationsVariant | I_BOOSqncOperationAssgmtChgSt | BillOfOperationsVariant | |
| KEY | BillOfOperationsVersion | I_BOOSqncOperationAssgmtChgSt | BillOfOperationsVersion | |
| KEY | BillOfOperationsSequence | I_BOOSqncOperationAssgmtChgSt | BillOfOperationsSequence | |
| KEY | BOOOperationInternalID | I_BOOSqncOperationAssgmtChgSt | BOOOperationInternalID | |
| BOOOpInternalVersionCounter | I_BillOfOperationsOpBasic | BOOOpInternalVersionCounter | ||
| WorkCenterInternalID | I_BillOfOperationsOpBasic | WorkCenterInternalID | ||
| WorkCenterTypeCode | I_BillOfOperationsOpBasic | WorkCenterTypeCode | ||
| OperationExternalID | I_BillOfOperationsOpBasic | OperationExternalID | ||
| Operation | I_BillOfOperationsOpBasic | Operation | ||
| Operation_2 | I_BillOfOperationsOpBasic | Operation_2 | ||
| OperationText | I_BillOfOperationsOpBasic | OperationText | ||
| LongTextLanguageCode | I_BillOfOperationsOpBasic | LongTextLanguageCode | ||
| Plant | I_BillOfOperationsOpBasic | Plant | ||
| OperationControlProfile | I_BillOfOperationsOpBasic | OperationControlProfile | ||
| OperationReferenceQuantity | I_BillOfOperationsOpBasic | OperationReferenceQuantity | ||
| OperationUnit | I_BillOfOperationsOpBasic | OperationUnit | ||
| BillOfOperationsBreakDuration | I_BillOfOperationsOpBasic | BillOfOperationsBreakDuration | ||
| BillOfOperationsBreakDurnUnit | I_BillOfOperationsOpBasic | BillOfOperationsBreakDurnUnit | ||
| StandardWorkQuantity1 | I_BillOfOperationsOpBasic | StandardWorkQuantity1 | ||
| StandardWorkQuantityUnit1 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit1 | ||
| CostCtrActivityType1 | I_BillOfOperationsOpBasic | CostCtrActivityType1 | ||
| StandardWorkQuantity2 | I_BillOfOperationsOpBasic | StandardWorkQuantity2 | ||
| StandardWorkQuantityUnit2 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit2 | ||
| CostCtrActivityType2 | I_BillOfOperationsOpBasic | CostCtrActivityType2 | ||
| StandardWorkQuantity3 | I_BillOfOperationsOpBasic | StandardWorkQuantity3 | ||
| StandardWorkQuantityUnit3 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit3 | ||
| CostCtrActivityType3 | I_BillOfOperationsOpBasic | CostCtrActivityType3 | ||
| StandardWorkQuantity4 | I_BillOfOperationsOpBasic | StandardWorkQuantity4 | ||
| StandardWorkQuantityUnit4 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit4 | ||
| CostCtrActivityType4 | I_BillOfOperationsOpBasic | CostCtrActivityType4 | ||
| StandardWorkQuantity5 | I_BillOfOperationsOpBasic | StandardWorkQuantity5 | ||
| StandardWorkQuantityUnit5 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit5 | ||
| CostCtrActivityType5 | I_BillOfOperationsOpBasic | CostCtrActivityType5 | ||
| StandardWorkQuantity6 | I_BillOfOperationsOpBasic | StandardWorkQuantity6 | ||
| StandardWorkQuantityUnit6 | I_BillOfOperationsOpBasic | StandardWorkQuantityUnit6 | ||
| CostCtrActivityType6 | I_BillOfOperationsOpBasic | CostCtrActivityType6 | ||
| BusinessProcess | I_BillOfOperationsOpBasic | BusinessProcess | ||
| LeadTimeReductionStrategy | I_BillOfOperationsOpBasic | LeadTimeReductionStrategy | ||
| TeardownAndWaitIsParallel | I_BillOfOperationsOpBasic | TeardownAndWaitIsParallel | ||
| MaximumWaitDuration | I_BillOfOperationsOpBasic | MaximumWaitDuration | ||
| MaximumWaitDurationUnit | I_BillOfOperationsOpBasic | MaximumWaitDurationUnit | ||
| MinimumWaitDuration | I_BillOfOperationsOpBasic | MinimumWaitDuration | ||
| MinimumWaitDurationUnit | I_BillOfOperationsOpBasic | MinimumWaitDurationUnit | ||
| StandardQueueDuration | I_BillOfOperationsOpBasic | StandardQueueDuration | ||
| StandardQueueDurationUnit | I_BillOfOperationsOpBasic | StandardQueueDurationUnit | ||
| MinimumQueueDuration | I_BillOfOperationsOpBasic | MinimumQueueDuration | ||
| MinimumQueueDurationUnit | I_BillOfOperationsOpBasic | MinimumQueueDurationUnit | ||
| StandardMoveDuration | I_BillOfOperationsOpBasic | StandardMoveDuration | ||
| StandardMoveDurationUnit | I_BillOfOperationsOpBasic | StandardMoveDurationUnit | ||
| MinimumMoveDuration | I_BillOfOperationsOpBasic | MinimumMoveDuration | ||
| MinimumMoveDurationUnit | I_BillOfOperationsOpBasic | MinimumMoveDurationUnit | ||
| OperationSplitIsRequired | I_BillOfOperationsOpBasic | OperationSplitIsRequired | ||
| MaximumNumberOfSplits | I_BillOfOperationsOpBasic | MaximumNumberOfSplits | ||
| MinProcessingDurationPerSplit | I_BillOfOperationsOpBasic | MinProcessingDurationPerSplit | ||
| MinProcessingDurnPerSplitUnit | I_BillOfOperationsOpBasic | MinProcessingDurnPerSplitUnit | ||
| OperationOverlappingIsRequired | I_BillOfOperationsOpBasic | OperationOverlappingIsRequired | ||
| OperationOverlappingIsPossible | I_BillOfOperationsOpBasic | OperationOverlappingIsPossible | ||
| OperationsIsAlwaysOverlapping | I_BillOfOperationsOpBasic | OperationsIsAlwaysOverlapping | ||
| OverlapMinimumDuration | I_BillOfOperationsOpBasic | OverlapMinimumDuration | ||
| OverlapMinimumDurationUnit | I_BillOfOperationsOpBasic | OverlapMinimumDurationUnit | ||
| OverlapMinimumTransferQty | I_BillOfOperationsOpBasic | OverlapMinimumTransferQty | ||
| OverlapMinimumTransferQtyUnit | I_BillOfOperationsOpBasic | OverlapMinimumTransferQtyUnit | ||
| OperationScrapPercent | I_BillOfOperationsOpBasic | OperationScrapPercent | ||
| NumberOfTimeTickets | I_BillOfOperationsOpBasic | NumberOfTimeTickets | ||
| NumberOfConfirmationSlips | I_BillOfOperationsOpBasic | NumberOfConfirmationSlips | ||
| EmployeeWageGroup | I_BillOfOperationsOpBasic | EmployeeWageGroup | ||
| EmployeeWageType | I_BillOfOperationsOpBasic | EmployeeWageType | ||
| NumberOfEmployees | I_BillOfOperationsOpBasic | NumberOfEmployees | ||
| OperationSetupType | I_BillOfOperationsOpBasic | OperationSetupType | ||
| OperationSetupGroupCategory | I_BillOfOperationsOpBasic | OperationSetupGroupCategory | ||
| OperationSetupGroup | I_BillOfOperationsOpBasic | OperationSetupGroup | ||
| OperationCostingRelevancyType | I_BillOfOperationsOpBasic | OperationCostingRelevancyType | ||
| PurchasingInfoRecord | I_BillOfOperationsOpBasic | PurchasingInfoRecord | ||
| PurchaseContract | I_BillOfOperationsOpBasic | PurchaseContract | ||
| PurchasingInfoRecdAddlGrpgName | I_BillOfOperationsOpBasic | PurchasingInfoRecdAddlGrpgName | ||
| MaterialGroup | I_BillOfOperationsOpBasic | MaterialGroup | ||
| PurchasingGroup | I_BillOfOperationsOpBasic | PurchasingGroup | ||
| Supplier | I_BillOfOperationsOpBasic | Supplier | ||
| PlannedDeliveryDuration | I_BillOfOperationsOpBasic | PlannedDeliveryDuration | ||
| NumberOfOperationPriceUnits | I_BillOfOperationsOpBasic | NumberOfOperationPriceUnits | ||
| OpExternalProcessingPrice | I_BillOfOperationsOpBasic | OpExternalProcessingPrice | ||
| OpExternalProcessingCurrency | I_BillOfOperationsOpBasic | OpExternalProcessingCurrency | ||
| InspectionLotType | I_BillOfOperationsOpBasic | InspectionLotType | ||
| PurchasingOrganization | I_BillOfOperationsOpBasic | PurchasingOrganization | ||
| PurchaseContractItem | I_BillOfOperationsOpBasic | PurchaseContractItem | ||
| CostElement | I_BillOfOperationsOpBasic | CostElement | ||
| CreationDate | I_BillOfOperationsOpBasic | CreationDate | ||
| CreatedByUser | I_BillOfOperationsOpBasic | CreatedByUser | ||
| LastChangeDate | I_BillOfOperationsOpBasic | LastChangeDate | ||
| LastChangedByUser | I_BillOfOperationsOpBasic | LastChangedByUser |
@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'
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA