C_RO_SAFTMatlUnitOfMeasure

DDL: C_RO_SAFTMATLUNITOFMEASURE SQL: CROSAFTMATUOM Type: view CONSUMPTION

Materials Unit of Measure

C_RO_SAFTMatlUnitOfMeasure is a Consumption CDS View that provides data about "Materials Unit of Measure" in SAP S/4HANA. It reads from 1 data source (I_RO_SAFTUnitOfMeasure) and exposes 4 fields with key field SourceUnitOfMeasure.

Data Sources (1)

SourceAliasJoin Type
I_RO_SAFTUnitOfMeasure UOM inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTMATUOM view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Materials Unit of Measure view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SourceUnitOfMeasure UOMM SourceUnitOfMeasure
SourceUnitOfMeasureFactor I_RO_SAFTUnitOfMeasure SourceUnitOfMeasureFactor
UnitOfMeasureParameterDesc
_UnitOfMeasureText I_RO_SAFTUnitOfMeasure _UnitOfMeasureText
@AbapCatalog.sqlViewName: 'CROSAFTMATUOM'
@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey:true

@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Materials Unit of Measure'
define view C_RO_SAFTMatlUnitOfMeasure
  as select distinct from I_RO_SAFTUnitOfMeasureMap as UOMM
  inner join              I_RO_SAFTUnitOfMeasure    as UOM  on UOM.SourceUnitOfMeasureFactor = UOMM.SourceUnitOfMeasureFactor
{
  key UOMM.SourceUnitOfMeasure                                             as SourceUnitOfMeasure,
      @ObjectModel.text.association: '_UnitOfMeasureText'
      UOM.SourceUnitOfMeasureFactor                                        as SourceUnitOfMeasureFactor,
      UOM._UnitOfMeasureText[1: Language = '4'].UnitOfMeasureParameterDesc as UnitOfMeasureParameterDesc,
      UOM._UnitOfMeasureText
}