I_ProjectChangeDocuments

@AbapCatalog: {
          sqlViewName: 'IPROJCHGDOC',
          compiler.compareFilter: true,
          preserveKey: true
          }

@AccessControl: {
    authorizationCheck: #CHECK
    }
@EndUserText.label: 'Change document for Project data'

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM: {
   viewType: #BASIC,
   lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@ObjectModel: {
    compositionRoot: true,

    usageType: {
        serviceQuality: #C,
        sizeCategory : #XL,
        dataClass: #TRANSACTIONAL
    },
    supportedCapabilities: [ #SQL_DATA_SOURCE, #EXTRACTION_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
}

@Analytics: {
    dataCategory: #FACT,
    dataExtraction: {
        enabled: true
    }
 }
@Metadata.ignorePropagatedAnnotations:true
define view I_ProjectChangeDocuments
  as select from           I_ProjectData_2                                                                             as proj
    inner join             I_ChangeDocument                                                                            as cdhdr        on  cdhdr.ChangeDocObject      = proj.ProjectInternalID
                                                                                                                                       and cdhdr.ChangeDocObjectClass = 'PROJ'
    inner join             I_ChangeDocumentItem                                                                        as cdpos        on  cdpos.ChangeDocObject = proj.ProjectInternalID
                                                                                                                                       and cdpos.ChangeDocument  = cdhdr.ChangeDocument
                                                                                                                                       and (
                                                                                                                                          cdpos.DatabaseTable    = 'PROJ'
                                                                                                                                        )
    left outer to one join P_ProjectFieldMappingForChgDoc( p_tabname: 'I_PROJECTDATA_2' , p_viewname:'IPROJECTDATA2' ) as FieldmapProj on FieldmapProj.DDICName = cdpos.ChangeDocDatabaseTableField

  // DPP Changes

  // Person in Responsible for Project

  association [0..1] to I_ProjectResponsiblePerson as _ResponsiblePerson on $projection.ResponsiblePerson = _ResponsiblePerson.ResponsiblePerson
  // Project Applicant

  association [0..1] to I_ProjectApplicant         as _ProjectApplicant  on $projection.ApplicantCode = _ProjectApplicant.ApplicantCode
  // WBS Element

  association [0..*] to I_WBSElementData_2         as _WBSElement        on $projection.ProjectInternalID = _WBSElement.ProjectInternalID

{
  key cdhdr.ChangeDocObject             as ChangeDocObject,

  key cdhdr.ChangeDocObjectClass        as ChangeDocObjectClass,

  key cdpos.ChangeDocument              as ChangeDocument,
  key cdpos.DatabaseTable               as DatabaseTable,
  key cdpos.ChangeDocTableKey           as ChangeDocTableKey,
      // Field Name

  key cdpos.ChangeDocDatabaseTableField as ChangeDocDatabaseTableField,

      // Change Indicator

  key cdpos.ChangeDocItemChangeType     as ChangeDocItemChangeType,
  key proj.ProjectInternalID            as ProjectInternalID,

      proj.ProjectExternalID            as ProjectExternalID,

      FieldmapProj.GFNName              as ChangeDocGlobalFieldName,

      @Semantics.text: true
      proj.ProjectDescription           as ProjectDescription,

      @Consumption.hidden: true
      proj.ControllingArea              as ControllingArea,

      @Consumption.hidden: true
      proj.ProfitCenter                 as ProfitCenter,

      @Consumption.hidden: true
      proj.ResponsiblePerson            as ResponsiblePerson,

      @Consumption.hidden: true
      proj.ApplicantCode                as ApplicantCode,

      cdpos.ChangeDocPreviousUnit       as ChangeDocPreviousUnit,

      cdpos.ChangeDocNewUnit            as ChangeDocNewUnit,

      cdpos.ChangeDocPreviousCurrency   as ChangeDocPreviousCurrency,

      cdpos.ChangeDocNewCurrency        as ChangeDocNewCurrency,

      // Old Value

      @EndUserText.label: 'Old Value'
      cdpos.ChangeDocPreviousFieldValue as ChangeDocumentOldFieldValue,

      // New Value

      @EndUserText.label: 'New Value'
      cdpos.ChangeDocNewFieldValue      as ChangeDocumentNewFieldValue,

      // Changed By

      cdhdr.CreatedByUser               as LastChangedByUser,

      // Separate Date

      // LastChangedDate needed for Smart Filter Bar

      @Semantics.systemDate.createdAt: true
      cdhdr.CreationDate                as LastChangeDate,

      // Separate Time

      // LastChangeTime needed for sorting

      @Semantics.systemTime.createdAt: true
      cdhdr.CreationTime                as LastChangeTime,

      //Associations

      @Consumption.hidden: true
      proj._ControllingArea             as _ControllingArea,

      @Consumption.hidden: true
      proj._ProfitCenter                as _ProfitCenter,

      @Consumption.hidden: true
      _ResponsiblePerson,
      @Consumption.hidden: true
      _ProjectApplicant,
      @Consumption.hidden: true
      _WBSElement

}
where
      cdhdr.ChangeDocObjectClass = 'PROJ'
  and cdpos.ChangeDocObjectClass = 'PROJ'
  and cdpos.DatabaseTable        = 'PROJ'