I_ChmlCmplncInfoPckgdProdVH

DDL: I_CHMLCMPLNCINFOPCKGDPRODVH Type: view_entity COMPOSITE Package: EHFND_BO_CCI

Packaged Product Value Help

I_ChmlCmplncInfoPckgdProdVH is a Composite CDS View that provides data about "Packaged Product Value Help" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfoVH) and exposes 19 fields with key field ChmlCmplncInfoUUID. It has 2 associations to related views. Part of development package EHFND_BO_CCI.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfoVH ChmlCmplncInfo from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ChmlCmplncProdAssgmt _BrandedProductAssignment _BrandedProductAssignment.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID and _BrandedProductAssignment.ChmlCmplncInfoType = 'BP' -- Linked Unpackaged Products
[0..1] I_ChmlCmplncProdAssgmt _UnpackagedProductAssignment _UnpackagedProductAssignment.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID and _UnpackagedProductAssignment.ChmlCmplncInfoType = 'BU'

Annotations (10)

NameValueLevelField
EndUserText.label Packaged Product Value Help view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey ChmlCmplncInfoUUID view
Metadata.ignorePropagatedAnnotations true view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncInfoUUID I_ChmlCmplncInfoVH ChmlCmplncInfoUUID
Specification
ChmlCmplncInternalName
Material
ProductName
ChmlCmplncInfoCombinedName
ProdStewardshipRespUnit I_ChmlCmplncInfoVH ProdStewardshipRespUnit
DngrsGdsRespUnit I_ChmlCmplncInfoVH DngrsGdsRespUnit
ChmlCmplncInfoType I_ChmlCmplncInfoVH ChmlCmplncInfoType
MaterialIsSold I_ChmlCmplncInfoVH MaterialIsSold
MaterialIsTransported I_ChmlCmplncInfoVH MaterialIsTransported
MaterialIsSourced I_ChmlCmplncInfoVH MaterialIsSourced
MaterialIsProduced I_ChmlCmplncInfoVH MaterialIsProduced
MaterialIsDisposed I_ChmlCmplncInfoVH MaterialIsDisposed
MaterialIsEmissionRelevant I_ChmlCmplncInfoVH MaterialIsEmissionRelevant
ChmlCmplncProdIsResearched I_ChmlCmplncInfoVH ChmlCmplncProdIsResearched
MatlIsMultiComponentProduct I_ChmlCmplncInfoVH MatlIsMultiComponentProduct
Associations_UnpackagedProductAssignment
_BrandedProductAssignment _BrandedProductAssignment 
@EndUserText.label: 'Packaged Product Value Help'

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

  personalData.blocking: #NOT_REQUIRED
}

@VDM.viewType: #COMPOSITE

@ObjectModel:
{
  dataCategory: #VALUE_HELP,

  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #C
  },
  representativeKey: 'ChmlCmplncInfoUUID',
  semanticKey: ['Specification']
}

@Metadata.ignorePropagatedAnnotations: true

@UI:{

  presentationVariant: [{
    sortOrder: [{ by: 'ChmlCmplncInternalName', direction: #ASC }],
    requestAtLeast: ['ChmlCmplncInfoUUID', 'Specification', 'ChmlCmplncInternalName','Material']
  }]
}

define view entity I_ChmlCmplncInfoPckgdProdVH
  as select from    I_ChmlCmplncInfoVH             as ChmlCmplncInfo

  -- Linked Branded Products
  association [0..1] to I_ChmlCmplncProdAssgmt as _BrandedProductAssignment    on  _BrandedProductAssignment.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
                                                                               and _BrandedProductAssignment.ChmlCmplncInfoType = 'BP'

  -- Linked Unpackaged Products
  association [0..1] to I_ChmlCmplncProdAssgmt as _UnpackagedProductAssignment on  _UnpackagedProductAssignment.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
                                                                               and _UnpackagedProductAssignment.ChmlCmplncInfoType = 'BU'
{
      
      @UI.hidden: true
  key ChmlCmplncInfo.ChmlCmplncInfoUUID,

      
      @UI.hidden: true
      cast(ChmlCmplncInfo.Specification as ehfnd_internal_nr_nc preserving type ) as Specification,

      --CCI Internal name
      @UI.hidden: true
      ChmlCmplncInfo.ChmlCmplncInternalName,

      --Material number
      @UI.hidden: true
      ChmlCmplncInfo.Material,

      --Name of assigned product
      @UI.hidden: true
      ChmlCmplncInfo.ProductName,

      --Combined name
      @UI.hidden: true
      ChmlCmplncInfo.ChmlCmplncInfoCombinedName,

      // needed for DCL

      @UI.hidden: true
      ChmlCmplncInfo.ProdStewardshipRespUnit,

      @UI.hidden: true
      ChmlCmplncInfo.DngrsGdsRespUnit,

      @UI.hidden: true
      ChmlCmplncInfo.ChmlCmplncInfoType,

      @UI.hidden: true
      ChmlCmplncInfo.MaterialIsSold,

      @UI.hidden: true
      ChmlCmplncInfo.MaterialIsTransported,

      @UI.hidden: true
      ChmlCmplncInfo.MaterialIsSourced,

      @UI.hidden: true
      ChmlCmplncInfo.MaterialIsProduced,

      @UI.hidden: true
      ChmlCmplncInfo.MaterialIsDisposed,

      @UI.hidden: true
      ChmlCmplncInfo.MaterialIsEmissionRelevant,

      @UI.hidden: true
      ChmlCmplncInfo.ChmlCmplncProdIsResearched,

      @UI.hidden: true
      ChmlCmplncInfo.MatlIsMultiComponentProduct,

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      -- Linked Branded Product Info
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      @UI.hidden: true
      _BrandedProductAssignment.ChmlCmplncProdUUID                                as BrnddChmlCmplncInfoUUID,

      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      -- Linked Unpackaged Product Info
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      @UI.hidden: true
      _UnpackagedProductAssignment.ChmlCmplncProdUUID                             as UnpckgdChmlCmplncInfoUUID,
      
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      -- Associations
      -----------------------------------------------------------------------------------------------------------------------------------------------------------------
      _UnpackagedProductAssignment,
      _BrandedProductAssignment
}
where
       ChmlCmplncInfo.ChmlCmplncInfoType             =  'PP'
  and  ChmlCmplncInfo.MatlIsMultiComponentProduct    =  ''
  and  ChmlCmplncInfo.MaterialIsSold                 =  'X'

Learn More