I_DocSingleWorkflowInfo

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IDOCSINGLEWFINFO'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.representativeKey: 'AccountingDocument'
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'one document to single workflow'

@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_DocSingleWorkflowInfo
  as select from I_DocWorkflowInfo as _DocWorkflowInfo
  //    left outer join I_DocLatestWorkflow as _DocLatestWorkflow on  _DocLatestWorkflow.ObjectKey       = _DocWorkflowInfo.ObjectKey

  //                                                              and _DocLatestWorkflow.ReleaseDateTime = _DocWorkflowInfo.ReleaseDateTime

  association [0..1] to I_WorkflowToObject         as _WorkflowToObject on  $projection.ObjectKey = _WorkflowToObject.ObjectKey
  association [1..1] to I_CompanyCode              as _CompanyCode      on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_FiscalYearForCompanyCode as _FiscalYear       on  $projection.FiscalYear  = _FiscalYear.FiscalYear
                                                                        and $projection.CompanyCode = _FiscalYear.CompanyCode
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
  key AccountingDocument,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key FiscalYear,
      AccountingDocumentType,
      ReferenceDocument,
      DocumentDate,
      FiscalPeriod,
      LastChangeDate,
      LedgerGroup,
      HeaderDescription,
      PostingDate,

      CreationDateTime,
      AccountingDocumentCreationDate,
      //RequisitionerName,

      //Processor,

      _DocWorkflowInfo.ObjectKey,
      //    TCODE(6) = FBDC_P

      //    PPTCODE(6) = FBDC_P

      //    can not use tcode directly, maybe in the future we will have more parked documents

      TransactionCode,
      ParkingTransactionCode,
      Currency,
      CompanyCodeCurrency,
      GlobalCurrency,
      FreeDefinedCurrency1,
      AccountingDocumentCategory,
      AccountingDocumentStatus,
      /*    comment by i337033
            enable currency adjustment workflow
            case AccountingDocumentCategory
            when 'Z' then 'D'
            when ''  then 'P'
            else AccountingDocumentStatus
            end                           as AccountingDocumentStatus,*/

      cast ( _DocWorkflowInfo.Workflow as sww_wiid )                    as Workflow,
      case AccountingDocumentStatus
      when 'P'
      then _WorkflowToObject.WorkflowTaskInternalID
      else  WorkItem
      end                                                               as WorkItem,
      TaskProcessingStatus,

      case AccountingDocumentCategory
      when 'V' //still a prak

      then _DocWorkflowInfo.CreatedByUser
      when 'Z'  // entry deleted, only parked document can be deleted

      //    change from CE2008

      //    new logic

      //    after parked document deleted, BKPF-USNAM = deleted by

      //    BKPF-PPNAM = submitted by

      then _DocWorkflowInfo.ParkedByUser
      //      then _DocWorkflowInfo.CreatedByUser

      else _DocWorkflowInfo.ParkedByUser //posted dcoument

      end                                                               as ParkedByUser,
      //      case AccountingDocumentStatus

      //      when 'A' then ( case AccountingDocumentCategory

      //                      when 'Z' then _DocWorkflowInfo.CreatedByUser

      //                      else _DocWorkflowInfo.ParkedByUser end )

      //      else _DocWorkflowInfo.CreatedByUser

      //      end                           as ParkedByUser,


      case AccountingDocumentCategory
      when 'V' then '' //parked document

      when 'Z' then ' '
      else _DocWorkflowInfo.CreatedByUser
      end                                                               as CreatedByUser,
      //      case AccountingDocumentStatus

      //      when 'A' then (case AccountingDocumentCategory

      //                     when 'Z' then ''

      //                     else _DocWorkflowInfo.CreatedByUser end )

      //      when 'P'  then _DocWorkflowInfo.CreatedByUser

      //      else ''

      //      end                           as CreatedByUser,

      _DocWorkflowInfo.Batch,
      cast(_DocWorkflowInfo.IntercompanyTransaction as fac_inter_trans) as IntercompanyTransaction,

      // auto reversal

      ReversalReason,
      PlannedReversalDate,

      _CompanyCode,
      _FiscalYear,
      _WorkflowToObject
}
where
     _DocWorkflowInfo.ObjectKey is not null
  or _DocWorkflowInfo.Workflow  is null