P_InvtryTransBsdMatlBegAndEnd

DDL: P_INVTRYTRANSBSDMATLBEGANDEND Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
41 Fields 4 Data Sources

Transaction-Based Material Beginning and Ending Inventory

P_InvtryTransBsdMatlBegAndEnd is a Composite CDS View that provides data about "Transaction-Based Material Beginning and Ending Inventory" in SAP S/4HANA. It reads from 4 data sources (P_MaterialWithActualCosting, P_MaterialWithActualCosting, P_MatlLedgerDocumentExtract, P_MatlLedgerDocumentExtract) and exposes 41 fields with key fields CostEstimate, FiscalYearPeriod, MaterialLedgerCategory, CurrencyRole, Ledger. Part of development package FCML4H_DISPLAY.

Data Sources (4)

SourceAliasJoin Type
P_MaterialWithActualCosting MaterialWithActualCosting inner
P_MaterialWithActualCosting MaterialWithActualCosting inner
P_MatlLedgerDocumentExtract MLDocExtract from
P_MatlLedgerDocumentExtract MLDocExtract 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 #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate P_MatlLedgerDocumentExtract CostEstimate Cost EstimateNo
KEY FiscalYearPeriod
KEY MaterialLedgerCategory
KEY CurrencyRole P_MatlLedgerDocumentExtract CurrencyRole Curr./Val. Type
KEY Ledger P_MatlLedgerDocumentExtract Ledger Ledger
TotalVltdStockQuantity
ValuationQuantityUnit P_MatlLedgerDocumentExtract ValuationQuantityUnit Valuation Unit
InvtryTransacAmtInDisplayCrcy
Currency P_MatlLedgerDocumentExtract Currency Valuation Crcy
PriceDeterminationControl P_MaterialWithActualCosting PriceDeterminationControl Price Determ.
Material P_MaterialWithActualCosting Material Vehicle Model
ValuationArea P_MaterialWithActualCosting ValuationArea Valuation Area
InventoryValuationType P_MaterialWithActualCosting InventoryValuationType Valuation Type
SalesOrder P_MaterialWithActualCosting SalesOrder SD Document
SalesOrderItem P_MaterialWithActualCosting SalesOrderItem Sales Order Item
InventorySpecialStockType P_MaterialWithActualCosting InventorySpecialStockType Special Stock Type
InventorySpecialStockTypeName P_MaterialWithActualCosting InventorySpecialStockTypeName
Supplier P_MaterialWithActualCosting Supplier Supplier
WBSElementExternalID
CompanyCode P_MaterialWithActualCosting CompanyCode Receiver Company Code
CostEstimate Cost EstimateNo
KEY FiscalYearPeriod
KEY MaterialLedgerCategory
KEY CurrencyRole P_MatlLedgerDocumentExtract CurrencyRole Curr./Val. Type
KEY Ledger P_MatlLedgerDocumentExtract Ledger Ledger
TotalVltdStockQuantity
ValuationQuantityUnit P_MatlLedgerDocumentExtract ValuationQuantityUnit Valuation Unit
InvtryTransacAmtInDisplayCrcy
Currency P_MatlLedgerDocumentExtract Currency Valuation Crcy
PriceDeterminationControl P_MaterialWithActualCosting PriceDeterminationControl Price Determ.
Material P_MaterialWithActualCosting Material Vehicle Model
ValuationArea P_MaterialWithActualCosting ValuationArea Valuation Area
InventoryValuationType P_MaterialWithActualCosting InventoryValuationType Valuation Type
SalesOrder P_MaterialWithActualCosting SalesOrder SD Document
SalesOrderItem P_MaterialWithActualCosting SalesOrderItem Sales Order Item
InventorySpecialStockType P_MaterialWithActualCosting InventorySpecialStockType Special Stock Type
InventorySpecialStockTypeName P_MaterialWithActualCosting InventorySpecialStockTypeName
Supplier P_MaterialWithActualCosting Supplier Supplier
WBSElementExternalID
CompanyCode P_MaterialWithActualCosting CompanyCode Receiver Company Code
ControllingArea P_MaterialWithActualCosting 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_InvtryTransBsdMatlBegAndEnd.
-- 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_InvtryTransBsdMatlBegAndEnd AS
SELECT
  MLDocExtract.CostEstimate AS CostEstimate,
  $parameters.P_FromFiscalYearPeriod AS FiscalYearPeriod,
  cast ( 'AB' as ckml_categ preserving type ) AS MaterialLedgerCategory,
  MLDocExtract.CurrencyRole AS CurrencyRole,
  MLDocExtract.Ledger AS Ledger,
  sum (MLDocExtract.TotalVltdStockQuantity) AS TotalVltdStockQuantity,
  MLDocExtract.ValuationQuantityUnit AS ValuationQuantityUnit,
  sum (MLDocExtract.InvtryTransacAmtInDisplayCrcy) AS InvtryTransacAmtInDisplayCrcy,
  MLDocExtract.Currency AS Currency,
  MaterialWithActualCosting.PriceDeterminationControl AS PriceDeterminationControl,
  MaterialWithActualCosting.Material AS Material,
  MaterialWithActualCosting.ValuationArea AS ValuationArea,
  MaterialWithActualCosting.InventoryValuationType AS InventoryValuationType,
  MaterialWithActualCosting.SalesOrder AS SalesOrder,
  MaterialWithActualCosting.SalesOrderItem AS SalesOrderItem,
  MaterialWithActualCosting.InventorySpecialStockType AS InventorySpecialStockType,
  MaterialWithActualCosting.InventorySpecialStockTypeName AS InventorySpecialStockTypeName,
  MaterialWithActualCosting.Supplier AS Supplier,
  MaterialWithActualCosting._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  MaterialWithActualCosting.CompanyCode AS CompanyCode,
  MaterialWithActualCosting.ControllingArea AS ControllingArea
FROM P_MatlLedgerDocumentExtract AS MLDocExtract
INNER JOIN P_MaterialWithActualCosting AS MaterialWithActualCosting ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_MatlLedgerDocumentExtract
;

Learn More