I_REContractType
Real Estate Contract Type
I_REContractType 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 29 fields with key field REContractType. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| tivcncctadd | _ContractType | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_REContractTypeText | _Text | $projection.REContractType = _Text.REContractType |
| [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 |
Annotations (17)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IRECONTYPE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| EndUserText.label | Real Estate Contract Type | view | |
| ObjectModel.usageType.dataClass | #CUSTOMIZING | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.sapObjectNodeType.name | RealEstateContractType | view | |
| VDM.viewType | #BASIC | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.compositionRoot | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.modelingPattern | #ANALYTICAL_DIMENSION | view | |
| Analytics.dataCategory | #DIMENSION | view | |
| Analytics.internalName | #LOCAL | view | |
| Analytics.dataExtraction.enabled | true | view |
Fields (29)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | REContractType | smvart | ||
| REConditionGroup | condgroup | |||
| REAdjustNumberGroup | adjustnumberbeg | |||
| REAdjustNumber | adjustnumberstep | |||
| REBusinessPartnerRole1 | bproletype1 | |||
| REBusinessPartnerRole2 | bproletype2 | |||
| REContractUserSupplier | usersupplier | |||
| REContractCategory | category | |||
| RECashFlowPeriod | cfperiod | |||
| RETaxType | taxtype | |||
| TaxGroup | taxgroup | |||
| REContractDepositType | cntypedeposit | |||
| REContractIsTaxFree | istaxfree | |||
| RENoticeProcedure | ntprocdefault | |||
| REInfluenceHoldings | cntypeusageind | |||
| REFinanceDepositLevel | cmcflevel | |||
| REIsPossessionDate | ispossdenabled | |||
| REConditionGroupTotal | condgroupsum | |||
| REHasNewCreationAssignment | cuexcludeassign | |||
| REIsExclForNewAssgmt | cuexcludeassign | |||
| NumberRangeInterval | _ContractTypeFndn | NumberRangeInterval | ||
| REUsageType | _ContractTypeFndn | REUsageType | ||
| REContractTypeCategory | _ContractTypeFndn | REContractTypeCategory | ||
| REIsAreaBasedRent | _ContractTypeFndn | REIsAreaBasedRent | ||
| REHasDistributionOnObject | _ContractTypeFndn | REHasDistributionOnObject | ||
| _RETaxType | _RETaxType | |||
| _RETaxGroup | _RETaxGroup | |||
| _REFinanceDepositLevel | _REFinanceDepositLevel | |||
| _Text | _Text |
@AbapCatalog.sqlViewName: 'IRECONTYPE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Contract Type'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.representativeKey: ['REContractType']
@ObjectModel.semanticKey: ['REContractType']
@ObjectModel.sapObjectNodeType.name: 'RealEstateContractType'
//@ClientDependent: true
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
//@Search.searchable: true
@ObjectModel.compositionRoot: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [ #ANALYTICAL_DIMENSION,
#CDS_MODELING_ASSOCIATION_TARGET,
#SQL_DATA_SOURCE,
#EXTRACTION_DATA_SOURCE,
#CDS_MODELING_DATA_SOURCE]
@Analytics:{
dataCategory: #DIMENSION,
internalName: #LOCAL,
dataExtraction: {
enabled: true
}
}
// Double Maintenance with I_REContractType_2 required
define view I_REContractType
as select from tivcncctadd as _ContractType
join I_REContractTypeFndn as _ContractTypeFndn on _ContractType.smvart = _ContractTypeFndn.REContractType
association [0..*] to I_REContractTypeText as _Text on $projection.REContractType = _Text.REContractType
association [1..*] to I_RETaxType as _RETaxType on $projection.RETaxType = _RETaxType.RETaxType
association [0..1] to I_RETaxGroup as _RETaxGroup on $projection.TaxGroup = _RETaxGroup.TaxGroup
association [0..1] to I_PlanningLevel as _REFinanceDepositLevel on $projection.REFinanceDepositLevel = _REFinanceDepositLevel.PlanningLevel
{
@ObjectModel.text.association: '_Text'
key smvart as REContractType,
//gcvarnr as REScreenSequence,
condgroup as REConditionGroup,
// nrnroff as NumberRangeInterval,
//home_url as REContractHomepage,
adjustnumberbeg as REAdjustNumberGroup,
adjustnumberstep as REAdjustNumber,
bproletype1 as REBusinessPartnerRole1,
bproletype2 as REBusinessPartnerRole2,
//bpappl as REApplicationCategory,
usersupplier as REContractUserSupplier,
category as REContractCategory,
cfperiod as RECashFlowPeriod,
//optmeth as REOptionRateMethod,
// @ObjectModel.foreignKey.association: '_RETaxType'
taxtype as RETaxType,
@ObjectModel.foreignKey.association: '_RETaxGroup'
taxgroup as TaxGroup,
cntypedeposit as REContractDepositType,
istaxfree as REContractIsTaxFree,
//nooptmeth as REIsOptionRateMethodRequired,
//coseprof as RESettlementProfile,
ntprocdefault as RENoticeProcedure,
cntypeusageind as REInfluenceHoldings,
@ObjectModel.foreignKey.association: '_REFinanceDepositLevel'
cmcflevel as REFinanceDepositLevel,
//currencyassign as RECurrenyAssignment,
ispossdenabled as REIsPossessionDate,
condgroupsum as REConditionGroupTotal,
@API.element.releaseState: #DEPRECATED
@API.element.successor: 'REIsExclForNewAssgmt'
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'REIsExclForNewAssgmt'
cuexcludeassign as REHasNewCreationAssignment,
cuexcludeassign as REIsExclForNewAssgmt,
_ContractTypeFndn.NumberRangeInterval,
_ContractTypeFndn.REUsageType,
_ContractTypeFndn.REContractTypeCategory,
_ContractTypeFndn.REIsAreaBasedRent,
_ContractTypeFndn.REHasDistributionOnObject,
_RETaxType,
_RETaxGroup,
_REFinanceDepositLevel,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_Text
}
where
_ContractTypeFndn.REIsNewContractType = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECONTRACTTYPEFNDN",
"TIVCNCCTADD"
],
"ASSOCIATED":
[
"I_PLANNINGLEVEL",
"I_RECONTRACTTYPETEXT",
"I_RETAXGROUP",
"I_RETAXTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA