I_RecipeCharcValueTP

DDL: I_RECIPECHARCVALUETP SQL: IRECCHRVALTP Type: view TRANSACTIONAL Package: VDM_PLMB_RCP

TP for Recipe Charc Valuation

I_RecipeCharcValueTP is a Transactional CDS View that provides data about "TP for Recipe Charc Valuation" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharcValForKeyDate) and exposes 25 fields with key fields RecipeUUID, ClassType, CharcInternalID, CharcValuePositionNumber. It has 1 association to related views. Part of development package VDM_PLMB_RCP.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_RecipeForKeyDateTP _Recipe $projection.RecipeUUID = _Recipe.RecipeUUID

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IRECCHRVALTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label TP for Recipe Charc Valuation view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY RecipeUUID Recipe RecipeUUID
KEY ClassType Valuation ClassType
KEY CharcInternalID Valuation CharcInternalID
KEY CharcValuePositionNumber Valuation CharcValuePositionNumber
KeyDate
CharcValueDependency Valuation CharcValueDependency
CharcValue Valuation CharcValue
CharcFromNumericValue Valuation CharcFromNumericValue
CharcFromNumericValueUnit Valuation CharcFromNumericValueUnit
CharcToNumericValue Valuation CharcToNumericValue
CharcToNumericValueUnit Valuation CharcToNumericValueUnit
CharcFromDecimalValue Valuation CharcFromDecimalValue
CharcToDecimalValue Valuation CharcToDecimalValue
CharcFromAmount Valuation CharcFromAmount
CharcToAmount Valuation CharcToAmount
Currency Valuation Currency
CharcFromDate Valuation CharcFromDate
CharcToDate Valuation CharcToDate
CharcFromTime Valuation CharcFromTime
CharcToTime Valuation CharcToTime
CharacteristicAuthor Valuation CharacteristicAuthor
ValidityStartDate Valuation ValidityStartDate
ValidityEndDate Valuation ValidityEndDate
_Recipe _Recipe
_Characteristic Valuation _Characteristic 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IRECCHRVALTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'TP for Recipe Charc Valuation'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
define view I_RecipeCharcValueTP 
  with parameters
    @Consumption.hidden: true
    @Semantics.businessDate.at: true
    P_KeyDate:sydate
  as select from I_ClfnObjectCharcValForKeyDate( P_KeyDate:$parameters.P_KeyDate ) as Valuation
       join I_RecipeForKeyDateTP( P_KeyDate: $parameters.P_KeyDate ) as Recipe on
         Valuation.ClfnObjectID = bintohex( Recipe.RecipeUUID )
    
    association [1..1] to I_RecipeForKeyDateTP as _Recipe on
      $projection.RecipeUUID = _Recipe.RecipeUUID 
  {
    key Recipe.RecipeUUID,
    key Valuation.ClassType,
    key Valuation.CharcInternalID,
    key Valuation.CharcValuePositionNumber,
          
    $parameters.P_KeyDate as KeyDate,
    Valuation.CharcValueDependency,
    Valuation.CharcValue,
    Valuation.CharcFromNumericValue,  
    Valuation.CharcFromNumericValueUnit,
    Valuation.CharcToNumericValue,     
    Valuation.CharcToNumericValueUnit,
    Valuation.CharcFromDecimalValue,
    Valuation.CharcToDecimalValue,
    @Semantics.amount.currencyCode: 'Currency'
    Valuation.CharcFromAmount,
    @Semantics.amount.currencyCode: 'Currency'
    Valuation.CharcToAmount,
    @Semantics.currencyCode: true
    Valuation.Currency,
    Valuation.CharcFromDate,
    Valuation.CharcToDate,
    Valuation.CharcFromTime,
    Valuation.CharcToTime, 
    Valuation.CharacteristicAuthor,
    Valuation.ValidityStartDate,   
    Valuation.ValidityEndDate,
            
    _Recipe,
    Valuation._Characteristic
  }
    where
      Valuation.ClfnObjectTable = '/PLMB/RCP_RECIPE' and 
      Valuation.ClfnObjectType = 'O'

Learn More