ESH_S_SPEC_INT

DDL: ESH_S_SPEC_INT SQL: ESH_U_SPEC_INT Type: view Package: BSESH_PLM_WUI_SPE
49 Fields 1 Data Sources

Search view -SPEC_INT

ESH_S_SPEC_INT is a CDS View that provides data about "Search view -SPEC_INT" in SAP S/4HANA. It reads from 1 data source (ESH_N_SPEC_INT) and exposes 49 fields. Part of development package BSESH_PLM_WUI_SPE.

Data Sources (1)

SourceAliasJoin Type
ESH_N_SPEC_INT ESH_N_SPEC_INT from

Parameters (2)

NameTypeDefault
P_Language abap.lang
P_KEYDATE SYDATE

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
EnterpriseSearch.hidden true view
UI.headerInfo.typeName Specification_Internal view
UI.headerInfo.typeNamePlural Specifications_Internal view
Consumption.semanticObject Specification view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value SPECIFICATION view
AbapCatalog.sqlViewName ESH_U_SPEC_INT view

Fields (49)

KeyFieldSource TableSource FieldDescription
DOCUMENTINFORECORDDOCNUMBER DOCUMENTINFORECORDDOCNUMBER Document
DOCUMENTINFORECORDDOCPART DOCUMENTINFORECORDDOCPART Document Part
DOCUMENTINFORECORDDOCTYPE DOCUMENTINFORECORDDOCTYPE Document Type
DOCUMENTINFORECORDDOCVERSION DOCUMENTINFORECORDDOCVERSION Doc. Version
EACHSPECUSAGEISINHERITED EACHSPECUSAGEISINHERITED
INHTDSPECIDFGDESCISPERMCHGD INHTDSPECIDFGDESCISPERMCHGD
INHTDSPECIDFGDESCISTMPCHGD INHTDSPECIDFGDESCISTMPCHGD
LOGACCMCONTEXT LOGACCMCONTEXT Owning Context
LOGACCMOBJECTTYPE LOGACCMOBJECTTYPE
LOGACCMOBJECTTYPEISACTIVE LOGACCMOBJECTTYPEISACTIVE
LOGACCMUSERAUTHZNOBJECT LOGACCMUSERAUTHZNOBJECT
MATERIAL MATERIAL Assigned Material
PLAINLONGTEXT PLAINLONGTEXT Long Text
PLANT PLANT Valuation Area
RCPFMLAITEMTYPE RCPFMLAITEMTYPE
RCPFMLAITEMUUID RCPFMLAITEMUUID
RCPFMLAUUID RCPFMLAUUID
SPECIDFGDESCCATEGORY SPECIDFGDESCCATEGORY
SPECIDFGDESCLANGUAGE SPECIDFGDESCLANGUAGE
SPECIDFGDESCTEXT SPECIDFGDESCTEXT
SPECIDFGDESCTYPE SPECIDFGDESCTYPE
ORIGSPECIDFGUSAGEISACTIVE ORIGSPECIDFGUSAGEISACTIVE
SPECIDFGUSAGEISACTIVE SPECIDFGUSAGEISACTIVE
ORIGSPECIDFGUSAGEISEXCLUDED ORIGSPECIDFGUSAGEISEXCLUDED
SPECIDFGUSAGEISEXCLUDED SPECIDFGUSAGEISEXCLUDED
ORIGSPECIDFGUSAGEISRELEVANT ORIGSPECIDFGUSAGEISRELEVANT
SPECIDFGUSAGEISRELEVANT SPECIDFGUSAGEISRELEVANT
SPECIFICATION SPECIFICATION Specification
SPECIFICATIONAUTHZNGROUP SPECIFICATIONAUTHZNGROUP
SPECIFICATIONAUTHZNGROUPDESC SPECIFICATIONAUTHZNGROUPDESC
SPECIFICATIONCATEGORY SPECIFICATIONCATEGORY
SPECIFICATIONCHANGENUMBER SPECIFICATIONCHANGENUMBER
SPECIFICATIONCREATIONDATE SPECIFICATIONCREATIONDATE
SPECIFICATIONHEADERSTATUS SPECIFICATIONHEADERSTATUS
SPECIFICATIONHEADERSTATUSDESC SPECIFICATIONHEADERSTATUSDESC
SPECIFICATIONINTERNALID SPECIFICATIONINTERNALID Specification
ORIGSPECIFICATIONRATING ORIGSPECIFICATIONRATING
SPECIFICATIONRATING SPECIFICATIONRATING Rating
SPECIFICATIONSUBSTANCENATR SPECIFICATIONSUBSTANCENATR
SPECIFICATIONTYPE SPECIFICATIONTYPE
SPECIFICATIONTYPEDESCRIPTION SPECIFICATIONTYPEDESCRIPTION
SPECINHTNCTEMPLATEVALIDITYAREA SPECINHTNCTEMPLATEVALIDITYAREA
ORIGSPECIFICATIONVALIDITYAREA ORIGSPECIFICATIONVALIDITYAREA
SPECIFICATIONVALIDITYAREA SPECIFICATIONVALIDITYAREA Validity Area
SPECIFICATIONVALIDITYENDDATE SPECIFICATIONVALIDITYENDDATE Valid to
SPECIFICATIONVALIDITYSTARTDATE SPECIFICATIONVALIDITYSTARTDATE Valid from
SPECINHERITANCETEMPLATE SPECINHERITANCETEMPLATE
SPECIFICATIONCREATEDBYNAME SPECIFICATIONCREATEDBYNAME Created By Name
SPECIFICATIONCREATEDBYUSER SPECIFICATIONCREATEDBYUSER Created By

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

CREATE VIEW ESH_S_SPEC_INT AS
SELECT
  DOCUMENTINFORECORDDOCNUMBER,
  DOCUMENTINFORECORDDOCPART,
  DOCUMENTINFORECORDDOCTYPE,
  DOCUMENTINFORECORDDOCVERSION,
  EACHSPECUSAGEISINHERITED,
  INHTDSPECIDFGDESCISPERMCHGD,
  INHTDSPECIDFGDESCISTMPCHGD,
  LOGACCMCONTEXT,
  LOGACCMOBJECTTYPE,
  LOGACCMOBJECTTYPEISACTIVE,
  LOGACCMUSERAUTHZNOBJECT,
  MATERIAL,
  PLAINLONGTEXT,
  PLANT,
  RCPFMLAITEMTYPE,
  RCPFMLAITEMUUID,
  RCPFMLAUUID,
  SPECIDFGDESCCATEGORY,
  SPECIDFGDESCLANGUAGE,
  SPECIDFGDESCTEXT,
  SPECIDFGDESCTYPE,
  ORIGSPECIDFGUSAGEISACTIVE,
  SPECIDFGUSAGEISACTIVE,
  ORIGSPECIDFGUSAGEISEXCLUDED,
  SPECIDFGUSAGEISEXCLUDED,
  ORIGSPECIDFGUSAGEISRELEVANT,
  SPECIDFGUSAGEISRELEVANT,
  SPECIFICATION,
  SPECIFICATIONAUTHZNGROUP,
  SPECIFICATIONAUTHZNGROUPDESC,
  SPECIFICATIONCATEGORY,
  SPECIFICATIONCHANGENUMBER,
  SPECIFICATIONCREATIONDATE,
  SPECIFICATIONHEADERSTATUS,
  SPECIFICATIONHEADERSTATUSDESC,
  SPECIFICATIONINTERNALID,
  ORIGSPECIFICATIONRATING,
  SPECIFICATIONRATING,
  SPECIFICATIONSUBSTANCENATR,
  SPECIFICATIONTYPE,
  SPECIFICATIONTYPEDESCRIPTION,
  SPECINHTNCTEMPLATEVALIDITYAREA,
  ORIGSPECIFICATIONVALIDITYAREA,
  SPECIFICATIONVALIDITYAREA,
  SPECIFICATIONVALIDITYENDDATE,
  SPECIFICATIONVALIDITYSTARTDATE,
  SPECINHERITANCETEMPLATE,
  SPECIFICATIONCREATEDBYNAME,
  SPECIFICATIONCREATEDBYUSER
FROM ESH_N_SPEC_INT
;

Learn More