I_MatlStkAtKeyDateInAltUoM

DDL: I_MATLSTKATKEYDATEINALTUOM Type: view_entity COMPOSITE Package: MM_IM_VDM_STOCK
34 Fields 1 Data Sources 10 Associations

Stock At Key Date In Alternative UoM

I_MatlStkAtKeyDateInAltUoM (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Supply Chain

I_MatlStkAtKeyDateInAltUoM is a Composite CDS View (Cube) that provides data about "Stock At Key Date In Alternative UoM" in SAP S/4HANA. It reads from 1 data source (P_MatlStkAtKeyDateInAltUoM) and exposes 34 fields with key fields Product, Plant, StorageLocation, Batch, Supplier. It has 10 associations to related views. Part of development package MM_IM_VDM_STOCK.

SAP Help Documentation

CategoryCDS Views for Stock and Material Documents
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business question: Which quantity in alternative unit of measure (AUoM) of a material was available at a certain date?

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table above. In this role, the following restriction types must be set to read access: You have configured the currency conversion rates to use the value in reporting currency. You have the authorizations to access the required plants.

Structure
Object types This view is built on the following object type: Material Stock (business objects) Main CDS parameters and filters The main CDS parameter is: P_KeyDate used to define the date for which the stock quantity in alternative unit of measure will be returned. The main filters are: Product Plant StorageLocation Batch Supplier used to the define the supplier for which stock has been posted SDDocument used to define the SD order for which stock has been posted SDDocumentItem used to define the SD order item for which stock has been posted WBSElementInternalID used to define the WBS element for which stock has been posted Customer used to the define the customer for which stock has been posted InventoryStockType to define the stock type InventorySpecialStockType to define the special stock type Measures and attributes Some important attributes are: MaterialBaseUnit AlternativeUnit Some important measures are: Stock Quantity in AUoM Consumption Quantity in AUoM Stock Increase Quantity in AUoM Stock Decrease Quantity in AUoM

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessSupply Chain
Application ComponentMM-IM-VDM-SGM-2CL
CapabilitiesData Source in SQL Select,Data Provider for Analytical Queries,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSupply Chain for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business question:</p> <ul> <li> <p>Which quantity in alternative unit of measure (AUoM) of a material was available at a certain date?</p> </li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_MatlStkAtKeyDateInAltUoM P_MatlStkAtKeyDateInAltUoM from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Associations (10)

CardinalityTargetAliasCondition
[0..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[0..1] I_StorageLocation _StorageLocation $projection.Plant = _StorageLocation.Plant and $projection.StorageLocation = _StorageLocation.StorageLocation
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Supplier _SpecialStockIdfgStockOwner $projection.SpecialStockIdfgStockOwner = _SpecialStockIdfgStockOwner.Supplier
[0..1] I_InventorySpecialStockType _InventorySpecialStockType $projection.InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType
[0..1] I_InventoryStockType _InventoryStockType $projection.InventoryStockType = _InventoryStockType.InventoryStockType
[1..1] I_UnitOfMeasure _UnitOfMeasure $projection.MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (14)

NameValueLevelField
EndUserText.label Stock At Key Date In Alternative UoM view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Analytics.technicalName IMATSTKDATEAUOM view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY Product Material Material for Stock Mamangement
KEY Plant Plant Valuation Area
KEY StorageLocation StorageLocation Storage Location
KEY Batch Batch Batch Number (Stock Identifier)
KEY Supplier Supplier Supplier for Special Stock
KEY SDDocument SDDocument Sales Order Number of Valuated Sales Order Stock
KEY SDDocumentItem SDDocumentItem Sales Order Item of Valuated Sales Order Stock
KEY WBSElementInternalID WBSElementInternalID Valuated Sales Order Stock WBS Element
KEY Customer Customer Customer for Special Stock
KEY SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner Add. Supplier for Special Stock
KEY InventoryStockType InventoryStockType Stock Type of Goods Movement (Stock Identifier)
KEY InventorySpecialStockType InventorySpecialStockType Special Stock Type
KEY MaterialBaseUnit MaterialBaseUnit Base Unit of Measure
KEY AlternativeUnit AlternativeUnit Alternative Unit of Measure for Stockkeeping Unit
CompanyCode CompanyCode Receiver Company Code
FiscalYearVariant FiscalYearVariant Fiscal Year Variant
MatlWrhsStkQtyInMatlBaseUnit MatlWrhsStkQtyInMatlBaseUnit Quantity
MatlCnsmpnQtyInMatlBaseUnit MatlCnsmpnQtyInMatlBaseUnit
MatlStkIncrQtyInMatlBaseUnit MatlStkIncrQtyInMatlBaseUnit
MatlStkDecrQtyInMatlBaseUnit MatlStkDecrQtyInMatlBaseUnit
MatlWrhsStkQtyInAltUoM Stock Quantity in AUoM
MatlCnsmpnQtyInAltUoM Consumption Quantity in AUoM
MatlStkIncrQtyInAltUoM Stock Increase Quantity in AUoM
MatlStkDecrQtyInAltUoM Stock Decrease Quantity in AUoM
_UnitOfMeasure _UnitOfMeasure
_Product _Product
_Plant _Plant
_StorageLocation _StorageLocation
_Supplier _Supplier
_Customer _Customer
_SpecialStockIdfgStockOwner _SpecialStockIdfgStockOwner
_InventoryStockType _InventoryStockType
_InventorySpecialStockType _InventorySpecialStockType
_CompanyCode _CompanyCode

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 I_MatlStkAtKeyDateInAltUoM.
-- 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.
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW I_MatlStkAtKeyDateInAltUoM AS
SELECT
  Material AS Product,
  Plant,
  StorageLocation,
  Batch,
  Supplier,
  SDDocument,
  SDDocumentItem,
  WBSElementInternalID,
  Customer,
  SpecialStockIdfgStockOwner,
  InventoryStockType,
  InventorySpecialStockType,
  MaterialBaseUnit,
  AlternativeUnit,
  CompanyCode,
  FiscalYearVariant,
  MatlWrhsStkQtyInMatlBaseUnit,
  MatlCnsmpnQtyInMatlBaseUnit,
  MatlStkIncrQtyInMatlBaseUnit,
  MatlStkDecrQtyInMatlBaseUnit,
  cast( fltp_to_dec( MatlWrhsStkQtyInAltUoM as abap.dec(31,14) ) as nsdm_stock_qty_auom ) AS MatlWrhsStkQtyInAltUoM,
  cast( fltp_to_dec( MatlCnsmpnQtyInAltUoM as abap.dec(31,14) ) as nsdm_consumption_qty_auom ) AS MatlCnsmpnQtyInAltUoM,
  cast( fltp_to_dec( MatlStkIncrQtyInAltUoM as abap.dec(31,14) ) as nsdm_stock_increase_qty_auom ) AS MatlStkIncrQtyInAltUoM,
  cast( fltp_to_dec( MatlStkDecrQtyInAltUoM as abap.dec(31,14) ) as nsdm_stock_decrease_qty_auom ) AS MatlStkDecrQtyInAltUoM
FROM P_MatlStkAtKeyDateInAltUoM
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _SpecialStockIdfgStockOwner ON SpecialStockIdfgStockOwner = _SpecialStockIdfgStockOwner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_InventoryStockType AS _InventoryStockType ON InventoryStockType = _InventoryStockType.InventoryStockType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
;

Learn More