I_TicketNominationInfoFld

DDL: I_TICKETNOMINATIONINFOFLD SQL: ITICKETNOMINFFLD Type: view BASIC
16 Fields 3 Data Sources

Ticket Nomination Information Field

I_TicketNominationInfoFld is a Basic CDS View that provides data about "Ticket Nomination Information Field" in SAP S/4HANA. It reads from 3 data sources (I_NominationHeaderFld, I_NominationItemFld, I_NominationLocationVH) and exposes 16 fields with key fields NominationDoc, NominationDocItem.

Data Sources (3)

SourceAliasJoin Type
I_NominationHeaderFld NominationHeaderFld left_outer
I_NominationItemFld NominationItemFld from
I_NominationLocationVH NominationLocationVH left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ITICKETNOMINFFLD view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Ticket Nomination Information Field view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc I_NominationItemFld NominationDoc Nomination key
KEY NominationDocItem I_NominationItemFld NominationDocItem Nom. key item
NominationExtNumber I_NominationHeaderFld NominationExtNumber Single-Character Flag
NominationScheduleType I_NominationItemFld NominationScheduleType Sched.type
DemandMaterial I_NominationItemFld DemandMaterial Single-Character Flag
NominationType I_NominationHeaderFld NominationType Single-Character Flag
LocationName I_NominationItemFld LocationName Location Name
LocationId I_NominationItemFld LocationId Location ID
TransportSystem I_NominationHeaderFld TransportSystem Transport System
QuantityStartDateTime
QuantityEndDateTime
QuantityPostingDateTime
TypeOfMovement
QuantityIsMarked
MeterIsMarked
GaugeIsMarked

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_TicketNominationInfoFld.
-- 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: ITICKETNOMINFFLD

CREATE VIEW I_TicketNominationInfoFld AS
SELECT
  NominationItemFld.NominationDoc AS NominationDoc,
  NominationItemFld.NominationDocItem AS NominationDocItem,
  NominationHeaderFld.NominationExtNumber AS NominationExtNumber,
  NominationItemFld.NominationScheduleType AS NominationScheduleType,
  NominationItemFld.DemandMaterial AS DemandMaterial,
  NominationHeaderFld.NominationType AS NominationType,
  NominationItemFld.LocationName AS LocationName,
  NominationItemFld.LocationId AS LocationId,
  NominationHeaderFld.TransportSystem AS TransportSystem,
  cast(0 as timestamp ) AS QuantityStartDateTime,
  cast(0 as timestamp ) AS QuantityEndDateTime,
  cast(0 as timestamp ) AS QuantityPostingDateTime,
  cast('Q' as abap.char(15)) AS TypeOfMovement,
  cast('' as boolean preserving type) AS QuantityIsMarked,
  cast('X' as boolean preserving type) AS MeterIsMarked,
  cast('' as boolean preserving type) AS GaugeIsMarked
FROM I_NominationItemFld AS NominationItemFld
LEFT OUTER JOIN I_NominationHeaderFld AS NominationHeaderFld ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationLocationVH AS NominationLocationVH ON /* join condition not captured in parsed metadata */
;

Learn More