I_VMSVehicleOpenSalesOrder

DDL: I_VMSVEHICLEOPENSALESORDER Type: view_entity COMPOSITE
28 Fields 2 Data Sources 1 Associations

VMS Vehicle Open Sales Order

I_VMSVehicleOpenSalesOrder is a Composite CDS View that provides data about "VMS Vehicle Open Sales Order" in SAP S/4HANA. It reads from 2 data sources (I_VMSVehicleSalesOrder, P_VMSVehLatestSalesOrder) and exposes 28 fields with key field VMSVehicleUUID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_VMSVehicleSalesOrder _VMSVehicleSalesOrder from
P_VMSVehLatestSalesOrder _VMSVehLatestSalesOrder inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartnerCustomer _BusinessPartnerCustomer $projection.SoldToParty = _BusinessPartnerCustomer.Customer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
EndUserText.label VMS Vehicle Open Sales Order view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY VMSVehicleUUID I_VMSVehicleSalesOrder VMSVehicleUUID Vehicle GUID
VMSVehicleActionDateTime I_VMSVehicleSalesOrder VMSVehicleActionDateTime Time Stamp
VMSVehicleActionDocType I_VMSVehicleSalesOrder VMSVehicleActionDocType Action Document Type
SalesOrder I_VMSVehicleSalesOrder SalesOrder SD Document
SalesOrderItem I_VMSVehicleSalesOrder SalesOrderItem Sales Order Item
CreatedByUserName I_VMSVehicleSalesOrder CreatedByUserName Person Resp.
PurchasingDocReferenceByCust I_VMSVehicleSalesOrder PurchasingDocReferenceByCust Cust. Reference
SoldToParty I_VMSVehicleSalesOrder SoldToParty Sold-to Party
CostCenter I_VMSVehicleSalesOrder CostCenter Cost Center
SalesOrganization I_VMSVehicleSalesOrder SalesOrganization Sales Organization
DistributionChannel I_VMSVehicleSalesOrder DistributionChannel RefDistCh-Cust/Mat.
Plant I_VMSVehicleSalesOrder Plant Valuation Area
OrganizationDivision I_VMSVehicleSalesOrder OrganizationDivision Org. Division
OverallSDProcessStatus I_VMSVehicleSalesOrder OverallSDProcessStatus
SalesGroup I_VMSVehicleSalesOrder SalesGroup Sales Group
SalesOffice I_VMSVehicleSalesOrder SalesOffice Sales Office
SalesOrderDate I_VMSVehicleSalesOrder SalesOrderDate Document Date
NetAmount I_VMSVehicleSalesOrder NetAmount Stated Amount
SalesDocumentCurrency I_VMSVehicleSalesOrder SalesDocumentCurrency Currency
SalesOrderType I_VMSVehicleSalesOrder SalesOrderType Sales Order Type
RequestedDeliveryDate I_VMSVehicleSalesOrder RequestedDeliveryDate Requested Delivery Date
CreatedByUser I_VMSVehicleSalesOrder CreatedByUser User Name
CreationDate I_VMSVehicleSalesOrder CreationDate Time Stamp
Division I_VMSVehicleSalesOrder Division Internal Division ID
ProductConfiguration I_VMSVehicleSalesOrder ProductConfiguration
Batch I_VMSVehicleSalesOrder Batch Lot No.
Material I_VMSVehicleSalesOrder Material Vehicle Model
_BusinessPartnerCustomer _BusinessPartnerCustomer

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_VMSVehicleOpenSalesOrder.
-- 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.

CREATE VIEW I_VMSVehicleOpenSalesOrder AS
SELECT
  _VMSVehicleSalesOrder.VMSVehicleUUID AS VMSVehicleUUID,
  _VMSVehicleSalesOrder.VMSVehicleActionDateTime AS VMSVehicleActionDateTime,
  _VMSVehicleSalesOrder.VMSVehicleActionDocType AS VMSVehicleActionDocType,
  _VMSVehicleSalesOrder.SalesOrder AS SalesOrder,
  _VMSVehicleSalesOrder.SalesOrderItem AS SalesOrderItem,
  _VMSVehicleSalesOrder.CreatedByUserName AS CreatedByUserName,
  _VMSVehicleSalesOrder.PurchasingDocReferenceByCust AS PurchasingDocReferenceByCust,
  _VMSVehicleSalesOrder.SoldToParty AS SoldToParty,
  _VMSVehicleSalesOrder.CostCenter AS CostCenter,
  _VMSVehicleSalesOrder.SalesOrganization AS SalesOrganization,
  _VMSVehicleSalesOrder.DistributionChannel AS DistributionChannel,
  _VMSVehicleSalesOrder.Plant AS Plant,
  _VMSVehicleSalesOrder.OrganizationDivision AS OrganizationDivision,
  _VMSVehicleSalesOrder.OverallSDProcessStatus AS OverallSDProcessStatus,
  _VMSVehicleSalesOrder.SalesGroup AS SalesGroup,
  _VMSVehicleSalesOrder.SalesOffice AS SalesOffice,
  _VMSVehicleSalesOrder.SalesOrderDate AS SalesOrderDate,
  _VMSVehicleSalesOrder.NetAmount AS NetAmount,
  _VMSVehicleSalesOrder.SalesDocumentCurrency AS SalesDocumentCurrency,
  _VMSVehicleSalesOrder.SalesOrderType AS SalesOrderType,
  _VMSVehicleSalesOrder.RequestedDeliveryDate AS RequestedDeliveryDate,
  _VMSVehicleSalesOrder.CreatedByUser AS CreatedByUser,
  _VMSVehicleSalesOrder.CreationDate AS CreationDate,
  _VMSVehicleSalesOrder.Division AS Division,
  _VMSVehicleSalesOrder.ProductConfiguration AS ProductConfiguration,
  _VMSVehicleSalesOrder.Batch AS Batch,
  _VMSVehicleSalesOrder.Material AS Material
FROM I_VMSVehicleSalesOrder AS _VMSVehicleSalesOrder
INNER JOIN P_VMSVehLatestSalesOrder AS _VMSVehLatestSalesOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartnerCustomer AS _BusinessPartnerCustomer ON SoldToParty = _BusinessPartnerCustomer.Customer  -- association [0..1]
;

Learn More