C_ChmlCmplncInfoCmplRqRslt

@EndUserText.label: 'Assess Compliance Assessments for (Un-)Packaged Product'

@AbapCatalog:
{
  sqlViewName: 'CCCINFOCRR',
  compiler.compareFilter: true
}

@AccessControl:
{
  authorizationCheck: #MANDATORY,
  // blocking of personal data not required (no personal data fields exposed for material (MARA))

  personalData.blocking: #NOT_REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

/* This view is considering metadata extensions
 *----------------------------------------------------------------------------------------------------------------------*/
@Metadata.allowExtensions: true
@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  semanticKey:  [ 'Specification' ],
  usageType:
  {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
  }
}

@Search.searchable : true

/*----------------------------------------------------------------------------------------------------------------------
 * This view serves as data source for the "Unpackaged Product - Compliance Requirements" app,
 * see https://projectportal.int.sap.hana.ondemand.com/projects/ehs.fnd.product.crr.infos1

 * This view shows marketability requirements in progress/all assigned, and CRRs for SDS
 *----------------------------------------------------------------------------------------------------------------------*/

define view C_ChmlCmplncInfoCmplRqRslt
  --Select data from transactional view of Chemical Compliance Information
  as select from I_ChmlCmplncInfoTP

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  -- Nodes
  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  --SDS CRRs for SDS Management
  association [0..*] to C_ChmCmInCmplRqRsltSftyDataSht as _ChmCmInCmplRqRsltSftyDataSht on  $projection.ChmlCmplncInfoUUID = _ChmCmInCmplRqRsltSftyDataSht.ChmlCmplncInfoUUID
  --SDS CRRs for others
  association [0..*] to C_SftyDataShtRelatedAssmt      as _SftyDataShtRelatedAssmt      on  $projection.ChmlCmplncInfoUUID = _SftyDataShtRelatedAssmt.ChmlCmplncInfoUUID

  --DG Unpackaged Product CRRs
  association [0..*] to C_ChmCmInCmplRqRsltDngrsGds    as _CmplRqRsltDngrsGds           on  $projection.ChmlCmplncInfoUUID = _CmplRqRsltDngrsGds.ChmlCmplncInfoUUID
  --DG Packaged Product CRRs
  association [0..*] to C_PaChCoInCmplRqRsltDngrsGds   as _PaChCoInCmplRqRsltDngrsGds   on  $projection.ChmlCmplncInfoUUID = _PaChCoInCmplRqRsltDngrsGds.ChmlCmplncProdUUID

  --PMA UP CRRs In Progress/Released
  association [0..*] to C_CmplRqRsltMarketability      as _CmplRqRsltMarketability      on  $projection.ChmlCmplncInfoUUID = _CmplRqRsltMarketability.ChmlCmplncProdUUID
  --PMA PP CRRs In Progress/Released
  association [0..*] to C_PckgdCmplRqRsltMarketability as _PckgdCmplRqRsltMarketability on  $projection.ChmlCmplncInfoUUID = _PckgdCmplRqRsltMarketability.ChmlCmplncProdUUID

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  -- Additional Information
  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  -- Material Data for Primary Material
  association [0..1] to C_ChmlCmplncPrimMatl           as _MaterialDataPrimary          on  _MaterialDataPrimary.ChmlCmplncInfoUUID = $projection.ActiveChmlCmplncInfoUUID

  association [1..1] to P_ChmlCmplIsRawMat             as _isRawMat                     on  _isRawMat.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

  association [0..1] to I_ChmlCmplncProdAssgmt         as _UnpackagedProductAssgmt      on  _UnpackagedProductAssgmt.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
                                                                                        and _UnpackagedProductAssgmt.ChmlCmplncInfoType = 'BU'

  association [0..1] to C_ChmlCmplncInfoQuickView      as _ChmlCmplncInfoQuickVw        on  $projection.Specification = _ChmlCmplncInfoQuickVw.Specification

  association [0..1] to C_ChmlCmplncInfoQuickView      as _UnpckgdChmlCmplncInfoQuickVw on  $projection.UnpckgdChemicalComplianceInfo = _UnpckgdChmlCmplncInfoQuickVw.Specification

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  -- Value Helps --
  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  association [0..1] to C_ChmlCmplncRespUnitDngrsGdsVH as _RespDangerousGoodsVH         on  _RespDangerousGoodsVH.ResponsibleUnit = $projection.DngrsGdsRespUnit
  association [0..1] to C_ChmlCmplncRespUnitProductVH  as _RespProductStewardshipVH     on  _RespProductStewardshipVH.ResponsibleUnit = $projection.ProdStewardshipRespUnit
{

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      --Facet Annotation
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------

      @ObjectModel.readOnly: true
      --UUID of Chemical Compliance Information
  key ChmlCmplncInfoUUID,

      --UUID of active Chemical Compliance Information
      ActiveChmlCmplncInfoUUID,

      --UUID of active or draft chemical compliance info
      @ObjectModel.readOnly: true
      case ChmlCmplncInfoType
      when 'BU'
      then ActiveChmlCmplncInfoUUID
      else _UnpackagedProductAssgmt.ChmlCmplncProdUUID
      end                                                                                                              as ChmlCmplncInfoNavgnLink,

      --UUID of active or draft chemical compliance info
      @ObjectModel.readOnly: true
      ActiveChmlCmplncInfoUUID                                                                                         as BrnddChmlCmplncInfoUUID,

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      // General data of chemical compliance information

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      --Internal Name of Chemical Compliance Information

      // Navigation Link to Unpackaged Product App

      @Semantics.text: true
      ChmlCmplncInternalName,

      --Name of Chemical Compliance Information (either material name of primary material or internal name)
      @ObjectModel.readOnly: true
      _MaterialDataPrimary.ChmlCmplncInfoCombinedName                                                                  as ChmlCmplncInfoCombinedName,

      --Specification with intent-based navigation
      @ObjectModel.readOnly: true
      @ObjectModel.text.element: [ 'ChmlCmplncInternalName' ]
      @ObjectModel:{ foreignKey.association: '_ChmlCmplncInfoQuickVw',  mandatory: true }
      Specification                                                                                                    as Specification,

      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_TYPE_IMAGE_CALC_EXT'
      cast( '' as /ui2/semantic_object )                                                                               as SemanticObject,

      --Responsible Unit of Product Stewardship
      @ObjectModel:
      {
        mandatory: true,
        foreignKey.association: '_RespProductStewardshipVH',
        text.element:  [ 'ProdStewardshipRespUnitName' ]
      }
      @Semantics.text: true
      cast(ProdStewardshipRespUnit as ehfnd_cci_responsible_unit preserving type )                                     as ProdStewardshipRespUnit,

      --Description of Responsible Unit of Product Stewardship
      @ObjectModel.readOnly: true
      @Semantics.text: true
      _RespProductStewardshipVH.ResponsibleUnitName                                                                    as ProdStewardshipRespUnitName,

      @ObjectModel:
       {
         mandatory: true,
         foreignKey.association: '_RespDangerousGoodsVH',
         text.element:  [ 'DngrsGdsRespUnitName' ]
       }
      @Semantics.text: true
      DngrsGdsRespUnit,

      --Description of Responsible Unit of Dangerous Goods
      @ObjectModel.readOnly: true
      @Semantics.text: true
      _RespDangerousGoodsVH.ResponsibleUnitName                                                                        as DngrsGdsRespUnitName,


      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      -- CCI Type and Roles
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      --Chemical Compliance Information Type
      ChmlCmplncInfoType,

      --Indicator: Chemical Compliance Information is transported
      MaterialIsTransported,

      --Indicator: Chemical Compliance Information is sold
      MaterialIsSold,

      --Indicator: Chemical Compliance Information is produced
      MaterialIsProduced,

      --Indicator: Chemical Compliance Information is sourced
      MaterialIsSourced,

      --R&D Indicator: Product is in research
      ChmlCmplncProdIsResearched,

      -- indicators to disable essential checks
      MatlIsNotProdSafetyRlvt,

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      // Data of assigned material with indicator "primary material"

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      --Primary Material of Chemical Compliance Information (assigned in material assignment)
      @ObjectModel.readOnly: true
      _MaterialDataPrimary.Material,

      --Material Group of Primary Material
      @ObjectModel:
      {
        readOnly: true,
        text.element:  [ 'MaterialGroupName' ]
      }
      _MaterialDataPrimary._MaterialData.ProductGroup                                                                  as MaterialGroup,

      --Description of Material Group
      @ObjectModel.readOnly: true
      @Semantics.text: true
      _MaterialDataPrimary._MaterialData._ProductGroupText_2[1: Language = $session.system_language ].ProductGroupName as MaterialGroupName,

      --Material Name of Primary Material
      @ObjectModel.readOnly: true
      @Semantics.text: true
      _MaterialDataPrimary.MaterialName,

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_MKT_CALC_EXIT3'
      cast( '' as ehpma_application )                                                                                  as ChmlCmplncApplication,

      @ObjectModel.readOnly: true
      @Semantics.systemDate.lastChangedAt: true
      LastChangeUTCDateTime,

      @ObjectModel.text.element: ['LastChangedByUserName']
      @ObjectModel.readOnly: true
      LastChangedByUser                                                                                                as LastChangedByUser,

      @Semantics.name.fullName: true
      @ObjectModel.readOnly: true
      cast( _LastChangedByUser.UserDescription as ehfnd_bo_lchg_uname_enhanced preserving type )                       as LastChangedByUserName,

      @ObjectModel.readOnly: true
      _isRawMat.ChmlCmplncInfoIsRawMatl,

      -------------------------------------------------------------------------------------------------------
      --Type Image URL
      -------------------------------------------------------------------------------------------------------
      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_TYPE_IMAGE_CALC_EXT'
      @ObjectModel.readOnly: true
      cast( '' as abap.char( 255 ) )                                                                                   as ChmlCmplncTypeImageURL,



      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      -- UP of a BP
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      _UnpackagedProductAssgmt.ChmlCmplncProdUUID                                                                      as ChmlCmplncProdUUID,

      @Semantics.text: true
      _UnpackagedProductAssgmt._ChmlCmplncInfoProduct.ChmlCmplncInternalName                                           as ChmlCmplncInfoUnpckgdProdName,

      @ObjectModel.readOnly: true
      @ObjectModel.text.element: [ 'ChmlCmplncInfoUnpckgdProdName' ]
      @ObjectModel:{ foreignKey.association: '_UnpckgdChmlCmplncInfoQuickVw',  mandatory: true }
      _UnpackagedProductAssgmt._ChmlCmplncInfoProduct.Specification                                                    as UnpckgdChemicalComplianceInfo,

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHFND_CCI_QV_CALC_EXT'
      @ObjectModel.readOnly: true
      cast('' as ehfnd_boole preserving type )                                                                         as UnpckgdChmlCmplncInfoIsHidn,

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      /* Associations */
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      _MaterialDataPrimary,
      _UnpackagedProductAssgmt,
      _ChmlCmplncInfoQuickVw,
      _UnpckgdChmlCmplncInfoQuickVw,

      _CmplRqRsltMarketability,
      _PckgdCmplRqRsltMarketability,

      _ChmCmInCmplRqRsltSftyDataSht,
      _SftyDataShtRelatedAssmt,
      _CmplRqRsltDngrsGds,
      _PaChCoInCmplRqRsltDngrsGds,
      _RespProductStewardshipVH,
      _RespDangerousGoodsVH
}
-- Only for Unpackaged Product
where
     ChmlCmplncInfoType = 'BU'
  or ChmlCmplncInfoType = 'BP'