C_MatlStkAtKeyDateInAltUoM

DDL: C_MATLSTKATKEYDATEINALTUOM Type: view CONSUMPTION
24 Fields 1 Data Sources

Stock at Key Date in Alternative UoM

C_MatlStkAtKeyDateInAltUoM (Consumption)

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

Supply Chain

C_MatlStkAtKeyDateInAltUoM is a Consumption CDS View that provides data about "Stock at Key Date in Alternative UoM" in SAP S/4HANA. It reads from 1 data source (I_MatlStkAtKeyDateInAltUoM) and exposes 24 fields.

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

StateC1
Line of BusinessSupply Chain
Application ComponentMM-IM-VDM-SGM
CapabilitiesAnalytical Query
PackageSupply Chain for SAP S/4HANA Cloud Private 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
I_MatlStkAtKeyDateInAltUoM I_MatlStkAtKeyDateInAltUoM from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CMATSTKDATEAUOM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Stock at Key Date in Alternative UoM view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
Analytics.query true view
OData.publish true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (24)

KeyFieldSource TableSource FieldDescription
Product Product Material for Stock Mamangement
Plant Plant Valuation Area
StorageLocation StorageLocation Storage Location
Batch Batch Batch Number (Stock Identifier)
Supplier Supplier Supplier for Special Stock
SDDocument SDDocument Sales Order Number of Valuated Sales Order Stock
SDDocumentItem SDDocumentItem Sales Order Item of Valuated Sales Order Stock
WBSElementInternalID WBSElementInternalID Valuated Sales Order Stock WBS Element
Customer Customer Customer for Special Stock
SpecialStockIdfgStockOwner SpecialStockIdfgStockOwner Add. Supplier for Special Stock
InventoryStockType InventoryStockType Stock Type of Goods Movement (Stock Identifier)
InventorySpecialStockType InventorySpecialStockType Special Stock Type
MaterialBaseUnit MaterialBaseUnit Base Unit of Measure
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 MatlWrhsStkQtyInAltUoM Stock Quantity in AUoM
MatlCnsmpnQtyInAltUoM MatlCnsmpnQtyInAltUoM Consumption Quantity in AUoM
MatlStkIncrQtyInAltUoM MatlStkIncrQtyInAltUoM Stock Increase Quantity in AUoM
MatlStkDecrQtyInAltUoM MatlStkDecrQtyInAltUoM Stock Decrease Quantity in AUoM

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_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 C_MatlStkAtKeyDateInAltUoM AS
SELECT
  Product,
  Plant,
  StorageLocation,
  Batch,
  Supplier,
  SDDocument,
  SDDocumentItem,
  WBSElementInternalID,
  Customer,
  SpecialStockIdfgStockOwner,
  InventoryStockType,
  InventorySpecialStockType,
  MaterialBaseUnit,
  AlternativeUnit,
  CompanyCode,
  FiscalYearVariant,
  MatlWrhsStkQtyInMatlBaseUnit,
  MatlCnsmpnQtyInMatlBaseUnit,
  MatlStkIncrQtyInMatlBaseUnit,
  MatlStkDecrQtyInMatlBaseUnit,
  MatlWrhsStkQtyInAltUoM,
  MatlCnsmpnQtyInAltUoM,
  MatlStkIncrQtyInAltUoM,
  MatlStkDecrQtyInAltUoM
FROM I_MatlStkAtKeyDateInAltUoM
;

Learn More