FAC_DART_Z3_C_BP_ADDRESS

DDL: FAC_DART_Z3_C_BP_ADDRESS SQL: FAC_DZARTCBPADDR Type: view Package: FINS_FI_DART_Z3

Business Partner Address for Customer

FAC_DART_Z3_C_BP_ADDRESS is a CDS View that provides data about "Business Partner Address for Customer" in SAP S/4HANA. It reads from 5 data sources (I_Address, I_BPCurrentDefaultAddress, I_BusinessPartner, I_Customer, I_Customer_to_BusinessPartner) and exposes 1 field with key field Customer. Part of development package FINS_FI_DART_Z3.

5 data source(s) 1 fields

Data Sources (5)

SourceAliasJoin Type
I_Address I_Address inner
I_BPCurrentDefaultAddress I_BPCurrentDefaultAddress left_outer
I_BusinessPartner I_BusinessPartner inner
I_Customer I_Customer from
I_Customer_to_BusinessPartner I_Customer_to_BusinessPartner inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZARTCBPADDR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Business Partner Address for Customer view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer 
@AbapCatalog.sqlViewName: 'FAC_DZARTCBPADDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Business Partner Address for Customer'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER

define view FAC_DART_Z3_C_BP_ADDRESS
  as select from    I_Customer                    as I_Customer
    inner join      I_Customer_to_BusinessPartner as I_Customer_to_BusinessPartner on I_Customer_to_BusinessPartner.Customer = I_Customer.Customer
    inner join      I_BusinessPartner             as I_BusinessPartner             on I_BusinessPartner.BusinessPartnerUUID = I_Customer_to_BusinessPartner.BusinessPartnerUUID
    left outer join I_BPCurrentDefaultAddress     as I_BPCurrentDefaultAddress     on I_BPCurrentDefaultAddress.BusinessPartner = I_BusinessPartner.BusinessPartner
    inner join      I_Address                     as I_Address                     on I_Address.AddressID = I_BPCurrentDefaultAddress.AddressID

{
  key I_Customer.Customer,

      cast(
        REPLACE (
            RTRIM(
              LTRIM(
                concat(
                  concat(
                    concat(
                      concat( I_Address.HouseNumber , '/' ),
                      concat( I_Address.StreetName , '/' )
                    ) ,
                    concat(
                      concat( I_Address.CityName , '/' ),
                      concat( I_Address.Country , '/' )
                     )
                 ) ,
                 I_Address.PostalCode
                ), '/'
              ), '/'
          ),
          '//',

          '/'
        ) as fac_dart_z3_bp_addr ) as  BusinessPartnerAddress

}

Learn More