_CONTRACT

31 Fields

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

Fields (31)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 4
KEY InternalRealEstateNumber InternalRealEstateNumber 3
KEY RealEstateContract RealEstateContract 3
_AccountingPrinciple _AccountingPrinciple 1
_BusinessPartner _BusinessPartner 1
_CompanyCode _CompanyCode 1
AccountingPrinciple AccountingPrinciple 1
AuthorizationGroup AuthorizationGroup 1
BusinessPartner BusinessPartner 3
Customer Customer 2
ExternalContractDate ExternalContractDate 1
ExternalContractNumber ExternalContractNumber 1
FirstName FirstName 1
HCMCountryRegionGrouping HCMCountryRegionGrouping 1
HCMIsMainPersonWorkAgreement HCMIsMainPersonWorkAgreement 1
InsurancePolicyContract InsurancePolicyContract 1
InsurClmAuthznGrp InsurClmAuthznGrp 1
InsurClmType InsurClmType 1
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 4
LastName LastName 1
ObjectInternalID StatusObject 1
RAContrHasMnlPrcAllocConflict RAContrHasMnlPrcAllocConflict 1
REAuthorizationGroup REAuthorizationGroup 3
REContractType REContractType 3
REStatusObject REStatusObject 1
RevenueAccountingContract RevenueAccountingContract 1
RevnAcctgContractDescription RevnAcctgContractDescription 1
RevnAcctgContractStatus RevnAcctgContractStatus 3
SalesDocumentCurrency SalesDocumentCurrency 2
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,
    ACCOUNTINGPRINCIPLE,
    AUTHORIZATIONGROUP,
    BUSINESSPARTNER,
    CUSTOMER,
    EXTERNALCONTRACTDATE,
    EXTERNALCONTRACTNUMBER,
    FIRSTNAME,
    HCMCOUNTRYREGIONGROUPING,
    HCMISMAINPERSONWORKAGREEMENT,
    INSURANCEPOLICYCONTRACT,
    INSURCLMAUTHZNGRP,
    INSURCLMTYPE,
    ISBUSINESSPURPOSECOMPLETED,
    LASTNAME,
    OBJECTINTERNALID,
    RACONTRHASMNLPRCALLOCCONFLICT,
    REAUTHORIZATIONGROUP,
    RECONTRACTTYPE,
    RESTATUSOBJECT,
    REVENUEACCOUNTINGCONTRACT,
    REVNACCTGCONTRACTDESCRIPTION,
    REVNACCTGCONTRACTSTATUS,
    SALESDOCUMENTCURRENCY,
    TOTALSRVCCONTRVALUEINDC,
    VALUATIONRELEVANCE,
    PRIMARY KEY (COMPANYCODE, INTERNALREALESTATENUMBER, REALESTATECONTRACT)
);

Learn More