Fields (26)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CompanyCode | CompanyCode,REContractCompanyCode | 16 |
| KEY | RealEstateContract | RealEstateContract | 13 |
| _CompanyCode | _CompanyCode | 7 | |
| _MainContractCompanyCode | _MainContractCompanyCode | 1 | |
| _REContractType | _REContractType | 2 | |
| _StatusObject | _StatusObject | 1 | |
| ContractEndDate | ContractEndDate | 3 | |
| ContractStartDate | ContractStartDate | 3 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangeTime | LastChangeTime | 1 | |
| RealEstateContractOID | RealEstateContractOID | 2 | |
| RealEstateObjectType | RealEstateObjectType | 3 | |
| REAuthorizationGroup | REAuthorizationGroup | 3 | |
| REBusinessPartnerRole1 | REBusinessPartnerRole1 | 1 | |
| REContractCashFlowDate | REContractCashFlowDate | 1 | |
| REContractName | REContractName | 15 | |
| REContractNoticeDate | REContractNoticeDate | 1 | |
| REContractNumberOld | REContractNumberOld | 1 | |
| REContractType | REContractType | 19 | |
| REIdentificationKey | REIdentificationKey | 11 | |
| REIndustrySector | REIndustrySector | 1 | |
| REIsSalesRelevant | REIsSalesRelevant | 1 | |
| REMainContract | REMainContract | 1 | |
| REMainContractCompanyCode | REMainContractCompanyCode | 1 | |
| Responsible | Responsible | 2 | |
| REStatusObject | REStatusObject | 11 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _RECONTRACT (
COMPANYCODE,
REALESTATECONTRACT,
_COMPANYCODE,
_MAINCONTRACTCOMPANYCODE,
_RECONTRACTTYPE,
_STATUSOBJECT,
CONTRACTENDDATE,
CONTRACTSTARTDATE,
LASTCHANGEDATE,
LASTCHANGETIME,
REALESTATECONTRACTOID,
REALESTATEOBJECTTYPE,
REAUTHORIZATIONGROUP,
REBUSINESSPARTNERROLE1,
RECONTRACTCASHFLOWDATE,
RECONTRACTNAME,
RECONTRACTNOTICEDATE,
RECONTRACTNUMBEROLD,
RECONTRACTTYPE,
REIDENTIFICATIONKEY,
REINDUSTRYSECTOR,
REISSALESRELEVANT,
REMAINCONTRACT,
REMAINCONTRACTCOMPANYCODE,
RESPONSIBLE,
RESTATUSOBJECT,
PRIMARY KEY (COMPANYCODE, REALESTATECONTRACT)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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