I_PurHubSmrtCmmdtyTrmQuotation

DDL: I_PURHUBSMRTCMMDTYTRMQUOTATION Type: view_entity COMPOSITE Package: LOG_CMM_PRC_PUR_HUB_BASE
19 Fields 1 Data Sources

Purchase Hub Smart Cmmdity Term Qtn

I_PurHubSmrtCmmdtyTrmQuotation is a Composite CDS View that provides data about "Purchase Hub Smart Cmmdity Term Qtn" in SAP S/4HANA. It reads from 1 data source (I_PurHubSmrtCmmdtyTrmQtanUnion) and exposes 19 fields with key fields ConditionRecord, ConditionSequentialNumberShort, PricingConditionTerm, PrcgCndnTermQuotationDateTime. Part of development package LOG_CMM_PRC_PUR_HUB_BASE.

Data Sources (1)

SourceAliasJoin Type
I_PurHubSmrtCmmdtyTrmQtanUnion Quotation from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Purchase Hub Smart Cmmdity Term Qtn view
Analytics.technicalName IPURHUBTERMQTN view
ObjectModel.representativeKey ConditionRecord view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord ConditionRecord Cond.Record No.
KEY ConditionSequentialNumberShort ConditionSequentialNumberShort Sequent. No. of Cond
KEY PricingConditionTerm PricingConditionTerm Term Number
KEY PrcgCndnTermQuotationDateTime PrcgCndnTermQuotationDateTime Quotation Time Stamp
CndnTrmQtanPerdDetnResultUUID CndnTrmQtanPerdDetnResultUUID PerDet.Out.GUID
PrcgConditionTermQuotationRate PrcgConditionTermQuotationRate Price Quotation
PrcgCndnTrmQtanRateCurrency PrcgCndnTrmQtanRateCurrency Qtn Currency
PrcgCndnTrmQtanRateQuantity PrcgCndnTrmQtanRateQuantity Quotation PU
PrcgCndnTrmQtanRateQtyUnit PrcgCndnTrmQtanRateQtyUnit Quotation UoM
MaturityKeyDate MaturityKeyDate Maturity Key Date
PrcgCndnTrmQtanSubstnDateTime PrcgCndnTrmQtanSubstnDateTime Subst Time Stamp
PricingConditionExchangeRate PricingConditionExchangeRate Conv.:Ex.Rate
PrcgCndnTrmQtanIsNonTradingDay PrcgCndnTrmQtanIsNonTradingDay Non-Trading Day
PrcgCndnTermQuotationIsMissing PrcgCndnTermQuotationIsMissing Quotation Missing
PrcgCndnTrmQtanIsSubstituted PrcgCndnTrmQtanIsSubstituted Substitute Qtn
PrcgCndnTrmQuotationIsIgnored PrcgCndnTrmQuotationIsIgnored Quotation Ignored
ConditionType ConditionType Condition type
_QuotationCurrency I_PurHubSmrtCmmdtyTrmQtanUnion _QuotationCurrency
_PrcgCndnTrmQtanRateQtyUnit I_PurHubSmrtCmmdtyTrmQtanUnion _PrcgCndnTrmQtanRateQtyUnit

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_PurHubSmrtCmmdtyTrmQuotation.
-- 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_PurHubSmrtCmmdtyTrmQuotation AS
SELECT
  ConditionRecord,
  ConditionSequentialNumberShort,
  PricingConditionTerm,
  PrcgCndnTermQuotationDateTime,
  CndnTrmQtanPerdDetnResultUUID,
  PrcgConditionTermQuotationRate,
  PrcgCndnTrmQtanRateCurrency,
  PrcgCndnTrmQtanRateQuantity,
  PrcgCndnTrmQtanRateQtyUnit,
  MaturityKeyDate,
  PrcgCndnTrmQtanSubstnDateTime,
  PricingConditionExchangeRate,
  PrcgCndnTrmQtanIsNonTradingDay,
  PrcgCndnTermQuotationIsMissing,
  PrcgCndnTrmQtanIsSubstituted,
  PrcgCndnTrmQuotationIsIgnored,
  ConditionType,
  Quotation._QuotationCurrency AS _QuotationCurrency,
  Quotation._PrcgCndnTrmQtanRateQtyUnit AS _PrcgCndnTrmQtanRateQtyUnit
FROM I_PurHubSmrtCmmdtyTrmQtanUnion AS Quotation
;

Learn More