C_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 C_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: CMRPSALESORDER

CREATE VIEW C_MRPSalesOrder AS
SELECT
  I_MRPSalesOrder.SalesOrder AS SalesOrder,
  I_MRPSalesOrder.SalesOrderItem AS SalesOrderItem,
  I_MRPSalesOrder.ScheduleLine AS SalesOrderScheduleLine,
  I_MRPSalesOrder.SalesOrder AS SDDocument,
  I_MRPSalesOrder.MRPPlant AS MRPPlant,
  I_MRPSalesOrder.Material AS Material,
  I_MRPSalesOrder.MaterialName AS MaterialName,
  I_MRPSalesOrder.DeliveryIsBlocked AS DeliveryIsBlocked,
  I_MRPSalesOrder.BaseUnit AS BaseUnit,
  I_MRPSalesOrder.SalesUnit AS SalesUnit,
  I_MRPSalesOrder.DeliveredQtyInOrderQtyUnit AS DeliveredQtyInOrderQtyUnit,
  case when I_MRPSalesOrder.OpenReqdDelivQtyInBaseUnit > 0 then I_MRPSalesOrder.CorrectedQtyInBaseUnit - I_MRPSalesOrder.OpenReqdDelivQtyInBaseUnit else cast(0 as abap.quan( 13, 3 )) end as DeliveredQuantityInBaseUnit AS quan133endasDeliveredQuantityInBaseUnit,
  I_MRPSalesOrder.OpenConfdDelivQtyInBaseUnit AS OpenConfdDelivQtyInBaseUnit,
  I_MRPSalesOrder.OpenConfdDelivQtyInOrdQtyUnit AS OpenConfdDelivQtyInOrdQtyUnit,
  I_MRPSalesOrder.ConfirmationTotalQuantity AS ConfirmationTotalQuantity,
  I_MRPSalesOrder.ConfirmedQuantity AS ConfirmedQuantity,
  I_MRPSalesOrder.CorrectedQtyInBaseUnit AS OrderQuantity,
  I_MRPSalesOrder.OpenQuantity AS OpenQuantity,
  I_MRPSalesOrder.Customer AS Customer,
  I_MRPSalesOrder.CustomerName AS CustomerName,
  cast('' as ad_namtext) AS ContactPersonName,
  cast('' as ad_tlnmbr1) AS ContactPersonPhoneNumber,
  cast('' as ad_smtpadr) AS InternalContactEmailAddress,
  I_MRPSalesOrder.SalesOrderDate AS SalesOrderDate,
  I_MRPSalesOrder.ProductAvailabilityDate AS ProductAvailabilityDate,
  I_MRPSalesOrder.RequestedDeliveryDate AS RequestedDeliveryDate,
  I_MRPSalesOrder.LoadingDate AS LoadingDate,
  I_MRPSalesOrder.DeliveryPriority AS DeliveryPriority,
  I_MRPSalesOrder.DeliveryPriorityDesc AS DeliveryPriorityDesc,
  I_MRPSalesOrder.DeliveryBlockReason AS DeliveryBlockReason,
  _DeliveryBlockReason._Text[1: Language = $session.system_language ].DeliveryBlockReasonText AS DeliveryBlockReasonText,
  I_MRPSalesOrder.MaterialByCustomer AS MaterialByCustomer,
  I_MRPSalesOrder._WBSElementBasicData.WBSElementExternalID AS WBSElement,
  I_MRPSalesOrder._WBSElementBasicData.WBSDescription AS WBSDescription,
  cast( I_MRPSalesOrder._ProjectRespPersn.PersonWorkAgreement as ps_s4_vernr preserving type ) AS ResponsiblePerson,
  I_MRPSalesOrder._ProjectRespPersn._WorkforcePerson.PersonFullName AS ResponsiblePersonName,
  I_MRPSalesOrder._WBSElementBasicData._Project.ProjectExternalID AS Project,
  cast( I_MRPSalesOrder._WBSElementBasicData.ProjectInternalID as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  I_MRPSalesOrder._WBSElementBasicData._Project.ProjectDescription AS ProjectDescription,
  '' AS TopLevelOrder,
  '' AS TopLevelOrderMaterial,
  '' AS TopLevelOrderMaterialName
FROM I_MRPSalesOrder
LEFT OUTER JOIN C_Salesorderfs AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
;