I_CmmdtyOrdReqDocument

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_CmmdtyOrdReqDocument.
-- 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: ICMMDTYORDDOC

CREATE VIEW I_CmmdtyOrdReqDocument AS
SELECT
  Document.cmmdtyorderrequestdocumentuuid AS CmmdtyOrderRequestDocumentUUID,
  Document.commodityorderrequestuuid AS CommodityOrderRequestUUID,
  Document.commodityorderrequest AS CommodityOrderRequest,
  Document.cmmdtyordrequestdocumentitem AS CmmdtyOrdRequestDocumentItem,
  Document.cmmdtyordreqdocapplication AS CmmdtyOrdReqDocApplication,
  Document.cmmdtyordrequestdocumenttype AS CmmdtyOrdRequestDocumentType,
  Document.cmmdtyordreqdoccontracttype AS CmmdtyOrdReqDocContractType,
  Document.cmmdtyordreqdocpricingstatus AS CmmdtyOrdReqDocPricingStatus,
  Document.cmmdtyordreqdocpricinglot AS CmmdtyOrdReqDocPricingLot,
  Document.cmmdtyordreqdoctofillqty AS CmmdtyOrdReqDocToFillQty,
  Document.cmmdtyordreqdoctofillqtyunit AS CmmdtyOrdReqDocToFillQtyUnit,
  Document.cmmdtyordreqdocopnquantity AS CmmdtyOrdReqDocOpnQuantity,
  Document.cmmdtyordreqdocopnquantityunit AS CmmdtyOrdReqDocOpnQuantityUnit,
  Document.cmmdtyordreqdocsqncoffilling AS CmmdtyOrdReqDocSqncOfFilling,
  Document.cmmdtyordreqdocexternalid AS CmmdtyOrdReqDocExternalID,
  Document.cmmdtyorderfillprcgupdtstatus AS CmmdtyOrderFillPrcgUpdtStatus,
  Document.cmmdtyorddocloglrptgisupdtd AS CmmdtyOrdDocLoglRptgIsUpdtd,
  Document.commodityorderfillpacketuuid AS CommodityOrderFillPacketUUID,
  _CmmdtyOrdReqDocPrcgStsText.CmmdtyOrdReqDocPrcgStatusText AS CmmdtyOrdReqDocPrcgStatusText,
  Document.creationdatetime AS CreationDateTime,
  Document.lastchangedbyuser AS LastChangedByUser,
  Document.lastchangedatetime AS LastChangeDateTime
FROM cmmfdor_d_doc AS Document
LEFT OUTER JOIN I_CmmdtyOrdReqDocPrcgStsText AS _CmmdtyOrdReqDocPrcgStsText ON Document.cmmdtyordreqdocpricingstatus = _CmmdtyOrdReqDocPrcgStsText.CmmdtyOrdReqDocPricingStatus  -- association [0..1]
;