I_ReversedUtilsBillingDocument

@EndUserText.label: 'Reversed Billing Document'
@Analytics.dataCategory: #CUBE
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IERVSDBILLGDOC'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'UtilitiesBillingDocument'
@AccessControl.privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser' ]
@Metadata.allowExtensions: true
define view I_ReversedUtilsBillingDocument
  as select from I_UtilitiesBillingDocument as _UtilitiesBillingDocument
{
  key UtilitiesBillingDocument,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      CompanyCode,
      BusinessPartner,
      //@ObjectModel.foreignKey.association: '_ContractAccount'

      ContractAccount,
      @ObjectModel.foreignKey.association: '_UtilitiesContract'
      UtilitiesContract,
      //@ObjectModel.foreignKey.association: '_UtilsBusinessTransactionTT'

      UtilsBusTransactionType,
      @ObjectModel.foreignKey.association: '_UtilitiesBillingReason'
      UtilitiesBillingReason,
      UtilsBillgPeriodStartDate,
      UtilsBillgPeriodEndDate,
      @ObjectModel.foreignKey.association: '_Division'
      Division,
      @ObjectModel.foreignKey.association: '_UtilsBillgDocSimulationRsn'
      UtilsBillgSimulationReason,
      UtilsBillgDocIsNotReleased,
      UtilsBillgDocReversalDate,
      @ObjectModel.foreignKey.association: '_UtilsBillingDocReversalRsn'
      UtilsBillgDocReversalRsn,
      UtilsBillgPeriodAllocationDate,
      @ObjectModel.foreignKey.association: '_UtilitiesPortion'
      UtilitiesPortion,
      ScheduledUtilitiesBillingDate,
      @ObjectModel.foreignKey.association: '_MeterReadingUnit'
      MeterReadingUnit,
      ScheduledMeterReadingDate,
      @ObjectModel.foreignKey.association: '_ManualUtilsBillgDocCrtnRsn'
      ManualUtilsBillgDocCrtnRsn,
      MnlUtilsBillgDocIsReldForInvcg,
      UtilitiesBillingRun,
      UtilsBillgDocCreationDate,
      UtilsBillgDocCreatedByUser,
      UtilsBillgDocLastChangeDate,
      UtilsBillgDocLastChangedByUser,
      AuthorizationGroup,

      @DefaultAggregation: #SUM
      cast(1 as e_reversedbillgdoc_vdm) as NmbrOfReversedUtilsBillgDocs,

      _UtilitiesBillingReason,
      @ObjectModel.association.boundFields.dataMatchesSourceAndTargetTypes: true
      _UtilsBillgDocSimulationRsn,
      _ManualUtilsBillgDocCrtnRsn,
      _Division,
      _CompanyCode,
      _UtilsBillingDocReversalRsn,
      //_UtilsBusinessTransactionTT,

      _UtilitiesPortion,
      _MeterReadingUnit,
      _BusinessPartner,
      //_ContractAccount,

      _UtilitiesContract,
      _CreatedByUser,
      _LastChangedByUser
}
where
  _UtilitiesBillingDocument.UtilsBillgDocReversalDate != '00000000'
  and //No date

  _UtilitiesBillingDocument.UtilitiesBillingReason != '06'; //Manual Credit Memo/Backbilling 

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILITIESBILLINGDOCUMENT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_DIVISION",
"I_MANUALUTILSBILLGDOCCRTNRSN",
"I_METERREADINGUNIT",
"I_USER",
"I_UTILITIESBILLINGREASON",
"I_UTILITIESCONTRACT",
"I_UTILITIESPORTION",
"I_UTILSBILLGDOCSIMULATIONRSN",
"I_UTILSBILLINGDOCREVERSALRSN"
],
"BASE":
[
"I_UTILITIESBILLINGDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/