I_RecipeProcessParamValueTP

DDL: I_RECIPEPROCESSPARAMVALUETP SQL: IRPRPARAMVALTP Type: view TRANSACTIONAL

Recipe Process Parameter Value (Transactional Processing)

I_RecipeProcessParamValueTP is a Transactional CDS View that provides data about "Recipe Process Parameter Value (Transactional Processing)" in SAP S/4HANA. It reads from 1 data source (I_RecipeProcessParamValue) and exposes 21 fields with key field RecipeProcessParamValUUID. It has 4 associations to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_RecipeProcessParamValue I_RecipeProcessParamValue from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_RecipeProcessParam _RecipeProcessParam $projection.RecipeProcessParamUUID = _RecipeProcessParam.RecipeProcessParamUUID
[0..1] I_RecipeProcessElementTP _RecipeProcessElementTP $projection.RecipeProcessElementUUID = _RecipeProcessElementTP.RecipeProcessElementUUID
[0..1] I_RecipeProcessEquipRqmtTP _RecipeProcessEquipRqmtTP $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessEquipRqmtTP.RecipeProcessEquipRqmtUUID
[0..*] I_RecipeProcessParamValueTxtTP _RecipeProcessParamValueTxtTP

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IRPRPARAMVALTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey RecipeProcessParamValUUID view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Recipe Process Parameter Value (Transactional Processing) view

Fields (21)

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
RecipeUUID RecipeUUID
Recipe
RecipeProcessParam _RecipeProcessParam RecipeProcessParam
RecipeProcessEquipRqmtPosNmbr
RecipeProcessStagePosNmbr
RecipeProcessOperationPosNmbr
RecipeProcessActionPosNmbr
_RecipeProcessParam _RecipeProcessParam
_RecipeForKeyDateTP _RecipeForKeyDateTP
_RecipeProcessParamValueTxtTP _RecipeProcessParamValueTxtTP 
@AbapCatalog.sqlViewName: 'IRPRPARAMVALTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@ObjectModel.representativeKey: 'RecipeProcessParamValUUID'

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Recipe Process Parameter Value (Transactional Processing)'

define view I_RecipeProcessParamValueTP
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    @Consumption.hidden: true
    P_KeyDate : sydate
  as select from I_RecipeProcessParamValue
  association        to parent I_RecipeForKeyDateTP    as _RecipeForKeyDateTP       on $projection.RecipeUUID = _RecipeForKeyDateTP.RecipeUUID
  association [0..1] to I_RecipeProcessParam           as _RecipeProcessParam       on $projection.RecipeProcessParamUUID = _RecipeProcessParam.RecipeProcessParamUUID
  association [0..1] to I_RecipeProcessElementTP       as _RecipeProcessElementTP   on $projection.RecipeProcessElementUUID = _RecipeProcessElementTP.RecipeProcessElementUUID
  association [0..1] to I_RecipeProcessEquipRqmtTP     as _RecipeProcessEquipRqmtTP on $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessEquipRqmtTP.RecipeProcessEquipRqmtUUID

  // Texts

  composition [0..*] of I_RecipeProcessParamValueTxtTP as _RecipeProcessParamValueTxtTP

{
  key RecipeProcessParamValUUID,

      RecipeProcessUUID,

      RecipeProcessElementUUID,
      RecipeProcessParamUUID,
      RecipeProcessEquipRqmtUUID,

      RecipeProcessParamUnit,
      RecipeProcessParamTgtVal,
      RecipeProcessParamMinVal,
      RecipeProcessParamMaxVal,
      RecipeProcessParamSqncNmbr,

      // for ETag handling

      _RecipeForKeyDateTP(P_KeyDate : $parameters.P_KeyDate ).RecipeLastChangeDateTime,

      // for shadow locking

      RecipeUUID,

      _RecipeForKeyDateTP(P_KeyDate : $parameters.P_KeyDate ).Recipe,

      _RecipeProcessParam.RecipeProcessParam,
      _RecipeProcessEquipRqmtTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessEquipRqmtPosNmbr,
      _RecipeProcessElementTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessStagePosNmbr,
      _RecipeProcessElementTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessOperationPosNmbr,
      _RecipeProcessElementTP(P_KeyDate : $parameters.P_KeyDate ).RecipeProcessActionPosNmbr,

      _RecipeProcessParam,
      _RecipeForKeyDateTP,
      _RecipeProcessParamValueTxtTP
}
where
  _RecipeForKeyDateTP(P_KeyDate : $parameters.P_KeyDate ).RecipeLastChangeDateTime is not null

Learn More