I_REContractData

DDL: I_RECONTRACTDATA SQL: IRECONTRACTB Type: view_entity COMPOSITE
82 Fields 1 Data Sources 1 Associations

Real Estate Contract

I_REContractData (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

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.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentRE-FX-CN
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Search
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

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 Internal Key of Real Estate Object
CompanyCode CompanyCode Receiver Company Code
RealEstateContract RealEstateContract Real Estate Contract
REStatusObject REStatusObject Val. Obj. No.
REInternalFinNumber REInternalFinNumber Internal Key of Real Estate Object (FI)
RECreationType RECreationType How the Object Was Created
CreatedByUser CreatedByUser Entered By
CreationDate CreationDate First Entered On
CreationTime CreationTime Time of Creation
RESourceOfCreation RESourceOfCreation Source of Initial Entry
LastChangedByUser LastChangedByUser Employee ID
LastChangeDate LastChangeDate Last Edited On
LastChangeTime LastChangeTime Last Edited At
RESourceOfChange RESourceOfChange Editing Source
Responsible Responsible Person Responsible
REUserExclusive REUserExclusive User with Exclusive Change Authorization
REAuthorizationGroup REAuthorizationGroup Authorization Group
REContractType REContractType Contract Type
ContractStartDate ContractStartDate Contract Start Date
ContractEndDate ContractEndDate Contract End Date
REContractName REContractName Contract Name
REContractActivateDate REContractActivateDate Active From
RETenancyLaw RETenancyLaw Tenancy Law
REContractNumberOld REContractNumberOld Number of Old Contract
REMainContractCompanyCode REMainContractCompanyCode Company code of main contract
REMainContract REMainContract Number of Real Estate Main Contract
REContractCurrency REContractCurrency Currency for Contract
REIndustrySector REIndustrySector Industry
REIsSalesRelevant REIsSalesRelevant Indicator: Relevant to Sales
REContractDepositType REContractDepositType Contract Security Deposit Type
REContractSignDate REContractSignDate Date of Contract Conclusion
REContract2SignDate REContract2SignDate Date of Second Signature
REContractCashFlowDate REContractCashFlowDate Cash Flow Generated Starting On
REContractFirstEndDate REContractFirstEndDate Date of First Contract End
REContractNoticeDate REContractNoticeDate Contract Notice Per
REContractNoticeInDate REContractNoticeInDate Date of receipt of notice
REContractNoticeReason REContractNoticeReason Reason for Notice
REContractNoticeActivationDate REContractNoticeActivationDate Notice: Date of Activation
RECashFlowArchivedToDate RECashFlowArchivedToDate Date Up to Which the Cash Flow Is Archived
RECashFlowLockedToDate RECashFlowLockedToDate Date Until Which the Cash Flow Is Locked
RECashFlowPostingFromDate RECashFlowPostingFromDate First Posting From
REBusinessEntity REBusinessEntity RE Business Entity
REObjectAvailableFromDate REObjectAvailableFromDate Transfer of Possession Start Date
REObjectAvailableToDate REObjectAvailableToDate Transfer of Possession End Date
REHasMultipleAssignments REHasMultipleAssignments Multiple Assignment of Object to Group Allowed
REPossessionStartDate REPossessionStartDate Date From Which the Object Is Made Available for Use
REPossessionEndDate REPossessionEndDate Date Up to Which the Object Is Used
ValuationRelevance ValuationRelevance Valuation Relevance
RealEstateObjectType RealEstateObjectType Object Type
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_REContractData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IRECONTRACTB

CREATE VIEW I_REContractData AS
SELECT
  InternalRealEstateNumber,
  CompanyCode,
  RealEstateContract,
  REStatusObject,
  REInternalFinNumber,
  RECreationType,
  CreatedByUser,
  CreationDate,
  CreationTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  RESourceOfChange,
  Responsible,
  REUserExclusive,
  REAuthorizationGroup,
  REContractType,
  ContractStartDate,
  ContractEndDate,
  REContractName,
  REContractActivateDate,
  RETenancyLaw,
  REContractNumberOld,
  REMainContractCompanyCode,
  REMainContract,
  REContractCurrency,
  REIndustrySector,
  REIsSalesRelevant,
  REContractDepositType,
  REContractSignDate,
  REContract2SignDate,
  REContractCashFlowDate,
  REContractFirstEndDate,
  REContractNoticeDate,
  REContractNoticeInDate,
  REContractNoticeReason,
  REContractNoticeActivationDate,
  RECashFlowArchivedToDate,
  RECashFlowLockedToDate,
  RECashFlowPostingFromDate,
  REBusinessEntity,
  REObjectAvailableFromDate,
  REObjectAvailableToDate,
  REHasMultipleAssignments,
  REPossessionStartDate,
  REPossessionEndDate,
  ValuationRelevance,
  RealEstateObjectType
FROM I_REContract
LEFT OUTER JOIN E_REContract AS _Extension ON InternalRealEstateNumber = _Extension.InternalRealEstateNumber  -- association [1..1]
;

Learn More