I_ACMTrdgContrItmExtn

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_ACMTrdgContrItmExtn.
-- 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: IACMTRCONTITMEXT

CREATE VIEW I_ACMTrdgContrItmExtn AS
SELECT
  Item.TradingContractNumber AS TradingContractNumber,
  Item.TradingContractItem AS TradingContractItem,
  _ContractHeader.TradingContractType AS TradingContractType,
  Item.ContractMaterial AS ContractMaterial,
  Item.ContractPlant AS ContractPlant,
  _Material.Commodity AS Commodity,
  _CommodityItem.TrdgContrCreditSalesFromDate AS ACMTrdgContrActualStartDate,
  _CommodityItem.TrdgContractCreditSalesToDate AS ActualStartDateTo,
  _ContractAdditionalItem.PricingApproach AS PricingApproach,
  _ContractAdditionalItem.ValuationPoint AS ValuationPoint,
  Item.ContractStorageLocation AS ContractStorageLocation
FROM I_ACMTradingContractItemData AS Item
LEFT OUTER JOIN I_ACMContractCommoditySubitem AS _CommodityItem ON Item.TradingContractNumber = _CommodityItem.TradingContractNumber AND Item.TradingContractItem = _CommodityItem.TradingContractItem  -- association [1..1]
LEFT OUTER JOIN I_ACMMaterialMstrData AS _Material ON Item.ContractMaterial = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_ACMTradingContractItemAddl AS _ContractAdditionalItem ON Item.TradingContractNumber = _ContractAdditionalItem.TradingContractNumber AND Item.TradingContractItem = _ContractAdditionalItem.TradingContractItem  -- association [1..1]
LEFT OUTER JOIN I_ACMTrdgContrItmPrcg AS _PricingInfo ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN I_ACMTrdgContrTol AS _ToleranceInfo ON /* condition not available in parsed metadata */  -- association [1]
LEFT OUTER JOIN I_ACMTrdgContrOptntyInfo AS _OptionalityInfo ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN I_ACMContrPaytTrm AS _DeferredPaymentInfo ON /* condition not available in parsed metadata */  -- association [1]
LEFT OUTER JOIN I_ACMTrdgContrPpaytDet AS _PrepaymentInfo ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN I_ACMTrdgContrQtyTypeInfo AS _QuantityTypes ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN I_ACMContrFeeDet AS _FeeDetails ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN I_ACMTrdgContrItmTxt AS _TextDetails ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN I_ACMContrItmUoMCnvrsnInfo AS _ItemUoMCnvrsn ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN I_ACMTrdgContrItmDlvDet AS _ItemDelivDteDet ON /* condition not available in parsed metadata */  -- association [1]
LEFT OUTER JOIN I_ACMTrdgContrDPQSHdrDet AS _DPQS ON /* condition not available in parsed metadata */  -- association [1]
;