C_RecipeAnalysis

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 C_RecipeAnalysis.
-- 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: CRCPANALYSIS
-- Parameters: P_KeyDate : sydate

CREATE VIEW C_RecipeAnalysis AS
SELECT
  finder_cache.RecipeFinderCacheUUID AS RecipeFinderCacheUUID,
  finder_cache.RecipeFinderCacheLineUUID AS RecipeFinderCacheLineUUID,
  finder_cache.RecipeUUID AS RecipeUUID,
  finder_cache.SourceRecipeUUID AS SourceRecipeUUID,
  rcp.RecipeUniqueID AS RecipeUniqueID,
  rcp._RecipeDescription[1:Language = $session.system_language].RecipeDescription AS RecipeDescription,
  rcp.Recipe AS Recipe,
  rcp.RecipeType AS RecipeType,
  rcp.RecipeStatus AS RecipeStatus,
  rcp.RecipeAuthorizationGroup AS RecipeAuthorizationGroup,
  cast( coalesce( rcp._Plant.Plant, '' ) as /plmb/werks_d ) AS Plant,
  rcp.RecipePurpose AS RecipePurpose,
  rcp.RecipeCreatedByUser AS RecipeCreatedByUser,
  rcp._CreatedByUser.UserDescription AS CreatedByUserName,
  rcp.RecipeLastChangedByUser AS RecipeLastChangedByUser,
  rcp._LastChangedByUser.UserDescription AS LastChangedByUserName,
  rcp.RecipeValidityStartDate AS RecipeValidityStartDate,
  rcp.RecipeValidityEndDate AS RecipeValidityEndDate,
  rcp.RecipePrimaryOutputInternalID AS RecipePrimaryOutputInternalID,
  cast(rcp._PrimaryOutputSpecification(P_KeyDate:$parameters.P_KeyDate).Specification as /plmb/rcp_prim_output_id preserving type ) AS RecipePrimaryOutput,
  cast(_PrimaryOutputIdentifier( P_KeyDate : $parameters.P_KeyDate).SpecIdfgDescText as /plmb/rcp_prim_output_text preserving type ) AS RecipePrimaryOutputDesc,
  rcp.RecipeVersionNumber AS RecipeVersionNumber,
  rcp.RecipeAlternativeNumber AS RecipeAlternativeNumber,
  finder_cache.Material AS Material,
  finder_cache.Specification AS Specification,
  finder_cache.SpecificationInternalID AS SpecificationInternalID,
  finder_cache.RecipeFinderSearchItem AS RecipeFinderSearchItem,
  cast( coalesce( _Product._Text[Language=$session.system_language].ProductDescription, _Identifier( P_KeyDate : $parameters.P_KeyDate).SpecIdfgDescText ) as /plmb/rca_calc_item_desc preserving type) AS RecipeFinderSearchItemDesc,
  cast(finder_cache.RecipeWhereUsedResultQtyInPct as /plmb/rca_srch_item_total_per preserving type ) AS RcpWhereUsedResultTotQtyInPct,
  cast(finder_cache._RecipeFinderSrchItmIsUsdAs._Text[Language = $session.system_language].RecipeFinderSrchItmIsUsdAsDesc as /plmb/rca_srch_itm_occrnc_desc) AS RecipeFinderSrchItmIsUsdAsDesc,
  cast(1 as /plmb/rca_number_of_recipes) AS NumberOfRecipes,
  RecipePrimaryOutputMaterial,
  RecipePrimOutputMaterialName,
  RecipePrimOutpSubstNatr,
  RecipePrimOutpSubstNatrDesc,
  RecipePrimOutpSpecType,
  rcp._PrimaryOutputSpecification AS _PrimaryOutputSpecification,
  rcp._LogAccMObjectTypeActive AS _LogAccMObjectTypeActive,
  rcp._LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn,
  rcp._LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt,
  cast(srcrcp.Recipe as /plmb/source_rcp_id) AS SourceRecipe,
  cast(srcrcp._RecipeDescription[Language = $session.system_language].RecipeDescription as /plmb/source_rcp_desc) AS SourceRecipeDescription
FROM I_RcpWhereUsedAnlysForKeyDate
INNER JOIN R_RecipeWithPrimaryOutput ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_RecipeFinderPlantValueHelp AS _PlantVH ON Plant = _PlantVH.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductVH AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_SpecIdfrBscForKeyDate AS _Identifier ON SpecificationInternalID = _Identifier.SpecificationInternalID  -- association [0..1]
LEFT OUTER JOIN I_SpecIdfrBscForKeyDate AS _PrimaryOutputIdentifier ON RecipePrimaryOutputInternalID = _PrimaryOutputIdentifier.SpecificationInternalID  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _RcpValidityStartDate ON rcp.RecipeValidityStartDate = _RcpValidityStartDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _RecipeValidityEndDate ON rcp.RecipeValidityEndDate = _RecipeValidityEndDate.CalendarDate  -- association [0..1]
LEFT OUTER JOIN I_RecipeTypeText AS _RecipeTypeText ON RecipeType = _RecipeTypeText.RecipeType  -- association [0..*]
LEFT OUTER JOIN I_RecipeStatusText AS _RecipeStatusText ON RecipeStatus = _RecipeStatusText.RecipeStatus  -- association [0..*]
LEFT OUTER JOIN I_RecipeAuthorizationGroupText AS _RecipeAuthorizationGroupText ON RecipeAuthorizationGroup = _RecipeAuthorizationGroupText.RecipeAuthorizationGroup  -- association [0..*]
LEFT OUTER JOIN I_RecipePurposeText AS _RecipePurposeText ON RecipePurpose = _RecipePurposeText.RecipePurpose  -- association [0..*]
LEFT OUTER JOIN I_SpecTypeText AS _RecipePOSpecTypeText ON RecipePrimOutpSpecType = _RecipePOSpecTypeText.SpecificationType  -- association [0..*]
LEFT OUTER JOIN C_RecipeIngredientMaterialVH AS _RecipePOMaterialVH ON RecipePrimaryOutputMaterial = _RecipePOMaterialVH.RecipeIngredientMaterial  -- association [0..1]
LEFT OUTER JOIN C_RecipePrimOutputSpecTypeVH AS _RecipePrimOutputSpecTypeVH ON RecipePrimOutpSpecType = _RecipePrimOutputSpecTypeVH.SpecificationType  -- association [0..1]
LEFT OUTER JOIN E_Recipe AS _Extension ON RecipeUUID = _Extension.RecipeUUID  -- association [1..1]
;