C_CmmdtyOrdReqBracketTP

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_CmmdtyOrdReqBracketTP.
-- 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: CCMMDTYORDBKTTP

CREATE VIEW C_CmmdtyOrdReqBracketTP AS
SELECT
  cast( OrderRequestBracket.CmmdtyBracketFilledQtyMsgText as cmmfdor_orderbracketinfomsg preserving type ) AS CmmdtyBracketFilledQtyMsgText,
  cast( OrderRequestBracket.CmmdtyBracketPricedQtyMsgText as cmmfdor_orderbracketinfomsg2 preserving type ) AS CmmdtyBracketPricedQtyMsgText,
  OrderRequestBracket.CmmdtyOrderRequestQuantityUnit AS CmmdtyOrderRequestQuantityUnit,
  OrderRequestBracket.CmmdtyOrdReqToPriceTotQtyUnit AS CmmdtyOrdReqToPriceTotQtyUnit,
  OrderRequestBracket.CmmdtyOrdBracketFilledQtyUnit AS CmmdtyOrdBracketFilledQtyUnit,
  OrderRequestBracket.CmmdtyOrdBracketPricedQtyUnit AS CmmdtyOrdBracketPricedQtyUnit,
  OrderRequestBracket.CmmdtyBracketFillQtyIsVisible AS CmmdtyBracketFillQtyIsVisible,
  OrderRequestBracket.CmmdtyBracketPrcdQtyIsVisible AS CmmdtyBracketPrcdQtyIsVisible,
  OrderRequestBracket.ActiveFlag AS ActiveFlag,
  OrderRequestBracket.CreatedByUserName AS CreatedByUserName,
  OrderRequestBracket.CreationDateTime AS CreationDateTime,
  OrderRequestBracket.CreationDateDecimalValue AS CreationDateDecimalValue,
  OrderRequestBracket.LastChangedByUser AS LastChangedByUser,
  OrderRequestBracket.LastChangedByUserName AS LastChangedByUserName,
  OrderRequestBracket.LastChangeDateTime AS LastChangeDateTime,
  OrderRequestBracket.LastChangeDate AS LastChangeDate,
  OrderRequestBracket.CmmdtyDrvtvOrdTrdExecIsRecent AS CmmdtyDrvtvOrdTrdExecIsRecent,
  _AssignedOrderCount.CmmdtyOrdBracketNrOfAssgdOrds AS CmmdtyOrdBracketNrOfAssgdOrds,
  _CmmdtyOrderBracketType.CmmdtyOrderRequestBracketText AS CmmdtyOrderRequestBracketText
FROM I_CmmdtyOrdReqBracketTP AS OrderRequestBracket
LEFT OUTER JOIN I_CmmdtyOrdBracketTypeVH AS _CmmdtyOrderBracketType ON CmmdtyOrderRequestBracketType = _CmmdtyOrderBracketType.CmmdtyOrderRequestBracketType  -- association [0..1]
LEFT OUTER JOIN C_CmmdtyOrdReqBracketItmTP AS _CommodityOrderReqBracketItem ON CmmdtyOrderRequestBracketUUID = _CommodityOrderReqBracketItem.CmmdtyOrderRequestBracketUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyAssgdOrderReqByBracket AS _AssignedOrderCount ON CmmdtyOrderRequestBracketUUID = _AssignedOrderCount.CmmdtyOrderRequestBracketUUID  -- association [0..*]
LEFT OUTER JOIN E_CommodityOrderRequestBracket AS _Extension ON CmmdtyOrderRequestBracketUUID = _Extension.CmmdtyOrderRequestBracketUUID  -- association [0..1]
;