I_UTILITIESCONTRACTHISTORY

CDS View
12 Fields 6 CDS Views

Utilities Contract History

I_UTILITIESCONTRACTHISTORY is a CDS View in S/4HANA. Utilities Contract History. It contains 12 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_UtilsContractHistoryDEX view_entity from CONSUMPTION Data Extractor for Contract History
I_LtstUtilsValdtyDateForContr view from COMPOSITE Latest Utilities Validity Date For Contract
I_UtilsContractKeyDateAnalysis view inner COMPOSITE Key Date-Based Utilities Contract Analysis
I_UtilsContractKeyDateAnalysis view left_outer COMPOSITE Key Date-Based Utilities Contract Analysis
I_UtilsContractProductChanges view left_outer COMPOSITE Utilities Contract Product Changes
I_UtilsContrNextValidityPeriod view from COMPOSITE Next Validity Period for Utilities Contract

Fields (12)

KeyField CDS FieldsUsed in Views
KEY UtilitiesContract UtilitiesContract 2
KEY UtilitiesFourDigitNumber UtilitiesFourDigitNumber 2
KEY UtilsContractValidityEndDate UtilsContractValidityEndDate 1
_UtilitiesContract _UtilitiesContract 3
_UtilsContrHistFourDigitNmbr _UtilsContrHistFourDigitNmbr 1
DeletionIndicator DeletionIndicator 1
UtilitiesProduct UtilitiesProduct 2
UtilsContractValidityStartDate UtilsContractValidityStartDate 1
UtilsItemNumberInCRMDocument UtilsItemNumberInCRMDocument 1
UtilsMarketingCampaignEndDate UtilsMarketingCampaignEndDate 1
UtilsMstrAgrmtForIndivContract UtilsMstrAgrmtForIndivContract 1
UtilsTransNumberInCRMDocument UtilsTransNumberInCRMDocument 1

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.

-- Utilities Contract History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILITIESCONTRACTHISTORY (
    UTILITIESCONTRACT,
    UTILITIESFOURDIGITNUMBER,
    UTILSCONTRACTVALIDITYENDDATE,
    _UTILITIESCONTRACT,
    _UTILSCONTRHISTFOURDIGITNMBR,
    DELETIONINDICATOR,
    UTILITIESPRODUCT,
    UTILSCONTRACTVALIDITYSTARTDATE,
    UTILSITEMNUMBERINCRMDOCUMENT,
    UTILSMARKETINGCAMPAIGNENDDATE,
    UTILSMSTRAGRMTFORINDIVCONTRACT,
    UTILSTRANSNUMBERINCRMDOCUMENT,
    PRIMARY KEY (UTILITIESCONTRACT, UTILITIESFOURDIGITNUMBER, UTILSCONTRACTVALIDITYENDDATE)
);

Learn More