A_VMSVehicleInvoice

DDL: A_VMSVEHICLEINVOICE SQL: AVMSINVOICE Type: view COMPOSITE
24 Fields 2 Data Sources 1 Associations

Vehicle Outgoing Invoice

A_VMSVehicleInvoice is a Composite CDS View that provides data about "Vehicle Outgoing Invoice" in SAP S/4HANA. It reads from 2 data sources (I_SAPClient, I_VMSVehicleInvoice) and exposes 24 fields with key fields VMSVehicleUUID, VMSVehicleActionDateTime. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_SAPClient _SAPClient inner
I_VMSVehicleInvoice I_VMSVehicleInvoice from

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName AVMSINVOICE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Vehicle Outgoing Invoice view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL 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

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY VMSVehicleUUID VMSVehicleUUID
KEY VMSVehicleActionDateTime VMSVehicleActionDateTime
VMSVehicleActionDocType VMSVehicleActionDocType
BillingDocument BillingDocument SD Document
VMSVehicleActnDocTypeIsRvsd VMSVehicleActnDocTypeIsRvsd
CreatedByUser CreatedByUser User Name
SalesOrganization SalesOrganization Sales Organization
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCodeText CompanyCodeName Company Name
BillingDocumentDate BillingDocumentDate Billing Date
CreationDate CreationDate Time Stamp
SoldToParty SoldToParty Sold-to Party
BillingDocumentIsCancelled BillingDocumentIsCancelled Canceled
CancelledBillingDocument CancelledBillingDocument Canceld Bill.Dc
DocumentReferenceID DocumentReferenceID Reference
VMSBillingDocumentIsCancelled VMSBillingDocumentIsCancelled Canceled
BillingDocumentItem BillingDocumentItem Item
NetAmount NetAmount Stated Amount
TransactionCurrency TransactionCurrency Transaction Currency
PlantName _plant PlantName Plant Name
Plant Plant Valuation Area
BillingDocumentType BillingDocumentType Billing Type
_SalesOrganizationText _SalesOrganizationText
LogicalSystem I_SAPClient LogicalSystem Logical System

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 A_VMSVehicleInvoice.
-- 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: AVMSINVOICE

CREATE VIEW A_VMSVehicleInvoice AS
SELECT
  VMSVehicleUUID,
  VMSVehicleActionDateTime,
  VMSVehicleActionDocType,
  BillingDocument,
  VMSVehicleActnDocTypeIsRvsd,
  CreatedByUser,
  SalesOrganization,
  CompanyCode,
  _CompanyCodeText.CompanyCodeName AS CompanyCodeName,
  BillingDocumentDate,
  CreationDate,
  SoldToParty,
  BillingDocumentIsCancelled,
  CancelledBillingDocument,
  DocumentReferenceID,
  VMSBillingDocumentIsCancelled,
  BillingDocumentItem,
  NetAmount,
  TransactionCurrency,
  _plant.PlantName AS PlantName,
  Plant,
  BillingDocumentType,
  _SAPClient.LogicalSystem AS LogicalSystem
FROM I_VMSVehicleInvoice
INNER JOIN I_SAPClient AS _SAPClient ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_VMSVehicleInvoice AS _Extension ON VMSVehicleUUID = _Extension.VMSVehicleUUID AND VMSVehicleActionDateTime = _Extension.VMSVehicleActionDateTime  -- association [1..1]
;

Learn More