C_ACMMntnPrcgComponentData

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_ACMMntnPrcgComponentData.
-- 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: CMNTNPRCGCOMP

CREATE VIEW C_ACMMntnPrcgComponentData AS
SELECT
  PriceFix.TradingContractNumber AS TradingContractNumber,
  PriceFix.TradingContractItem AS TradingContractItem,
  PriceFix.ConditionType AS ConditionType,
  PricingCndnTermExtensionGroup,
  ACMConditionTermNumber,
  PrcgConditionFormulaInputUUID,
  PricingConditionTermFixedRate,
  ACMPricingStdConditionType,
  ACMNonCPEConditionType,
  ACMNonCPEConditionType2,
  PrcgConditionTermFixedRateCrcy,
  PrcgConditionTermFixedRateQty,
  cast(1 as abap.dec( 5, 0 )) AS ACMPrcgCndnVirtualFixRateQty,
  PrcgCndnTermFixedRateQtyUnit,
  DerivativeContrSpecification,
  ACMPricingMarketIdentifierCode,
  MaturityKeyDate,
  cast(CmmdtyMaturityMonthYear as cmmfdof_aif_maturity_mon_yr ) AS CmmdtyMaturityMonthYear,
  CommodityProductSymbol,
  cast(DerivativeContractMaturityCode as tba_contract_code ) AS DerivativeContractMaturityCode,
  PricingConditionQuotationKey,
  ACMTermCalcType,
  ConditionTermExtensionUsage,
  ConditionTermQuantity,
  ConditionTermUnit,
  PrcgCndnTermCnvrsnSourceCrcy,
  PrcgCndnTermCnvrsnTargetCrcy,
  PrcgCndnTermCnvrsnFxdExchRate,
  PrcgCndnTradingContrCurrency,
  Bridge.ACMPricingAspect AS ACMPricingAspect,
  Bridge.ACMPricingAspectValue AS ACMPricingAspectValue,
  TrdgContrPrcgAspectSrceLotID,
  cast(0 as abap.dec( 16, 8 )) AS ACMPrcgProvisionalRate,
  cast(1 as abap.int1) AS ACMFixedExchangeRateEditable,
  cast(1 as abap.int1) AS ACMPrcComponentAmtEditable,
  cast(1 as abap.int1) AS ACMPrcgExchangeDetEditable,
  cast(1 as abap.int1) AS ACMPrcgMaturityCodeEditable,
  cast('' as boole_d ) AS ACMPrcgIsFixZeroRateAllowed,
  BasisID,
  PriceQuotationType,
  ConditionTypeText.ACMPricingConditionTypeName AS ACMPricingConditionTypeName,
  ACMPriceConditionCategory,
  ACMPricingRate,
  PriceFix.PricingDocument AS PricingDocument,
  PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  PricingElement.PricingProcedureStep AS PricingProcedureStep,
  cast( '' as boole_d ) AS ACMPrcIsLiftFixExchOnlyAllowed,
  cast( '' as boole_d ) AS ACMPrcgIsLifted,
  cast( '' as boole_d ) AS ACMPrcgIsLiftAllowed,
  cast( 1 as menge_d ) AS ACMPrcgToLiftQty,
  PrcgCndnTermFixedRateQtyUnit AS ACMPrcgToLiftQtyUnit,
  PricingConditionTermFixedRate AS ACMPrcgLiftEquityAmt,
  PricingConditionTermFixedRate AS ACMPrcgReferencePrice,
  cast( '0' as int1 ) AS ACMPrcgReferencePriceFldCtrl,
  cast( '' as boole_d ) AS ACMPrcgIsFixTermDisabled,
  PricingConditionTermFixedRate AS ACMPrcgPriceProtectionAmt,
  cast( '' as /accgo/e_pror_rc ) AS ACMPrcgReasonCodeDetail,
  cast( '0' as int1 ) AS ACMPrcgQtyToLiftFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgVehiclesFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgLiftTermRateChkFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgOnlyFixExchLiftFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgLiftCmmdtyOrdDetFldCtrl,
  cast( PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgPriceProtectionUnit,
  cast( 1 as cpet_fixprun ) AS ACMPrcgPriceProtectionQty,
  cast( PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgPriceProtectionCrcy,
  cast( PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgReferencePriceCrcy,
  cast( PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgReferencePriceUnit,
  cast( 1 as cpet_fixprun ) AS ACMPrcgReferencePriceQty,
  cast( 1 as cpet_fixprun ) AS ACMPrcgFetchedPriceQty,
  cast( PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgFetchedPriceCrcy,
  cast( PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgFetchedPriceUnit,
  PricingConditionTermFixedRate AS ACMPrcgFetchedPriceAmt,
  cast ('' as char30) AS ACMPrcgActionPerformed,
  cast( '0' as int1 ) AS ACMPrcgActionPerformedFldCtrl,
  cast('' as /accgo/e_mntn_prcng_comp_act ) AS ACMPrcgSubAction,
  cast( 0 as /accgo/e_number_of_vehicles ) AS ACMPrcgVehiclesToLift,
  cast( '' as boole_d) AS ACMPrcgIsUpdated,
  cast( PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgLiftEquityCrcy,
  cast( PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgLiftEquityUnit,
  cast( 1 as cpet_fixprun ) AS ACMPrcgLiftEquityQty,
  Side,
  PricingConditionTermFixedRate AS ACMPrcgRolledPriceAmt,
  PricingConditionTermFixedRate AS ACMPrcgSpreadFutureAmt,
  PricingConditionTermFixedRate AS ACMPrcgPremiumAmt,
  PricingConditionTermFixedRate AS ACMPrcgSpreadBasisAmt,
  cast( '' as boole_d ) AS ACMPrcgIsRolled,
  cast( '' as boole_d ) AS ACMPrcgIsRollAllowed,
  cast( PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgSpreadFutureCrcy,
  cast( PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgSpreadFutureUnit,
  cast( 1 as cpet_fixprun ) AS ACMPrcgSpreadFutureQty,
  cast( PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgSpreadBasisCrcy,
  cast( PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgSpreadBasisUnit,
  cast( 1 as cpet_fixprun ) AS ACMPrcgSpreadBasisQty,
  cast( 0 as /accgo/e_number_of_vehicles ) AS ACMPrcgVehiclesToRoll,
  cast( 1 as menge_d ) AS ACMPrcgToRollQty,
  PrcgCndnTermFixedRateQtyUnit AS ACMPrcgToRollQtyUnit,
  cast( '0' as int1 ) AS ACMPrcgVehiclesToRollFldCtrl,
  cast( DerivativeContractMaturityCode as tba_contract_code ) AS ACMPrcgRefMaturityCode,
  cast( '0' as int1 ) AS ACMPrcgRefMaturityCodeFldCtrl,
  MaturityKeyDate AS ACMPrcgRefMaturityKeyDate,
  PricingConditionTermFixedRate AS ACMPrcgRefMatCodeRefPrcAmt,
  PrcgCndnTermCnvrsnFxdExchRate AS ACMPrcgRollSpotFxdExchRate,
  PrcgCndnTermCnvrsnFxdExchRate AS ACMPrcgRollBlendedFxdExchRate,
  cast( '' as boole_d ) AS ACMPrcgIsBasisSpreadDisabled,
  cast( '0' as int1 ) AS ACMPrcgToRollQtyFldCtrl,
  PrcgCndnTermCnvrsnFxdExchRate AS ACMPrcgRollFxdExchRate,
  cast( '0' as int1 ) AS ACMPrcgRollFxdExchRateFldCtrl,
  MaturityKeyDate AS ACMPrcgFetchedMaturityKeyDate,
  cast( '' as tba_contract_code ) AS ACMPrcgFetchedMaturityCode,
  PrcgCndnTermCnvrsnFxdExchRate AS ACMPrcgFixedFxdExchRate,
  cast( '0' as int1 ) AS ACMPrcgFixedFxdExchRateFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgBlendFxdExchRateFldCtrl,
  cast( '0' as int1 ) AS ACMPrcgSpotFxdExchRateFldCtrl,
  cast( '' as boole_d ) AS ACMPrcgIsFetchFxdExchDisabled,
  PrcgCndnTermCnvrsnFxdExchRate AS ACMPrcgBasisSpotFxdExchRate,
  cast( '0' as int1 ) AS ACMPrcgBasisSpotFxdExchFldCtrl,
  cast ( '' as boole_d ) AS ACMPrcgIsSecondaryBasis,
  cast( '' as tbac_basis_type ) AS BasisType,
  cast ( '' as boole_d ) AS ACMPrcgIsReasonCodeEnabled
FROM I_ACMPrcFixationExerData AS PriceFix
INNER JOIN I_ACMTrdgCntrPrcBridgeDets AS Bridge ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMPricingAspectData AS PriceAspect ON /* join condition not captured in parsed metadata */
INNER JOIN left ON /* join condition not captured in parsed metadata */
INNER JOIN I_ACMTrdgContrPricingElement AS PricingElement ON /* join condition not captured in parsed metadata */
;