I_BPFINANCIALSERVICESEXTN

CDS View

Financial Services Attributes for BP

I_BPFINANCIALSERVICESEXTN is a CDS View in S/4HANA. Financial Services Attributes for BP. It contains 7 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 7 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_BPFinancialServicesExtn view from BASIC Financial Services Details
I_BPFinancialServicesExtnTP view_entity from TRANSACTIONAL Financial Services Details - TP
I_LoanContrBPFinSrvcWthDflt view left_outer COMPOSITE Loan Contract Business Partner Financials with defaulting
P_LoanContrBPAddlDet view left_outer COMPOSITE Business Partner additional details
P_LoanContrBPIncome view inner COMPOSITE Business Partner income

Fields (7)

KeyField CDS FieldsUsed in Views
BPAnnualNetIncAmtInIncomeCrcy BPAnnualIncAmtInIncCrcy 2
BPMonthlyNetIncAmtInIncomeCrcy BPMonthlyIncAmtInIncCrcy 2
BusinessPartnerIncomeCurrency BusinessPartnerIncomeCurrency 2
BusinessPartnerIsVIP BusinessPartnerIsVIP 1
BusinessPartnerTargetGroup BusPartEmploymentTargetGroup 1
CustomerIsUnwanted CustomerIsUnwanted 1
UndesirabilityReason UndesirabilityReason 1 
@AbapCatalog: { sqlViewName: 'IBPFINSERVEXTN',
                compiler.compareFilter: true,
                buffering.status: #NOT_ALLOWED
              }

@ObjectModel: { usageType: { dataClass: #MASTER,
                             serviceQuality: #A,
                             sizeCategory: #XL
                            },
                representativeKey: 'BusinessPartner',
                sapObjectNodeType.name: 'BPFinancialServicesExtension',
                supportedCapabilities: [  #ANALYTICAL_DIMENSION,
                                          #CDS_MODELING_DATA_SOURCE,
                                          #CDS_MODELING_ASSOCIATION_TARGET,
                                          #SQL_DATA_SOURCE,
                                          #EXTRACTION_DATA_SOURCE ],
                modelingPattern: #ANALYTICAL_DIMENSION              
              }
@Analytics: { dataExtraction.enabled: true,
              dataCategory: #DIMENSION,
              internalName: #LOCAL
            }
@Metadata: { allowExtensions: true,
             ignorePropagatedAnnotations: true
           }   
@AccessControl: { personalData.blocking: #REQUIRED,
                  authorizationCheck: #MANDATORY
                }                                  
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@EndUserText.label: 'Financial Services Attributes for BP'

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


}

Learn More