P_MatlInvtryLdgrBegInventory

DDL: P_MATLINVTRYLDGRBEGINVENTORY Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
39 Fields 2 Data Sources

Beginning Inventory and Revaluation

P_MatlInvtryLdgrBegInventory is a Composite CDS View that provides data about "Beginning Inventory and Revaluation" in SAP S/4HANA. It reads from 2 data sources (P_MatlLdgrDocXtrctActlCosting, P_InventoryRevaluationPosting) and exposes 39 fields with key fields CostEstimate, FiscalYearPeriodTO, CurrencyRole, Ledger, FiscalYearPeriodTO. Part of development package FCML4H_DISPLAY.

Data Sources (2)

SourceAliasJoin Type
P_MatlLdgrDocXtrctActlCosting MaterialLedgerDocumentExtract from
P_InventoryRevaluationPosting P_InventoryRevaluationPosting union_all

Parameters (2)

NameTypeDefault
P_FromFiscalYearPeriod fml_fyearperiod_from
P_ToFiscalYearPeriod fml_fyearperiod_to

Annotations (7)

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

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate P_MatlLdgrDocXtrctActlCosting CostEstimate Cost EstimateNo
KEY FiscalYearPeriodTO
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
CostEstimateasCostEstimate
KEY FiscalYearPeriodTO
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

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_MatlInvtryLdgrBegInventory.
-- 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_MatlInvtryLdgrBegInventory AS
SELECT
  MaterialLedgerDocumentExtract.CostEstimate AS CostEstimate,
  $parameters.P_FromFiscalYearPeriod AS FiscalYearPeriodTO,
  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 AS CostEstimateasCostEstimate,
  ControllingArea
FROM P_MatlLdgrDocXtrctActlCosting AS MaterialLedgerDocumentExtract
-- UNION ALL with additional select branch(es): P_InventoryRevaluationPosting
;

Learn More