I_ACMMntnTrdgContrPrcOvw

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_ACMMntnTrdgContrPrcOvw.
-- 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: IMNTNCNTRPRCOVW

CREATE VIEW I_ACMMntnTrdgContrPrcOvw AS
SELECT
  TrdgContrPrcgAspectDummyLotID AS ACMTrdgContrSourcePriceLotID,
  Pricing.TradingContractNumber AS TradingContractNumber,
  TradingContractItem,
  ACMConditionTermNumber AS PricingConditionTerm,
  TrdgContrPrcgAspectDummyLotID,
  _PriceMeth.ACMPriceMethodProgramID AS ACMPriceMethodProgramID,
  _PriceMeth.ACMPriceMethodProgram AS ACMPriceMethodProgram,
  TradingContractType,
  TradingContractTypeName,
  Side,
  cast( _Side.DomainText as wb2_side ) AS DocumentSide,
  ContractStatus,
  TrdgContrApplStsName,
  SalesOrganization,
  _SalesOrganizationText.SalesOrganizationText AS SalesOrganizationText,
  DistributionChannel,
  _DistributionChannelText.DistributionChannelText AS DistributionChannelText,
  Division,
  _OrganizationDivisionName.DivisionName AS DivisionName,
  PurchasingOrganization,
  _PurchasingOrganizationName.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroupName.PurchasingGroupName AS PurchasingGroupName,
  TradingContractExternalID,
  ContractPlant,
  _PlantName.PlantName AS PlantName,
  ContractMaterial,
  Material,
  _MaterialText.MaterialName AS MaterialName,
  Pricing.PricingApproach AS PricingApproach,
  _PricingApproach.PricingTypeName AS PricingTypeName,
  _CommodityDetails.Commodity AS Commodity,
  _CommodityDetails.CommodityName AS CommodityName,
  case Side when 'M' then Purchase_Counterparty.Counterparty else Sales_Counterparty.Counterparty end as Counterparty AS CounterpartyendasCounterparty,
  case Side when 'M' then Purchase_Counterparty.CustomerName else Sales_Counterparty.CustomerName end as CustomerName AS CustomerNameendasCustomerName,
  _TransactingCounterparty.TransactingCtpty AS TransactingCtpty,
  _TransactingCounterparty.ACMTransCounterpartyFullName AS ACMTransCounterpartyFullName,
  _ContrHdrAddDets.ACMOriginalTraderID AS ACMOriginalTraderID,
  _ContrHdrAddDets.ACMAmendingTraderID AS ACMAmendingTraderID,
  Pricing.AlternatePaymentTerm AS AlternatePaymentTerm,
  Incoterms,
  IncotermsLocation1,
  TrdgContrPurgIncotermsLoc1Text,
  TrdgContrSlsIncotermsLoc1Text,
  ContractTradeUnit AS UnitOfMeasure,
  Pricing.ContractTradeQuantity AS Quantity,
  TradingContrCreatedOnDate,
  PersonResponsible AS TrdgContrPersonResponsible,
  _PersonRespDetails.UserDescription AS TrdgContrPersonResponsibleName,
  TradingContractCreatedBy,
  _CreatedByDetails.UserDescription AS TradingContractCreatedByName,
  _CreatedByDetails.UserDescription AS TradingContractChangedByName,
  DocumentDate,
  ACMPricingItemQuantity,
  TrdgContractItemUnitOfMeasure,
  ValuationPoint,
  _ValPtDesc.ValuationPointDesc AS ValuationPointDesc,
  Pricing.CompanyCode AS CompanyCode,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  Pricing.DerivativeContrSpecification AS DerivativeContrSpecification,
  _DCSText.DerivativeContrSpecName AS ACMDerivativeContrSpecsTxt,
  Pricing.ACMPricingMarketIdentifierCode AS ACMPricingMarketIdentifierCode,
  _MarketIDText.MarketIdentifierCodeName AS ACMMarketIdentifierCodeTxt,
  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,
  _IntendedPrcType.DomainText AS ACMPrcgIntendedPrcTypeDesc,
  Pricing.ACMYourReference AS ACMYourReference,
  Pricing.ACMCustomerReference AS ACMCustomerReference,
  Pricing.ACMPrcgCndnFuturePrice AS ACMPrcgCndnFuturePrice,
  Pricing.ACMPrcgCndnFutureTermCrcy AS ACMPrcgCndnFutureTermCrcy,
  Pricing.ACMPrcgCndnFixedRateFutureUoM AS ACMPrcgCndnFixedRateFutureUoM,
  UnitOfMeasure AS ACMPrcgCndnFlatRateFutureUoM,
  Pricing.ACMPrcgCndnBasisPrc AS ACMPrcgCndnBasisPrc,
  Pricing.PrcgConditionTermFixedRateCrcy AS PrcgConditionTermFixedRateCrcy,
  Pricing.ACMPrcgCndnNonHedgeTermCrcy AS ACMPrcgCndnNonHedgeTermCrcy,
  Pricing.ACMPrcgCndnNonHedgePriceUnit AS ACMPrcgCndnNonHedgePriceUnit,
  Pricing.ACMPrcgCndnNonHedgeQtyUnit AS ACMPrcgCndnNonHedgeQtyUnit,
  Pricing.ACMPrcgCndnFlatPrice AS ACMPrcgCndnFlatPrice,
  cast( '000000' as numc06 ) AS ACMPrcgSourceLotGroup,
  $session.user AS SessionUser,
  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.ACMPricingRate AS ACMPricingRate,
  Pricing.ConditionTermUnit AS ConditionTermUnit,
  cast( Quantity as menge_d ) AS ACMPrcgToLiftQty,
  cast( UnitOfMeasure as cpet_uomfrom ) AS ACMPrcgToLiftQtyUnit,
  cast( Quantity as menge_d ) AS ACMPrcgToRollQty,
  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,
  ACMPrcgCndnFlatPrice 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 ACMPrcgFutIsUserChanged,
  ACMPrcgCndnFlatPrice AS ACMPrcgCancFutureRefPrice,
  ACMPrcgCndnFlatPrice AS ACMPrcgCancFutureFetchedPrice,
  cast ( '0' as int1 ) AS ACMPrcgCancFutureRefPrcFldCtrl,
  ACMPrcgCndnFlatPrice AS ACMPrcgCancBasisRefPrice,
  ACMPrcgCndnFlatPrice 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 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,
  _PriceCommOrder.CmmdtyOrderRequestStatusText AS CmmdtyOrderRequestStatusText,
  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.ACMPrcgCndnFlatPrice AS ACMPrcgRolledPriceAmt,
  Pricing.ACMPrcgCndnFlatPrice AS ACMPrcgSpreadFutureAmt,
  Pricing.ACMPrcgCndnFlatPrice AS ACMPrcgPremiumAmt,
  ACMPrcgCndnFutureTermCrcy AS PrcgCndnTermCnvrsnSourceCrcy,
  Pricing.ACMPrcgCndnFlatPrice AS PricingConditionTermFixedRate,
  Pricing.ACMPrcgCndnFlatPrice AS ACMPrcgFirstExecInstrPrice,
  Pricing.ACMPrcgCndnFlatPrice AS ACMPrcgSecondExecInstrPrice,
  Pricing.ACMPrcgCndnFlatPrice 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,
  ACMPrcgCndnFlatPrice AS ACMPrcgNonHedgeFlatPrcAmt,
  Pricing.ACMPrcgCndnNonHedgeTermCrcy AS ACMPrcgNonHedgeFlatPrcCrcy,
  Pricing.ACMPrcgCndnNonHedgeQtyUnit AS ACMPrcgNonHedgeFlatPrcUnit,
  Pricing.ACMPrcgCndnNonHedgePriceUnit AS ACMPrcgNonHedgePrPerQuantity,
  cast( '1' as int1 ) AS ACMPrcgOverfillFldCtrl
FROM I_ACMTrdgContrPrcLotDet AS Pricing
LEFT OUTER JOIN I_TrdgContrPrcFixPrcMethDet AS _PriceMeth ON _PriceMeth.TradingContractNumber = TradingContractNumber AND _PriceMeth.TradingContractItem = TradingContractItem AND _PriceMeth.PricingConditionTerm = PricingConditionTerm  -- association [0..*]
LEFT OUTER JOIN I_ACMTrdgContrHdrAddlDets AS _ContrHdrAddDets ON _ContrHdrAddDets.TradingContractNumber = Pricing.TradingContractNumber  -- association [1..1]
LEFT OUTER JOIN I_ACMCommodityDetails AS _CommodityDetails ON Pricing.Material = _CommodityDetails.Material  -- association [1..1]
LEFT OUTER JOIN I_ACMTrdgContrPartForMntnContr AS _TransactingCounterparty ON _TransactingCounterparty.TradingContractNumber = Pricing.TradingContractNumber  -- association [0..1]
LEFT OUTER JOIN I_ACMMntnPrcgLotCmmdtyOrder AS _PriceCommOrder ON _PriceCommOrder.TradingContractNumber = TradingContractNumber AND _PriceCommOrder.TradingContractItem = TradingContractItem AND _PriceCommOrder.PricingConditionTerm = PricingConditionTerm  -- association [0..*]
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_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_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_PlantStdVH AS _PlantName ON Pricing.ContractPlant = _PlantName.Plant  -- 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_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_CompanyCode AS _CompanyCodeText ON _CompanyCodeText.CompanyCode = Pricing. CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ACMValuationPointVH AS _ValPtDesc ON Pricing.ValuationPoint = _ValPtDesc.ValuationPoint  -- association [0..1]
LEFT OUTER JOIN I_ACMMntnContrSideText AS _Side ON Side = _Side.DomainValue  -- association [0..1]
;