I_ACMMntnTrdgContrPrcgOvw

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_ACMMntnTrdgContrPrcgOvw.
-- 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: IMNTNCONTPRCGOVW

CREATE VIEW I_ACMMntnTrdgContrPrcgOvw AS
SELECT
  TrdgContrPrcgAspectDummyLotID,
  Pricing.TradingContractNumber AS TradingContractNumber,
  TradingContractType,
  TradingContractTypeName,
  PrcgCndnTradingContrCurrency AS TradingContractCurrency,
  Side,
  ACMConditionTermNumber AS PricingConditionTerm,
  ContractStatus,
  TrdgContrApplStsName,
  SalesOrganization,
  DistributionChannel,
  Division,
  PurchasingOrganization,
  PurchasingGroup,
  TradingContractExternalID,
  ContractPlant,
  ContractMaterial,
  Material,
  Pricing.TradingContractItem AS TradingContractItem,
  Pricing.PricingApproach AS PricingApproach,
  Pricing.AlternatePaymentTerm AS AlternatePaymentTerm,
  Incoterms,
  IncotermsLocation1,
  TrdgContrPurgIncotermsLoc1Text,
  TrdgContrSlsIncotermsLoc1Text,
  ContractTradeUnit AS UnitOfMeasure,
  Pricing.ContractTradeQuantity AS Quantity,
  DocumentDate,
  TradingContrCreatedOnDate,
  TradingContrChangedOnDate,
  PersonResponsible AS TrdgContrPersonResponsible,
  TradingContractCreatedBy,
  ACMPricingItemQuantity,
  TrdgContractItemUnitOfMeasure,
  ValuationPoint,
  Pricing.CompanyCode AS CompanyCode,
  Pricing.DerivativeContrSpecification AS DerivativeContrSpecification,
  Pricing.ACMPricingMarketIdentifierCode AS ACMPricingMarketIdentifierCode,
  Pricing.MaturityKeyDate AS MaturityKeyDate,
  cast(ContrDrvtvContrMaturityCode as tba_contract_code ) AS DerivativeContractMaturityCode,
  Pricing.PrcgCndnTradingContrCurrency AS PrcgCndnTradingContrCurrency,
  Pricing.ACMPrcgCndnFlatPrice AS ACMPrcgTotAmt,
  CmmdtyDealDetEffectiveFromDate,
  CmmdtyDealDetEffectiveToDate,
  Pricing.ACMPrcgIntendedPrcType AS ACMPrcgIntendedPrcType,
  Pricing.ACMYourReference AS ACMYourReference,
  Pricing.ACMCustomerReference AS ACMCustomerReference,
  Pricing.ACMPrcgCndnFuturePrice AS ACMPrcgCndnFuturePrice,
  Pricing.ACMPrcgCndnFutureTermCrcy AS ACMPrcgCndnFutureTermCrcy,
  Pricing.ACMPrcgCndnFixedRateFutureUoM AS ACMPrcgCndnFixedRateFutureUoM,
  Pricing.ACMPrcgCndnFutureFixedRateQty AS ACMPrcgCndnFutureFixedRateQty,
  Pricing.ACMPrcgCndnBasisPrc AS ACMPrcgCndnBasisPrc,
  Pricing.PrcgConditionTermFixedRateCrcy AS PrcgConditionTermFixedRateCrcy,
  Pricing.ACMPrcgCndnNonHedgeTermCrcy AS ACMPrcgCndnNonHedgeTermCrcy,
  Pricing.ACMPrcgCndnNonHedgePriceUnit AS ACMPrcgCndnNonHedgePriceUnit,
  Pricing.ACMPrcgCndnNonHedgeQtyUnit AS ACMPrcgCndnNonHedgeQtyUnit,
  ACMTrdgContrPrcgStatusText,
  TrdgContrPrcgAspectSrceLotID,
  Pricing.ACMPurgIncotermsPart1 AS ACMPurgIncotermsPart1,
  Pricing.ACMSlsIncotermsPart1 AS ACMSlsIncotermsPart1,
  Pricing.TrdgContrGoodsSupplier AS TrdgContrGoodsSupplier,
  Pricing.PurchaseOrderSupplier AS PurchaseOrderSupplier,
  Pricing.PricingDocument AS PricingDocument,
  Pricing.ACMTrdgContrStatusCategory AS ACMTrdgContrStatusCategory,
  Pricing.ACMContractStatusIsPosRelevant AS ACMContractStatusIsPosRelevant,
  Pricing.ACMPrcgCmmdtyOrdSubAccountID AS ACMPrcgCmmdtyOrdSubAccountID,
  Pricing.ACMTrdgContrSubAccountName AS ACMTrdgContrSubAccountName,
  Pricing.ACMFormulaUoM AS ACMFormulaUoM,
  Pricing.ACMPricingRate AS ACMPricingRate,
  Pricing.ConditionTermUnit AS ConditionTermUnit,
  _ContrHdrAddDets.ACMSignedStatus AS ACMSignedStatus
FROM I_ACMTrdgContrPrcOvw_2 AS Pricing
LEFT OUTER JOIN I_ACMTrdgContrHdrAddlDets AS _ContrHdrAddDets ON _ContrHdrAddDets.TradingContractNumber = Pricing.TradingContractNumber  -- association [1..1]
LEFT OUTER JOIN I_ACMMntnContrSideText AS _Side ON Side = _Side.DomainValue  -- association [0..1]
LEFT OUTER JOIN I_DerivativeContractSpecText AS _DCSText ON _DCSText.DerivativeContrSpecification = Pricing.DerivativeContrSpecification AND _DCSText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN i_MarketIdentifierCodeText AS _MarketIDText ON _MarketIDText.MarketIdentifierCode = Pricing.ACMPricingMarketIdentifierCode AND _MarketIDText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ACMIntendedPriceTypeVH AS _IntendedPrcType ON ACMPrcgIntendedPrcType = _IntendedPrcType.DomainValue  -- association [0..1]
LEFT OUTER JOIN I_ACMMaterialValueText AS _MaterialText ON ContractMaterial = _MaterialText.Material  -- association [0..1]
LEFT OUTER JOIN I_ACMCommodityDetails AS _CommodityDetails ON Pricing.Material = _CommodityDetails.Material  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON _CompanyCodeText.CompanyCode = Pricing. CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CreatedByUser AS _CreatedByDetails ON Pricing.TradingContractCreatedBy = _CreatedByDetails.UserName  -- association [1..1]
LEFT OUTER JOIN I_CreatedByUser AS _PersonRespDetails ON Pricing.PersonResponsible = _PersonRespDetails.UserName  -- association [0..1]
LEFT OUTER JOIN I_CreatedByUser AS _ChangedByDetails ON Pricing.TradingContractCreatedBy = _ChangedByDetails.UserName  -- association [1..1]
LEFT OUTER JOIN I_ACMDistributionChnlValueHelp AS _DistributionChannelText ON Pricing.DistributionChannel = _DistributionChannelText.DistributionChannel AND Pricing.SalesOrganization = _DistributionChannelText.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_ACMSalesDivisionValueHelp AS _OrganizationDivisionName ON Pricing.Division = _OrganizationDivisionName.Division AND Pricing.SalesOrganization = _OrganizationDivisionName.SalesOrganization AND Pricing.DistributionChannel = _OrganizationDivisionName.DistributionChannel  -- association [1..1]
LEFT OUTER JOIN I_ACMSalesOrganizationValHelp AS _SalesOrganizationText ON Pricing.SalesOrganization = _SalesOrganizationText.SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_PlantStdVH AS _PlantName ON Pricing.ContractPlant = _PlantName.Plant  -- association [1..1]
LEFT OUTER JOIN I_ACMTrdgContrCounterparty AS _Counterparty ON Pricing.TrdgContrGoodsSupplier = _Counterparty.Counterparty OR Pricing.PurchaseOrderSupplier = _Counterparty.Counterparty  -- association [1..1]
LEFT OUTER JOIN I_ACMPricingApproach AS _PricingApproach ON _PricingApproach.PricingApproach = Pricing.PricingApproach AND _PricingApproach.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_ACMPurchasingOrganization AS _PurchasingOrganizationName ON Pricing.PurchasingOrganization = _PurchasingOrganizationName.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_ACMPurchasingGroup AS _PurchasingGroupName ON Pricing.PurchasingGroup = _PurchasingGroupName.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_ACMTrdgContrPartForMntnContr AS _TransactingCounterparty ON _TransactingCounterparty.TradingContractNumber = Pricing.TradingContractNumber  -- association [0..1]
LEFT OUTER JOIN I_ACMTrdgContrTypeWithSide AS _TargetContractType ON TradingContractType = _TargetContractType.TradingContractType  -- association [0..1]
;