I_NominationHeaderFld

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_NominationHeaderFld.
-- 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: INOMHDRFLD

CREATE VIEW I_NominationHeaderFld AS
SELECT
  nomtk AS NominationDoc,
  nomtyp AS NominationType,
  nomnr AS NominationExtNumber,
  nomst AS NominationHeaderStatus,
  tsyst AS TransportSystem,
  cycle AS NominationPipelineCycleID,
  nmvehicle AS VehicleId,
  nmcarrier AS NominationCarrier,
  nmshipper AS NominationShipper,
  unit AS NominationUnitOfMeasure,
  nmshtype AS BulkShipmentType,
  tplst AS TransportationPlanningPoint,
  nmwerk AS InTransitPlant,
  nmlgort AS InTransitStorageLocation,
  vktra AS NominationModeOfTransport,
  nmvessel AS VehicleIdentifier,
  ernam AS NominationCreatedByUser,
  erdat AS NominationCreationDate,
  aedat AS NominationChangedDate,
  aenam AS LastChangedByUser,
  bustyp AS BusinessType,
  nmselect AS NominationDocIsBlocked,
  route AS ShippingRoute,
  bookts AS IsBookedTransportSystem,
  ev_group AS NominationEventDefaultGroup,
  unit AS NominationHeaderUom,
  sentdat AS NominationLastHeaderActionDate
FROM oijnomh
LEFT OUTER JOIN E_NominationHeader AS _NominationHeaderExtension ON NominationDoc = _NominationHeaderExtension.NominationDoc  -- association [0..1]
;