C_CmmdtyTotalStockOnHandDEX

DDL: C_CMMDTYTOTALSTOCKONHANDDEX Type: view_entity CONSUMPTION
31 Fields 1 Data Sources 1 Associations

Extractor for Commodity Total Stock On Hand

C_CmmdtyTotalStockOnHandDEX is a Consumption CDS View (Fact) that provides data about "Extractor for Commodity Total Stock On Hand" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyTotalStockOnHand) and exposes 31 fields with key fields PricingKey, VersStockRecordUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyTotalStockOnHand I_CmmdtyTotalStockOnHand from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SAPClient clnt clnt.LogicalSystem is null or clnt.LogicalSystem is not null

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Extractor for Commodity Total Stock On Hand view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.dataCategory #FACT view
ObjectModel.modelingPattern #ANALYTICAL_FACT view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY PricingKey PricingKey Pricing Key
KEY VersStockRecordUUID VersStockRecordUUID XML Vers.
SourceLogicalSystem
EndOfDayBusinessEntityKey EndOfDayBusinessEntityKey Node Key
RecordSelectionCutoffDateTime RecordSelectionCutoffDateTime
CreatedOnDateTime CreatedOnDateTime Created On
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
Material Material Vehicle Model
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
PhysicalCommodity PhysicalCommodity Commodity Code
DataSourceType DataSourceType Type of Data Record
QuantitySign QuantitySign Sign of Quantity
CommodityQuantityInBaseUnit CommodityQuantityInBaseUnit Qty Base UoM
MaterialBaseUnit MaterialBaseUnit Valuation Unit
CommodityQuantity CommodityQuantity Commodity Quantity
CommodityUnit CommodityUnit Order Unit
CommodityReferenceQuantityUnit CommodityReferenceQuantityUnit Ref. UoM
CommodityQuantityInMassUnit CommodityQuantityInMassUnit Quantity in Mass UoM
CommodityMassUnit CommodityMassUnit Cmdty UoM
CommodityQuantityInVolumeUnit CommodityQuantityInVolumeUnit Quantity in Vol UoM
CommodityVolumeUnit CommodityVolumeUnit Cmdty UoM
InventoryEventIdentifier InventoryEventIdentifier Type of Event
QualityRepositoryUUID QualityRepositoryUUID QRep GUID
QualityRepositoryVersion QualityRepositoryVersion QRep Version
DiscPremQualityScheduleUUID DiscPremQualityScheduleUUID Schedule GUID
NetQuantityInBaseUnit NetQuantityInBaseUnit
NetQuantityInCommodityUnit NetQuantityInCommodityUnit Cmdty Quantity
NetQuantityInMassUnit NetQuantityInMassUnit Cmdty Quantity
NetQuantityInVolumeUnit NetQuantityInVolumeUnit

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_CmmdtyTotalStockOnHandDEX.
-- 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.

CREATE VIEW C_CmmdtyTotalStockOnHandDEX AS
SELECT
  PricingKey,
  VersStockRecordUUID,
  cast( clnt.LogicalSystem as logsys preserving type ) AS SourceLogicalSystem,
  EndOfDayBusinessEntityKey,
  RecordSelectionCutoffDateTime,
  CreatedOnDateTime,
  CompanyCode,
  Plant,
  Material,
  StorageLocation,
  Batch,
  PhysicalCommodity,
  DataSourceType,
  QuantitySign,
  CommodityQuantityInBaseUnit,
  MaterialBaseUnit,
  CommodityQuantity,
  CommodityUnit,
  CommodityReferenceQuantityUnit,
  CommodityQuantityInMassUnit,
  CommodityMassUnit,
  CommodityQuantityInVolumeUnit,
  CommodityVolumeUnit,
  InventoryEventIdentifier,
  QualityRepositoryUUID,
  QualityRepositoryVersion,
  DiscPremQualityScheduleUUID,
  NetQuantityInBaseUnit,
  NetQuantityInCommodityUnit,
  NetQuantityInMassUnit,
  NetQuantityInVolumeUnit
FROM I_CmmdtyTotalStockOnHand
LEFT OUTER JOIN I_SAPClient AS clnt ON /* condition not available in parsed metadata */  -- association [0..1]
;

Learn More