I_MRPSalesOrder

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_MRPSalesOrder.
-- 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.
-- SQL view name: IMRPSALESORDER

CREATE VIEW I_MRPSalesOrder AS
SELECT
  SalesOrder,
  SalesOrderItem,
  ScheduleLine,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.SalesOrderDate AS SalesOrderDate,
  _SalesOrderItem.Plant AS MRPPlant,
  _SalesOrderItem.Material AS Material,
  _SalesOrderItem._Material._Text[1: Language = $session.system_language ].MaterialName AS MaterialName,
  _SalesOrderItem.WBSElementInternalID AS WBSElementInternalID,
  _SalesOrder._SoldToParty.Customer AS Customer,
  _SalesOrder._SoldToParty.BPCustomerName AS CustomerName,
  _SalesOrder._SoldToParty.BPCustomerFullName AS CustomerFullName,
  _SalesOrder._SoldToParty._StandardAddress.PhoneNumber AS PhoneNumber,
  _SalesOrder._SoldToParty._StandardAddress._DefaultEmailAddress.EmailAddress AS EmailAddress,
  _SalesOrderItem.MaterialByCustomer AS MaterialByCustomer,
  BaseUnit,
  _SalesOrderItem.DeliveryDateQuantityIsFixed AS DeliveryDateQuantityIsFixed,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrderItem.Division AS Division,
  _SalesOrder._DeliveryBlockReason._Text[1: Language = $session.system_language ].DeliveryBlockReasonText AS DeliveryBlockReasonText,
  RequestedDeliveryDate,
  ProductAvailabilityDate,
  ScheduleLineOrderQuantity AS OrderQuantity,
  ConfdOrderQtyByMatlAvailCheck AS ConfirmedQuantity,
  OrderQuantityUnit AS SalesUnit,
  ConfdOrderQtyByMatlAvailCheck AS ConfirmationTotalQuantity,
  DeliveredQtyInOrderQtyUnit,
  DeliveredQuantityInBaseUnit,
  OpenConfdDelivQtyInBaseUnit,
  OpenConfdDelivQtyInOrdQtyUnit,
  RequestedRqmtQtyInBaseUnit AS OpenQuantity,
  OpenReqdDelivQtyInBaseUnit,
  case when OrderToBaseQuantityNmrtr > 0 then cast(CorrectedQtyInOrderQtyUnit * (cast(OrderToBaseQuantityNmrtr as abap.decfloat16) / cast(OrderToBaseQuantityDnmntr as abap.decfloat16)) as abap.quan( 13, 3 )) else cast(0 as abap.quan( 13, 3 )) end as CorrectedQtyInBaseUnit AS quan133endasCorrectedQtyInBaseUnit,
  LoadingDate,
  _SalesOrderItem.DeliveryPriority AS DeliveryPriority,
  _SalesOrderItem._DeliveryPriority._Text[1: Language = $session.system_language ].DeliveryPriorityDesc AS DeliveryPriorityDesc
FROM I_SalesOrderScheduleLine
LEFT OUTER JOIN I_CustomerMaterial AS _CustomerMaterialInfoRecord ON salesorganization = _CustomerMaterialInfoRecord.SalesOrganization AND distributionchannel = _CustomerMaterialInfoRecord.DistributionChannel AND customer = _CustomerMaterialInfoRecord.Customer AND material = _CustomerMaterialInfoRecord.Material  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON wbselementinternalid = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_EntProjectResponsiblePerson AS _ProjectRespPersn ON wbselementinternalid = _ProjectRespPersn.WBSElementInternalID AND _ProjectRespPersn.WBSElementInternalID is not initial  -- association [1..1]
;