I_ExcessRqmtQtySlsDocMainItm

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_ExcessRqmtQtySlsDocMainItm.
-- 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: IEXRQMTSDMITM

CREATE VIEW I_ExcessRqmtQtySlsDocMainItm AS
SELECT
  item.SalesDocument AS SalesDocument,
  item.SalesDocumentItem AS SalesDocumentItem,
  cast ( case when OrderToBaseQuantityDnmntr > 0 then _AggregatedScheduleLine.RequestedQuantity * division(OrderToBaseQuantityNmrtr,OrderToBaseQuantityDnmntr,2) else _AggregatedScheduleLine.RequestedQuantity end as abap.quan(15,3)) as RequestedQuantityInBaseUnit AS quan153asRequestedQuantityInBaseUnit,
  cast ( case when OrderToBaseQuantityDnmntr > 0 then _AggregatedScheduleLine.ConfdOrderQtyByMatlAvailCheck * division(OrderToBaseQuantityNmrtr,OrderToBaseQuantityDnmntr,2) else _AggregatedScheduleLine.ConfdOrderQtyByMatlAvailCheck end as abap.quan(15,3)) as ConfirmedRqmtQtyInBaseUnit AS quan153asConfirmedRqmtQtyInBaseUnit,
  _AggregatedScheduleLine.DeliveredQuantityInBaseUnit AS DeliveredQuantityInBaseUnit,
  coalesce(_AssignedSalesItem.AssignedQuantityInBaseUnit,0) AS AssignedQuantityInBaseUnit,
  coalesce(_AcctAssgdQty.AlignedPurOrdItmQtyInBaseUoM,0) AS AlignedPurOrdItmQtyInBaseUoM,
  RequestedRqmtQtyInBaseUnit AS OpenContrRefQtyInBsUnt,
  (RequestedRqmtQtyInBaseUnit - _AggregatedScheduleLine.ConfirmedRqmtQtyInBaseUnit) AS OpenForConfQtyInBaseUnit,
  PurchaseRequisition,
  item.ShipToParty AS ShipToParty,
  tvak.fsh_msoind AS MultiShipToOrdType
FROM I_RFM_SalesDocumentItem AS item
INNER JOIN tvak ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunSalesDocItmAssgdQty AS _AssignedSalesItem ON SalesDocument = _AssignedSalesItem.RequirementDocumentNumber AND SalesDocumentItem = _AssignedSalesItem.RequirementDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_ExcessRqmtAcctAssgdAggrgdQty AS _AcctAssgdQty ON SalesDocument = _AcctAssgdQty.SalesDocument AND SalesDocumentItem = _AcctAssgdQty.SalesDocumentItem  -- association [0..1]
;