I_BPFinancialServicesExtn

@AbapCatalog.sqlViewName: 'IBPFINSERVEXTN'
@EndUserText.label: 'Financial Services Attributes for BP'
@ObjectModel.usageType.sizeCategory: #XL

@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName: #LOCAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'BusinessPartner'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@Metadata.allowExtensions: true
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true //For C1 Release


define view I_BPFinancialServicesExtn   
  as select from bp001
  association [1]    to I_BusinessPartner       as _BusinessPartner    on $projection.BusinessPartner         = _BusinessPartner.BusinessPartner
  association [0..1] to I_BPLetterSalutation    as _BPLetterSalutation on $projection.BPLetterSalutation      = _BPLetterSalutation.BPLetterSalutation
  association [0..1] to I_BPTradingPartner      as _BPTradingPartner   on $projection.TradingPartner          = _BPTradingPartner.TradingPartner
{
  key bp001.partner        as BusinessPartner,
      bp001.vip            as BusinessPartnerIsVIP,
      bp001.vbund          as TradingPartner,
      bp001.calendarid     as FactoryCalendar,
      bp001.cntry_comp     as BusinessPartnerOfficeCountry,
      bp001.regio          as BusinessPartnerOfficeRegion,
      bp001.comp_head      as BPRegisteredOfficeName,
      bp001.bal_sh_cur     as BPBalanceSheetCurrency,
      
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      bp001.cap_incr_a     as BPLastCptlIncrAmtInBalShtCrcy,
      
      bp001.cap_incr_y     as BPLastCapitalIncreaseYear,
      bp001.balance_fl     as BPBalanceSheetDisplayType,
      bp001.state          as BusinessPartnerCitizenship,
      bp001.proprty_st     as BPMaritalPropertyRegime,
      bp001.income_cur     as BusinessPartnerIncomeCurrency,
      bp001.children       as BPNumberOfChildren,
      bp001.mem_house      as BPNumberOfHouseholdMembers,
      
      @Semantics.amount.currencyCode: 'BusinessPartnerIncomeCurrency'
      bp001.net_income     as BPAnnualNetIncAmtInIncomeCrcy,
      
      @Semantics.amount.currencyCode: 'BusinessPartnerIncomeCurrency'
      bp001.mo_net_inc     as BPMonthlyNetIncAmtInIncomeCrcy,
      
      bp001.net_inc_y      as BPAnnualNetIncomeYear,
      bp001.mo_inc_m       as BPMonthlyNetIncomeMonth,
      bp001.mo_inc_y       as BPMonthlyNetIncomeYear,
      bp001.dying_place    as BPPlaceOfDeathName,
      bp001.unw_customer   as CustomerIsUnwanted,
      bp001.unw_reason     as UndesirabilityReason,
      bp001.unw_remark     as UndesirabilityComment,
      bp001.last_cust_cont as LastCustomerContactDate,
      bp001.group_feature  as BPGroupingCharacter,
      bp001.title_let      as BPLetterSalutation,

      bp001.group_d        as BusinessPartnerTargetGroup,
      bp001.staff_grp      as BusinessPartnerEmployeeGroup,
      bp001.staff_ref      as BusinessPartnerIsEmployee,
      bp001.bank_del_d     as BPTermnBusRelationsBankDate,

      _BPTradingPartner,
      _BPLetterSalutation,
      _BusinessPartner


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BP001"
],
"ASSOCIATED":
[
"I_BPLETTERSALUTATION",
"I_BPTRADINGPARTNER",
"I_BUSINESSPARTNER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/