P_EngmntProjIntcoCoCode

@AbapCatalog.sqlViewName: 'PEPINTCOCC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #A
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_EngmntProjIntcoCoCode
  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 c.CompanyCode != b.CompanyCode
                                                               or c.CompanyCode = b.CompanyCode
    inner join              I_EngmntProjServiceOrgDetails as d on  c.CompanyCode                   = d.EngmntProjectCompanyCode
                                                               and d.EngmtProjServiceOrgIsDelivery = 'X'
    left outer to many join C_IntcoPostgAllwdSndrRcvr     as f on  b.CompanyCode = f.ReceiverCompanyCode
                                                               and c.CompanyCode = f.SenderCompanyCode


{
  key a.EngagementProjectServiceOrg,
  key a.EngmntProjectCompanyCode,
  key c.CompanyCode,
      c.CompanyCodeName,
      cast(case
      when f.SenderCompanyCode is not initial or b.CompanyCode = c.CompanyCode then 'X'
      else   '' end as fco_ico_post_all_allowed )       as IntcoPostgIsAllowed
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_INTCOPOSTGALLWDSNDRRCVR",
"I_COMPANYCODE",
"I_ENGMNTPROJSERVICEORGDETAILS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/