I_UTILITIESINSTALLATIONHIST

CDS View
30 Fields 23 CDS Views

Installation History

I_UTILITIESINSTALLATIONHIST is a CDS View in S/4HANA. Installation History. It contains 30 fields. 23 CDS views read from this table.

CDS Views using this table (23)

ViewTypeJoinVDMDescription
C_OutsrtdUtilsBillgMaLeApply view inner CONSUMPTION Machine Learning Apply Data for Outsorted Billing
C_OutsrtdUtilsBillgMaLeTrng view inner CONSUMPTION Machine Learning Training Data for Outsorted Billing
C_OutsrtdUtilsBillingDoc view inner CONSUMPTION Outsorted Utilities Billing Document
C_UtilsInstallationHistoryDEX view_entity from CONSUMPTION Data Extractor for Intstallation History
CRMS4_IU_I_ILNH view_entity from Utilities Installation History
I_ImplsblMtrRdngMaLrnApply view inner COMPOSITE Machine Learning Training for Implbl. Mtr. Rdng.
I_ImplsblMtrRdngMaLrnTrng view inner COMPOSITE Machine Learning Training Data for Implausible Meter Reading
I_MtrRdngUnitSchedRecdRlvt view inner COMPOSITE Relevant Meter Reading Unit Schedule Record
I_OpenUtilsBillgDocAndOrdData view inner COMPOSITE Open Utilities Billing Document and Order Data
I_SchedldRdngRelevantRegCube view inner COMPOSITE Scheduled Reading-Relevant Register Cube
I_SpprsdUtilsBillgOrdWthDets view inner COMPOSITE Suppressed Utilities Billing Order with Details
I_SuppressedUtilsBillgOrd view inner COMPOSITE Suppressed Utilities Billing Order
I_UtilitiesContractTP view_entity inner TRANSACTIONAL Utilities Contract
I_UtilsBillgDocOutsrtgChkGrp view inner COMPOSITE Outsorting Data with Current Outsorting Check Group
I_UtilsBillgDocPrevYrInvcgDoc view inner COMPOSITE Previous Year Invoicing Document for Billing Document
I_UtilsBillingOrder view inner COMPOSITE Utilities Billing Order
I_UtilsContractBlkdForBillg view inner COMPOSITE Contract Blocked For Billing
I_UtilsContractToBeBilled view inner COMPOSITE Contract To Be Billed
I_UtilsContrToBeBlldData view inner COMPOSITE Utilities Contract to Be Billed Data
I_UtilsInfoRecdHistAndInst view inner COMPOSITE Information Record History And Installation
I_UtilsInstdDvceAndInst view inner COMPOSITE Installed Device And Installation
I_UtilsInvcgDocBillingData view inner COMPOSITE Billing Data for Invoicing Document
P_ISU_EL_RATE_CATEGORY_VH_BR view from BASIC

Fields (30)

KeyField CDS FieldsUsed in Views
KEY UtilitiesInstallation UtilitiesInstallation 3
KEY UtilsInstHistValidityEndDate UtilsInstHistValidityEndDate 6
_MeterReadingUnit _MeterReadingUnit 2
_UtilitiesInstallation _UtilitiesInstallation 3
_UtilitiesRateCategory _UtilitiesRateCategory 10
_UtilsBillingClass _UtilsBillingClass 11
_UtilsDepdntValdtnGroup _UtilsDepdntValdtnGroup 2
_UtilsInstGroupRole _UtilsInstGroupRole 2
_UtilsInstGroupType _UtilsInstGroupType 2
_UtilsTemperatureArea _UtilsTemperatureArea 2
_UtilsUnbilldRevnXtrapltnType _UtilsUnbilldRevnXtrapltnType 2
HigherLevelUtilsInstallation HigherLevelUtilsInstallation 3
IndustrySector IndustrySector 2
MeterReadingUnit MeterReadingUnit 5
ObligatorySupUtilsSrvcProvider ObligatorySupUtilsSrvcProvider 3
PrimaryUtilitiesInstallation PrimaryUtilitiesInstallation 3
UnbilldRevnXtrapltnType UnbilldRevnXtrapltnType 3
UtilitiesBillingClass UtilitiesBillingClass 14
UtilitiesBillingParty UtilitiesBillingParty 3
UtilitiesBillingSchema UtilitiesBillingSchema 3
UtilitiesFranchiseContract UtilitiesFranchiseContract 3
UtilitiesInvoicingParty UtilitiesInvoicingParty 3
UtilitiesRateCategory UtilitiesRateCategory 18
UtilitiesTemperatureArea UtilitiesTemperatureArea 3
UtilsInstallationGroupRole UtilsInstallationGroupRole 3
UtilsInstallationGroupType UtilsInstallationGroupType 3
UtilsInstDvceAllctnIsNotAllwd UtilsInstDvceAllctnIsNotAllwd 3
UtilsInstHistValidityStartDate UtilsInstHistValidityStartDate 3
UtilsInstIsExmptFrmFrnchsFee UtilsInstIsExmptFrmFrnchsFee 3
UtilsRegDepdntValdtnGroup UtilsRegDepdntValdtnGroup 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.

-- Installation History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILITIESINSTALLATIONHIST (
    UTILITIESINSTALLATION,
    UTILSINSTHISTVALIDITYENDDATE,
    _METERREADINGUNIT,
    _UTILITIESINSTALLATION,
    _UTILITIESRATECATEGORY,
    _UTILSBILLINGCLASS,
    _UTILSDEPDNTVALDTNGROUP,
    _UTILSINSTGROUPROLE,
    _UTILSINSTGROUPTYPE,
    _UTILSTEMPERATUREAREA,
    _UTILSUNBILLDREVNXTRAPLTNTYPE,
    HIGHERLEVELUTILSINSTALLATION,
    INDUSTRYSECTOR,
    METERREADINGUNIT,
    OBLIGATORYSUPUTILSSRVCPROVIDER,
    PRIMARYUTILITIESINSTALLATION,
    UNBILLDREVNXTRAPLTNTYPE,
    UTILITIESBILLINGCLASS,
    UTILITIESBILLINGPARTY,
    UTILITIESBILLINGSCHEMA,
    UTILITIESFRANCHISECONTRACT,
    UTILITIESINVOICINGPARTY,
    UTILITIESRATECATEGORY,
    UTILITIESTEMPERATUREAREA,
    UTILSINSTALLATIONGROUPROLE,
    UTILSINSTALLATIONGROUPTYPE,
    UTILSINSTDVCEALLCTNISNOTALLWD,
    UTILSINSTHISTVALIDITYSTARTDATE,
    UTILSINSTISEXMPTFRMFRNCHSFEE,
    UTILSREGDEPDNTVALDTNGROUP,
    PRIMARY KEY (UTILITIESINSTALLATION, UTILSINSTHISTVALIDITYENDDATE)
);

Learn More