FAC_AUDIT_Z3_PROJECT

@AbapCatalog.sqlViewName: 'FAC_AUDPROJECT'
@EndUserText.label: 'Project'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL

define view FAC_AUDIT_Z3_PROJECT
  as select from I_ProjectBasicData as _ProjectBasic

  association [1..1] to proj as _Project on $projection.ProjectInternalID = _Project.pspnr

{
  key _ProjectBasic.ProjectInternalID           as ProjectInternalID,
      @EndUserText.label: 'System Client'
      $session.client                           as SystemClient,
      _ProjectBasic.Project                     as Project,
      _ProjectBasic.ProjectDescription          as ProjectDescription,
      _Project.ernam                            as CreatedByUser,
      _Project.erdat                            as CreationDate,
      _Project.aenam                            as LastChangedByUser,
      _Project.aedat                            as LastChangeDate,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      _ProjectBasic.CompanyCode                 as CompanyCode,
      _Project.vgsbr                            as BusinessArea,
      @ObjectModel.foreignKey.association: '_ControllingArea'
      _ProjectBasic.ControllingArea             as ControllingArea,
      @ObjectModel.foreignKey.association: '_ProfitCenter2'
      _ProjectBasic.ProfitCenter                as ProfitCenter,
      _ProjectBasic.PlannedStartDate            as PlannedStartDate,
      _ProjectBasic.PlannedEndDate              as PlannedEndDate,
      _Project.werks                            as Plant,
      _Project.kalid                            as FactoryCalendar,
      _ProjectBasic.ProjectProfileCode          as ProjectProfileCode,
      _Project.bprof                            as BudgetProfile,
      _Project.logsystem                        as LogicalSystem,
      _Project.cpd_updat                        as UpdateTimestamp,
      _ProjectBasic.AvailabilityControlProfile  as AvailabilityControlProfile,
      _ProjectBasic.AvailabilityControlIsActive as AvailabilityControlIsActive,
      _ProjectBasic.ProjectCurrency             as ProjectCurrency,

      _Project,
      _CompanyCode,
      _ControllingArea,
      _ProfitCenter2
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBASICDATA",
"PROJ"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_PROFITCENTER",
"PROJ"
],
"BASE":
[
"I_PROJECTBASICDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/