I_SupAssgmtDmndDets

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_SupAssgmtDmndDets.
-- 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_SupAssgmtDmndDets AS
SELECT
  Demand.RequirementDocumentNumber AS RequirementDocumentNumber,
  Demand.RequirementDocumentItem AS RequirementDocumentItem,
  Demand.RequirementType AS RequirementType,
  Demand.RequestedDeliveryDate AS RequestedDeliveryDate,
  RequestedRqmtQtyInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  DeliveredQuantityInBaseUnit,
  ( OpenDemandQuantity - coalesce( _Assgmt.AssignedQuantityInBaseUnit , 0 ) ) AS OpenDemandQuantity,
  _Assgmt.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  _Assgmt.FixedQuantityInBaseUnit AS FixedQuantityInBaseUnit,
  _Assgmt.SupAssgmtReservedQtyInBaseUnit AS SupAssgmtReservedQtyInBaseUnit,
  _Assgmt.OnHoldQuantityInBaseUnit AS OnHoldQuantityInBaseUnit,
  _Assgmt.ReadyForReleaseQtyInBaseUnit AS ReadyForReleaseQtyInBaseUnit,
  _Assgmt.InboundAssignedQuantityInBsUnt AS InboundAssignedQuantityInBsUnt,
  Demand.BaseUnit AS BaseUnit,
  cast ( NetPriceAmount * OpenDemandQuantity as netwr ) AS ActlAmt,
  Demand.NetPriceAmount AS NetPriceAmount,
  DocumentCurrency,
  Demand.Material AS Material,
  Demand.MaterialGroup AS MaterialGroup,
  Demand.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  Demand.Plant AS Plant,
  case when Demand.SalesOrganization is initial then coalesce( _SupDmndPlant.SalesOrganization, '' ) else Demand.SalesOrganization end as SalesOrganization AS SalesOrganizationendasSalesOrganization,
  case when Demand.Division is initial then coalesce( _SupDmndPlant.Division, '' ) else Demand.Division end as Division AS DivisionendasDivision,
  case when Demand.SalesDistrict is initial then coalesce( _SupDmndPlant.SalesDistrict, '' ) else Demand.SalesDistrict end as SalesDistrict AS SalesDistrictendasSalesDistrict,
  case when Demand.CompanyCode is initial then coalesce( _SupDmndPlant.CompanyCode, '' ) else Demand.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  case when Demand.SoldToParty is initial then coalesce( _SupDmndPlant.PlantCustomer, '' ) else Demand.SoldToParty end as Customer AS SoldToPartyendasCustomer,
  case when Demand.ShippingPoint is initial then coalesce( _SupDmndPlant.ShippingPoint, '' ) else Demand.ShippingPoint end as ShippingPoint AS ShippingPointendasShippingPoint,
  FashionCancelDateHorizon,
  SupAssgmtOrdStatus,
  '01' AS SupAssgmtSource,
  CustomerGroup,
  CreationDate,
  FashionCancelDate,
  ShipToParty,
  RequirementSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  OrderType,
  OrderTypeName,
  StorageLocation,
  ShippingCondition,
  ShippingGroupRule,
  ShippingGroupNumber,
  ARunSupplyAssgmtReleaseRule,
  PartnerFunction,
  SalesDocumentItemCategory,
  DeliveryGroup,
  ItemBillingBlockReason,
  PurchasingDocument,
  PurchasingDocumentItem,
  Supplier,
  _Assgmt.ARunPhysSupAssgdQtyInBsUnt AS ARunPhysSupAssgdQtyInBsUnt,
  _Assgmt.ARunPhysSupReservedQtyInBsUnt AS ARunPhysSupReservedQtyInBsUnt
FROM P_SupAssgmtDmndDets AS Demand
LEFT OUTER JOIN P_SupAssgmtByDmndItem AS _Assgmt ON Demand.RequirementDocumentNumber = _Assgmt.RequirementDocumentNumber AND Demand.RequirementDocumentItem = _Assgmt.RequirementDocumentItem AND Demand.RequirementType = _Assgmt.RequirementType AND Demand.Material = _Assgmt.Material AND Demand.Plant = _Assgmt.Plant  -- association [0..1]
LEFT OUTER JOIN I_SupDmndOvwPlant AS _SupDmndPlant ON Plant = _SupDmndPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON Demand.RequirementDocumentNumber = _SalesDocumentItem.SalesDocument AND Demand.RequirementDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_StockTransportOrderItem AS _STONumberItemBasic ON Demand.RequirementDocumentNumber = _STONumberItemBasic.PurchaseOrder AND Demand.PurchasingDocumentItem = _STONumberItemBasic.PurchaseOrderItem  -- association [0..1]
;