I_VMSVehicleInvoiceBasic

DDL: I_VMSVEHICLEINVOICEBASIC SQL: IVMSVEHINVBASIC Type: view BASIC
20 Fields 3 Data Sources

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.

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 Vehicle GUID
KEY VMSVehicleActionDateTime tstmp Time Stamp
VMSVehicleActionDocType actdoctype Action Document Type
BillingDocument vbeln SD Sched. Agmt
VMSVehicleActnDocTypeIsRvsd revflag Indicator
CreatedByUser ernam User Name
VMSVehicleBatch I_VMSVehicle VMSVehicleBatch Chargeable Proc.
SalesOrganization I_BillingDocumentBasic SalesOrganization Sales Organization
CompanyCode I_BillingDocumentBasic CompanyCode Receiver Company Code
BillingDocumentDate I_BillingDocumentBasic BillingDocumentDate Billing Date
CreationDate I_BillingDocumentBasic CreationDate Time Stamp
SoldToParty I_BillingDocumentBasic SoldToParty Sold-to Party
SDDocumentCategory I_BillingDocumentBasic SDDocumentCategory Document Cat.
BillingDocumentIsCancelled I_BillingDocumentBasic BillingDocumentIsCancelled Canceled
CancelledBillingDocument I_BillingDocumentBasic CancelledBillingDocument Canceld Bill.Dc
DocumentReferenceID I_BillingDocumentBasic DocumentReferenceID Reference
BillingDocumentType I_BillingDocumentBasic BillingDocumentType Billing Type
_SalesOrganization _SalesOrganization
_CompanyCode _CompanyCode
_SoldToParty _SoldToParty

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_VMSVehicleInvoiceBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IVMSVEHINVBASIC

CREATE VIEW I_VMSVehicleInvoiceBasic AS
SELECT
  vguid AS VMSVehicleUUID,
  tstmp AS VMSVehicleActionDateTime,
  actdoctype AS VMSVehicleActionDocType,
  vbeln AS BillingDocument,
  revflag AS VMSVehicleActnDocTypeIsRvsd,
  ernam AS CreatedByUser,
  _VMSVehicle.VMSVehicleBatch AS VMSVehicleBatch,
  _BILLINGDOCUMENTBASIC.SalesOrganization AS SalesOrganization,
  _BILLINGDOCUMENTBASIC.CompanyCode AS CompanyCode,
  _BILLINGDOCUMENTBASIC.BillingDocumentDate AS BillingDocumentDate,
  _BILLINGDOCUMENTBASIC.CreationDate AS CreationDate,
  _BILLINGDOCUMENTBASIC.SoldToParty AS SoldToParty,
  _BILLINGDOCUMENTBASIC.SDDocumentCategory AS SDDocumentCategory,
  _BILLINGDOCUMENTBASIC.BillingDocumentIsCancelled AS BillingDocumentIsCancelled,
  _BILLINGDOCUMENTBASIC.CancelledBillingDocument AS CancelledBillingDocument,
  _BILLINGDOCUMENTBASIC.DocumentReferenceID AS DocumentReferenceID,
  _BILLINGDOCUMENTBASIC.BillingDocumentType AS BillingDocumentType
FROM vlcinvoice
INNER JOIN I_VMSVehicle AS _VMSVehicle ON /* join condition not captured in parsed metadata */
INNER JOIN I_BillingDocumentBasic AS _BILLINGDOCUMENTBASIC ON /* join condition not captured in parsed metadata */
;

Learn More