I_CmmdtyPrcgPriceFixationGroup

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_CmmdtyPrcgPriceFixationGroup.
-- 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 I_CmmdtyPrcgPriceFixationGroup AS
SELECT
  prcfixgrp_guid AS CmmdtyPrcgPrcFixationGroupUUID,
  prcfixset_guid AS CmmdtyPrcgPriceFixationSetUUID,
  group_id AS CmmdtyPrcgPriceFixationGroupID,
  status AS CmmdtyPrcgPriceFixationStatus,
  pricequantity AS PriceFixationGroupQuantity,
  priceunit AS PriceFixationGroupQuantityUnit,
  statuslastchangedon AS PrcFixationStsLastChgdDateTime,
  statuschangedtoflat AS PrcFxtnStsFlatCreationDateTime,
  status_icon AS PriceFixationGroupStatusIcon,
  dcsid AS PriceFixationGroupDCSID,
  mic AS PrcFxtnGrpMarketIdentifierCode,
  maturitykeydate AS PrcFxtnGroupMaturityKeyDate,
  contractmaturitycode AS PrcFxtnGrpContractMaturityCode,
  parent_group_guid AS OriginalPriceFixationGroupUUID,
  total_price_doc_curr AS PriceFixationDocumentCurrency,
  total_price_doc_prun AS PrcFxtnDocumentRatePerQuantity,
  total_price_doc_uom AS PrcFxtnDocRateQuantityUnit,
  total_price_in_doc_curr AS PriceFixationTotalPrice,
  cumltv_basis_price AS PrcFxtnCumulativeBasisPrice,
  settled_quantity AS PrcFxtnGrpSettledQuantity,
  fill_sequence AS PriceFixationFillSequenceValue,
  overfill AS PriceFixationGroupOverfill,
  cancelledquantity AS PrcFxtnGroupCancelledQuantity,
  is_cdote_order_open AS PrFxtnGrpCmmdtyDrvtvOrdIsOpen,
  masscdoteorderrequeststatus AS PrcFxtnGrpMassCDOTEOrdReqSts
FROM cpe_prcfixgrp
LEFT OUTER JOIN I_CmmdtyPrcgPrcFixationGrpComp AS _CmmdtyPrcgPrcFixationGrpComp ON CmmdtyPrcgPrcFixationGroupUUID = _CmmdtyPrcgPrcFixationGrpComp.CmmdtyPrcgPrcFixationGroupUUID  -- association [0..*]
LEFT OUTER JOIN I_CmmdtyPrcgPriceFixationSet AS _CmmdtyPrcgPriceFixationSet ON CmmdtyPrcgPriceFixationSetUUID = _CmmdtyPrcgPriceFixationSet.CmmdtyPrcgPriceFixationSetUUID  -- association [1..1]
LEFT OUTER JOIN I_CmmdtyPrcgPrcFxtnGrpStsText AS _PrcFxtnGrpStsText ON CmmdtyPrcgPriceFixationStatus = _PrcFxtnGrpStsText.CmmdtyPrcgPriceFixationStatus  -- association [1..*]
;