I_EngmntProjCustomerAddress

DDL: I_ENGMNTPROJCUSTOMERADDRESS SQL: IPCUSTBPDET Type: view COMPOSITE

Customer Business Partner Multi Address Details

I_EngmntProjCustomerAddress is a Composite CDS View that provides data about "Customer Business Partner Multi Address Details" in SAP S/4HANA. It reads from 3 data sources (I_BPCustomerMultiAddrVH, I_CustomerSalesArea, I_EngagementProjectSrvcOrgDets) and exposes 21 fields with key fields Customer, BusinessPartner, CustomerProjectServiceOrg, SalesOrganization, DistributionChannel. It has 1 association to related views.

3 data source(s) 21 fields

Data Sources (3)

SourceAliasJoin Type
I_BPCustomerMultiAddrVH CustomerBP from
I_CustomerSalesArea CustomerSalesArea inner
I_EngagementProjectSrvcOrgDets CustProjSrvc inner

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_BPCustomerMultiAddrVH _CustomerBP $projection.Customer = _CustomerBP.Customer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPCUSTBPDET view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Customer Business Partner Multi Address Details view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Customer I_BPCustomerMultiAddrVH Customer
KEY BusinessPartner I_BPCustomerMultiAddrVH BusinessPartner
KEY CustomerProjectServiceOrg I_EngagementProjectSrvcOrgDets EngagementProjectServiceOrg
KEY SalesOrganization I_CustomerSalesArea SalesOrganization
KEY DistributionChannel I_CustomerSalesArea DistributionChannel
KEY Division I_CustomerSalesArea Division
CustomerName I_BPCustomerMultiAddrVH CustomerName
StandardUsage I_BPCustomerMultiAddrVH StandardUsage
OrganizationBPName1 I_BPCustomerMultiAddrVH OrganizationBPName1
OrganizationBPName2 I_BPCustomerMultiAddrVH OrganizationBPName2
Currency I_CustomerSalesArea Currency
CustomerAccountGroup I_BPCustomerMultiAddrVH CustomerAccountGroup
AuthorizationGroup I_BPCustomerMultiAddrVH AuthorizationGroup
CityName I_BPCustomerMultiAddrVH CityName
Country I_BPCustomerMultiAddrVH Country
PostalCode I_BPCustomerMultiAddrVH PostalCode
_CustomerBP _CustomerBP
_SalesOrganization I_CustomerSalesArea _SalesOrganization
_DistributionChannel I_CustomerSalesArea _DistributionChannel
_Division I_CustomerSalesArea _Division
_Currency I_CustomerSalesArea _Currency 
@AbapCatalog.sqlViewName: 'IPCUSTBPDET'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@EndUserText.label: 'Customer Business Partner Multi Address Details'
define view I_EngmntProjCustomerAddress
  as select from I_BPCustomerMultiAddrVH        as CustomerBP
    inner join   I_CustomerSalesArea            as CustomerSalesArea on CustomerBP.Customer = CustomerSalesArea.Customer
    inner join   I_EngagementProjectSrvcOrgDets as CustProjSrvc      on  CustomerSalesArea.SalesOrganization   = CustProjSrvc.AssignedOrganisation
                                                                     and CustProjSrvc.AssignedOrganisationType = 'SO'
     association [1..*] to I_BPCustomerMultiAddrVH as _CustomerBP on $projection.Customer = _CustomerBP.Customer 
{
  key    CustomerBP.Customer                      as Customer,
  key    CustomerBP.BusinessPartner               as BusinessPartner,
  key    CustProjSrvc.EngagementProjectServiceOrg as CustomerProjectServiceOrg,
  key    CustomerSalesArea.SalesOrganization      as SalesOrganization,
  key    CustomerSalesArea.DistributionChannel    as DistributionChannel,
  key    CustomerSalesArea.Division               as Division,

         CustomerBP.CustomerName                  as CustomerName,
         CustomerBP.StandardUsage                 as StandardUsage,
         CustomerBP.OrganizationBPName1           as OrganizationBPName1,
         CustomerBP.OrganizationBPName2           as OrganizationBPName2,
         CustomerSalesArea.Currency               as Currency,
         CustomerBP.CustomerAccountGroup          as CustomerAccountGroup,
         CustomerBP.AuthorizationGroup            as AuthorizationGroup,
         CustomerBP.CityName                      as CityName,
         CustomerBP.Country                       as Country,
         CustomerBP.PostalCode                    as PostalCode,
        
        //Association for DCL

        @Consumption.valueHelpDefinition : [{association: '_CustomerBP'}]
         _CustomerBP,
        
         CustomerSalesArea._SalesOrganization,
         CustomerSalesArea._DistributionChannel,
         CustomerSalesArea._Division,
         CustomerSalesArea._Currency
}
where
  CustomerBP.IsBusinessPurposeCompleted <> 'X'

Learn More