P_RecipeHeaderAnalysis

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 P_RecipeHeaderAnalysis.
-- 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: PRCPHDRANLYS
-- Parameters: P_KeyDate : sydate

CREATE VIEW P_RecipeHeaderAnalysis AS
SELECT
  finder_cache.RecipeFinderCacheUUID AS RecipeFinderCacheUUID,
  recipe.RecipeUUID AS RecipeUUID,
  recipe.RecipeUniqueID AS RecipeUniqueID,
  recipe.Recipe AS Recipe,
  recipe.RecipePrimaryOutputInternalID AS RecipePrimaryOutputInternalID,
  recipe.RecipeAlternativeNumber AS RecipeAlternativeNumber,
  recipe.RecipeVersionNumber AS RecipeVersionNumber,
  recipe.RecipeCreatedByUser AS RecipeCreatedByUser,
  recipe.RecipeCreationDateTime AS RecipeCreationDateTime,
  recipe.RecipeLastChangedByUser AS RecipeLastChangedByUser,
  recipe.RecipeLastChangeDateTime AS RecipeLastChangeDateTime,
  recipe.RecipeType AS RecipeType,
  recipe.RecipePurpose AS RecipePurpose,
  recipe.RecipeStatus AS RecipeStatus,
  recipe.RecipeStatusSchema AS RecipeStatusSchema,
  recipe.RcpFmlaUUID AS RcpFmlaUUID,
  recipe.RecipeProcessUUID AS RecipeProcessUUID,
  recipe.RecipePropertySpecInternalID AS RecipePropertySpecInternalID,
  recipe.RecipeIsDeleted AS RecipeIsDeleted,
  recipe.RecipeIsArchived AS RecipeIsArchived,
  recipe.RecipeValidityStartDate AS RecipeValidityStartDate,
  recipe.RecipeValidityEndDate AS RecipeValidityEndDate,
  recipe.RecipeValidityMinQuantity AS RecipeValidityMinQuantity,
  recipe.RecipeValidityMaxQuantity AS RecipeValidityMaxQuantity,
  recipe.RecipeValidityUnit AS RecipeValidityUnit,
  recipe.RecipeAuthorizationGroup AS RecipeAuthorizationGroup,
  recipe.RcpFmlaItemUUID AS RcpFmlaItemUUID,
  recipe.RcpFmlaItemType AS RcpFmlaItemType,
  recipe.RecipeFmlaItemAltvIsUsed AS RecipeFmlaItemAltvIsUsed,
  recipe.RecipePrimOutpSpecType AS RecipePrimOutpSpecType,
  recipe.Material AS Material,
  recipe.RecipePrimaryOutputMaterial AS RecipePrimaryOutputMaterial,
  recipe.RecipePrimOutputMaterialName AS RecipePrimOutputMaterialName,
  recipe.RecipePrimOutpSubstNatr AS RecipePrimOutpSubstNatr,
  recipe.RecipePrimOutpSubstNatrDesc AS RecipePrimOutpSubstNatrDesc,
  recipe._AuthorizationGroup AS _AuthorizationGroup,
  recipe._CreatedByUser AS _CreatedByUser,
  recipe._FormulaForKeyDate AS _FormulaForKeyDate,
  recipe._LastChangedByUser AS _LastChangedByUser,
  recipe._LogAccMObjectTypeActive AS _LogAccMObjectTypeActive,
  recipe._LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn,
  recipe._LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt,
  recipe._Plant AS _Plant,
  recipe._PrimaryOutputSpecification AS _PrimaryOutputSpecification,
  recipe._RecipeDescription AS _RecipeDescription,
  recipe._RecipePOMaterialText AS _RecipePOMaterialText,
  recipe._RecipePurpose AS _RecipePurpose,
  recipe._RecipeStatus AS _RecipeStatus,
  recipe._RecipeType AS _RecipeType
FROM I_RcpWhereUsedAnlysForKeyDate
INNER JOIN R_RecipeWithPrimaryOutput ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): R_RecipeWithPrimaryOutput
;