I_ChmlSuplrMatlCmplRqRslt

@AbapCatalog.sqlViewName: 'ICSUPLRMATLCRR'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@EndUserText.label: 'Compliance Requirement Results for Supplier Material'

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #CHECK,
  // blocking of personal data not required (no personal data fields exposed for supplier material)

  personalData.blocking: #NOT_REQUIRED
}

--Client Handling of the view
@ClientHandling:
{
  type: #INHERITED,
  algorithm: #SESSION_VARIABLE
}

--VDM view type
@VDM.viewType: #COMPOSITE

@ObjectModel:
{
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #XL,
    serviceQuality: #C
  }
}

// view returns CR results from supplier material (all CRs from raw materials are propagated to the supplier material)

// there are only preliminary CRRs for supplier materials

define view I_ChmlSuplrMatlCmplRqRslt
  --Select data from composite view "Compliance Requirment Results" (combined with different status)
  as select from I_CmplRqRslt as CmplRqRslt

{
      --UUID of Compliance Requirement Result (preliminary)
  key CmplRqRslt.CmplRqRsltUUID,

      --UUID of Supplier Material
      CmplRqRslt.ChmlSuplrMatlUUID                        as ChmlSuplrMatlUUID,

      --Preliminary Status of Compliance Requirement Result
      CmplRqRslt.CmplRqRsltManualStatus                   as CmplRqRsltPrelimCmplncSts,

      --Create date/time of Compliance Requirement Result
      CmplRqRslt.CreationDateTime,

      --UUID of Compliance Requirement Version
      CmplRqRslt.CmplRqVersUUID,

      --Processor of Compliance Requirement Result
      CmplRqRslt.Processor,

      --expose supplier material for DCL
      CmplRqRslt._SupplierMaterial
}
where
      ChmlSuplrMatlUUID          is not null
  and ChmlSuplrMatlUUID          <> hextobin( '00000000000000000000000000000000' )
  and CmplRqRsltProcessingStatus = 'IP'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMPLRQRSLT"
],
"ASSOCIATED":
[
"I_CHMLSUPLRMATL"
],
"BASE":
[
"I_CMPLRQRSLT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/