I_VMSVehicleInvoiceBasic

DDL: I_VMSVEHICLEINVOICEBASIC SQL: IVMSVEHINVBASIC Type: view BASIC

Vehicle Invoice

I_VMSVehicleInvoiceBasic is a Basic CDS View that provides data about "Vehicle Invoice" in SAP S/4HANA. It reads from 3 data sources (I_BillingDocumentBasic, I_VMSVehicle, vlcinvoice) and exposes 20 fields with key fields VMSVehicleUUID, VMSVehicleActionDateTime.

3 data source(s) 20 fields

Data Sources (3)

SourceAliasJoin Type
I_BillingDocumentBasic _BILLINGDOCUMENTBASIC inner
I_VMSVehicle _VMSVehicle inner
vlcinvoice vlcinvoice from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IVMSVEHINVBASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Vehicle Invoice view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY VMSVehicleUUID vguid
KEY VMSVehicleActionDateTime tstmp
VMSVehicleActionDocType actdoctype
BillingDocument vbeln
VMSVehicleActnDocTypeIsRvsd revflag
CreatedByUser ernam
VMSVehicleBatch I_VMSVehicle VMSVehicleBatch
SalesOrganization I_BillingDocumentBasic SalesOrganization
CompanyCode I_BillingDocumentBasic CompanyCode
BillingDocumentDate I_BillingDocumentBasic BillingDocumentDate
CreationDate I_BillingDocumentBasic CreationDate
SoldToParty I_BillingDocumentBasic SoldToParty
SDDocumentCategory I_BillingDocumentBasic SDDocumentCategory
BillingDocumentIsCancelled I_BillingDocumentBasic BillingDocumentIsCancelled
CancelledBillingDocument I_BillingDocumentBasic CancelledBillingDocument
DocumentReferenceID I_BillingDocumentBasic DocumentReferenceID
BillingDocumentType I_BillingDocumentBasic BillingDocumentType
_SalesOrganization _SalesOrganization
_CompanyCode _CompanyCode
_SoldToParty _SoldToParty 
@AbapCatalog.sqlViewName: 'IVMSVEHINVBASIC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Vehicle Invoice'
@ObjectModel.usageType.serviceQuality : #C
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass : #TRANSACTIONAL
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view I_VMSVehicleInvoiceBasic
  as select from vlcinvoice
    inner join   I_VMSVehicle           as _VMSVehicle           on vlcinvoice.vguid = _VMSVehicle.VMSVehicleUUID
    inner join   I_BillingDocumentBasic as _BILLINGDOCUMENTBASIC on _BILLINGDOCUMENTBASIC.BillingDocument = vlcinvoice.vbeln
{
  key vguid      as VMSVehicleUUID,
  key tstmp      as VMSVehicleActionDateTime,
      actdoctype as VMSVehicleActionDocType,
      vbeln      as BillingDocument,
      revflag    as VMSVehicleActnDocTypeIsRvsd,
      ernam      as CreatedByUser,
      _VMSVehicle.VMSVehicleBatch,
      _BILLINGDOCUMENTBASIC.SalesOrganization,
      _BILLINGDOCUMENTBASIC.CompanyCode,
      _BILLINGDOCUMENTBASIC.BillingDocumentDate,
      _BILLINGDOCUMENTBASIC.CreationDate,
      _BILLINGDOCUMENTBASIC.SoldToParty,
      _BILLINGDOCUMENTBASIC.SDDocumentCategory,
      _BILLINGDOCUMENTBASIC.BillingDocumentIsCancelled,
      _BILLINGDOCUMENTBASIC.CancelledBillingDocument,
      _BILLINGDOCUMENTBASIC.DocumentReferenceID ,
      _BILLINGDOCUMENTBASIC.BillingDocumentType,  
      _SalesOrganization,
      _CompanyCode,
      _SoldToParty
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTBASIC",
"I_VMSVEHICLE",
"VLCINVOICE"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CUSTOMER",
"I_SALESORGANIZATION"
],
"BASE":
[
"I_BILLINGDOCUMENTBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More