C_RO_SAFTUnitOfMeasure

DDL: C_RO_SAFTUNITOFMEASURE SQL: CROSAFTUOM Type: view CONSUMPTION

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 3 data sources (I_StRpJournalEntryHeaderLog, P_RO_SAFTJournalEntryItemExc, I_RO_SAFTUnitOfMeasure) and exposes 8 fields with key fields SourceUnitOfMeasure, StatryRptCategory, StatryRptgEntity, StatryRptRunID.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
I_StRpJournalEntryHeaderLog Log inner
P_RO_SAFTJournalEntryItemExc P_RO_SAFTJournalEntryItemExc inner
I_RO_SAFTUnitOfMeasure UOM inner

Parameters (1)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

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 (8)

KeyFieldSource TableSource FieldDescription
KEY SourceUnitOfMeasure UOMM SourceUnitOfMeasure
KEY StatryRptCategory I_StRpJournalEntryHeaderLog StatryRptCategory
KEY StatryRptgEntity I_StRpJournalEntryHeaderLog StatryRptgEntity
KEY StatryRptRunID I_StRpJournalEntryHeaderLog StatryRptRunID
SourceUnitOfMeasureFactor I_RO_SAFTUnitOfMeasure SourceUnitOfMeasureFactor
UnitOfMeasureParameterDesc
_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

  with parameters
    P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

  as select distinct from I_RO_SAFTUnitOfMeasureMap                                                                            as UOMM
    inner join            I_RO_SAFTUnitOfMeasure                                                                               as UOM          on UOM.SourceUnitOfMeasureFactor = UOMM.SourceUnitOfMeasureFactor
    inner join            P_RO_SAFTJournalEntryItemExc(P_AlternativeGLAccountIsUsed: $parameters.P_AlternativeGLAccountIsUsed) as JournalEntry on JournalEntry.BaseUnit = UOMM.SourceUnitOfMeasure
    inner join            I_StRpJournalEntryHeaderLog                                                                          as Log          on  Log.AccountingDocument = JournalEntry.AccountingDocument
                                                                                                                                               and Log.CompanyCode        = JournalEntry.CompanyCode
                                                                                                                                               and Log.FiscalYear         = JournalEntry.FiscalYear
{
  key UOMM.SourceUnitOfMeasure                                             as SourceUnitOfMeasure,
      @Consumption.filter.selectionType: #SINGLE
  key Log.StatryRptCategory,
      @Consumption.filter.selectionType: #SINGLE
  key Log.StatryRptgEntity,
      @Consumption.filter.selectionType: #SINGLE
  key Log.StatryRptRunID,

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


      UOM._UnitOfMeasureText,
      'X'                                                                  as ItemIsReportingRelevant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RO_SAFTUNITOFMEASURE",
"I_RO_SAFTUNITOFMEASUREMAP",
"I_RO_SAFTUNITOFMEASURETEXT",
"I_STRPJOURNALENTRYHEADERLOG",
"P_RO_SAFTJOURNALENTRYITEMEXC"
],
"ASSOCIATED":
[
"I_RO_SAFTUNITOFMEASURETEXT"
],
"BASE":
[
"I_RO_SAFTUNITOFMEASURE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More