C_ACMMntnPrcgNominationDet

DDL: C_ACMMNTNPRCGNOMINATIONDET SQL: CACMPRCGNOM Type: view CONSUMPTION
16 Fields 1 Data Sources 1 Associations

Nomination Details for Price Lots

C_ACMMntnPrcgNominationDet is a Consumption CDS View that provides data about "Nomination Details for Price Lots" in SAP S/4HANA. It reads from 1 data source (I_ACMNominationItmDet) and exposes 16 fields with key fields ContractNum, TradingContractItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ACMNominationItmDet NomItmDet from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ACMContrNominationLotInfo _ContNomInfo NomItmDet.TradingContractNumber = _ContNomInfo.ContractNum and NomItmDet.TradingContractItem = _ContNomInfo.TradingContractItem and NomItmDet.ConfirmedNominationNumber = _ContNomInfo.ConfirmedNominationNumber and NomItmDet.ConfirmedNominationItem = _ContNomInfo.ConfirmedNominationItem

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CACMPRCGNOM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Search.searchable true view
EndUserText.label Nomination Details for Price Lots view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ContractNum I_ACMNominationItmDet TradingContractNumber Trading Contract
KEY TradingContractItem I_ACMNominationItmDet TradingContractItem Item Number
ContractItemAssignmentUUID _ContNomInfo ContractItemAssignmentUUID
ACMFromDocumentNumber _ContNomInfo ACMFromDocumentNumber
ApplicationDocumentItem _ContNomInfo ApplicationDocumentItem
DocumentFrom _ContNomInfo DocumentFrom
ACMPricingAspect _ContNomInfo ACMPricingAspect
ACMPricingAspectValue _ContNomInfo ACMPricingAspectValue
ACMNominationScheduledDate I_ACMNominationItmDet ScheduledDate Scheduled Date
ACMNominationScheduledQty I_ACMNominationItmDet ACMNominationScheduledQty Scheduled Quantity
ACMNominationScheduledQtyUoM I_ACMNominationItmDet ACMNominationScheduledQtyUoM
ACMMntnPrcgNominationActualQty I_ACMNominationItmDet ACMMntnPrcgNominationActualQty Actual Quantity
ActualScheduledQuantityUnit I_ACMNominationItmDet ActualScheduledQuantityUnit
NominationItemStatus I_ACMNominationItmDet NominationItemStatus
ACMApplDocContrOptnDschrgdLoc I_ACMNominationItmDet ACMApplDocContrOptnDschrgdLoc Discharge Location
ACMApplDocContrOptnLoadLoc I_ACMNominationItmDet ACMApplDocContrOptnLoadLoc Load Location

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_ACMMntnPrcgNominationDet.
-- 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: CACMPRCGNOM

CREATE VIEW C_ACMMntnPrcgNominationDet AS
SELECT
  NomItmDet.TradingContractNumber AS ContractNum,
  NomItmDet.TradingContractItem AS TradingContractItem,
  _ContNomInfo.ContractItemAssignmentUUID AS ContractItemAssignmentUUID,
  _ContNomInfo.ACMFromDocumentNumber AS ACMFromDocumentNumber,
  _ContNomInfo.ApplicationDocumentItem AS ApplicationDocumentItem,
  _ContNomInfo.DocumentFrom AS DocumentFrom,
  _ContNomInfo.ACMPricingAspect AS ACMPricingAspect,
  _ContNomInfo.ACMPricingAspectValue AS ACMPricingAspectValue,
  NomItmDet.ScheduledDate AS ACMNominationScheduledDate,
  NomItmDet.ACMNominationScheduledQty AS ACMNominationScheduledQty,
  NomItmDet.ACMNominationScheduledQtyUoM AS ACMNominationScheduledQtyUoM,
  NomItmDet.ACMMntnPrcgNominationActualQty AS ACMMntnPrcgNominationActualQty,
  NomItmDet.ActualScheduledQuantityUnit AS ActualScheduledQuantityUnit,
  NomItmDet.NominationItemStatus AS NominationItemStatus,
  NomItmDet.ACMApplDocContrOptnDschrgdLoc AS ACMApplDocContrOptnDschrgdLoc,
  NomItmDet.ACMApplDocContrOptnLoadLoc AS ACMApplDocContrOptnLoadLoc
FROM I_ACMNominationItmDet AS NomItmDet
LEFT OUTER JOIN I_ACMContrNominationLotInfo AS _ContNomInfo ON NomItmDet.TradingContractNumber = _ContNomInfo.ContractNum AND NomItmDet.TradingContractItem = _ContNomInfo.TradingContractItem AND NomItmDet.ConfirmedNominationNumber = _ContNomInfo.ConfirmedNominationNumber AND NomItmDet.ConfirmedNominationItem = _ContNomInfo.ConfirmedNominationItem  -- association [0..*]
;

Learn More