I_ChmlCmplncSuplrForRawMatl

--Label of view
-- e.g. display as filter name in the consumption
@EndUserText.label: 'Raw Material Data via Supplier Material Assignment'

@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'ICCSMRMATL',

  --If it's true, the filter conditions are compared and, if they match, the associated join expression is evaluated only once
  compiler.compareFilter: true
}

--Access Control: Authorizations Checks
@AccessControl:
{ 
  authorizationCheck: #CHECK,
  // blocking required for supplier

  personalData.blocking: #REQUIRED
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

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


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

define view I_ChmlCmplncSuplrForRawMatl
  --Select data from basic view of supplier material assignment
  as select distinct from  I_ChmlCmplncSuplrMatlAssgmt as SupplierMaterialAssignment

  --join data for active or draft chemical compliance information
    left outer to one join I_ChmlCmplncInfoActiveDraft as ActiveDraftCCI on SupplierMaterialAssignment.ChmlCmplncInfoUUID = ActiveDraftCCI.ActiveChmlCmplncInfoUUID

  --Link Chemical Compliance Information => needed for DCL
  association [1..1] to I_ChmlCmplncInfo as _ChmlCmplncInfo on ActiveDraftCCI.ActiveChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID
{
      --UUID of Supplier Material
  key SupplierMaterialAssignment.ChmlSuplrMatlUUID,

      --Active or Draft UUID of Chemical Compliance Information
  key ActiveDraftCCI.ChmlCmplncInfoUUID,

      --Active UUID of Chemical Compliance Information
      ActiveDraftCCI.ActiveChmlCmplncInfoUUID,

      --Indicator: Is Active Entity
      ActiveDraftCCI.ChmlCmplncInfoIsActiveEntity,

      --Supplier Status
      SupplierMaterialAssignment.ChmlSuplrMatlSuplrSts,
      
      /*Associations*/
      _SupplierStatus,
      _ChmlCmplncInfo,
      // needed for DCL

      SupplierMaterialAssignment._SupplierMaterial
}