Which tables does R_REContractTP use?

R_REContractTP reads from 1 data source(s): I_REContract.

How many fields does R_REContractTP have?

R_REContractTP has 98 fields. Key fields: InternalRealEstateNumber.

R_REContractTP

DDL: R_RECONTRACTTP Type: view_entity TRANSACTIONAL

Real Estate Contract TP

R_REContractTP is a Transactional CDS View that provides data about "Real Estate Contract TP" in SAP S/4HANA. It reads from 1 data source (I_REContract) and exposes 98 fields with key field InternalRealEstateNumber. It has 29 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_REContract	REContract	from

Associations (29)

Cardinality	Target	Alias	Condition
[1..1]	I_REContractAddl	_REContractAddl	`$projection.InternalRealEstateNumber = _REContractAddl.InternalRealEstateNumber`
[0..*]	I_StatusProfiletext	_StatusProfileText	`$projection.StatusProfile = _StatusProfileText.StatusProfile`
[1..1]	E_REContract	_Extension	`$projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber`
[0..1]	P_REActVlnForCoCodeContrType	_ValuationRules	`$projection.CompanyCode = _ValuationRules.CompanyCode and $projection.REContractType = _ValuationRules.REContractType`
[0..*]	R_REContrPartAssgmtTP	_REPartnerAssgmtTP
[0..*]	R_REContrObjAssgmtTP	_REObjAssgmtTP
[1..*]	R_REContrOrglAssgmtTermTP	_REOrglAssgmtTermTP
[1..*]	R_REContrPostingTermTP	_REPostingTermTP
[1..*]	R_REContrRhythmTermTP	_RERhythmTermTP
[0..*]	R_REContrRenewalTermAndRulesTP	_RERenewalTermAndRulesTP
[0..*]	R_REContrRenewalTermTP	_RERenewalTermTP
[0..*]	R_REContractRenewalTP	_RERenewalTP
[0..*]	R_REContractNoticeTP	_RENoticeTP
[0..*]	R_REContrNoticeTermTP	_RENoticeTermTP
[0..*]	R_REContrNoticeTermAndRulesTP	_RENoticeTermAndRulesTP
[0..*]	R_REContrConditionTP	_REConditionTP
[0..*]	R_REContrNoticeTermForObjTP	_RENoticeTermForObjTP
[0..*]	R_REContrAdjustmentTermTP	_REAdjustmentTermTP
[0..*]	R_REContrReminderRuleTP	_REReminderRuleTP
[0..*]	R_REContrReminderRuleMainTP	_REReminderRuleMainTP
[0..*]	R_REContrReminderDateTP	_REReminderDateTP
[0..*]	R_REContrValuationTP	_REValuationTP
[0..*]	R_REContrValuationConditionTP	_REValuationConditionTP
[0..*]	R_REContrSalesRuleTermTP	_RESalesRuleTermTP
[0..*]	R_REContrSalesReportingTermTP	_RESalesReportingTermTP
[0..*]	R_REContrSalesRuleFrqcyTermTP	_RESalesRuleFrqcyTermTP
[0..*]	R_REContrRegistryEntryTP	_RERegistryEntryTP
[0..*]	R_REContrValuationProcStepTP	_REValuationProcessStepTP
[0..*]	R_REContrStatusObjectTP	_REStatusObjectTP

Annotations (13)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Real Estate Contract TP	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.representativeKey	InternalRealEstateNumber	view
ObjectModel.sapObjectNodeType.name	RealEstateContract	view
ObjectModel.lifecycle.enqueue.expiryInterval	PT15M	view
ObjectModel.objectIdentifier.oidElement	RealEstateContractOID	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
Analytics.technicalName	RRECONTRACTTP	view

Fields (98)

Key	Field	Source Table	Source Field
KEY	InternalRealEstateNumber		InternalRealEstateNumber
	CompanyCode		CompanyCode
	RealEstateContract		RealEstateContract
	REStatusObject		REStatusObject
	REInternalFinNumber		REInternalFinNumber
	RealEstateContractOID		RealEstateContractOID
	REContractAlternativeID		REContractAlternativeID
	REIdentificationKey		REIdentificationKey
	RECreationType		RECreationType
	CreatedByUser		CreatedByUser
	CreationDate		CreationDate
	CreationTime		CreationTime
	RESourceOfCreation		RESourceOfCreation
	LastChangedByUser		LastChangedByUser
	LastChangeDate		LastChangeDate
	LastChangeTime		LastChangeTime
	RESourceOfChange		RESourceOfChange
	Responsible		Responsible
	REUserExclusive		REUserExclusive
	REAuthorizationGroup		REAuthorizationGroup
	REContractType		REContractType
	ContractStartDate		ContractStartDate
	ContractEndDate		ContractEndDate
	REContractName		REContractName
	REContractActivateDate		REContractActivateDate
	RETenancyLaw		RETenancyLaw
	REContractNumberOld		REContractNumberOld
	REMainContractCompanyCode		REMainContractCompanyCode
	REMainContract		REMainContract
	REContractCurrency		REContractCurrency
	REIndustrySector		REIndustrySector
	REIsSalesRelevant		REIsSalesRelevant
	REContractDepositType		REContractDepositType
	REContractSignDate		REContractSignDate
	REContract2SignDate		REContract2SignDate
	REContractCashFlowDate		REContractCashFlowDate
	REContractFirstEndDate		REContractFirstEndDate
	REContractNoticeDate		REContractNoticeDate
	REContractNoticeInDate		REContractNoticeInDate
	REContractNoticeReason		REContractNoticeReason
	REContractNoticeActivationDate		REContractNoticeActivationDate
	RECashFlowArchivedToDate		RECashFlowArchivedToDate
	RECashFlowLockedToDate		RECashFlowLockedToDate
	RECashFlowPostingFromDate		RECashFlowPostingFromDate
	REBusinessEntity		REBusinessEntity
	REPossessionStartDate		REPossessionStartDate
	REPossessionEndDate		REPossessionEndDate
	REHasMultipleAssignments		REHasMultipleAssignments
	REObjectAvailableFromDate		REObjectAvailableFromDate
	REObjectAvailableToDate		REObjectAvailableToDate
	ValuationRelevance		ValuationRelevance
	StatusProfile	_StatusObject	StatusProfile
	RealEstateObjectType		RealEstateObjectType
	REBusinessPartnerRole1	_REContractType	REBusinessPartnerRole1
	_REContractAddl		_REContractAddl
	_CompanyCode		_CompanyCode
	_MainContractCompanyCode		_MainContractCompanyCode
	_StatusObject		_StatusObject
	_StatusObjectStatus		_StatusObjectStatus
	_REObjectType		_REObjectType
	_REAuthorizationGroup		_REAuthorizationGroup
	_CreatedByUser		_CreatedByUser
	_ChangedByUser		_ChangedByUser
	_ResponsibleUser		_ResponsibleUser
	_Currency		_Currency
	_REIndustry		_REIndustry
	_RECreationType		_RECreationType
	_REContractType		_REContractType
	_RETenancyLaw		_RETenancyLaw
	_REContractDepositType		_REContractDepositType
	_REContractNoticeReason		_REContractNoticeReason
	_REValuationRelevance		_REValuationRelevance
	_REPartnerAssgmtTP		_REPartnerAssgmtTP
	_REOrglAssgmtTermTP		_REOrglAssgmtTermTP
	_REPostingTermTP		_REPostingTermTP
	_RERhythmTermTP		_RERhythmTermTP
	_REObjAssgmtTP		_REObjAssgmtTP
	_RERenewalTermTP		_RERenewalTermTP
	_RERenewalTermAndRulesTP		_RERenewalTermAndRulesTP
	_StatusProfileText		_StatusProfileText
	_RERenewalTP		_RERenewalTP
	_RENoticeTP		_RENoticeTP
	_RENoticeTermTP		_RENoticeTermTP
	_REConditionTP		_REConditionTP
	_RENoticeTermForObjTP		_RENoticeTermForObjTP
	_REAdjustmentTermTP		_REAdjustmentTermTP
	_REReminderRuleTP		_REReminderRuleTP
	_REReminderRuleMainTP		_REReminderRuleMainTP
	_REReminderDateTP		_REReminderDateTP
	_REValuationTP		_REValuationTP
	_REValuationConditionTP		_REValuationConditionTP
	_RESalesRuleTermTP		_RESalesRuleTermTP
	_RESalesReportingTermTP		_RESalesReportingTermTP
	_RESalesRuleFrqcyTermTP		_RESalesRuleFrqcyTermTP
	_RERegistryEntryTP		_RERegistryEntryTP
	_RENoticeTermAndRulesTP		_RENoticeTermAndRulesTP
	_REValuationProcessStepTP		_REValuationProcessStepTP
	_REStatusObjectTP		_REStatusObjectTP

@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_StatusObject']
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@EndUserText.label: 'Real Estate Contract TP'

@ObjectModel: {
        usageType: {
            serviceQuality: #C,
            dataClass: #TRANSACTIONAL,
            sizeCategory: #XL
        },

        semanticKey: ['RealEstateContract', 'CompanyCode' ],
        representativeKey: 'InternalRealEstateNumber',
        sapObjectNodeType.name: 'RealEstateContract',
        lifecycle.enqueue.expiryInterval: 'PT15M', //draft expiry 15 min for lock testing

        objectIdentifier.oidElement: 'RealEstateContractOID',
        alternativeKey: [{ element: [ 'RealEstateContractOID' ], id: 'OID', uniqueness: #UNIQUE_IF_NOT_INITIAL }]
    }

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

@Analytics.technicalName: 'RRECONTRACTTP'

define root view entity R_REContractTP
  as select from I_REContract as REContract
  composition [0..*] of R_REContrPartAssgmtTP          as _REPartnerAssgmtTP
  composition [0..*] of R_REContrObjAssgmtTP           as _REObjAssgmtTP
  composition [1..*] of R_REContrOrglAssgmtTermTP      as _REOrglAssgmtTermTP
  composition [1..*] of R_REContrPostingTermTP         as _REPostingTermTP
  composition [1..*] of R_REContrRhythmTermTP          as _RERhythmTermTP
  composition [0..*] of R_REContrRenewalTermAndRulesTP as _RERenewalTermAndRulesTP
  composition [0..*] of R_REContrRenewalTermTP         as _RERenewalTermTP

  composition [0..*] of R_REContractRenewalTP          as _RERenewalTP
  composition [0..*] of R_REContractNoticeTP           as _RENoticeTP

  composition [0..*] of R_REContrNoticeTermTP          as _RENoticeTermTP
  composition [0..*] of R_REContrNoticeTermAndRulesTP  as _RENoticeTermAndRulesTP
  composition [0..*] of R_REContrConditionTP           as _REConditionTP
  composition [0..*] of R_REContrNoticeTermForObjTP    as _RENoticeTermForObjTP
  composition [0..*] of R_REContrAdjustmentTermTP      as _REAdjustmentTermTP
  composition [0..*] of R_REContrReminderRuleTP        as _REReminderRuleTP
  composition [0..*] of R_REContrReminderRuleMainTP    as _REReminderRuleMainTP
  composition [0..*] of R_REContrReminderDateTP        as _REReminderDateTP
  composition [0..*] of R_REContrValuationTP           as _REValuationTP
  composition [0..*] of R_REContrValuationConditionTP  as _REValuationConditionTP
  composition [0..*] of R_REContrSalesRuleTermTP       as _RESalesRuleTermTP
  composition [0..*] of R_REContrSalesReportingTermTP  as _RESalesReportingTermTP
  composition [0..*] of R_REContrSalesRuleFrqcyTermTP  as _RESalesRuleFrqcyTermTP
  composition [0..*] of R_REContrRegistryEntryTP       as _RERegistryEntryTP
  composition [0..*] of R_REContrValuationProcStepTP   as _REValuationProcessStepTP
  composition [0..*] of R_REContrStatusObjectTP        as _REStatusObjectTP

  //  Additional fields

  association [1..1] to I_REContractAddl               as _REContractAddl    on  $projection.InternalRealEstateNumber = _REContractAddl.InternalRealEstateNumber
  //Text

  association [0..*] to I_StatusProfiletext            as _StatusProfileText on  $projection.StatusProfile = _StatusProfileText.StatusProfile
  //  Extensibility

  association [1..1] to E_REContract                   as _Extension         on  $projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber

  association [0..1] to P_REActVlnForCoCodeContrType as _ValuationRules
      on $projection.CompanyCode = _ValuationRules.CompanyCode and
         $projection.REContractType = _ValuationRules.REContractType
{
  key     InternalRealEstateNumber                                                                                               as InternalRealEstateNumber,
          CompanyCode                                                                                                            as CompanyCode,
          RealEstateContract                                                                                                     as RealEstateContract,
          REStatusObject                                                                                                         as REStatusObject,
          REInternalFinNumber                                                                                                    as REInternalFinNumber,
          RealEstateContractOID,
          REContractAlternativeID,
          REIdentificationKey                                                                                                    as REIdentificationKey,
          RECreationType                                                                                                         as RECreationType,
          @Semantics.user.createdBy: true
          CreatedByUser                                                                                                          as CreatedByUser,
          CreationDate                                                                                                           as CreationDate,
          CreationTime                                                                                                           as CreationTime,
          //          Create Timestamp aggregation

          @Semantics.systemDateTime.createdAt: true
          cast (dats_tims_to_tstmp( CreationDate,
                              CreationTime,
                              abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as vdm_creationdatetime) as CreationDateTime,
          RESourceOfCreation                                                                                                     as RESourceOfCreation,
          @Semantics.user.lastChangedBy: true
          LastChangedByUser                                                                                                      as LastChangedByUser,
          LastChangeDate                                                                                                         as LastChangeDate,
          LastChangeTime                                                                                                         as LastChangeTime,
          //          LastChange Timestamp aggregation

          @Semantics.systemDateTime.lastChangedAt: true
          cast (dats_tims_to_tstmp( LastChangeDate,
                              LastChangeTime,
                              abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as vdm_lastchangedon)    as LastChangeDateTime,
          RESourceOfChange                                                                                                       as RESourceOfChange,
          @Semantics.user.createdBy: true
          Responsible                                                                                                            as Responsible,
          REUserExclusive                                                                                                        as REUserExclusive,
          REAuthorizationGroup                                                                                                   as REAuthorizationGroup,
          REContractType                                                                                                         as REContractType,
          @Semantics.businessDate.from: true
          ContractStartDate                                                                                                      as ContractStartDate,
          @Semantics.businessDate.to: true
          ContractEndDate                                                                                                        as ContractEndDate,
          //@ObjectModel.mandatory: true

          REContractName                                                                                                         as REContractName,
          REContractActivateDate                                                                                                 as REContractActivateDate,
          RETenancyLaw                                                                                                           as RETenancyLaw,
          REContractNumberOld                                                                                                    as REContractNumberOld,
          REMainContractCompanyCode                                                                                              as REMainContractCompanyCode,
          REMainContract                                                                                                         as REMainContract,
          //@Semantics.currencyCode: true

          REContractCurrency                                                                                                     as REContractCurrency,
          REIndustrySector                                                                                                       as REIndustrySector,
          REIsSalesRelevant                                                                                                      as REIsSalesRelevant,
          REContractDepositType                                                                                                  as REContractDepositType,
          REContractSignDate                                                                                                     as REContractSignDate,
          REContract2SignDate                                                                                                    as REContract2SignDate,
          REContractCashFlowDate                                                                                                 as REContractCashFlowDate,
          REContractFirstEndDate                                                                                                 as REContractFirstEndDate,
          REContractNoticeDate                                                                                                   as REContractNoticeDate,
          REContractNoticeInDate                                                                                                 as REContractNoticeInDate,
          REContractNoticeReason                                                                                                 as REContractNoticeReason,
          REContractNoticeActivationDate                                                                                         as REContractNoticeActivationDate,
          RECashFlowArchivedToDate                                                                                               as RECashFlowArchivedToDate,
          RECashFlowLockedToDate                                                                                                 as RECashFlowLockedToDate,
          RECashFlowPostingFromDate                                                                                              as RECashFlowPostingFromDate,
          REBusinessEntity                                                                                                       as REBusinessEntity,
          REPossessionStartDate                                                                                                  as REPossessionStartDate,
          REPossessionEndDate                                                                                                    as REPossessionEndDate,
          REHasMultipleAssignments                                                                                               as REHasMultipleAssignments,
          REObjectAvailableFromDate                                                                                              as REObjectAvailableFromDate,
          REObjectAvailableToDate                                                                                                as REObjectAvailableToDate,
          ValuationRelevance                                                                                                     as ValuationRelevance,
          _StatusObject.StatusProfile                                                                                            as StatusProfile,
          RealEstateObjectType                                                                                                   as RealEstateObjectType,
          _REContractType.REBusinessPartnerRole1                                                                                 as REBusinessPartnerRole1,

 //         cast ('' as receceactive ) as REContractIsRelevantForValn,

          case
            when _ValuationRules[1: 1 = 1].REValuationRuleIsActive is null then ''
            else _ValuationRules[1: 1 = 1].REValuationRuleIsActive
          end as REContractIsRelevantForValn,

//          _ValuationRules[1: 1 = 1].REValuationRuleIsActive                                                                      as REContractIsRelevantForValn,

          //          _REContractStat.REContractStatus                                     as REContractStatus,


          _REContractAddl,
          _CompanyCode,
          _MainContractCompanyCode,
          _StatusObject,
          _StatusObjectStatus,
          _REObjectType,
          _REAuthorizationGroup,
          _CreatedByUser,
          _ChangedByUser,
          _ResponsibleUser,
          _Currency,
          _REIndustry,
          _RECreationType,
          _REContractType,
          _RETenancyLaw,
          _REContractDepositType,
          _REContractNoticeReason,
          _REValuationRelevance,
          _REPartnerAssgmtTP,
          _REOrglAssgmtTermTP,
          _REPostingTermTP,
          _RERhythmTermTP,
          _REObjAssgmtTP,
          _RERenewalTermTP,
          _RERenewalTermAndRulesTP,
          _StatusProfileText,

          _RERenewalTP,
          _RENoticeTP,

          _RENoticeTermTP,
          _REConditionTP,
          _RENoticeTermForObjTP,
          _REAdjustmentTermTP,
          _REReminderRuleTP,
          _REReminderRuleMainTP,
          _REReminderDateTP,
          _REValuationTP,
          _REValuationConditionTP,
          _RESalesRuleTermTP,
          _RESalesReportingTermTP,
          _RESalesRuleFrqcyTermTP,
          _RERegistryEntryTP,
          _RENoticeTermAndRulesTP,
          _REValuationProcessStepTP,
          _REStatusObjectTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECONTRACT",
"I_RECONTRACTTYPE",
"I_STATUSOBJECT",
"P_REACTVLNFORCOCODECONTRTYPE"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CURRENCY",
"I_REAUTHORIZATIONGROUP",
"I_RECONTRACTADDL",
"I_RECONTRACTDEPOSITTYPE",
"I_RECONTRACTNOTICEREASON",
"I_RECONTRACTTYPE",
"I_RECREATIONTYPE",
"I_REINDUSTRY",
"I_REOBJECTTYPE",
"I_RETENANCYLAW",
"I_REVALUATIONRELEVANCE_2",
"I_STATUSOBJECT",
"I_STATUSOBJECTSTATUS",
"I_STATUSPROFILETEXT",
"I_USER",
"R_RECONTRACTNOTICETP",
"R_RECONTRACTRENEWALTP",
"R_RECONTRADJUSTMENTTERMTP",
"R_RECONTRCONDITIONTP",
"R_RECONTRNOTICETERMANDRULESTP",
"R_RECONTRNOTICETERMFOROBJTP",
"R_RECONTRNOTICETERMTP",
"R_RECONTROBJASSGMTTP",
"R_RECONTRORGLASSGMTTERMTP",
"R_RECONTRPARTASSGMTTP",
"R_RECONTRPOSTINGTERMTP",
"R_RECONTRREGISTRYENTRYTP",
"R_RECONTRREMINDERDATETP",
"R_RECONTRREMINDERRULEMAINTP",
"R_RECONTRREMINDERRULETP",
"R_RECONTRRENEWALTERMANDRULESTP",
"R_RECONTRRENEWALTERMTP",
"R_RECONTRRHYTHMTERMTP",
"R_RECONTRSALESREPORTINGTERMTP",
"R_RECONTRSALESRULEFRQCYTERMTP",
"R_RECONTRSALESRULETERMTP",
"R_RECONTRSTATUSOBJECTTP",
"R_RECONTRVALUATIONCONDITIONTP",
"R_RECONTRVALUATIONPROCSTEPTP",
"R_RECONTRVALUATIONTP"
],
"BASE":
[
"I_RECONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

R_REContractTP view_entity

I_REContract view

A_REContract view_entity
C_REContractTermTP view_entity
C_REContractTP view_entity
C_REValuationManageTP view_entity