C_UtilsContractHistoryDEX

@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Data Extractor for Contract History'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
    supportedCapabilities:  [ #EXTRACTION_DATA_SOURCE ],
    modelingPattern: #NONE,
    sapObjectNodeType: { name: 'UtilitiesContract' },
    usageType:  {
      serviceQuality: #X,
      sizeCategory: #XL,
      dataClass: #TRANSACTIONAL
                }
              }
@Analytics: {
      dataCategory: #FACT,
      technicalName: 'CUTILCONTRHISTDEX',
      dataExtraction: {
      enabled: true,
      delta.changeDataCapture: {
                                 mapping: [
                                 {
                                 table: 'EVERH', role: #MAIN,
                                 viewElement: [ 'UtilitiesContract', 'UtilsContractValidityEndDate', 'UtilitiesFourDigitNumber' ],
                                 tableElement: [ 'vertrag', 'bis', 'num' ]
                                 },
                                 {
                                 table: 'EVER', role: #LEFT_OUTER_TO_ONE_JOIN,
                                 viewElement: [ 'UtilitiesContract' ],
                                 tableElement: [ 'vertrag' ]
                                 }
                                          ]
                               }
                               }
}
define view entity C_UtilsContractHistoryDEX
  as select from           I_UtilitiesContractHistory
    left outer to one join I_UtilitiesContract as I_UtilitiesContract on I_UtilitiesContractHistory.UtilitiesContract = I_UtilitiesContract.UtilitiesContract

{
      // @ObjectModel.foreignKey.association: '_UtilitiesInstallation'

  key I_UtilitiesContractHistory.UtilitiesContract,
  key I_UtilitiesContractHistory.UtilsContractValidityEndDate,
  key I_UtilitiesContractHistory.UtilitiesFourDigitNumber,

      I_UtilitiesContractHistory.UtilsContractValidityStartDate,
      //     I_UtilitiesContractHistory.UtilitiesInstallation,

      I_UtilitiesContractHistory.UtilitiesProduct,
      I_UtilitiesContractHistory.UtilsTransNumberInCRMDocument,
      I_UtilitiesContractHistory.UtilsItemNumberInCRMDocument,

      //      everh.campaign         as UtilitiesMarketingCampaign,


      //      @Semantics.businessDate.to: true

      I_UtilitiesContractHistory.UtilsMarketingCampaignEndDate,
      I_UtilitiesContractHistory.DeletionIndicator,
      //@ObjectModel.foreignKey.association: '_UtilitiesContract'

      I_UtilitiesContractHistory.UtilsMstrAgrmtForIndivContract,
      // I_UtilitiesContractHistory.UtilitiesContractDescription,

      I_UtilitiesContract.CompanyCode,
      I_UtilitiesContract.UtilitiesDivision,
      I_UtilitiesContract.AlternativeUtilitiesPortion,
      I_UtilitiesContract.UtilsContrIsBilledManually,
      I_UtilitiesContract.UtilsBillgBlockReason,
      I_UtilitiesContract.UtilsBillgUnblockReason,
      I_UtilitiesContract.UtilitiesInstallation,
      I_UtilitiesContract.ContractAccount,
      I_UtilitiesContract.UtilitiesMoveInDate,
      I_UtilitiesContract.UtilitiesMoveOutDate,
      I_UtilitiesContract.UtilsContractCreationDate,
      I_UtilitiesContract.UtilsContractCreatedByUser,
      I_UtilitiesContract.UtilsContractLastChangeDate,
      I_UtilitiesContract.UtilsContractLastChangedByUser,
      @Semantics.booleanIndicator: true
      I_UtilitiesContract.UtilsContrIsFinallyBilled,
      I_UtilitiesContract.UtilsPlantOrCompanyConsumption,
      I_UtilitiesContract.UtilsContrJointInvcType,
      I_UtilitiesContract.UtilitiesContractCanclnDate,
      I_UtilitiesContract.UtilitiesContractRenewalDate,
      I_UtilitiesContract.CADunningProcedure,
      I_UtilitiesContract.UtilitiesServiceProvider,
      I_UtilitiesContract.UtilsContractProcessingSts,
      I_UtilitiesContract.AuthorizationGroup,
      //      I_UtilitiesContract.DeletionIndicator,

      I_UtilitiesContract.UtilsOutsrtgCheckGrpForBillg,
      I_UtilitiesContract.UtilitiesContractDescription,
      I_UtilitiesContract.UtilitiesAccountDetnCode,
      I_UtilitiesContract.UtilsContrSpcfcBdgtBillgCycle,
      I_UtilitiesContract.UtilsBillgOutsortingReason,
      I_UtilitiesContract.LastUtilitiesPortion,

      /* Associations */
      I_UtilitiesContractHistory._UtilitiesContract
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_UTILITIESCONTRACT",
"I_UTILITIESCONTRACTHISTORY"
],
"ASSOCIATED":
[
"I_UTILITIESCONTRACT"
],
"BASE":
[
"I_UTILITIESCONTRACTHISTORY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/