I_RecipeForKeyDateTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_RecipeForKeyDateTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IRECIPEKDTP
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_RecipeForKeyDateTP AS
SELECT
  RecipeUUID,
  RecipeUniqueID,
  Recipe,
  RecipePrimaryOutputInternalID,
  RecipeAlternativeNumber,
  RecipeVersionNumber,
  cast(_PrimaryOutputSpecification(P_KeyDate:$parameters.P_KeyDate).Specification as /plmb/rcp_prim_output_id preserving type) AS RecipePrimaryOutput,
  RecipeType,
  RecipePurpose,
  RecipeStatus,
  RecipeStatusSchema,
  RecipeAuthorizationGroup,
  RcpFmlaUUID,
  RecipeProcessUUID,
  RecipeValidityStartDate,
  RecipeValidityEndDate,
  RecipeValidityMinQuantity,
  RecipeValidityMaxQuantity,
  RecipeValidityUnit,
  RecipeCreatedByUser,
  RecipeLastChangedByUser,
  RecipeCreationDateTime,
  RecipeLastChangeDateTime,
  RecipeIsDeleted,
  RecipeIsArchived,
  _PrimaryOutputSpecification(P_KeyDate:$parameters.P_KeyDate).SpecificationAuthznGroup AS RecipePrimOutpAuthznGrp,
  _PrimaryOutputSpecification(P_KeyDate:$parameters.P_KeyDate).SpecificationType AS RecipePrimOutpSpecType
FROM I_RecipeForKeyDate
LEFT OUTER JOIN I_LogAccMObjectTypeActive AS _LogAccMObjectTypeActive ON _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_RCP'  -- association [0..1]
LEFT OUTER JOIN I_LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt ON RecipeUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_RCP'  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn ON 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 [0..*]
LEFT OUTER JOIN E_Recipe AS _Extension ON RecipeUUID = _Extension.RecipeUUID  -- association [1..1]
LEFT OUTER JOIN I_RecipeTextTP AS _RecipeText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_RecipeFmlaItemForKeyDateTP AS _FormulaItem ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_RecipeProcessEquipRqmtTP AS _RecipeProcessEquipRqmt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_RecipeProcessElementTP AS _RecipeProcessElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_RecipeProcessParamValueTP AS _RecipeProcessParamValue ON /* condition not available in parsed metadata */  -- association [0..*]
;