P_AllocationUnitOfMeasureVH

DDL: P_ALLOCATIONUNITOFMEASUREVH SQL: PALLOUNOFMEASVH Type: view CONSUMPTION

P_AllocationUnitOfMeasureVH is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_UnitOfMeasure) and exposes 8 fields with key field UnitOfMeasure. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_UnitOfMeasure I_UnitOfMeasure from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_UnitOfMeasureText _Text $projection.UnitOfMeasure = _Text.UnitOfMeasure
[0..*] I_UnitOfMeasureDimensionText _DimensionText $projection.UnitOfMeasureDimension = _DimensionText.UnitOfMeasureDimension

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PALLOUNOFMEASVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY UnitOfMeasure I_UnitOfMeasure UnitOfMeasure
UnitOfMeasureDimension I_UnitOfMeasure UnitOfMeasureDimension
UnitOfMeasureISOCode I_UnitOfMeasure UnitOfMeasureISOCode ISO Code
UnitOfMeasure_E I_UnitOfMeasure UnitOfMeasure_E
UnitOfMeasureLongName
UnitOfMeasureDimensionName
_Text _Text
_DimensionText _DimensionText 
@AbapCatalog.sqlViewName: 'PALLOUNOFMEASVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking:#NOT_REQUIRED
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@VDM.viewType: #CONSUMPTION
@VDM.private: true

@Metadata.ignorePropagatedAnnotations: true
define view P_AllocationUnitOfMeasureVH
as select from I_UnitOfMeasure

      association [0..*] to I_UnitOfMeasureText as _Text on $projection.UnitOfMeasure = _Text.UnitOfMeasure
        association [0..*] to I_UnitOfMeasureDimensionText as _DimensionText
        on $projection.UnitOfMeasureDimension = _DimensionText.UnitOfMeasureDimension 

{
      @Semantics.unitOfMeasure: true
      @ObjectModel.text.association: '_Text'
      @UI.hidden: true
  key I_UnitOfMeasure.UnitOfMeasure,

      @Search.defaultSearchElement: true
//      @Search.fuzzinessThreshold: 0.7

      @UI.hidden: true
      I_UnitOfMeasure.UnitOfMeasureDimension,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @EndUserText.label: 'ISO Code'
      @UI.hidden: true
      I_UnitOfMeasure.UnitOfMeasureISOCode,

      // I_UnitOfMeasure.UnitOfMeasureNumberOfDecimals,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      //@Consumption.hidden: true

      I_UnitOfMeasure.UnitOfMeasure_E,

      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @Consumption.hidden: true
      _Text[1: Language = $session.system_language ].UnitOfMeasureLongName as UnitOfMeasureLongName,
      
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @Consumption.hidden: true
      _DimensionText[1: Language = $session.system_language ].UnitOfMeasureDimensionName as UnitOfMeasureDimensionName,
            
      _Text,
      _DimensionText

}

Learn More