I_CommodityOrderRequestVH

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_CommodityOrderRequestVH.
-- 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: ICMMDTYORDVH

CREATE VIEW I_CommodityOrderRequestVH AS
SELECT
  CommodityOrderRequest.CommodityOrderRequest AS CommodityOrderRequest,
  CommodityOrderRequest.CmmdtyOrderRequestType AS CmmdtyOrderRequestType,
  CommodityOrderRequest.CmmdtyOrderRequestReason AS CmmdtyOrderRequestReason,
  CommodityOrderRequest.CmmdtyOrderRequestStatus AS CmmdtyOrderRequestStatus,
  CommodityOrderRequest.CmmdtyOrderRequestSource AS CmmdtyOrderRequestSource,
  CmmdtyOrderReqType.CmmdtyOrderRequestKind AS CmmdtyOrderRequestKind,
  CommodityOrderRequest.CommoditySubAccount AS CommoditySubAccount,
  _CommodityOrderLeg.CmmdtyOrderRequestFlowType AS CmmdtyOrderRequestFlowType,
  _CommodityOrderLeg.CommodityDerivativeFuture AS CommodityDerivativeFuture,
  _CommodityOrderLeg.Commodity AS Commodity
FROM I_CommodityOrderRequest AS CommodityOrderRequest
LEFT OUTER JOIN I_CmmdtyOrderRequestType AS CmmdtyOrderReqType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmmdtyOrdReqStatusText AS CmmdtyOrdReqStatusText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmmdtyOrdReqSourceText AS CmmdtyOrdReqSourceText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CmmdtyOrdReqReasonText AS CmmdtyOrdReqReasonText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CommodityOrderLeg AS _CommodityOrderLeg ON CommodityOrderRequest.CommodityOrderRequestUUID = _CommodityOrderLeg.CommodityOrderRequestUUID  -- association [0..*]
;