I_REContractValid

Valid Real Estate Contracts | view: IRECONTRACTVALID | TRAN | Extraction: Not supported | Component: Real Estate Contract
Column Name Description
CompanyCode FK Company Code
RealEstateContract Real Estate Contract
Column Name Description
Column Name Description
Column Name Description
CreationDate First Entered On
CreationTime Time of Creation
LastChangeDate Last Edited On
LastChangeTime Last Edited At
ContractStartDate Contract Start Date
ContractEndDate Contract End Date
REContractFirstEndDate Date of First Contract End
Column Name Description
IsActive Deletion Indicator Show values
IsDeleted Deletion Indicator Show values
Column Name Description Domain name
InternalRealEstateNumber Internal Key of Real Estate Object RECAINTRENO
ObjectInternalID Object Number J_OBJNR
CreatedByUser Entered By SYCHAR12
CreatedByUserDescription User Description SUIDTECHDESC
LastChangedByUser Employee ID SYCHAR12
LastChangedByUserDescription User Description SUIDTECHDESC
ResponsibleUserFullName User Description SUIDTECHDESC
REContractName Contract Name XTEXT80
REContractNumberOld Number of Old Contract VVOSMIVE
REMainContract Number of Real Estate Main Contract RECNNUMBER
REAuthorizationGroup Authorization Group RECAAUTHGRP
ValuationRelevance Valuation Relevance
ValuationRelevanceDesc Description for Valuation Relevance RECAXLDESCRIPTION
REIdentificationType null
REIdentificationKey ID Part Key, for example "1000/123" CHAR45
CompanyCodeName Name of Company Code or Company TEXT25
REContractTypeName Contract Type Name XMBEZ
REContractSystStatus Concatenated Contract System Status
REContractUserStatus Concatenated Contract User Status
REContractStatus null
Country Country/Region Key LAND1
CountryName Country/Region Name TEXT50
NumberOfREContracts null
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_RECONTRACTVALID.MANDT == T001.MANDT
  • I_RECONTRACTVALID.COMPANYCODE == T001.BUKRS
Contract Type
  • Client
  • Contract Type
  • I_RECONTRACTVALID.MANDT == TIV26.MANDT
  • I_RECONTRACTVALID.RECONTRACTTYPE == TIV26.SMVART
Company code of main contract
  • Company code of main contract
  • Client
  • I_RECONTRACTVALID.REMAINCONTRACTCOMPANYCODE == T001.BUKRS
  • I_RECONTRACTVALID.MANDT == T001.MANDT
Person Responsible
  • Client
  • Person Responsible
  • I_RECONTRACTVALID.MANDT == USR02.MANDT
  • I_RECONTRACTVALID.RESPONSIBLE == USR02.BNAME