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,
  _PriceMeth.ACMPriceMethodProgramID AS ACMPriceMethodProgramID,
  _PriceMeth.ACMPriceMethodProgram AS ACMPriceMethodProgram,
  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,
  _PurchasingOrganizationName.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroupName.PurchasingGroupName AS PurchasingGroupName,
  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,
  _NomInfo.ConfirmedNominationNumber AS ConfirmedNominationNumber,
  _NomInfo.ConfirmedNominationItem AS ConfirmedNominationItem,
  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,
  _ValPtDesc.ValuationPointDesc AS ValuationPointDesc,
  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,
  _PriceCommOrder.CmmdtyOrderRequestStatusText AS CmmdtyOrderRequestStatusText,
  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,
  _PriceCommOrder.CmmdtyOrderRequestStatus AS CmmdtyOrderRequestStatus,
  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,
  Pricing.ACMPrcgTotAmt AS ACMPrcgPremiumAmt,
  Pricing.ACMPrcgTotAmt AS PricingConditionTermFixedRate,
  Pricing.ACMPrcgTotAmt AS ACMPrcgFirstExecInstrPrice,
  Pricing.ACMPrcgTotAmt AS ACMPrcgSecondExecInstrPrice,
  Pricing.ACMPrcgTotAmt AS ACMPrcgThirdExecInstrPrice,
  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,
  Pricing.ACMPricingRate AS ACMPricingRate,
  Pricing.ConditionTermUnit AS ConditionTermUnit,
  ACMPrcgTotAmt AS ACMPrcgNonHedgeFlatPrcAmt,
  Pricing.ACMPrcgCndnNonHedgeTermCrcy AS ACMPrcgNonHedgeFlatPrcCrcy,
  Pricing.ACMPrcgCndnNonHedgeQtyUnit AS ACMPrcgNonHedgeFlatPrcUnit,
  Pricing.ACMPrcgCndnNonHedgePriceUnit AS ACMPrcgNonHedgePrPerQuantity,
  ACMSignedStatus,
  Pricing._ContrHdrAddDets.ACMTargetTrdgContrType AS ACMTargetTrdgContrType,
  Pricing._ContrHdrAddDets.ACMTargetTrdgContrTypeName AS ACMTargetTrdgContrTypeName,
  ACMVehContrIndVal
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]
;