I_VMSVEHICLEINCOMINGINVOICE

CDS View

View for vehicle incoming Invoice

I_VMSVEHICLEINCOMINGINVOICE is a CDS View in S/4HANA. View for vehicle incoming Invoice. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_VMSVehicleIncomingInvoice view from COMPOSITE Vehicle Incoming Invoice 
@AbapCatalog.sqlViewName: 'IVMSINCINVOICE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'View for vehicle incoming Invoice'
@ObjectModel.usageType.serviceQuality : #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass : #TRANSACTIONAL
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view I_VMSVehicleIncomingInvoice
  as select from vlcincinvoice
 inner join I_VMSVehicle as _VMSVehicle on _VMSVehicle.VMSVehicleUUID = vlcincinvoice.vguid
  association [1..1] to I_SupplierInvoice              as _SUPPLIERINVOICE on  _SUPPLIERINVOICE.SupplierInvoice = vlcincinvoice.belnr
                                                                           and _SUPPLIERINVOICE.FiscalYear      = vlcincinvoice.gjahr
  association [1..*] to I_SupplierInvoiceItemPurOrdRef as _DocumentItem    on  _DocumentItem.SupplierInvoice        = $projection.RefAccountingDocument
                                                                          and _DocumentItem.InventoryValuationType = $projection.VMSVehicleBatch
                                                                           and _DocumentItem.FiscalYear             = $projection.InputFiscalYear
  association [1..1] to E_VMSVehicleIncomingInvoice    as _Extension       on  $projection.VMSVehicleUUID           = _Extension.VMSVehicleUUID
                                                                           and $projection.VMSVehicleActionDateTime = _Extension.VMSVehicleActionDateTime
{
  key vguid                                 as VMSVehicleUUID,
  key tstmp                                 as VMSVehicleActionDateTime,
      actdoctype                            as VMSVehicleActionDocType,
      belnr                                 as RefAccountingDocument,
      gjahr                                 as InputFiscalYear,
      _DocumentItem.SupplierInvoiceItem,
      xblnr                                 as DocumentReferenceID,
      ernam                                 as SuplrInvcExtCreatedByUser,
      revflag                               as VehActionDocTypeIsReversed,
      _VMSVehicle.VMSVehicleBatch,
      _SUPPLIERINVOICE.DocumentDate,
      _SUPPLIERINVOICE.CompanyCode,
      _SUPPLIERINVOICE.SuplrInvcTransactionCategory,
      case _SUPPLIERINVOICE.SuplrInvcTransactionCategory
      when 'RS' then 'X'
      when 'RD' then ''
      end                                   as SupplierInvoiceIsCancelled,
      case when _SUPPLIERINVOICE.SuplrInvcTransactionCategory = 'RS' then
       _SUPPLIERINVOICE.ReverseDocument end as ReverseDocument,
      _SUPPLIERINVOICE.PostingDate,
      @Semantics.currencyCode: true
      _SUPPLIERINVOICE.DocumentCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      _DocumentItem.SupplierInvoiceItemAmount,
      _SUPPLIERINVOICE.InvoicingParty,
      _SUPPLIERINVOICE._CompanyCode,
      _SUPPLIERINVOICE._Currency,
      _SUPPLIERINVOICE.IsEndOfPurposeBlocked

}

Learn More