I_PurHubSmrtCmmdtyTrmQtanUnion

DDL: I_PURHUBSMRTCMMDTYTRMQTANUNION Type: view_entity COMPOSITE

Union Layer Purchase Hub Quotation

I_PurHubSmrtCmmdtyTrmQtanUnion is a Composite CDS View that provides data about "Union Layer Purchase Hub Quotation" in SAP S/4HANA. It reads from 4 data sources (I_PurHubSmrtCmmdtyTrmQtanNew, I_PurHubCommodityTermQuotation, I_CmmdtyPricingMigrationStatus, I_CmmdtyPricingMigrationStatus) and exposes 37 fields with key fields ConditionRecord, ConditionSequentialNumberShort, PricingConditionTerm, PrcgCndnTermQuotationDateTime, ConditionSequentialNumberShort.

Data Sources (4)

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Union Layer Purchase Hub Quotation view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord I_PurHubSmrtCmmdtyTrmQtanNew ConditionRecord Cond.Record No.
KEY ConditionSequentialNumberShort I_PurHubSmrtCmmdtyTrmQtanNew ConditionSequentialNumberShort Sequent. No. of Cond
KEY PricingConditionTerm I_PurHubSmrtCmmdtyTrmQtanNew PricingConditionTerm Term Number
KEY PrcgCndnTermQuotationDateTime I_PurHubSmrtCmmdtyTrmQtanNew PrcgCndnTermQuotationDateTime Quotation Time Stamp
CndnTrmQtanPerdDetnResultUUID I_PurHubSmrtCmmdtyTrmQtanNew CndnTrmQtanPerdDetnResultUUID PerDet.Out.GUID
PrcgConditionTermQuotationRate I_PurHubSmrtCmmdtyTrmQtanNew PrcgConditionTermQuotationRate Price Quotation
PrcgCndnTrmQtanRateCurrency I_PurHubSmrtCmmdtyTrmQtanNew PrcgCndnTrmQtanRateCurrency Qtn Currency
PrcgCndnTrmQtanRateQuantity I_PurHubSmrtCmmdtyTrmQtanNew PrcgCndnTrmQtanRateQuantity Quotation PU
PrcgCndnTrmQtanRateQtyUnit I_PurHubSmrtCmmdtyTrmQtanNew PrcgCndnTrmQtanRateQtyUnit Quotation UoM
MaturityKeyDate I_PurHubSmrtCmmdtyTrmQtanNew MaturityKeyDate Maturity Key Date
PrcgCndnTrmQtanSubstnDateTime I_PurHubSmrtCmmdtyTrmQtanNew PrcgCndnTrmQtanSubstnDateTime Subst Time Stamp
PricingConditionExchangeRate I_PurHubSmrtCmmdtyTrmQtanNew PricingConditionExchangeRate Conv.:Ex.Rate
PrcgCndnTrmQtanIsNonTradingDay I_PurHubSmrtCmmdtyTrmQtanNew PrcgCndnTrmQtanIsNonTradingDay Non-Trading Day
PrcgCndnTermQuotationIsMissing I_PurHubSmrtCmmdtyTrmQtanNew PrcgCndnTermQuotationIsMissing Quotation Missing
PrcgCndnTrmQtanIsSubstituted I_PurHubSmrtCmmdtyTrmQtanNew PrcgCndnTrmQtanIsSubstituted Substitute Qtn
PrcgCndnTrmQuotationIsIgnored I_PurHubSmrtCmmdtyTrmQtanNew PrcgCndnTrmQuotationIsIgnored Quotation Ignored
ConditionType I_PurHubSmrtCmmdtyTrmQtanNew ConditionType Condition type
_QuotationCurrency I_PurHubSmrtCmmdtyTrmQtanNew _QuotationCurrency
ConditionRecord Cond.Record No.
KEY ConditionSequentialNumberShort I_PurHubCommodityTermQuotation ConditionSequentialNumberShort Sequent. No. of Cond
KEY PricingConditionTerm I_PurHubCommodityTermQuotation PricingConditionTerm Term Number
KEY PrcgCndnTermQuotationDateTime I_PurHubCommodityTermQuotation PrcgCndnTermQuotationDateTime Quotation Time Stamp
CndnTrmQtanPerdDetnResultUUID I_PurHubCommodityTermQuotation CndnTrmQtanPerdDetnResultUUID PerDet.Out.GUID
PrcgConditionTermQuotationRate I_PurHubCommodityTermQuotation PrcgConditionTermQuotationRate Price Quotation
PrcgCndnTrmQtanRateCurrency I_PurHubCommodityTermQuotation PrcgCndnTrmQtanRateCurrency Qtn Currency
PrcgCndnTrmQtanRateQuantity I_PurHubCommodityTermQuotation PrcgCndnTrmQtanRateQuantity Quotation PU
PrcgCndnTrmQtanRateQtyUnit I_PurHubCommodityTermQuotation PrcgCndnTrmQtanRateQtyUnit Quotation UoM
MaturityKeyDate I_PurHubCommodityTermQuotation MaturityKeyDate Maturity Key Date
PrcgCndnTrmQtanSubstnDateTime I_PurHubCommodityTermQuotation PrcgCndnTrmQtanSubstnDateTime Subst Time Stamp
PricingConditionExchangeRate I_PurHubCommodityTermQuotation PricingConditionExchangeRate Conv.:Ex.Rate
PrcgCndnTrmQtanIsNonTradingDay I_PurHubCommodityTermQuotation PrcgCndnTrmQtanIsNonTradingDay Non-Trading Day
PrcgCndnTermQuotationIsMissing I_PurHubCommodityTermQuotation PrcgCndnTermQuotationIsMissing Quotation Missing
PrcgCndnTrmQtanIsSubstituted I_PurHubCommodityTermQuotation PrcgCndnTrmQtanIsSubstituted Substitute Qtn
PrcgCndnTrmQuotationIsIgnored I_PurHubCommodityTermQuotation PrcgCndnTrmQuotationIsIgnored Quotation Ignored
ConditionType I_PurHubCommodityTermQuotation ConditionType Condition type
_QuotationCurrency I_PurHubCommodityTermQuotation _QuotationCurrency
_PrcgCndnTrmQtanRateQtyUnit I_PurHubCommodityTermQuotation _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_PurHubSmrtCmmdtyTrmQtanUnion.
-- 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_PurHubSmrtCmmdtyTrmQtanUnion AS
SELECT
  new.ConditionRecord AS ConditionRecord,
  new.ConditionSequentialNumberShort AS ConditionSequentialNumberShort,
  new.PricingConditionTerm AS PricingConditionTerm,
  new.PrcgCndnTermQuotationDateTime AS PrcgCndnTermQuotationDateTime,
  new.CndnTrmQtanPerdDetnResultUUID AS CndnTrmQtanPerdDetnResultUUID,
  new.PrcgConditionTermQuotationRate AS PrcgConditionTermQuotationRate,
  new.PrcgCndnTrmQtanRateCurrency AS PrcgCndnTrmQtanRateCurrency,
  new.PrcgCndnTrmQtanRateQuantity AS PrcgCndnTrmQtanRateQuantity,
  new.PrcgCndnTrmQtanRateQtyUnit AS PrcgCndnTrmQtanRateQtyUnit,
  new.MaturityKeyDate AS MaturityKeyDate,
  new.PrcgCndnTrmQtanSubstnDateTime AS PrcgCndnTrmQtanSubstnDateTime,
  new.PricingConditionExchangeRate AS PricingConditionExchangeRate,
  new.PrcgCndnTrmQtanIsNonTradingDay AS PrcgCndnTrmQtanIsNonTradingDay,
  new.PrcgCndnTermQuotationIsMissing AS PrcgCndnTermQuotationIsMissing,
  new.PrcgCndnTrmQtanIsSubstituted AS PrcgCndnTrmQtanIsSubstituted,
  new.PrcgCndnTrmQuotationIsIgnored AS PrcgCndnTrmQuotationIsIgnored,
  new.ConditionType AS ConditionType,
  new._QuotationCurrency AS _QuotationCurrency,
  old._PrcgCndnTrmQtanRateQtyUnit AS _PrcgCndnTrmQtanRateQtyUnit
FROM I_PurHubSmrtCmmdtyTrmQtanNew AS new
INNER JOIN I_CmmdtyPricingMigrationStatus AS tf ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_PurHubCommodityTermQuotation
;