C_Nomination

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_Nomination.
-- 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: CNOMINATION

CREATE VIEW C_Nomination AS
SELECT
  NominationDoc,
  NominationExtNumber,
  NominationType,
  NominationPipelineCycleID,
  TransportSystem,
  VehicleIdentifier,
  NominationHeaderStatus,
  VehicleId,
  NominationCarrier,
  NominationShipper,
  BulkShipmentType,
  TransportationPlanningPoint,
  InTransitPlantStorageLoc,
  InTransitPlant,
  InTransitStorageLocation,
  NominationCreatedByUser,
  NominationCreationDate,
  LastChangedByUser,
  NominationChangedDate,
  NominationUnitOfMeasure,
  NominationModeOfTransport,
  NominationDocIsBlocked
FROM I_NominationHeader
LEFT OUTER JOIN C_NominationItem AS _NominationItem ON NominationDoc = _NominationItem.NominationDoc  -- association [0..*]
LEFT OUTER JOIN C_NominationApplLog AS _NominationApplLog ON NominationDoc = _NominationApplLog.NominationDoc  -- association [0..*]
LEFT OUTER JOIN C_NominationTicketItem AS _NominationTicketItm ON NominationDoc = _NominationTicketItm.NominationDoc  -- association [0..*]
;