I_DemandNominationSchedule

DDL: I_DEMANDNOMINATIONSCHEDULE SQL: IDEMANDNOMSCHED Type: view COMPOSITE
43 Fields 3 Data Sources 4 Associations

Demand Schedule

I_DemandNominationSchedule is a Composite CDS View that provides data about "Demand Schedule" in SAP S/4HANA. It reads from 3 data sources (I_NominationItemFld, I_NominationSimulation, I_NominationHeaderFld) and exposes 43 fields with key fields NominationDoc, NominationDocItem, NominationDocItem. It has 4 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_NominationItemFld _DestinationNominationItem union
I_NominationSimulation _DestNominationSimulation from
I_NominationHeaderFld _Header inner

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_NominationSimulation _SourceNominationSimulation _SourceNominationSimulation.NominationDoc = _DestNominationSimulation.NominationDoc and _SourceNominationSimulation.ScheduledMaterial = _DestNominationSimulation.ScheduledMaterial and _SourceNominationSimulation.ScheduledDate <= _DestNominationSimulation.ScheduledDate and _SourceNominationSimulation.NominationScheduleType = 'O'
[0..1] I_NominationSchedldMvtPegging _NominationSchedldMvtPegging _NominationSchedldMvtPegging.NominationDoc = $projection.NominationDoc and _NominationSchedldMvtPegging.NominationDocItem = $projection.NominationDocItem and _NominationSchedldMvtPegging.NominationPegType = 'CN'
[0..1] I_NominationSimulation _NominationSimulation _NominationSimulation.NominationDoc = $projection.NominationDoc and _NominationSimulation.NominationDocItem = $projection.NominationDocItem
[0..1] I_NominationItemFld _SourceItem _SourceItem.NominationDoc = _DestinationNominationItem.NominationDoc and _SourceItem.ScheduledMaterial = _DestinationNominationItem.ScheduledMaterial and _SourceItem.NominationScheduleDate <= _DestinationNominationItem.NominationScheduleDate and _SourceItem.NominationScheduleType = 'O' and _SourceItem.NominationIsMarkedForDeletion = ''

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDEMANDNOMSCHED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Demand Schedule view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc NominationDoc Nomination key
KEY NominationDocItem NominationDocItem Nom. key item
LocationId LocationId Location ID
ScheduledMaterial ScheduledMaterial Single-Character Flag
NominationScheduleDate ScheduledDate Single-Character Flag
ScheduledQuantity ScheduledQuantity Scheduled Qty
ScheduledQuantityUnit ScheduledQuantityUnit SchedUoM
TransportSystem TransportSystem Transport System
TransportationVehicle I_NominationSimulation TransportationVehicle Vehicle Number
NominationScheduleType NominationScheduleType Sched.type
NominationReferenceDocType NominationReferenceDocType Single-Character Flag
NominationReferenceDocument I_NominationSimulation NominationReferenceDocument Well doc.no.
NominationReferenceDocItem I_NominationSimulation NominationReferenceDocItem Single-Character Flag
NominationExtNumber NominationExtNumber Single-Character Flag
ModeOfTransport ModeOfTransport Single-Character Flag
CreatedByUser CreatedByUser User Name
NominationScheduleCreationDate NominationScheduleCreationDate Entered On
NominationCreationTime NominationCreationTime Time created
NominationSimlnID NominationSimlnID Sim ID
NominationSimlnLineItm NominationSimlnLineItm Sim Line
NominationSimlnVersion NominationSimlnVersion Sim Version
NominationDoc Nomination key
KEY NominationDocItem NominationDocItem Nom. key item
LocationId LocationId Location ID
ScheduledMaterial ScheduledMaterial Single-Character Flag
NominationScheduleDate NominationScheduleDate Single-Character Flag
ScheduledQuantity ScheduledQuantity Scheduled Qty
ScheduledQuantityUnit ScheduledQuantityUnit SchedUoM
TransportSystem I_NominationItemFld TransportSystem Transport System
TransportationVehicle I_NominationHeaderFld VehicleId Vehicle Number
NominationScheduleType NominationScheduleType Sched.type
NominationReferenceDocType NominationReferenceDocType Single-Character Flag
NominationReferenceDocument I_NominationItemFld NominationReferenceDocument Well doc.no.
NominationReferenceDocItem I_NominationItemFld NominationReferenceDocItem Single-Character Flag
NominationExtNumber I_NominationHeaderFld NominationExtNumber Single-Character Flag
ModeOfTransport I_NominationHeaderFld NominationModeOfTransport Single-Character Flag
CreatedByUser I_NominationHeaderFld NominationCreatedByUser User Name
NominationScheduleCreationDate I_NominationHeaderFld NominationCreationDate Entered On
NominationCreationTime I_NominationItemFld NominationCreationTime Time created
NominationSimlnID Sim ID
NominationSimlnLineItm Sim Line
NominationSimlnVersion Sim Version
NominationDocIsBlocked I_NominationHeaderFld NominationDocIsBlocked Flag to Select Nom

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_DemandNominationSchedule.
-- 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: IDEMANDNOMSCHED

CREATE VIEW I_DemandNominationSchedule AS
SELECT
  NominationDoc,
  NominationDocItem,
  LocationId,
  ScheduledMaterial,
  ScheduledDate AS NominationScheduleDate,
  ScheduledQuantity,
  ScheduledQuantityUnit,
  TransportSystem,
  _DestNominationSimulation.TransportationVehicle AS TransportationVehicle,
  NominationScheduleType,
  NominationReferenceDocType,
  _DestNominationSimulation.NominationReferenceDocument AS NominationReferenceDocument,
  _DestNominationSimulation.NominationReferenceDocItem AS NominationReferenceDocItem,
  NominationExtNumber,
  ModeOfTransport,
  CreatedByUser,
  NominationScheduleCreationDate,
  NominationCreationTime,
  NominationSimlnID,
  NominationSimlnLineItm,
  NominationSimlnVersion,
  _Header.NominationDocIsBlocked AS NominationDocIsBlocked
FROM I_NominationSimulation AS _DestNominationSimulation
INNER JOIN I_NominationHeaderFld AS _Header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationSimulation AS _SourceNominationSimulation ON _SourceNominationSimulation.NominationDoc = _DestNominationSimulation.NominationDoc AND _SourceNominationSimulation.ScheduledMaterial = _DestNominationSimulation.ScheduledMaterial AND _SourceNominationSimulation.ScheduledDate <= _DestNominationSimulation.ScheduledDate AND _SourceNominationSimulation.NominationScheduleType = 'O'  -- association [0..1]
LEFT OUTER JOIN I_NominationSchedldMvtPegging AS _NominationSchedldMvtPegging ON _NominationSchedldMvtPegging.NominationDoc = NominationDoc AND _NominationSchedldMvtPegging.NominationDocItem = NominationDocItem AND _NominationSchedldMvtPegging.NominationPegType = 'CN'  -- association [0..1]
LEFT OUTER JOIN I_NominationSimulation AS _NominationSimulation ON _NominationSimulation.NominationDoc = NominationDoc AND _NominationSimulation.NominationDocItem = NominationDocItem  -- association [0..1]
LEFT OUTER JOIN I_NominationItemFld AS _SourceItem ON _SourceItem.NominationDoc = _DestinationNominationItem.NominationDoc AND _SourceItem.ScheduledMaterial = _DestinationNominationItem.ScheduledMaterial AND _SourceItem.NominationScheduleDate <= _DestinationNominationItem.NominationScheduleDate AND _SourceItem.NominationScheduleType = 'O' AND _SourceItem.NominationIsMarkedForDeletion = ''  -- association [0..1]
-- UNION with additional select branch(es): I_NominationItemFld
;

Learn More