I_SupDmndOvwTotalSupply

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_SupDmndOvwTotalSupply.
-- 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_SupDmndOvwTotalSupply AS
SELECT
  supply.Material AS Material,
  supply.Plant AS Plant,
  supply.StorageLocation AS StorageLocation,
  supply.Batch AS Batch,
  supply.SupplyNumber AS SupplyNumber,
  supply.SupplyItem AS SupplyItem,
  supply.SupplyScheduleLine AS SupplyScheduleLine,
  supply.TotalQuantity AS TotalQuantity,
  OpenSupplyQuantity,
  supply.SupplyDeliveryDate AS SupplyDeliveryDate,
  supply.RequestedDeliveryDate AS RequestedDeliveryDate,
  supply.StockSegment AS StockSegment,
  supply.MaterialGroup AS MaterialGroup,
  supply.BaseUnit AS BaseUnit,
  supply.AssignedSupplyType AS AssignedSupplyType,
  text.AssignedSupplyTypeName AS AssignedSupplyTypeName,
  supply.FreeDefinedProductAttribute01 AS FreeDefinedProductAttribute01,
  supply.FreeDefinedProductAttribute02 AS FreeDefinedProductAttribute02,
  supply.FreeDefinedProductAttribute03 AS FreeDefinedProductAttribute03,
  supply.RetailArticleColor AS RetailArticleColor,
  supply.RetailArticleMainSize AS RetailArticleMainSize,
  supply.RetailArticleSecondSize AS RetailArticleSecondSize,
  supply.RoughGoodsReceiptQty AS RoughGoodsReceiptQty,
  supply.ProductCharacteristic1 AS ProductCharacteristic1,
  supply.ProductCharacteristic2 AS ProductCharacteristic2,
  supply.ProductCharacteristic3 AS ProductCharacteristic3,
  case when supply.CompanyCode is null or supply.CompanyCode = '' then Plant.CompanyCode else supply.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  supply.NetPriceAmount AS NetPriceAmount,
  supply.NetPriceQuantity AS NetPriceQuantity,
  supply.NetAmount AS NetAmount,
  supply.Customer AS Customer,
  supply.ItemIsRejectedBySupplier AS ItemIsRejectedBySupplier,
  supply.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  supply.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  supply.PurchasingOrderReason AS PurchasingOrderReason,
  supply.OrderType AS OrderType,
  supply.PaymentTerms AS PaymentTerms,
  supply.PurchasingGroup AS PurchasingGroup,
  supply.DocumentCurrency AS DocumentCurrency,
  supply.SupplyingPlant AS SupplyingPlant,
  supply.Supplier AS Supplier,
  supply.DeliveryDocument AS DeliveryDocument,
  supply.ProductSeason AS ProductSeason,
  supply.ProductSeasonYear AS ProductSeasonYear,
  supply.ProductCollection AS ProductCollection,
  supply.ProductTheme AS ProductTheme,
  supply.InventorySpecialStockType AS InventorySpecialStockType,
  supply.SalesOrder AS SalesOrder,
  supply.SalesOrderItem AS SalesOrderItem,
  supply.ItemQuantity AS ItemQuantity,
  supply.MfgOrderItemGoodsReceiptQty AS MfgOrderItemGoodsReceiptQty,
  supply.MfgOrderItemActualDeviationQty AS MfgOrderItemActualDeviationQty,
  supply.MfgOrderItemPlannedScrapQty AS MfgOrderItemPlannedScrapQty,
  supply.DeliveredQuantity AS DeliveredQuantity,
  CalDate.CalendarMonth AS CalendarMonth,
  concat_with_space('Week',CalDate.CalendarWeek,1) AS CalendarWeek,
  CalDate.CalendarYear AS CalendarYear,
  CalMonth.CalendarMonthName AS CalendarMonthName,
  case when AssignedQuantityInBaseUnit is not null then AssignedQuantityInBaseUnit else 0 end AS AssignedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  FixedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  OnHoldQuantityInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  PreviewFixedAssignedQtyInBsUnt,
  PreviewReservedAssgdQtyInBsUnt,
  PreviewOnHoldAssgdQtyInBsUnt,
  PreviewRdyForReleaseQtyInBsUnt,
  PreviewAssignedQuantityInBsUnt,
  '01' AS SupAssgmtCategory,
  Cat.SupAssgmtCategoryName AS SupAssgmtCategoryName,
  ShippingGroupRule,
  ShippingGroupNumber,
  Plant.SalesOrganization AS SalesOrganization,
  Plant.DistributionChannel AS DistributionChannel,
  Plant.PlantCustomer AS PlantCustomer,
  Plant.PlantSupplier AS PlantSupplier,
  mara.Division AS Division,
  Plant.ShippingPoint AS ShippingPoint,
  Plant.SalesDistrict AS SalesDistrict,
  supply.SupAssgmtSource AS SupAssgmtSource,
  SupAssgmtSourceName,
  PurchasingDocument,
  ShippingInstruction
FROM I_SupDmndOvwSupply AS supply
LEFT OUTER JOIN P_SUPDMNDSUPASSGMTSUPPLY AS bdbs 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 */
INNER JOIN I_SupDmndOvwPlant AS Plant ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupDmndMaterialPlant AS mara ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupDmndSource AS Src ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupDmndAssgdSupType AS text ON supply.AssignedSupplyType = text.AssignedSupplyType  -- association [1..1]
LEFT OUTER JOIN I_SupDmndSupAssgmtCat AS Cat ON Cat.SupAssgmtCategory = '01'  -- association [1..1]
;