FAC_DART_Z3_S_BP_ADDRESS

DDL: FAC_DART_Z3_S_BP_ADDRESS SQL: FAC_DZARTSBPADDR Type: view

Business Partner Address for Supplier

FAC_DART_Z3_S_BP_ADDRESS is a CDS View that provides data about "Business Partner Address for Supplier" in SAP S/4HANA. It reads from 5 data sources (I_Address, I_BPCurrentDefaultAddress, I_BusinessPartner, I_Supplier, I_Supplier_to_BusinessPartner) and exposes 1 field with key field Supplier.

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_Supplier I_Supplier from
I_Supplier_to_BusinessPartner I_Supplier_to_BusinessPartner inner

Annotations (10)

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

Fields (1)

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

define view FAC_DART_Z3_S_BP_ADDRESS
  as select from    I_Supplier                    as I_Supplier
    inner join      I_Supplier_to_BusinessPartner as I_Supplier_to_BusinessPartner on I_Supplier_to_BusinessPartner.Supplier = I_Supplier.Supplier
    inner join      I_BusinessPartner             as I_BusinessPartner             on I_BusinessPartner.BusinessPartnerUUID = I_Supplier_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_Supplier.Supplier,

      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