C_CN_MaterialStockSum

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 C_CN_MaterialStockSum.
-- 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.
-- SQL view name: CCNMATSTKSUM
-- Parameters: P_FromPostingDate : budat, P_ToPostingDate : budat, P_IsReversal : char1

CREATE VIEW C_CN_MaterialStockSum AS
SELECT
  defaultValue: '20210331' AS P_FromPostingDate,
  P_ToPostingDate : $parameters.P_ToPostingDate AS P_ToPostingDate,
  Plant,
  StockIdentifyingBatch,
  InventoryValuationType,
  GoodsMovementType,
  StockIdfgStorageLocation,
  _detail.BaseUnit AS MaterialBaseUnit,
  CompanyCode,
  InventorySpecialStockType,
  CompanyCodeCurrency,
  MaterialGroup,
  MaterialGroupName,
  MaterialType,
  MaterialTypeName,
  MaterialDescription,
  StandardPriceInCoCodeCrcy,
  CompanyCodeName,
  StorageLocationName,
  PlantName,
  AccountingDocumentIsExcluded,
  IsCrossPlantTransfer,
  IsStorageLocChangeByTransf,
  IsBatchChangeByTransf,
  sum ( case when PostingDate >= :P_FromPostingDate and PostingDate <= :P_ToPostingDate then MatlStkIncrQtyInMatlBaseUnit else 0 end ) AS MatlStkIncrQtyInMatlBaseUnit,
  sum ( case when PostingDate >= :P_FromPostingDate and PostingDate <= :P_ToPostingDate then MatlStkIncrQtyAmountInCCCrcy else 0 end ) AS GoodsMovementStkAmtInCCCrcy,
  sum ( case when PostingDate >= :P_FromPostingDate and PostingDate <= :P_ToPostingDate then MatlStkDecrQtyInMatlBaseUnit else 0 end ) AS MatlStkDecrQtyInMatlBaseUnit,
  sum ( case when PostingDate >= :P_FromPostingDate and PostingDate <= :P_ToPostingDate then MatlStkDecrQtyAmountInCCCrcy else 0 end ) AS MatlStkDecrQtyAmountInCCCrcy,
  sum ( case when PostingDate < :P_FromPostingDate then MatlStkChangeQtyInBaseUnit else 0 end ) AS PeriodStartStockQuantity,
  sum ( case when PostingDate < :P_FromPostingDate then GoodsMovementStkAmtInCCCrcy else 0 end ) AS PeriodStartStockAmountInCoCrcy,
  cast( '99999999' as nsdm_dmbtr_stock ) AS MatlStkPerdStrtPriceInCCCrcy,
  sum ( case when ( PostingDate < :P_FromPostingDate) and ( CN_MatlsStkSpclStkIsNoValFlag = 'X') then MatlStkChangeQtyInBaseUnit else 0 end ) AS CN_MatlsStkSpclStkNoValStrtQty,
  cast( '99999999' as nsdm_dmbtr_stock ) AS MatlStkPerdEndPriceInCCCrcy,
  cast( '99999999' as j_3rm_credreval ) AS MatlStkCreditRevalAmtInCCCrcy,
  cast( '99999999' as j_3rm_debreval ) AS MatlStkDebitRevalAmtInCCCrcy
FROM I_CN_MaterialStockDetail
LEFT OUTER JOIN I_CN_MaterialStockDetail AS _child ON StockIdentifyingMaterial = _child.StockIdentifyingMaterial AND _detail.Plant = _child.Plant AND _detail.StockIdfgStorageLocation = _child.StockIdfgStorageLocation AND _detail.StockIdentifyingBatch = _child.StockIdentifyingBatch AND _detail.InventoryValuationType = _child.InventoryValuationType AND _detail.GoodsMovementType = _child.GoodsMovementType  -- association [1..*]
;