C_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 C_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: CMNTNCONTPRCGOVW

CREATE VIEW C_ACMMntnTrdgContrPrcgOvw AS
SELECT
  TrdgContrPrcgAspectDummyLotID AS ACMTrdgContrSourcePriceLotID,
  TradingContractNumber,
  PricingConditionTerm,
  TradingContractItem,
  TrdgContrPrcgAspectDummyLotID,
  TradingContractType,
  TradingContractTypeName,
  Side,
  Pricing._Side.DomainText AS DocumentSide,
  ContractStatus,
  TradingContractCurrency,
  TrdgContrApplStsName,
  SalesOrganization,
  Pricing._SalesOrganizationText.SalesOrganizationText AS SalesOrganizationText,
  DistributionChannel,
  Pricing._DistributionChannelText.DistributionChannelText AS DistributionChannelText,
  Division,
  Pricing._OrganizationDivisionName.DivisionName AS DivisionName,
  PurchasingOrganization,
  PurchasingGroup,
  TradingContractExternalID,
  ContractPlant,
  Pricing._PlantName.PlantName AS PlantName,
  ContractMaterial,
  Material,
  Pricing._MaterialText.MaterialName AS MaterialName,
  PricingApproach,
  Pricing._PricingApproach.PricingTypeName AS PricingTypeName,
  Pricing._CommodityDetails.Commodity AS Commodity,
  Pricing._CommodityDetails.CommodityName AS CommodityName,
  Pricing._Counterparty.Counterparty AS Counterparty,
  Pricing._Counterparty.CounterpartyFullName AS CounterpartyFullName,
  Pricing._Counterparty.ACMCounterpartyFirstName AS ACMCounterpartyFirstName,
  Pricing._Counterparty.ACMCounterpartyLastName AS ACMCounterpartyLastName,
  Pricing._Counterparty.AuthorizationGroup AS AuthorizationGroup,
  Pricing._Counterparty.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  Pricing._TransactingCounterparty.TransactingCtpty AS TransactingCtpty,
  Pricing._TransactingCounterparty.ACMTransCounterpartyFullName AS ACMTransCounterpartyFullName,
  cast( '' as abap.char(30)) AS ACMNominationList,
  Pricing._ContrHdrAddDets.ACMOriginalTraderID AS ACMOriginalTraderID,
  Pricing._ContrHdrAddDets.ACMOriginalTraderIDText AS ACMOriginalTraderIDText,
  Pricing._ContrHdrAddDets.ACMAmendingTraderID AS ACMAmendingTraderID,
  Pricing._ContrHdrAddDets.ACMAmendingTraderIDText AS ACMAmendingTraderIDText,
  Incoterms,
  TrdgContrCreditSalesVals,
  IncotermsLocation1,
  TrdgContrPurgIncotermsLoc1Text,
  TrdgContrSlsIncotermsLoc1Text,
  UnitOfMeasure,
  Quantity,
  TrdgContrPersonResponsible,
  Pricing._PersonRespDetails.UserDescription AS TrdgContrPersonResponsibleName,
  TradingContractCreatedBy,
  Pricing._CreatedByDetails.UserDescription AS TradingContractCreatedByName,
  TradingContractChangedBy,
  DocumentDate,
  TradingContrCreatedOnDate,
  TradingContrChangedOnDate,
  CompanyCode,
  Pricing._CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  DerivativeContrSpecification,
  Pricing._DCSText.DerivativeContrSpecName AS ACMDerivativeContrSpecsTxt,
  ACMPricingMarketIdentifierCode,
  Pricing._MarketIDText.MarketIdentifierCodeName AS ACMMarketIdentifierCodeTxt,
  MaturityKeyDate,
  DerivativeContractMaturityCode,
  ACMPrcgTotAmt,
  CmmdtyDealDetEffectiveToDate,
  CmmdtyDealDetEffectiveFromDate,
  ACMPrcgIntendedPrcType,
  Pricing._IntendedPrcType.DomainText AS ACMPrcgIntendedPrcTypeDesc,
  ACMCustomerReference,
  ACMYourReference,
  cast(1 as abap.int4) AS ConditionCount,
  TrdgContractItemUnitOfMeasure,
  ACMPricingItemQuantity,
  ValuationPoint,
  AlternatePaymentTerm,
  cast('' as abap.char( 256 )) AS PaymentTermsDescription,
  ACMPrcgCndnFutureTermCrcy,
  PrcgConditionTermFixedRateCrcy,
  PrcgCndnTradingContrCurrency,
  ACMPrcgCndnFuturePrice,
  ACMPrcgCndnBasisPrc,
  ACMPrcgTotAmt AS ACMPrcgCndnFlatPrice,
  ACMPrcgCndnFixedRateFutureUoM,
  UnitOfMeasure AS ACMPrcgCndnFlatRateFutureUoM,
  cast( '000000' as numc06 ) AS ACMPrcgSourceLotGroup,
  $session.user AS SessionUser,
  ACMTrdgContrPrcgStatusText,
  TrdgContrPrcgAspectSrceLotID,
  PricingDocument,
  ACMContractStatusIsPosRelevant,
  ACMTrdgContrStatusCategory,
  cast( '' as /accgo/e_mntn_prcng_comp_act ) AS ACMPrcgSubAction,
  cast ( 01 as int1 ) AS ACMPrcgQtyToBePricedFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgToRollQtyFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgVehiclesToRollFldCtrl,
  Quantity AS ACMPrcgHdrOpenQty,
  cast( '0' as int1 ) AS ACMPrcgHdrOpenQtyFldCtrl,
  Quantity AS ACMPrcgHdrEditQty,
  cast ( '' as absgr ) AS ACMPrcgCancellationCode,
  cast( $session.system_date as datum ) AS ACMPrcgCancellationDate,
  cast( $session.system_date as datum ) AS ACMPrcgCancEffectiveDate,
  cast( PrcgCndnTradingContrCurrency as waers ) AS PricingFormulaCurrency,
  cast( 0 as /accgo/e_fee ) AS ACMPrcgCancellationFee,
  cast( PrcgCndnTradingContrCurrency as waers ) AS ACMPrcgCancellationFeeCurrency,
  cast( 1 as cpet_fixprun ) AS ACMPrcgCancFeePrcUnitQty,
  cast ( '' as text_val ) AS ACMPrcgCancellationCodeText,
  cast ( '' as text_val ) AS ACMPrcgCancellationTypeText,
  Quantity AS ACMPrcgToBeCancelledQty,
  Quantity AS ACMPrcgAllwdToSpltQty,
  cast( 0 as /accgo/e_number_of_vehicles ) AS ACMPrcgVehToBeCancelled,
  cast( '0' as int1 ) AS ACMPrcgToBeCancelledQtyFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgVehToBeCancelledFldCtrl,
  Quantity AS ACMPrcgToBeCancelledHdrQty,
  cast( '0' as int1 ) AS ACMPrcgToBeCancHdrQtyFldCtrl,
  cast( '' as boole_d ) AS ACMPrcgIsCancellationAllowed,
  ACMPrcgTotAmt AS ACMPrcgCancellationEquityAmt,
  cast( PrcgCndnTradingContrCurrency as cpet_fixcurr ) AS ACMPrcgCancellationEquityCrcy,
  cast( 1 as cpet_fixprun ) AS ACMPrcgCancEquityPrcUnitQty,
  cast( UnitOfMeasure as cpet_fixuom ) AS ACMPrcgCancellationEquityUnit,
  cast( '' as boole_d ) AS ACMPrcgBasIsUserChanged,
  cast( '' as boole_d ) AS ACMPrcgFutIsUserChanged,
  ACMPrcgTotAmt AS ACMPrcgCancFutureRefPrice,
  ACMPrcgTotAmt AS ACMPrcgCancFutureFetchedPrice,
  cast ( '0' as int1 ) AS ACMPrcgCancFutureRefPrcFldCtrl,
  ACMPrcgTotAmt AS ACMPrcgCancBasisRefPrice,
  ACMPrcgTotAmt AS ACMPrcgCancBasisFetchedPrice,
  cast( PrcgCndnTradingContrCurrency as cpet_fixcurr ) AS ACMPrcgCancBasisRefPriceCrcy,
  cast( 1 as cpet_fixprun ) AS ACMPrcgCancBasisRefPriceQty,
  cast( UnitOfMeasure as cpet_fixuom ) AS ACMPrcgCancBasisRefPriceUnit,
  cast( '' as /accgo/e_pror_rc ) AS ACMPrcgFutureReasonCodeDetail,
  cast( '' as /accgo/e_pror_rc ) AS ACMPrcgBasisReasonCodeDetail,
  cast ( '0' as int1 ) AS ACMPrcgCancBasisRefPrcFldCtrl,
  cast ( '0' as int1 ) AS ACMPrcgFutureReasonCodeFldCtrl,
  cast ( '0' as int1 ) AS ACMPrcgBasisReasonCodeFldCtrl,
  cast ( '' as boole_d ) AS ACMPrcgIsCancelled,
  cast( '' as kurst_curr ) AS ACMPrcgExchRateType,
  cast( '' as /accgo/e_cancl_typ ) AS ACMPrcgCancellationType,
  cast( '1' as int1 ) AS ACMPrcgUnitOfMeasureFldCtrl,
  cast( '0' as int1 ) AS ACMPricingFormulaCrcyFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgCanclnButtonFldCtrl,
  cast( '' as cmmfdor_ordertype ) AS ACMPrcgCmmdtyOrdType,
  cast( '' as cmmfdor_ordertypetext ) AS ACMPrcgCmmdtyOrdTypeText,
  cast( '' as cmmfdor_orderrequstatusreason ) AS ACMPrcgCmmdtyOrdRequestReason,
  cast( 0 as cmmfdor_ordreqnumberoflots ) AS ACMPrcgCmmdtyOrdNmbrOfOrdLots,
  cast( '' as /accgo/e_cdote_ordreason_desc ) AS ACMPrcgCmmdtyOrdReqReasonTxt,
  Quantity AS ACMPrcgCmmdtyOrdQty,
  cast( 0 as int1 ) AS ACMPrcgCmmdtyOrdQtyFldCtrl,
  cast( 0 as /accgo/e_number_of_vehicles ) AS ACMPrcgCmmdtyOrdVeh,
  cast( 0 as int1 ) AS ACMPrcgCmmdtyOrdVehFldCtrl,
  cast( '' as cmmfdor_orderrequestflowtype ) AS ACMPrcgCmmdtyOrdFlowType,
  cast( '' as cmmfdor_ordreqflowtypetext ) AS ACMPrcgCmmdtyOrdFlowTypeTxt,
  cast( '' as rdealer ) AS ACMPrcgCmmdtyOrdTraderID,
  cast( $session.system_date as datum ) AS ACMPrcgCmmdtyOrdFetchPriceDate,
  cast( '' as cmmfdor_orderpricingexecinst ) AS ACMPrcgExecInstruction,
  cast( '' as text_30 ) AS ACMPrcgExecInstructionTxt,
  cast( '' as text_30 ) AS ACMPrcgExpiryInstructionTxt,
  cast( '' as cmmfdor_orderexpirationinst ) AS ACMPrcgExpiryInstruction,
  cast( $session.system_date as datum ) AS ACMPrcgCmmdtyOrdExpiryDate,
  cast( '' as boole_d ) AS ACMPrcgIsCmmdtyOrdPrcgAllowed,
  cast( '' as boole_d ) AS ACMPrcgIsCmmdtyOrdPlaced,
  cast( '' as cmmfdor_ordreqexchangetype ) AS ACMPrcgCmmdtyOrdExchType,
  cast( '' as cmmfdor_ordreqexchangetypetext ) AS ACMPrcgCmmdtyOrdExchTypeTxt,
  cast( '' as cmmfdor_cntrparty_broker ) AS ACMPrcgCmmdtyOrdCtptyBroker,
  cast( '' as cmmfsa_referencebrokeraccount ) AS ACMPrcgCmmdtyOrdBrokerAccount,
  cast( '' as cmmfdor_ordreqcntrptysubacct ) AS ACMPrcgCounterpartySubAccount,
  ACMPrcgCndnFuturePrice AS ACMPrcgCmmdtyOrdLeewayPriceAmt,
  ACMPrcgCndnFuturePrice AS ACMPrcgCmmdtyOrdLeewayRngeAmt,
  ACMPrcgCndnFuturePrice AS ACMPrcgCmmdtyOrdLimitSpreadPrc,
  cast( 0 as cmmfdor_ordreqlongfuture ) AS ACMPrcgCmmdtyOrdLongFutureID,
  cast( 0 as cmmfdor_cmmdtyordfillfutureid ) AS ACMPrcgCmmdtyOrdShortFutureID,
  cast( '' as cmmfdof_cmmdtyordfillextordref ) AS ACMPrcgCmmdtyOrdExternalDocRef,
  cast( $session.system_date as tba_keydate ) AS ACMPrcgLongMaturityKeyDte,
  cast( $session.system_date as tba_keydate ) AS ACMPrcgShortMaturityKeyDte,
  cast( 0 as cmmfdor_ordnegotiationdatetime ) AS ACMPrcgNegotiatedDateTime,
  cast( 0 as cmmfdor_ordreqticks ) AS ACMPrcgCmmdtyOrdRequestTicks,
  ACMPrcgCndnFuturePrice AS ACMPrcgReferencePrice,
  ACMPrcgCndnFuturePrice AS ACMPrcgCmmdtyOrdStopPrice,
  ACMPrcgCndnFuturePrice AS ACMPrcgCmmdtyOrdLimitPrice,
  ACMPrcgCndnFuturePrice AS ACMPrcgCmmdtyOrdStopLimitPrice,
  cast( '' as cpet_uomfrom) AS PrcgCndnTermFixedRateQtyUnit,
  cast( 1 as cpet_fixprun ) AS PrcgConditionTermFixedRateQty,
  cast( 0 as int4 ) AS ACMPrcgCmmdtyOrdSequenceNumber,
  ACMPrcgCmmdtyOrdSubAccountID,
  ACMTrdgContrSubAccountName,
  cast( '' as cmmfdor_orderrequestdoctype ) AS ACMPrcgCmmdtyOrdDocumentType,
  cast( '0' as int1 ) AS ACMPrcgNegotiatedOnFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgSpreadSpotFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgCmmdtyOrdTraderFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgSpreadBasisFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgRefMaturityCodeFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgRefMarketPriceFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgRefMarketCrcyFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgRefFlowTypeFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgCmmdtyOrdRefAmtFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgCmmdtyOrdQtyUnitFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgCmmdtyOrderLotsFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgBrokerAccountFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgCmmdtyOrdBrokerFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgCtptyBrokerFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgCtptySubAccountFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgCounterpartyFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgExchangeTypeFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgExecutionInstrFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgExecutionTicksFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgExpirationDateFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgExpirationInstrFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgFlowTypeFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgOrderLiftFxdExchFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgMaturityCodeFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgMaturityCodeDescFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgMaturityKeyDateFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgAmountFldCtrl,
  cast( '' as cmmfdor_orderrequestflowtype ) AS ACMPrcgCmmdtyOrdRefFlowType,
  cast( '' as cmmfdor_ordreqflowtypetext ) AS ACMPrcgCmmdtyOrdRefFlowTypeTxt,
  cast( '' as boole_d ) AS ACMPrcgIsRolledWithCmmdtyOrd,
  cast( '' as boole_d ) AS ACMPrcgIsRollWthCmmdtyOrdAllwd,
  cast( '' as boole_d ) AS ACMPrcgIsLiftedWithCmmdtyOrd,
  cast( '' as boole_d ) AS ACMPrcgIsLiftWthCmmdtyOrdAllwd,
  cast( '' as boole_d ) AS ACMPrcgIsCancelledWthCmmdtyOrd,
  cast( '' as boole_d ) AS ACMPrcgIsCancWthCmmdtyOrdAllwd,
  cast( '' as tba_contract_code ) AS ACMPrcgRefMaturityCode,
  cast( '' as tba_keydate ) AS ACMPrcgRefMaturityKeyDate,
  cast( 0 as cpet_fixexchrate ) AS ACMPrcgRollSpotFxdExchRate,
  cast( 0 as cpet_fixexchrate ) AS ACMPrcgRollBlendedFxdExchRate,
  cast( '0' as int1 ) AS ACMPrcgBlendFxdExchRateFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgSpotFxdExchRateFldCtrl,
  cast( '' as boole_d ) AS ACMPrcgIsFetchFxdExchDisabled,
  cast( 0 as int1 ) AS ACMPrcgThirdExecPrcFldCtrl,
  cast( 0 as int1 ) AS ACMPrcgSecondExecPrcFldCtrl,
  cast( 0 as int1 ) AS ACMPrcgFirstExecPrcFldCtrl,
  cast( '' as cpet_cond_type ) AS ConditionType,
  cast( '' as vtxtm ) AS ACMPricingConditionTypeName,
  ACMPrcgCndnFuturePrice AS ACMContrPrcgCumltvBsAmt,
  ACMFormulaUoM,
  ACMPrcgTotAmt AS ACMPrcgNonHedgeFlatPrcAmt,
  ACMSignedStatus,
  Pricing._ContrHdrAddDets.ACMTargetTrdgContrType AS ACMTargetTrdgContrType,
  Pricing._ContrHdrAddDets.ACMTargetTrdgContrTypeName AS ACMTargetTrdgContrTypeName,
  ACMVehContrIndVal,
  Pricing.ACMPrcgTotAmt AS ACMPrcgPremiumAmt,
  Pricing.ACMPrcgTotAmt AS PricingConditionTermFixedRate,
  Pricing.ACMPrcgTotAmt AS ACMPrcgFirstExecInstrPrice,
  Pricing.ACMPrcgTotAmt AS ACMPrcgSecondExecInstrPrice,
  Pricing.ACMPrcgTotAmt AS ACMPrcgThirdExecInstrPrice,
  Pricing.ACMPricingRate AS ACMPricingRate,
  Pricing.ConditionTermUnit AS ConditionTermUnit,
  Pricing.ACMPrcgCndnNonHedgeTermCrcy AS ACMPrcgNonHedgeFlatPrcCrcy,
  Pricing.ACMPrcgCndnNonHedgeQtyUnit AS ACMPrcgNonHedgeFlatPrcUnit,
  Pricing.ACMPrcgCndnNonHedgePriceUnit AS ACMPrcgNonHedgePrPerQuantity,
  _NomInfo.ConfirmedNominationNumber AS ConfirmedNominationNumber,
  _NomInfo.ConfirmedNominationItem AS ConfirmedNominationItem,
  _PriceCommOrder.CmmdtyOrderRequestStatusText AS CmmdtyOrderRequestStatusText,
  _PriceCommOrder.CmmdtyOrderRequestStatus AS CmmdtyOrderRequestStatus,
  _PriceMeth.ACMPriceMethodProgramID AS ACMPriceMethodProgramID,
  _PriceMeth.ACMPriceMethodProgram AS ACMPriceMethodProgram,
  _PurchasingGroupName.PurchasingGroupName AS PurchasingGroupName,
  _PurchasingOrganizationName.PurchasingOrganizationName AS PurchasingOrganizationName,
  _ValPtDesc.ValuationPointDesc AS ValuationPointDesc
FROM I_ACMMntnTrdgContrPrcgOvw AS Pricing
LEFT OUTER JOIN C_ACMMntnPrcgComponentData AS _PriceComponent ON TrdgContrPrcgAspectDummyLotID = _PriceComponent.TrdgContrPrcgAspectSrceLotID AND TradingContractNumber = _PriceComponent.TradingContractNumber AND TradingContractItem = _PriceComponent.TradingContractItem AND PricingConditionTerm = _PriceComponent.ACMConditionTermNumber  -- association [1..*]
LEFT OUTER JOIN C_ACMMntnPrcgLotFeeDetsOvw AS _PriceFee ON TradingContractNumber = _PriceFee.TradingContractNumber AND TradingContractItem = _PriceFee.TradingContractItem AND PricingConditionTerm = _PriceFee.PricingConditionTerm  -- association [0..*]
LEFT OUTER JOIN C_ACMMntnPrcLotPrcMethDets AS _PriceMeth ON TradingContractNumber = _PriceMeth.TradingContractNumber AND TradingContractItem = _PriceMeth.TradingContractItem AND PricingConditionTerm = _PriceMeth.PricingConditionTerm  -- association [0..*]
LEFT OUTER JOIN C_ACMMntnPrcLotCmmdtyOrder AS _PriceCommOrder ON TradingContractNumber = _PriceCommOrder.TradingContractNumber AND TradingContractItem = _PriceCommOrder.TradingContractItem AND PricingConditionTerm = _PriceCommOrder.PricingConditionTerm  -- association [0..*]
LEFT OUTER JOIN C_ACMMntnPrcgNominationDet AS _NomInfo ON TrdgContrPrcgAspectDummyLotID = _NomInfo.TrdgContrPrcgAspectSrceLotID  -- association [0..*]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncoDescmm ON Pricing.ACMPurgIncotermsPart1 = _IncoDescmm.IncotermsClassification AND _IncoDescmm.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncoDescsd ON Pricing.ACMSlsIncotermsPart1 = _IncoDescsd.IncotermsClassification AND _IncoDescsd.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ACMValuationPointVH AS _ValPtDesc ON Pricing.ValuationPoint = _ValPtDesc.ValuationPoint  -- association [0..1]
LEFT OUTER JOIN I_VehicleContractValueHelp AS _signedStatus ON ACMSignedStatus = _signedStatus.DomainValue  -- association [0..1]
;