I_ChmlCmplncInfoSrch

DDL: I_CHMLCMPLNCINFOSRCH Type: view COMPOSITE Package: EHFND_BO_CCI

Chemical Compliance Info UP Launchpad Search

I_ChmlCmplncInfoSrch is a Composite CDS View that provides data about "Chemical Compliance Info UP Launchpad Search" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 17 fields with key field ChmlCmplncInfoUUID. It has 5 associations to related views. Part of development package EHFND_BO_CCI.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfo ChemicalCompliance from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmplncMatlAssgmt _MaterialDataPrimary $projection.ChmlCmplncInfoUUID = _MaterialDataPrimary.ChmlCmplncInfoUUID and _MaterialDataPrimary.MatlAssgmtIsPrimary = 'X' ----------------------------------------------------------------------------------------------------------------------------------------------------------------- -- Associations used for searching. -----------------------------------------------------------------------------------------------------------------------------------------------------------------
[0..*] I_ChmlCmplncMatlAssgmt _MaterialAssignment _MaterialAssignment.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
[0..*] I_ChmlCmplncPrpsAssgmt _PurposeAssignment _PurposeAssignment.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID ----------------------------------------------------------------------------------------------------------------------------------------------------------------- -- Associations used for filtering hits. This information will shown in facets for additional filtering. -----------------------------------------------------------------------------------------------------------------------------------------------------------------
[0..*] I_ChmlCmplncApplAssgmt _Applications _Applications.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
[0..*] I_ChmlCmplncMktReq _Countries _Countries.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

Annotations (9)

NameValueLevelField
EndUserText.label Chemical Compliance Info UP Launchpad Search view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ICCIUPSRCH view
ObjectModel.Link https view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_ChmlCmplncInfo ChmlCmplncInfoUUID
ChmlCmplncInternalName I_ChmlCmplncInfo ChmlCmplncInternalName
ChmlCmplncInfoNavgnLink I_ChmlCmplncInfo ChmlCmplncInfoUUID
Specification I_ChmlCmplncInfo Specification
Material _MaterialDataPrimary Material
ProductName
ProdStewardshipRespUnit ProdStewardshipRespUnit
MaterialIsTransported MaterialIsTransported
MaterialIsProduced MaterialIsProduced
MaterialIsSourced MaterialIsSourced
MaterialIsSold MaterialIsSold
_MaterialAssignment _MaterialAssignment
_PurposeAssignment _PurposeAssignment
_Applications _Applications
_Countries _Countries
_RespUnitForProductStewardship _RespUnitForProductStewardship
_Product _MaterialDataPrimary _Product 
@EndUserText.label: 'Chemical Compliance Info UP Launchpad Search'
@AccessControl.authorizationCheck: #MANDATORY 
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE

@AbapCatalog: {
  sqlViewName: 'ICCIUPSRCH'
}

@ObjectModel:
{
  --Link: https://wiki.wdf.sap.corp/wiki/display/SuiteCDS/CDS+View+Performance

  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #B
  }
}

-----------------------------------------------------------------------------------------------------------------------------------------------------------------
-- This view is used for launchpad search of Unpackaged Products. The guidelines for CDS-based Search Models says that the search should be done on Interface View.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
define view I_ChmlCmplncInfoSrch
  as select from I_ChmlCmplncInfo as ChemicalCompliance

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  -- Associations used for response information. This information will be only shown not search on.
  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  association [0..1] to I_ChmlCmplncMatlAssgmt as _MaterialDataPrimary on  $projection.ChmlCmplncInfoUUID           = _MaterialDataPrimary.ChmlCmplncInfoUUID
                                                                       and _MaterialDataPrimary.MatlAssgmtIsPrimary = 'X'

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  -- Associations used for searching.
  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  association [0..*] to I_ChmlCmplncMatlAssgmt as _MaterialAssignment  on  _MaterialAssignment.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
  association [0..*] to I_ChmlCmplncPrpsAssgmt as _PurposeAssignment   on  _PurposeAssignment.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  -- Associations used for filtering hits. This information will shown in facets for additional filtering.
  -----------------------------------------------------------------------------------------------------------------------------------------------------------------
  association [0..*] to I_ChmlCmplncApplAssgmt as _Applications        on  _Applications.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
  association [0..*] to I_ChmlCmplncMktReq     as _Countries           on  _Countries.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

{
  key ChemicalCompliance.ChmlCmplncInfoUUID                                                                as ChmlCmplncInfoUUID,
      ChemicalCompliance.ChmlCmplncInternalName,
      ChemicalCompliance.ChmlCmplncInfoUUID                                                                as ChmlCmplncInfoNavgnLink,
      ChemicalCompliance.Specification                                                                     as Specification,
      _MaterialDataPrimary.Material                                                                        as Material,
      _MaterialDataPrimary._Product._Text[ 1: Language = $session.system_language ].ProductName            as ProductName,

      /****  Fields for DCL  ****/
      ProdStewardshipRespUnit,
      MaterialIsTransported,
      MaterialIsProduced,
      MaterialIsSourced,
      MaterialIsSold,

      /****  Associations for searching  ****/
      _MaterialAssignment,
      _PurposeAssignment,
      _Applications,
      _Countries,
      
      /****  Associations for foreign keys  ****/
      _RespUnitForProductStewardship,
      _MaterialDataPrimary._Product
}
where
       ChemicalCompliance.ChmlCmplncInfoType    = 'BU'
  and(
       ChemicalCompliance.MaterialIsSold        = 'X'
    or ChemicalCompliance.MaterialIsTransported = 'X'
    or ChemicalCompliance.MaterialIsProduced    = 'X'
  )

Learn More