C_PCLblSizeUnitVH

DDL: C_PCLBLSIZEUNITVH SQL: CLBLSIZEUVH Type: view CONSUMPTION

Label size unit of measure

C_PCLblSizeUnitVH is a Consumption CDS View that provides data about "Label size unit of measure" in SAP S/4HANA. It reads from 2 data sources (I_UnitOfMeasure, I_UnitOfMeasure) and exposes 2 fields with key field UnitOfMeasure. It has 1 association to related views.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_UnitOfMeasure I_UnitOfMeasure from
I_UnitOfMeasure I_UnitOfMeasure union

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasureText _Text $projection.UnitOfMeasure = _Text.UnitOfMeasure and _Text.Language = $session.system_language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CLBLSIZEUVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Label size unit of measure view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey UnitOfMeasure view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY UnitOfMeasure UnitOfMeasure
UnitOfMeasureName 
@AbapCatalog.sqlViewName: 'CLBLSIZEUVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Label size unit of measure'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:
{
  resultSet.sizeCategory: #XS, //This qualifies it as a drop-down

  dataCategory: #VALUE_HELP,
  representativeKey: 'UnitOfMeasure',
  usageType:
  {
    dataClass: #CUSTOMIZING,
    sizeCategory: #S,
    serviceQuality: #C
  }
}

define view C_PCLblSizeUnitVH 
  as select from I_UnitOfMeasure
  association [0..1] to I_UnitOfMeasureText as _Text on  $projection.UnitOfMeasure = _Text.UnitOfMeasure
                                                          and _Text.Language       = $session.system_language
{   
  key UnitOfMeasure,         
      _Text.UnitOfMeasureName
      
}
where
    UnitOfMeasure = 'MM' 
or 
    UnitOfMeasure = 'CM'
or 
    UnitOfMeasure = 'IN'
    
// the following union makes the value help support selecting an empty unit

union select from I_UnitOfMeasure
{
  key cast ( '' as msehiunit ) as UnitOfMeasure,
      ''                       as UnitOfMeasureName
         
}
where
  UnitOfMeasure = 'MM'    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UNITOFMEASURE",
"I_UNITOFMEASURETEXT"
],
"ASSOCIATED":
[
"I_UNITOFMEASURETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More