C_SupDmndOvwTotDmndQuery

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_SupDmndOvwTotDmndQuery.
-- 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 C_SupDmndOvwTotDmndQuery AS
SELECT
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequestedDate,
  ProductAvailabilityDate,
  RequirementType,
  DeliveredQuantityInBaseUnit,
  RequestedRqmtQtyInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  OpenDemandQuantity,
  RequirementTypeName,
  OrderType,
  Demand.SalesOrganization AS SalesOrganization,
  Demand.DistributionChannel AS DistributionChannel,
  RequestedDeliveryDate,
  SoldToParty,
  ShipToParty,
  Demand.CompanyCode AS CompanyCode,
  PartnerFunction,
  SalesDocumentItemCategory,
  Demand.Division AS Division,
  Demand.Material AS Material,
  Demand.MaterialGroup AS MaterialGroup,
  BaseUnit,
  DeliveryGroup,
  ItemBillingBlockReason,
  NetAmount,
  DocumentCurrency,
  Demand.Plant AS Plant,
  StorageLocation,
  ShippingPoint,
  NetPriceAmount,
  NetPriceQuantity,
  RequirementSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  FashionCancelDate,
  ShippingGroupRule,
  ShippingGroupNumber,
  CustomerGroup,
  Demand.SalesDistrict AS SalesDistrict,
  CalendarMonth,
  CalendarWeek,
  CalendarYear,
  CalendarMonthName,
  AssignedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  FixedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  OnHoldQuantityInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  PreviewFixedAssignedQtyInBsUnt,
  PreviewReservedAssgdQtyInBsUnt,
  PreviewOnHoldAssgdQtyInBsUnt,
  PreviewRdyForReleaseQtyInBsUnt,
  PreviewAssignedQuantityInBsUnt,
  RequestedQuantityInBaseUnit,
  SupAssgmtCategory,
  SupAssgmtCategoryName,
  SupAssgmtOrdStatusName,
  Demand.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  SupAssgmtSource,
  SupAssgmtSourceName,
  SalesDocument,
  SalesOrganizationName,
  MaterialText.MaterialName AS MaterialName,
  MatGrpText.MaterialGroupName AS MaterialGroupName,
  DistChl.DistributionChannelName AS DistributionChannelName,
  Div.DivisionName AS DivisionName,
  SalesDist.SalesDistrictName AS SalesDistrictName,
  Plant.PlantName AS PlantName,
  CompanyCode.CompanyCodeName AS CompanyCodeName,
  OrderTypeName,
  Demand.ARunCancDteSupDlyTmeHrznCode AS ARunCancDteSupDlyTmeHrznCode,
  CancDteSupDlyHrznT.ARunCancDteSupDlyTmeHrznTxt AS ARunCancDteSupDlyTmeHrznTxt,
  Customer.CustomerName AS CustomerName,
  PurchaseOrderByCustomer,
  DeliveryBlockReason,
  Demand.ProductCharacteristic1 AS ProductCharacteristic1,
  CharValTexts1.RetailCharacteristicValueDesc AS ProductCharacteristic1Desc,
  Demand.ProductCharacteristic2 AS ProductCharacteristic2,
  CharValTexts2.RetailCharacteristicValueDesc AS ProductCharacteristic2Desc,
  Demand.ProductCharacteristic3 AS ProductCharacteristic3,
  CharValTexts3.RetailCharacteristicValueDesc AS ProductCharacteristic3Desc,
  OrganizationDivision,
  Demand.SalesOffice AS SalesOffice,
  SalesOffice.SalesOfficeName AS SalesOfficeName
FROM I_SupDmndOvwTotalDemandCube AS Demand
LEFT OUTER JOIN I_MaterialText AS MaterialText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialGroupText AS MatGrpText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DistributionChannelText AS DistChl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DivisionText AS Div ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesDistrictText AS SalesDist ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Plant AS Plant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS Customer ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesOfficeText AS SalesOffice ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunCancDteSupDlyHrznT AS CancDteSupDlyHrznT ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS Material ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RetailCharacteristicValueT AS CharValTexts1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RetailCharacteristicValueT AS CharValTexts2 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RetailCharacteristicValueT AS CharValTexts3 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DivisionText AS _OrganizationDivn ON OrganizationDivision = _OrganizationDivn.Division AND _OrganizationDivn.Language = $session.system_language  -- association [0..1]
;