I_ACMNominationDelivUoM

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_ACMNominationDelivUoM.
-- 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: IACMNOMDLVUOMCNV

CREATE VIEW I_ACMNominationDelivUoM AS
SELECT
  ACMNominationDelivAssgmt.NominationKey AS NominationKey,
  ACMNominationDelivAssgmt.NominationDocItem AS NominationDocItem,
  ACMNominationDelivAssgmt.LoadDataCaptureObjId AS LoadDataCaptureObjId,
  BpUomConfig.PreferredUnitOfMeasure AS PreferredUnitOfMeasure
FROM I_ACMNominationDelivAssgmt AS ACMNominationDelivAssgmt
INNER JOIN I_ACMNomination AS ACMNomination ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMNominationItem AS ACMNominationItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMBusPartUoMConfign AS BpUomConfig ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMNomination AS _ACMNomination ON NominationKey = _ACMNomination.NominationKey  -- association [1..1]
LEFT OUTER JOIN I_ACMNominationItem AS _ACMNominationItem ON NominationKey = _ACMNominationItem.NominationKey AND NominationDocItem = _ACMNominationItem.NominationDocItem  -- association [1..1]
;