P_EngmntProjIntcoCostCtrVH

@AbapCatalog.sqlViewName: 'PEPINTCOCSTCNTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #A
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_EngmntProjIntcoCostCtrVH
  as select distinct from   I_EngmntProjServiceOrgDetails  as a
    inner join              I_CompanyCode                  as b on b.CompanyCode = a.EngmntProjectCompanyCode
    inner join              I_CompanyCode                  as c on b.CompanyCode != c.CompanyCode
                                                                or b.CompanyCode = c.CompanyCode
    inner join              I_EngmntProjServiceOrgDetails  as d on  c.CompanyCode                   = d.EngmntProjectCompanyCode
                                                                and d.EngmtProjServiceOrgIsDelivery = 'X'
    inner join              I_EngagementProjectSrvcOrgDets as e on  d.EngagementProjectServiceOrg = e.EngagementProjectServiceOrg
                                                                and e.AssignedOrganisationType    = 'CS'
    inner join              I_CostCenter                   as f on  c.CompanyCode                = f.CompanyCode
                                                                and d.EngagementProjectCtrlgArea = f.ControllingArea
                                                                and e.AssignedOrganisation       = f.CostCenter
    left outer to many join C_IntcoPostgAllwdSndrRcvr      as g on  b.CompanyCode = g.ReceiverCompanyCode
                                                                and c.CompanyCode = g.SenderCompanyCode
{
  key a.EngagementProjectServiceOrg,
  key a.EngmntProjectCompanyCode,
  key c.CompanyCode,
  key f.CostCenter,
  key f.ValidityEndDate,
      f.ValidityStartDate,
      f.ControllingArea,
      c.CompanyCodeName,
      cast(case
      when g.SenderCompanyCode is not initial or b.CompanyCode = c.CompanyCode  then 'X'
      else   '' end as fco_ico_post_all_allowed )       as IntcoPostgIsAllowed,
      f._ControllingArea,
      f._Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_INTCOPOSTGALLWDSNDRRCVR",
"I_COMPANYCODE",
"I_COSTCENTER",
"I_ENGAGEMENTPROJECTSRVCORGDETS",
"I_ENGMNTPROJSERVICEORGDETAILS"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_COSTCENTERTEXT"
],
"BASE":
[
"I_COSTCENTER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/