What is R_SrcgProjQtnItmCommodityTerm in SAP S/4HANA?

R_SrcgProjQtnItmCommodityTerm is a composite CDS view in SAP S/4HANA. Sourcing project qtn item commodity term It contains 93 fields.

Which tables does R_SrcgProjQtnItmCommodityTerm read from?

R_SrcgProjQtnItmCommodityTerm reads data from: R_SrcgProjQtnItemCondition.

What VDM layer is R_SrcgProjQtnItmCommodityTerm?

R_SrcgProjQtnItmCommodityTerm is classified as a Composite view that combines data from multiple basic views.

R_SrcgProjQtnItmCommodityTerm

DDL: R_SRCGPROJQTNITMCOMMODITYTERM SQL: RSPQCMMDTYTERM Type: view COMPOSITE Package: LOG_CMM_PRC_PUR_HUB_SRCGPRJQTN

93 Fields 1 Data Sources 2 Associations

Sourcing project qtn item commodity term

R_SrcgProjQtnItmCommodityTerm is a Composite CDS View that provides data about "Sourcing project qtn item commodity term" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjQtnItemCondition) and exposes 93 fields with key fields ConditionRecord, ConditionSequentialNumberShort. It has 2 associations to related views. Part of development package LOG_CMM_PRC_PUR_HUB_SRCGPRJQTN.

Data Sources (1)

Source	Alias	Join Type
R_SrcgProjQtnItemCondition	SrcgProjQtnItemCondition	inner

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	R_SourcingProjectQuotation	_SourcingProjectQuotation	`_SourcingProjectQuotation.SourcingProjectQuotationUUID = SrcgProjQtnItemCondition.SourcingProjectQuotationUUID`
[0..1]	R_SrcgProjQtnItmCmmdtyFormula	_SrcgProjQtnItmCmmdtyFormula	`_SrcgProjQtnItmCmmdtyFormula.ConditionRecord = SrcgProjQtnItmCommodityTerm.ConditionRecord and _SrcgProjQtnItmCmmdtyFormula.ConditionSequentialNumberShort = SrcgProjQtnItmCommodityTerm.ConditionSequentialNumberShort`

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	RSPQCMMDTYTERM	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Sourcing project qtn item commodity term	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
ObjectModel.representativeKey	ConditionRecord	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view

Fields (93)

Key	Field	Source Table	Source Field	Description
KEY	ConditionRecord	SrcgProjQtnItmCommodityTerm	ConditionRecord	Cond.Record No.
KEY	ConditionSequentialNumberShort	SrcgProjQtnItmCommodityTerm	ConditionSequentialNumberShort	Sequent. No. of Cond
	PricingConditionTerm	SrcgProjQtnItmCommodityTerm	PricingConditionTerm	Term Number
	DocItemCommodityPricingUUID	SrcgProjQtnItmCommodityTerm	DocItemCommodityPricingUUID	GUID
	ConditionType	SrcgProjQtnItmCommodityTerm	ConditionType	Condition type
	PricingConditionFormulaKey	SrcgProjQtnItmCommodityTerm	PricingConditionFormulaKey	Formula Key
	PrcgConditionFormulaInputUUID	SrcgProjQtnItmCommodityTerm	PrcgConditionFormulaInputUUID	Doc. Form. GUID
	OriginSystem	SrcgProjQtnItmCommodityTerm	OriginSystem	LogSys: Formula
	PrcgCndnFmlaCommodityQuantity	SrcgProjQtnItmCommodityTerm	PrcgCndnFmlaCommodityQuantity	Comm.Qty Item
	PrcgCndnFmlaCmmdtyQuantityUnit	SrcgProjQtnItmCommodityTerm	PrcgCndnFmlaCmmdtyQuantityUnit	Commodity UoM
	PrcgCndnFmlaEvaluationDateTime	SrcgProjQtnItmCommodityTerm	PrcgCndnFmlaEvaluationDateTime	Eval. Date and Time
	CndnExchRatePerdDetnResultUUID	SrcgProjQtnItmCommodityTerm	CndnExchRatePerdDetnResultUUID	PerDet.Out.GUID
	PrcgCndnTrmConversionInputUUID	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmConversionInputUUID	ConvInputGUID
	PrcgCndnTermConversionRsltUUID	SrcgProjQtnItmCommodityTerm	PrcgCndnTermConversionRsltUUID	ConvResultGUID
	PricingConditionSourceCurrency	SrcgProjQtnItmCommodityTerm	PricingConditionSourceCurrency	Curr:Conv. from
	PricingConditionTargetCurrency	SrcgProjQtnItmCommodityTerm	PricingConditionTargetCurrency	Curr.: Conv. to
	PrcgCndnSourceQuantityUnit	SrcgProjQtnItmCommodityTerm	PrcgCndnSourceQuantityUnit	UoM: Conv. from
	PrcgCndnTargetQuantityUnit	SrcgProjQtnItmCommodityTerm	PrcgCndnTargetQuantityUnit	UoM: Conv. to
	PricingConditionConversionRule	SrcgProjQtnItmCommodityTerm	PricingConditionConversionRule	Conv. Rule
	PrcgConditionFixedExchangeRate	SrcgProjQtnItmCommodityTerm	PrcgConditionFixedExchangeRate	Fix.Exch.Rate
	CndnCnvrsnRuleValdtyStrtDteTme	SrcgProjQtnItmCommodityTerm	CndnCnvrsnRuleValdtyStrtDteTme	Valid From
	CndnTrmCnvrsnValdtyStrtDteTme	SrcgProjQtnItmCommodityTerm	CndnTrmCnvrsnValdtyStrtDteTme	Valid From
	PrcgConditionConversionPlace	SrcgProjQtnItmCommodityTerm	PrcgConditionConversionPlace	Conv. Place
	PrcgCndnGrpTrmValdtyStrtDteTme	SrcgProjQtnItmCommodityTerm	PrcgCndnGrpTrmValdtyStrtDteTme	Valid From
	PricingConditionTermKey	SrcgProjQtnItmCommodityTerm	PricingConditionTermKey	Term Key
	PrcgCndnTrmValdtyStartDateTime	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmValdtyStartDateTime	Valid From
	PrcgCndnFmlaEvaluationModule	SrcgProjQtnItmCommodityTerm	PrcgCndnFmlaEvaluationModule	Module
	CndnTrmCalcTypeRoutineSubMdl	SrcgProjQtnItmCommodityTerm	CndnTrmCalcTypeRoutineSubMdl	Submodule
	PrcgCndnTermCalculationType	SrcgProjQtnItmCommodityTerm	PrcgCndnTermCalculationType	Calculation Type
	PricingConditionTermRule	SrcgProjQtnItmCommodityTerm	PricingConditionTermRule	Term Rule
	CndnTrmRuleValdtyStartDateTime	SrcgProjQtnItmCommodityTerm	CndnTrmRuleValdtyStartDateTime	Valid From
	PrcgCndnTermCalculationRule	SrcgProjQtnItmCommodityTerm	PrcgCndnTermCalculationRule	Calculation Rule
	CndnCalcRuleValdtyStrtDateTime	SrcgProjQtnItmCommodityTerm	CndnCalcRuleValdtyStrtDateTime	Valid From
	PrcgCndnTermQuotationRule	SrcgProjQtnItmCommodityTerm	PrcgCndnTermQuotationRule	Quotation Rule
	CndnQtanRuleValdtyStrtDateTime	SrcgProjQtnItmCommodityTerm	CndnQtanRuleValdtyStrtDateTime	Valid From
	PricingConditionTermRate	SrcgProjQtnItmCommodityTerm	PricingConditionTermRate	Term Rate
	PrcgConditionTermRateCrcy	SrcgProjQtnItmCommodityTerm	PrcgConditionTermRateCrcy	Term Currency
	PrcgConditionTermRateQty	SrcgProjQtnItmCommodityTerm	PrcgConditionTermRateQty	Term Price Unit
	PrcgConditionTermRateQtyUnit	SrcgProjQtnItmCommodityTerm	PrcgConditionTermRateQtyUnit	Term UoM
	PrcgConditionTermQuotationRate	SrcgProjQtnItmCommodityTerm	PrcgConditionTermQuotationRate	Price Quotation
	PrcgCndnTrmQtanRateCurrency	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmQtanRateCurrency	Qtn Currency
	PrcgCndnTrmQtanRateQuantity	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmQtanRateQuantity	Quotation PU
	PrcgCndnTrmQtanRateQtyUnit	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmQtanRateQtyUnit	Quotation UoM
	PrcgCndnTrmQtanPerdStrtDteTime	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmQtanPerdStrtDteTime	Begin of Period
	PrcgCndnTrmQtanPerdEndDateTime	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmQtanPerdEndDateTime	End of Period
	PrcgCndnTrmQtanPerdRefDate	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmQtanPerdRefDate	Reference Date
	PrcgCndnTrmQtanPerdBaseDteTime	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmQtanPerdBaseDteTime	Calculated Base Date
	CndnTrmExchRatePerdStrtDteTime	SrcgProjQtnItmCommodityTerm	CndnTrmExchRatePerdStrtDteTime	Begin of Period
	CndnTrmExchRatePerdEndDateTime	SrcgProjQtnItmCommodityTerm	CndnTrmExchRatePerdEndDateTime	End of Period
	PrcgCndnTrmExchRatePerdRefDate	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmExchRatePerdRefDate	Reference Date
	CndnTrmExchRatePerdBaseDteTime	SrcgProjQtnItmCommodityTerm	CndnTrmExchRatePerdBaseDteTime	Calculated Base Date
	PrcgConditionTermSurchargeRate	SrcgProjQtnItmCommodityTerm	PrcgConditionTermSurchargeRate	Total Surcharge
	PrcgCndnTrmSurchargeRteCrcy	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmSurchargeRteCrcy	AbsSurchCurr
	PrcgCndnTrmSurchargeRteQty	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmSurchargeRteQty	AbsSurch PU
	PrcgCndnTrmSurchargeRteQtyUnit	SrcgProjQtnItmCommodityTerm	PrcgCndnTrmSurchargeRteQtyUnit	AbsSurchUoM
	PricingConditionTermGroup	SrcgProjQtnItmCommodityTerm	PricingConditionTermGroup	Term Group
	PricingConditionTermFixedRate	SrcgProjQtnItmCommodityTerm	PricingConditionTermFixedRate	Fixed Rate
	PrcgConditionTermFixedRateCrcy	SrcgProjQtnItmCommodityTerm	PrcgConditionTermFixedRateCrcy	Currency Fixed Rate
	PrcgConditionTermFixedRateQty	SrcgProjQtnItmCommodityTerm	PrcgConditionTermFixedRateQty	PrcUnit Fixed Value
	PrcgCndnTermFixedRateQtyUnit	SrcgProjQtnItmCommodityTerm	PrcgCndnTermFixedRateQtyUnit	UoM for Fixed Value
	DerivativeContrSpecification	SrcgProjQtnItmCommodityTerm	DerivativeContrSpecification	DCS ID
	MarketIdentifierCode	SrcgProjQtnItmCommodityTerm	MarketIdentifierCode	MIC
	TimeToMaturity	SrcgProjQtnItmCommodityTerm	TimeToMaturity	Time to Maturity
	QuotationPriceType	SrcgProjQtnItmCommodityTerm	QuotationPriceType	Price Type
	ConditionValidityEndDate	R_SrcgProjQtnItemCondition	ConditionValidityEndDate	Valid To
	ConditionValidityStartDate	R_SrcgProjQtnItemCondition	ConditionValidityStartDate	Valid From
	SourcingProjectQuotation	R_SrcgProjQtnItemCondition	SourcingProjectQuotation	Supplier Quotation
	SourcingProjectQuotationItem	R_SrcgProjQtnItemCondition	SourcingProjectQuotationItem	Item
	SrcgProjQuotationVersion	R_SrcgProjQtnItemCondition	SrcgProjQuotationVersion	Version
	SrcgProjQtnItemUUID	R_SrcgProjQtnItemCondition	SrcgProjQtnItemUUID	Supplier Quotation Item UUID
	SourcingProjectQuotationUUID	R_SrcgProjQtnItemCondition	SourcingProjectQuotationUUID	Supplier Quotation UUID
	ProcmtHubPlantUniqueID	R_SrcgProjQtnItemCondition	ProcmtHubPlantUniqueID	Plant Unique ID
	Currency	R_SrcgProjQtnItemCondition	Currency	Valuation Crcy
	ConditionRateValue	R_SrcgProjQtnItemCondition	ConditionRateValue	Condition Rate Value
	ConditionRateValueUnit	R_SrcgProjQtnItemCondition	ConditionRateValueUnit	Unit of Condition Rate Value
	ConditionCalculationTypeShort	R_SrcgProjQtnItemCondition	ConditionCalculationTypeShort	Calculat.Type
	ConditionQuantity	R_SrcgProjQtnItemCondition	ConditionQuantity	Pricing Unit
	ConditionQuantityUnit	R_SrcgProjQtnItemCondition	ConditionQuantityUnit	Unit of Measure
	ConditionApplication	R_SrcgProjQtnItemCondition	ConditionApplication	Application
	ConditionIsDeleted	R_SrcgProjQtnItemCondition	ConditionIsDeleted	Deletion Indic.
	_SourcingProjectQuotation		_SourcingProjectQuotation
	_SrcgProjQtnItmCmmdtyFormula		_SrcgProjQtnItmCmmdtyFormula
	_CmmdtyPrcgCalcRuleText	SrcgProjQtnItmCommodityTerm	_CmmdtyPrcgCalcRuleText
	_CmmdtyPrcgQuotationRuleText	SrcgProjQtnItmCommodityTerm	_CmmdtyPrcgQuotationRuleText
	_CmmdtyPrcgTermCalcTypeText	SrcgProjQtnItmCommodityTerm	_CmmdtyPrcgTermCalcTypeText
	_CmmdtyPricingTermRuleText	SrcgProjQtnItmCommodityTerm	_CmmdtyPricingTermRuleText
	_CommodityPricingTermText	SrcgProjQtnItmCommodityTerm	_CommodityPricingTermText
	_OriginSystem	SrcgProjQtnItmCommodityTerm	_OriginSystem
	_PrcgCndnFmlaCmmdtyQtyUnit	SrcgProjQtnItmCommodityTerm	_PrcgCndnFmlaCmmdtyQtyUnit
	_PrcgCndnSourceQuantityUnit	SrcgProjQtnItmCommodityTerm	_PrcgCndnSourceQuantityUnit
	_PrcgCndnTargetQuantityUnit	SrcgProjQtnItmCommodityTerm	_PrcgCndnTargetQuantityUnit
	_PrcgConditionSourceCurrency	SrcgProjQtnItmCommodityTerm	_PrcgConditionSourceCurrency
	_PrcgConditionTargetCurrency	SrcgProjQtnItmCommodityTerm	_PrcgConditionTargetCurrency

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 R_SrcgProjQtnItmCommodityTerm.
-- 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: RSPQCMMDTYTERM

CREATE VIEW R_SrcgProjQtnItmCommodityTerm AS
SELECT
  SrcgProjQtnItmCommodityTerm.ConditionRecord AS ConditionRecord,
  SrcgProjQtnItmCommodityTerm.ConditionSequentialNumberShort AS ConditionSequentialNumberShort,
  SrcgProjQtnItmCommodityTerm.PricingConditionTerm AS PricingConditionTerm,
  SrcgProjQtnItmCommodityTerm.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  SrcgProjQtnItmCommodityTerm.ConditionType AS ConditionType,
  SrcgProjQtnItmCommodityTerm.PricingConditionFormulaKey AS PricingConditionFormulaKey,
  SrcgProjQtnItmCommodityTerm.PrcgConditionFormulaInputUUID AS PrcgConditionFormulaInputUUID,
  SrcgProjQtnItmCommodityTerm.OriginSystem AS OriginSystem,
  SrcgProjQtnItmCommodityTerm.PrcgCndnFmlaCommodityQuantity AS PrcgCndnFmlaCommodityQuantity,
  SrcgProjQtnItmCommodityTerm.PrcgCndnFmlaCmmdtyQuantityUnit AS PrcgCndnFmlaCmmdtyQuantityUnit,
  SrcgProjQtnItmCommodityTerm.PrcgCndnFmlaEvaluationDateTime AS PrcgCndnFmlaEvaluationDateTime,
  SrcgProjQtnItmCommodityTerm.CndnExchRatePerdDetnResultUUID AS CndnExchRatePerdDetnResultUUID,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmConversionInputUUID AS PrcgCndnTrmConversionInputUUID,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTermConversionRsltUUID AS PrcgCndnTermConversionRsltUUID,
  SrcgProjQtnItmCommodityTerm.PricingConditionSourceCurrency AS PricingConditionSourceCurrency,
  SrcgProjQtnItmCommodityTerm.PricingConditionTargetCurrency AS PricingConditionTargetCurrency,
  SrcgProjQtnItmCommodityTerm.PrcgCndnSourceQuantityUnit AS PrcgCndnSourceQuantityUnit,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTargetQuantityUnit AS PrcgCndnTargetQuantityUnit,
  SrcgProjQtnItmCommodityTerm.PricingConditionConversionRule AS PricingConditionConversionRule,
  SrcgProjQtnItmCommodityTerm.PrcgConditionFixedExchangeRate AS PrcgConditionFixedExchangeRate,
  SrcgProjQtnItmCommodityTerm.CndnCnvrsnRuleValdtyStrtDteTme AS CndnCnvrsnRuleValdtyStrtDteTme,
  SrcgProjQtnItmCommodityTerm.CndnTrmCnvrsnValdtyStrtDteTme AS CndnTrmCnvrsnValdtyStrtDteTme,
  SrcgProjQtnItmCommodityTerm.PrcgConditionConversionPlace AS PrcgConditionConversionPlace,
  SrcgProjQtnItmCommodityTerm.PrcgCndnGrpTrmValdtyStrtDteTme AS PrcgCndnGrpTrmValdtyStrtDteTme,
  SrcgProjQtnItmCommodityTerm.PricingConditionTermKey AS PricingConditionTermKey,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmValdtyStartDateTime AS PrcgCndnTrmValdtyStartDateTime,
  SrcgProjQtnItmCommodityTerm.PrcgCndnFmlaEvaluationModule AS PrcgCndnFmlaEvaluationModule,
  SrcgProjQtnItmCommodityTerm.CndnTrmCalcTypeRoutineSubMdl AS CndnTrmCalcTypeRoutineSubMdl,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTermCalculationType AS PrcgCndnTermCalculationType,
  SrcgProjQtnItmCommodityTerm.PricingConditionTermRule AS PricingConditionTermRule,
  SrcgProjQtnItmCommodityTerm.CndnTrmRuleValdtyStartDateTime AS CndnTrmRuleValdtyStartDateTime,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTermCalculationRule AS PrcgCndnTermCalculationRule,
  SrcgProjQtnItmCommodityTerm.CndnCalcRuleValdtyStrtDateTime AS CndnCalcRuleValdtyStrtDateTime,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTermQuotationRule AS PrcgCndnTermQuotationRule,
  SrcgProjQtnItmCommodityTerm.CndnQtanRuleValdtyStrtDateTime AS CndnQtanRuleValdtyStrtDateTime,
  SrcgProjQtnItmCommodityTerm.PricingConditionTermRate AS PricingConditionTermRate,
  SrcgProjQtnItmCommodityTerm.PrcgConditionTermRateCrcy AS PrcgConditionTermRateCrcy,
  SrcgProjQtnItmCommodityTerm.PrcgConditionTermRateQty AS PrcgConditionTermRateQty,
  SrcgProjQtnItmCommodityTerm.PrcgConditionTermRateQtyUnit AS PrcgConditionTermRateQtyUnit,
  SrcgProjQtnItmCommodityTerm.PrcgConditionTermQuotationRate AS PrcgConditionTermQuotationRate,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmQtanRateCurrency AS PrcgCndnTrmQtanRateCurrency,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmQtanRateQuantity AS PrcgCndnTrmQtanRateQuantity,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmQtanRateQtyUnit AS PrcgCndnTrmQtanRateQtyUnit,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmQtanPerdStrtDteTime AS PrcgCndnTrmQtanPerdStrtDteTime,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmQtanPerdEndDateTime AS PrcgCndnTrmQtanPerdEndDateTime,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmQtanPerdRefDate AS PrcgCndnTrmQtanPerdRefDate,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmQtanPerdBaseDteTime AS PrcgCndnTrmQtanPerdBaseDteTime,
  SrcgProjQtnItmCommodityTerm.CndnTrmExchRatePerdStrtDteTime AS CndnTrmExchRatePerdStrtDteTime,
  SrcgProjQtnItmCommodityTerm.CndnTrmExchRatePerdEndDateTime AS CndnTrmExchRatePerdEndDateTime,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmExchRatePerdRefDate AS PrcgCndnTrmExchRatePerdRefDate,
  SrcgProjQtnItmCommodityTerm.CndnTrmExchRatePerdBaseDteTime AS CndnTrmExchRatePerdBaseDteTime,
  SrcgProjQtnItmCommodityTerm.PrcgConditionTermSurchargeRate AS PrcgConditionTermSurchargeRate,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmSurchargeRteCrcy AS PrcgCndnTrmSurchargeRteCrcy,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmSurchargeRteQty AS PrcgCndnTrmSurchargeRteQty,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTrmSurchargeRteQtyUnit AS PrcgCndnTrmSurchargeRteQtyUnit,
  SrcgProjQtnItmCommodityTerm.PricingConditionTermGroup AS PricingConditionTermGroup,
  SrcgProjQtnItmCommodityTerm.PricingConditionTermFixedRate AS PricingConditionTermFixedRate,
  SrcgProjQtnItmCommodityTerm.PrcgConditionTermFixedRateCrcy AS PrcgConditionTermFixedRateCrcy,
  SrcgProjQtnItmCommodityTerm.PrcgConditionTermFixedRateQty AS PrcgConditionTermFixedRateQty,
  SrcgProjQtnItmCommodityTerm.PrcgCndnTermFixedRateQtyUnit AS PrcgCndnTermFixedRateQtyUnit,
  SrcgProjQtnItmCommodityTerm.DerivativeContrSpecification AS DerivativeContrSpecification,
  SrcgProjQtnItmCommodityTerm.MarketIdentifierCode AS MarketIdentifierCode,
  SrcgProjQtnItmCommodityTerm.TimeToMaturity AS TimeToMaturity,
  SrcgProjQtnItmCommodityTerm.QuotationPriceType AS QuotationPriceType,
  SrcgProjQtnItemCondition.ConditionValidityEndDate AS ConditionValidityEndDate,
  SrcgProjQtnItemCondition.ConditionValidityStartDate AS ConditionValidityStartDate,
  SrcgProjQtnItemCondition.SourcingProjectQuotation AS SourcingProjectQuotation,
  SrcgProjQtnItemCondition.SourcingProjectQuotationItem AS SourcingProjectQuotationItem,
  SrcgProjQtnItemCondition.SrcgProjQuotationVersion AS SrcgProjQuotationVersion,
  SrcgProjQtnItemCondition.SrcgProjQtnItemUUID AS SrcgProjQtnItemUUID,
  SrcgProjQtnItemCondition.SourcingProjectQuotationUUID AS SourcingProjectQuotationUUID,
  SrcgProjQtnItemCondition.ProcmtHubPlantUniqueID AS ProcmtHubPlantUniqueID,
  SrcgProjQtnItemCondition.Currency AS Currency,
  SrcgProjQtnItemCondition.ConditionRateValue AS ConditionRateValue,
  SrcgProjQtnItemCondition.ConditionRateValueUnit AS ConditionRateValueUnit,
  SrcgProjQtnItemCondition.ConditionCalculationTypeShort AS ConditionCalculationTypeShort,
  SrcgProjQtnItemCondition.ConditionQuantity AS ConditionQuantity,
  SrcgProjQtnItemCondition.ConditionQuantityUnit AS ConditionQuantityUnit,
  SrcgProjQtnItemCondition.ConditionApplication AS ConditionApplication,
  SrcgProjQtnItemCondition.ConditionIsDeleted AS ConditionIsDeleted,
  SrcgProjQtnItmCommodityTerm._CmmdtyPrcgCalcRuleText AS _CmmdtyPrcgCalcRuleText,
  SrcgProjQtnItmCommodityTerm._CmmdtyPrcgQuotationRuleText AS _CmmdtyPrcgQuotationRuleText,
  SrcgProjQtnItmCommodityTerm._CmmdtyPrcgTermCalcTypeText AS _CmmdtyPrcgTermCalcTypeText,
  SrcgProjQtnItmCommodityTerm._CmmdtyPricingTermRuleText AS _CmmdtyPricingTermRuleText,
  SrcgProjQtnItmCommodityTerm._CommodityPricingTermText AS _CommodityPricingTermText,
  SrcgProjQtnItmCommodityTerm._OriginSystem AS _OriginSystem,
  SrcgProjQtnItmCommodityTerm._PrcgCndnFmlaCmmdtyQtyUnit AS _PrcgCndnFmlaCmmdtyQtyUnit,
  SrcgProjQtnItmCommodityTerm._PrcgCndnSourceQuantityUnit AS _PrcgCndnSourceQuantityUnit,
  SrcgProjQtnItmCommodityTerm._PrcgCndnTargetQuantityUnit AS _PrcgCndnTargetQuantityUnit,
  SrcgProjQtnItmCommodityTerm._PrcgConditionSourceCurrency AS _PrcgConditionSourceCurrency,
  SrcgProjQtnItmCommodityTerm._PrcgConditionTargetCurrency AS _PrcgConditionTargetCurrency
INNER JOIN R_SrcgProjQtnItemCondition AS SrcgProjQtnItemCondition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SourcingProjectQuotation AS _SourcingProjectQuotation ON _SourcingProjectQuotation.SourcingProjectQuotationUUID = SrcgProjQtnItemCondition.SourcingProjectQuotationUUID  -- association [0..1]
LEFT OUTER JOIN R_SrcgProjQtnItmCmmdtyFormula AS _SrcgProjQtnItmCmmdtyFormula ON _SrcgProjQtnItmCmmdtyFormula.ConditionRecord = SrcgProjQtnItmCommodityTerm.ConditionRecord AND _SrcgProjQtnItmCmmdtyFormula.ConditionSequentialNumberShort = SrcgProjQtnItmCommodityTerm.ConditionSequentialNumberShort  -- association [0..1]
;

Depth:

R_SrcgProjQtnItmCommodityTerm view

R_SrcgProjQtnItemCondition view_entity