I_ProjCustSrvcOrgDetails

DDL: I_PROJCUSTSRVCORGDETAILS SQL: IPCUSTSRVORGDET Type: view COMPOSITE

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.

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 #REQUIRED 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 CustomerName
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: #REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
@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'
 
//   inner join   I_EngmntProjSrvcOrgDefValues     as CustProjSrvc    on  CustomerSalesArea.SalesOrganization   = CustProjSrvc.SalesOrganization

//                                                                    and CustomerSalesArea.DistributionChannel = CustProjSrvc.DistributionChannel

//                                                                    and CustomerSalesArea.Division            = CustProjSrvc.Division

 
  association [1..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer
{
  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,

         Customer.CustomerName                                           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