I_RETERM

CDS View

Real Estate Term

I_RETERM is a CDS View in S/4HANA. Real Estate Term. It contains 8 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_REAdjustmentTerm view from COMPOSITE Real Estate Adjustment Term
I_RENoticeTerm view from COMPOSITE Real Estate Notice Term
I_RERenewalTerm view from BASIC Real Estate Renewal Term
R_REContractRegulationTermTP view_entity from TRANSACTIONAL RE Contract Rgln Terms - TP
R_REContrNoticeTermTP view_entity from TRANSACTIONAL Real Estate Notice Term TP
R_REContrRenewalTermTP view_entity from TRANSACTIONAL Real Estate Renewal Term TP
R_REServiceGroupTermTP view_entity from TRANSACTIONAL RE Service Group Terms - TP

Fields (8)

KeyField CDS FieldsUsed in Views
KEY InternalRealEstateNumber InternalRealEstateNumber 2
KEY RETermNumber RETermNumber 2
KEY RETermType RETermType 2
_REKeyAssgmt _REKeyAssgmt 3
_REObjectType _REObjectType 5
_RETermType _RETermType 4
RealEstateObjectType RealEstateObjectType 4
RETermName RETermName 4

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 Term
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RETERM (
    INTERNALREALESTATENUMBER,
    RETERMNUMBER,
    RETERMTYPE,
    _REKEYASSGMT,
    _REOBJECTTYPE,
    _RETERMTYPE,
    REALESTATEOBJECTTYPE,
    RETERMNAME,
    PRIMARY KEY (INTERNALREALESTATENUMBER, RETERMNUMBER, RETERMTYPE)
);