P_APProcessFlowSupplierInvoice

@VDM.viewType: #COMPOSITE
@VDM.private:true
@AbapCatalog.sqlViewName: 'PAPPFLWSINV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@DataAging.noAgingRestriction: false

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_APProcessFlowSupplierInvoice
  as select from I_SupplierInvoice as supplierInvoice

  association [1..1] to I_UserContactCard as _UserContactCard on _UserContactCard.ContactCardID = $projection.CreatedByUser

{

  key supplierInvoice.SupplierInvoice               as SupplierInvoice,
  key supplierInvoice.FiscalYear                    as FiscalYear,

      //    ProcessFlow

      supplierInvoice.SupplierInvoice               as ProcessFlowNodeDocument,
      cast( '2' as vgabe )                          as ProcessFlowNodeDocCategory,

      concat(supplierInvoice.SupplierInvoice,concat('00000____',concat(supplierInvoice.FiscalYear,'1')))
                                                    as ProcessFlowNode,


      //    Additional Info

      supplierInvoice.InvoicingParty                as Supplier,
      supplierInvoice._Supplier.SupplierName        as SupplierName,
      supplierInvoice.PostingDate                   as PostingDate,
      supplierInvoice.DocumentDate                  as DocumentDate,
      supplierInvoice.PaymentBlockingReason         as PaymentBlockingReason,
      supplierInvoice.SupplierInvoiceIDByInvcgParty as SupplierInvoiceIDByInvcgParty,
      supplierInvoice.InvoiceGrossAmount            as InvoiceGrossAmount,
      supplierInvoice.DocumentCurrency              as DocumentCurrency,
      supplierInvoice.CreatedByUser                 as CreatedByUser,
      supplierInvoice.SupplierInvoiceStatus         as SupplierInvoiceStatus,
      _UserContactCard.FullName                     as FullName,
      IsInvoice,
      supplierInvoice.CompanyCode                   as CompanyCode,
      supplierInvoice._CompanyCode.CompanyCodeName  as CompanyCodeName,
      @Consumption.hidden: true
      IsEndOfPurposeBlocked,
      @Consumption.hidden: true
      _Supplier.AuthorizationGroup

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_SUPPLIER",
"I_SUPPLIERINVOICE",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[
"I_USERCONTACTCARD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/