I_NominationHeaderPlanActual

DDL: I_NOMINATIONHEADERPLANACTUAL SQL: INOMHEADER Type: view BASIC
19 Fields 2 Data Sources

CDS FOR NOMINATION HEADER FINAL TABLE

I_NominationHeaderPlanActual is a Basic CDS View that provides data about "CDS FOR NOMINATION HEADER FINAL TABLE" in SAP S/4HANA. It reads from 2 data sources (I_NominationHeaderAggregation, I_NominationHeaderVersion) and exposes 19 fields.

Data Sources (2)

SourceAliasJoin Type
I_NominationHeaderAggregation b union_all
I_NominationHeaderVersion i from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName INOMHEADER view
AbapCatalog.compiler.compareFilter true view
EndUserText.label CDS FOR NOMINATION HEADER FINAL TABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (19)

KeyFieldSource TableSource FieldDescription
NominationDoc I_NominationHeaderVersion NominationDoc Nomination key
NominationVersion I_NominationHeaderVersion NominationVersion Version ID
NominationExtNumber I_NominationHeaderVersion NominationExtNumber Single-Character Flag
TransportSystem I_NominationHeaderVersion TransportSystem Transport System
NominationPipelineCycleID I_NominationHeaderVersion NominationPipelineCycleID Single-Character Flag
NominationCarrier I_NominationHeaderVersion NominationCarrier Single-Character Flag
NominationShipper I_NominationHeaderVersion NominationShipper Single-Character Flag
ModeOfTransport I_NominationHeaderVersion ModeOfTransport Mode of Transp.
VehicleId I_NominationHeaderVersion VehicleId Vehicle Number
NominationDoc Nomination key
NominationVersion I_NominationHeaderAggregation NominationVersion Version ID
NominationExtNumber I_NominationHeaderAggregation NominationExtNumber Single-Character Flag
TransportSystem I_NominationHeaderAggregation TransportSystem Transport System
NominationPipelineCycleID I_NominationHeaderAggregation NominationPipelineCycleID Single-Character Flag
NominationCarrier I_NominationHeaderAggregation NominationCarrier Single-Character Flag
NominationShipper I_NominationHeaderAggregation NominationShipper Single-Character Flag
ModeOfTransport I_NominationHeaderAggregation ModeOfTransport Mode of Transp.
VehicleId I_NominationHeaderAggregation VehicleId Vehicle Number
NominationDocIsBlocked I_NominationHeaderAggregation 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_NominationHeaderPlanActual.
-- 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: INOMHEADER

CREATE VIEW I_NominationHeaderPlanActual AS
SELECT
  i.NominationDoc AS NominationDoc,
  i.NominationVersion AS NominationVersion,
  i.NominationExtNumber AS NominationExtNumber,
  i.TransportSystem AS TransportSystem,
  i.NominationPipelineCycleID AS NominationPipelineCycleID,
  i.NominationCarrier AS NominationCarrier,
  i.NominationShipper AS NominationShipper,
  i.ModeOfTransport AS ModeOfTransport,
  i.VehicleId AS VehicleId,
  b.NominationDocIsBlocked AS NominationDocIsBlocked
FROM I_NominationHeaderVersion AS i
-- UNION ALL with additional select branch(es): I_NominationHeaderAggregation
;

Learn More