P_ChmlCmplncPrpsAssgmtCt

DDL: P_CHMLCMPLNCPRPSASSGMTCT Type: view CONSUMPTION Package: EHFND_BO_CCI

Count Purpose Assignments from Finished Good and Product

P_ChmlCmplncPrpsAssgmtCt is a Consumption CDS View that provides data about "Count Purpose Assignments from Finished Good and Product" in SAP S/4HANA. It reads from 1 data source (P_ChmlCmplncPrpsAssgmt) and exposes 2 fields with key field ChemicalComplianceUUID. Part of development package EHFND_BO_CCI.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
P_ChmlCmplncPrpsAssgmt P_ChmlCmplncPrpsAssgmt from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCCPRPSASSGMTCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ChemicalComplianceUUID ChemicalComplianceUUID
NmbrOfChmlCmplncPurposes 
@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'PCCPRPSASSGMTCT ',

  --If it's true, the filter conditions are compared and, if they match, the associated join expression is evaluated only once
  compiler.compareFilter: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

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

define view P_ChmlCmplncPrpsAssgmtCt 
  as select from P_ChmlCmplncPrpsAssgmt {
  
  key ChemicalComplianceUUID,
  count( distinct ChemicalCmplncPrpsAssgmtUUID ) as NmbrOfChmlCmplncPurposes  
  
}
group by
  ChemicalComplianceUUID

Learn More