I_Productplantqtmanagement

@AbapCatalog: {
  sqlViewName: 'IPRDPLANTQM',
  compiler.compareFilter: true,
  preserveKey: true
  }
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Product Plant QM'

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@Analytics:{
    dataCategory: #DIMENSION,
    dataExtraction: {
        enabled: true,
       delta.changeDataCapture.automatic: true
    }
}
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET,
                                     #EXTRACTION_DATA_SOURCE
]
@Metadata.allowExtensions:true
@ObjectModel.representativeKey: 'Product'
define view I_Productplantqtmanagement
  as select from P_ProductPlantBasic as PlantQualityMgmt
  association [1..1] to I_Product                as _Product                on  $projection.Product = _Product.Product
  association [0..1] to I_QualityMgmtCtrlKey     as _QualityMgmtCtrlKey     on  $projection.QualityMgmtCtrlKey = _QualityMgmtCtrlKey.QualityMgmtCtrlKey
  
  association [0..1] to E_Productplant           as _ProdPlantQtMgmtExt     on  $projection.Product = _ProdPlantQtMgmtExt.Product
                                                                            and $projection.Plant   = _ProdPlantQtMgmtExt.Plant
  association [1..1] to I_Plant                  as _Plant                  on  $projection.Plant = _Plant.Plant
  
  association [1..1] to I_QualityCertificateType as _QualityCertificateType on $projection.ProductQualityCertificateType = _QualityCertificateType.QualityCertificateType
{
  key PlantQualityMgmt.Product,
      @ObjectModel.foreignKey.association: '_Plant'
  key PlantQualityMgmt.Plant,
      PlantQualityMgmt.MaximumStoragePeriod,
      @ObjectModel.foreignKey.association:'_QualityMgmtCtrlKey'
      PlantQualityMgmt.QualityMgmtCtrlKey,
      _QualityMgmtCtrlKey,
      PlantQualityMgmt.MatlQualityAuthorizationGroup,
      PlantQualityMgmt. HasPostToInspectionStock,
      cast( 'X' as sdraft_is_active preserving type ) as IsActiveEntity, // to enbale extensibility in Draft 2.0


      // New fields from MDG model, as part of unified API development

      PlantQualityMgmt.InspLotDocumentationIsRequired,
      //PlantQualityMgmt.qmata                                        as MatlQualityAuthorizationGroup,

      PlantQualityMgmt.SuplrQualityManagementSystem,
      PlantQualityMgmt.RecrrgInspIntervalTimeInDays,
      PlantQualityMgmt.ProductQualityCertificateType,
      PlantQualityMgmt.ProductPlantHasInspectionSetup,

      _Product,
      _Plant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PRODUCTPLANTBASIC"
],
"ASSOCIATED":
[
"E_PRODUCTPLANT",
"I_PLANT",
"I_PRODUCT",
"I_QUALITYCERTIFICATETYPE",
"I_QUALITYMGMTCTRLKEY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/