A_RecipeCharcValue

DDL: A_RECIPECHARCVALUE SQL: ANGCRECCLFN4 Type: view CONSUMPTION Package: VDM_PLMB_RECIPE_API

Recipe Characteristic Values

A_RecipeCharcValue is a Consumption CDS View that provides data about "Recipe Characteristic Values" in SAP S/4HANA. It reads from 1 data source (I_RecipeCharcValueTP) and exposes 23 fields with key fields RecipeUUID, ClassType, CharcInternalID, CharcValuePositionNumber. It has 1 association to related views. Part of development package VDM_PLMB_RECIPE_API.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_RecipeCharcValueTP I_RecipeCharcValueTP from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

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

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ANGCRECCLFN4 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Consumption.filter.businessDate.at true view
EndUserText.label Recipe Characteristic Values view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY RecipeUUID 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
CharcMaintAuthGrp
_Recipe _Recipe 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'ANGCRECCLFN4'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@Consumption.filter.businessDate.at: true

@EndUserText.label: 'Recipe Characteristic Values'
define view A_RecipeCharcValue 
  with parameters
    @Consumption.hidden: true
    @Semantics.businessDate.at: true
    P_KeyDate:sydate
  as select from I_RecipeCharcValueTP( P_KeyDate: $parameters.P_KeyDate ) as Valuation 
    association [1..1] to A_Recipe as _Recipe on
      $projection.RecipeUUID = _Recipe.RecipeUUID
  {
    key 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,
    _Characteristic(P_KeyDate: $parameters.P_KeyDate).CharcMaintAuthGrp,
    
    _Recipe
  }

Learn More