ESH_N_RECIPE

DDL: ESH_N_RECIPE SQL: ESH_L_RECIPE Type: view Package: BSESH_PLM_WUI_RCP_RCP
68 Fields 1 Data Sources

Anchor view -RECIPE

ESH_N_RECIPE is a CDS View that provides data about "Anchor view -RECIPE" in SAP S/4HANA. It reads from 1 data source (I_RECIPEFORKEYDATE) and exposes 68 fields with key field RECIPEUUID. Part of development package BSESH_PLM_WUI_RCP_RCP.

Data Sources (1)

SourceAliasJoin Type
I_RECIPEFORKEYDATE I_RECIPEFORKEYDATE from

Parameters (2)

NameTypeDefault
P_Language abap.lang
P_KEYDATE SYDATE

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ESH_L_RECIPE view

Fields (68)

KeyFieldSource TableSource FieldDescription
KEY RECIPEUUID RECIPEUUID Recipe GUID
CHARACTERISTIC
CHARCDESCRIPTION
CHARCFROMAMOUNT
CHARCFROMDATE
CHARCFROMDECIMALVALUE
CHARCFROMTIME
CHARCTOAMOUNT
CHARCTODATE
CHARCTODECIMALVALUE
CHARCTOTIME
CHARCVALUE
CHARCVALUEDESCRIPTION
CLASS
CLASSINTERNALID
CLASSKEYWORDTEXT
CLASSTYPE
CURRENCY
DOCUMENTINFORECORDDOCNUMBER _RECIPEDOCINFORECORDOBJECTLINK DOCUMENTINFORECORDDOCNUMBER Document
LOGACCMCONTEXT
PRIMOUTPLOGACCMOBJECTTYPE
LOGACCMOBJECTTYPE _LOGACCMOBJSECUREIDASSGMT LOGACCMOBJECTTYPE
PRIMOUTPLOGACCMOBJTYPEISACTV
LOGACCMOBJECTTYPEISACTIVE _LOGACCMOBJECTTYPEACTIVE LOGACCMOBJECTTYPEISACTIVE
PRIMOUTPLOGACCMUSERAUTHZNOBJ
LOGACCMUSERAUTHZNOBJECT _LOGACCMOBJECTUSERAUTHZN LOGACCMUSERAUTHZNOBJECT
INPUTMATERIAL
MATERIAL
OUTPUTSTREAMMATERIAL
SECONDARYOUTPUTMATERIAL
PLAINLONGTEXT
PLANT _PLANT PLANT Valuation Area
RECIPE RECIPE
RECIPEALTERNATIVENUMBER RECIPEALTERNATIVENUMBER
RECIPEAUTHORIZATIONGROUP RECIPEAUTHORIZATIONGROUP
RECIPECHANGENUMBER RECIPECHANGENUMBER
RECIPECREATEDBYUSER RECIPECREATEDBYUSER
RECIPECREATIONDATETIME RECIPECREATIONDATETIME
RECIPEDESCRIPTION
RECIPEISARCHIVED RECIPEISARCHIVED
RECIPEISDELETED RECIPEISDELETED
RECIPELASTCHANGEDATETIME RECIPELASTCHANGEDATETIME
RECIPELASTCHANGEDBYUSER RECIPELASTCHANGEDBYUSER
RECIPEPROCESSELEMENTDESC
RECIPEPROCESSEQUIPRQMTDESC
RECIPEPROCESSPARAM
RECIPEPROCESSPARAMDESC
RECIPEPROCESSPARAMTGTVAL _RECIPEPROCESSPARAMVALUE RECIPEPROCESSPARAMTGTVAL
RECIPEPROCESSPARAMVALUEDESC
RECIPEPURPOSE RECIPEPURPOSE
RECIPESTATUS RECIPESTATUS
RECIPETYPE RECIPETYPE
RECIPETYPEDESCRIPTION
RECIPEVALIDITYENDDATE RECIPEVALIDITYENDDATE
RECIPEVALIDITYMAXQUANTITY RECIPEVALIDITYMAXQUANTITY
RECIPEVALIDITYMINQUANTITY RECIPEVALIDITYMINQUANTITY
RECIPEVALIDITYSTARTDATE RECIPEVALIDITYSTARTDATE
RECIPEVALIDITYUNIT RECIPEVALIDITYUNIT
RECIPEVERSIONNUMBER RECIPEVERSIONNUMBER
SPECIFICATION
STREAMOUTPUTSPECIFICATION
SECOUTPUTFORMULASPECIFICATION
INPUTFORMULASPECIFICATION
SPECIFICATIONAUTHZNGROUP
SPECIFICATIONTYPE
STSACTNMGMTSTATUSTEXT
USERDESCRIPTION _CREATEDBYUSER USERDESCRIPTION Full Name
LASTCHANGEDBYUSERDESC _LASTCHANGEDBYUSER USERDESCRIPTION Full Name

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 ESH_N_RECIPE.
-- 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: ESH_L_RECIPE
-- Parameters: P_Language : abap.lang, P_KEYDATE : SYDATE

CREATE VIEW ESH_N_RECIPE AS
SELECT
  RECIPEUUID,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTIC(P_KEYDATE : $parameters. P_KEYDATE).CHARACTERISTIC AS CHARACTERISTIC,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTIC(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTICDESC(P_KEYDATE : $parameters. P_KEYDATE)[1: Language = $parameters. P_Language].CHARCDESCRIPTION AS CHARCDESCRIPTION,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCFROMAMOUNT AS CHARCFROMAMOUNT,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCFROMDATE AS CHARCFROMDATE,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCFROMDECIMALVALUE AS CHARCFROMDECIMALVALUE,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCFROMTIME AS CHARCFROMTIME,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCTOAMOUNT AS CHARCTOAMOUNT,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCTODATE AS CHARCTODATE,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCTODECIMALVALUE AS CHARCTODECIMALVALUE,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCTOTIME AS CHARCTOTIME,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCVALUE AS CHARCVALUE,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTIC(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTICVALUE(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTICVALUEDESC(P_KEYDATE : $parameters. P_KEYDATE)[1: Language = $parameters. P_Language].CHARCVALUEDESCRIPTION AS CHARCVALUEDESCRIPTION,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CLASS(P_KEYDATE : $parameters. P_KEYDATE).CLASS AS CLASS,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CLASSINTERNALID AS CLASSINTERNALID,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CLASS(P_KEYDATE : $parameters. P_KEYDATE)._CLASSKEYWORD(P_KEYDATE : $parameters. P_KEYDATE)[1: LANGUAGE = $parameters. P_Language].CLASSKEYWORDTEXT AS CLASSKEYWORDTEXT,
  _CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CLASSTYPE AS CLASSTYPE,
  _CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CURRENCY AS CURRENCY,
  _RECIPEDOCINFORECORDOBJECTLINK.DOCUMENTINFORECORDDOCNUMBER AS DOCUMENTINFORECORDDOCNUMBER,
  _LOGACCMOBJSECUREIDASSGMT._LOGACCMSECUREIDREPOSITORY._LOGACCMCONTEXT.LOGACCMCONTEXT AS LOGACCMCONTEXT,
  _PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE)._LOGACCMOBJSECUREIDASSGMT.LOGACCMOBJECTTYPE AS PRIMOUTPLOGACCMOBJECTTYPE,
  _LOGACCMOBJSECUREIDASSGMT.LOGACCMOBJECTTYPE AS LOGACCMOBJECTTYPE,
  _PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE)._LOGACCMOBJECTTYPEACTIVE.LOGACCMOBJECTTYPEISACTIVE AS PRIMOUTPLOGACCMOBJTYPEISACTV,
  _LOGACCMOBJECTTYPEACTIVE.LOGACCMOBJECTTYPEISACTIVE AS LOGACCMOBJECTTYPEISACTIVE,
  _PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE)._LOGACCMOBJECTUSERAUTHZN.LOGACCMUSERAUTHZNOBJECT AS PRIMOUTPLOGACCMUSERAUTHZNOBJ,
  _LOGACCMOBJECTUSERAUTHZN.LOGACCMUSERAUTHZNOBJECT AS LOGACCMUSERAUTHZNOBJECT,
  _INPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).MATERIAL AS INPUTMATERIAL,
  _PRIMOUTPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).MATERIAL AS MATERIAL,
  _OUTPUTSTREAMFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).MATERIAL AS OUTPUTSTREAMMATERIAL,
  _SECOUTPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).MATERIAL AS SECONDARYOUTPUTMATERIAL,
  _TEXTOBJECTPLAINLONGTEXT[1: Language = $parameters. P_Language].PLAINLONGTEXT AS PLAINLONGTEXT,
  _PLANT.PLANT AS PLANT,
  RECIPE,
  RECIPEALTERNATIVENUMBER,
  RECIPEAUTHORIZATIONGROUP,
  RECIPECHANGENUMBER,
  RECIPECREATEDBYUSER,
  RECIPECREATIONDATETIME,
  _RECIPEDESCRIPTION[1: Language = $parameters. P_Language].RECIPEDESCRIPTION AS RECIPEDESCRIPTION,
  RECIPEISARCHIVED,
  RECIPEISDELETED,
  RECIPELASTCHANGEDATETIME,
  RECIPELASTCHANGEDBYUSER,
  _RECIPEPROCESSELEMENTBASIC._RECIPEPROCESSELEMENTTEXT[1: Language = $parameters. P_Language].RECIPEPROCESSELEMENTDESC AS RECIPEPROCESSELEMENTDESC,
  _RECIPEPROCESSEQUIPRQMT._RECIPEPROCESSEQUIPRQMTDESC[1: Language = $parameters. P_Language].RECIPEPROCESSEQUIPRQMTDESC AS RECIPEPROCESSEQUIPRQMTDESC,
  _RECIPEPROCESSPARAMVALUE._RECIPEPROCESSPARAM.RECIPEPROCESSPARAM AS RECIPEPROCESSPARAM,
  _RECIPEPROCESSPARAMVALUE._RECIPEPROCESSPARAM._RECIPEPROCESSPARAMDESC[1: Language = $parameters. P_Language].RECIPEPROCESSPARAMDESC AS RECIPEPROCESSPARAMDESC,
  _RECIPEPROCESSPARAMVALUE.RECIPEPROCESSPARAMTGTVAL AS RECIPEPROCESSPARAMTGTVAL,
  _RECIPEPROCESSPARAMVALUE._RECIPEPROCESSPARAMVALUEDESC[1: Language = $parameters. P_Language].RECIPEPROCESSPARAMVALUEDESC AS RECIPEPROCESSPARAMVALUEDESC,
  RECIPEPURPOSE,
  RECIPESTATUS,
  RECIPETYPE,
  _RECIPETYPE._RECIPETYPETEXT[1: Language = $parameters. P_Language].RECIPETYPEDESCRIPTION AS RECIPETYPEDESCRIPTION,
  RECIPEVALIDITYENDDATE,
  RECIPEVALIDITYMAXQUANTITY,
  RECIPEVALIDITYMINQUANTITY,
  RECIPEVALIDITYSTARTDATE,
  RECIPEVALIDITYUNIT,
  RECIPEVERSIONNUMBER,
  _PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATION AS SPECIFICATION,
  _OUTPUTSTREAMFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._SPECIFICATIONFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATION AS STREAMOUTPUTSPECIFICATION,
  _SECOUTPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._SPECIFICATIONFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATION AS SECOUTPUTFORMULASPECIFICATION,
  _INPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._SPECIFICATIONFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATION AS INPUTFORMULASPECIFICATION,
  _PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATIONAUTHZNGROUP AS SPECIFICATIONAUTHZNGROUP,
  _PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATIONTYPE AS SPECIFICATIONTYPE,
  _RECIPESTATUSTEXT[1: LANGUAGE = $parameters. P_Language].STSACTNMGMTSTATUSTEXT AS STSACTNMGMTSTATUSTEXT,
  _CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION,
  _LASTCHANGEDBYUSER.USERDESCRIPTION AS LASTCHANGEDBYUSERDESC
FROM I_RECIPEFORKEYDATE
;

Learn More