I_NominationDetail

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_NominationDetail.
-- 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: INOMDET

CREATE VIEW I_NominationDetail AS
SELECT
  NominationHeader.NominationDoc AS NominationDoc,
  NominationItem.NominationDocItem AS NominationDocItem,
  NominationHeader.NominationType AS NominationType,
  NominationHeader.NominationExtNumber AS NominationExtNumber,
  cast('' as abap.char(2)) AS NominationAIFStatus,
  NominationHeader.TransportSystem AS TransportSystem,
  Transport.TransportSystemName AS TransportSystemName,
  NominationHeader.VehicleId AS VehicleId,
  NominationItem.NominationScheduleDate AS NominationScheduleDate,
  NominationItem.NominationScheduleType AS NominationScheduleType,
  cast('' as abap.char(36)) AS NominationScheduleTypeDesc,
  NominationItem.ScheduledMaterial AS ScheduledMaterial,
  NominationMaterial.MaterialName AS MaterialDesc,
  NominationItem.ScheduledQuantity AS ScheduledQuantity,
  NominationItem.ScheduledQuantityUnit AS ScheduledQuantityUnit,
  NominationItem.LocationId AS LocationId,
  NominationLocation.LocationName AS LocationName,
  NominationItem.ContractPartner AS ContractPartner,
  NominationItem.OilLocationPartnerPlant AS OilLocationPartnerPlant,
  NominationItem.OilLocationPartnerStorageLoc AS OilLocationPartnerStorageLoc,
  cast('' as abap.char(1)) AS UserIsDeleteAuthorized
INNER JOIN I_NominationHeaderFld AS NominationHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_NominationMblEvtsConfign AS NominationEvtConfig ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationLocationVH AS NominationLocation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SwText AS NominationMaterial ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationTransptSystVH AS Transport ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationEvent AS _NomEvent ON _NomEvent.NominationDoc = NominationDoc AND _NomEvent.NominationDocItem = NominationDocItem  -- association [1..*]
;