- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_REContractValidQ
Valid Real Estate Contracts Query
| view: CRECONTRACTVALQ
| Extraction:
Not supported
| Component: Real Estate Contract
Tables used:
JEST, T001, TKA02, T005, T005T, VICNCN, TIV26, TIV2F, VICAINTRENO, TIVCERELEVALT, USR21, TIVCNCCTADD
- 🔑 Keys
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (7)
- ☰ Categorical (2)
- Other (23)
- 🔗 Relations (4)
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| ContractStartDate | Contract Start Date | |
| ContractEndDate | Contract End Date | |
| CreationDate | First Entered On | |
| CreationTime | Time of Creation | |
| LastChangeDate | Last Edited On | |
| LastChangeTime | Last Edited At | |
| REContractFirstEndDate | Date of First Contract End |
| Column Name | Description | |
|---|---|---|
| IsActive | Deletion Indicator | Show values |
| IsDeleted | Deletion Indicator | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| RealEstateContract | Real Estate Contract | RECNVDMCNNR | |
| 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 | |
| NumberOfREContracts | null |
| Master Data Relations | Join Conditions |
|---|---|
Company Code
| |
Contract Type
| |
Company code of main contract
| |
Person Responsible
|