C_UtilsContrToBeBlld

DDL: C_UTILSCONTRTOBEBLLD SQL: CECONTRTBBILLEDQ Type: view CONSUMPTION
40 Fields 1 Data Sources 1 Associations

Utilities Contract to Be Billed

C_UtilsContrToBeBlld is a Consumption CDS View that provides data about "Utilities Contract to Be Billed" in SAP S/4HANA. It reads from 1 data source (I_UtilsContrToBeBlld) and exposes 40 fields with key fields UtilitiesContract, ScheduledUtilitiesBillingDate, UtilitiesPortion, ScheduledMeterReadingDate. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_UtilsContrToBeBlld UtilsContrToBeBlld from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MeterReadingPortnSchedVH _MeterReadingPortnSchedVH $projection.UtilitiesPortion = _MeterReadingPortnSchedVH.UtilitiesPortion and $projection.ScheduledUtilitiesBillingDate = _MeterReadingPortnSchedVH.ScheduledUtilitiesBillingDate

Annotations (8)

NameValueLevelField
EndUserText.label Utilities Contract to Be Billed view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CECONTRTBBILLEDQ view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_UtilsContrToBeBlld UtilitiesContract
KEY ScheduledUtilitiesBillingDate I_UtilsContrToBeBlld ScheduledUtilitiesBillingDate
KEY UtilitiesPortion I_UtilsContrToBeBlld UtilitiesPortion
KEY ScheduledMeterReadingDate I_UtilsContrToBeBlld ScheduledMeterReadingDate
UtilitiesBillingReason I_UtilsContrToBeBlld UtilitiesBillingReason
BusinessPartner I_UtilsContrToBeBlld BusinessPartner Issuing Authority
ContractAccount I_UtilsContrToBeBlld ContractAccount Contract Acct
UtilsBillgBlockReason I_UtilsContrToBeBlld UtilsBillgBlockReason
UtilsBillgUnblockReason I_UtilsContrToBeBlld UtilsBillgUnblockReason
CompanyCode I_UtilsContrToBeBlld CompanyCode Receiver Company Code
Division I_UtilsContrToBeBlld Division Internal Division ID
UtilitiesInstallation I_UtilsContrToBeBlld UtilitiesInstallation
MeterReadingUnit I_UtilsContrToBeBlld MeterReadingUnit
MeterReadingUnitName
UtilitiesRateCategory I_UtilsContrToBeBlld UtilitiesRateCategory
UtilitiesBillingClass I_UtilsContrToBeBlld UtilitiesBillingClass
UtilsPortionScheduleRecordDate I_UtilsContrToBeBlld UtilsPortionScheduleRecordDate
UtilitiesAccountDetnCode I_UtilsContrToBeBlld UtilitiesAccountDetnCode
UtilsContrToBeBlldType I_UtilsContrToBeBlld UtilsContrToBeBlldType
UtilsContrToBeBlldTypeName
UtilsContrToBeBlldDetsType I_UtilsContrToBeBlld UtilsContrToBeBlldDetsType
UtilsContrToBeBlldDetsTypeName
AuthorizationGroup I_UtilsContrToBeBlld AuthorizationGroup AuthorizGroup
NmbrOfUtilsContractsToBeBilled I_UtilsContrToBeBlld NmbrOfUtilsContractsToBeBilled
_UtilitiesPortion I_UtilsContrToBeBlld _UtilitiesPortion
_UtilitiesBillingReason I_UtilsContrToBeBlld _UtilitiesBillingReason
_BusinessPartner I_UtilsContrToBeBlld _BusinessPartner
_ContrAcc I_UtilsContrToBeBlld _ContrAcc
_UtilsBillgBlockReason I_UtilsContrToBeBlld _UtilsBillgBlockReason
_UtilsBillgUnblockReason I_UtilsContrToBeBlld _UtilsBillgUnblockReason
_CompanyCode I_UtilsContrToBeBlld _CompanyCode
_Division I_UtilsContrToBeBlld _Division
_UtilitiesInstallation I_UtilsContrToBeBlld _UtilitiesInstallation
_MeterReadingUnit I_UtilsContrToBeBlld _MeterReadingUnit
_UtilitiesRateCategory I_UtilsContrToBeBlld _UtilitiesRateCategory
_UtilsBillingClass I_UtilsContrToBeBlld _UtilsBillingClass
_UtilsAccountDetnCode I_UtilsContrToBeBlld _UtilsAccountDetnCode
_UtilsContrToBeBlldType I_UtilsContrToBeBlld _UtilsContrToBeBlldType
_UtilsContrToBeBlldDetsType I_UtilsContrToBeBlld _UtilsContrToBeBlldDetsType
_MeterReadingPortnSchedVH _MeterReadingPortnSchedVH

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_UtilsContrToBeBlld.
-- 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.
-- SQL view name: CECONTRTBBILLEDQ

CREATE VIEW C_UtilsContrToBeBlld AS
SELECT
  UtilsContrToBeBlld.UtilitiesContract AS UtilitiesContract,
  UtilsContrToBeBlld.ScheduledUtilitiesBillingDate AS ScheduledUtilitiesBillingDate,
  UtilsContrToBeBlld.UtilitiesPortion AS UtilitiesPortion,
  UtilsContrToBeBlld.ScheduledMeterReadingDate AS ScheduledMeterReadingDate,
  UtilsContrToBeBlld.UtilitiesBillingReason AS UtilitiesBillingReason,
  UtilsContrToBeBlld.BusinessPartner AS BusinessPartner,
  UtilsContrToBeBlld.ContractAccount AS ContractAccount,
  UtilsContrToBeBlld.UtilsBillgBlockReason AS UtilsBillgBlockReason,
  UtilsContrToBeBlld.UtilsBillgUnblockReason AS UtilsBillgUnblockReason,
  UtilsContrToBeBlld.CompanyCode AS CompanyCode,
  UtilsContrToBeBlld.Division AS Division,
  UtilsContrToBeBlld.UtilitiesInstallation AS UtilitiesInstallation,
  UtilsContrToBeBlld.MeterReadingUnit AS MeterReadingUnit,
  UtilsContrToBeBlld._MeterReadingUnit.MeterReadingUnitName AS MeterReadingUnitName,
  UtilsContrToBeBlld.UtilitiesRateCategory AS UtilitiesRateCategory,
  UtilsContrToBeBlld.UtilitiesBillingClass AS UtilitiesBillingClass,
  UtilsContrToBeBlld.UtilsPortionScheduleRecordDate AS UtilsPortionScheduleRecordDate,
  UtilsContrToBeBlld.UtilitiesAccountDetnCode AS UtilitiesAccountDetnCode,
  UtilsContrToBeBlld.UtilsContrToBeBlldType AS UtilsContrToBeBlldType,
  UtilsContrToBeBlld._UtilsContrToBeBlldType._Text[1:Language = $session.system_language].UtilsContrToBeBlldTypeName AS UtilsContrToBeBlldTypeName,
  UtilsContrToBeBlld.UtilsContrToBeBlldDetsType AS UtilsContrToBeBlldDetsType,
  UtilsContrToBeBlld._UtilsContrToBeBlldDetsType._Text[1:Language = $session.system_language].UtilsContrToBeBlldDetsTypeName AS UtilsContrToBeBlldDetsTypeName,
  UtilsContrToBeBlld.AuthorizationGroup AS AuthorizationGroup,
  UtilsContrToBeBlld.NmbrOfUtilsContractsToBeBilled AS NmbrOfUtilsContractsToBeBilled,
  UtilsContrToBeBlld._UtilitiesPortion AS _UtilitiesPortion,
  UtilsContrToBeBlld._UtilitiesBillingReason AS _UtilitiesBillingReason,
  UtilsContrToBeBlld._BusinessPartner AS _BusinessPartner,
  UtilsContrToBeBlld._ContrAcc AS _ContrAcc,
  UtilsContrToBeBlld._UtilsBillgBlockReason AS _UtilsBillgBlockReason,
  UtilsContrToBeBlld._UtilsBillgUnblockReason AS _UtilsBillgUnblockReason,
  UtilsContrToBeBlld._CompanyCode AS _CompanyCode,
  UtilsContrToBeBlld._Division AS _Division,
  UtilsContrToBeBlld._UtilitiesInstallation AS _UtilitiesInstallation,
  UtilsContrToBeBlld._MeterReadingUnit AS _MeterReadingUnit,
  UtilsContrToBeBlld._UtilitiesRateCategory AS _UtilitiesRateCategory,
  UtilsContrToBeBlld._UtilsBillingClass AS _UtilsBillingClass,
  UtilsContrToBeBlld._UtilsAccountDetnCode AS _UtilsAccountDetnCode,
  UtilsContrToBeBlld._UtilsContrToBeBlldType AS _UtilsContrToBeBlldType,
  UtilsContrToBeBlld._UtilsContrToBeBlldDetsType AS _UtilsContrToBeBlldDetsType
FROM I_UtilsContrToBeBlld AS UtilsContrToBeBlld
LEFT OUTER JOIN I_MeterReadingPortnSchedVH AS _MeterReadingPortnSchedVH ON UtilitiesPortion = _MeterReadingPortnSchedVH.UtilitiesPortion AND ScheduledUtilitiesBillingDate = _MeterReadingPortnSchedVH.ScheduledUtilitiesBillingDate  -- association [0..*]
;

Learn More