C_TaxRegMigrationTP

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #NOT_REQUIRED,
  privilegedAssociations: ['_CreatedByUserContactCard','_LastChangedByUserContactCard']
  }
@EndUserText.label: 'Migration Overview'
@ObjectModel:{
  semanticKey: ['TaxRegisterMigrationNumber'],
  usageType :{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
  }
}
@VDM:{
  viewType: #CONSUMPTION,
  usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
}
@Metadata.allowExtensions: true


define root view entity C_TaxRegMigrationTP
  provider contract transactional_query
  as projection on R_TaxRegMigrationTP

  association [1..1] to C_TaxRegisterActiveTaxCountry as _TaxRegisterActiveTaxCountry  on  $projection.TaxCountry   = _TaxRegisterActiveTaxCountry.TaxCountry
                                                                                       and $projection.TaxationType = _TaxRegisterActiveTaxCountry.TaxationType
  association [1..1] to I_UserContactCard             as _CreatedByUserContactCard     on  $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID
  association [0..1] to I_UserContactCard             as _LastChangedByUserContactCard on  $projection.LastChangedByUser = _LastChangedByUserContactCard.ContactCardID
{
  key TaxRegisterMigrationUUID,
      TaxRegisterMigrationNumber,
      @ObjectModel: {
        text.element: ['CountryName']
        }
      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_TaxCountryValueHelp', element: 'TaxCountry' }}]
      TaxCountry,
      @ObjectModel: {
        text.element: ['TaxationTypeDescription']
       }
      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_TaxationTypeValueHelp', element: 'TaxationType' },
                                           additionalBinding: [{ localElement: 'TaxCountry', element: 'TaxCountry'}]}]
      TaxationType,
      @ObjectModel.text.element: ['TaxRegisterMigrationStatusDesc']
      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_TaxRegisterMigrationStatus', element: 'TaxRegisterMigrationStatus' }}]
      TaxRegisterMigrationStatus,
      @Consumption.filter : { selectionType: #INTERVAL }
      @EndUserText.label: 'Posting Date From'
      FromPostingDate,
      @Consumption.filter : { selectionType: #INTERVAL }
      @EndUserText.label: 'Posting Date To'
      ToPostingDate,
      @ObjectModel.text.element: ['TaxRegMigrtnRptgDateTypeDesc']
      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_TxRegMigrtnRptgDateType', element: 'TaxRegMigrtnRptgDateType' }}]
      TaxRegMigrtnRptgDateType,
      @ObjectModel.text.element: ['TaxRegMigrtnFlfmtDateTypeDesc']
      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_TxRegMigrtnFlfmtDateType', element: 'TaxRegMigrtnFlfmtDateType' }}]
      TaxRegMigrtnFlfmtDateType,
      TxRegMigrtnScheduledDateTime,
      MigrationJobNumber,
      TaxRegisterMigrationLogHandle,
      Criticality,
      @ObjectModel.foreignKey.association: '_CreatedByUserContactCard'
      CreatedByUser,
      @Consumption.filter : { selectionType: #INTERVAL }
      CreationDateTime,
      @ObjectModel.foreignKey.association: '_LastChangedByUserContactCard'
      LastChangedByUser,
      LastChangeDateTime,
      _TaxCountryText.CountryName                                   as CountryName                    : localized,
      _TaxationTypeText.TaxationTypeDescription                     as TaxationTypeDescription        : localized,
      _TaxRegisterMigrationStatusTxt.TaxRegisterMigrationStatusDesc as TaxRegisterMigrationStatusDesc : localized,
      _TaxRegisterRptgDateTypeText.TaxRegMigrtnRptgDateTypeDesc     as TaxRegMigrtnRptgDateTypeDesc   : localized,
      _TaxRegisterFlfmtDateTypeText.TaxRegMigrtnFlfmtDateTypeDesc   as TaxRegMigrtnFlfmtDateTypeDesc  : localized,
      _TaxRegisterActiveTaxCountry,
      _TaxCountryText,
      _TaxationTypeText,
      @Consumption.filter.hidden: true
      _CreatedByUserContactCard,
      @Consumption.filter.hidden: true
      _LastChangedByUserContactCard
      //_TaxCountry

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COUNTRYTEXT",
"I_TAXATIONTYPETEXT",
"I_TXREGMIGRATIONSTATUSTEXT",
"I_TXREGMIGRTNFLFMTDATETYPETEXT",
"I_TXREGMIGRTNRPTGDATETYPETEXT",
"R_TAXREGMIGRATIONTP"
],
"ASSOCIATED":
[
"C_TAXREGISTERACTIVETAXCOUNTRY",
"I_COUNTRYTEXT",
"I_TAXATIONTYPETEXT",
"I_USERCONTACTCARD"
],
"BASE":
[
"R_TAXREGMIGRATIONTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/