I_REContractType

DDL: I_RECONTRACTTYPE SQL: IRECONTYPE Type: view BASIC

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)

SourceAliasJoin Type
tivcncctadd _ContractType from

Associations (4)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/