I_CommodityPricingRoutineText

DDL: I_COMMODITYPRICINGROUTINETEXT SQL: IROUTINETEXT Type: view BASIC

CPE Routine Text

I_CommodityPricingRoutineText is a Basic CDS View that provides data about "CPE Routine Text" in SAP S/4HANA. It reads from 1 data source (cpec_routine_t) and exposes 8 fields with key fields Language, OriginSystem, PricingConditionModule, PricingConditionSubModule, PricingConditionRoutine. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
cpec_routine_t cpec_routine_t from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CommodityPricingRoutine _CommodityPricingRoutine _CommodityPricingRoutine.OriginSystem = $projection.OriginSystem and _CommodityPricingRoutine.PricingConditionModule = $projection.PricingConditionModule and _CommodityPricingRoutine.PricingConditionSubModule = $projection.PricingConditionSubModule and _CommodityPricingRoutine.PricingConditionRoutine = $projection.PricingConditionRoutine
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IROUTINETEXT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label CPE Routine Text view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey PricingConditionRoutine view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY Language langu
KEY OriginSystem logsys
KEY PricingConditionModule cpe_module
KEY PricingConditionSubModule submodule
KEY PricingConditionRoutine cpe_routine
PricingConditionRoutineText routtext
_CommodityPricingRoutine _CommodityPricingRoutine
_Language _Language 
@AbapCatalog.sqlViewName: 'IROUTINETEXT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'CPE Routine Text'
@ObjectModel.dataCategory:#TEXT
@VDM.viewType:#BASIC
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.representativeKey: 'PricingConditionRoutine'
define view I_CommodityPricingRoutineText
  as select from cpec_routine_t
  association [1..1] to I_CommodityPricingRoutine as _CommodityPricingRoutine on  _CommodityPricingRoutine.OriginSystem              = $projection.OriginSystem
                                                                              and _CommodityPricingRoutine.PricingConditionModule    = $projection.PricingConditionModule
                                                                              and _CommodityPricingRoutine.PricingConditionSubModule = $projection.PricingConditionSubModule
                                                                              and _CommodityPricingRoutine.PricingConditionRoutine   = $projection.PricingConditionRoutine
  association [0..1] to I_Language                as _Language                on  $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key langu       as Language,
  key logsys      as OriginSystem,
  key cpe_module  as PricingConditionModule,
  key submodule   as PricingConditionSubModule,
      @ObjectModel.foreignKey.association: '_CommodityPricingRoutine'
  key cpe_routine as PricingConditionRoutine,
      @Semantics.text: true
      routtext    as PricingConditionRoutineText,

      _CommodityPricingRoutine,
      _Language

}

Learn More