I_PrcgCndnRootTrmCnvrsnInput

DDL: I_PRCGCNDNROOTTRMCNVRSNINPUT Type: view_entity COMPOSITE
27 Fields 3 Data Sources

CPE Root term conversion input

I_PrcgCndnRootTrmCnvrsnInput is a Composite CDS View that provides data about "CPE Root term conversion input" in SAP S/4HANA. It reads from 3 data sources (I_CmmdtyPrcgCndnTermConversion, I_CmmdtyPrcgConditionRootTerm, I_CndnCnvrsnPlaceForTrmCnvrsn) and exposes 27 fields with key fields DocItmCmmdtyPrcgCndnUUID, PricingConditionTerm, PrcgConditionConversionPlace, PricingConditionTermKey, PricingConditionSourceCurrency.

Data Sources (3)

SourceAliasJoin Type
I_CmmdtyPrcgCndnTermConversion _CmmdtyPrcgCndnTermConversion from
I_CmmdtyPrcgConditionRootTerm _CmmdtyPrcgConditionRootTerm inner
I_CndnCnvrsnPlaceForTrmCnvrsn _CndnCnvrsnPlaceForTrmCnvrsn inner

Annotations (7)

NameValueLevelField
EndUserText.label CPE Root term conversion input view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
ObjectModel.sapObjectNodeType.name CmmdtyPrcgCndnRootTermCnvrsn view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY DocItmCmmdtyPrcgCndnUUID I_CmmdtyPrcgCndnTermConversion DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID
KEY PricingConditionTerm I_CmmdtyPrcgCndnTermConversion PricingConditionTerm Term Number
KEY PrcgConditionConversionPlace I_CmmdtyPrcgCndnTermConversion PrcgConditionConversionPlace Conv. Place
KEY PricingConditionTermKey I_CmmdtyPrcgCndnTermConversion PricingConditionTermKey Term Key
KEY PricingConditionSourceCurrency I_CmmdtyPrcgCndnTermConversion PricingConditionSourceCurrency Curr:Conv. from
KEY PrcgCndnSourceQuantityUnit I_CmmdtyPrcgCndnTermConversion PrcgCndnSourceQuantityUnit UoM: Conv. from
KEY PricingConditionTargetCurrency I_CmmdtyPrcgCndnTermConversion PricingConditionTargetCurrency Curr.: Conv. to
KEY PrcgCndnTargetQuantityUnit I_CmmdtyPrcgCndnTermConversion PrcgCndnTargetQuantityUnit UoM: Conv. to
PricingConditionConversionRule I_CmmdtyPrcgCndnTermConversion PricingConditionConversionRule Conv. Rule
PrcgConditionFixedExchangeRate I_CmmdtyPrcgCndnTermConversion PrcgConditionFixedExchangeRate Fix.Exch.Rate
SourceConversionFactor I_CmmdtyPrcgCndnTermConversion SourceConversionFactor From-Fctr Conv.
TargetConversionFactor I_CmmdtyPrcgCndnTermConversion TargetConversionFactor To-Fctr Conv.
PrcgCndnFXRateChangeDateTime I_CmmdtyPrcgCndnTermConversion PrcgCndnFXRateChangeDateTime
PrcgCndnFXRateChangedByUser I_CmmdtyPrcgCndnTermConversion PrcgCndnFXRateChangedByUser Changed By
PrcgConditionConversionRoutine I_CmmdtyPrcgCndnTermConversion PrcgConditionConversionRoutine Conv. Routine
PrcgConditionExchangeRateType I_CmmdtyPrcgCndnTermConversion PrcgConditionExchangeRateType Exch. Rate Type
PrcgCndnCnvrsnIsExchRateAvg I_CmmdtyPrcgCndnTermConversion PrcgCndnCnvrsnIsExchRateAvg Ex.Rate Avging
PrcgCndnConversionRoundingRule I_CmmdtyPrcgCndnTermConversion PrcgCndnConversionRoundingRule Round Rule Curr
PrcgCndnQuantityConversionRule I_CmmdtyPrcgCndnTermConversion PrcgCndnQuantityConversionRule Quantity Conv. Rule
CndnCrcyCnvrsnRoundingRoutine I_CmmdtyPrcgCndnTermConversion CndnCrcyCnvrsnRoundingRoutine Rnd.Routine for Curr
CrcyCnvrsnNrOfDcmlsToBeRnddTo I_CmmdtyPrcgCndnTermConversion CrcyCnvrsnNrOfDcmlsToBeRnddTo Dec. Plcs. conv curr
CrcyCnvrsnNrOfPreDcmlsRnddTo I_CmmdtyPrcgCndnTermConversion CrcyCnvrsnNrOfPreDcmlsRnddTo Predec. Rnd. Curr.
CndnQuantityConversionRoutine I_CmmdtyPrcgCndnTermConversion CndnQuantityConversionRoutine Qty Conv. Rtine
CndnQtyConversionRoundingRule I_CmmdtyPrcgCndnTermConversion CndnQtyConversionRoundingRule Round Rule Qty
CndnQtyCnvrsnRoundingRoutine I_CmmdtyPrcgCndnTermConversion CndnQtyCnvrsnRoundingRoutine Round. Routine
QtyCnvrsnNrOfDcmlsToBeRnddTo I_CmmdtyPrcgCndnTermConversion QtyCnvrsnNrOfDcmlsToBeRnddTo Dec. Plcs. convt Qty
QtyCnvrsnNrOfPreDcmlsRoundedTo I_CmmdtyPrcgCndnTermConversion QtyCnvrsnNrOfPreDcmlsRoundedTo Predec. Rndng

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_PrcgCndnRootTrmCnvrsnInput.
-- 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_PrcgCndnRootTrmCnvrsnInput AS
SELECT
  _CmmdtyPrcgCndnTermConversion.DocItmCmmdtyPrcgCndnUUID AS DocItmCmmdtyPrcgCndnUUID,
  _CmmdtyPrcgCndnTermConversion.PricingConditionTerm AS PricingConditionTerm,
  _CmmdtyPrcgCndnTermConversion.PrcgConditionConversionPlace AS PrcgConditionConversionPlace,
  _CmmdtyPrcgCndnTermConversion.PricingConditionTermKey AS PricingConditionTermKey,
  _CmmdtyPrcgCndnTermConversion.PricingConditionSourceCurrency AS PricingConditionSourceCurrency,
  _CmmdtyPrcgCndnTermConversion.PrcgCndnSourceQuantityUnit AS PrcgCndnSourceQuantityUnit,
  _CmmdtyPrcgCndnTermConversion.PricingConditionTargetCurrency AS PricingConditionTargetCurrency,
  _CmmdtyPrcgCndnTermConversion.PrcgCndnTargetQuantityUnit AS PrcgCndnTargetQuantityUnit,
  _CmmdtyPrcgCndnTermConversion.PricingConditionConversionRule AS PricingConditionConversionRule,
  _CmmdtyPrcgCndnTermConversion.PrcgConditionFixedExchangeRate AS PrcgConditionFixedExchangeRate,
  _CmmdtyPrcgCndnTermConversion.SourceConversionFactor AS SourceConversionFactor,
  _CmmdtyPrcgCndnTermConversion.TargetConversionFactor AS TargetConversionFactor,
  _CmmdtyPrcgCndnTermConversion.PrcgCndnFXRateChangeDateTime AS PrcgCndnFXRateChangeDateTime,
  _CmmdtyPrcgCndnTermConversion.PrcgCndnFXRateChangedByUser AS PrcgCndnFXRateChangedByUser,
  _CmmdtyPrcgCndnTermConversion.PrcgConditionConversionRoutine AS PrcgConditionConversionRoutine,
  _CmmdtyPrcgCndnTermConversion.PrcgConditionExchangeRateType AS PrcgConditionExchangeRateType,
  _CmmdtyPrcgCndnTermConversion.PrcgCndnCnvrsnIsExchRateAvg AS PrcgCndnCnvrsnIsExchRateAvg,
  _CmmdtyPrcgCndnTermConversion.PrcgCndnConversionRoundingRule AS PrcgCndnConversionRoundingRule,
  _CmmdtyPrcgCndnTermConversion.PrcgCndnQuantityConversionRule AS PrcgCndnQuantityConversionRule,
  _CmmdtyPrcgCndnTermConversion.CndnCrcyCnvrsnRoundingRoutine AS CndnCrcyCnvrsnRoundingRoutine,
  _CmmdtyPrcgCndnTermConversion.CrcyCnvrsnNrOfDcmlsToBeRnddTo AS CrcyCnvrsnNrOfDcmlsToBeRnddTo,
  _CmmdtyPrcgCndnTermConversion.CrcyCnvrsnNrOfPreDcmlsRnddTo AS CrcyCnvrsnNrOfPreDcmlsRnddTo,
  _CmmdtyPrcgCndnTermConversion.CndnQuantityConversionRoutine AS CndnQuantityConversionRoutine,
  _CmmdtyPrcgCndnTermConversion.CndnQtyConversionRoundingRule AS CndnQtyConversionRoundingRule,
  _CmmdtyPrcgCndnTermConversion.CndnQtyCnvrsnRoundingRoutine AS CndnQtyCnvrsnRoundingRoutine,
  _CmmdtyPrcgCndnTermConversion.QtyCnvrsnNrOfDcmlsToBeRnddTo AS QtyCnvrsnNrOfDcmlsToBeRnddTo,
  _CmmdtyPrcgCndnTermConversion.QtyCnvrsnNrOfPreDcmlsRoundedTo AS QtyCnvrsnNrOfPreDcmlsRoundedTo
FROM I_CmmdtyPrcgCndnTermConversion AS _CmmdtyPrcgCndnTermConversion
INNER JOIN I_CmmdtyPrcgConditionRootTerm AS _CmmdtyPrcgConditionRootTerm ON /* join condition not captured in parsed metadata */
INNER JOIN I_CndnCnvrsnPlaceForTrmCnvrsn AS _CndnCnvrsnPlaceForTrmCnvrsn ON /* join condition not captured in parsed metadata */
;

Learn More