ESH_N_SITE

DDL: ESH_N_SITE SQL: ESH_L_SITE Type: view Package: RFM_SITE_ESH
20 Fields 1 Data Sources 1 Associations

Anchor view -SITE

ESH_N_SITE is a CDS View that provides data about "Anchor view -SITE" in SAP S/4HANA. It reads from 1 data source (I_SITE) and exposes 20 fields with key field SITE. It has 1 association to related views. Part of development package RFM_SITE_ESH.

Data Sources (1)

SourceAliasJoin Type
I_SITE I_SITE from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] dd07t _SITECATEGORY $projection.SiteCategory=_SITECATEGORY.domvalue_l and _SITECATEGORY.domname='VLFKZ' and _SITECATEGORY.as4local='A'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_SITE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SITE SITE Plant
CITYNAME _ADDRESS CITYNAME Name
COUNTRY
COUNTRYNAME
DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL RefDistCh-Cust/Mat.
DISTRIBUTIONCHANNELNAME
POSTALCODE _ADDRESS POSTALCODE Postal Code
PURCHASING_ORGANIZATION _DEFAULTPURCHASINGORGANIZATION PURCHASINGORGANIZATION Purchasing Organization
PURCHASING_ORGANIZATION_NAME _DEFAULTPURCHASINGORGANIZATION PURCHASINGORGANIZATIONNAME Purch. Org. Name
REGION
SALESORGANIZATION SALESORGANIZATION Sales Organization
SALESORGANIZATIONNAME
SITEBLOCKINGFROMDATE _SITEBLOCKING SITEBLOCKINGFROMDATE
SITEBLOCKINGREASON _SITEBLOCKING SITEBLOCKINGREASON
SITEBLOCKINGTODATE _SITEBLOCKING SITEBLOCKINGTODATE
SITECATEGORY SITECATEGORY
SITECATEGORYNAME
SITECUSTOMER SITECUSTOMER
SITENAME SITENAME
SUPPLIER _SUPPLIER SUPPLIER Supplier

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_SITE.
-- 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_SITE
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_SITE AS
SELECT
  SITE,
  _ADDRESS.CITYNAME AS CITYNAME,
  _ADDRESS._COUNTRY.COUNTRY AS COUNTRY,
  _ADDRESS._COUNTRY._TEXT[1: LANGUAGE = $parameters. P_Language].COUNTRYNAME AS COUNTRYNAME,
  DISTRIBUTIONCHANNEL,
  _DISTRIBUTIONCHANNEL._TEXT[1: LANGUAGE = $parameters. P_Language].DISTRIBUTIONCHANNELNAME AS DISTRIBUTIONCHANNELNAME,
  _ADDRESS.POSTALCODE AS POSTALCODE,
  _DEFAULTPURCHASINGORGANIZATION.PURCHASINGORGANIZATION AS PURCHASING_ORGANIZATION,
  _DEFAULTPURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS PURCHASING_ORGANIZATION_NAME,
  _ADDRESS._REGION.REGION AS REGION,
  SALESORGANIZATION,
  _SALESORGANIZATION._TEXT[1: LANGUAGE = $parameters. P_Language].SALESORGANIZATIONNAME AS SALESORGANIZATIONNAME,
  _SITEBLOCKING.SITEBLOCKINGFROMDATE AS SITEBLOCKINGFROMDATE,
  _SITEBLOCKING.SITEBLOCKINGREASON AS SITEBLOCKINGREASON,
  _SITEBLOCKING.SITEBLOCKINGTODATE AS SITEBLOCKINGTODATE,
  SITECATEGORY,
  _SITECATEGORY[1: ddlanguage = $parameters. P_Language].ddtext AS SITECATEGORYNAME,
  SITECUSTOMER,
  SITENAME,
  _SUPPLIER.SUPPLIER AS SUPPLIER
FROM I_SITE
LEFT OUTER JOIN dd07t AS _SITECATEGORY ON SiteCategory=_SITECATEGORY.domvalue_l AND _SITECATEGORY.domname='VLFKZ' AND _SITECATEGORY.as4local='A'  -- association [0..*]
;

Learn More