I_RecipeForKeyDate

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_RecipeForKeyDate.
-- 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: IRECIPEKD
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_RecipeForKeyDate AS
SELECT
  RecipeUUID,
  RecipeUniqueID,
  Recipe,
  RecipePrimaryOutputInternalID,
  RecipeAlternativeNumber,
  RecipeVersionNumber,
  RecipeCreatedByUser,
  RecipeCreationDateTime,
  RecipeLastChangedByUser,
  RecipeLastChangeDateTime,
  RecipeType,
  RecipePurpose,
  RecipeStatus,
  _RecipeStatusText.StsActnMgmtStatusText AS StsActnMgmtStatusText,
  RecipeStatusSchema,
  RcpFmlaUUID,
  RecipeProcessUUID,
  RecipePropertySpecInternalID,
  RecipeChangeNumber,
  RecipeIsDeleted,
  RecipeIsArchived,
  RecipeValidityStartDate,
  RecipeValidityEndDate,
  RecipeValidityMinQuantity,
  RecipeValidityMaxQuantity,
  RecipeValidityUnit,
  RecipeAuthorizationGroup
FROM I_Recipe
LEFT OUTER JOIN I_SpecificationForKeyDate AS _PrimaryOutputSpecification ON RecipePrimaryOutputInternalID = _PrimaryOutputSpecification.SpecificationInternalID  -- association [0..1]
LEFT OUTER JOIN I_RecipeFormulaItemForKeyDate AS _FormulaForKeyDate ON RcpFmlaUUID = _FormulaForKeyDate.RcpFmlaUUID  -- association [1..*]
LEFT OUTER JOIN I_RecipeProcessEquipRqmt AS _RecipeProcessEquipRqmt ON RecipeUUID = _RecipeProcessEquipRqmt.RecipeUUID  -- association [0..*]
LEFT OUTER JOIN I_RecipeProcessElementBasic AS _RecipeProcessElementBasic ON RecipeUUID = _RecipeProcessElementBasic.RecipeUUID  -- association [0..*]
LEFT OUTER JOIN I_RecipeProcessParamValue AS _RecipeProcessParamValue ON RecipeUUID = _RecipeProcessParamValue.RecipeUUID  -- association [0..*]
LEFT OUTER JOIN I_RecipeFormulaItemForKeyDate AS _PrimOutputFormulaForKeyDate ON RcpFmlaUUID = _PrimOutputFormulaForKeyDate.RcpFmlaUUID AND _PrimOutputFormulaForKeyDate.RcpFmlaItemType = 'PO'  -- association [1..*]
LEFT OUTER JOIN I_RecipeFormulaItemForKeyDate AS _InputFormulaForKeyDate ON RcpFmlaUUID = _InputFormulaForKeyDate.RcpFmlaUUID AND _InputFormulaForKeyDate.RcpFmlaItemType = 'IN'  -- association [0..*]
LEFT OUTER JOIN I_RecipeFormulaItemForKeyDate AS _OutputStreamFormulaForKeyDate ON RcpFmlaUUID = _OutputStreamFormulaForKeyDate.RcpFmlaUUID AND _OutputStreamFormulaForKeyDate.RcpFmlaItemType = 'OS'  -- association [0..*]
LEFT OUTER JOIN I_RecipeFormulaItemForKeyDate AS _SecOutputFormulaForKeyDate ON RcpFmlaUUID = _SecOutputFormulaForKeyDate.RcpFmlaUUID AND _SecOutputFormulaForKeyDate.RcpFmlaItemType = 'SO'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectClassForKeyDate AS _ClfnObjectClassForKeyDate ON RecipeUniqueID = _ClfnObjectClassForKeyDate.ClfnObjectID AND _ClfnObjectClassForKeyDate.ClfnObjectTable = '/PLMB/RCP_RECIPE'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectCharcValForKeyDate AS _ClfnObjectCharcValForKeyDate ON RecipeUniqueID = _ClfnObjectCharcValForKeyDate.ClfnObjectID AND _ClfnObjectCharcValForKeyDate.ClfnObjectTable = '/PLMB/RCP_RECIPE'  -- association [0..*]
LEFT OUTER JOIN E_Recipe AS _Extension ON RecipeUUID = _Extension.RecipeUUID  -- association [1..1]
;