C_UtilsContractHistoryDEX

DDL: C_UTILSCONTRACTHISTORYDEX Type: view_entity CONSUMPTION
40 Fields 1 Data Sources

Data Extractor for Contract History

C_UtilsContractHistoryDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Utilities Contract · Utilities

C_UtilsContractHistoryDEX is a Consumption CDS View (Fact) that provides data about "Data Extractor for Contract History" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesContractHistory) and exposes 40 fields with key fields UtilitiesContract, UtilsContractValidityEndDate, UtilitiesFourDigitNumber.

SAP Help Documentation

CategoryContract
Data CategoryFact
StatusC1
Corresponding DataSource2CCUTILCONTRHISTDEX
Purpose
This CDS view provides information about the connection between the IS-U contract and the historical data of an IS-U contract and allows data extraction to the SAP Business Warehouse (SAP BW). In addition, this CDS view can directly be used as a data source in the SAP Data Sphere or SAP Analytics Cloud (SAC) .

SAP Business Warehouse (SAP BW) Extraction
Data extraction type Delta-enabled with Change Data Capture (CDC) Corresponding DataSource (Extractor) Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. In case you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content .

Prerequisites
Authorizations The following authorization objects are required to use this CDS view: E_CONTRACT (Authorization to display utilities contract data )

Structure
Important fields in this view include the following: Field Name Description UtilitiesContract Contract AlternativeUtilitiesPortion Alternative Portion UtilsBillgBlockReason Billing Block Reason UtilitiesInstallation Installation UtilitiesDivision Division ContractAccount Contract Account

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessUtilities
Application ComponentIS-U-MD
CapabilitiesData Source for Data Extraction
PackageUtilities for SAP S/4HANA

Documentation

Data Sources (1)

SourceAliasJoin Type
I_UtilitiesContractHistory I_UtilitiesContractHistory from

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Data Extractor for Contract History view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.modelingPattern #NONE view
ObjectModel.sapObjectNodeType.name UtilitiesContract view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.dataCategory #FACT view
Analytics.technicalName CUTILCONTRHISTDEX view
Analytics.dataExtraction.enabled true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_UtilitiesContractHistory UtilitiesContract PoD service
KEY UtilsContractValidityEndDate I_UtilitiesContractHistory UtilsContractValidityEndDate Date at Which a Time Slice Expires
KEY UtilitiesFourDigitNumber I_UtilitiesContractHistory UtilitiesFourDigitNumber Four-digit number
UtilsContractValidityStartDate I_UtilitiesContractHistory UtilsContractValidityStartDate Date from which time slice is valid
UtilitiesProduct I_UtilitiesContractHistory UtilitiesProduct CRM Product
UtilsTransNumberInCRMDocument I_UtilitiesContractHistory UtilsTransNumberInCRMDocument Transaction Number in CRM Document
UtilsItemNumberInCRMDocument I_UtilitiesContractHistory UtilsItemNumberInCRMDocument Item Number in CRM Document
UtilsMarketingCampaignEndDate I_UtilitiesContractHistory UtilsMarketingCampaignEndDate IS-U: Individual To-Date Campaign Analysis
DeletionIndicator I_UtilitiesContractHistory DeletionIndicator Deletion Indicator
UtilsMstrAgrmtForIndivContract I_UtilitiesContractHistory UtilsMstrAgrmtForIndivContract Master Agreement for Individual Contract
CompanyCode I_UtilitiesContract CompanyCode Receiver Company Code
UtilitiesDivision I_UtilitiesContract UtilitiesDivision Division
AlternativeUtilitiesPortion I_UtilitiesContract AlternativeUtilitiesPortion Alternative portion
UtilsContrIsBilledManually I_UtilitiesContract UtilsContrIsBilledManually Contract Is Billed Manually
UtilsBillgBlockReason I_UtilitiesContract UtilsBillgBlockReason Billing Block Reason
UtilsBillgUnblockReason I_UtilitiesContract UtilsBillgUnblockReason Release Reason
UtilitiesInstallation I_UtilitiesContract UtilitiesInstallation Installation
ContractAccount I_UtilitiesContract ContractAccount Contract Account Number
UtilitiesMoveInDate I_UtilitiesContract UtilitiesMoveInDate Move-In
UtilitiesMoveOutDate I_UtilitiesContract UtilitiesMoveOutDate Move-Out
UtilsContractCreationDate I_UtilitiesContract UtilsContractCreationDate Record Created On
UtilsContractCreatedByUser I_UtilitiesContract UtilsContractCreatedByUser Name of Person Responsible for Creating the Object
UtilsContractLastChangeDate I_UtilitiesContract UtilsContractLastChangeDate Last Changed On
UtilsContractLastChangedByUser I_UtilitiesContract UtilsContractLastChangedByUser Name of Person Who Changed Object
UtilsContrIsFinallyBilled I_UtilitiesContract UtilsContrIsFinallyBilled Contract Terminated for Billing Reasons
UtilsPlantOrCompanyConsumption I_UtilitiesContract UtilsPlantOrCompanyConsumption Plant or company consumption
UtilsContrJointInvcType I_UtilitiesContract UtilsContrJointInvcType Invoice Contracts Jointly
UtilitiesContractCanclnDate I_UtilitiesContract UtilitiesContractCanclnDate Cancellation date of contract
UtilitiesContractRenewalDate I_UtilitiesContract UtilitiesContractRenewalDate Renewal date of contract
CADunningProcedure I_UtilitiesContract CADunningProcedure Dunning Procedure
UtilitiesServiceProvider I_UtilitiesContract UtilitiesServiceProvider Service Provider
UtilsContractProcessingSts I_UtilitiesContract UtilsContractProcessingSts Processing Status
AuthorizationGroup I_UtilitiesContract AuthorizationGroup Authorization Group
UtilsOutsrtgCheckGrpForBillg I_UtilitiesContract UtilsOutsrtgCheckGrpForBillg Outsorting check group for billing
UtilitiesContractDescription I_UtilitiesContract UtilitiesContractDescription Contract Description
UtilitiesAccountDetnCode I_UtilitiesContract UtilitiesAccountDetnCode Account Determination Code
UtilsContrSpcfcBdgtBillgCycle I_UtilitiesContract UtilsContrSpcfcBdgtBillgCycle Overriding Budget Billing Cycle
UtilsBillgOutsortingReason I_UtilitiesContract UtilsBillgOutsortingReason Outsorting Reason
LastUtilitiesPortion I_UtilitiesContract LastUtilitiesPortion Last Portion
_UtilitiesContract I_UtilitiesContractHistory _UtilitiesContract

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 C_UtilsContractHistoryDEX.
-- 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 C_UtilsContractHistoryDEX AS
SELECT
  I_UtilitiesContractHistory.UtilitiesContract AS UtilitiesContract,
  I_UtilitiesContractHistory.UtilsContractValidityEndDate AS UtilsContractValidityEndDate,
  I_UtilitiesContractHistory.UtilitiesFourDigitNumber AS UtilitiesFourDigitNumber,
  I_UtilitiesContractHistory.UtilsContractValidityStartDate AS UtilsContractValidityStartDate,
  I_UtilitiesContractHistory.UtilitiesProduct AS UtilitiesProduct,
  I_UtilitiesContractHistory.UtilsTransNumberInCRMDocument AS UtilsTransNumberInCRMDocument,
  I_UtilitiesContractHistory.UtilsItemNumberInCRMDocument AS UtilsItemNumberInCRMDocument,
  I_UtilitiesContractHistory.UtilsMarketingCampaignEndDate AS UtilsMarketingCampaignEndDate,
  I_UtilitiesContractHistory.DeletionIndicator AS DeletionIndicator,
  I_UtilitiesContractHistory.UtilsMstrAgrmtForIndivContract AS UtilsMstrAgrmtForIndivContract,
  I_UtilitiesContract.CompanyCode AS CompanyCode,
  I_UtilitiesContract.UtilitiesDivision AS UtilitiesDivision,
  I_UtilitiesContract.AlternativeUtilitiesPortion AS AlternativeUtilitiesPortion,
  I_UtilitiesContract.UtilsContrIsBilledManually AS UtilsContrIsBilledManually,
  I_UtilitiesContract.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  I_UtilitiesContract.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  I_UtilitiesContract.UtilitiesInstallation AS UtilitiesInstallation,
  I_UtilitiesContract.ContractAccount AS ContractAccount,
  I_UtilitiesContract.UtilitiesMoveInDate AS UtilitiesMoveInDate,
  I_UtilitiesContract.UtilitiesMoveOutDate AS UtilitiesMoveOutDate,
  I_UtilitiesContract.UtilsContractCreationDate AS UtilsContractCreationDate,
  I_UtilitiesContract.UtilsContractCreatedByUser AS UtilsContractCreatedByUser,
  I_UtilitiesContract.UtilsContractLastChangeDate AS UtilsContractLastChangeDate,
  I_UtilitiesContract.UtilsContractLastChangedByUser AS UtilsContractLastChangedByUser,
  I_UtilitiesContract.UtilsContrIsFinallyBilled AS UtilsContrIsFinallyBilled,
  I_UtilitiesContract.UtilsPlantOrCompanyConsumption AS UtilsPlantOrCompanyConsumption,
  I_UtilitiesContract.UtilsContrJointInvcType AS UtilsContrJointInvcType,
  I_UtilitiesContract.UtilitiesContractCanclnDate AS UtilitiesContractCanclnDate,
  I_UtilitiesContract.UtilitiesContractRenewalDate AS UtilitiesContractRenewalDate,
  I_UtilitiesContract.CADunningProcedure AS CADunningProcedure,
  I_UtilitiesContract.UtilitiesServiceProvider AS UtilitiesServiceProvider,
  I_UtilitiesContract.UtilsContractProcessingSts AS UtilsContractProcessingSts,
  I_UtilitiesContract.AuthorizationGroup AS AuthorizationGroup,
  I_UtilitiesContract.UtilsOutsrtgCheckGrpForBillg AS UtilsOutsrtgCheckGrpForBillg,
  I_UtilitiesContract.UtilitiesContractDescription AS UtilitiesContractDescription,
  I_UtilitiesContract.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  I_UtilitiesContract.UtilsContrSpcfcBdgtBillgCycle AS UtilsContrSpcfcBdgtBillgCycle,
  I_UtilitiesContract.UtilsBillgOutsortingReason AS UtilsBillgOutsortingReason,
  I_UtilitiesContract.LastUtilitiesPortion AS LastUtilitiesPortion,
  I_UtilitiesContractHistory._UtilitiesContract AS _UtilitiesContract
FROM I_UtilitiesContractHistory
;

Learn More