C_BillOfOperationsBasicOpDEX

DDL: C_BILLOFOPERATIONSBASICOPDEX Type: view_entity CONSUMPTION Package: VDM_PP_MD_RTG

Bill of Operations Operation

C_BillOfOperationsBasicOpDEX is a Consumption CDS View (Dimension) that provides data about "Bill of Operations Operation" in SAP S/4HANA. It reads from 1 data source (I_BillOfOperationsOpBasic) and exposes 167 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BOOOperationInternalID, BOOOpInternalVersionCounter. Part of development package VDM_PP_MD_RTG.

Data Sources (1)

SourceAliasJoin Type
I_BillOfOperationsOpBasic I_BillOfOperationsOpBasic from

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey BOOOpInternalVersionCounter view
EndUserText.label Bill of Operations Operation view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name ProductionRoutingOperation view

Fields (167)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType BillOfOperationsType
KEY BillOfOperationsGroup BillOfOperationsGroup
KEY BOOOperationInternalID BOOOperationInternalID
KEY BOOOpInternalVersionCounter BOOOpInternalVersionCounter
BillOfOperationsVersion BillOfOperationsVersion
WorkCenterInternalID WorkCenterInternalID
WorkCenterTypeCode WorkCenterTypeCode
IsDeleted IsDeleted
IsImplicitlyDeleted IsImplicitlyDeleted
SuperiorOperationInternalID SuperiorOperationInternalID
BOORefOperationIncrementValue BOORefOperationIncrementValue
OperationExternalID OperationExternalID
Operation Operation_2
OperationText OperationText
LongTextLanguageCode LongTextLanguageCode
Plant Plant
OperationControlProfile OperationControlProfile
OperationStandardTextCode OperationStandardTextCode
BillOfOperationsRefType BillOfOperationsRefType
BillOfOperationsRefGroup BillOfOperationsRefGroup
BillOfOperationsRefVariant BillOfOperationsRefVariant
LineSegmentTakt LineSegmentTakt
OperationStdWorkQtyGrpgCat OperationStdWorkQtyGrpgCat
OrderHasNoSubOperations OrderHasNoSubOperations
OperationReferenceQuantity OperationReferenceQuantity
OperationUnit OperationUnit
OpQtyToBaseQtyNmrtr OpQtyToBaseQtyNmrtr
OpQtyToBaseQtyDnmntr OpQtyToBaseQtyDnmntr
BillOfOperationsBreakDuration BillOfOperationsBreakDuration
BillOfOperationsBreakDurnUnit BillOfOperationsBreakDurnUnit
StandardWorkQuantity1 StandardWorkQuantity1
StandardWorkQuantityUnit1 StandardWorkQuantityUnit1
CostCtrActivityType1 CostCtrActivityType1
PerfEfficiencyRatioCode1 PerfEfficiencyRatioCode1
StandardWorkQuantity2 StandardWorkQuantity2
StandardWorkQuantityUnit2 StandardWorkQuantityUnit2
CostCtrActivityType2 CostCtrActivityType2
PerfEfficiencyRatioCode2 PerfEfficiencyRatioCode2
StandardWorkQuantity3 StandardWorkQuantity3
StandardWorkQuantityUnit3 StandardWorkQuantityUnit3
CostCtrActivityType3 CostCtrActivityType3
PerfEfficiencyRatioCode3 PerfEfficiencyRatioCode3
StandardWorkQuantity4 StandardWorkQuantity4
StandardWorkQuantityUnit4 StandardWorkQuantityUnit4
CostCtrActivityType4 CostCtrActivityType4
PerfEfficiencyRatioCode4 PerfEfficiencyRatioCode4
StandardWorkQuantity5 StandardWorkQuantity5
StandardWorkQuantityUnit5 StandardWorkQuantityUnit5
CostCtrActivityType5 CostCtrActivityType5
PerfEfficiencyRatioCode5 PerfEfficiencyRatioCode5
StandardWorkQuantity6 StandardWorkQuantity6
StandardWorkQuantityUnit6 StandardWorkQuantityUnit6
CostCtrActivityType6 CostCtrActivityType6
PerfEfficiencyRatioCode6 PerfEfficiencyRatioCode6
BusinessProcess BusinessProcess
LeadTimeReductionStrategy LeadTimeReductionStrategy
TeardownAndWaitIsParallel TeardownAndWaitIsParallel
MaximumWaitDuration MaximumWaitDuration
MaximumWaitDurationUnit MaximumWaitDurationUnit
MinimumWaitDuration MinimumWaitDuration
MinimumWaitDurationUnit MinimumWaitDurationUnit
StandardQueueDuration StandardQueueDuration
StandardQueueDurationUnit StandardQueueDurationUnit
MinimumQueueDuration MinimumQueueDuration
MinimumQueueDurationUnit MinimumQueueDurationUnit
StandardMoveDuration StandardMoveDuration
StandardMoveDurationUnit StandardMoveDurationUnit
MinimumMoveDuration MinimumMoveDuration
MinimumMoveDurationUnit MinimumMoveDurationUnit
OperationSplitIsRequired OperationSplitIsRequired
MaximumNumberOfSplits MaximumNumberOfSplits
MinProcessingDurationPerSplit MinProcessingDurationPerSplit
MinProcessingDurnPerSplitUnit MinProcessingDurnPerSplitUnit
OperationOverlappingIsRequired OperationOverlappingIsRequired
OperationOverlappingIsPossible OperationOverlappingIsPossible
OperationsIsAlwaysOverlapping OperationsIsAlwaysOverlapping
OverlapMinimumDuration OverlapMinimumDuration
OverlapMinimumDurationUnit OverlapMinimumDurationUnit
OverlapMinimumTransferQty OverlapMinimumTransferQty
OverlapMinimumTransferQtyUnit OverlapMinimumTransferQtyUnit
StartDateOffsetDurationUnit StartDateOffsetDurationUnit
StartDateOffsetDuration StartDateOffsetDuration
EndDateOffsetDurationUnit EndDateOffsetDurationUnit
EndDateOffsetDuration EndDateOffsetDuration
OperationScrapPercent OperationScrapPercent
NumberOfTimeTickets NumberOfTimeTickets
NumberOfConfirmationSlips NumberOfConfirmationSlips
EmployeeWageGroup EmployeeWageGroup
EmployeeWageType EmployeeWageType
EmployeeSuitability EmployeeSuitability
NumberOfEmployees NumberOfEmployees
OperationSetupType OperationSetupType
OperationSetupGroupCategory OperationSetupGroupCategory
OperationSetupGroup OperationSetupGroup
OperationCostingRelevancyType OperationCostingRelevancyType
IsNonValueAddedOperation IsNonValueAddedOperation
OpIsExtlyProcdWithSubcontrg OpIsExtlyProcdWithSubcontrg
PurchasingInfoRecord PurchasingInfoRecord
PurchasingOrganization PurchasingOrganization
PurchaseContract PurchaseContract
PurchaseContractItem PurchaseContractItem
PurchasingInfoRecdAddlGrpgName PurchasingInfoRecdAddlGrpgName
MaterialGroup MaterialGroup
PurchasingGroup PurchasingGroup
Supplier Supplier
PlannedDeliveryDuration PlannedDeliveryDuration
NumberOfOperationPriceUnits NumberOfOperationPriceUnits
OpExternalProcessingPrice OpExternalProcessingPrice
InspectionLotType InspectionLotType
CostElement CostElement
OpExternalProcessingCurrency OpExternalProcessingCurrency
CapacityCategoryCode CapacityCategoryCode
BOOOperationIsPhase BOOOperationIsPhase
BOOPhaseSuperiorOpInternalID BOOPhaseSuperiorOpInternalID
ControlRecipeDestination ControlRecipeDestination
InspResultRecordingView InspResultRecordingView
MinimumDuration MinimumDuration
MinimumDurationUnit MinimumDurationUnit
OperationWorkPercent OperationWorkPercent
CapRqmtsDistributionFunction CapRqmtsDistributionFunction
CompanyCode CompanyCode
FactoryCalendar FactoryCalendar
CapacityRequirementDistrKey CapacityRequirementDistrKey
InspSbstCompletionConfirmation InspSbstCompletionConfirmation
InspSbstHasNoTimeOrQuantity InspSbstHasNoTimeOrQuantity
OperationStandardDuration OperationStandardDuration
OperationStandardDurationUnit OperationStandardDurationUnit
NumberOfCapacities NumberOfCapacities
OperationSystemCondition OperationSystemCondition
CostCtrActivityType CostCtrActivityType
OperationCalculationControl OperationCalculationControl
Assembly Assembly
PurchaseOrderQty PurchaseOrderQty
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit
PurchasingInfoRecordCategory PurchasingInfoRecordCategory
FunctionalLocation
Equipment Equipment
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic
FreeDefinedAttribute01 FreeDefinedAttribute01
FreeDefinedAttribute02 FreeDefinedAttribute02
FreeDefinedAttribute03 FreeDefinedAttribute03
FreeDefinedAttribute04 FreeDefinedAttribute04
FreeDefinedQuantity1 FreeDefinedQuantity1
FreeDefinedQuantity1Unit FreeDefinedQuantity1Unit
FreeDefinedQuantity2 FreeDefinedQuantity2
FreeDefinedQuantity2Unit FreeDefinedQuantity2Unit
FreeDefinedAmount1
FreeDefinedAmount1Currency FreeDefinedAmount1Currency
FreeDefinedAmount2
FreeDefinedAmount2Currency FreeDefinedAmount2Currency
FreeDefinedDate1 FreeDefinedDate1
FreeDefinedDate2 FreeDefinedDate2
FreeDefinedIndicator1 FreeDefinedIndicator1
FreeDefinedIndicator2 FreeDefinedIndicator2
MaintOperationExecStageCode MaintOperationExecStageCode
CreationDate CreationDate
CreatedByUser CreatedByUser
LastChangeDate LastChangeDate
LastChangedByUser LastChangedByUser
ChangeNumber ChangeNumber
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
OpPlannedWorkQuantity OpPlannedWorkQuantity
OpWorkQuantityUnit OpWorkQuantityUnit
_BillOfOperationsGroup _BillOfOperationsGroup
_BillOfOperationsType _BillOfOperationsType
_BOOOperationInternalID _BOOOperationInternalID
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #CONSUMPTION
@Analytics: {dataCategory: #DIMENSION,
    dataExtraction: {
       enabled: true,
       delta.changeDataCapture: {
       automatic : true
       }
     },
internalName: #LOCAL
}
@ObjectModel.representativeKey: 'BOOOpInternalVersionCounter'
@EndUserText.label: 'Bill of Operations Operation'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #L, dataClass: #MASTER }
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type:#PUBLIC_LOCAL_API
@ObjectModel.supportedCapabilities:[#EXTRACTION_DATA_SOURCE,#ANALYTICAL_DIMENSION,#CDS_MODELING_ASSOCIATION_TARGET]
@ObjectModel.modelingPattern:#ANALYTICAL_DIMENSION
@ObjectModel.sapObjectNodeType.name:'ProductionRoutingOperation'
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')

define view entity C_BillOfOperationsBasicOpDEX
  as select from I_BillOfOperationsOpBasic
{
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key BillOfOperationsType,
      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key BillOfOperationsGroup,
      @ObjectModel.foreignKey.association: '_BOOOperationInternalID'
  key BOOOperationInternalID,
      @ObjectModel.text.element: ['OperationText']
  key BOOOpInternalVersionCounter,
      BillOfOperationsVersion,
      WorkCenterInternalID,
      WorkCenterTypeCode,
      IsDeleted,
      IsImplicitlyDeleted,
      SuperiorOperationInternalID,
      BOORefOperationIncrementValue,
      OperationExternalID,
      Operation_2                                                as Operation,
      @Semantics.text: true
      OperationText,
      LongTextLanguageCode,
      Plant,
      OperationControlProfile,
      OperationStandardTextCode,
      BillOfOperationsRefType,
      BillOfOperationsRefGroup,
      BillOfOperationsRefVariant,
      LineSegmentTakt,
      OperationStdWorkQtyGrpgCat,
      OrderHasNoSubOperations,
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      OperationReferenceQuantity,
      OperationUnit,
      OpQtyToBaseQtyNmrtr,
      OpQtyToBaseQtyDnmntr,
      @Semantics.quantity.unitOfMeasure:'BillOfOperationsBreakDurnUnit'
      BillOfOperationsBreakDuration,
      BillOfOperationsBreakDurnUnit,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit1'
      StandardWorkQuantity1,
      StandardWorkQuantityUnit1,
      CostCtrActivityType1,
      PerfEfficiencyRatioCode1,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit2'
      StandardWorkQuantity2,
      StandardWorkQuantityUnit2,
      CostCtrActivityType2,
      PerfEfficiencyRatioCode2,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit3'
      StandardWorkQuantity3,
      StandardWorkQuantityUnit3,
      CostCtrActivityType3,
      PerfEfficiencyRatioCode3,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit4'
      StandardWorkQuantity4,
      StandardWorkQuantityUnit4,
      CostCtrActivityType4,
      PerfEfficiencyRatioCode4,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit5'
      StandardWorkQuantity5,
      StandardWorkQuantityUnit5,
      CostCtrActivityType5,
      PerfEfficiencyRatioCode5,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit6'
      StandardWorkQuantity6,
      StandardWorkQuantityUnit6,
      CostCtrActivityType6,
      PerfEfficiencyRatioCode6,
      BusinessProcess,
      LeadTimeReductionStrategy,
      TeardownAndWaitIsParallel,
      @Semantics.quantity.unitOfMeasure: 'MaximumWaitDurationUnit'
      MaximumWaitDuration,
      MaximumWaitDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'MinimumWaitDurationUnit'
      MinimumWaitDuration,
      MinimumWaitDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'StandardQueueDurationUnit'
      StandardQueueDuration,
      StandardQueueDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'MinimumQueueDurationUnit'
      MinimumQueueDuration,
      MinimumQueueDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'StandardMoveDurationUnit'
      StandardMoveDuration,
      StandardMoveDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'MinimumMoveDurationUnit'
      MinimumMoveDuration,
      MinimumMoveDurationUnit,
      OperationSplitIsRequired,
      MaximumNumberOfSplits,
      @Semantics.quantity.unitOfMeasure: 'MinProcessingDurnPerSplitUnit'
      MinProcessingDurationPerSplit,
      MinProcessingDurnPerSplitUnit,
      OperationOverlappingIsRequired,
      OperationOverlappingIsPossible,
      OperationsIsAlwaysOverlapping,
      @Semantics.quantity.unitOfMeasure: 'OverlapMinimumDurationUnit'
      OverlapMinimumDuration,
      OverlapMinimumDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'OverlapMinimumTransferQtyUnit'
      OverlapMinimumTransferQty,
      OverlapMinimumTransferQtyUnit,
      StartDateOffsetDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'StartDateOffsetDurationUnit'
      StartDateOffsetDuration,
      EndDateOffsetDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'EndDateOffsetDurationUnit'
      EndDateOffsetDuration,
      OperationScrapPercent,
      NumberOfTimeTickets,
      NumberOfConfirmationSlips,
      EmployeeWageGroup,
      EmployeeWageType,
      EmployeeSuitability,
      NumberOfEmployees,
      OperationSetupType,
      OperationSetupGroupCategory,
      OperationSetupGroup,
      OperationCostingRelevancyType,
      @Semantics.booleanIndicator
      IsNonValueAddedOperation,
      @Semantics.booleanIndicator
      OpIsExtlyProcdWithSubcontrg,
      PurchasingInfoRecord,
      PurchasingOrganization,
      PurchaseContract,
      PurchaseContractItem,
      PurchasingInfoRecdAddlGrpgName,
      MaterialGroup,
      PurchasingGroup,
      Supplier,
      PlannedDeliveryDuration,
      NumberOfOperationPriceUnits,
      @Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
      OpExternalProcessingPrice,
      InspectionLotType,
      CostElement,
      OpExternalProcessingCurrency,
      CapacityCategoryCode,
      BOOOperationIsPhase,
      BOOPhaseSuperiorOpInternalID,
      ControlRecipeDestination,
      InspResultRecordingView,
      @Semantics.quantity.unitOfMeasure: 'MinimumDurationUnit'
      MinimumDuration,
      MinimumDurationUnit,
      OperationWorkPercent,
      CapRqmtsDistributionFunction,
      CompanyCode,
      FactoryCalendar,
      CapacityRequirementDistrKey,
      InspSbstCompletionConfirmation,
      @Semantics.booleanIndicator
      InspSbstHasNoTimeOrQuantity,
      @Semantics.quantity.unitOfMeasure: 'OperationStandardDurationUnit'
      OperationStandardDuration,
      OperationStandardDurationUnit,
      NumberOfCapacities,
      OperationSystemCondition,
      CostCtrActivityType,
      OperationCalculationControl,
      Assembly,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      PurchaseOrderQty,
      PurchaseOrderQuantityUnit,
      PurchasingInfoRecordCategory,
      cast(FunctionalLocation as vdm_eam_tplnr preserving type ) as FunctionalLocation,
      Equipment,
      FreeDefinedTableFieldSemantic,
      FreeDefinedAttribute01,
      FreeDefinedAttribute02,
      FreeDefinedAttribute03,
      FreeDefinedAttribute04,
      @Semantics.quantity.unitOfMeasure: 'FreeDefinedQuantity1Unit'
      FreeDefinedQuantity1,
      FreeDefinedQuantity1Unit,
      @Semantics.quantity.unitOfMeasure: 'FreeDefinedQuantity2Unit'
      FreeDefinedQuantity2,
      FreeDefinedQuantity2Unit,
      @Semantics.amount.currencyCode: 'FreeDefinedAmount1Currency'
      cast(FreeDefinedAmount1 as vdm_usrcurr ) as FreeDefinedAmount1,
      FreeDefinedAmount1Currency,
      @Semantics.amount.currencyCode: 'FreeDefinedAmount2Currency'
      cast(FreeDefinedAmount2 as vdm_usrcurr )  as FreeDefinedAmount2,
      FreeDefinedAmount2Currency,
      FreeDefinedDate1,
      FreeDefinedDate2,
      FreeDefinedIndicator1,
      FreeDefinedIndicator2,
      MaintOperationExecStageCode,
      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      ChangeNumber,
      ValidityStartDate,
      ValidityEndDate,
      @Semantics.quantity.unitOfMeasure: 'OpWorkQuantityUnit'
      OpPlannedWorkQuantity,
      OpWorkQuantityUnit,
      /* Associations */

      _BillOfOperationsGroup,
      _BillOfOperationsType,
      _BOOOperationInternalID
}