P_SubstanceVariantsCt

DDL: P_SUBSTANCEVARIANTSCT Type: view CONSUMPTION

P_SubstanceVariantsCt is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ListedSubstanceVariant) and exposes 2 fields with key field ListedSubstanceUUID.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_ListedSubstanceVariant I_ListedSubstanceVariant from

Annotations (6)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ListedSubstanceUUID I_ListedSubstanceVariant ListedSubstanceUUID
VariantCount 
@AbapCatalog:
{
  sqlViewName: 'PSUBVARCNT',
  compiler.compareFilter: true
}
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

@VDM.viewType: #CONSUMPTION
@VDM.private: true

/*----------------------------------------------------------------------------------------------------------------------
    Private composite view to determine the available listed substance variants for a listed substance.
------------------------------------------------------------------------------------------------------------------------*/
define view P_SubstanceVariantsCt

  as select from I_ListedSubstanceVariant
{
  key I_ListedSubstanceVariant.ListedSubstanceUUID,

      count(*) as VariantCount
}
group by
  I_ListedSubstanceVariant.ListedSubstanceUUID
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LISTEDSUBSTANCEVARIANT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More