I_ChmlCmplncProdAssgmtDimn

DDL: I_CHMLCMPLNCPRODASSGMTDIMN SQL: ICCPRODASSGMTD Type: view COMPOSITE Package: EHFND_BO_CCI

Dimension Prodcut Assignment

I_ChmlCmplncProdAssgmtDimn is a Composite CDS View (Dimension) that provides data about "Dimension Prodcut Assignment" in SAP S/4HANA. It reads from 3 data sources (I_ChmlCmplncProdAssgmt, I_ChmlCmplncAnlyts1, to) and exposes 11 fields. It has 3 associations to related views. Part of development package EHFND_BO_CCI.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_ChmlCmplncProdAssgmt _ChmlCmplncProdAssgmt from
I_ChmlCmplncAnlyts1 _UnpackagedProduct inner
to to inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Substance _Substance _UnpackagedProduct.SubstanceUUID = _Substance.SubstanceUUID --
[0..1] I_ChmlCompositionType _CompositionType _UnpackagedProduct.ChmlCompositionType = _CompositionType.ChmlCompositionType -- packaged product
[1..1] I_ChmlCmplncInfo _ChmlCmplncInfo1 _ChmlCmplncProdAssgmt.ChmlCmplncInfoUUID = _ChmlCmplncInfo1.ChmlCmplncInfoUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ICCPRODASSGMTD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey Product view
EndUserText.label Dimension Prodcut Assignment view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view

Fields (11)

KeyFieldSource TableSource FieldDescription
ChmlCmplncInfoUUIDasChmlCmplncInfoUUID
MaterialasProduct
SubstanceUUIDasSubstanceUUID
ChmlCompositionType
MaterialIsSoldasMaterialIsSold
Material
ProductGroup
Associations_ChmlCmplncInfo
_ChmlCmplncInfo1 _ChmlCmplncInfo1
_CompositionType _CompositionType
_Substance _Substance 
@AbapCatalog.sqlViewName: 'ICCPRODASSGMTD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ObjectModel.representativeKey: 'Product'

@EndUserText.label: 'Dimension Prodcut Assignment'

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@ClientHandling:
{
  type: #INHERITED,
  algorithm: #SESSION_VARIABLE
}

@VDM.viewType: #COMPOSITE

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

@Analytics.dataCategory: #DIMENSION

@Metadata.allowExtensions: true

/*----------------------------------------------------------------------------------------------------------------------
    Dimension Product Assignments for Analytics
------------------------------------------------------------------------------------------------------------------------*/

define view I_ChmlCmplncProdAssgmtDimn
  as select from I_ChmlCmplncProdAssgmt as _ChmlCmplncProdAssgmt
  -- inner join to Chemical Compliance Information of Unpackaged Product
    inner join   I_ChmlCmplncAnlyts1    as _UnpackagedProduct on  _ChmlCmplncProdAssgmt.ChmlCmplncProdUUID = _UnpackagedProduct.ChmlCmplncInfoUUID
                                                              and _UnpackagedProduct.MatlAssgmtIsPrimary   = 'X'

  -- Association to Substance
  association [0..1] to I_Substance           as _Substance       on  _UnpackagedProduct.SubstanceUUID = _Substance.SubstanceUUID

  -- Association to Composition Type
  association [0..1] to I_ChmlCompositionType as _CompositionType on  _UnpackagedProduct.ChmlCompositionType = _CompositionType.ChmlCompositionType

  -- packaged product
  association [1..1] to I_ChmlCmplncInfo      as _ChmlCmplncInfo1 on  _ChmlCmplncProdAssgmt.ChmlCmplncInfoUUID = _ChmlCmplncInfo1.ChmlCmplncInfoUUID

{
      -- UUID of Chemical Compliance Info of Packaged Product
      @ObjectModel.foreignKey.association: '_ChmlCmplncInfo1'
  key _ChmlCmplncProdAssgmt.ChmlCmplncInfoUUID                                           as ChmlCmplncInfoUUID,

      -- Material assigned to Packaged Product
  key _ChmlCmplncInfo._MaterialAssignment.Material                                       as Product,

      -- UUID of Company Substance from Composition of Unpackaged Product
      @ObjectModel.foreignKey.association: '_Substance'
  key _UnpackagedProduct.SubstanceUUID                                                   as SubstanceUUID,

      -- Composition Type
      @ObjectModel.foreignKey.association: '_CompositionType'
  key _UnpackagedProduct.ChmlCompositionType,

      -- Material is Sold flag of Packaged Product
      _ChmlCmplncInfo.MaterialIsSold                                                     as MaterialIsSold,

      -- Material assigned to Unpackaged Product
      _UnpackagedProduct.Material,

      -- Product Group of assigned material of Unpackaged Product
      _UnpackagedProduct.ProductGroup,

      -- UUID of Chemical Compliance Info of Unpackaged Product
      cast( _ChmlCmplncProdAssgmt.ChmlCmplncProdUUID as ehfnd_cci_uuid preserving type ) as ChmlCmplncProdUUID,

      -- Associations
      _ChmlCmplncInfo,
      _ChmlCmplncInfo1,
      _CompositionType,
      _Substance
}
where
  MaterialIsSold = 'X'

Learn More