P_MltplMatlStk_L3C

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_MltplMatlStk_L3C.
-- 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_EndDate : sydate

CREATE VIEW P_MltplMatlStk_L3C AS
SELECT
  Material,
  Plant,
  StorageLocation,
  Batch,
  Supplier,
  SDDocument,
  SDDocumentItem,
  WBSElementInternalID,
  Customer,
  ResourceID,
  InventorySpecialStockType,
  CostEstimate,
  cast('3' as bwkrs_cus) AS ValuationAreaType,
  MaterialBaseUnit,
  InventoryValuationType,
  Currency,
  VltdUnrestrictedUseStkQty,
  QualityInspectionStockQuantity,
  ReturnsBlockedStockQuantity,
  TransferStockStorageLocQty,
  TransferStockPlantQuantity,
  StockInTransitQuantity,
  BlockedStockQuantity,
  RestrictedStockQuantity,
  TiedEmptiesStockQuantity,
  GoodsReceiptBlockedStockQty,
  case when _CurrentInvtryPrice.MaterialPriceUnitQty = 0 then cast(1 as abap.dec( 5, 0 )) when _CurrentInvtryPrice.MaterialPriceUnitQty is null then cast(1 as abap.dec( 5, 0 )) else cast(_CurrentInvtryPrice.MaterialPriceUnitQty as abap.dec( 5, 0 )) end as MaterialPriceUnitQty AS dec50endasMaterialPriceUnitQty,
  cast(_MaterialStockValueByKeyDate( P_EndDate: $parameters.P_EndDate ).AmountInCompanyCodeCurrency as abap.dec(23,2)) AS AmountInCompanyCodeCurrency,
  cast(_MaterialStockValueByKeyDate( P_EndDate: $parameters.P_EndDate ).InventoryQty as abap.dec(16,5)) AS InventoryQty
FROM P_MltplMatlStk_L2
LEFT OUTER JOIN R_MaterialStockValueByKeyDate AS _MaterialStockValueByKeyDate ON CostEstimate = _MaterialStockValueByKeyDate.CostEstimate AND CompanyCode = _MaterialStockValueByKeyDate.ValuationArea AND Material = _MaterialStockValueByKeyDate.Product AND MaterialBaseUnit = _MaterialStockValueByKeyDate.BaseUnit AND CostEstimate <> '000000000000'  -- association [0..1]
LEFT OUTER JOIN I_CurrentMatlPriceByCostEst AS _CurrentInvtryPrice ON CostEstimate = _CurrentInvtryPrice.CostEstimate AND CompanyCode = _CurrentInvtryPrice.ValuationArea AND Material = _CurrentInvtryPrice.Material AND CostEstimate <> '000000000000'  -- association [0..1]
;