P_GRIRPROCESS

@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PFIGRIRPROCESS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.representativeKey: 'PurchasingDocumentItem'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true 

@Search.searchable: false
@ObjectModel.compositionRoot: true
@ObjectModel.entityChangeStateId: 'GRIRClearingProcessStatus'

define view P_GRIRProcess as select from fins_grirproc

association[1]      to I_CompanyCode             as _CompanyCode               on $projection.CompanyCode                   = _CompanyCode.CompanyCode
association[1]      to I_PurchasingDocument      as _PurchasingDocument        on $projection.PurchasingDocument            = _PurchasingDocument.PurchasingDocument
association[1]      to I_PurchasingDocumentItem  as _PurchasingDocumentItem    on $projection.PurchasingDocument            = _PurchasingDocumentItem.PurchasingDocument and
                                                                                  $projection.PurchasingDocumentItem        = _PurchasingDocumentItem.PurchasingDocumentItem 
association[0..1]   to I_GRIRProcessStatus       as _GRIRProcessStatus         on $projection.GRIRClearingProcessStatus     = _GRIRProcessStatus.GRIRClearingProcessStatus
association[0..1]   to I_GRIRProcessStatus       as _GRIRPrpsdStatus           on $projection.GRIRClrgProcessPrpsdStatus    = _GRIRPrpsdStatus.GRIRClearingProcessStatus
association[1]      to I_GRIRProcessPriority     as _GRIRProcessPriority       on $projection.GRIRClearingProcessPriority   = _GRIRProcessPriority.GRIRClearingProcessPriority
association[1]      to I_GRIRProcessPriority     as _GRIRClrgProcPrpsdPriority on $projection.GRIRClrgProcPrpsdPriority     = _GRIRClrgProcPrpsdPriority.GRIRClearingProcessPriority
association[0..1]   to I_GRIRProcessRootCause    as _GRIRProcessRootCause      on $projection.GRIRClearingProcessRootCause  = _GRIRProcessRootCause.GRIRClearingProcessRootCause
association[0..1]   to I_GRIRProcessRootCause    as _GRIRProcessPrpsdRootCause on $projection.GRIRClrgProcessPrpsdRootCause = _GRIRProcessPrpsdRootCause.GRIRClearingProcessRootCause

{
    @ObjectModel.foreignKey.association: '_CompanyCode'
    key fins_grirproc.companycode                as CompanyCode,
    @ObjectModel.foreignKey.association: '_PurchasingDocument'
    key fins_grirproc.purchasingdocument         as PurchasingDocument,
    key fins_grirproc.purchasingdocumentitem     as PurchasingDocumentItem,
    fins_grirproc.lastchangedatetime             as LastChangeDateTime,
    fins_grirproc.lastchangedbyuser              as LastChangedByUser,
    fins_grirproc.responsibledepartment          as ResponsibleDepartment,
    fins_grirproc.responsibleperson              as ResponsiblePerson,
    fins_grirproc.grirclearingprocessstatus      as GRIRClearingProcessStatus,
    fins_grirproc.grirclearingprocesspriority    as GRIRClearingProcessPriority,
    fins_grirproc.hasnote                        as HasNote,
    fins_grirproc.note                           as Note,
    fins_grirproc.systemmessageidentification    as SystemMessageIdentification,
    fins_grirproc.systemmessagetype              as SystemMessageType,
    fins_grirproc.systemmessagenumber            as SystemMessageNumber,
    fins_grirproc.systemmessagevariable1         as SystemMessageVariable1,
    fins_grirproc.systemmessagevariable2         as SystemMessageVariable2,
    fins_grirproc.systemmessagevariable3         as SystemMessageVariable3,
    fins_grirproc.systemmessagevariable4         as SystemMessageVariable4,
    fins_grirproc.systemmessagetext              as SystemMessageText,
    fins_grirproc.grirclearingprocessrootcause   as GRIRClearingProcessRootCause,
    fins_grirproc.prpsdresponsibledepartment     as PrpsdResponsibleDepartment,
    fins_grirproc.proposedresponsibleperson      as ProposedResponsiblePerson,
    fins_grirproc.grirclrgprocessprpsdstatus     as GRIRClrgProcessPrpsdStatus,
    fins_grirproc.grirclrgprocprpsdpriority      as GRIRClrgProcPrpsdPriority,
    fins_grirproc.grirclrgprocessprpsdrootcause  as GRIRClrgProcessPrpsdRootCause,    
    fins_grirproc.prpsdrespdeptmaxclprobability  as PrpsdRespDeptMaxClProbability,
    fins_grirproc.prpsdresppersonmaxclassproblty as PrpsdRespPersonMaxClassProblty,
    fins_grirproc.grirproposedstatusmaxclproblty as GRIRProposedStatusMaxClProblty,
    fins_grirproc.grirproposedpriomaxclproblty   as GRIRProposedPrioMaxClProblty,
    fins_grirproc.grirprpsdrootcausemaxclproblty as GRIRPrpsdRootCauseMaxClProblty,
    fins_grirproc.grirprocprpsllastchangedtetime as GRIRProcPrpslLastChangeDteTime,
    

    case 
        when fins_grirproc.lastchangedatetime <> 0
            then cast( cast( substring( cast( fins_grirproc.lastchangedatetime as abap.char(17) ), 1, 8 ) as abap.dats ) as fis_aufaedat preserving type)
        else
            cast( cast( '00000000' as abap.dats ) as fis_aufaedat preserving type)
    end as LastChangeDate,
   
    
    
    _CompanyCode,
    _PurchasingDocument,
    _PurchasingDocumentItem,
    _GRIRProcessStatus,
    _GRIRPrpsdStatus,
    _GRIRProcessPriority,
    _GRIRClrgProcPrpsdPriority,
    _GRIRProcessRootCause,
    _GRIRProcessPrpsdRootCause
}