E_ProdEWMWrhsStorageType

DDL: E_PRODEWMWRHSSTORAGETYPE SQL: EPRDEWMWRHSSTOR Type: view EXTENSION
5 Fields 1 Data Sources

Product EWM Storage - Extension

E_ProdEWMWrhsStorageType is a Extension CDS View that provides data about "Product EWM Storage - Extension" in SAP S/4HANA. It reads from 1 data source (/sapapo/matlwhst) and exposes 5 fields with key fields SupplyChainUnitUUID, ProdSupChnMgmtUUID22, BusinessPartnerUUID, EWMStorageType.

Data Sources (1)

SourceAliasJoin Type
/sapapo/matlwhst Persistence from

Annotations (9)

NameValueLevelField
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName EPRDEWMWRHSSTOR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #EXTENSION view
EndUserText.label Product EWM Storage - Extension view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY SupplyChainUnitUUID /sapapo/matlwhst scuguid SC Unit GUID
KEY ProdSupChnMgmtUUID22 /sapapo/matlwhst matid Product ID
KEY BusinessPartnerUUID /sapapo/matlwhst entitled_id Ent. to Dispose
KEY EWMStorageType /sapapo/matlwhst lgtyp Storage Type
IsActiveEntity

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 E_ProdEWMWrhsStorageType.
-- 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: EPRDEWMWRHSSTOR

CREATE VIEW E_ProdEWMWrhsStorageType AS
SELECT
  Persistence.scuguid AS SupplyChainUnitUUID,
  Persistence.matid AS ProdSupChnMgmtUUID22,
  Persistence.entitled_id AS BusinessPartnerUUID,
  Persistence.lgtyp AS EWMStorageType,
  cast( 'X' as sdraft_is_active preserving type ) AS IsActiveEntity
FROM /sapapo/matlwhst AS Persistence
;

Learn More