P_BeginningAndEndingInventory

DDL: P_BEGINNINGANDENDINGINVENTORY Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
43 Fields 2 Data Sources 1 Associations

Beginning and Ending Inventory

P_BeginningAndEndingInventory is a Composite CDS View that provides data about "Beginning and Ending Inventory" in SAP S/4HANA. It reads from 2 data sources (P_MatlLdgrDocXtrctActlCosting, P_MatlInvtryLdgrBegInventory) and exposes 43 fields with key fields CostEstimate, FiscalYearPeriodTO, MaterialLedgerCategory, CurrencyRole, Ledger. It has 1 association to related views. Part of development package FCML4H_DISPLAY.

Data Sources (2)

SourceAliasJoin Type
P_MatlLdgrDocXtrctActlCosting MaterialLedgerDocumentExtract union_all
P_MatlInvtryLdgrBegInventory P_MatlInvtryLdgrBegInventory from

Parameters (2)

NameTypeDefault
P_FromFiscalYearPeriod fml_fyearperiod_from
P_ToFiscalYearPeriod fml_fyearperiod_to

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialLedgerCategory _MaterialLedgerCategory $projection.MaterialLedgerCategory = _MaterialLedgerCategory.MaterialLedgerCategory

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate P_MatlLdgrDocXtrctActlCosting CostEstimate Cost EstimateNo
KEY FiscalYearPeriodTO
KEY MaterialLedgerCategory
KEY CurrencyRole P_MatlLdgrDocXtrctActlCosting CurrencyRole Curr./Val. Type
KEY Ledger P_MatlLdgrDocXtrctActlCosting Ledger Ledger
TotalVltdStockQuantity
ValuationQuantityUnit P_MatlLdgrDocXtrctActlCosting ValuationQuantityUnit
InvtryTransacAmtInDisplayCrcy
Currency P_MatlLdgrDocXtrctActlCosting Currency Valuation Crcy
PriceDeterminationControl PriceDeterminationControl Price Determ.
Material Material Vehicle Model
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
InventorySpecialStockType InventorySpecialStockType Special Stock Type
InventorySpecialStockTypeName InventorySpecialStockTypeName
Supplier Supplier Supplier
WBSElementExternalID WBSElementExternalID WBS Element External ID
CompanyCode CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area
CostEstimateasCostEstimate
KEY FiscalYearPeriodTO
KEY MaterialLedgerCategory
KEY CurrencyRole P_MatlLdgrDocXtrctActlCosting CurrencyRole Curr./Val. Type
KEY Ledger P_MatlLdgrDocXtrctActlCosting Ledger Ledger
TotalVltdStockQuantity
ValuationQuantityUnit P_MatlLdgrDocXtrctActlCosting ValuationQuantityUnit
InvtryTransacAmtInDisplayCrcy
Currency P_MatlLdgrDocXtrctActlCosting Currency Valuation Crcy
PriceDeterminationControl PriceDeterminationControl Price Determ.
Material Material Vehicle Model
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
InventorySpecialStockType InventorySpecialStockType Special Stock Type
InventorySpecialStockTypeName InventorySpecialStockTypeName
Supplier Supplier Supplier
WBSElementExternalID WBSElementExternalID WBS Element External ID
CompanyCode CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area
_MaterialLedgerCategory _MaterialLedgerCategory

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 P_BeginningAndEndingInventory.
-- 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_FromFiscalYearPeriod : fml_fyearperiod_from, P_ToFiscalYearPeriod : fml_fyearperiod_to

CREATE VIEW P_BeginningAndEndingInventory AS
SELECT
  MaterialLedgerDocumentExtract.CostEstimate AS CostEstimate,
  $parameters.P_FromFiscalYearPeriod AS FiscalYearPeriodTO,
  cast ( 'AB' as ckml_categ preserving type ) AS MaterialLedgerCategory,
  MaterialLedgerDocumentExtract.CurrencyRole AS CurrencyRole,
  MaterialLedgerDocumentExtract.Ledger AS Ledger,
  sum (MaterialLedgerDocumentExtract.TotalVltdStockQuantity) AS TotalVltdStockQuantity,
  MaterialLedgerDocumentExtract.ValuationQuantityUnit AS ValuationQuantityUnit,
  sum (MaterialLedgerDocumentExtract.InvtryTransacAmtInDisplayCrcy) AS InvtryTransacAmtInDisplayCrcy,
  MaterialLedgerDocumentExtract.Currency AS Currency,
  PriceDeterminationControl,
  Material,
  ValuationArea,
  InventoryValuationType,
  SalesOrder,
  SalesOrderItem,
  InventorySpecialStockType,
  InventorySpecialStockTypeName,
  Supplier,
  WBSElementExternalID,
  CompanyCode,
  ControllingArea
FROM P_MatlInvtryLdgrBegInventory
LEFT OUTER JOIN I_MaterialLedgerCategory AS _MaterialLedgerCategory ON MaterialLedgerCategory = _MaterialLedgerCategory.MaterialLedgerCategory  -- association [0..1]
-- UNION ALL with additional select branch(es): P_MatlLdgrDocXtrctActlCosting
;

Learn More