CRMS4_IU_I_ILNH

DDL: CRMS4_IU_I_ILNH Type: view_entity
30 Fields 1 Data Sources

Utilities Installation History

CRMS4_IU_I_ILNH is a CDS View that provides data about "Utilities Installation History" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesInstallationHist) and exposes 30 fields with key fields UtilitiesInstallation, UtilsInstHistValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_UtilitiesInstallationHist I_UtilitiesInstallationHist from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Utilities Installation History view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesInstallation UtilitiesInstallation Installation
KEY UtilsInstHistValidityEndDate UtilsInstHistValidityEndDate
UtilsInstHistValidityStartDate UtilsInstHistValidityStartDate
UtilitiesRateCategory UtilitiesRateCategory Rate category
UtilitiesBillingSchema UtilitiesBillingSchema Billing schema
UtilitiesBillingClass UtilitiesBillingClass Billing Class
MeterReadingUnit MeterReadingUnit MR unit
UtilitiesTemperatureArea UtilitiesTemperatureArea Temp. area
UtilsInstIsExmptFrmFrnchsFee UtilsInstIsExmptFrmFrnchsFee No franch. fee
UtilsInstDvceAllctnIsNotAllwd UtilsInstDvceAllctnIsNotAllwd No dev. alloc.
UtilitiesFranchiseContract UtilitiesFranchiseContract Franchise cont.
UtilitiesBillingParty UtilitiesBillingParty Billing ServPr.
UtilitiesInvoicingParty UtilitiesInvoicingParty Supplier
ObligatorySupUtilsSrvcProvider ObligatorySupUtilsSrvcProvider Supply Obligatn
PrimaryUtilitiesInstallation PrimaryUtilitiesInstallation Primary Inst.
UtilsInstallationGroupRole UtilsInstallationGroupRole Installtn Role
UtilsInstallationGroupType UtilsInstallationGroupType Grouping Type
HigherLevelUtilsInstallation HigherLevelUtilsInstallation High.-Level Installn
UnbilldRevnXtrapltnType UnbilldRevnXtrapltnType Extrapol. type
UtilsRegDepdntValdtnGroup UtilsRegDepdntValdtnGroup ValGrp dep.vals
IndustrySector IndustrySector Industry
_MeterReadingUnit _MeterReadingUnit
_UtilitiesInstallation _UtilitiesInstallation
_UtilitiesRateCategory _UtilitiesRateCategory
_UtilsBillingClass _UtilsBillingClass
_UtilsDepdntValdtnGroup _UtilsDepdntValdtnGroup
_UtilsInstGroupRole _UtilsInstGroupRole
_UtilsInstGroupType _UtilsInstGroupType
_UtilsTemperatureArea _UtilsTemperatureArea
_UtilsUnbilldRevnXtrapltnType _UtilsUnbilldRevnXtrapltnType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view CRMS4_IU_I_ILNH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW CRMS4_IU_I_ILNH AS
SELECT
  UtilitiesInstallation,
  UtilsInstHistValidityEndDate,
  UtilsInstHistValidityStartDate,
  UtilitiesRateCategory,
  UtilitiesBillingSchema,
  UtilitiesBillingClass,
  MeterReadingUnit,
  UtilitiesTemperatureArea,
  UtilsInstIsExmptFrmFrnchsFee,
  UtilsInstDvceAllctnIsNotAllwd,
  UtilitiesFranchiseContract,
  UtilitiesBillingParty,
  UtilitiesInvoicingParty,
  ObligatorySupUtilsSrvcProvider,
  PrimaryUtilitiesInstallation,
  UtilsInstallationGroupRole,
  UtilsInstallationGroupType,
  HigherLevelUtilsInstallation,
  UnbilldRevnXtrapltnType,
  UtilsRegDepdntValdtnGroup,
  IndustrySector
FROM I_UtilitiesInstallationHist
;

Learn More