P_ChmlCmplncInfoPckgdProdCnt

DDL: P_CHMLCMPLNCINFOPCKGDPRODCNT Type: view_entity CONSUMPTION Package: EHFND_BO_CCI

Count Compliance Requirements of all Purposes per Product

P_ChmlCmplncInfoPckgdProdCnt is a Consumption CDS View that provides data about "Count Compliance Requirements of all Purposes per Product" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 1 field. Part of development package EHFND_BO_CCI.

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncInfo ChmlCmplInfo from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.representativeKey ChmlCmplncInfoUUID view

Fields (1)

KeyFieldSource TableSource FieldDescription
ChmlCmplncInfoUUID 
//@EndUserText.label: 'Count Compliance Requirements of all Purposes per Product'


@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

--VDM view type
@VDM.viewType: #CONSUMPTION
@VDM.private: true

@ObjectModel.representativeKey: 'ChmlCmplncInfoUUID'

define view entity P_ChmlCmplncInfoPckgdProdCnt
  --Select data from basic view 'Chemical compliance information'
  as select from I_ChmlCmplncInfo            as ChmlCmplInfo

  --Join master table
    join         C_ChmlCmplncPckgdProdAssgmt as ChmlCmplncPckgdProdAssgmt on ChmlCmplInfo.ChmlCmplncInfoUUID = ChmlCmplncPckgdProdAssgmt.ChmlCmplncProdUUID

{
      --UUID of chemical compliance information
  key ChmlCmplInfo.ChmlCmplncInfoUUID,

      --Count compliance requirements
      cast( count( distinct ChmlCmplncPckgdProdAssgmt.ChmlCmplncInfoUUID ) as ehfnd_cci_number_of_pp ) as NmbrOfChmlCmplncInfoPckgdProd
}
group by
  ChmlCmplInfo.ChmlCmplncInfoUUID

Learn More