I_REConditionType

DDL: I_RECONDITIONTYPE SQL: IRECNDNTYPE Type: view_entity BASIC
16 Fields 1 Data Sources 5 Associations

Real Estate Condition Type

I_REConditionType (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Real Estate Condition Type · Cross Applications

I_REConditionType is a Basic CDS View (Dimension) that provides data about "Real Estate Condition Type" in SAP S/4HANA. It reads from 1 data source (tivcdcondtype) and exposes 16 fields with key field REConditionType. It has 5 associations to related views.

SAP Help Documentation

CategoryCustomizing
Data CategoryDimension
Purpose
This CDS view is designed to provide a structured representation of real estate condition types within contract and lease management. It serves as a dimension in analytical scenarios, allowing users to analyze and extract data related to various condition types associated. The view integrates multiple attributes and associations to offer a comprehensive overview of condition types, including their properties, flow types, calculation rules, and distribution rules. This CDS view provides the data to answer the following business questions: What are the different condition types available in contract and lease management? How are condition types associated with specific attributes and flow types? What calculation and distribution rules are applied to each condition type? How are advance payments posted in relation to condition types? What is the unit price associated with each condition type? How can condition types be searched and analyzed for reporting purposes? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description REConditionType Condition Type REConditionAttribute Attribute REFlowType Flow Type RECalculationRule Ext. Calculation Rule RECalculationRuleParam1 Calc. Formula Param. RECalculationRuleParam2 Calc. Formula Param. REDistributionRule Ext. Distr. Formula REDistributionRuleParam1 Dist. Form. Param. 1 REDistributionRuleParam2 Dist. Form. Param. 2 REAdvancePaytIsPostedAsRevenue Revenue REUnitPrice Unit Price

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentRE-FX-CN
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction, Data Provider for Value Help, Data Source for Search
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tivcdcondtype tivcdcondtype from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_REConditionAttribute _REConditionAttribute $projection.REConditionAttribute = _REConditionAttribute.REConditionAttribute
[0..1] I_REFlowType _REFlowType $projection.REFlowType = _REFlowType.REFlowType
[0..1] I_RECndnCalculationRuleExt _RECndnCalculationRuleExt $projection.RECalculationRule = _RECndnCalculationRuleExt.RECalculationRule
[0..1] I_RECndnDistributionRuleExt _RECndnDistributionRuleExt $projection.REDistributionRule = _RECndnDistributionRuleExt.REDistributionRule
[0..*] I_REConditionTypeText _Text

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view
Analytics.technicalName IRECNDNTYPE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.representativeKey REConditionType view
ObjectModel.sapObjectNodeType.name RealEstateConditionType view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.compositionRoot true view
Search.searchable true view
EndUserText.label Real Estate Condition Type view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY REConditionType condtype Condition Type
REConditionAttribute condprop Attribute of Condition Type
REFlowType flowtype Update Type
RECalculationRule calcruleext External Calculation Formula
RECalculationRuleParam1 calcrulepara1 Untypified Parameter for a Calculation Formula
RECalculationRuleParam2 calcrulepara2 Untypified Parameter for a Calculation Formula
REDistributionRule distruleext External Distribution Formula
REDistributionRuleParam1 distrulepara1 Untypified Parameter for a Distribution Formula
REDistributionRuleParam2 distrulepara2 Untypified Parameter for a Distribution Formula
REAdvancePaytIsPostedAsRevenue bookasrevenue Advance Payment Posted as Revenue
REUnitPrice unitprice Unit Price
_Text _Text
_REConditionAttribute _REConditionAttribute
_REFlowType _REFlowType
_RECndnCalculationRuleExt _RECndnCalculationRuleExt
_RECndnDistributionRuleExt _RECndnDistributionRuleExt

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_REConditionType.
-- 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: IRECNDNTYPE

CREATE VIEW I_REConditionType AS
SELECT
  condtype AS REConditionType,
  condprop AS REConditionAttribute,
  flowtype AS REFlowType,
  calcruleext AS RECalculationRule,
  calcrulepara1 AS RECalculationRuleParam1,
  calcrulepara2 AS RECalculationRuleParam2,
  distruleext AS REDistributionRule,
  distrulepara1 AS REDistributionRuleParam1,
  distrulepara2 AS REDistributionRuleParam2,
  bookasrevenue AS REAdvancePaytIsPostedAsRevenue,
  unitprice AS REUnitPrice
FROM tivcdcondtype
LEFT OUTER JOIN I_REConditionAttribute AS _REConditionAttribute ON REConditionAttribute = _REConditionAttribute.REConditionAttribute  -- association [0..1]
LEFT OUTER JOIN I_REFlowType AS _REFlowType ON REFlowType = _REFlowType.REFlowType  -- association [0..1]
LEFT OUTER JOIN I_RECndnCalculationRuleExt AS _RECndnCalculationRuleExt ON RECalculationRule = _RECndnCalculationRuleExt.RECalculationRule  -- association [0..1]
LEFT OUTER JOIN I_RECndnDistributionRuleExt AS _RECndnDistributionRuleExt ON REDistributionRule = _RECndnDistributionRuleExt.REDistributionRule  -- association [0..1]
LEFT OUTER JOIN I_REConditionTypeText AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More