I_ACMNominationItem

DDL: I_ACMNOMINATIONITEM SQL: IACMNOMINATIONI Type: view COMPOSITE
23 Fields 1 Data Sources 5 Associations

ACM Nomination Item Details

I_ACMNominationItem is a Composite CDS View that provides data about "ACM Nomination Item Details" in SAP S/4HANA. It reads from 1 data source (I_ACMNominationBaseQty) and exposes 23 fields with key fields NominationKey, NominationDocItem. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ACMNominationBaseQty ACMNominationBaseQty from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_ACMTrdgContrHdr _ContractHeader $projection.TradingContractNumber = _ContractHeader.TradingContractNumber
[1..1] I_ACMTrdgContrItmDet _ContractItem $projection.TradingContractNumber = _ContractItem.TradingContractNumber and $projection.TradingContractItem = _ContractItem.TradingContractItem
[0..*] I_ACMNominationItemUoMCnvrsn _ACMNominationItemUoMCnvrsn
[0..*] I_ACMNominationDelivAssgmt _ACMNominationDelivAssgmt
[0..*] I_ACMNominationTrdgContract _ACMNominationTrdgContract

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACMNOMINATIONI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label ACM Nomination Item Details view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY NominationKey I_ACMNominationBaseQty NominationKey Nomination key
KEY NominationDocItem I_ACMNominationBaseQty NominationDocItem Nom. key item
Plant I_ACMNominationBaseQty Plant Valuation Area
Material I_ACMNominationBaseQty Material Vehicle Model
Counterparty I_ACMNominationBaseQty Counterparty Supplier
TradingContractNumber I_ACMNominationBaseQty TradingContractNumber Trading Contract
TradingContractItem I_ACMNominationBaseQty TradingContractItem Item Number
ScheduledQuantity I_ACMNominationBaseQty ScheduledQuantity Scheduled Qty
ActualScheduledQuantity I_ACMNominationBaseQty ActualScheduledQuantity Single-Character Flag
ScheduledQuantityUnit I_ACMNominationBaseQty ScheduledQuantityUnit SchedUoM
BaseUnitofMeasure I_ACMNominationBaseQty BaseUnitofMeasure Base Unit
ScheduledBatchStartDateTime I_ACMNominationBaseQty ScheduledBatchStartDateTime TST From
ScheduledBatchEndDateTime I_ACMNominationBaseQty ScheduledBatchEndDateTime TST To
ACMNominationItemIsConfirmed I_ACMNominationBaseQty ACMNominationItemIsConfirmed Single-Character Flag
NominationItemIsComplete I_ACMNominationBaseQty NominationItemIsComplete Single-Character Flag
ACMNominationReferenceDocument I_ACMNominationBaseQty ACMNominationReferenceDocument Single-Character Flag
MaterialBaseUnit Material MaterialBaseUnit Valuation Unit
_ACMNomination _ACMNomination
_ACMNominationItemUoMCnvrsn _ACMNominationItemUoMCnvrsn
_ACMNominationDelivAssgmt _ACMNominationDelivAssgmt
_ACMNominationTrdgContract _ACMNominationTrdgContract
_ContractHeader _ContractHeader
_ContractItem _ContractItem

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_ACMNominationItem.
-- 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: IACMNOMINATIONI

CREATE VIEW I_ACMNominationItem AS
SELECT
  ACMNominationBaseQty.NominationKey AS NominationKey,
  ACMNominationBaseQty.NominationDocItem AS NominationDocItem,
  ACMNominationBaseQty.Plant AS Plant,
  ACMNominationBaseQty.Material AS Material,
  ACMNominationBaseQty.Counterparty AS Counterparty,
  ACMNominationBaseQty.TradingContractNumber AS TradingContractNumber,
  ACMNominationBaseQty.TradingContractItem AS TradingContractItem,
  ACMNominationBaseQty.ScheduledQuantity AS ScheduledQuantity,
  ACMNominationBaseQty.ActualScheduledQuantity AS ActualScheduledQuantity,
  ACMNominationBaseQty.ScheduledQuantityUnit AS ScheduledQuantityUnit,
  ACMNominationBaseQty.BaseUnitofMeasure AS BaseUnitofMeasure,
  ACMNominationBaseQty.ScheduledBatchStartDateTime AS ScheduledBatchStartDateTime,
  ACMNominationBaseQty.ScheduledBatchEndDateTime AS ScheduledBatchEndDateTime,
  ACMNominationBaseQty.ACMNominationItemIsConfirmed AS ACMNominationItemIsConfirmed,
  ACMNominationBaseQty.NominationItemIsComplete AS NominationItemIsComplete,
  ACMNominationBaseQty.ACMNominationReferenceDocument AS ACMNominationReferenceDocument,
  Material.MaterialBaseUnit AS MaterialBaseUnit
FROM I_ACMNominationBaseQty AS ACMNominationBaseQty
LEFT OUTER JOIN I_ACMTrdgContrHdr AS _ContractHeader ON TradingContractNumber = _ContractHeader.TradingContractNumber  -- association [1..1]
LEFT OUTER JOIN I_ACMTrdgContrItmDet AS _ContractItem ON TradingContractNumber = _ContractItem.TradingContractNumber AND TradingContractItem = _ContractItem.TradingContractItem  -- association [1..1]
LEFT OUTER JOIN I_ACMNominationItemUoMCnvrsn AS _ACMNominationItemUoMCnvrsn ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ACMNominationDelivAssgmt AS _ACMNominationDelivAssgmt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ACMNominationTrdgContract AS _ACMNominationTrdgContract ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More