A_RecipeProcessParamValue

DDL: A_RECIPEPROCESSPARAMVALUE SQL: ARPRPARAMVAL Type: view_entity CONSUMPTION

Recipe Process Parameter Values

A_RecipeProcessParamValue is a Consumption CDS View that provides data about "Recipe Process Parameter Values" in SAP S/4HANA. It reads from 1 data source (I_RecipeProcessParamValueTP) and exposes 25 fields with key field RecipeProcessParamValUUID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RecipeProcessParamValueTP I_RecipeProcessParamValueTP from

Parameters (1)

NameTypeDefault
P_KeyDate dats

Associations (6)

CardinalityTargetAliasCondition
[0..1] A_RecipeProcessParam _RecipeProcessParam $projection.RecipeProcessParamUUID = _RecipeProcessParam.RecipeProcessParamUUID
[0..1] A_RecipeProcessElement _RecipeProcessElement $projection.RecipeProcessElementUUID = _RecipeProcessElement.RecipeProcessElementUUID
[0..1] A_RecipeProcessEquipRqmt _RecipeProcessEquipRqmt $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessEquipRqmt.RecipeProcessEquipRqmtUUID
[0..*] A_RecProcParamValClass _RecProcParamValClass $projection.RecipeProcessParamValUUID = _RecProcParamValClass.RecipeProcessParamValUUID
[0..*] A_RecProcParamValCharc _RecProcParamValCharc $projection.RecipeProcessParamValUUID = _RecProcParamValCharc.RecipeProcessParamValUUID
[0..*] A_RecipeProcessParamValueTxt _RecipeProcessParamValueTxt

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey RecipeProcessParamValUUID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
Consumption.filter.businessDate.at true view
EndUserText.label Recipe Process Parameter Values view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY RecipeProcessParamValUUID RecipeProcessParamValUUID
RecipeProcessUUID RecipeProcessUUID
RecipeProcessElementUUID RecipeProcessElementUUID
RecipeProcessParamUUID RecipeProcessParamUUID
RecipeProcessEquipRqmtUUID RecipeProcessEquipRqmtUUID
RecipeProcessParamUnit RecipeProcessParamUnit
RecipeProcessParamTgtVal RecipeProcessParamTgtVal
RecipeProcessParamMinVal RecipeProcessParamMinVal
RecipeProcessParamMaxVal RecipeProcessParamMaxVal
RecipeProcessParamSqncNmbr RecipeProcessParamSqncNmbr
RecipeLastChangeDateTime RecipeLastChangeDateTime
RecipeUUID RecipeUUID
Recipe Recipe
RecipeProcessParam RecipeProcessParam
RecipeProcessEquipRqmtPosNmbr RecipeProcessEquipRqmtPosNmbr
RecipeProcessStagePosNmbr RecipeProcessStagePosNmbr
RecipeProcessOperationPosNmbr RecipeProcessOperationPosNmbr
RecipeProcessActionPosNmbr RecipeProcessActionPosNmbr
_Recipe _Recipe
_RecipeProcessParamValueTxt _RecipeProcessParamValueTxt
_RecipeProcessElement _RecipeProcessElement
_RecipeProcessParam _RecipeProcessParam
_RecipeProcessEquipRqmt _RecipeProcessEquipRqmt
_RecProcParamValClass _RecProcParamValClass
_RecProcParamValCharc _RecProcParamValCharc
//@AbapCatalog.sqlViewName: 'ARPRPARAMVAL'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true


@AccessControl.authorizationCheck: #CHECK

//@ClientHandling.algorithm: #SESSION_VARIABLE


@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

@ObjectModel.representativeKey: 'RecipeProcessParamValUUID'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER

@Metadata.ignorePropagatedAnnotations: true

@Consumption.filter.businessDate.at: true

@EndUserText.label: 'Recipe Process Parameter Values'
define view entity A_RecipeProcessParamValue
  with parameters
    @Consumption.hidden: true
    @Semantics.businessDate.at: true
    P_KeyDate :dats
  as select from I_RecipeProcessParamValueTP( P_KeyDate: $parameters.P_KeyDate )

  association        to parent A_Recipe              as _Recipe                 on $projection.RecipeUUID = _Recipe.RecipeUUID
  composition [0..*] of A_RecipeProcessParamValueTxt as _RecipeProcessParamValueTxt
  association [0..1] to A_RecipeProcessParam         as _RecipeProcessParam     on $projection.RecipeProcessParamUUID = _RecipeProcessParam.RecipeProcessParamUUID
  association [0..1] to A_RecipeProcessElement       as _RecipeProcessElement   on $projection.RecipeProcessElementUUID = _RecipeProcessElement.RecipeProcessElementUUID
  association [0..1] to A_RecipeProcessEquipRqmt     as _RecipeProcessEquipRqmt on $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessEquipRqmt.RecipeProcessEquipRqmtUUID


  association [0..*] to A_RecProcParamValClass       as _RecProcParamValClass   on $projection.RecipeProcessParamValUUID = _RecProcParamValClass.RecipeProcessParamValUUID
  association [0..*] to A_RecProcParamValCharc       as _RecProcParamValCharc   on $projection.RecipeProcessParamValUUID = _RecProcParamValCharc.RecipeProcessParamValUUID

{

  key RecipeProcessParamValUUID,

      RecipeProcessUUID,

      RecipeProcessElementUUID,
      RecipeProcessParamUUID,
      RecipeProcessEquipRqmtUUID,

      RecipeProcessParamUnit,
      RecipeProcessParamTgtVal,
      RecipeProcessParamMinVal,
      RecipeProcessParamMaxVal,
      RecipeProcessParamSqncNmbr,

      RecipeLastChangeDateTime,

      RecipeUUID,

      Recipe,

      RecipeProcessParam,
      RecipeProcessEquipRqmtPosNmbr,
      RecipeProcessStagePosNmbr,
      RecipeProcessOperationPosNmbr,
      RecipeProcessActionPosNmbr,

      _Recipe,

      _RecipeProcessParamValueTxt,

      _RecipeProcessElement,
      _RecipeProcessParam,
      _RecipeProcessEquipRqmt,

      _RecProcParamValClass,
      _RecProcParamValCharc

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECIPEPROCESSPARAMVALUETP"
],
"ASSOCIATED":
[
"A_RECIPE",
"A_RECIPEPROCESSELEMENT",
"A_RECIPEPROCESSEQUIPRQMT",
"A_RECIPEPROCESSPARAM",
"A_RECIPEPROCESSPARAMVALUETXT",
"A_RECPROCPARAMVALCHARC",
"A_RECPROCPARAMVALCLASS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/