I_NominationHeaderInfo

DDL: I_NOMINATIONHEADERINFO SQL: INOMHDRINFO Type: view COMPOSITE
64 Fields 4 Data Sources 2 Associations

Nomination Header Information

I_NominationHeaderInfo is a Composite CDS View that provides data about "Nomination Header Information" in SAP S/4HANA. It reads from 4 data sources (I_NominationItemStatusVH, I_NominationMaterialDesc, I_NominationHeaderFld, I_NominationTicketStsCt) and exposes 64 fields with key fields NominationDoc, NominationDocItem. It has 2 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_NominationItemStatusVH itemstatus left_outer
I_NominationMaterialDesc materialText inner
I_NominationHeaderFld nomhead inner
I_NominationTicketStsCt statusitem left_outer

Associations (2)

CardinalityTargetAliasCondition
[0..1] E_NominationHeader _NominationHeaderExtension $projection.NominationDoc = _NominationHeaderExtension.NominationDoc
[0..1] E_NominationItem _NominationItemExtension $projection.NominationDoc = _NominationItemExtension.NominationDoc and $projection.NominationDocItem = _NominationItemExtension.NominationDocItem

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName INOMHDRINFO view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Nomination Header Information view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc nomitem NominationDoc Nomination key
KEY NominationDocItem nomitem NominationDocItem Nom. key item
NominationTicketKey I_NominationTicketStsCt NominationTicketKey
NominationTicketItem I_NominationTicketStsCt NominationTicketItem
NominationTicketVersion I_NominationTicketStsCt NominationTicketVersion
NominationTicketPurpose I_NominationTicketStsCt NominationTicketPurpose
NominationScheduleDate nomitem NominationScheduleDate
LocationName nomitem LocationName Location Name
LocationId nomitem LocationId Location ID
DemandMaterial nomitem DemandMaterial
MaterialDesc I_NominationMaterialDesc MaterialDesc Short text
ScheduledQuantity nomitem ScheduledQuantity Scheduled Qty
ScheduledQuantityUnit nomitem ScheduledQuantityUnit SchedUoM
ActualScheduledQuantity nomitem ActualScheduledQuantity
ActualScheduledQuantityUnit nomitem ActualScheduledQuantityUnit
NominationScheduleType nomitem NominationScheduleType Sched.type
NumberOfTickets I_NominationTicketStsCt NumberOfTickets
TicketItemStatus I_NominationItemStatusVH TicketItemStatus Lower Value
TransportSystem I_NominationHeaderFld TransportSystem Transport System
NominationType I_NominationHeaderFld NominationType Single-Character Flag
VehicleIdentifier I_NominationHeaderFld VehicleIdentifier Ext. identifier
InTransitPlant I_NominationHeaderFld InTransitPlant Single-Character Flag
NominationShipper I_NominationHeaderFld NominationShipper Single-Character Flag
NominationCarrier I_NominationHeaderFld NominationCarrier Single-Character Flag
TransportationPlanningPoint I_NominationHeaderFld TransportationPlanningPoint TransportPlanPt
InTransitStorageLocation I_NominationHeaderFld InTransitStorageLocation Single-Character Flag
NominationPipelineCycleID I_NominationHeaderFld NominationPipelineCycleID Single-Character Flag
BusinessType I_NominationHeaderFld BusinessType Type of Business
VehicleId I_NominationHeaderFld VehicleId Vehicle Number
BulkShipmentType I_NominationHeaderFld BulkShipmentType Single-Character Flag
NominationModeOfTransport I_NominationHeaderFld NominationModeOfTransport Single-Character Flag
NominationUnitOfMeasure I_NominationHeaderFld NominationUnitOfMeasure UoM
NominationExtNumber I_NominationHeaderFld NominationExtNumber Single-Character Flag
NominationCreatedByUser nomitem NominationCreatedByUser User Name
NominationCreationDate nomitem NominationCreationDate Entered On
NominationChangedDate nomitem NominationChangedDate Obsolete
LastChangedByUser nomitem LastChangedByUser User Name
NominationReferenceDocType nomitem NominationReferenceDocType
NominationCreationTime nomitem NominationCreationTime
NominationReferenceDocItem nomitem NominationReferenceDocItem
NominationReferenceDocument nomitem NominationReferenceDocument
ValuationTypeDestination nomitem ValuationTypeDestination
ValuationTypeOrigin nomitem ValuationTypeOrigin
LocationPartner nomitem LocationPartner Loc.partner
BatchOriginLocation nomitem BatchOriginLocation
BatchDestinationLocation nomitem BatchDestinationLocation
NominationIsBlocked nomitem NominationIsBlocked
NominationIsMarkedForDeletion nomitem NominationIsMarkedForDeletion
NominationItemStatus nomitem NominationItemStatus
NominationItemSubStatus nomitem NominationItemSubStatus
ContractPartner nomitem ContractPartner
ConsigneePartner nomitem ConsigneePartner
IsImportExportPartner nomitem IsImportExportPartner
ImportExportPartner nomitem ImportExportPartner
NominationInspector nomitem NominationInspector
IsNominationWorklistEntry nomitem IsNominationWorklistEntry
QuickConfirm nomitem QuickConfirm
ScheduledBatchEndDateTime nomitem ScheduledBatchEndDateTime
ScheduledBatchStartDateTime nomitem ScheduledBatchStartDateTime
NominationItemIsComplete nomitem NominationItemIsComplete
NominationIsIncomplete nomitem NominationIsIncomplete
NominationRefDocCode nomitem NominationRefDocCode
NominationDocIsBlocked I_NominationHeaderFld NominationDocIsBlocked Flag to Select Nom
NominationTicketIsBlocked I_NominationTicketStsCt NominationTicketIsBlocked

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_NominationHeaderInfo.
-- 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: INOMHDRINFO

CREATE VIEW I_NominationHeaderInfo AS
SELECT
  nomitem.NominationDoc AS NominationDoc,
  nomitem.NominationDocItem AS NominationDocItem,
  statusitem.NominationTicketKey AS NominationTicketKey,
  statusitem.NominationTicketItem AS NominationTicketItem,
  statusitem.NominationTicketVersion AS NominationTicketVersion,
  statusitem.NominationTicketPurpose AS NominationTicketPurpose,
  nomitem.NominationScheduleDate AS NominationScheduleDate,
  nomitem.LocationName AS LocationName,
  nomitem.LocationId AS LocationId,
  nomitem.DemandMaterial AS DemandMaterial,
  materialText.MaterialDesc AS MaterialDesc,
  nomitem.ScheduledQuantity AS ScheduledQuantity,
  nomitem.ScheduledQuantityUnit AS ScheduledQuantityUnit,
  nomitem.ActualScheduledQuantity AS ActualScheduledQuantity,
  nomitem.ActualScheduledQuantityUnit AS ActualScheduledQuantityUnit,
  nomitem.NominationScheduleType AS NominationScheduleType,
  statusitem.NumberOfTickets AS NumberOfTickets,
  itemstatus.TicketItemStatus AS TicketItemStatus,
  nomhead.TransportSystem AS TransportSystem,
  nomhead.NominationType AS NominationType,
  nomhead.VehicleIdentifier AS VehicleIdentifier,
  nomhead.InTransitPlant AS InTransitPlant,
  nomhead.NominationShipper AS NominationShipper,
  nomhead.NominationCarrier AS NominationCarrier,
  nomhead.TransportationPlanningPoint AS TransportationPlanningPoint,
  nomhead.InTransitStorageLocation AS InTransitStorageLocation,
  nomhead.NominationPipelineCycleID AS NominationPipelineCycleID,
  nomhead.BusinessType AS BusinessType,
  nomhead.VehicleId AS VehicleId,
  nomhead.BulkShipmentType AS BulkShipmentType,
  nomhead.NominationModeOfTransport AS NominationModeOfTransport,
  nomhead.NominationUnitOfMeasure AS NominationUnitOfMeasure,
  nomhead.NominationExtNumber AS NominationExtNumber,
  nomitem.NominationCreatedByUser AS NominationCreatedByUser,
  nomitem.NominationCreationDate AS NominationCreationDate,
  nomitem.NominationChangedDate AS NominationChangedDate,
  nomitem.LastChangedByUser AS LastChangedByUser,
  nomitem.NominationReferenceDocType AS NominationReferenceDocType,
  nomitem.NominationCreationTime AS NominationCreationTime,
  nomitem.NominationReferenceDocItem AS NominationReferenceDocItem,
  nomitem.NominationReferenceDocument AS NominationReferenceDocument,
  nomitem.ValuationTypeDestination AS ValuationTypeDestination,
  nomitem.ValuationTypeOrigin AS ValuationTypeOrigin,
  nomitem.LocationPartner AS LocationPartner,
  nomitem.BatchOriginLocation AS BatchOriginLocation,
  nomitem.BatchDestinationLocation AS BatchDestinationLocation,
  nomitem.NominationIsBlocked AS NominationIsBlocked,
  nomitem.NominationIsMarkedForDeletion AS NominationIsMarkedForDeletion,
  nomitem.NominationItemStatus AS NominationItemStatus,
  nomitem.NominationItemSubStatus AS NominationItemSubStatus,
  nomitem.ContractPartner AS ContractPartner,
  nomitem.ConsigneePartner AS ConsigneePartner,
  nomitem.IsImportExportPartner AS IsImportExportPartner,
  nomitem.ImportExportPartner AS ImportExportPartner,
  nomitem.NominationInspector AS NominationInspector,
  nomitem.IsNominationWorklistEntry AS IsNominationWorklistEntry,
  nomitem.QuickConfirm AS QuickConfirm,
  nomitem.ScheduledBatchEndDateTime AS ScheduledBatchEndDateTime,
  nomitem.ScheduledBatchStartDateTime AS ScheduledBatchStartDateTime,
  nomitem.NominationItemIsComplete AS NominationItemIsComplete,
  nomitem.NominationIsIncomplete AS NominationIsIncomplete,
  nomitem.NominationRefDocCode AS NominationRefDocCode,
  nomhead.NominationDocIsBlocked AS NominationDocIsBlocked,
  statusitem.NominationTicketIsBlocked AS NominationTicketIsBlocked
INNER JOIN I_NominationHeaderFld AS nomhead ON /* join condition not captured in parsed metadata */
INNER JOIN I_NominationMaterialDesc AS materialText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationItemStatusVH AS itemstatus ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationTicketStsCt AS statusitem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_NominationHeader AS _NominationHeaderExtension ON NominationDoc = _NominationHeaderExtension.NominationDoc  -- association [0..1]
LEFT OUTER JOIN E_NominationItem AS _NominationItemExtension ON NominationDoc = _NominationItemExtension.NominationDoc AND NominationDocItem = _NominationItemExtension.NominationDocItem  -- association [0..1]
;

Learn More