C_UtilsBillingDocumentHistory

DDL: C_UTILSBILLINGDOCUMENTHISTORY SQL: CEBILLINGDOCHIST Type: view CONSUMPTION

Billing Document History

C_UtilsBillingDocumentHistory is a Consumption CDS View that provides data about "Billing Document History" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesBillingDocument) and exposes 18 fields with key field UtilitiesBillingDocument.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_UtilitiesBillingDocument UtilitiesBillingDocument from

Annotations (8)

NameValueLevelField
EndUserText.label Billing Document History view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CEBILLINGDOCHIST view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesBillingDocument I_UtilitiesBillingDocument UtilitiesBillingDocument
CompanyCode I_UtilitiesBillingDocument CompanyCode
BusinessPartner I_UtilitiesBillingDocument BusinessPartner
Division I_UtilitiesBillingDocument Division
UtilitiesContract I_UtilitiesBillingDocument UtilitiesContract
UtilsBillgPeriodStartDate I_UtilitiesBillingDocument UtilsBillgPeriodStartDate
UtilsBillgPeriodEndDate I_UtilitiesBillingDocument UtilsBillgPeriodEndDate
ScheduledUtilitiesBillingDate I_UtilitiesBillingDocument ScheduledUtilitiesBillingDate
UtilitiesBillingReason I_UtilitiesBillingDocument UtilitiesBillingReason
UtilitiesInstallation
UtilsBillgDocIsNotReleased
AuthorizationGroup I_UtilitiesBillingDocument AuthorizationGroup
_CompanyCode I_UtilitiesBillingDocument _CompanyCode
_BusinessPartner I_UtilitiesBillingDocument _BusinessPartner
_Division I_UtilitiesBillingDocument _Division
_UtilitiesContract I_UtilitiesBillingDocument _UtilitiesContract
_UtilitiesBillingReason I_UtilitiesBillingDocument _UtilitiesBillingReason
_UtilitiesInstallation 
@EndUserText.label: 'Billing Document History'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'CEBILLINGDOCHIST'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@UI.presentationVariant.sortOrder: [{ by: 'ScheduledUtilitiesBillingDate' , direction: #DESC }]
define view C_UtilsBillingDocumentHistory
  as select from I_UtilitiesBillingDocument   as UtilitiesBillingDocument
{
      @UI.lineItem: [{ position: 10, importance: #HIGH, type:#WITH_INTENT_BASED_NAVIGATION, semanticObjectAction: 'displayWithParams'}]
      @Consumption.semanticObject: 'UtilitiesBillingDocument'
  key UtilitiesBillingDocument.UtilitiesBillingDocument,
  
      @Consumption.hidden: true
      @ObjectModel.foreignKey.association:'_CompanyCode'
      UtilitiesBillingDocument.CompanyCode,
      
      @Consumption.hidden: true
      @ObjectModel.foreignKey.association:'_BusinessPartner'
      UtilitiesBillingDocument.BusinessPartner,
      
      @Consumption.hidden: true
      @ObjectModel.foreignKey.association:'_Division'
      UtilitiesBillingDocument.Division,

      @Consumption.hidden: true
      @ObjectModel.foreignKey.association: '_UtilitiesContract'
      UtilitiesBillingDocument.UtilitiesContract,

      @UI.lineItem: [{ position: 40, importance: #HIGH }]
      @Semantics.businessDate.from: true
      UtilitiesBillingDocument.UtilsBillgPeriodStartDate,

      @UI.lineItem: [{ position: 50, importance: #HIGH }]
      @Semantics.businessDate.to: true
      UtilitiesBillingDocument.UtilsBillgPeriodEndDate,

      @UI.lineItem: [{ position: 20, importance: #HIGH }]
      @Semantics.businessDate.at: true
      UtilitiesBillingDocument.ScheduledUtilitiesBillingDate,

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

      @UI.hidden: true  
      @ObjectModel.foreignKey.association: '_UtilitiesInstallation'
      UtilitiesBillingDocument._UtilitiesContract.UtilitiesInstallation,
  
      @UI.lineItem: [{ position: 60, importance: #HIGH }]
      cast(UtilitiesBillingDocument.UtilsBillgDocIsNotReleased as e_docnotreleased_vdm preserving type) as UtilsBillgDocIsNotReleased,
   
      @Consumption.hidden: true
      UtilitiesBillingDocument.AuthorizationGroup,

      /* Associations */
      @Consumption.filter.hidden: true
      UtilitiesBillingDocument._CompanyCode,
      @Consumption.filter.hidden: true
      UtilitiesBillingDocument._BusinessPartner,
      @Consumption.filter.hidden: true
      UtilitiesBillingDocument._Division,
      @Consumption.filter.hidden: true
      UtilitiesBillingDocument._UtilitiesContract,
      @Consumption.filter.hidden: true
      UtilitiesBillingDocument._UtilitiesBillingReason,
      @Consumption.filter.hidden: true
      UtilitiesBillingDocument._UtilitiesContract._UtilitiesInstallation
}
where
  UtilitiesBillingDocument.UtilsBillgSimulationReason = '' and 
  UtilitiesBillingDocument.UtilsBillgDocReversalRsn = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILITIESBILLINGDOCUMENT",
"I_UTILITIESCONTRACT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_DIVISION",
"I_UTILITIESBILLINGREASON",
"I_UTILITIESCONTRACT",
"I_UTILITIESINSTALLATION"
],
"BASE":
[
"I_UTILITIESBILLINGDOCUMENT",
"I_UTILITIESCONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More