I_ProductPRTByInternalKeyTP

@AbapCatalog.sqlViewName: 'IPRDPRTTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'BO Node : Product Resource Tool'

@VDM.viewType: #TRANSACTIONAL
@ObjectModel: {
    writeDraftPersistence: 'PROD_PLANT_PRT',
    semanticKey: [ 'Product','Plant' ],
    createEnabled : true,
    updateEnabled : true,
    deleteEnabled : true,
    usageType.serviceQuality: #A,
    usageType.sizeCategory : #M,
    usageType.dataClass: #MASTER
}


define view I_ProductPRTByInternalKeyTP
  as select from I_MaterialPRTByInternalKey as PRT
  association [1..1] to I_ProductWD               as _Product       on  $projection.Product = _Product.Product
  association [1..1] to I_ProductPlantWD          as _Plant         on  $projection.Product = _Plant.Product
                                                                    and $projection.Plant   = _Plant.Plant
  association [0..*] to I_ProductUnitsOfMeasureWD as _UnitOfMeasure on  $projection.Product = _UnitOfMeasure.Product

{
       @ObjectModel.readOnly:true
  key  cast ( PRT.Product as productnumber preserving type ) as Product,
       @ObjectModel.readOnly:true
  key  PRT.Plant,
       PRT.Plant                                             as PlantForEdit,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       PRT.ProductionResourceToolGroup1,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       PRT.ProductionResourceToolGroup2,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       @Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
       PRT.ProductionResourceUsage,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       ProdnRsceToolControlProfile,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       ProdnRsceToolStandardTextCode,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       ProdnRsceToolTotQtyCalcFormula,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       ProdnRsceToolUsageQtyCalcFmla,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       StartDateOffsetReferenceCode,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       EndDateOffsetReferenceCode,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       EndDateOffsetDurnIsReferenced,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       StartDateOffstDurnIsReferenced,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       EndDteOffstRefCodeIsReferenced,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       StartDateOffsetRefCodeIsRefcd,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       PRTTotQtyCalcFmlaIsReferenced,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       PRTUsgeQtyCalcFmlaIsReferenced,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       PRTControlProfileIsReferenced,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       PRTStdTextCodeIsReferenced,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       StartDateOffsetDuration,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       @ObjectModel.foreignKey.association: '_StartDateOffsetDurationUnit'
       StartDateOffsetDurationUnit,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       EndDateOffsetDuration,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       @ObjectModel.foreignKey.association: '_EndDateOffsetDurationUnit'
       EndDateOffsetDurationUnit,
       @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
       ShopFloorRtgPRTIsRegistrable,
       @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
       _Product,
       @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
       _Plant,
       _UnitOfMeasure,
       _ProdnRsceToolGroup1,
       _ProdnRsceToolGroup2,
       _ProductionResourceUsage,
       _ProdnRsceToolControlProfile,
       _ProdnRsceToolStandardText,
       _ProdnRsceToolTotQtyCalcFmla,
       _ProdnRsceToolUsageQtyCalcFmla,
       _StartDateOffsetReferenceCode,
       _EndDateOffsetReferenceCode,
       _StartDateOffsetDurationUnit,
       _EndDateOffsetDurationUnit
}