C_SSPSupplierInvoice

@AbapCatalog.sqlViewName: 'CSSPSUPLRINV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality:#B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@EndUserText.label: 'Self Service Procurement Supplier Invoice Document'


define view C_SSPSupplierInvoice
  as select from I_SupplierInvoice

  association to C_SSPSuplrInvcTransCat as _SSPSuplrInvcTransCat on _SSPSuplrInvcTransCat.DomainValue = $projection.SuplrInvcTransactionCategory
{
      //I_SupplierInvoice

  key SupplierInvoice,
  key FiscalYear,
      SupplierInvoiceUUID,
      //--[ GENERATED:012:GlBfhyFV7kY4u9rcrreGbG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'C_MM_CompanyCodeValueHelp',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

      CompanyCode,
      DocumentDate,
      PostingDate,
      SupplierInvoiceIDByInvcgParty,
      InvoicingParty,
      DocumentCurrency,
      //InvoiceGrossAmount,

      IsInvoice,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      case
      when IsInvoice = 'X'
      then InvoiceGrossAmount
      else -InvoiceGrossAmount
      end                              as InvoiceGrossAmount,
      UnplannedDeliveryCost,
      DocumentHeaderText,
      CreatedByUser,
      LastChangedByUser,
      ManualCashDiscount,
      PaymentTerms,
      DueCalculationBaseDate,
      CashDiscount1Percent,
      CashDiscount1Days,
      CashDiscount2Percent,
      CashDiscount2Days,
      NetPaymentDays,
      PaymentBlockingReason,
      AccountingDocumentType,
      SupplierInvoiceStatus,
      SupplierInvoiceOrigin,
      BusinessNetworkOrigin,
      ReverseDocument,
      ReverseDocumentFiscalYear,
      SuplrInvcTransactionCategory,
      SuplrInvcManuallyReducedAmount,
      SuplrInvcAutomReducedAmount,
      BPBankAccountInternalID,
      cast( ExchangeRate as kursf )    as ExchangeRate,
      StateCentralBankPaymentReason,
      SupplyingCountry,
      PaymentMethod,
      PaymentReference,
      InvoiceReference,
      InvoiceReferenceFiscalYear,
      FixedCashDiscount,
      UnplannedDeliveryCostTaxCode,
      UnplndDelivCostTaxJurisdiction,
      AssignmentReference,
      SupplierPostingLineItemText,
      TaxIsCalculatedAutomatically,
      BusinessPlace,
      PaytSlipWthRefSubscriber,
      PaytSlipWthRefCheckDigit,
      PaytSlipWthRefReference,
      IsEndOfPurposeBlocked,
      _SSPSuplrInvcTransCat.DomainText as ProcessFlowDynamicNodeTitle,
      _SSPSuplrInvcTransCat.DomainText as ProcessFlowNodeShortTitle,
      _AmountSplit,
      _BlockingRecord,
      @Consumption.hidden: true
      _CompanyCode,
      _CreatedByUser,
      _Currency,
      _FiscalYear,
      _PaymentTerms,
      _SelectedBillOfLadings,
      _SelectedDeliveryNotes,
      _SelectedPurchaseOrders,      
      _Supplier,
      _SupplierInvoiceItemAsset,
      _SupplierInvoiceItemGLAcct,
      _SupplierInvoiceItemMaterial,
      _SupplierInvoiceItemPurOrdRef,
      _SupplierInvoiceTax,
      _WithholdingTax

}