R_REContrNoticeTermTP

DDL: R_RECONTRNOTICETERMTP Type: view_entity TRANSACTIONAL

Real Estate Notice Term TP

R_REContrNoticeTermTP is a Transactional CDS View that provides data about "Real Estate Notice Term TP" in SAP S/4HANA. It reads from 1 data source (I_RETerm) and exposes 16 fields with key fields InternalRealEstateNumber, RETermType, RETermNumber. It has 2 associations to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_RETerm _RETerm from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_RENoticeTermBasic _RENoticeTerm $projection.InternalRealEstateNumber = _RENoticeTerm.InternalRealEstateNumber and $projection.RETermType = _RENoticeTerm.RETermType and $projection.RETermNumber = _RENoticeTerm.RETermNumber
[0..*] R_REContrNoticeTermRulesTP _RENoticeRules

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Real Estate Notice Term TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey RETermNumber view
Analytics.technicalName RRECNNTTRMTP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber
KEY RETermType RETermType
KEY RETermNumber RETermNumber
RETermName RETermName
RealEstateObjectType RealEstateObjectType
REStatusObject _REContract REStatusObject
REIdentificationKey _REContract REIdentificationKey
RENoticeType _RENoticeTerm RENoticeType
RENoticeProcedure _RENoticeTerm RENoticeProcedure
_RENoticeProcedure _RENoticeTerm _RENoticeProcedure
_RENoticeType _RENoticeTerm _RENoticeType
_REContract _REContract
_RETermType I_RETerm _RETermType
_REObjectType I_RETerm _REObjectType
_REKeyAssgmt I_RETerm _REKeyAssgmt
_RENoticeRules _RENoticeRules 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Real Estate Notice Term TP'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]

@ObjectModel.representativeKey:  'RETermNumber'
@Analytics.technicalName: 'RRECNNTTRMTP'
@ObjectModel.semanticKey: ['InternalRealEstateNumber', 'RETermType' ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L


define view entity R_REContrNoticeTermTP
 as select from I_RETerm as _RETerm
  association [1..1] to I_RENoticeTermBasic   as _RENoticeTerm on  $projection.InternalRealEstateNumber = _RENoticeTerm.InternalRealEstateNumber
                                                               and $projection.RETermType               = _RENoticeTerm.RETermType
                                                               and $projection.RETermNumber             = _RENoticeTerm.RETermNumber
  association        to parent R_REContractTP as _REContract   on  $projection.InternalRealEstateNumber = _REContract.InternalRealEstateNumber
  composition [0..*] of R_REContrNoticeTermRulesTP                 as _RENoticeRules
  
  //  association [1..1] to I_RENoticeTermAddl    as _RENoticeTermAddl on  $projection.InternalRealEstateNumber = _RENoticeTermAddl.InternalRealEstateNumber

  //                                                                   and $projection.RETermType               = _RENoticeTermAddl.RETermType

  //                                                                   and $projection.RETermNumber             = _RENoticeTermAddl.RETermNumber

  //                                                                   and $projection.RENoticeRule             = _RENoticeTermAddl.RENoticeRule

  //                                                                   and $projection.RENoticeSequenceNo       = _RENoticeTermAddl.RENoticeSequenceNo

{
  key InternalRealEstateNumber,
      @ObjectModel.foreignKey.association: '_RETermType'
  key RETermType,
  key RETermNumber,

      @Semantics.text: true
      RETermName,
      RealEstateObjectType,
      _REContract.REStatusObject,
      _REContract.REIdentificationKey,
      @ObjectModel.foreignKey.association: '_RENoticeType'
      _RENoticeTerm.RENoticeType,
      @ObjectModel.foreignKey.association: '_RENoticeProcedure'
      _RENoticeTerm.RENoticeProcedure,
      _RENoticeTerm._RENoticeProcedure,
      _RENoticeTerm._RENoticeType,
      _REContract,
      _RETerm._RETermType,
      _RETerm._REObjectType,
      _RETerm._REKeyAssgmt
      ,
      _RENoticeRules

}
where
 RETermType = '1020' and _REContract.RealEstateObjectType = 'IS'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RENOTICETERMBASIC",
"I_RETERM",
"R_RECONTRACTTP"
],
"ASSOCIATED":
[
"I_REKEYASSGMT",
"I_RENOTICEPROCEDURE",
"I_RENOTICETYPE",
"I_REOBJECTTYPE",
"I_RETERMTYPE",
"R_RECONTRACTTP",
"R_RECONTRNOTICETERMRULESTP"
],
"BASE":
[
"I_RENOTICETERMBASIC",
"I_RETERM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More