A_BPFinancialServicesExtn

DDL: A_BPFINANCIALSERVICESEXTN SQL: ABPFINSERVEXTN Type: view BASIC

Financial Services Details

A_BPFinancialServicesExtn is a Basic CDS View that provides data about "Financial Services Details" in SAP S/4HANA. It reads from 1 data source (I_BPFinancialServicesExtn) and exposes 34 fields with key field BusinessPartner.

1 data source(s) 34 fields

Data Sources (1)

SourceAliasJoin Type
I_BPFinancialServicesExtn I_BPFinancialServicesExtn from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ABPFINSERVEXTN view
EndUserText.label Financial Services Details view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
BusinessPartnerIsVIP BusinessPartnerIsVIP
TradingPartner TradingPartner
FactoryCalendar FactoryCalendar
BusinessPartnerOfficeCountry BusinessPartnerOfficeCountry
BusinessPartnerOfficeRegion BusinessPartnerOfficeRegion
BPRegisteredOfficeName BPRegisteredOfficeName
BPBalanceSheetCurrency BPBalanceSheetCurrency
BPLastCptlIncrAmtInBalShtCrcy BPLastCptlIncrAmtInBalShtCrcy
BPLastCapitalIncreaseYear BPLastCapitalIncreaseYear
BPBalanceSheetDisplayType BPBalanceSheetDisplayType
BusinessPartnerCitizenship BusinessPartnerCitizenship
BPMaritalPropertyRegime BPMaritalPropertyRegime
BusinessPartnerIncomeCurrency BusinessPartnerIncomeCurrency
BPNumberOfChildren BPNumberOfChildren
BPNumberOfHouseholdMembers BPNumberOfHouseholdMembers
BPAnnualNetIncAmtInIncomeCrcy BPAnnualNetIncAmtInIncomeCrcy
BPMonthlyNetIncAmtInIncomeCrcy BPMonthlyNetIncAmtInIncomeCrcy
BPAnnualNetIncomeYear BPAnnualNetIncomeYear
BPMonthlyNetIncomeMonth BPMonthlyNetIncomeMonth
BPMonthlyNetIncomeYear BPMonthlyNetIncomeYear
BPPlaceOfDeathName BPPlaceOfDeathName
CustomerIsUnwanted CustomerIsUnwanted
UndesirabilityReason UndesirabilityReason
UndesirabilityComment UndesirabilityComment
LastCustomerContactDate LastCustomerContactDate
BPGroupingCharacter BPGroupingCharacter
BPLetterSalutation BPLetterSalutation
BusinessPartnerTargetGroup BusinessPartnerTargetGroup
BusinessPartnerEmployeeGroup BusinessPartnerEmployeeGroup
BusinessPartnerIsEmployee BusinessPartnerIsEmployee
BPTermnBusRelationsBankDate BPTermnBusRelationsBankDate
_BPLetterSalutation _BPLetterSalutation
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'ABPFINSERVEXTN'
@EndUserText.label: 'Financial Services Details'

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.createEnabled:true
@ObjectModel.updateEnabled:true
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

define view A_BPFinancialServicesExtn
  as select from I_BPFinancialServicesExtn
  association[1..1] to A_BusinessPartner  as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
{
  key BusinessPartner,
      BusinessPartnerIsVIP,
      TradingPartner,
      FactoryCalendar,
      BusinessPartnerOfficeCountry,
      BusinessPartnerOfficeRegion,
      BPRegisteredOfficeName,
      BPBalanceSheetCurrency,
      @Semantics.amount.currencyCode: 'BPBalanceSheetCurrency'
      BPLastCptlIncrAmtInBalShtCrcy,
      BPLastCapitalIncreaseYear,
      BPBalanceSheetDisplayType,
      BusinessPartnerCitizenship,
      BPMaritalPropertyRegime,
      BusinessPartnerIncomeCurrency,
      BPNumberOfChildren,
      BPNumberOfHouseholdMembers,
      @Semantics.amount.currencyCode: 'BusinessPartnerIncomeCurrency'
      BPAnnualNetIncAmtInIncomeCrcy,
      @Semantics.amount.currencyCode: 'BusinessPartnerIncomeCurrency'
      BPMonthlyNetIncAmtInIncomeCrcy,
      BPAnnualNetIncomeYear,
      BPMonthlyNetIncomeMonth,
      BPMonthlyNetIncomeYear,
      BPPlaceOfDeathName,
      CustomerIsUnwanted,
      UndesirabilityReason,
      UndesirabilityComment,
      LastCustomerContactDate,
      BPGroupingCharacter,
      BPLetterSalutation,
      BusinessPartnerTargetGroup,
      BusinessPartnerEmployeeGroup,
      BusinessPartnerIsEmployee,
      BPTermnBusRelationsBankDate,
      /* Associations */
      @Consumption.hidden:true
      _BPLetterSalutation,
      @Consumption.hidden:true
      _BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPFINANCIALSERVICESEXTN"
],
"ASSOCIATED":
[
"A_BUSINESSPARTNER",
"I_BPLETTERSALUTATION"
],
"BASE":
[
"I_BPFINANCIALSERVICESEXTN"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More