I_RecipeCharcValueTP

DDL: I_RECIPECHARCVALUETP SQL: IRECCHRVALTP Type: view TRANSACTIONAL

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.

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

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IRECCHRVALTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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 ClassType
KEY CharcInternalID CharcInternalID
KEY CharcValuePositionNumber CharcValuePositionNumber
KeyDate
CharcValueDependency CharcValueDependency
CharcValue CharcValue
CharcFromNumericValue CharcFromNumericValue
CharcFromNumericValueUnit CharcFromNumericValueUnit
CharcToNumericValue CharcToNumericValue
CharcToNumericValueUnit CharcToNumericValueUnit
CharcFromDecimalValue CharcFromDecimalValue
CharcToDecimalValue CharcToDecimalValue
CharcFromAmount CharcFromAmount
CharcToAmount CharcToAmount
Currency Currency
CharcFromDate CharcFromDate
CharcToDate CharcToDate
CharcFromTime CharcFromTime
CharcToTime CharcToTime
CharacteristicAuthor CharacteristicAuthor
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
_Recipe _Recipe
_Characteristic Valuation _Characteristic 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IRECCHRVALTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: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 ClassType,
    key CharcInternalID,
    key CharcValuePositionNumber,
          
    $parameters.P_KeyDate as KeyDate,
    CharcValueDependency,
    CharcValue,
    CharcFromNumericValue,  
    CharcFromNumericValueUnit,
    CharcToNumericValue,     
    CharcToNumericValueUnit,
    CharcFromDecimalValue,
    CharcToDecimalValue,
    @Semantics.amount.currencyCode: 'Currency'
    CharcFromAmount,
    @Semantics.amount.currencyCode: 'Currency'
    CharcToAmount,
    @Semantics.currencyCode: true
    Currency,
    CharcFromDate,
    CharcToDate,
    CharcFromTime,
    CharcToTime, 
    CharacteristicAuthor,
    ValidityStartDate,   
    ValidityEndDate,
            
    _Recipe,
    Valuation._Characteristic
  }
    where
      ClfnObjectTable = '/PLMB/RCP_RECIPE' and 
      ClfnObjectType = 'O'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNOBJECTCHARCVALFORKEYDATE",
"I_RECIPEFORKEYDATETP"
],
"ASSOCIATED":
[
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_RECIPEFORKEYDATETP"
],
"BASE":
[
"I_CLFNOBJECTCHARCVALFORKEYDATE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More