C_RO_SAFTUnitOfMeasure

DDL: C_RO_SAFTUNITOFMEASURE SQL: CROSAFTUOM Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_RO

Unit Of Measure

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

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_RO_SAFTUnitOfMeasure UOM inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTUOM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Unit Of Measure view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY SourceUnitOfMeasure UOMM SourceUnitOfMeasure
SourceUnitOfMeasureFactor I_RO_SAFTUnitOfMeasure SourceUnitOfMeasureFactor
_UnitOfMeasureText I_RO_SAFTUnitOfMeasure _UnitOfMeasureText
ItemIsReportingRelevant 
@AbapCatalog.sqlViewName: 'CROSAFTUOM'
@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: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Unit Of Measure'
define view C_RO_SAFTUnitOfMeasure

  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,
// do not use - no longer dependant on report run


      @ObjectModel.text.association: '_UnitOfMeasureText'
      UOM.SourceUnitOfMeasureFactor                                                  as SourceUnitOfMeasureFactor,
      coalesce(UOM._UnitOfMeasureText[1: Language = '4'].UnitOfMeasureParameterDesc,
               UOM._UnitOfMeasureText[1: Language = 'E'].UnitOfMeasureParameterDesc) as UnitOfMeasureParameterDesc,

      UOM._UnitOfMeasureText,
      'X'                                                                            as ItemIsReportingRelevant
}

Learn More