A_RecipeProcessEquipRqmt

DDL: A_RECIPEPROCESSEQUIPRQMT SQL: ARPREQUIPRQMT Type: view_entity CONSUMPTION Package: VDM_PLMB_RECIPE_API

Recipe Equipment Requirements

A_RecipeProcessEquipRqmt is a Consumption CDS View that provides data about "Recipe Equipment Requirements" in SAP S/4HANA. It reads from 1 data source (I_RecipeProcessEquipRqmtTP) and exposes 17 fields with key field RecipeProcessEquipRqmtUUID. It has 5 associations to related views. Part of development package VDM_PLMB_RECIPE_API.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_RecipeProcessEquipRqmtTP I_RecipeProcessEquipRqmtTP from

Parameters (1)

NameTypeDefault
P_KeyDate dats

Associations (5)

CardinalityTargetAliasCondition
[0..1] A_RecipeProcessElement _RecipeProcessElement $projection.RecipeProcessElementUUID = _RecipeProcessElement.RecipeProcessElementUUID
[0..*] A_RecipeProcessParamValue _RecipeProcessParamValue $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessParamValue.RecipeProcessEquipRqmtUUID
[0..*] A_RecProcEquipRqmtClass _RecProcEquipRqmtClass $projection.RecipeProcessEquipRqmtUUID = _RecProcEquipRqmtClass.RecipeProcessEquipRqmtUUID
[0..*] A_RecProcEquipRqmtCharc _RecProcEquipRqmtCharc $projection.RecipeProcessEquipRqmtUUID = _RecProcEquipRqmtCharc.RecipeProcessEquipRqmtUUID
[0..*] A_RecipeProcessEquipRqmtText _RecipeProcessEquipRqmtText

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.representativeKey RecipeProcessEquipRqmtUUID 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 Equipment Requirements view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY RecipeProcessEquipRqmtUUID RecipeProcessEquipRqmtUUID
RecipeProcessUUID RecipeProcessUUID
RecipeProcessElementUUID RecipeProcessElementUUID
RecipeProcessEquipRqmtPosNmbr RecipeProcessEquipRqmtPosNmbr
RecipeProcEquipRqmtIsPrimRsce RecipeProcEquipRqmtIsPrimRsce
RecipeLastChangeDateTime RecipeLastChangeDateTime
RecipeUUID RecipeUUID
Recipe Recipe
RecipeProcessStagePosNmbr RecipeProcessStagePosNmbr
RecipeProcessOperationPosNmbr RecipeProcessOperationPosNmbr
RecipeProcessActionPosNmbr RecipeProcessActionPosNmbr
_Recipe _Recipe
_RecipeProcessEquipRqmtText _RecipeProcessEquipRqmtText
_RecipeProcessElement _RecipeProcessElement
_RecipeProcessParamValue _RecipeProcessParamValue
_RecProcEquipRqmtClass _RecProcEquipRqmtClass
_RecProcEquipRqmtCharc _RecProcEquipRqmtCharc 
//@AbapCatalog.sqlViewName: 'ARPREQUIPRQMT'

//@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: 'RecipeProcessEquipRqmtUUID'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER

@Metadata.ignorePropagatedAnnotations: true

@Consumption.filter.businessDate.at: true

@EndUserText.label: 'Recipe Equipment Requirements'
define view entity A_RecipeProcessEquipRqmt
  with parameters
    @Consumption.hidden: true
    @Semantics.businessDate.at: true
    P_KeyDate :dats
  as select from I_RecipeProcessEquipRqmtTP( P_KeyDate: $parameters.P_KeyDate )

  association        to parent A_Recipe              as _Recipe                  on $projection.RecipeUUID = _Recipe.RecipeUUID

  // Process

  association [0..1] to A_RecipeProcessElement       as _RecipeProcessElement    on $projection.RecipeProcessElementUUID = _RecipeProcessElement.RecipeProcessElementUUID
  composition [0..*] of A_RecipeProcessEquipRqmtText as _RecipeProcessEquipRqmtText
  association [0..*] to A_RecipeProcessParamValue    as _RecipeProcessParamValue on $projection.RecipeProcessEquipRqmtUUID = _RecipeProcessParamValue.RecipeProcessEquipRqmtUUID


  association [0..*] to A_RecProcEquipRqmtClass      as _RecProcEquipRqmtClass   on $projection.RecipeProcessEquipRqmtUUID = _RecProcEquipRqmtClass.RecipeProcessEquipRqmtUUID
  association [0..*] to A_RecProcEquipRqmtCharc      as _RecProcEquipRqmtCharc   on $projection.RecipeProcessEquipRqmtUUID = _RecProcEquipRqmtCharc.RecipeProcessEquipRqmtUUID

{
  key RecipeProcessEquipRqmtUUID,

      RecipeProcessUUID,

      RecipeProcessElementUUID,

      RecipeProcessEquipRqmtPosNmbr,

      RecipeProcEquipRqmtIsPrimRsce,

      RecipeLastChangeDateTime,

      RecipeUUID,

      Recipe,

      RecipeProcessStagePosNmbr,
      RecipeProcessOperationPosNmbr,
      RecipeProcessActionPosNmbr,

      _Recipe,
      _RecipeProcessEquipRqmtText,
      _RecipeProcessElement,
      _RecipeProcessParamValue,

      _RecProcEquipRqmtClass,
      _RecProcEquipRqmtCharc
}

Learn More