I_ProjCustSrvcOrgDetails

DDL: I_PROJCUSTSRVCORGDETAILS SQL: IPCUSTSRVORGDET Type: view COMPOSITE Package: CPD_CDS

Customer Service Organisation Details

I_ProjCustSrvcOrgDetails is a Composite CDS View that provides data about "Customer Service Organisation Details" in SAP S/4HANA. It reads from 3 data sources (I_Customer, I_CustomerSalesArea, I_EngagementProjectSrvcOrgDets) and exposes 12 fields with key fields Customer, CustomerProjectServiceOrg, SalesOrganization, DistributionChannel, Division. It has 1 association to related views. Part of development package CPD_CDS.

3 data source(s) 12 fields

Data Sources (3)

SourceAliasJoin Type
I_Customer Customer from
I_CustomerSalesArea CustomerSalesArea inner
I_EngagementProjectSrvcOrgDets CustProjSrvc inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPCUSTSRVORGDET view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Customer Service Organisation Details view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Customer I_Customer Customer
KEY CustomerProjectServiceOrg I_EngagementProjectSrvcOrgDets EngagementProjectServiceOrg
KEY SalesOrganization I_CustomerSalesArea SalesOrganization
KEY DistributionChannel I_CustomerSalesArea DistributionChannel
KEY Division I_CustomerSalesArea Division
CustomerName I_Customer BPCustomerName
OrganizationBPName1 I_Customer OrganizationBPName1
OrganizationBPName2 I_Customer OrganizationBPName2
Currency I_CustomerSalesArea Currency
CustomerAccountGroup I_Customer CustomerAccountGroup
AuthorizationGroup I_Customer AuthorizationGroup
_Customer _Customer 
@AbapCatalog.sqlViewName: 'IPCUSTSRVORGDET'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER

@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

@EndUserText.label: 'Customer Service Organisation Details'
define view I_ProjCustSrvcOrgDetails as select from I_Customer                     as Customer

    inner join   I_CustomerSalesArea            as CustomerSalesArea on Customer.Customer = CustomerSalesArea.Customer
    inner join   I_EngagementProjectSrvcOrgDets as CustProjSrvc      on  CustomerSalesArea.SalesOrganization   = CustProjSrvc.AssignedOrganisation

                                                                    and CustProjSrvc.AssignedOrganisationType = 'SO'
  association [1..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
{
  @ObjectModel.text.element: ['CustomerName']
  key    Customer.Customer                                               as Customer,
  key    CustProjSrvc.EngagementProjectServiceOrg                        as CustomerProjectServiceOrg,
  key    CustomerSalesArea.SalesOrganization                             as SalesOrganization,
  key    CustomerSalesArea.DistributionChannel                           as DistributionChannel,
  key    CustomerSalesArea.Division                                      as Division,
         
         @Semantics.text:true
         Customer.BPCustomerName                                         as CustomerName,
         Customer.OrganizationBPName1                                    as OrganizationBPName1,
         Customer.OrganizationBPName2                                    as OrganizationBPName2,
         CustomerSalesArea.Currency                                      as Currency,
         Customer.CustomerAccountGroup                                   as CustomerAccountGroup,
         Customer.AuthorizationGroup                                     as AuthorizationGroup,

         //Association for DCL

         
         _Customer
         
}
where
  Customer.IsBusinessPurposeCompleted <> 'X'

Learn More