C_UtilitiesBillingOrderHistory

DDL: C_UTILITIESBILLINGORDERHISTORY SQL: CEBILLINGORDHIST Type: view CONSUMPTION

Billing Order History

C_UtilitiesBillingOrderHistory is a Consumption CDS View that provides data about "Billing Order History" in SAP S/4HANA. It reads from 1 data source (I_UtilsBillingOrder) and exposes 17 fields with key fields UtilitiesContract, UtilitiesInstallation, ScheduledUtilitiesBillingDate, UtilitiesBillingReason.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_UtilsBillingOrder UtilsBillingOrder from

Annotations (8)

NameValueLevelField
EndUserText.label Billing Order History view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CEBILLINGORDHIST 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 (17)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesContract I_UtilsBillingOrder UtilitiesContract
KEY UtilitiesInstallation I_UtilsBillingOrder UtilitiesInstallation
KEY ScheduledUtilitiesBillingDate I_UtilsBillingOrder ScheduledUtilitiesBillingDate
KEY UtilitiesBillingReason I_UtilsBillingOrder UtilitiesBillingReason
CompanyCode I_UtilsBillingOrder CompanyCode
Division I_UtilsBillingOrder Division
ScheduledMeterReadingDate I_UtilsBillingOrder ScheduledMeterReadingDate
UtilsBillingOrderStatus I_UtilsBillingOrder UtilsBillingOrderStatus
UtilsBillgOrdChkBfrBilling I_UtilsBillingOrder UtilsBillgOrdChkBfrBilling
StatusCriticality
AuthorizationGroup I_UtilsBillingOrder AuthorizationGroup
_UtilitiesInstallation I_UtilsBillingOrder _UtilitiesInstallation
_UtilitiesBillingReason I_UtilsBillingOrder _UtilitiesBillingReason
_CompanyCode I_UtilsBillingOrder _CompanyCode
_Division I_UtilsBillingOrder _Division
_UtilsBillingOrderStatus I_UtilsBillingOrder _UtilsBillingOrderStatus
_UtilsBillgOrdChkBfrBilling I_UtilsBillingOrder _UtilsBillgOrdChkBfrBilling 
@EndUserText.label: 'Billing Order History'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'CEBILLINGORDHIST'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@UI.presentationVariant.sortOrder: [{ by: 'ScheduledUtilitiesBillingDate' , direction: #DESC }]
define view C_UtilitiesBillingOrderHistory
  as select from I_UtilsBillingOrder as UtilsBillingOrder
{
      @UI.hidden: true
  key UtilsBillingOrder.UtilitiesContract,

      @UI.hidden: true
      @ObjectModel.foreignKey.association:'_UtilitiesInstallation'
  key UtilsBillingOrder.UtilitiesInstallation,

      @UI.lineItem: [{ position: 10, importance: #HIGH }]
      @Semantics.businessDate.at: true
  key UtilsBillingOrder.ScheduledUtilitiesBillingDate,

      @UI.textArrangement: #TEXT_ONLY
      @UI.lineItem: [{ position: 20, importance: #HIGH }]
      @ObjectModel.foreignKey.association:'_UtilitiesBillingReason'
  key UtilsBillingOrder.UtilitiesBillingReason,

      @Consumption.hidden: true
      @ObjectModel.foreignKey.association:'_CompanyCode'
      UtilsBillingOrder.CompanyCode,

      @Consumption.hidden: true
      @ObjectModel.foreignKey.association:'_Division'
      UtilsBillingOrder.Division,

      @UI.lineItem: [{ position: 50, importance: #HIGH }]
      UtilsBillingOrder.ScheduledMeterReadingDate,

      @UI.textArrangement: #TEXT_FIRST
      @UI.lineItem: [{ position: 30, importance: #HIGH }]
      @ObjectModel.foreignKey.association: '_UtilsBillingOrderStatus'
      UtilsBillingOrder.UtilsBillingOrderStatus,

      @UI.textArrangement: #TEXT_ONLY
      @UI.lineItem: [{ position: 40, importance: #HIGH, criticality: 'StatusCriticality', criticalityRepresentation: #WITHOUT_ICON }]
      @ObjectModel.foreignKey.association: '_UtilsBillgOrdChkBfrBilling'
      UtilsBillingOrder.UtilsBillgOrdChkBfrBilling,

      @UI.hidden: true
      case when UtilsBillingOrder.UtilsBillgOrdChkBfrBilling is not null then 1 end as StatusCriticality,

      @Consumption.hidden: true
      UtilsBillingOrder.AuthorizationGroup,

      /* Associations */
      @Consumption.filter.hidden: true
      UtilsBillingOrder._UtilitiesInstallation,
      @Consumption.filter.hidden: true
      UtilsBillingOrder._UtilitiesBillingReason,
      @Consumption.filter.hidden: true
      UtilsBillingOrder._CompanyCode,
      @Consumption.filter.hidden: true
      UtilsBillingOrder._Division,
      @Consumption.filter.hidden: true
      UtilsBillingOrder._UtilsBillingOrderStatus,
      @Consumption.filter.hidden: true
      UtilsBillingOrder._UtilsBillgOrdChkBfrBilling
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILSBILLINGORDER"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_DIVISION",
"I_UTILITIESBILLINGREASON",
"I_UTILITIESINSTALLATION",
"I_UTILSBILLGORDCHKBFRBILLING",
"I_UTILSBILLINGORDERSTATUS"
],
"BASE":
[
"I_UTILSBILLINGORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More