P_ActlCostgRunRsltBegInventory

DDL: P_ACTLCOSTGRUNRSLTBEGINVENTORY Type: view_entity COMPOSITE Package: FCML4H_DISPLAY
37 Fields 8 Data Sources

Beginning Inventory

P_ActlCostgRunRsltBegInventory is a Composite CDS View that provides data about "Beginning Inventory" in SAP S/4HANA. It reads from 8 data sources and exposes 37 fields with key fields CostEstimate, CurrencyRole, Ledger, Material, ValuationArea. Part of development package FCML4H_DISPLAY.

Data Sources (8)

SourceAliasJoin Type
P_MaterialLedgerCostingRun CostingRun inner
P_MaterialLedgerCostingRun CostingRun inner
P_InvtryLdgrMatlLedgerDocument MatlLedgerDocument inner
P_MaterialLedgerHeaderData MatlLedgerHeaderData inner
P_MaterialLedgerHeaderData MatlLedgerHeaderData inner
P_MatlLedgerDocumentExtract MLDocExtract inner
P_MatLedgerCostingRunPerPeriod PerPeriod from
P_MatLedgerCostingRunPerPeriod PerPeriod union_all

Parameters (3)

NameTypeDefault
P_CostingRunType ckml_run_type
P_FiscalPeriod fins_fiscalperiod
P_FiscalYear fis_gjahr_no_conv

Annotations (7)

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

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY CostEstimate P_MatlLedgerDocumentExtract CostEstimate Cost EstimateNo
KEY CurrencyRole P_MatlLedgerDocumentExtract CurrencyRole Curr./Val. Type
KEY Ledger P_MatlLedgerDocumentExtract Ledger Ledger
KEY Material P_MaterialLedgerHeaderData Material Vehicle Model
KEY ValuationArea P_MaterialLedgerHeaderData ValuationArea Valuation Area
KEY InventoryValuationType P_MaterialLedgerHeaderData InventoryValuationType Valuation Type
KEY SalesOrder P_MaterialLedgerHeaderData SalesOrder SD Document
KEY SalesOrderItem P_MaterialLedgerHeaderData SalesOrderItem Sales Order Item
KEY InventorySpecialStockType P_MaterialLedgerHeaderData InventorySpecialStockType Special Stock Type
KEY WBSElementExternalID
KEY Supplier P_MaterialLedgerHeaderData Supplier Supplier
KEY MaterialLedgerCategory
KEY ProcessCategory
TotalVltdStockQuantity
ValuationQuantityUnit P_MatlLedgerDocumentExtract ValuationQuantityUnit Valuation Unit
InvtryTransacAmtInDisplayCrcy
PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency
CostEstimateasCostEstimate
KEY CurrencyRole P_InvtryLdgrMatlLedgerDocument CurrencyRole Curr./Val. Type
KEY Ledger P_InvtryLdgrMatlLedgerDocument Ledger Ledger
KEY Material P_MaterialLedgerHeaderData Material Vehicle Model
KEY ValuationArea P_MaterialLedgerHeaderData ValuationArea Valuation Area
KEY InventoryValuationType P_MaterialLedgerHeaderData InventoryValuationType Valuation Type
KEY SalesOrder P_MaterialLedgerHeaderData SalesOrder SD Document
KEY SalesOrderItem P_MaterialLedgerHeaderData SalesOrderItem Sales Order Item
KEY InventorySpecialStockType P_MaterialLedgerHeaderData InventorySpecialStockType Special Stock Type
KEY WBSElementExternalID
KEY Supplier P_MaterialLedgerHeaderData Supplier Supplier
KEY MaterialLedgerCategory
KEY ProcessCategory
TotalVltdStockQuantity
ValuationQuantityUnit P_InvtryLdgrMatlLedgerDocument ValuationQuantityUnit Valuation Unit
InvtryTransacAmtInDisplayCrcy
PriceDiffAmtInDisplayCrcy
ExchRateDiffAmtInDspCurrency
Currency P_InvtryLdgrMatlLedgerDocument Currency Valuation Crcy

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_ActlCostgRunRsltBegInventory.
-- 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_CostingRunType : ckml_run_type, P_FiscalPeriod : fins_fiscalperiod, P_FiscalYear : fis_gjahr_no_conv

CREATE VIEW P_ActlCostgRunRsltBegInventory AS
SELECT
  MLDocExtract.CostEstimate AS CostEstimate,
  MLDocExtract.CurrencyRole AS CurrencyRole,
  MLDocExtract.Ledger AS Ledger,
  MatlLedgerHeaderData.Material AS Material,
  MatlLedgerHeaderData.ValuationArea AS ValuationArea,
  MatlLedgerHeaderData.InventoryValuationType AS InventoryValuationType,
  MatlLedgerHeaderData.SalesOrder AS SalesOrder,
  MatlLedgerHeaderData.SalesOrderItem AS SalesOrderItem,
  MatlLedgerHeaderData.InventorySpecialStockType AS InventorySpecialStockType,
  MatlLedgerHeaderData._WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID,
  MatlLedgerHeaderData.Supplier AS Supplier,
  cast ( 'AB' as ckml_categ preserving type ) AS MaterialLedgerCategory,
  cast ( ' ' as ck_ptyp_bvalt preserving type ) AS ProcessCategory,
  sum(MLDocExtract.TotalVltdStockQuantity) AS TotalVltdStockQuantity,
  MLDocExtract.ValuationQuantityUnit AS ValuationQuantityUnit,
  sum(MLDocExtract.InvtryTransacAmtInDisplayCrcy) AS InvtryTransacAmtInDisplayCrcy,
  cast ( 0 as ml4h_prd ) AS PriceDiffAmtInDisplayCrcy,
  cast ( 0 as ml4h_kdm ) AS ExchRateDiffAmtInDspCurrency,
  MLDocExtract.Currency as Currency AS CostEstimateasCostEstimate,
  MatlLedgerDocument.Currency AS Currency
FROM P_MatLedgerCostingRunPerPeriod AS PerPeriod
INNER JOIN P_MaterialLedgerCostingRun AS CostingRun ON /* join condition not captured in parsed metadata */
INNER JOIN P_MatlLedgerDocumentExtract AS MLDocExtract ON /* join condition not captured in parsed metadata */
INNER JOIN P_MaterialLedgerHeaderData AS MatlLedgerHeaderData ON /* join condition not captured in parsed metadata */
INNER JOIN P_InvtryLdgrMatlLedgerDocument AS MatlLedgerDocument ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_MatLedgerCostingRunPerPeriod
;

Learn More