I_UTILITIESINSTALLATIONHIST

CDS View
30 Fields 26 CDS Views

Installation History

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

CDS Views using this table (26)

ViewTypeJoinVDMDescription
/UCOM/I_UTILSINSTLN view_entity from COMPOSITE UTILITY INSTALLATION
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_UtilitiesInstallationHistDP view_entity from CONSUMPTION Data Provider for utils inst history
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
P_UtilsDeviceInfoRecordEntSrch view_entity inner COMPOSITE

Fields (30)

KeyField CDS FieldsUsed in Views
KEY UtilitiesInstallation UtilitiesInstallation 4
KEY UtilsInstHistValidityEndDate UtilsInstHistValidityEndDate 7
_MeterReadingUnit _MeterReadingUnit 3
_UtilitiesInstallation _UtilitiesInstallation 4
_UtilitiesRateCategory _UtilitiesRateCategory 11
_UtilsBillingClass _UtilsBillingClass 12
_UtilsDepdntValdtnGroup _UtilsDepdntValdtnGroup 3
_UtilsInstGroupRole _UtilsInstGroupRole 3
_UtilsInstGroupType _UtilsInstGroupType 3
_UtilsTemperatureArea _UtilsTemperatureArea 3
_UtilsUnbilldRevnXtrapltnType _UtilsUnbilldRevnXtrapltnType 3
HigherLevelUtilsInstallation HigherLevelUtilsInstallation 4
IndustrySector IndustrySector 3
MeterReadingUnit MeterReadingUnit 6
ObligatorySupUtilsSrvcProvider ObligatorySupUtilsSrvcProvider 4
PrimaryUtilitiesInstallation PrimaryUtilitiesInstallation 4
UnbilldRevnXtrapltnType UnbilldRevnXtrapltnType 4
UtilitiesBillingClass UtilitiesBillingClass 15
UtilitiesBillingParty UtilitiesBillingParty 4
UtilitiesBillingSchema UtilitiesBillingSchema 4
UtilitiesFranchiseContract UtilitiesFranchiseContract 4
UtilitiesInvoicingParty UtilitiesInvoicingParty 4
UtilitiesRateCategory UtilitiesRateCategory 19
UtilitiesTemperatureArea UtilitiesTemperatureArea 4
UtilsInstallationGroupRole UtilsInstallationGroupRole 4
UtilsInstallationGroupType UtilsInstallationGroupType 4
UtilsInstDvceAllctnIsNotAllwd UtilsInstDvceAllctnIsNotAllwd 4
UtilsInstHistValidityStartDate UtilsInstHistValidityStartDate 4
UtilsInstIsExmptFrmFrnchsFee UtilsInstIsExmptFrmFrnchsFee 4
UtilsRegDepdntValdtnGroup UtilsRegDepdntValdtnGroup 4

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