ESH_N_RECIPE_INT

DDL: ESH_N_RECIPE_INT SQL: ESH_L_RECIPE_INT Type: view Package: BSESH_PLM_WUI_RCP_RCP
65 Fields 1 Data Sources

Anchor view -RECIPE_INT

ESH_N_RECIPE_INT is a CDS View that provides data about "Anchor view -RECIPE_INT" in SAP S/4HANA. It reads from 1 data source (I_RECIPEFORKEYDATE) and exposes 65 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 #P 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_INT view

Fields (65)

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
LOGACCMOBJECTTYPE _LOGACCMOBJSECUREIDASSGMT LOGACCMOBJECTTYPE
LOGACCMOBJECTTYPEISACTIVE _LOGACCMOBJECTTYPEACTIVE LOGACCMOBJECTTYPEISACTIVE
LOGACCMUSERAUTHZNOBJECT _LOGACCMOBJECTUSERAUTHZN LOGACCMUSERAUTHZNOBJECT
SECONDARYOUTPUTMATERIAL
OUTPUTSTREAMMATERIAL
MATERIAL
INPUTMATERIAL
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
INPUTFORMULASPECIFICATION
SECOUTPUTFORMULASPECIFICATION
STREAMOUTPUTSPECIFICATION
SPECIFICATION
SPECIFICATIONAUTHZNGROUP
SPECIFICATIONTYPE
STSACTNMGMTSTATUSTEXT
LASTCHANGEDBYUSERDESC _LASTCHANGEDBYUSER USERDESCRIPTION Full Name
USERDESCRIPTION _CREATEDBYUSER 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_INT.
-- 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_INT
-- Parameters: P_Language : abap.lang, P_KEYDATE : SYDATE

CREATE VIEW ESH_N_RECIPE_INT 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,
  _LOGACCMOBJSECUREIDASSGMT.LOGACCMOBJECTTYPE AS LOGACCMOBJECTTYPE,
  _LOGACCMOBJECTTYPEACTIVE.LOGACCMOBJECTTYPEISACTIVE AS LOGACCMOBJECTTYPEISACTIVE,
  _LOGACCMOBJECTUSERAUTHZN.LOGACCMUSERAUTHZNOBJECT AS LOGACCMUSERAUTHZNOBJECT,
  _SECOUTPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).MATERIAL AS SECONDARYOUTPUTMATERIAL,
  _OUTPUTSTREAMFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).MATERIAL AS OUTPUTSTREAMMATERIAL,
  _PRIMOUTPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).MATERIAL AS MATERIAL,
  _INPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).MATERIAL AS INPUTMATERIAL,
  _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,
  _INPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._SPECIFICATIONFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATION AS INPUTFORMULASPECIFICATION,
  _SECOUTPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._SPECIFICATIONFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATION AS SECOUTPUTFORMULASPECIFICATION,
  _OUTPUTSTREAMFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._SPECIFICATIONFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATION AS STREAMOUTPUTSPECIFICATION,
  _PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATION AS SPECIFICATION,
  _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,
  _LASTCHANGEDBYUSER.USERDESCRIPTION AS LASTCHANGEDBYUSERDESC,
  _CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION
FROM I_RECIPEFORKEYDATE
;

Learn More