I_REContractData

DDL: I_RECONTRACTDATA SQL: IRECONTRACTB Type: view_entity COMPOSITE

Real Estate Contract

I_REContractData is a Composite CDS View that provides data about "Real Estate Contract" in SAP S/4HANA. It reads from 1 data source (I_REContract) and exposes 82 fields with key field InternalRealEstateNumber. It has 1 association to related views.

1 data source(s) 82 fields

Data Sources (1)

SourceAliasJoin Type
I_REContract I_REContract from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_REContract _Extension $projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber

Annotations (11)

NameValueLevelField
EndUserText.label Real Estate Contract view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey InternalRealEstateNumber view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
Metadata.allowExtensions true view
VDM.viewType #COMPOSITE view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber
CompanyCode CompanyCode
RealEstateContract RealEstateContract
REStatusObject REStatusObject
REInternalFinNumber REInternalFinNumber
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
REObjectAvailableFromDate REObjectAvailableFromDate
REObjectAvailableToDate REObjectAvailableToDate
REHasMultipleAssignments REHasMultipleAssignments
REPossessionStartDate REPossessionStartDate
REPossessionEndDate REPossessionEndDate
ValuationRelevance ValuationRelevance
RealEstateObjectType RealEstateObjectType
_CompanyCode _CompanyCode
_MainContractCompanyCode _MainContractCompanyCode
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_ResponsibleUser _ResponsibleUser
_Currency _Currency
_REIndustry _REIndustry
_RECreationType _RECreationType
_REContractType _REContractType
_RETenancyLaw _RETenancyLaw
_REContractDepositType _REContractDepositType
_REContractNoticeReason _REContractNoticeReason
_REAuthorizationGroup _REAuthorizationGroup
_REValuationRelevance _REValuationRelevance
_REKeyAssgmt _REKeyAssgmt
_StatusObject _StatusObject
_StatusObjectStatus _StatusObjectStatus
_REObjectType _REObjectType
_REPartnerAssgmt _REPartnerAssgmt
_REObjectAssgmt _REObjectAssgmt
_RERenewalTerm _RERenewalTerm
_RENoticeTerm _RENoticeTerm
_REOrganizationalAssgmtTerm _REOrganizationalAssgmtTerm
_REPostingTerm _REPostingTerm
_RERhythmTerm _RERhythmTerm
_RECondition _RECondition
_REReminderRule _REReminderRule
_REValuationTerm _REValuationTerm
_REValuationRuleCondition _REValuationRuleCondition
_REAdjustmentTerm _REAdjustmentTerm
_RESalesRuleTerm _RESalesRuleTerm
_RESalesReportingTerm _RESalesReportingTerm
_RESalesRuleFrqcyTerm _RESalesRuleFrqcyTerm 
//@AbapCatalog.sqlViewName: 'IRECONTRACTB'

@EndUserText.label: 'Real Estate Contract'
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: ['_REPartnerAssgmt._BusinessPartner.IsBusinessPurposeCompleted']
@AccessControl.privilegedAssociations: ['_StatusObject', '_StatusObjectStatus']

@ObjectModel.representativeKey: 'InternalRealEstateNumber'
@ObjectModel.semanticKey: ['CompanyCode', 'RealEstateContract']
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities:  [  #ANALYTICAL_DIMENSION,
                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #SQL_DATA_SOURCE,
//                                        #ANALYTICAL_PROVIDER,

                                        #CDS_MODELING_DATA_SOURCE,
//                                        #EXTRACTION_DATA_SOURCE,

                                        #SEARCHABLE_ENTITY      ]

@Metadata.allowExtensions: true
@VDM.viewType: #COMPOSITE

define view entity I_REContractData
  as select from I_REContract
  //  Extensibility

  association [1..1] to E_REContract                 as _Extension                  on  $projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber
{
  key InternalRealEstateNumber,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      CompanyCode,
      RealEstateContract,
      @ObjectModel.foreignKey.association: '_StatusObject'
      REStatusObject,
      REInternalFinNumber,
      @ObjectModel.foreignKey.association: '_RECreationType'
      RECreationType,
      @ObjectModel.foreignKey.association: '_CreatedByUser'
      CreatedByUser,
      CreationDate,
      CreationTime,
      RESourceOfCreation,
      @ObjectModel.foreignKey.association: '_ChangedByUser'
      LastChangedByUser,
      LastChangeDate,
      LastChangeTime,
      RESourceOfChange,
      @ObjectModel.foreignKey.association: '_ResponsibleUser'
      Responsible,
      REUserExclusive,
      @ObjectModel.foreignKey.association: '_REAuthorizationGroup'
      REAuthorizationGroup,
      @ObjectModel.foreignKey.association: '_REContractType'
      REContractType,
      ContractStartDate,
      @EndUserText.quickInfo: 'End of Term'
      ContractEndDate,
      REContractName,
      REContractActivateDate,
      @ObjectModel.foreignKey.association: '_RETenancyLaw'
      RETenancyLaw,
      REContractNumberOld,
      @ObjectModel.foreignKey.association: '_MainContractCompanyCode'
      REMainContractCompanyCode,
      REMainContract,
      @ObjectModel.foreignKey.association: '_Currency'
      REContractCurrency,
      @ObjectModel.foreignKey.association: '_REIndustry'
      REIndustrySector,
      REIsSalesRelevant,
      @ObjectModel.foreignKey.association: '_REContractDepositType'
      REContractDepositType,
      REContractSignDate,
      REContract2SignDate,
      REContractCashFlowDate,
      REContractFirstEndDate,
      REContractNoticeDate,
      REContractNoticeInDate,
      @ObjectModel.foreignKey.association: '_REContractNoticeReason'
      REContractNoticeReason,
      REContractNoticeActivationDate,
      RECashFlowArchivedToDate,
      RECashFlowLockedToDate,
      RECashFlowPostingFromDate,
      REBusinessEntity,
      REObjectAvailableFromDate,
      REObjectAvailableToDate,
      REHasMultipleAssignments,
      REPossessionStartDate,
      REPossessionEndDate,
      @ObjectModel.foreignKey.association: '_REValuationRelevance'
      ValuationRelevance,
      @ObjectModel.foreignKey.association: '_REObjectType'
      RealEstateObjectType,
//      REIdentificationKey,

//      REBusinessPartnerRole1,


      _CompanyCode,
      _MainContractCompanyCode,
      _CreatedByUser,
      _ChangedByUser,
      _ResponsibleUser,
      _Currency,
      _REIndustry,
      _RECreationType,
      _REContractType,
      _RETenancyLaw,
      _REContractDepositType,
      _REContractNoticeReason,
      _REAuthorizationGroup,
      _REValuationRelevance,
      _REKeyAssgmt,
      _StatusObject,
      _StatusObjectStatus,
      _REObjectType,
//      _Extension,


      _REPartnerAssgmt,
      _REObjectAssgmt,
      _RERenewalTerm,
      _RENoticeTerm,
      _REOrganizationalAssgmtTerm,
      _REPostingTerm,
      _RERhythmTerm,
      _RECondition,
      _REReminderRule,
      _REValuationTerm,
      _REValuationRuleCondition,
      _REAdjustmentTerm,
      _RESalesRuleTerm,
      _RESalesReportingTerm,
      _RESalesRuleFrqcyTerm

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RECONTRACT"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CURRENCY",
"I_READJUSTMENTTERM",
"I_REAUTHORIZATIONGROUP",
"I_RECONDITION",
"I_RECONTRACTDEPOSITTYPE",
"I_RECONTRACTNOTICEREASON",
"I_RECONTRACTTYPE",
"I_RECREATIONTYPE",
"I_REINDUSTRY",
"I_REKEYASSGMT",
"I_RENOTICETERM",
"I_REOBJECTASSGMT",
"I_REOBJECTTYPE",
"I_REORGANIZATIONALASSGMTTERM",
"I_REPARTNERASSGMT",
"I_REPOSTINGTERM",
"I_REREMINDEROBJRULE",
"I_RERENEWALTERM",
"I_RERHYTHMTERM",
"I_RESALESREPORTINGTERM",
"I_RESALESRULEFREQUENCYTERM",
"I_RESALESRULETERM",
"I_RETENANCYLAW",
"I_REVALUATIONRELEVANCE_2",
"I_REVALUATIONRULECONDITION",
"I_REVALUATIONTERM",
"I_STATUSOBJECT",
"I_STATUSOBJECTSTATUS",
"I_USER"
],
"BASE":
[
"I_RECONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More