SEPMRA_C_Shop_ShoppingCart

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 SEPMRA_C_Shop_ShoppingCart.
-- 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 SEPMRA_C_Shop_ShoppingCart AS
SELECT
  ShoppingCart.ShoppingCartUUID AS ShoppingCartUUID,
  ShoppingCart.Owner AS Owner,
  cast( sum(_ShoppingCartItems.NetAmountInCompanyCurrency) as snwd_ttl_net_amount preserving type ) AS NetAmountInCompanyCurrency,
  cast( ShoppingCart._Owner._Company.CompanyCurrency as sepmra_currency preserving type ) AS CompanyCurrency,
  cast( sum(_ShoppingCartItems.Quantity) as sepmra_quantityasint preserving type ) AS Quantity,
  cast('EA' as sepmra_quantityunit) AS QuantityUnit,
  _Owner._EmployeeOrgAssignmentToday._OrganizationalUnit._Address.FormattedAddress AS DeliveryAddress,
  ShoppingCart._Owner AS _Owner
FROM SEPMRA_I_ShoppingCart AS ShoppingCart
LEFT OUTER JOIN SEPMRA_C_Shop_ShoppingCartItem AS _ShoppingCartItems ON ShoppingCartUUID = _ShoppingCartItems.ShoppingCartUUID  -- association [0..*]
LEFT OUTER JOIN SEPMRA_I_QuantityUnit AS _QuantityUnit ON QuantityUnit = _QuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCurrency ON CompanyCurrency = _CompanyCurrency.Currency  -- association [0..1]
;