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

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  -- 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
      ActiveChmlCmplncInfoUUID                                                                                          as ChmlCmplncInfoNavgnLink,

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

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

      // Navigation Link to Unpackaged Product App

      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
      cast( Specification as ehfnd_internal_nr_nc )                                                                     as Specification,

      --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,

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      // 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,

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      /* Associations */
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      _MaterialDataPrimary,

      _CmplRqRsltMarketability,
      _PckgdCmplRqRsltMarketability,

      _ChmCmInCmplRqRsltSftyDataSht,
      _SftyDataShtRelatedAssmt,
      _CmplRqRsltDngrsGds,
      _PaChCoInCmplRqRsltDngrsGds,
      _RespProductStewardshipVH,
      _RespDangerousGoodsVH
}
-- Only for Unpackaged Product
where
  ChmlCmplncInfoType = 'BU'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CHMLCMPLNCPRIMMATL",
"C_CHMLCMPLNCRESPUNITDNGRSGDSVH",
"C_CHMLCMPLNCRESPUNITPRODUCTVH",
"I_CHMLCMPLNCINFOTP",
"I_PRODUCT",
"I_PRODUCTGROUPTEXT_2",
"I_USER",
"P_CHMLCMPLISRAWMAT"
],
"ASSOCIATED":
[
"C_CHMCMINCMPLRQRSLTDNGRSGDS",
"C_CHMCMINCMPLRQRSLTSFTYDATASHT",
"C_CHMLCMPLNCPRIMMATL",
"C_CHMLCMPLNCRESPUNITDNGRSGDSVH",
"C_CHMLCMPLNCRESPUNITPRODUCTVH",
"C_CMPLRQRSLTMARKETABILITY",
"C_PACHCOINCMPLRQRSLTDNGRSGDS",
"C_PCKGDCMPLRQRSLTMARKETABILITY",
"C_SFTYDATASHTRELATEDASSMT",
"P_CHMLCMPLISRAWMAT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/