I_DemandNominationScheduleTP

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_DemandNominationScheduleTP.
-- 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: IDMNDNOMSCHEDTP

CREATE VIEW I_DemandNominationScheduleTP AS
SELECT
  NominationDoc,
  NominationDocItem,
  LocationId,
  ScheduledMaterial,
  _ScheduledMaterialVH.MaterialDesc AS MaterialDesc,
  NominationScheduleDate,
  ScheduledQuantity,
  ScheduledQuantityUnit,
  TransportSystem,
  TransportationVehicle,
  NominationScheduleType,
  NominationReferenceDocType,
  NominationReferenceDocument,
  NominationReferenceDocItem,
  NominationExtNumber,
  ModeOfTransport,
  DemandNominationSchedSrceType,
  CreatedByUser,
  NominationScheduleCreationDate,
  NominationCreationTime,
  cast(dats_tims_to_tstmp( NominationScheduleCreationDate, NominationCreationTime, abap_user_timezone( $session.user,$session.client, 'NULL' ), $session.client, 'NULL' ) as timestamp ) as CreationDateTime AS clientNULLastimestampasCreationDateTime,
  NominationSimlnID,
  NominationSimlnLineItm,
  NominationSimlnVersion,
  NominationDocIsBlocked
FROM I_DemandNominationSchedule AS _DemandNominationSchedule
LEFT OUTER JOIN I_SourceNominationScheduleTP AS _SourceNominationSchedule ON _SourceNominationSchedule.NominationDoc = NominationDoc AND _SourceNominationSchedule.NominationDocItem = NominationDocItem  -- association [0..*]
LEFT OUTER JOIN I_NominationLocation AS _NominationLocation ON _NominationLocation.LocationId = LocationId  -- association [0..1]
LEFT OUTER JOIN I_ScheduledMaterialVH AS _ScheduledMaterialVH ON _ScheduledMaterialVH.ScheduledMaterial = ScheduledMaterial  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON _MaterialText.Material = ScheduledMaterial  -- association [0..*]
LEFT OUTER JOIN I_ModeOfTransportText AS _ModeOfTransportText ON _ModeOfTransportText.ModeOfTransport = ModeOfTransport  -- association [0..*]
LEFT OUTER JOIN I_ModeOfTransportVH AS _ModeOfTransportVH ON _ModeOfTransportVH.ModeOfTransport = ModeOfTransport  -- association [0..1]
LEFT OUTER JOIN I_ScheduledQuantityUoMVH AS _ScheduledQuantityUoMVH ON _ScheduledQuantityUoMVH.ScheduledQuantityUnit = ScheduledQuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_NominationScheduleUserText AS _NominationScheduleUserText ON _NominationScheduleUserText.NominationSchedUserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN E_DemandNominationSchedule AS _DemandNomExtension ON NominationSimlnID = _DemandNomExtension.NominationSimlnID AND NominationSimlnLineItm = _DemandNomExtension.NominationSimlnLineItm AND NominationSimlnVersion = _DemandNomExtension.NominationSimlnVersion  -- association [1..1]
LEFT OUTER JOIN E_NominationHeader AS _NominationHeaderExtension ON NominationDoc = _NominationHeaderExtension.NominationDoc  -- association [1..1]
LEFT OUTER JOIN E_NominationItem AS _NominationItemExtension ON NominationDoc = _NominationItemExtension.NominationDoc AND NominationDocItem = _NominationItemExtension.NominationDocItem  -- association [1..1]
;