C_DemandNominationScheduleTP

DDL: C_DEMANDNOMINATIONSCHEDULETP SQL: CDMNDNOMSCHEDTP Type: view CONSUMPTION
24 Fields 1 Data Sources 1 Associations

Scheduling Assistant

C_DemandNominationScheduleTP is a Consumption CDS View that provides data about "Scheduling Assistant" in SAP S/4HANA. It reads from 1 data source (I_DemandNominationScheduleTP) and exposes 24 fields with key fields NominationDoc, NominationDocItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_DemandNominationScheduleTP _DemandNominationScheduleTP from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_SourceNominationScheduleTP _SourceNominationSchedule _SourceNominationSchedule.NominationDoc = $projection.NominationDoc and _SourceNominationSchedule.NominationDocItem = $projection.NominationDocItem

Annotations (23)

NameValueLevelField
AbapCatalog.sqlViewName CDMNDNOMSCHEDTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Scheduling Assistant view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
UI.headerInfo.typeName Demand view
UI.headerInfo.typeNamePlural Demands view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value NominationDoc view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value NominationDocItem view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc NominationDoc Nomination Key
KEY NominationDocItem NominationDocItem Nomination Item
LocationId LocationId Destination Location
ScheduledMaterial ScheduledMaterial Product
MaterialDesc MaterialDesc Material Description
NominationScheduleDate NominationScheduleDate Scheduled Date
DemandNominationSchedSrceType DemandNominationSchedSrceType Demand Source
NominationExtNumber NominationExtNumber Nomination Number
ScheduledQuantity ScheduledQuantity Quantity / UoM
ScheduledQuantityUnit ScheduledQuantityUnit UoM
ModeOfTransport ModeOfTransport Mode of Transport
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
NominationSimlnID NominationSimlnID
NominationSimlnLineItm NominationSimlnLineItm
NominationSimlnVersion NominationSimlnVersion
NominationDocIsBlocked NominationDocIsBlocked
_SourceNominationSchedule _SourceNominationSchedule
_NominationLocation _NominationLocation
_ScheduledMaterialVH _ScheduledMaterialVH
_ModeOfTransportText _ModeOfTransportText
_ModeOfTransportVH _ModeOfTransportVH
_ScheduledQuantityUoMVH _ScheduledQuantityUoMVH
_NominationScheduleUserText _NominationScheduleUserText

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_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: CDMNDNOMSCHEDTP

CREATE VIEW C_DemandNominationScheduleTP AS
SELECT
  NominationDoc,
  NominationDocItem,
  LocationId,
  ScheduledMaterial,
  MaterialDesc,
  NominationScheduleDate,
  DemandNominationSchedSrceType,
  NominationExtNumber,
  ScheduledQuantity,
  ScheduledQuantityUnit,
  ModeOfTransport,
  CreatedByUser,
  CreationDateTime,
  NominationSimlnID,
  NominationSimlnLineItm,
  NominationSimlnVersion,
  NominationDocIsBlocked
FROM I_DemandNominationScheduleTP AS _DemandNominationScheduleTP
LEFT OUTER JOIN C_SourceNominationScheduleTP AS _SourceNominationSchedule ON _SourceNominationSchedule.NominationDoc = NominationDoc AND _SourceNominationSchedule.NominationDocItem = NominationDocItem  -- association [0..*]
;

Learn More