C_ProdEWMWrhsStorageType

DDL: C_PRODEWMWRHSSTORAGETYPE SQL: CPRODEWMSTOR Type: view CONSUMPTION
45 Fields 1 Data Sources 2 Associations

Consumption view for Product EWM Storage

C_ProdEWMWrhsStorageType is a Consumption CDS View that provides data about "Consumption view for Product EWM Storage" in SAP S/4HANA. It reads from 1 data source (I_ProdEWMWrhsStorageTypeTP) and exposes 45 fields with key fields Product, Warehouse, BusinessPartner, StorageType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProdEWMWrhsStorageTypeTP WrhsStorageType from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_Product _Product $projection.Product = _Product.Product
[1..1] C_ProdEWMWarehouse _ProdEWMWarehouse $projection.Product = _ProdEWMWarehouse.Product and $projection.Warehouse = _ProdEWMWarehouse.Warehouse and $projection.BusinessPartner = _ProdEWMWarehouse.BusinessPartner

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CPRODEWMSTOR view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption view for Product EWM Storage view
Search.searchable true view
VDM.viewType #CONSUMPTION view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.text.control #ASSOCIATED_TEXT_UI_HIDDEN view
AccessControl.personalData.blocking #REQUIRED view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProdEWMWrhsStorageTypeTP Product Product Sold
KEY Warehouse I_ProdEWMWrhsStorageTypeTP Warehouse Warehouse No.
KEY BusinessPartner I_ProdEWMWrhsStorageTypeTP BusinessPartner Issuing Authority
KEY StorageType I_ProdEWMWrhsStorageTypeTP StorageType Storage Type
StorageTypeForEdit I_ProdEWMWrhsStorageTypeTP StorageTypeForEdit Storage Type
WarehouseForEdit I_ProdEWMWrhsStorageTypeTP WarehouseForEdit Warehouse No.
EWMStorageSectionMethod I_ProdEWMWrhsStorageTypeTP EWMStorageSectionMethod
StorageBinType I_ProdEWMWrhsStorageTypeTP StorageBinType
EWMStorageBinSearchRule I_ProdEWMWrhsStorageTypeTP EWMStorageBinSearchRule
EWMMaximumNumberOfBins I_ProdEWMWrhsStorageTypeTP EWMMaximumNumberOfBins
EWMSpltPtwyThresholdInPercent I_ProdEWMWrhsStorageTypeTP EWMSpltPtwyThresholdInPercent
EWMPtwySequence I_ProdEWMWrhsStorageTypeTP EWMPtwySequence
EWMProdQuantityClassification I_ProdEWMWrhsStorageTypeTP EWMProdQuantityClassification
EWMProdPtwyQtyClassification I_ProdEWMWrhsStorageTypeTP EWMProdPtwyQtyClassification
EWMProdIsSplitOnPtwy I_ProdEWMWrhsStorageTypeTP EWMProdIsSplitOnPtwy
EWMProdIsSkippedOnPtwy I_ProdEWMWrhsStorageTypeTP EWMProdIsSkippedOnPtwy
EWMHasNoReplenishment I_ProdEWMWrhsStorageTypeTP EWMHasNoReplenishment
EWMMinReplnmtQuantity I_ProdEWMWrhsStorageTypeTP EWMMinReplnmtQuantity
EWMMinReplnmtQuantityUnit I_ProdEWMWrhsStorageTypeTP EWMMinReplnmtQuantityUnit
EWMMinimumStorageQuantity I_ProdEWMWrhsStorageTypeTP EWMMinimumStorageQuantity
EWMMinimumStorageQuantityUnit I_ProdEWMWrhsStorageTypeTP EWMMinimumStorageQuantityUnit
EWMMaximumStorageQuantity I_ProdEWMWrhsStorageTypeTP EWMMaximumStorageQuantity
EWMMaximumStorageQuantityUnit I_ProdEWMWrhsStorageTypeTP EWMMaximumStorageQuantityUnit
EWMMinStorQtyOfMaxStorQtyInPct I_ProdEWMWrhsStorageTypeTP EWMMinStorQtyOfMaxStorQtyInPct
EWMSpltPtwyThresholdUnit
EWMMinStorQtyOfMaxStorQtyUnit
_Product _Product
_ProdEWMWarehouse _ProdEWMWarehouse
_EWMPtwyQtyClassificationText _EWMPtwyQtyClassificationText
_EWMPtwyQtyClassification _EWMPtwyQtyClassification
_EWMQtyClassificationText _EWMQtyClassificationText
_EWMQtyClassification _EWMQtyClassification
_ProdEWMStorageBinTypeText _ProdEWMStorageBinTypeText
_ProdEWMStorageBinType _ProdEWMStorageBinType
_ProdEWMPtwyStorSectionText _ProdEWMPtwyStorSectionText
_ProdEWMPtwyStorSection _ProdEWMPtwyStorSection
_ProdEWMStorageTypeText _ProdEWMStorageTypeText
_EWMMinReplnmtQuantityUnit _EWMMinReplnmtQuantityUnit
_EWMMinReplnmtQuantityUnitText _EWMMinReplnmtQuantityUnitText
_EWMMinStorageQuantityUnit _EWMMinStorageQuantityUnit
_EWMMinStorageQuantityUnitText _EWMMinStorageQuantityUnitText
_EWMMaxStorageQuantityUnit _EWMMaxStorageQuantityUnit
_EWMMaxStorageQuantityUnitText _EWMMaxStorageQuantityUnitText
_ProdEWMStorBinSrchRule _ProdEWMStorBinSrchRule
_ProdEWMStorBinSrchRuleText _ProdEWMStorBinSrchRuleText

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 C_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: CPRODEWMSTOR

CREATE VIEW C_ProdEWMWrhsStorageType AS
SELECT
  WrhsStorageType.Product AS Product,
  WrhsStorageType.Warehouse AS Warehouse,
  WrhsStorageType.BusinessPartner AS BusinessPartner,
  WrhsStorageType.StorageType AS StorageType,
  WrhsStorageType.StorageTypeForEdit AS StorageTypeForEdit,
  WrhsStorageType.WarehouseForEdit AS WarehouseForEdit,
  WrhsStorageType.EWMStorageSectionMethod AS EWMStorageSectionMethod,
  WrhsStorageType.StorageBinType AS StorageBinType,
  WrhsStorageType.EWMStorageBinSearchRule AS EWMStorageBinSearchRule,
  WrhsStorageType.EWMMaximumNumberOfBins AS EWMMaximumNumberOfBins,
  WrhsStorageType.EWMSpltPtwyThresholdInPercent AS EWMSpltPtwyThresholdInPercent,
  WrhsStorageType.EWMPtwySequence AS EWMPtwySequence,
  WrhsStorageType.EWMProdQuantityClassification AS EWMProdQuantityClassification,
  WrhsStorageType.EWMProdPtwyQtyClassification AS EWMProdPtwyQtyClassification,
  WrhsStorageType.EWMProdIsSplitOnPtwy AS EWMProdIsSplitOnPtwy,
  WrhsStorageType.EWMProdIsSkippedOnPtwy AS EWMProdIsSkippedOnPtwy,
  WrhsStorageType.EWMHasNoReplenishment AS EWMHasNoReplenishment,
  WrhsStorageType.EWMMinReplnmtQuantity AS EWMMinReplnmtQuantity,
  WrhsStorageType.EWMMinReplnmtQuantityUnit AS EWMMinReplnmtQuantityUnit,
  WrhsStorageType.EWMMinimumStorageQuantity AS EWMMinimumStorageQuantity,
  WrhsStorageType.EWMMinimumStorageQuantityUnit AS EWMMinimumStorageQuantityUnit,
  WrhsStorageType.EWMMaximumStorageQuantity AS EWMMaximumStorageQuantity,
  WrhsStorageType.EWMMaximumStorageQuantityUnit AS EWMMaximumStorageQuantityUnit,
  WrhsStorageType.EWMMinStorQtyOfMaxStorQtyInPct AS EWMMinStorQtyOfMaxStorQtyInPct,
  cast( '' as msehi ) AS EWMSpltPtwyThresholdUnit,
  cast( '' as msehi ) AS EWMMinStorQtyOfMaxStorQtyUnit
FROM I_ProdEWMWrhsStorageTypeTP AS WrhsStorageType
LEFT OUTER JOIN C_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN C_ProdEWMWarehouse AS _ProdEWMWarehouse ON Product = _ProdEWMWarehouse.Product AND Warehouse = _ProdEWMWarehouse.Warehouse AND BusinessPartner = _ProdEWMWarehouse.BusinessPartner  -- association [1..1]
;

Learn More