ESH_N_EWM_PROD

DDL: ESH_N_EWM_PROD SQL: ESH_L_EWM_PROD Type: view
32 Fields 1 Data Sources

ESH_N_EWM_PROD is a CDS View in SAP S/4HANA. It reads from 1 data source (I_EWM_PRODUCTSEARCHMODEL) and exposes 32 fields with key fields BUSINESSPARTNERUUID, PRODUCTUUID, SUPPLYCHAINUNITUUID.

Data Sources (1)

SourceAliasJoin Type
I_EWM_PRODUCTSEARCHMODEL I_EWM_PRODUCTSEARCHMODEL from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY 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.preserveKey true view
AbapCatalog.sqlViewName ESH_L_EWM_PROD view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY BUSINESSPARTNERUUID BUSINESSPARTNERUUID UUID
KEY PRODUCTUUID PRODUCTUUID UUID
KEY SUPPLYCHAINUNITUUID SUPPLYCHAINUNITUUID SC Unit GUID
BUSINESSPARTNER BUSINESSPARTNER Issuing Authority
BUSINESSPARTNERNAME _BUSINESSPARTNER BUSINESSPARTNERNAME Extracted Customer Name
EWMPHYSINVENTORYCOUNTINGCYCLE EWMPHYSINVENTORYCOUNTINGCYCLE Cyc. Coun. Ind.
EWMPTWYCONTROLSTRATEGY EWMPTWYCONTROLSTRATEGY Putaway Control
EWMPTWYCONTROLSTRATEGYTEXT
EWMSTKREMOVALCTRLSTRATEGYTEXT
EWMSTOCKREMOVALCONTROLSTRATEGY EWMSTOCKREMOVALCONTROLSTRATEGY Stock Removal Ctrl
ISBUSINESSPURPOSECOMPLETED ISBUSINESSPURPOSECOMPLETED Purpose Completed
MATERIALTYPENAME
PRODUCT PRODUCT Product Sold
PRODUCTBASEUNIT PRODUCTBASEUNIT Valuation Unit
PRODUCTBULKSTORAGEMETHOD PRODUCTBULKSTORAGEMETHOD Bulk Storage
PRODUCTBULKSTORAGEMETHODTEXT
PRODUCTEXTERNALID PRODUCTEXTERNALID Material
PRODUCTGROSSWEIGHT PRODUCTGROSSWEIGHT Gross Weight
PRODUCTGROUP PRODUCTGROUP Product Sold Group
PRODUCTGROUPNAME
PRODUCTNAME
PRODUCTNETWEIGHT PRODUCTNETWEIGHT Net Weight
PRODUCTTYPE PRODUCTTYPE Product Type Group
PRODUCTVOLUME PRODUCTVOLUME Volume
UNITOFMEASURELONGNAME
VOLUMEUNITOFMEASUREEXTERNAL
WEIGHTUNITOFMEASUREEXTERNAL
BASEUNITOFMEASUREEXTERNAL
VOLUMEUNIT VOLUMEUNIT Volume Unit
WAREHOUSE WAREHOUSE Warehouse No.
WAREHOUSENAME
WEIGHTUNIT WEIGHTUNIT Weight unit

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

CREATE VIEW ESH_N_EWM_PROD AS
SELECT
  BUSINESSPARTNERUUID,
  PRODUCTUUID,
  SUPPLYCHAINUNITUUID,
  BUSINESSPARTNER,
  _BUSINESSPARTNER.BUSINESSPARTNERNAME AS BUSINESSPARTNERNAME,
  EWMPHYSINVENTORYCOUNTINGCYCLE,
  EWMPTWYCONTROLSTRATEGY,
  _PUTAWAYCTRLSTRATEGYTEXT[1: LANGUAGE = $parameters. P_Language].EWMPTWYCONTROLSTRATEGYTEXT AS EWMPTWYCONTROLSTRATEGYTEXT,
  _STOCKREMOVALCTRLSTRATEGYTEXT[1: LANGUAGE = $parameters. P_Language].EWMSTKREMOVALCTRLSTRATEGYTEXT AS EWMSTKREMOVALCTRLSTRATEGYTEXT,
  EWMSTOCKREMOVALCONTROLSTRATEGY,
  ISBUSINESSPURPOSECOMPLETED,
  _PRODUCTTYPETEXT[1: LANGUAGE = $parameters. P_Language].MATERIALTYPENAME AS MATERIALTYPENAME,
  PRODUCT,
  PRODUCTBASEUNIT,
  PRODUCTBULKSTORAGEMETHOD,
  _PRODUCTBULKSTORAGEMETHODTEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTBULKSTORAGEMETHODTEXT AS PRODUCTBULKSTORAGEMETHODTEXT,
  PRODUCTEXTERNALID,
  PRODUCTGROSSWEIGHT,
  PRODUCTGROUP,
  _PRODUCTGROUPTEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTGROUPNAME AS PRODUCTGROUPNAME,
  _PRODUCTTEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTNAME AS PRODUCTNAME,
  PRODUCTNETWEIGHT,
  PRODUCTTYPE,
  PRODUCTVOLUME,
  _BASEUNITOFMEASURETEXT[1: LANGUAGE = $parameters. P_Language].UNITOFMEASURELONGNAME AS UNITOFMEASURELONGNAME,
  _VOLUMEUNITOFMEASURETEXT[1: LANGUAGE = $parameters. P_Language].UNITOFMEASURE_E AS VOLUMEUNITOFMEASUREEXTERNAL,
  _WEIGHTUNITOFMEASURETEXT[1: LANGUAGE = $parameters. P_Language].UNITOFMEASURE_E AS WEIGHTUNITOFMEASUREEXTERNAL,
  _BASEUNITOFMEASURETEXT[1: LANGUAGE = $parameters. P_Language].UNITOFMEASURE_E AS BASEUNITOFMEASUREEXTERNAL,
  VOLUMEUNIT,
  WAREHOUSE,
  _WAREHOUSETEXT[1: LANGUAGE = $parameters. P_Language].WAREHOUSENAME AS WAREHOUSENAME,
  WEIGHTUNIT
FROM I_EWM_PRODUCTSEARCHMODEL
;

Learn More