I_InventoryAmtByFsclPerd

DDL: I_INVENTORYAMTBYFSCLPERD Type: view_entity COMPOSITE Package: FINS_ML_VDM
21 Fields 1 Data Sources

Inventory Amount for Fiscal Period

I_InventoryAmtByFsclPerd (Composite)

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

Accounting and Financial Close

I_InventoryAmtByFsclPerd is a Composite CDS View that provides data about "Inventory Amount for Fiscal Period" in SAP S/4HANA. It reads from 1 data source (R_MatlValnEndgInvtryByFsclPerd) and exposes 21 fields with key fields Ledger, CompanyCode, CostEstimate. Part of development package FINS_ML_VDM.

SAP Help Documentation

CategoryCDS Views for Inventory Accounting
Purpose
This CDS view specifies the determined inventory amount and valuation quantity for all materials at the end of a fiscal period. If the end of the fiscal period has not been reached yet, the CDS view specifies the inventory amount and valuation quantity determined for the current date. This CDS view provides the data to answer the following business question: What was the inventory amount and valuation quantity at the end of the fiscal period? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Users who want to use this CDS view must have the authorization to access the companies and valuation areas.

Structure
Parameters The parameters of the CDS view are as follows: P_FiscalPeriod P_FiscalYear These parameters are used to define the fiscal period for the inventory amount and the valuation quantity determination of the materials. Important Fields Important fields in this view include the following: Field Name Description Ledger Ledger in universal parallel accounting CompanyCode Company code CostEstimate Cost estimate number for cost estimate without quantity structure Material Material number ValuationType Valuation type ValuationArea Valuation area InvtryValnSpecialStockType Special stock indicator SalesOrder Sales document number of valuated special inventory SalesOrderItem Sales document item number of valuated special inventory Supplier Supplier of valuated special inventory WBSElementInternalID WBS element internal ID FiscalPeriod Posting period FiscalYear Fiscal year ValuationQuantity Valuation quantity UnitOfMeasure Base unit of measure AmountInCompanyCodeCurrency Amount in company code currency CompanyCodeCurrency Currency key AmountInGlobalCurrency Amount in global currency GlobalCurrency Currency key AmountInFreeDefinedCurrency1 Amount in freely defined currency 1 FreeDefinedCurrency1 Currency key

View on SAP Help Portal →

SAP API Hub

CategoryComposite
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCO-PC-ML-2CL
CapabilitiesData Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Not Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view specifies the determined inventory amount and valuation quantity for all materials at the end of a fiscal period. If the end of the fiscal period has not been reached yet, the CDS view specifies the inventory amount and valuation quantity determined for the current date.</p> <p>This CDS view provides the data to answer the following business question: </p> <ul> <li><p>What was the inventory amount and valuation quantity at the end of the fiscal period?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
R_MatlValnEndgInvtryByFsclPerd R_MatlValnEndgInvtryByFsclPerd from

Parameters (2)

NameTypeDefault
P_FiscalPeriod poper
P_FiscalYear gjahr

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Inventory Amount for Fiscal Period view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger in General Ledger Accounting
KEY CompanyCode CompanyCode Receiver Company Code
KEY CostEstimate CostEstimate Cost Estimate Number for Cost Est. w/o Qty Structure
Material Material Material Number
ValuationType ValuationType Valuation Type
ValuationArea ValuationArea Valuation Area
InvtryValnSpecialStockType InvtryValnSpecialStockType Special Stock Indicator
SalesOrder SalesOrder Sales Document Number of Valuated Special Inventory
SalesOrderItem SalesOrderItem Sales Document Item Number of Valuated Special Inventory
Supplier Supplier Supplier of Valuated Special Inventory
WBSElementInternalID WBSElementInternalID WBS Element Internal ID
FiscalPeriod Posting Period
FiscalYear Fiscal Year
ValuationQuantity ValuationQuantity Valuation Quantity
UnitOfMeasure UnitOfMeasure Base Unit of Measure
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Amount in Company Code Currency
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInGlobalCurrency AmountInGlobalCurrency Amount in Global Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1

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_InventoryAmtByFsclPerd.
-- 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_FiscalPeriod : poper, P_FiscalYear : gjahr

CREATE VIEW I_InventoryAmtByFsclPerd AS
SELECT
  Ledger,
  CompanyCode,
  CostEstimate,
  Material,
  ValuationType,
  ValuationArea,
  InvtryValnSpecialStockType,
  SalesOrder,
  SalesOrderItem,
  Supplier,
  WBSElementInternalID,
  $parameters.P_FiscalPeriod AS FiscalPeriod,
  $parameters.P_FiscalYear AS FiscalYear,
  ValuationQuantity,
  UnitOfMeasure,
  AmountInCompanyCodeCurrency,
  CompanyCodeCurrency,
  AmountInGlobalCurrency,
  GlobalCurrency,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency1
FROM R_MatlValnEndgInvtryByFsclPerd
;

Learn More