I_PrcgCndnRootTrmRoundingInput

DDL: I_PRCGCNDNROOTTRMROUNDINGINPUT Type: view_entity COMPOSITE
7 Fields 3 Data Sources

CPE Root Term Rounding Input

I_PrcgCndnRootTrmRoundingInput is a Composite CDS View that provides data about "CPE Root Term Rounding Input" in SAP S/4HANA. It reads from 3 data sources (I_CmmdtyPrcgCndnTermRounding, I_CmmdtyPrcgConditionRootTerm, I_CndnCnvrsnPlaceForTrmRndng) and exposes 7 fields with key fields DocItmCmmdtyPrcgCndnUUID, PricingConditionTerm, PrcgConditionConversionPlace.

Data Sources (3)

SourceAliasJoin Type
I_CmmdtyPrcgCndnTermRounding _CmmdtyPrcgCndnTermRounding from
I_CmmdtyPrcgConditionRootTerm _CmmdtyPrcgConditionRootTerm inner
I_CndnCnvrsnPlaceForTrmRndng _CndnCnvrsnPlaceForTrmRndng inner

Annotations (7)

NameValueLevelField
EndUserText.label CPE Root Term Rounding 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 CmmdtyPrcgCndnRootTrmRounding view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY DocItmCmmdtyPrcgCndnUUID I_CmmdtyPrcgCndnTermRounding DocItmCmmdtyPrcgCndnUUID Doc. Cond. Item GUID
KEY PricingConditionTerm I_CmmdtyPrcgCndnTermRounding PricingConditionTerm Term Number
KEY PrcgConditionConversionPlace I_CmmdtyPrcgCndnTermRounding PrcgConditionConversionPlace Conv. Place
PricingConditionRoundingRule I_CmmdtyPrcgCndnTermRounding PricingConditionRoundingRule Rounding Rule
PrcgConditionRoundingRoutine I_CmmdtyPrcgCndnTermRounding PrcgConditionRoundingRoutine Round. Routine
PrcgCndnNrOfDcmlsToBeRoundedTo I_CmmdtyPrcgCndnTermRounding PrcgCndnNrOfDcmlsToBeRoundedTo Dec. Places Rnd
PrcgCndnNrOfPreDcmlsToBeRnddTo I_CmmdtyPrcgCndnTermRounding PrcgCndnNrOfPreDcmlsToBeRnddTo 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_PrcgCndnRootTrmRoundingInput.
-- 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_PrcgCndnRootTrmRoundingInput AS
SELECT
  _CmmdtyPrcgCndnTermRounding.DocItmCmmdtyPrcgCndnUUID AS DocItmCmmdtyPrcgCndnUUID,
  _CmmdtyPrcgCndnTermRounding.PricingConditionTerm AS PricingConditionTerm,
  _CmmdtyPrcgCndnTermRounding.PrcgConditionConversionPlace AS PrcgConditionConversionPlace,
  _CmmdtyPrcgCndnTermRounding.PricingConditionRoundingRule AS PricingConditionRoundingRule,
  _CmmdtyPrcgCndnTermRounding.PrcgConditionRoundingRoutine AS PrcgConditionRoundingRoutine,
  _CmmdtyPrcgCndnTermRounding.PrcgCndnNrOfDcmlsToBeRoundedTo AS PrcgCndnNrOfDcmlsToBeRoundedTo,
  _CmmdtyPrcgCndnTermRounding.PrcgCndnNrOfPreDcmlsToBeRnddTo AS PrcgCndnNrOfPreDcmlsToBeRnddTo
FROM I_CmmdtyPrcgCndnTermRounding AS _CmmdtyPrcgCndnTermRounding
INNER JOIN I_CmmdtyPrcgConditionRootTerm AS _CmmdtyPrcgConditionRootTerm ON /* join condition not captured in parsed metadata */
INNER JOIN I_CndnCnvrsnPlaceForTrmRndng AS _CndnCnvrsnPlaceForTrmRndng ON /* join condition not captured in parsed metadata */
;

Learn More