I_SupDmndAllDocBatStkC

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 I_SupDmndAllDocBatStkC.
-- 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.

CREATE VIEW I_SupDmndAllDocBatStkC AS
SELECT
  Supply.Material AS Material,
  Supply.Plant AS Plant,
  Supply.Batch AS Batch,
  Supply.StorageLocation AS StorageLocation,
  Supply.SupplyNumber AS SupplyNumber,
  Supply.SupplyItem AS SupplyItem,
  Supply.SupplyScheduleLine AS SupplyScheduleLine,
  Supply.ProductAvailabilityDate AS ProductAvailabilityDate,
  Supply.AssignedSupplyType AS AssignedSupplyType,
  Supply.RequestedDeliveryDate AS RequestedDeliveryDate,
  cast( Supply.TotalQuantity as abap.quan( 25, 3 )) AS TotalQuantity,
  cast( Supply.UnrestrictedStkInStkUnit as abap.quan( 25, 3 )) AS UnrestrictedStkInStkUnit,
  cast( Supply.QualityInspectionStockQuantity as abap.quan( 25, 3 )) AS QualityInspectionStockQuantity,
  cast( Supply.QualityInspectionStockQuantity as abap.quan( 25, 3 )) AS TransferStockStorageLocQty,
  cast( Supply.TransferStockPlantQuantity as abap.quan( 25, 3 )) AS TransferStockPlantQuantity,
  cast( Supply.StockInTransitQuantity as abap.quan( 25, 3 )) AS StockInTransitQuantity,
  cast( Supply.BlockedStockQuantity as abap.quan( 25, 3 )) AS BlockedStockQuantity,
  cast( Supply.RestrictedStockQuantity as abap.quan( 25, 3 )) AS RestrictedStockQuantity,
  cast( Supply.TiedEmptiesStockQuantity as abap.quan( 25, 3 )) AS TiedEmptiesStockQuantity,
  cast( Supply.GoodsReceiptBlockedStockQty as abap.quan( 25, 3 )) AS GoodsReceiptBlockedStockQty,
  cast (( Supply.OpenSupplyQuantity - coalesce( Assgmt.AssignedQuantityInBaseUnit , 0 ) ) as abap.quan( 25, 3 )) as OpenSupplyQuantity AS quan253asOpenSupplyQuantity,
  Assgmt.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  Assgmt.NormalAssignedQuantityInBsUnt AS NormalAssignedQuantityInBsUnt,
  Assgmt.PreviewAssignedQuantityInBsUnt AS PreviewAssignedQuantityInBsUnt,
  Assgmt.ARunTmpAssignedQuantityInBsUnt AS ARunTmpAssignedQuantityInBsUnt,
  Supply.BaseUnit AS BaseUnit,
  CalDate.CalendarYear AS CalendarYear,
  CalDate.CalendarMonth AS CalendarMonth,
  CalMonth.CalendarMonthName AS CalendarMonthName,
  concat_with_space( ARunDisplayTimeUnitText, CalDate.CalendarWeek, 1) AS CalendarWeek,
  CalDate.CalendarDay AS CalendarDay,
  Supply.MaterialGroup AS MaterialGroup,
  MaterialType,
  Supply.SupAssgmtSource AS SupAssgmtSource,
  Supply.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  Plant.SalesOrganization AS SalesOrganization,
  Plant.DistributionChannel AS DistributionChannel,
  Plant.Division AS Division,
  Plant.SalesDistrict AS SalesDistrict,
  PlantCustomer AS Customer,
  Plant.CompanyCode AS CompanyCode,
  Plant.PurchasingOrganization AS PurchasingOrganization,
  cast( '' as ekgrp ) AS PurchasingGroup,
  cast( ' ' as meins ) AS SupAssgmtAggrgQtyUnit,
  Supply.NetPriceAmount AS NetPriceAmount,
  Supply.DocumentCurrency AS DocumentCurrency
FROM I_SupDmndAllDocBatStkBsc AS Supply
INNER JOIN I_SupDmndOvwPlant AS Plant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ARunAssgmtSup AS Assgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunCalendarDate AS CalDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarMonthName AS CalMonth ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunTimeUnitText AS ARunTimeUnitText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductText AS _ProductText ON Material = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductGroupText AS _ProductGroupText ON MaterialGroup = _ProductGroupText.MaterialGroup AND _ProductGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeText AS _ProductTypeText ON MaterialType = _ProductTypeText.ProductType AND _ProductTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrgText ON SalesOrganization = _SalesOrgText.SalesOrganization AND _SalesOrgText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistrChnl ON DistributionChannel = _DistrChnl.DistributionChannel AND _DistrChnl.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _Divn ON Division = _Divn.Division AND _Divn.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrictText AS _SalesDist ON SalesDistrict = _SalesDist.SalesDistrict AND _SalesDist.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization AND CompanyCode = _PurchasingOrganization.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_SupDmndAllDocSupTypeT AS _SupText ON AssignedSupplyType = _SupText.AssignedSupplyType AND _SupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupDmndAllDocSupSourceT AS _SupSrceText ON SupAssgmtSource = _SupSrceText.SupAssgmtSource AND _SupSrceText.Language = $session.system_language  -- association [0..1]
;