I_CmmdtyPrcgCndnExerciseTerm

DDL: I_CMMDTYPRCGCNDNEXERCISETERM Type: view_entity COMPOSITE
124 Fields 1 Data Sources

Exercise Term in Pricing Condition

I_CmmdtyPrcgCndnExerciseTerm is a Composite CDS View that provides data about "Exercise Term in Pricing Condition" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyPricingConditionTerm) and exposes 124 fields with key fields DocItmCmmdtyPrcgCndnUUID, PricingConditionTerm.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyPricingConditionTerm I_CmmdtyPricingConditionTerm from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Exercise Term in Pricing Condition view
ObjectModel.sapObjectNodeType.name CmmdtyPrcgCndnExerciseTerm view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

Fields (124)

KeyFieldSource TableSource FieldDescription
KEY DocItmCmmdtyPrcgCndnUUID DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID
KEY PricingConditionTerm PricingConditionTerm Term Number
ConditionType ConditionType Condition type
PrcgCndnTrmQtnFxdPeriodStrtDte PrcgCndnTrmQtnFxdPeriodStrtDte Quot. Fx. Start Date
PrcgCndnTrmQtnFxdPeriodStrtTme PrcgCndnTrmQtnFxdPeriodStrtTme FixedStartTimeQuot.
PrcgCndnTrmQtnFxdPeriodEndDate PrcgCndnTrmQtnFxdPeriodEndDate Quot. Fx. End Date
PrcgCndnTrmQtnFxdPeriodEndTime PrcgCndnTrmQtnFxdPeriodEndTime Fixed End Time Quot.
CndnTrmExchRatesFxdPerdStrtDte CndnTrmExchRatesFxdPerdStrtDte Exch. Fx. Start Date
CndnTrmExchRatesFxdPerdStrtTme CndnTrmExchRatesFxdPerdStrtTme FixedStartTimeCurr.
CndnTrmExchRatesFxdPerdEndDate CndnTrmExchRatesFxdPerdEndDate Exch. Fx. End Date
CndnTrmExchRatesFxdPerdEndTime CndnTrmExchRatesFxdPerdEndTime Fixed End Time Curr.
TrmExchRatesMaxElmntWgtngValue TrmExchRatesMaxElmntWgtngValue Max. Weighting Curr
CndnTrmQtnPerdDetnIsIncomplete CndnTrmQtnPerdDetnIsIncomplete Incomplete Quotation
PrcgCndnTrmQtnPerdDetnStatus PrcgCndnTrmQtnPerdDetnStatus Status QuoPerDeterm.
CndnTrmQtnPerdDetnStartDteTime CndnTrmQtnPerdDetnStartDteTime
CndnTrmQtnPerdDetnEndDateTime CndnTrmQtnPerdDetnEndDateTime
TrmQtnFoundLastEntryDateTme TrmQtnFoundLastEntryDateTme
TrmQtnPerdDetnCalcdRefDate TrmQtnPerdDetnCalcdRefDate Quot. Reference Date
TrmQtnPerdDetnCalcdBaseDteTme TrmQtnPerdDetnCalcdBaseDteTme
TrmQtnPerdDetnCalcdRefDateTime TrmQtnPerdDetnCalcdRefDateTime
CndnTrmCrcyPerdDetnIsIncmplt CndnTrmCrcyPerdDetnIsIncmplt Incomplete Currency
PrcgCndnTrmCrcyPerdDetnStatus PrcgCndnTrmCrcyPerdDetnStatus Status CurPerDeterm.
CndnTrmCrcyPerdDetnStartDteTme CndnTrmCrcyPerdDetnStartDteTme
CndnTrmCrcyPerdDetnEndDateTime CndnTrmCrcyPerdDetnEndDateTime
TrmExchRatesFndnLastEntrDteTme TrmExchRatesFndnLastEntrDteTme
TrmCrcyPerdDetnCalcdRefDate TrmCrcyPerdDetnCalcdRefDate Curr. Reference Date
TrmCrcyPerdDetnCalcdBaseDteTme TrmCrcyPerdDetnCalcdBaseDteTme
TrmCrcyPerdDetnCalcdRefDteTime TrmCrcyPerdDetnCalcdRefDteTime
PrcgCndnTrmPrFixationOptnUUID PrcgCndnTrmPrFixationOptnUUID Prc Fixation GUID
PricingConditionTermTierUUID PricingConditionTermTierUUID Tier GUID
CalcdPrcgConditionTermQuantity CalcdPrcgConditionTermQuantity Commodity Quantity
CalcdPrcgCndnTermQuantityUnit CalcdPrcgCndnTermQuantityUnit Calc. Comm. UoM
ConditionTermStatus ConditionTermStatus Term Status
BillingBlockingReason BillingBlockingReason Blocking Reason
ConditionTermRateCurrency ConditionTermRateCurrency Term Currency
ConditionTermRateQuantity ConditionTermRateQuantity Term Price Unit
ConditionTermRateQuantityUnit ConditionTermRateQuantityUnit Term UoM
PrcgCndnUsedEvalKeyDateTime PrcgCndnUsedEvalKeyDateTime
PrcgCndnCommodityCurveDate PrcgCndnCommodityCurveDate Curve Date
ConditionTermRate ConditionTermRate CPE - Used for internal calculation (rounding, conversion)
ConditionTermValue ConditionTermValue Term Value
PrcgConditionTermQuotationRate PrcgConditionTermQuotationRate Price Quotation
PrcgCndnTrmQtanRateCurrency PrcgCndnTrmQtanRateCurrency Qtn Currency
PrcgCndnTrmQtanRateQuantity PrcgCndnTrmQtanRateQuantity Quotation PU
PrcgCndnTrmQtanRateQtyUnit PrcgCndnTrmQtanRateQtyUnit Quotation UoM
PrcgCndnQtanGroupQuotationKey PrcgCndnQtanGroupQuotationKey Quotation Key
PrcgCndnTrmUsedLimitOfCalcRule PrcgCndnTrmUsedLimitOfCalcRule CalcRule: Limit
PrcgCndnQtnHasQtyUoMSubstn PrcgCndnQtnHasQtyUoMSubstn UoM Subst. Quot
PrcgConditionTermSurchargeRate PrcgConditionTermSurchargeRate Total Surcharge
PrcgCndnTrmSurchargeRteCrcy PrcgCndnTrmSurchargeRteCrcy AbsSurchCurr
PrcgCndnTrmSurchargeRteQty PrcgCndnTrmSurchargeRteQty AbsSurch PU
PrcgCndnTrmSurchargeRteQtyUnit PrcgCndnTrmSurchargeRteQtyUnit AbsSurchUoM
PrcgCndnSurchrgHasQtyUoMSubstn PrcgCndnSurchrgHasQtyUoMSubstn UoM Subst. Sur
PricingCndnTermExtensionGroup PricingCndnTermExtensionGroup Extension Group
ConditionTermExtensionUsage ConditionTermExtensionUsage Extension Usage
PrcgCndnTermRelForFormulaRslt PrcgCndnTermRelForFormulaRslt Rel.for FormRes.
MaturityKeyDate MaturityKeyDate Maturity Key Date
PricingConditionTermKey PricingConditionTermKey Term Key
PricingConditionTermGroup PricingConditionTermGroup Term Group
PrcgCndnTermIsUsedForPrvsnPrcg PrcgCndnTermIsUsedForPrvsnPrcg ProvPricing only
PrcgConditionProvisionalTerm PrcgConditionProvisionalTerm Prov.Term No.
PricingConditionTermQuantity PricingConditionTermQuantity Commodity Qty
PricingConditionTrmQtyUnit PricingConditionTrmQtyUnit Comm. Qty UoM
PricingConditionTermFixedRate PricingConditionTermFixedRate Fixed Rate
PrcgConditionTermFixedRateCrcy PrcgConditionTermFixedRateCrcy Currency Fixed Rate
PrcgConditionTermFixedRateQty PrcgConditionTermFixedRateQty PrcUnit Fixed Value
PrcgCndnTermFixedRateQtyUnit PrcgCndnTermFixedRateQtyUnit UoM for Fixed Value
PrcgCndnDrvtvOrdReqExprtnDate PrcgCndnDrvtvOrdReqExprtnDate Expiratn Date
CndnDrvtvOrdReqLmtSpreadVal CndnDrvtvOrdReqLmtSpreadVal Limit Spread Value
CndnDrvtvOrdReqLmtSpreadPrCrcy CndnDrvtvOrdReqLmtSpreadPrCrcy Lim Spread Prc Crcy
DrvtvOrdReqReqdFxdSpreadPrice DrvtvOrdReqReqdFxdSpreadPrice Requested Spread Prc
DrvtvOrdReqReqdFxdSpreadPrCrcy DrvtvOrdReqReqdFxdSpreadPrCrcy Rqstd Spr Prc Crcy
CndnNrOfDrvtvOrderRequestTicks CndnNrOfDrvtvOrderRequestTicks Order Request Ticks
PrcgCndnTrmCtptyBrokerName PrcgCndnTrmCtptyBrokerName Counterparty Broker
PrcgCndnTrmRefBrokerAccount PrcgCndnTrmRefBrokerAccount Reference Account
PrcgCndnTermSavedFixedRate PrcgCndnTermSavedFixedRate Fixed Rate
PrcgCndnTermSavedFixedRateCrcy PrcgCndnTermSavedFixedRateCrcy Currency Fixed Rate
PrcgConditionTermTierUpperQty PrcgConditionTermTierUpperQty Quantity Up To
PrcgConditionTermTierQtyUnit PrcgConditionTermTierQtyUnit UoM: Conv. to
PrcgCndnTrmRateCrtnDateTime PrcgCndnTrmRateCrtnDateTime
PrcgCndnTermRateCreatedByUser PrcgCndnTermRateCreatedByUser Created by
PrcgCndnTrmRateChangeDateTime PrcgCndnTrmRateChangeDateTime
PrcgCndnTermRateChangedByUser PrcgCndnTermRateChangedByUser Changed By
CmmdtyPrcgCndnTrmMttyRefDate CmmdtyPrcgCndnTrmMttyRefDate Maturity Ref Date
PrcgCndnTrmMttyCalcdBaseDate PrcgCndnTrmMttyCalcdBaseDate Mtrty Calc Base Date
PrcgConditionTermProposedRate PrcgCndnTrmQtnCurrencyRate Trm Rate in Quot cur
CmmdtyPrcFixedRateIsMaintained CmmdtyPrcFixedRateIsMaintained Truth Value
DerivativeContrSpecification DerivativeContrSpecification DCS ID
MarketIdentifierCode MarketIdentifierCode MIC
PrcgCndnTrmPrSettingMethodUUID PrcgCndnTrmPrSettingMethodUUID PSM GUID
PrcgCndnTermPriceSettingMethod PrcgCndnTermPriceSettingMethod Price Setting Method
PrcgCndnTrmPrSttgMethodStatus PrcgCndnTrmPrSttgMethodStatus PSM Status
PrcgCndnTermCmmdtySubAccount PrcgCndnTermCmmdtySubAccount Subaccount ID
PrcgConditionTermNumberOfLots PrcgConditionTermNumberOfLots Lots
PrcgCndnDrvtvOrdFillPacketUUID PrcgCndnDrvtvOrdFillPacketUUID Key
PrcgCndnTrmPrSttgMethHasError PrcgCndnTrmPrSttgMethHasError Prcg Setting Error
PrcgCndnDrvtvOrdReqExpryInstrn PrcgCndnDrvtvOrdReqExpryInstrn Expiry Instruction
PrcgCndnOrdReqPrcgExecInstrn PrcgCndnOrdReqPrcgExecInstrn Prc/Exec Instruction
PrcgCndnDrvtvOrdReqLimitPrice PrcgCndnDrvtvOrdReqLimitPrice Limit Price
PrcgCndnDrvtvOrdReqLmtPrcCrcy PrcgCndnDrvtvOrdReqLmtPrcCrcy Limit Price Crcy
PrcgCndnDrvtvOrdReqStopPrice PrcgCndnDrvtvOrdReqStopPrice Stop Price
PrcgCndnDrvtvOrdReqStopPrcCrcy PrcgCndnDrvtvOrdReqStopPrcCrcy Stop Price Crcy
CndnDrvtvOrdReqStopLimitPrice CndnDrvtvOrdReqStopLimitPrice Stop Limit Price
CndnDrvtvOrdReqStopLmtPrcCrcy CndnDrvtvOrdReqStopLmtPrcCrcy Stop Limit Prc Crcy
CndnDrvtvOrdReqReqdFxdPrice CndnDrvtvOrdReqReqdFxdPrice Requested Price
CndnDrvtvOrdReqReqdFxdPrcCrcy CndnDrvtvOrdReqReqdFxdPrcCrcy Requested Price Crcy
DrvtvOrdReqReqdLeewayPrice DrvtvOrdReqReqdLeewayPrice Requested Price
DrvtvOrdReqReqdLeewayPriceCrcy DrvtvOrdReqReqdLeewayPriceCrcy Requested Price Crcy
CndnDrvtvOrdReqLeewayPrice CndnDrvtvOrdReqLeewayPrice Leeway Price
CndnDrvtvOrdReqLeewayPrcCrcy CndnDrvtvOrdReqLeewayPrcCrcy Leeway Prc Crcy
PricingConditionTermHasSpread PricingConditionTermHasSpread
PrcgCndnTrmCollvNumberOfLots PrcgCndnTrmCollvNumberOfLots
PriceFixationFillSequenceValue PriceFixationFillSequenceValue
PrcgCndnTrmLastPrcFixOperation PrcgCndnTrmLastPrcFixOperation
PricingConditionTermIsOverfill PricingConditionTermIsOverfill
CmmdtyOrdReqCntrPtySubAcct CmmdtyOrdReqCntrPtySubAcct Counterparty Subacct
_CmmdtyPrcgConditionRootTerm _CmmdtyPrcgConditionRootTerm
_CmmdtyPrcgConditionFormula _CmmdtyPrcgConditionFormula
_CmmdtyPrcgCndnTrmCnvrsnRslt _CmmdtyPrcgCndnTrmCnvrsnRslt
_CmmdtyPrcgCndnTrmCnvrsnInput _CmmdtyPrcgCndnTrmCnvrsnInput
_CmmdtyPrcgCndnTermQuotation _CmmdtyPrcgCndnTermQuotation
_CmmdtyPrcgConditionTermLog _CmmdtyPrcgConditionTermLog
_CmmdtyPrcgPrcFixationGrpComp _CmmdtyPrcgPrcFixationGrpComp
_ConditionTermExtension _ConditionTermExtension

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_CmmdtyPrcgCndnExerciseTerm.
-- 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 I_CmmdtyPrcgCndnExerciseTerm AS
SELECT
  DocItmCmmdtyPrcgCndnUUID,
  PricingConditionTerm,
  ConditionType,
  PrcgCndnTrmQtnFxdPeriodStrtDte,
  PrcgCndnTrmQtnFxdPeriodStrtTme,
  PrcgCndnTrmQtnFxdPeriodEndDate,
  PrcgCndnTrmQtnFxdPeriodEndTime,
  CndnTrmExchRatesFxdPerdStrtDte,
  CndnTrmExchRatesFxdPerdStrtTme,
  CndnTrmExchRatesFxdPerdEndDate,
  CndnTrmExchRatesFxdPerdEndTime,
  TrmExchRatesMaxElmntWgtngValue,
  CndnTrmQtnPerdDetnIsIncomplete,
  PrcgCndnTrmQtnPerdDetnStatus,
  CndnTrmQtnPerdDetnStartDteTime,
  CndnTrmQtnPerdDetnEndDateTime,
  TrmQtnFoundLastEntryDateTme,
  TrmQtnPerdDetnCalcdRefDate,
  TrmQtnPerdDetnCalcdBaseDteTme,
  TrmQtnPerdDetnCalcdRefDateTime,
  CndnTrmCrcyPerdDetnIsIncmplt,
  PrcgCndnTrmCrcyPerdDetnStatus,
  CndnTrmCrcyPerdDetnStartDteTme,
  CndnTrmCrcyPerdDetnEndDateTime,
  TrmExchRatesFndnLastEntrDteTme,
  TrmCrcyPerdDetnCalcdRefDate,
  TrmCrcyPerdDetnCalcdBaseDteTme,
  TrmCrcyPerdDetnCalcdRefDteTime,
  PrcgCndnTrmPrFixationOptnUUID,
  PricingConditionTermTierUUID,
  CalcdPrcgConditionTermQuantity,
  CalcdPrcgCndnTermQuantityUnit,
  ConditionTermStatus,
  BillingBlockingReason,
  ConditionTermRateCurrency,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  PrcgCndnUsedEvalKeyDateTime,
  PrcgCndnCommodityCurveDate,
  ConditionTermRate,
  ConditionTermValue,
  PrcgConditionTermQuotationRate,
  PrcgCndnTrmQtanRateCurrency,
  PrcgCndnTrmQtanRateQuantity,
  PrcgCndnTrmQtanRateQtyUnit,
  PrcgCndnQtanGroupQuotationKey,
  PrcgCndnTrmUsedLimitOfCalcRule,
  PrcgCndnQtnHasQtyUoMSubstn,
  PrcgConditionTermSurchargeRate,
  PrcgCndnTrmSurchargeRteCrcy,
  PrcgCndnTrmSurchargeRteQty,
  PrcgCndnTrmSurchargeRteQtyUnit,
  PrcgCndnSurchrgHasQtyUoMSubstn,
  PricingCndnTermExtensionGroup,
  ConditionTermExtensionUsage,
  PrcgCndnTermRelForFormulaRslt,
  MaturityKeyDate,
  PricingConditionTermKey,
  PricingConditionTermGroup,
  PrcgCndnTermIsUsedForPrvsnPrcg,
  PrcgConditionProvisionalTerm,
  PricingConditionTermQuantity,
  PricingConditionTrmQtyUnit,
  PricingConditionTermFixedRate,
  PrcgConditionTermFixedRateCrcy,
  PrcgConditionTermFixedRateQty,
  PrcgCndnTermFixedRateQtyUnit,
  PrcgCndnDrvtvOrdReqExprtnDate,
  CndnDrvtvOrdReqLmtSpreadVal,
  CndnDrvtvOrdReqLmtSpreadPrCrcy,
  DrvtvOrdReqReqdFxdSpreadPrice,
  DrvtvOrdReqReqdFxdSpreadPrCrcy,
  CndnNrOfDrvtvOrderRequestTicks,
  PrcgCndnTrmCtptyBrokerName,
  PrcgCndnTrmRefBrokerAccount,
  PrcgCndnTermSavedFixedRate,
  PrcgCndnTermSavedFixedRateCrcy,
  PrcgConditionTermTierUpperQty,
  PrcgConditionTermTierQtyUnit,
  PrcgCndnTrmRateCrtnDateTime,
  PrcgCndnTermRateCreatedByUser,
  PrcgCndnTrmRateChangeDateTime,
  PrcgCndnTermRateChangedByUser,
  CmmdtyPrcgCndnTrmMttyRefDate,
  PrcgCndnTrmMttyCalcdBaseDate,
  PrcgCndnTrmQtnCurrencyRate AS PrcgConditionTermProposedRate,
  CmmdtyPrcFixedRateIsMaintained,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  PrcgCndnTrmPrSettingMethodUUID,
  PrcgCndnTermPriceSettingMethod,
  PrcgCndnTrmPrSttgMethodStatus,
  PrcgCndnTermCmmdtySubAccount,
  PrcgConditionTermNumberOfLots,
  PrcgCndnDrvtvOrdFillPacketUUID,
  PrcgCndnTrmPrSttgMethHasError,
  PrcgCndnDrvtvOrdReqExpryInstrn,
  PrcgCndnOrdReqPrcgExecInstrn,
  PrcgCndnDrvtvOrdReqLimitPrice,
  PrcgCndnDrvtvOrdReqLmtPrcCrcy,
  PrcgCndnDrvtvOrdReqStopPrice,
  PrcgCndnDrvtvOrdReqStopPrcCrcy,
  CndnDrvtvOrdReqStopLimitPrice,
  CndnDrvtvOrdReqStopLmtPrcCrcy,
  CndnDrvtvOrdReqReqdFxdPrice,
  CndnDrvtvOrdReqReqdFxdPrcCrcy,
  DrvtvOrdReqReqdLeewayPrice,
  DrvtvOrdReqReqdLeewayPriceCrcy,
  CndnDrvtvOrdReqLeewayPrice,
  CndnDrvtvOrdReqLeewayPrcCrcy,
  PricingConditionTermHasSpread,
  PrcgCndnTrmCollvNumberOfLots,
  PriceFixationFillSequenceValue,
  PrcgCndnTrmLastPrcFixOperation,
  PricingConditionTermIsOverfill,
  CmmdtyOrdReqCntrPtySubAcct
FROM I_CmmdtyPricingConditionTerm
;

Learn More