Fclm_Bm_Used_Unit

DDL: FCLM_BM_USED_UNIT SQL: VFCLM_BMUSEDUNIT Type: view

Bank data of where used unit

Fclm_Bm_Used_Unit is a CDS View that provides data about "Bank data of where used unit" in SAP S/4HANA. It reads from 3 data sources (but020, but100, Fclm_Bm_Address) and exposes 8 fields with key fields BpNumber, BpRole, BankCountry, BankInternalId.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
but020 but020 left_outer
but100 but100 left_outer
Fclm_Bm_Address Fclm_Bm_Address left_outer

Parameters (1)

NameTypeDefault
p_spras sylangu

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName VFCLM_BMUSEDUNIT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
EndUserText.label Bank data of where used unit view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BpNumber but0bk BusinessPartner
KEY BpRole but100 rltyp
KEY BankCountry but0bk BankCountryKey
KEY BankInternalId but0bk BankNumber
AddressCountry _Address AddressCountry
AddressCountryText _Address AddressCountryText
AddressCity _Address AddressCity
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'VFCLM_BMUSEDUNIT'
//@ClientDependent: true

@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #MANDATORY //#NOT_REQUIRED

@AccessControl.personalData.blocking: #REQUIRED //#NOT_REQUIRED

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #ORGANIZATIONAL
@EndUserText.label: 'Bank data of where used unit'
define view Fclm_Bm_Used_Unit
  with parameters
    p_spras : sylangu
  as select distinct from I_BusinessPartnerBank_2 as but0bk
    left outer join       but100                                                   on but100.partner = but0bk.BusinessPartner //partner

    left outer join       but020                                                   on but020.partner = but0bk.BusinessPartner //partner

    left outer join       Fclm_Bm_Address(p_spras:$parameters.p_spras) as _Address on _Address.AddressID = but020.addrnumber
{

  key but0bk.BusinessPartner            as  BpNumber,
  key but100.rltyp                      as  BpRole, //but0bk._BusinessPartner._BusinessPartnerRole.BusinessPartnerRole

  key but0bk.BankCountryKey             as  BankCountry,
  key but0bk.BankNumber                 as  BankInternalId,
      _Address.AddressCountry,
      _Address.AddressCountryText,
      _Address.AddressCity,
      _BusinessPartner

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_BM_ADDRESS",
"I_BUSINESSPARTNERBANK_2",
"BUT020",
"BUT100"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER"
],
"BASE":
[
"I_BUSINESSPARTNERBANK_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More