I_RecipeProcessElmntForKeyDate

DDL: I_RECIPEPROCESSELMNTFORKEYDATE SQL: IRPRELEMENTKD Type: view COMPOSITE

Recipe Process Element for Key Date

I_RecipeProcessElmntForKeyDate is a Composite CDS View that provides data about "Recipe Process Element for Key Date" in SAP S/4HANA. It reads from 1 data source (I_RecipeProcessElement) and exposes 12 fields with key field RecipeProcessElementUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_RecipeProcessElement I_RecipeProcessElement from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_RecipeForKeyDate _RecipeForKeyDate $projection.RecipeProcessUUID = _RecipeForKeyDate.RecipeProcessUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IRPRELEMENTKD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey RecipeProcessElementUUID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Recipe Process Element for Key Date view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY RecipeProcessElementUUID RecipeProcessElementUUID
RecipeProcessStageUUID RecipeProcessStageUUID
RecipeProcessOperationUUID RecipeProcessOperationUUID
RecipeProcessActionUUID RecipeProcessActionUUID
RecipeProcessUUID RecipeProcessUUID
RecipeProcessStagePosNmbr RecipeProcessStagePosNmbr
RecipeProcessOperationPosNmbr RecipeProcessOperationPosNmbr
RecipeProcessActionPosNmbr RecipeProcessActionPosNmbr
_RecipeForKeyDate _RecipeForKeyDate
_RecipeProcessStageDescription _RecipeProcessStageDescription
_RecipeProcessOperationDesc _RecipeProcessOperationDesc
_RecipeProcessActionDesc _RecipeProcessActionDesc
@AbapCatalog.sqlViewName: 'IRPRELEMENTKD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'RecipeProcessElementUUID'

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

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #COMPOSITE

@EndUserText.label: 'Recipe Process Element for Key Date'

define view I_RecipeProcessElmntForKeyDate
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_RecipeProcessElement
  association [1..1] to I_RecipeForKeyDate as _RecipeForKeyDate on $projection.RecipeProcessUUID = _RecipeForKeyDate.RecipeProcessUUID
{
  key RecipeProcessElementUUID,
      RecipeProcessStageUUID,
      RecipeProcessOperationUUID,
      RecipeProcessActionUUID,
      
      RecipeProcessUUID,
      
      RecipeProcessStagePosNmbr,
      RecipeProcessOperationPosNmbr,
      RecipeProcessActionPosNmbr,

      /* Associations */
      _RecipeForKeyDate,

      // Texts

      _RecipeProcessStageDescription,
      _RecipeProcessOperationDesc,
      _RecipeProcessActionDesc      

}