I_CmmdtyOrdReqBracketItmTP

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_CmmdtyOrdReqBracketItmTP.
-- 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: ICMMDTYORDBKTITP

CREATE VIEW I_CmmdtyOrdReqBracketItmTP AS
SELECT
  CmmdtyOrdReqBracketItem.CmmdtyOrderReqBracketItemUUID AS CmmdtyOrderReqBracketItemUUID,
  CmmdtyOrdReqBracketItem.CommodityOrderRequestUUID AS CommodityOrderRequestUUID,
  cast( CmmdtyOrdReqBracketItem.CommodityOrderRequest as cmmfdor_orderrequestid preserving type ) AS CommodityOrderRequest,
  cast( CmmdtyOrdReqBracketItem.CmmdtyOrderRequestType as cmmfdor_ordertype preserving type ) AS CmmdtyOrderRequestType,
  cast( CmmdtyOrdReqBracketItem.CmmdtyOrderRequestReason as cmmfdor_orderrequestrsn preserving type ) AS CmmdtyOrderRequestReason,
  cast(CmmdtyOrdReqBracketItem.CmmdtyOrderRequestStatus as cmmfdor_ordstatus preserving type ) AS CmmdtyOrderRequestStatus,
  CmmdtyOrdReqBracketItem.CmmdtyOrdReqToPriceTotQty AS CmmdtyOrdReqToPriceTotQty,
  CmmdtyOrdReqBracketItem.CmmdtyOrderRequestQuantityUnit AS CmmdtyOrdReqToPriceTotQtyUnit,
  CmmdtyOrdReqBracketItem.CmmdtyOrderRequestQuantity AS CmmdtyOrderRequestQuantity,
  CmmdtyOrdReqBracketItem.CmmdtyOrderRequestQuantityUnit AS CmmdtyOrderRequestQuantityUnit,
  CmmdtyOrdReqBracketItem.CommoditySubAccountName AS CommoditySubAccountName,
  CmmdtyOrdReqBracketItem.CmmdtyOrdReqDocOpnQuantityUnit AS CmmdtyOrdReqDocOpnQuantityUnit,
  CmmdtyOrdReqBracketItem.CommodityOrderRequestDocument AS CommodityOrderRequestDocument,
  CmmdtyOrdReqBracketItem.CmmdtyOrdReqDocApplication AS CmmdtyOrdReqDocApplication,
  CmmdtyOrdReqBracketItem.CmmdtyOrdRequestDocumentType AS CmmdtyOrdRequestDocumentType,
  CmmdtyOrdReqBracketItem.CmmdtyOrdReqDocContractType AS CmmdtyOrdReqDocContractType,
  CmmdtyOrdReqBracketItem.NumberOfDocuments AS NumberOfDocuments,
  CmmdtyOrdReqBracketItem.CreationDateTime AS CreationDateTime,
  CmmdtyOrdReqBracketItem.LastChangedByUser AS LastChangedByUser,
  CmmdtyOrdReqBracketItem.LastChangeDateTime AS LastChangeDateTime
FROM I_CmmdtyOrdReqBracketItm AS CmmdtyOrdReqBracketItem
LEFT OUTER JOIN I_CmmdtyOrdReqBracketTP AS _CmmdtyOrdReqBracket ON CmmdtyOrderRequestBracketUUID = _CmmdtyOrdReqBracket.CmmdtyOrderRequestBracketUUID  -- association [1..1]
;