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
  _CmmdtyOrderBracketType.CmmdtyOrderRequestBracketText AS CmmdtyOrderRequestBracketText,
  OrderRequestBracket.CmmdtyOrderRequestQuantityUnit AS CmmdtyOrderRequestQuantityUnit,
  OrderRequestBracket.CmmdtyOrdReqToPriceTotQtyUnit AS CmmdtyOrdReqToPriceTotQtyUnit,
  OrderRequestBracket.CmmdtyOrdBracketFilledQtyUnit AS CmmdtyOrdBracketFilledQtyUnit,
  OrderRequestBracket.CmmdtyOrdBracketPricedQtyUnit AS CmmdtyOrdBracketPricedQtyUnit,
  OrderRequestBracket.CmmdtyBracketFillQtyIsVisible AS CmmdtyBracketFillQtyIsVisible,
  OrderRequestBracket.CmmdtyBracketPrcdQtyIsVisible AS CmmdtyBracketPrcdQtyIsVisible,
  cast( OrderRequestBracket.CmmdtyBracketFilledQtyMsgText as cmmfdor_orderbracketinfomsg preserving type ) AS CmmdtyBracketFilledQtyMsgText,
  cast( OrderRequestBracket.CmmdtyBracketPricedQtyMsgText as cmmfdor_orderbracketinfomsg2 preserving type ) AS CmmdtyBracketPricedQtyMsgText,
  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
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]
;