C_CustProjCustSrvcOrgDetails

DDL: C_CUSTPROJCUSTSRVCORGDETAILS SQL: CCPCUSTSRVDET Type: view CONSUMPTION Package: CPD_CDS

Customer Project Service Organisation Details For Customer

C_CustProjCustSrvcOrgDetails is a Consumption CDS View that provides data about "Customer Project Service Organisation Details For Customer" 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 (9)

NameValueLevelField
AbapCatalog.sqlViewName CCPCUSTSRVDET view
EndUserText.label Customer Project Service Organisation Details For Customer view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED 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: 'CCPCUSTSRVDET'
@EndUserText.label: 'Customer Project Service Organisation Details For Customer'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.personalData.blocking: #REQUIRED

@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view C_CustProjCustSrvcOrgDetails
  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
{
  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