_RECONTRACT

_RECONTRACT is an SAP database table in S/4HANA. It contains 26 fields.

Fields (26)

KeyField CDS FieldsUsed 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)
);