P_Weightuom

DDL: P_WEIGHTUOM SQL: PUOMWEIGHT Type: view BASIC

P_Weightuom is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (t006) and exposes 5 fields with key field UnitOfMeasure. It has 3 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
t006 t006 from

Associations (3)

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

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PUOMWEIGHT view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.representativeKey UnitOfMeasure view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY UnitOfMeasure msehi
_Text _Text
UnitOfMeasureDimension dimid
_Dimension _Dimension
_DimensionText _DimensionText 
@AbapCatalog.sqlViewName: 'PUOMWEIGHT'
//@EndUserText.label: 'VH for weight unit'

@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'value help for Price Indicator'

@Search.searchable: true
@ObjectModel.representativeKey: 'UnitOfMeasure'

define view P_Weightuom as select from t006
   
    association [0..*] to I_UnitOfMeasureText as _Text 
        on $projection.UnitOfMeasure = _Text.UnitOfMeasure
    association [0..1] to I_UnitOfMeasureDimension as _Dimension
        on $projection.UnitOfMeasureDimension = _Dimension.UnitOfMeasureDimension 

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

{   
    
    @Semantics.unitOfMeasure: true
    @ObjectModel.text.association: '_Text'
    @Search.defaultSearchElement: true
    @Search.fuzzinessThreshold: 0.8
    @Search.ranking: #HIGH  
    key msehi as UnitOfMeasure,
    _Text,
    
    @ObjectModel.foreignKey.association: '_Dimension'
    dimid as UnitOfMeasureDimension,    
    _Dimension,
    
    _DimensionText
}

 where dimid = 'MASS'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T006"
],
"ASSOCIATED":
[
"I_UNITOFMEASUREDIMENSION",
"I_UNITOFMEASUREDIMENSIONTEXT",
"I_UNITOFMEASURETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More