C_ACMMntnPrcgCompData_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_ACMMntnPrcgCompData_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_ACMMntnPrcgCompData_1 AS
SELECT
  PriceAspect.TradingContractNumber AS TradingContractNumber,
  PriceAspect.TradingContractItem AS TradingContractItem,
  PriceFixExerData.ConditionType AS ConditionType,
  PriceFixExerData.PricingCndnTermExtensionGroup AS PricingCndnTermExtensionGroup,
  PriceFixExerData.ACMConditionTermNumber AS ACMConditionTermNumber,
  PriceAspect.ACMPrcFixGrpID AS ACMPrcFixGrpID,
  PriceFixExerData.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  PriceFixExerData.PricingConditionTermFixedRate AS PricingConditionTermFixedRate,
  PriceFixExerData.ACMDocumentUnitOfMeasure AS ACMDocumentUnitOfMeasure,
  PriceFixExerData.ACMDocPerQty AS ACMDocPerQty,
  PriceFixExerData.ACMDocumentCurrency AS ACMDocumentCurrency,
  PriceFixExerData.ACMPricingStdConditionType AS ACMPricingStdConditionType,
  PriceAspect.ACMNonCPEConditionType AS ACMNonCPEConditionType,
  PriceAspect.ACMNonCPEConditionType2 AS ACMNonCPEConditionType2,
  PriceFixExerData.PrcgConditionTermFixedRateCrcy AS PrcgConditionTermFixedRateCrcy,
  PriceFixExerData.PrcgConditionTermFixedRateQty AS PrcgConditionTermFixedRateQty,
  cast(1 as abap.dec( 5, 0 )) AS ACMPrcgCndnVirtualFixRateQty,
  cast( PriceFixExerData.PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS PrcgCndnTermFixedRateQtyUnit,
  PriceFixExerData.DerivativeContrSpecification AS DerivativeContrSpecification,
  PriceFixExerData.ACMPricingMarketIdentifierCode AS ACMPricingMarketIdentifierCode,
  PriceFixExerData.MaturityKeyDate AS MaturityKeyDate,
  cast(PriceFixExerData.CmmdtyMaturityMonthYear as cmmfdof_aif_maturity_mon_yr ) AS CmmdtyMaturityMonthYear,
  PriceFixExerData.CommodityProductSymbol AS CommodityProductSymbol,
  cast(PriceFixExerData.DerivativeContractMaturityCode as tba_contract_code ) AS DerivativeContractMaturityCode,
  PriceFixExerData.PricingConditionQuotationKey AS PricingConditionQuotationKey,
  PriceFixExerData.ACMTermCalcType AS ACMTermCalcType,
  PriceFixExerData.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
  PriceFixExerData.ConditionTermQuantity AS ConditionTermQuantity,
  PriceFixExerData.ConditionTermUnit AS ConditionTermUnit,
  PriceFixExerData.PrcgCndnTermCnvrsnSourceCrcy AS PrcgCndnTermCnvrsnSourceCrcy,
  PriceFixExerData.PrcgCndnTermCnvrsnTargetCrcy AS PrcgCndnTermCnvrsnTargetCrcy,
  PriceFixExerData.PrcgConditionFixedExchangeRate AS PrcgCndnTermCnvrsnFxdExchRate,
  PriceFixExerData.PrcgCndnTradingContrCurrency AS PrcgCndnTradingContrCurrency,
  PriceAspect.TrdgContrPrcgAspectSrceLotID AS TrdgContrPrcgAspectSrceLotID,
  PriceFixExerData.PrcgCndnUsedExchangeRate 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,
  PriceFixExerData.BasisID AS BasisID,
  PriceFixExerData.PriceQuotationType AS PriceQuotationType,
  PriceFixExerData.ACMPricingConditionTypeName AS ACMPricingConditionTypeName,
  PriceFixExerData.ACMPriceConditionCategory AS ACMPriceConditionCategory,
  PriceFixExerData.ACMPricingRate AS ACMPricingRate,
  PriceFixExerData.PricingDocument AS PricingDocument,
  PriceFixExerData.ConditionIsForStatistics AS ConditionIsForStatistics,
  PriceFixExerData.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,
  cast( PriceFixExerData.PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgToLiftQtyUnit,
  PriceFixExerData.PricingConditionTermFixedRate AS ACMPrcgLiftEquityAmt,
  PriceFixExerData.PricingConditionTermFixedRate AS ACMPrcgReferencePrice,
  cast( '0' as int1 ) AS ACMPrcgReferencePriceFldCtrl,
  cast( '' as boole_d ) AS ACMPrcgIsFixTermDisabled,
  PriceFixExerData.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(PriceFixExerData.PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgPriceProtectionUnit,
  cast( 1 as cpet_fixprun ) AS ACMPrcgPriceProtectionQty,
  cast( PriceFixExerData.PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgPriceProtectionCrcy,
  cast( PriceFixExerData.PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgReferencePriceCrcy,
  cast( PriceFixExerData.PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgReferencePriceUnit,
  cast( 1 as cpet_fixprun ) AS ACMPrcgReferencePriceQty,
  cast( 1 as cpet_fixprun ) AS ACMPrcgFetchedPriceQty,
  cast( PriceFixExerData.PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgFetchedPriceCrcy,
  cast( PriceFixExerData.PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgFetchedPriceUnit,
  PriceFixExerData.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( PriceFixExerData.PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgLiftEquityCrcy,
  cast( PriceFixExerData.PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgLiftEquityUnit,
  cast( 1 as cpet_fixprun ) AS ACMPrcgLiftEquityQty,
  PriceAspect.Side AS Side,
  PriceFixExerData.PricingConditionTermFixedRate AS ACMPrcgRolledPriceAmt,
  PriceFixExerData.PricingConditionTermFixedRate AS ACMPrcgSpreadFutureAmt,
  PriceFixExerData.PricingConditionTermFixedRate AS ACMPrcgPremiumAmt,
  PriceFixExerData.PricingConditionTermFixedRate AS ACMPrcgSpreadBasisAmt,
  cast( '' as boole_d ) AS ACMPrcgIsRolled,
  cast( '' as boole_d ) AS ACMPrcgIsRollAllowed,
  cast( PriceFixExerData.PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgSpreadFutureCrcy,
  cast( PriceFixExerData.PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgSpreadFutureUnit,
  cast( PriceFixExerData.PrcgConditionTermFixedRateQty as cpet_fixprun ) AS ACMPrcgSpreadFutureQty,
  cast( PriceFixExerData.PrcgConditionTermFixedRateCrcy as cpet_fixcurr ) AS ACMPrcgSpreadBasisCrcy,
  cast( PriceFixExerData.PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgSpreadBasisUnit,
  cast( PriceFixExerData.PrcgConditionTermFixedRateQty as cpet_fixprun ) AS ACMPrcgSpreadBasisQty,
  cast( 0 as /accgo/e_number_of_vehicles ) AS ACMPrcgVehiclesToRoll,
  cast( 1 as menge_d ) AS ACMPrcgToRollQty,
  cast( PriceFixExerData.PrcgCndnTermFixedRateQtyUnit as cpet_uomfrom ) AS ACMPrcgToRollQtyUnit,
  cast( '0' as int1 ) AS ACMPrcgVehiclesToRollFldCtrl,
  PriceFixExerData.DerivativeContractMaturityCode AS ACMPrcgRefMaturityCode,
  cast( '0' as int1 ) AS ACMPrcgRefMaturityCodeFldCtrl,
  PriceFixExerData.MaturityKeyDate AS ACMPrcgRefMaturityKeyDate,
  PriceFixExerData.PricingConditionTermFixedRate AS ACMPrcgRefMatCodeRefPrcAmt,
  PriceFixExerData.PrcgConditionFixedExchangeRate AS ACMPrcgRollSpotFxdExchRate,
  PriceFixExerData.PrcgConditionFixedExchangeRate AS ACMPrcgRollBlendedFxdExchRate,
  cast( '' as boole_d ) AS ACMPrcgIsBasisSpreadDisabled,
  cast( '0' as int1 ) AS ACMPrcgToRollQtyFldCtrl,
  PriceFixExerData.PrcgConditionFixedExchangeRate AS ACMPrcgRollFxdExchRate,
  cast( '0' as int1 ) AS ACMPrcgRollFxdExchRateFldCtrl,
  PriceFixExerData.MaturityKeyDate AS ACMPrcgFetchedMaturityKeyDate,
  cast( '' as tba_contract_code ) AS ACMPrcgFetchedMaturityCode,
  PriceFixExerData.PrcgConditionFixedExchangeRate 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,
  PriceFixExerData.PrcgConditionFixedExchangeRate 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,
  dcs_text.DerivativeContrSpecName AS ACMDerivativeContrSpecsTxt,
  mic_text.MarketIdentifierCodeName AS ACMMarketIdentifierCodeTxt,
  PriceFixExerData.ConditionClass AS ConditionClass,
  PriceFixExerData.PricingConditionComponentType AS PricingConditionComponentType
FROM I_ACMPricingAspectData AS PriceAspect
INNER JOIN I_ACMPrcFixExerData AS PriceFixExerData ON /* join condition not captured in parsed metadata */
;