I_RECONTRACT
Real Estate Contract
I_RECONTRACT is a CDS View in S/4HANA. Real Estate Contract. It contains 18 fields. 23 CDS views read from this table.
CDS Views using this table (23)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_REContractDEX | view_entity | from | CONSUMPTION | Extraction for REContract |
| C_REContractMgmtApp | view | from | CONSUMPTION | Manage Lease Contract |
| C_REGeneralLetterEDP | view_entity | from | CONSUMPTION | RE General Letter Email Determination |
| C_REOutpReqContract | view_entity | from | CONSUMPTION | Real Estate Contract for Output Request |
| C_REOutputParamDetn520 | view | inner | CONSUMPTION | RE OM Parameter Determination A520 |
| C_REOutputParamDetnContr | view | from | CONSUMPTION | RE OM Parameter Determination -Contract- |
| ESH_N_RECONTRACT | view | from | Anchor view -RECONTRACT | |
| I_REContractAddl | view | from | COMPOSITE | RE Contract additional |
| I_REContractAssignSubject | view | from | COMPOSITE | Real Estate Contract Subject Assignments |
| I_REContractAssignSubjectC_2 | view | from | COMPOSITE | Real Estate Contract Subject Assignments |
| I_REContractCheckTable | view | from | BASIC | Real Estate Contract Check Table |
| I_REContractData | view_entity | from | COMPOSITE | Real Estate Contract |
| I_REContractStatusObject | view | from | COMPOSITE | Real Estate Contract Status |
| I_REContractValid | view | from | COMPOSITE | Valid Real Estate Contracts |
| I_REContractVH | view | from | COMPOSITE | Real Estate Contract Value Help |
| I_RERntblObjToContractAssgmt | view_entity | inner | COMPOSITE | RE Rentable Object Contract Assignment |
| P_FuncnlAreaClmContr | view | from | COMPOSITE | WUFAREA Lease Contract |
| P_FundCLMContr | view | from | COMPOSITE | WUFUND Lease Contract |
| P_GrantClmContr | view | from | COMPOSITE | WUGRANT Lease Contract |
| P_IntOrdSettlmtDistrRuleRE | view_entity | union | COMPOSITE | Settlement Distribution Rule Real Estate |
| P_ProjSettlmtRuleDistrRuleRE | view_entity | union | COMPOSITE | Real Estate Object for Distribution Rule |
| P_REIntegObjectOccpcyCalc1 | view | inner | COMPOSITE | Real Estate Integ Occpy Calc 1 |
| R_REContractTP | view_entity | from | TRANSACTIONAL | Real Estate Contract TP |
Fields (18)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode | 6 |
| KEY | InternalRealEstateNumber | InternalRealEstateNumber,REContractInternalNumber | 8 |
| KEY | RealEstateContract | RealEstateContract | 8 |
| KEY | REStatusObject | ObjectInternalID,REContractStatusObject,REStatusObject,StatusObject | 8 |
| _CompanyCode | _CompanyCode | 1 | |
| _REPartnerAssgmt | _REPartnerAssgmt | 3 | |
| ContractEndDate | ContractEndDate,ValidityEndDate | 6 | |
| ContractStartDate | ContractStartDate,ValidityStartDate | 6 | |
| CreatedByUser | CreatedByUser | 3 | |
| CreationDate | CreationDate | 3 | |
| LastChangeDate | LastChangeDate | 3 | |
| LastChangedByUser | LastChangedByUser | 3 | |
| REAuthorizationGroup | REAuthorizationGroup | 5 | |
| REContractName | REContractName | 5 | |
| REContractNumberOld | REContractNumberOld | 2 | |
| REContractType | REContractType | 5 | |
| REPossessionEndDate | REPossessionEndDate | 1 | |
| REPossessionStartDate | REPossessionStartDate | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Real Estate Contract
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RECONTRACT (
COMPANYCODE,
INTERNALREALESTATENUMBER,
REALESTATECONTRACT,
RESTATUSOBJECT,
_COMPANYCODE,
_REPARTNERASSGMT,
CONTRACTENDDATE,
CONTRACTSTARTDATE,
CREATEDBYUSER,
CREATIONDATE,
LASTCHANGEDATE,
LASTCHANGEDBYUSER,
REAUTHORIZATIONGROUP,
RECONTRACTNAME,
RECONTRACTNUMBEROLD,
RECONTRACTTYPE,
REPOSSESSIONENDDATE,
REPOSSESSIONSTARTDATE,
PRIMARY KEY (COMPANYCODE, INTERNALREALESTATENUMBER, REALESTATECONTRACT, RESTATUSOBJECT)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA