Which tables does ESH_N_RECIPE use?

ESH_N_RECIPE reads from 1 data source(s): I_RECIPEFORKEYDATE.

How many fields does ESH_N_RECIPE have?

ESH_N_RECIPE has 68 fields. Key fields: RECIPEUUID.

ESH_N_RECIPE

DDL: ESH_N_RECIPE SQL: ESH_L_RECIPE Type: view

ESH_N_RECIPE is a CDS View in SAP S/4HANA. It reads from 1 data source (I_RECIPEFORKEYDATE) and exposes 68 fields with key field RECIPEUUID.

Data Sources (1)

Source	Alias	Join Type
I_RECIPEFORKEYDATE	I_RECIPEFORKEYDATE	from

Parameters (2)

Name	Type	Default
P_Language	abap.lang
P_KEYDATE	SYDATE

Annotations (7)

Name	Value	Level
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.sqlViewName	ESH_L_RECIPE	view

Fields (68)

Key	Field	Source Table	Source Field
KEY	RECIPEUUID		RECIPEUUID
	CHARACTERISTIC
	CHARCDESCRIPTION
	CHARCFROMAMOUNT
	CHARCFROMDATE
	CHARCFROMDECIMALVALUE
	CHARCFROMTIME
	CHARCTOAMOUNT
	CHARCTODATE
	CHARCTODECIMALVALUE
	CHARCTOTIME
	CHARCVALUE
	CHARCVALUEDESCRIPTION
	CLASS
	CLASSINTERNALID
	CLASSKEYWORDTEXT
	CLASSTYPE
	CURRENCY
	DOCUMENTINFORECORDDOCNUMBER	_RECIPEDOCINFORECORDOBJECTLINK	DOCUMENTINFORECORDDOCNUMBER
	LOGACCMCONTEXT
	LOGACCMOBJECTTYPE	_LOGACCMOBJSECUREIDASSGMT	LOGACCMOBJECTTYPE
	PRIMOUTPLOGACCMOBJECTTYPE
	LOGACCMOBJECTTYPEISACTIVE	_LOGACCMOBJECTTYPEACTIVE	LOGACCMOBJECTTYPEISACTIVE
	PRIMOUTPLOGACCMOBJTYPEISACTV
	LOGACCMUSERAUTHZNOBJECT	_LOGACCMOBJECTUSERAUTHZN	LOGACCMUSERAUTHZNOBJECT
	PRIMOUTPLOGACCMUSERAUTHZNOBJ
	SECONDARYOUTPUTMATERIAL
	OUTPUTSTREAMMATERIAL
	MATERIAL
	INPUTMATERIAL
	PLAINLONGTEXT
	PLANT	_PLANT	PLANT
	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
	USERDESCRIPTION	_CREATEDBYUSER	USERDESCRIPTION

@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'ESH_L_RECIPE'
define view ESH_N_RECIPE
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang,
@CONSUMPTION.HIDDEN: true
@ENVIRONMENT.SYSTEMFIELD: #SYSTEM_DATE
P_KEYDATE: SYDATE
as select from I_RECIPEFORKEYDATE( P_KEYDATE: $parameters.P_KEYDATE ) {

key RECIPEUUID,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CHARACTERISTIC(P_KEYDATE : $parameters. P_KEYDATE).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,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCFROMAMOUNT,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCFROMDATE,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCFROMDECIMALVALUE,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCFROMTIME,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCTOAMOUNT,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCTODATE,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCTODECIMALVALUE,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CHARCTOTIME,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).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,

_CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._CLASS(P_KEYDATE : $parameters. P_KEYDATE).CLASS,

_CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).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,

_CLFNOBJECTCLASSFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CLASSTYPE,

_CLFNOBJECTCHARCVALFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).CURRENCY,

_RECIPEDOCINFORECORDOBJECTLINK.DOCUMENTINFORECORDDOCNUMBER,

_LOGACCMOBJSECUREIDASSGMT._LOGACCMSECUREIDREPOSITORY._LOGACCMCONTEXT.LOGACCMCONTEXT,

_LOGACCMOBJSECUREIDASSGMT.LOGACCMOBJECTTYPE,

_PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE)._LOGACCMOBJSECUREIDASSGMT.LOGACCMOBJECTTYPE as PRIMOUTPLOGACCMOBJECTTYPE,

_LOGACCMOBJECTTYPEACTIVE.LOGACCMOBJECTTYPEISACTIVE,

_PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE)._LOGACCMOBJECTTYPEACTIVE.LOGACCMOBJECTTYPEISACTIVE as PRIMOUTPLOGACCMOBJTYPEISACTV,

_LOGACCMOBJECTUSERAUTHZN.LOGACCMUSERAUTHZNOBJECT,

_PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE)._LOGACCMOBJECTUSERAUTHZN.LOGACCMUSERAUTHZNOBJECT as PRIMOUTPLOGACCMUSERAUTHZNOBJ,

_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,

_INPUTFORMULAFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).MATERIAL as INPUTMATERIAL,

_TEXTOBJECTPLAINLONGTEXT[1: Language = $parameters. P_Language].PLAINLONGTEXT,

_PLANT.PLANT,

RECIPE,

RECIPEALTERNATIVENUMBER,

RECIPEAUTHORIZATIONGROUP,

RECIPECHANGENUMBER,

RECIPECREATEDBYUSER,

RECIPECREATIONDATETIME,

_RECIPEDESCRIPTION[1: Language = $parameters. P_Language].RECIPEDESCRIPTION,

RECIPEISARCHIVED,

RECIPEISDELETED,

RECIPELASTCHANGEDATETIME,

RECIPELASTCHANGEDBYUSER,

_RECIPEPROCESSELEMENTBASIC._RECIPEPROCESSELEMENTTEXT[1: Language = $parameters. P_Language].RECIPEPROCESSELEMENTDESC,

_RECIPEPROCESSEQUIPRQMT._RECIPEPROCESSEQUIPRQMTDESC[1: Language = $parameters. P_Language].RECIPEPROCESSEQUIPRQMTDESC,

_RECIPEPROCESSPARAMVALUE._RECIPEPROCESSPARAM.RECIPEPROCESSPARAM,

_RECIPEPROCESSPARAMVALUE._RECIPEPROCESSPARAM._RECIPEPROCESSPARAMDESC[1: Language = $parameters. P_Language].RECIPEPROCESSPARAMDESC,

_RECIPEPROCESSPARAMVALUE.RECIPEPROCESSPARAMTGTVAL,

_RECIPEPROCESSPARAMVALUE._RECIPEPROCESSPARAMVALUEDESC[1: Language = $parameters. P_Language].RECIPEPROCESSPARAMVALUEDESC,

RECIPEPURPOSE,

RECIPESTATUS,

RECIPETYPE,

_RECIPETYPE._RECIPETYPETEXT[1: Language = $parameters. P_Language].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,

_PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATIONAUTHZNGROUP,

_PRIMARYOUTPUTSPECIFICATION(P_KEYDATE : $parameters. P_KEYDATE).SPECIFICATIONTYPE,

_RECIPESTATUSTEXT[1: LANGUAGE = $parameters. P_Language].STSACTNMGMTSTATUSTEXT,

_LASTCHANGEDBYUSER.USERDESCRIPTION as LASTCHANGEDBYUSERDESC,

_CREATEDBYUSER.USERDESCRIPTION
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARACTERISTICFORKEYDATE",
"I_CLFNCHARCDESCFORKEYDATE",
"I_CLFNCHARCVALUEDESCFORKEYDATE",
"I_CLFNCHARCVALUEFORKEYDATE",
"I_CLFNCLASSFORKEYDATE",
"I_CLFNCLASSKEYWORDFORKEYDATE",
"I_CLFNOBJECTCHARCVALFORKEYDATE",
"I_CLFNOBJECTCLASSFORKEYDATE",
"I_DOCUMENTINFORECORDOBJECTLINK",
"I_LOGACCMCONTEXT",
"I_LOGACCMOBJECTTYPEACTIVE",
"I_LOGACCMOBJECTUSERAUTHZN",
"I_LOGACCMOBJSECUREIDASSGMT",
"I_LOGACCMSECUREIDREPOSITORY",
"I_RECIPEASSGDPLANT",
"I_RECIPEFORKEYDATE",
"I_RECIPEFORMULAITEMFORKEYDATE",
"I_RECIPEPROCESSELEMENTBASIC",
"I_RECIPEPROCESSELEMENTTEXT",
"I_RECIPEPROCESSEQUIPRQMT",
"I_RECIPEPROCESSEQUIPRQMTTEXT",
"I_RECIPEPROCESSPARAM",
"I_RECIPEPROCESSPARAMTEXT",
"I_RECIPEPROCESSPARAMVALUE",
"I_RECIPEPROCESSPARAMVALUETEXT",
"I_RECIPETEXT",
"I_RECIPETYPE",
"I_RECIPETYPETEXT",
"I_SPECIFICATIONFORKEYDATE",
"I_STSACTNMGMTSTATUSTEXT",
"I_TEXTOBJECTPLAINLONGTEXT",
"I_USER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

ESH_N_RECIPE view

I_RecipeForKeyDate view

ESH_S_RECIPE view