_CONTRACT

22 Fields

_CONTRACT is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 3
KEY InternalRealEstateNumber InternalRealEstateNumber 3
KEY RealEstateContract RealEstateContract 3
_AccountingPrinciple _AccountingPrinciple 1
_BusinessPartner _BusinessPartner 1
_CompanyCode _CompanyCode 1
AuthorizationGroup AuthorizationGroup 1
ExternalContractDate ExternalContractDate 1
ExternalContractNumber ExternalContractNumber 1
FirstName FirstName 1
InsurClmAuthznGrp InsurClmAuthznGrp 1
InsurClmType InsurClmType 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 1
LastName LastName 1
ObjectInternalID StatusObject 1
RAContractIsUniversal RAContractIsUniversal 1
RAContrHasMnlPrcAllocConflict RAContrHasMnlPrcAllocConflict 1
REAuthorizationGroup REAuthorizationGroup 3
REContractType REContractType 3
REStatusObject REStatusObject 1
TotalSrvcContrValueInDC TotalSrvcContrValueInDC 1
ValuationRelevance ValuationRelevance 3

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 _CONTRACT (
    COMPANYCODE,
    INTERNALREALESTATENUMBER,
    REALESTATECONTRACT,
    _ACCOUNTINGPRINCIPLE,
    _BUSINESSPARTNER,
    _COMPANYCODE,
    AUTHORIZATIONGROUP,
    EXTERNALCONTRACTDATE,
    EXTERNALCONTRACTNUMBER,
    FIRSTNAME,
    INSURCLMAUTHZNGRP,
    INSURCLMTYPE,
    ISBUSINESSPURPOSECOMPLETED,
    LASTNAME,
    OBJECTINTERNALID,
    RACONTRACTISUNIVERSAL,
    RACONTRHASMNLPRCALLOCCONFLICT,
    REAUTHORIZATIONGROUP,
    RECONTRACTTYPE,
    RESTATUSOBJECT,
    TOTALSRVCCONTRVALUEINDC,
    VALUATIONRELEVANCE,
    PRIMARY KEY (COMPANYCODE, INTERNALREALESTATENUMBER, REALESTATECONTRACT)
);

Learn More