I_ACMContrItemPlndQty

DDL: I_ACMCONTRITEMPLNDQTY SQL: IACMCONTRPLANQTY Type: view COMPOSITE
10 Fields 2 Data Sources 2 Associations

I_ACMContrItemPlndQty is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ACMContrItmQtyLinkdType, I_ACMContrItmQtyLinkdType) and exposes 10 fields with key fields ContractNum, TradingContractItem, ACMRelatedTradeLinkID, TradingContractItem, ACMRelatedTradeLinkID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ACMContrItmQtyLinkdType TrdgContrQtyAll from
I_ACMContrItmQtyLinkdType TrdgContrQtyAll union_all

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_TrdgContrPlannedQtyDets _plannedQty TrdgContrQtyAll.ContractNum = _plannedQty.ContractNum and TrdgContrQtyAll.TradingContractItem = _plannedQty.TradingContractItem and TrdgContrQtyAll.ACMQuantityLinkTypeID = '10'
[0..*] I_TrdgContrPlannedQtyDets _planTradQty TrdgContrQtyAll.ACMRelatedTradeIdentifier = _planTradQty.ContractNum and TrdgContrQtyAll.TradingContractItem = _planTradQty.TradingContractItem and TrdgContrQtyAll.ACMQuantityLinkTypeID = '10'

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName IACMCONTRPLANQTY view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ContractNum ContractNum
KEY TradingContractItem TradingContractItem Item Number
KEY ACMRelatedTradeLinkID
ACMPlannedQtyUoM _plannedQty TrdgContractItemUnitOfMeasure
ACMApplicationDataUoM _plannedQty ACMApplicationDataUoM
KEY TradingContractItem TradingContractItem Item Number
KEY ACMRelatedTradeLinkID I_ACMContrItmQtyLinkdType ACMRelatedTradeIdentifier
ACMPlannedQtyUoM _planTradQty TrdgContractItemUnitOfMeasure
ACMApplicationDataUoM _planTradQty ACMApplicationDataUoM
ACMIsNominationConfirmed _planTradQty ACMIsNominationConfirmed

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_ACMContrItemPlndQty.
-- 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: IACMCONTRPLANQTY

CREATE VIEW I_ACMContrItemPlndQty AS
SELECT
  ContractNum,
  TradingContractItem,
  cast(' ' as /accgo/e_tc_link_id) AS ACMRelatedTradeLinkID,
  _plannedQty.TrdgContractItemUnitOfMeasure AS ACMPlannedQtyUoM,
  _plannedQty.ACMApplicationDataUoM AS ACMApplicationDataUoM,
  _planTradQty.ACMIsNominationConfirmed AS ACMIsNominationConfirmed
FROM I_ACMContrItmQtyLinkdType AS TrdgContrQtyAll
LEFT OUTER JOIN I_TrdgContrPlannedQtyDets AS _plannedQty ON TrdgContrQtyAll.ContractNum = _plannedQty.ContractNum AND TrdgContrQtyAll.TradingContractItem = _plannedQty.TradingContractItem AND TrdgContrQtyAll.ACMQuantityLinkTypeID = '10'  -- association [0..*]
LEFT OUTER JOIN I_TrdgContrPlannedQtyDets AS _planTradQty ON TrdgContrQtyAll.ACMRelatedTradeIdentifier = _planTradQty.ContractNum AND TrdgContrQtyAll.TradingContractItem = _planTradQty.TradingContractItem AND TrdgContrQtyAll.ACMQuantityLinkTypeID = '10'  -- association [0..*]
-- UNION ALL with additional select branch(es): I_ACMContrItmQtyLinkdType
;

Learn More