I_RECIPE

CDS View

Recipe

I_RECIPE is a CDS View in S/4HANA. Recipe. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_RecipeFinderIssue view from CONSUMPTION Recipe Finder Issue
I_RecipeForKeyDate view from COMPOSITE Recipe for Key Date
I_RecipeVH view from COMPOSITE Recipe Value Help
R_RecipeTP view_entity from TRANSACTIONAL Recipe (Transactional Processing) 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IRECIPE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'RecipeUUID'

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

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

@EndUserText.label: 'Recipe'
define view I_Recipe
  as select from P_Recipe

  // Access Control Management integration

  association [0..1] to I_LogAccMObjectTypeActive  as _LogAccMObjectTypeActive  on  _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_RCP'
  association [0..*] to I_LogAccMObjSecureIDAssgmt as _LogAccMObjSecureIDAssgmt on  $projection.RecipeUniqueID                  = _LogAccMObjSecureIDAssgmt.LogAccMObjectID
                                                                                and _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_RCP'
  association [0..*] to I_LogAccMObjectUserAuthzn  as _LogAccMObjectUserAuthzn  on  $projection.RecipeUniqueID                            = _LogAccMObjectUserAuthzn.LogAccMObjectID
                                                                                and _LogAccMObjectUserAuthzn.LogAccMObjectType            = 'PLM_RCP'
                                                                                and _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject      = 'PLM_RCP'
                                                                                and _LogAccMObjectUserAuthzn.LogAccMReadActivityIsEnabled = 'X'
                                                                                and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField       = 'ACTVT'
                                                                                //and _LogAccMObjectUserAuthzn.LogAccMUserEntityID          = $session.user //DT2869058

                                                                                and _LogAccMObjectUserAuthzn.UserID                       = $session.user   //DT2869058


  association [1..1] to E_Recipe                   as _Extension                on  $projection.RecipeUUID = _Extension.RecipeUUID

{

  key RecipeUUID,
      RecipeUniqueID,
      Recipe,
      RecipePrimaryOutputInternalID,
      RecipeAlternativeNumber,
      RecipeVersionNumber,

      RecipeCreatedByUser,
      RecipeCreationDateTime,
      RecipeLastChangedByUser,
      RecipeLastChangeDateTime,

      RecipeType,
      RecipePurpose,
      RecipeStatus,
      RecipeStatusSchema,

      RcpFmlaUUID,
      RecipeProcessUUID,
      RecipePropertySpecInternalID,

      RecipeChangeNumber,
      RecipeIsDeleted,
      RecipeIsArchived,
      RecipeValidityStartDate,
      RecipeValidityEndDate,

      RecipeAuthorizationGroup,

      RecipeValidityMinQuantity,
      RecipeValidityMaxQuantity,
      RecipeValidityUnit,

      /* Associations */
      _CreatedByUser,
      _LastChangedByUser,
      _Plant,
      _RecipeDescription,
      _TextObjectPlainLongText,
      _AuthorizationGroup,
      _RecipeType,
      _RecipePurpose,
      _RecipeStatus,
      _RecipeStatusText,
      _RecipeDocInfoRecordObjectLink,

      _PrimaryOutputSpecification,
      _LogAccMObjectTypeActive,
      _LogAccMObjectUserAuthzn,
      _LogAccMObjSecureIDAssgmt
}
// Filter out Recipe Building Blocks

where
  _RecipeType.RecipeCategory = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECIPETYPE",
"P_RECIPE"
],
"ASSOCIATED":
[
"E_RECIPE",
"I_DOCUMENTINFORECORDOBJECTLINK",
"I_LOGACCMOBJECTTYPEACTIVE",
"I_LOGACCMOBJECTUSERAUTHZN",
"I_LOGACCMOBJSECUREIDASSGMT",
"I_RECIPEASSGDPLANT",
"I_RECIPEAUTHORIZATIONGROUP",
"I_RECIPEPURPOSE",
"I_RECIPESTATUS",
"I_RECIPETEXT",
"I_RECIPETYPE",
"I_SPECIFICATION",
"I_STSACTNMGMTSTATUSTEXT",
"I_TEXTOBJECTPLAINLONGTEXT",
"I_USER"
],
"BASE":
[
"P_RECIPE"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More