ESH_N_SPECIFICATION

DDL: ESH_N_SPECIFICATION SQL: ESH_L_SPEC Type: view
30 Fields 1 Data Sources 1 Associations

ESH_N_SPECIFICATION is a CDS View in SAP S/4HANA. It reads from 1 data source (I_SPECIFICATIONFORKEYDATE) and exposes 30 fields with key field SPECIFICATIONINTERNALID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SPECIFICATIONFORKEYDATE I_SPECIFICATIONFORKEYDATE from

Parameters (2)

NameTypeDefault
P_Language abap.lang
P_KEYDATE SYDATE

Associations (1)

CardinalityTargetAliasCondition
[0..1] N_SPECASSIGNEDHEADERSTATUS _ASSIGNEDHEADERSTATUS $projection.SpecificationInternalID=_ASSIGNEDHEADERSTATUS.SpecificationInternalID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A 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_SPEC view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SPECIFICATIONINTERNALID SPECIFICATIONINTERNALID Specification
DOCUMENTINFORECORDDOCNUMBER _DOCUMENTINFORECORDOBJECTLINK DOCUMENTINFORECORDDOCNUMBER Document
LOGACCMCONTEXT
LOGACCMOBJECTTYPE _LOGACCMOBJSECUREIDASSGMT LOGACCMOBJECTTYPE
LOGACCMOBJECTTYPEISACTIVE _LOGACCMOBJECTTYPEACTIVE LOGACCMOBJECTTYPEISACTIVE
LOGACCMUSERAUTHZNOBJECT _LOGACCMOBJECTUSERAUTHZN LOGACCMUSERAUTHZNOBJECT
MATERIAL _SPECASSIGNEDMATERIAL MATERIAL Vehicle Model
PLAINLONGTEXT
RCPFMLAITEMTYPE _RECIPEFORMULAITEM RCPFMLAITEMTYPE
RCPFMLAITEMUUID _RECIPEFORMULAITEM RCPFMLAITEMUUID
RCPFMLAUUID _RECIPEFORMULAITEM RCPFMLAUUID
SPECIDFGDESCCATEGORY
SPECIDFGDESCLANGUAGE
SPECIDFGDESCTEXT
SPECIDFGDESCTYPE
SPECIFICATION SPECIFICATION Specification
SPECIFICATIONAUTHZNGROUP SPECIFICATIONAUTHZNGROUP
SPECIFICATIONAUTHZNGROUPDESC
SPECIFICATIONCATEGORY
SPECIFICATIONCHANGENUMBER SPECIFICATIONCHANGENUMBER
SPECIFICATIONCREATIONDATE SPECIFICATIONCREATIONDATE
SPECIFICATIONHEADERSTATUS
SPECIFICATIONHEADERSTATUSDESC
SPECIFICATIONSUBSTANCENATR SPECIFICATIONSUBSTANCENATR
SPECIFICATIONTYPE SPECIFICATIONTYPE
SPECIFICATIONTYPEDESCRIPTION
SPECIFICATIONVALIDITYENDDATE SPECIFICATIONVALIDITYENDDATE
SPECIFICATIONVALIDITYSTARTDATE SPECIFICATIONVALIDITYSTARTDATE
SPECIFICATIONCREATEDBYNAME _CREATEDBYUSER USERDESCRIPTION Full Name
SPECIFICATIONCREATEDBYUSER _CREATEDBYUSER USERID User 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_SPECIFICATION.
-- 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_SPEC
-- Parameters: P_Language : abap.lang, P_KEYDATE : SYDATE

CREATE VIEW ESH_N_SPECIFICATION AS
SELECT
  SPECIFICATIONINTERNALID,
  _DOCUMENTINFORECORDOBJECTLINK.DOCUMENTINFORECORDDOCNUMBER AS DOCUMENTINFORECORDDOCNUMBER,
  _LOGACCMOBJSECUREIDASSGMT._LOGACCMSECUREIDREPOSITORY._LOGACCMCONTEXT.LOGACCMCONTEXT AS LOGACCMCONTEXT,
  _LOGACCMOBJSECUREIDASSGMT.LOGACCMOBJECTTYPE AS LOGACCMOBJECTTYPE,
  _LOGACCMOBJECTTYPEACTIVE.LOGACCMOBJECTTYPEISACTIVE AS LOGACCMOBJECTTYPEISACTIVE,
  _LOGACCMOBJECTUSERAUTHZN.LOGACCMUSERAUTHZNOBJECT AS LOGACCMUSERAUTHZNOBJECT,
  _SPECASSIGNEDMATERIAL.MATERIAL AS MATERIAL,
  _SPECIDENTIFIERFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE)._SPECIDENTIFIERLONGTEXT._TEXTOBJECTPLAINLONGTEXT[1: Language = $parameters. P_Language].PLAINLONGTEXT AS PLAINLONGTEXT,
  _RECIPEFORMULAITEM.RCPFMLAITEMTYPE AS RCPFMLAITEMTYPE,
  _RECIPEFORMULAITEM.RCPFMLAITEMUUID AS RCPFMLAITEMUUID,
  _RECIPEFORMULAITEM.RCPFMLAUUID AS RCPFMLAUUID,
  _SPECIDENTIFIERFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIDFGDESCCATEGORY AS SPECIDFGDESCCATEGORY,
  _SPECIDENTIFIERFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIDFGDESCLANGUAGE AS SPECIDFGDESCLANGUAGE,
  _SPECIDENTIFIERFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIDFGDESCTEXT AS SPECIDFGDESCTEXT,
  _SPECIDENTIFIERFORKEYDATE(P_KEYDATE : $parameters. P_KEYDATE).SPECIDFGDESCTYPE AS SPECIDFGDESCTYPE,
  SPECIFICATION,
  SPECIFICATIONAUTHZNGROUP,
  _SPECIFICATIONAUTHGROUP._SPECIFICATIONAUTHGROUPTEXT[1: Language = $parameters. P_Language].SPECIFICATIONAUTHZNGROUPDESC AS SPECIFICATIONAUTHZNGROUPDESC,
  _SPECIFICATIONTYPE._ASSIGNEDCATEGORY.SPECIFICATIONCATEGORY AS SPECIFICATIONCATEGORY,
  SPECIFICATIONCHANGENUMBER,
  SPECIFICATIONCREATIONDATE,
  _ASSIGNEDHEADERSTATUS[1: Language = $parameters. P_Language].SPECIFICATIONHEADERSTATUS AS SPECIFICATIONHEADERSTATUS,
  _ASSIGNEDHEADERSTATUS[1: Language = $parameters. P_Language].SPECIFICATIONHEADERSTATUSDESC AS SPECIFICATIONHEADERSTATUSDESC,
  SPECIFICATIONSUBSTANCENATR,
  SPECIFICATIONTYPE,
  _SPECIFICATIONTYPE._SPECIFICATIONTYPETEXT[1: Language = $parameters. P_Language].SPECIFICATIONTYPEDESCRIPTION AS SPECIFICATIONTYPEDESCRIPTION,
  SPECIFICATIONVALIDITYENDDATE,
  SPECIFICATIONVALIDITYSTARTDATE,
  _CREATEDBYUSER.USERDESCRIPTION AS SPECIFICATIONCREATEDBYNAME,
  _CREATEDBYUSER.USERID AS SPECIFICATIONCREATEDBYUSER
FROM I_SPECIFICATIONFORKEYDATE
LEFT OUTER JOIN N_SPECASSIGNEDHEADERSTATUS AS _ASSIGNEDHEADERSTATUS ON SpecificationInternalID=_ASSIGNEDHEADERSTATUS.SpecificationInternalID  -- association [0..1]
;

Learn More