I_REContractType_2

DDL: I_RECONTRACTTYPE_2 SQL: IRECONTYPE2 Type: view_entity BASIC
28 Fields 1 Data Sources 4 Associations

Real Estate Contract Type

I_REContractType_2 (Basic)

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

Real Estate Contract Type · Cross Applications

I_REContractType_2 is a Basic CDS View (Dimension) that provides data about "Real Estate Contract Type" in SAP S/4HANA. It reads from 1 data source (tivcncctadd) and exposes 28 fields with key field REContractType. It has 4 associations to related views.

SAP Help Documentation

CategoryCustomizing
Data CategoryDimension
Purpose
This CDS view is designed to provide detailed information about contract types within contract and lease management. It integrates various attributes and associations related to contracts, enabling users to analyze and understand the characteristics and categorizations of different contract types. This CDS view provides the data to answer the following business questions: What are the different types of contracts available in the system? How are contracts categorized based on their attributes such as condition group, tax type? Which business partner roles are associated with specific contract types? What are the cash flow periods and notice procedures linked to each contract type? Are there any tax exemptions applicable to certain contract types? How do contract types influence holdings? What are the foundational attributes like usage type and contract category for new contract types? 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 REContractType Contract Type REConditionGroup Condition Group REAdjustNumberGroup Group Number Start REAdjustNumber Group No. Interval REBusinessPartnerRole1 BP Role 1 REBusinessPartnerRole2 BP Role 2 REContractUserSupplier Offerer/User REContractCategory Contract Category RECashFlowPeriod CF Period RETaxType Default Tax Type TaxGroup Default Tax Group REContractDepositType Contr.Type Dep.Agrmt REContractIsTaxFree Tax-Exempt RENoticeProcedure Notice Procedure REInfluenceHoldings Influence Holdings REFinanceDepositLevel Planning Level REIsPossessionDate Possession Dates REConditionGroupTotal Condition Grp Total REIsExclForNewAssgmt Obsolete NumberRangeInterval Number Range Number REUsageType Usage category REContractTypeCategory Contract category REIsAreaBasedRent No area basis REHasDistributionOnObject Aut. object distrib.

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
CapabilitiesAssociation Target for Defining CDS Entities, Analytical Dimension, Data Source for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
tivcncctadd _ContractType from

Associations (4)

CardinalityTargetAliasCondition
[1..*] I_RETaxType _RETaxType $projection.RETaxType = _RETaxType.RETaxType
[0..1] I_RETaxGroup _RETaxGroup $projection.TaxGroup = _RETaxGroup.TaxGroup
[0..1] I_PlanningLevel _REFinanceDepositLevel $projection.REFinanceDepositLevel = _REFinanceDepositLevel.PlanningLevel
[0..*] I_REContractTypeText_2 _Text

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Contract Type view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey REContractType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name RealEstateContractType view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.enabled true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY REContractType tivcncctadd smvart External Real Estate Contract Type
REConditionGroup tivcncctadd condgroup Condition Group
REAdjustNumberGroup tivcncctadd adjustnumberbeg Start of Group Number
REAdjustNumber tivcncctadd adjustnumberstep Interval Between Group Numbers
REBusinessPartnerRole1 tivcncctadd bproletype1 Business Partner: Role
REBusinessPartnerRole2 tivcncctadd bproletype2 Business Partner: Role
REContractUserSupplier tivcncctadd usersupplier Offerer (Customer), User (Vendor)
REContractCategory tivcncctadd category Real Estate Contract Category
RECashFlowPeriod tivcncctadd cfperiod Update Period of Cash Flow Items in Years
RETaxType tivcncctadd taxtype Default Value for Tax Type
TaxGroup tivcncctadd taxgroup Default Value for Tax Group
REContractDepositType tivcncctadd cntypedeposit Contract Type of Security Deposit Agreement
REContractIsTaxFree tivcncctadd istaxfree Tax-Exempt
RENoticeProcedure tivcncctadd ntprocdefault Notice Procedure: Default When Creating Contract
REInfluenceHoldings tivcncctadd cntypeusageind Influence on Changes in Holdings
REFinanceDepositLevel tivcncctadd cmcflevel Planning Level
REIsPossessionDate tivcncctadd ispossdenabled Possession Dates Active/Inactive
REConditionGroupTotal tivcncctadd condgroupsum Condition Group Total
REIsExclForNewAssgmt tivcncctadd cuexcludeassign No New Creation or Assignment
NumberRangeInterval _ContractTypeFndn NumberRangeInterval Number range number
REUsageType _ContractTypeFndn REUsageType Rental unit usage category indicator
REContractTypeCategory _ContractTypeFndn REContractTypeCategory Real Estate contract category
REIsAreaBasedRent _ContractTypeFndn REIsAreaBasedRent Rental based on area is not permitted
REHasDistributionOnObject _ContractTypeFndn REHasDistributionOnObject Indicator for automatic distribution on object
_RETaxType _RETaxType
_RETaxGroup _RETaxGroup
_REFinanceDepositLevel _REFinanceDepositLevel
_Text _Text

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_REContractType_2.
-- 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: IRECONTYPE2

CREATE VIEW I_REContractType_2 AS
SELECT
  _ContractType.smvart AS REContractType,
  _ContractType.condgroup AS REConditionGroup,
  _ContractType.adjustnumberbeg AS REAdjustNumberGroup,
  _ContractType.adjustnumberstep AS REAdjustNumber,
  _ContractType.bproletype1 AS REBusinessPartnerRole1,
  _ContractType.bproletype2 AS REBusinessPartnerRole2,
  _ContractType.usersupplier AS REContractUserSupplier,
  _ContractType.category AS REContractCategory,
  _ContractType.cfperiod AS RECashFlowPeriod,
  _ContractType.taxtype AS RETaxType,
  _ContractType.taxgroup AS TaxGroup,
  _ContractType.cntypedeposit AS REContractDepositType,
  _ContractType.istaxfree AS REContractIsTaxFree,
  _ContractType.ntprocdefault AS RENoticeProcedure,
  _ContractType.cntypeusageind AS REInfluenceHoldings,
  _ContractType.cmcflevel AS REFinanceDepositLevel,
  _ContractType.ispossdenabled AS REIsPossessionDate,
  _ContractType.condgroupsum AS REConditionGroupTotal,
  _ContractType.cuexcludeassign AS REIsExclForNewAssgmt,
  _ContractTypeFndn.NumberRangeInterval AS NumberRangeInterval,
  _ContractTypeFndn.REUsageType AS REUsageType,
  _ContractTypeFndn.REContractTypeCategory AS REContractTypeCategory,
  _ContractTypeFndn.REIsAreaBasedRent AS REIsAreaBasedRent,
  _ContractTypeFndn.REHasDistributionOnObject AS REHasDistributionOnObject
FROM tivcncctadd AS _ContractType
LEFT OUTER JOIN I_RETaxType AS _RETaxType ON RETaxType = _RETaxType.RETaxType  -- association [1..*]
LEFT OUTER JOIN I_RETaxGroup AS _RETaxGroup ON TaxGroup = _RETaxGroup.TaxGroup  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevel AS _REFinanceDepositLevel ON REFinanceDepositLevel = _REFinanceDepositLevel.PlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_REContractTypeText_2 AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More