A_Recipe

DDL: A_RECIPE SQL: ARECIPE Type: view CONSUMPTION

Recipe Header Data

A_Recipe is a Consumption CDS View that provides data about "Recipe Header Data" in SAP S/4HANA. It reads from 1 data source (I_RecipeForKeyDateTP) and exposes 38 fields with key field RecipeUUID. It has 11 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_RecipeForKeyDateTP I_RecipeForKeyDateTP from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Associations (11)

CardinalityTargetAliasCondition
[0..*] A_RecipeClass _Classification $projection.RecipeUUID = _Classification.RecipeUUID
[0..*] A_RecipeCharc _Characteristics $projection.RecipeUUID = _Characteristics.RecipeUUID
[0..1] A_LogAccMObjectTypeActive _LogAccMObjectTypeActive _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_RCP'
[0..*] A_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt $projection.RecipeUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID and _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_RCP'
[0..*] A_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn $projection.RecipeUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID and _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_RCP' and _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_RCP' and ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' and ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user or _LogAccMObjectUserAuthzn.UserID = $session.user )
[1..1] E_Recipe _Extension $projection.RecipeUUID = _Extension.RecipeUUID
[0..*] A_RecipeText _RecipeText
[1..*] A_RecipeFormulaItem _FormulaItem
[0..*] A_RecipeProcessElement _RecipeProcessElement
[0..*] A_RecipeProcessEquipRqmt _RecipeProcessEquipRqmt
[0..*] A_RecipeProcessParamValue _RecipeProcessParamValue

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ARECIPE 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
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
Consumption.filter.businessDate.at true view
EndUserText.label Recipe Header Data view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY RecipeUUID RecipeUUID
RecipeUniqueID RecipeUniqueID
Recipe Recipe
RecipePrimaryOutputInternalID RecipePrimaryOutputInternalID
RecipePrimaryOutput RecipePrimaryOutput
RecipeAlternativeNumber RecipeAlternativeNumber
RecipeVersionNumber RecipeVersionNumber
RecipeType RecipeType
RecipePurpose RecipePurpose
RecipeStatus RecipeStatus
RecipeStatusSchema RecipeStatusSchema
RecipeAuthorizationGroup RecipeAuthorizationGroup
RcpFmlaUUID RcpFmlaUUID
RecipeProcessUUID RecipeProcessUUID
RecipeValidityStartDate RecipeValidityStartDate
RecipeValidityEndDate RecipeValidityEndDate
RecipeValidityMinQuantity RecipeValidityMinQuantity
RecipeValidityMaxQuantity RecipeValidityMaxQuantity
RecipeValidityUnit RecipeValidityUnit
Plant _Plant Plant
RecipeCreatedByUser RecipeCreatedByUser
RecipeLastChangedByUser RecipeLastChangedByUser
RecipeCreationDateTime RecipeCreationDateTime
RecipeLastChangeDateTime RecipeLastChangeDateTime
RecipeIsDeleted RecipeIsDeleted
RecipeIsArchived RecipeIsArchived
RecipePrimOutpAuthznGrp RecipePrimOutpAuthznGrp
RecipePrimOutpSpecType RecipePrimOutpSpecType
_RecipeText _RecipeText
_FormulaItem _FormulaItem
_Classification _Classification
_Characteristics _Characteristics
_LogAccMObjectTypeActive _LogAccMObjectTypeActive
_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn
_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt
_RecipeProcessElement _RecipeProcessElement
_RecipeProcessEquipRqmt _RecipeProcessEquipRqmt
_RecipeProcessParamValue _RecipeProcessParamValue
@AbapCatalog.sqlViewName: 'ARECIPE'
@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

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

@Metadata.ignorePropagatedAnnotations: true

@Consumption.filter.businessDate.at: true

@EndUserText.label: 'Recipe Header Data'
define root view A_Recipe
  with parameters
    @Consumption.hidden: true
    @Semantics.businessDate.at: true
    P_KeyDate : sydate
  as select from I_RecipeForKeyDateTP( P_KeyDate: $parameters.P_KeyDate )
  composition [0..*] of A_RecipeText               as _RecipeText
  composition [1..*] of A_RecipeFormulaItem        as _FormulaItem

  // Classification integration

  association [0..*] to A_RecipeClass              as _Classification           on  $projection.RecipeUUID = _Classification.RecipeUUID
  association [0..*] to A_RecipeCharc              as _Characteristics          on  $projection.RecipeUUID = _Characteristics.RecipeUUID

  // Access Control Management integration

  association [0..1] to A_LogAccMObjectTypeActive  as _LogAccMObjectTypeActive  on  _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_RCP'
  association [0..*] to A_LogAccMObjSecureIDAssgmt as _LogAccMObjSecureIDAssgmt on  $projection.RecipeUniqueID                  = _LogAccMObjSecureIDAssgmt.LogAccMObjectID
                                                                                and _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_RCP'
  association [0..*] to A_LogAccMObjectUserAuthzn  as _LogAccMObjectUserAuthzn  on  $projection.RecipeUniqueID                       = _LogAccMObjectUserAuthzn.LogAccMObjectID
                                                                                and _LogAccMObjectUserAuthzn.LogAccMObjectType       = 'PLM_RCP'
                                                                                and _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_RCP'
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom    = '03'
                                                                                   or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*'
                                                                                 )
                                                                                and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField  = 'ACTVT'
                                                                                and (
                                                                                   _LogAccMObjectUserAuthzn.LogAccMUserEntityID      = $session.user
                                                                                   or _LogAccMObjectUserAuthzn.UserID                = $session.user
                                                                                 )
  association [1..1] to E_Recipe                   as _Extension                on  $projection.RecipeUUID = _Extension.RecipeUUID

  composition [0..*] of A_RecipeProcessElement     as _RecipeProcessElement
  composition [0..*] of A_RecipeProcessEquipRqmt   as _RecipeProcessEquipRqmt
  composition [0..*] of A_RecipeProcessParamValue  as _RecipeProcessParamValue

{
      @ObjectModel.text.association: '_RecipeText'
  key RecipeUUID,

      RecipeUniqueID,
      Recipe,
      RecipePrimaryOutputInternalID,
      RecipePrimaryOutput,
      RecipeAlternativeNumber,
      RecipeVersionNumber,

      RecipeType,
      RecipePurpose,
      RecipeStatus,
      RecipeStatusSchema,
      RecipeAuthorizationGroup,

      RcpFmlaUUID,
      RecipeProcessUUID,
      RecipeValidityStartDate,
      RecipeValidityEndDate,

      @Semantics.quantity.unitOfMeasure: 'RecipeValidityUnit'
      RecipeValidityMinQuantity,
      @Semantics.quantity.unitOfMeasure: 'RecipeValidityUnit'
      RecipeValidityMaxQuantity,
      @Semantics.unitOfMeasure: true
      RecipeValidityUnit,

      _Plant.Plant,

      RecipeCreatedByUser,
      RecipeLastChangedByUser,
      RecipeCreationDateTime,
      RecipeLastChangeDateTime,

      RecipeIsDeleted,
      RecipeIsArchived,
      RecipePrimOutpAuthznGrp,
      RecipePrimOutpSpecType,

      _RecipeText,
      _FormulaItem,
      _Classification,
      _Characteristics,

      _LogAccMObjectTypeActive,
      _LogAccMObjectUserAuthzn,
      _LogAccMObjSecureIDAssgmt,

      _RecipeProcessElement,
      _RecipeProcessEquipRqmt,
      _RecipeProcessParamValue

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECIPEASSGDPLANT",
"I_RECIPEFORKEYDATETP"
],
"ASSOCIATED":
[
"A_LOGACCMOBJECTTYPEACTIVE",
"A_LOGACCMOBJECTUSERAUTHZN",
"A_LOGACCMOBJSECUREIDASSGMT",
"A_RECIPECHARC",
"A_RECIPECLASS",
"A_RECIPEFORMULAITEM",
"A_RECIPEPROCESSELEMENT",
"A_RECIPEPROCESSEQUIPRQMT",
"A_RECIPEPROCESSPARAMVALUE",
"A_RECIPETEXT",
"E_RECIPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/