A_VMSVehicleIncomingInvoice

DDL: A_VMSVEHICLEINCOMINGINVOICE SQL: AVMSVINVOICE Type: view COMPOSITE Package: ISAUTO_VLC_DB

Vehicle Incoming Invoice

A_VMSVehicleIncomingInvoice is a Composite CDS View that provides data about "Vehicle Incoming Invoice" in SAP S/4HANA. It reads from 2 data sources (I_SAPClient, I_VMSVehicleIncomingInvoice) and exposes 20 fields with key fields VMSVehicleUUID, VMSVehicleActionDateTime. It has 1 association to related views. It is exposed through 1 OData service (API_VMSVEHICLE). Part of development package ISAUTO_VLC_DB.

2 data source(s) Exposed by 1 service(s) 20 fields

Data Sources (2)

SourceAliasJoin Type
I_SAPClient _SAPClient inner
I_VMSVehicleIncomingInvoice I_VMSVehicleIncomingInvoice from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_VMSVehicleIncomingInvoice _Extension $projection.VMSVehicleUUID = _Extension.VMSVehicleUUID and $projection.VMSVehicleActionDateTime = _Extension.VMSVehicleActionDateTime

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName AVMSVINVOICE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Vehicle Incoming Invoice view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

OData Services (1)

ServiceBindingVersionContractRelease
API_VMSVEHICLE API_VMSVEHICLE V2 C2 C1

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY VMSVehicleUUID VMSVehicleUUID
KEY VMSVehicleActionDateTime VMSVehicleActionDateTime
VMSVehicleActionDocType VMSVehicleActionDocType
RefAccountingDocument RefAccountingDocument
DocumentReferenceID DocumentReferenceID
InputFiscalYear InputFiscalYear
SupplierInvoiceItem SupplierInvoiceItem
SuplrInvcExtCreatedByUser SuplrInvcExtCreatedByUser
VehActionDocTypeIsReversed VehActionDocTypeIsReversed
DocumentDate DocumentDate
CompanyCode CompanyCode
CompanyCodeName _CompanyCodeText CompanyCodeName
SupplierInvoiceIsCancelled SupplierInvoiceIsCancelled
ReverseDocument ReverseDocument
PostingDate PostingDate
DocumentCurrency DocumentCurrency
SupplierInvoiceItemAmount SupplierInvoiceItemAmount
InvoicingParty InvoicingParty
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
LogicalSystem I_SAPClient LogicalSystem 
@AbapCatalog.sqlViewName: 'AVMSVINVOICE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Vehicle Incoming Invoice'
@ObjectModel.usageType.serviceQuality : #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass : #TRANSACTIONAL
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations:true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view A_VMSVehicleIncomingInvoice
  as select from I_VMSVehicleIncomingInvoice
    inner join   I_SAPClient as _SAPClient on _SAPClient.sapclient = $session.client
  association        to A_CompanyCode               as _CompanyCodeText on  _CompanyCodeText.CompanyCode = $projection.CompanyCode
  association [1..1] to E_VMSVehicleIncomingInvoice as _Extension       on  $projection.VMSVehicleUUID           = _Extension.VMSVehicleUUID
                                                                        and $projection.VMSVehicleActionDateTime = _Extension.VMSVehicleActionDateTime
{
  key VMSVehicleUUID,
  key VMSVehicleActionDateTime,
      VMSVehicleActionDocType,
      RefAccountingDocument,
      DocumentReferenceID,
      InputFiscalYear,
      SupplierInvoiceItem,
      SuplrInvcExtCreatedByUser,
      VehActionDocTypeIsReversed,
      DocumentDate,
      @ObjectModel.text.element: ['CompanyCodeName']
      CompanyCode,
      @Semantics.text:true
      _CompanyCodeText.CompanyCodeName,
      SupplierInvoiceIsCancelled,
      ReverseDocument,
      PostingDate,
      @Semantics.currencyCode: true
      DocumentCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      SupplierInvoiceItemAmount,
      InvoicingParty,
      @Consumption.hidden: true
      IsEndOfPurposeBlocked,
      _SAPClient.LogicalSystem

}

Learn More