I_EngmntProjSrvcOrgDefValues

@AbapCatalog.sqlViewName: 'IEPSRVCORGDEFLT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.lifecycle.status: #DEPRECATED
@EndUserText.label: 'Engmt Proj Service Org default Values'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING
/* As of 2302 release, this view is deprecated. Please do not use this view. */

define view I_EngmntProjSrvcOrgDefValues 
//as select from  /cpd/pwsc_orgpid

//  association [0..1] to I_EngagementProjectSrvcOrg as _EngagementProjectServiceOrg on $projection.EngagementProjectServiceOrg = _EngagementProjectServiceOrg.EngagementProjectServiceOrg

 as select from I_EngagementProjectSrvcOrg as _EngagementProjectServiceOrg
  association [0..1] to I_EngagementProjectSrvcOrgDets as _CompanyCode                  on  $projection.EngagementProjectServiceOrg    = _CompanyCode.EngagementProjectServiceOrg
                                                                                        and _CompanyCode.AssignedOrganisationIsDefault = 'X'
                                                                                        and _CompanyCode.AssignedOrganisationType      = 'CC'
                                                                                        
  association [0..1] to I_EngagementProjectSrvcOrgDets as _ControllingArea              on  $projection.EngagementProjectServiceOrg        = _ControllingArea.EngagementProjectServiceOrg
                                                                                        and _ControllingArea.AssignedOrganisationIsDefault = 'X'
                                                                                        and _ControllingArea.AssignedOrganisationType      = 'CA'
                                                                                        
 association [0..1] to I_EngagementProjectSrvcOrgDets as _SaleOrganization              on  $projection.EngagementProjectServiceOrg        = _SaleOrganization.EngagementProjectServiceOrg
                                                                                        and _SaleOrganization.AssignedOrganisationIsDefault = 'X'
                                                                                        and _SaleOrganization.AssignedOrganisationType      = 'SO'
                                                                                        
 association [0..1] to I_EngagementProjectSrvcOrgDets as _DistributionChannel           on  $projection.EngagementProjectServiceOrg        = _DistributionChannel.EngagementProjectServiceOrg
                                                                                        and _DistributionChannel.AssignedOrganisationIsDefault = 'X'
                                                                                        and _DistributionChannel.AssignedOrganisationType      = 'SC'
 association [0..1] to I_EngagementProjectSrvcOrgDets as _Division                      on  $projection.EngagementProjectServiceOrg        = _Division.EngagementProjectServiceOrg
                                                                                        and _Division.AssignedOrganisationIsDefault = 'X'
                                                                                        and _Division.AssignedOrganisationType      = 'SD'
                                                                                        
 association [0..1] to I_EngagementProjectSrvcOrgDets as _PurchasingOrganization        on  $projection.EngagementProjectServiceOrg        = _PurchasingOrganization.EngagementProjectServiceOrg
                                                                                        and _PurchasingOrganization.AssignedOrganisationIsDefault = 'X'
                                                                                        and _PurchasingOrganization.AssignedOrganisationType      = 'PO'                                                                                                                                                                                                                                                                      
 
 association [0..1] to I_EngagementProjectSrvcOrgDets as _Plant                         on  $projection.EngagementProjectServiceOrg        = _Plant.EngagementProjectServiceOrg
                                                                                        and _Plant.AssignedOrganisationIsDefault = 'X'
                                                                                        and _Plant.AssignedOrganisationType      = 'PL'
                                                                                        
 association [0..1] to I_EngagementProjectSrvcOrgDets as _CostCenter                    on  $projection.EngagementProjectServiceOrg        = _CostCenter.EngagementProjectServiceOrg
                                                                                        and _CostCenter.AssignedOrganisationIsDefault = 'X'
                                                                                        and _CostCenter.AssignedOrganisationType      = 'CS'                                                                                                                                                                              
{
    key  EngagementProjectServiceOrg                    as EngagementProjectServiceOrg, //org_unit_id


 //Company Code      

 cast( _CompanyCode.AssignedOrganisation as fis_bukrs )       as CompanyCode,

//Controlling Area         

 cast( _ControllingArea.AssignedOrganisation as fis_kokrs)    as ControllingArea,
 
 //SalesOrganization      

 cast( _SaleOrganization.AssignedOrganisation as vkorg )      as SalesOrganization,
 
 //Distrbution Channel          

 cast( _DistributionChannel.AssignedOrganisation as vtweg )   as DistributionChannel,
   
 //Division            

 cast( _Division.AssignedOrganisation as spart )              as Division,
  
 //Purchasing Organization        

 cast( _PurchasingOrganization.AssignedOrganisation as ekorg) as PurchasingOrganization,
  
 //Plant         

 cast( _Plant.AssignedOrganisation as  werks_d )              as Plant,
  
//Default Cost Center      

 _CostCenter.AssignedOrganisation                             as CostCenter
 
      
      //_EngagementProjectServiceOrg

}