C_ACMMntnTrdgContrPrcgOvw_1

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_ACMMntnTrdgContrPrcgOvw_1.
-- 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.

CREATE VIEW C_ACMMntnTrdgContrPrcgOvw_1 AS
SELECT
  TrdgContrPrcgAspectDummyLotID AS ACMTrdgContrSourcePriceLotID,
  TradingContractNumber,
  TradingContractItem,
  Pricing.PrcFixGrpUUID AS PrcFixGrpUUID,
  Pricing.ACMPrcFixGrpID AS ACMPrcFixGrpID,
  cast(Pricing.ACMPrcFixGrpID as /accgo/e_fee_refdoc_subitem) AS ACMPrcFixGrpIDChar32,
  TradingContractType,
  ACMTradingContractTypeName,
  Side,
  DomainText AS DocumentSideName,
  ACMPrcgAspectType,
  ACMPrcgAspectTxt,
  cast( '0' as abap.decfloat34 ) AS ACMCumltvAssgdQtyRawValue,
  cast('' as /accgo/e_assigned_quantity) AS ACMAssgdQtyLabel,
  ContractStatus,
  TrdgContrApplStsName,
  SalesOrganization,
  Pricing.SalesOrganizationText AS SalesOrganizationText,
  DistributionChannel,
  Pricing.DistributionChannelText AS DistributionChannelText,
  Division,
  DivisionName,
  PurchasingOrganization,
  Pricing.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  Pricing.PurchasingGroupName AS PurchasingGroupName,
  TradingContractExternalID,
  ContractPlant,
  Pricing.PlantName AS PlantName,
  Material,
  MaterialName,
  PricingApproach,
  Pricing.PricingTypeName AS PricingTypeName,
  Pricing.Commodity AS Commodity,
  Pricing.CommodityName AS CommodityName,
  Counterparty,
  CounterpartyFullName,
  ACMCounterpartyFirstName,
  ACMCounterpartyLastName,
  AuthorizationGroup,
  IsBusinessPurposeCompleted,
  Pricing._TransactingCounterparty.TransactingCtpty AS TransactingCtpty,
  Pricing._TransactingCounterparty.ACMTransCounterpartyFullName AS ACMTransCounterpartyFullName,
  ACMOriginalTraderID,
  ACMOriginalTraderIDText,
  ACMAmendingTraderID,
  ACMAmendingTraderIDText,
  Incoterms,
  Pricing.ACMPurgIncotermsPart1 AS ACMPurgIncotermsPart1,
  Pricing.ACMSlsIncotermsPart1 AS ACMSlsIncotermsPart1,
  Pricing.ACMTrdgContrStatusCategory AS ACMTrdgContrStatusCategory,
  Pricing.ACMContractStatusIsPosRelevant AS ACMContractStatusIsPosRelevant,
  IncotermsLocation1,
  PersonResponsible AS TrdgContrPersonResponsible,
  Pricing.TrdgContrPersonResponsibleName AS TrdgContrPersonResponsibleName,
  TradingContractCreatedBy,
  Pricing.TradingContractCreatedByName AS TradingContractCreatedByName,
  TradingContractChangedBy,
  DocumentDate,
  ACMPricingAspect,
  TradingContrCreatedOnDate,
  TradingContrChangedOnDate AS TradingContractChangedOnDate,
  CompanyCode,
  Pricing.CompanyCodeName AS CompanyCodeName,
  DerivativeContrSpecification,
  Pricing._DCSText.DerivativeContrSpecName AS ACMDerivativeContrSpecsTxt,
  ACMPricingMarketIdentifierCode,
  Pricing._MarketIDText.MarketIdentifierCodeName AS ACMMarketIdentifierCodeTxt,
  MaturityKeyDate,
  DerivativeContractMaturityCode,
  CmmdtyDealDetEffectiveToDate,
  CmmdtyDealDetEffectiveFromDate,
  ACMPrcgIntendedPrcType,
  Pricing.ACMPrcgIntendedPrcTypeDesc AS ACMPrcgIntendedPrcTypeDesc,
  TrdgContractItemUnitOfMeasure,
  ACMPricingItemQuantity,
  ValuationPoint,
  _ValPtDesc.ValuationPointDesc AS ValuationPointDesc,
  PrcgCndnTradingContrCurrency,
  ACMPrcgCndnFuturePrice,
  ACMPrcgCndnFutureTermCrcy,
  ACMPrcgCndnBasisPrc,
  PrcgConditionTermFixedRateCrcy,
  Pricing.ACMPrcgCndnFlatPrice AS ACMPrcgFirstExecInstrPrice,
  ACMPrcgCndnCumBasisRate AS ACMCumulativeBasisRateQty
FROM I_ACMMntnTrdgContrPrcgOvw_1 AS Pricing
LEFT OUTER JOIN C_ACMMntnPrcgCompData_1 AS _PriceComponent ON ACMTrdgContrSourcePriceLotID = _PriceComponent.TrdgContrPrcgAspectSrceLotID AND TradingContractNumber = _PriceComponent.TradingContractNumber AND TradingContractItem = _PriceComponent.TradingContractItem  -- association [1..*]
LEFT OUTER JOIN C_ACMMntnPrcgLotFeeDetsOvw_1 AS _PriceFee ON TradingContractNumber = _PriceFee.TradingContractNumber AND TradingContractItem = _PriceFee.TradingContractItem AND ACMPrcFixGrpIDChar32 = _PriceFee.ACMPrcFixGrpIDChar32  -- association [0..*]
LEFT OUTER JOIN C_ACMMntnPrcLotPrcMethDets AS _PriceMeth ON TradingContractNumber = _PriceMeth.TradingContractNumber AND TradingContractItem = _PriceMeth.TradingContractItem AND ACMPrcFixGrpID = _PriceMeth.ACMPrcFixGrpID  -- association [0..*]
LEFT OUTER JOIN C_ACMPrcLotCmmdtyOrder AS _PriceCommOrder ON TradingContractNumber = _PriceCommOrder.TradingContractNumber AND TradingContractItem = _PriceCommOrder.TradingContractItem AND ACMTrdgContrSourcePriceLotID = _PriceCommOrder.CmmdtyOrdReqDocPricingLot  -- association [0..*]
LEFT OUTER JOIN C_ACMMntnPrcgNominationDet AS _NomInfo ON ACMTrdgContrSourcePriceLotID = _NomInfo.TrdgContrPrcgAspectSrceLotID AND TradingContractNumber = _NomInfo.ContractNum AND TradingContractItem = _NomInfo.TradingContractItem  -- association [0..*]
LEFT OUTER JOIN C_ACMTrdgContrCancEvtDet AS _CancEventInfo ON TradingContractNumber = _CancEventInfo.TradingContractNumber AND TradingContractItem = _CancEventInfo.TradingContractItem AND ACMTrdgContrSourcePriceLotID = _CancEventInfo.ACMSourcePricingLotID  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _ClDescMM ON Pricing.ACMPurgIncotermsPart1 = _ClDescMM.IncotermsClassification AND _ClDescMM.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _ClDescSD ON Pricing.ACMSlsIncotermsPart1 = _ClDescSD.IncotermsClassification AND _ClDescSD.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ACMValuationPointVH AS _ValPtDesc ON Pricing.ValuationPoint = _ValPtDesc.ValuationPoint  -- association [0..1]
;