I_VMSVehicleB2CSalesOrdAssign

DDL: I_VMSVEHICLEB2CSALESORDASSIGN Type: view_entity BASIC
36 Fields 2 Data Sources

VMS Sales Order Assigned details

I_VMSVehicleB2CSalesOrdAssign is a Basic CDS View that provides data about "VMS Sales Order Assigned details" in SAP S/4HANA. It reads from 2 data sources (I_VMSVehicle, I_VMSVehicleSalesOrder) and exposes 36 fields with key fields SalesOrder, SalesOrderItem.

Data Sources (2)

SourceAliasJoin Type
I_VMSVehicle _vehi inner
I_VMSVehicleSalesOrder _vehiSales from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label VMS Sales Order Assigned details view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_VMSVehicleSalesOrder SalesOrder SD Document
KEY SalesOrderItem I_VMSVehicleSalesOrder SalesOrderItem Sales Order Item
VMSVehicleUUID I_VMSVehicle VMSVehicleUUID Vehicle GUID
SoldToParty I_VMSVehicleSalesOrder SoldToParty Sold-to Party
VMSVehicleModel I_VMSVehicle Material Vehicle Model
Plant I_VMSVehicleSalesOrder Plant Valuation Area
Batch I_VMSVehicleSalesOrder Batch Lot No.
VMSVehicleBatch I_VMSVehicle VMSVehicleBatch Chargeable Proc.
SalesOrganization I_VMSVehicleSalesOrder SalesOrganization Sales Organization
RequestedDeliveryDate I_VMSVehicleSalesOrder RequestedDeliveryDate Requested Delivery Date
NetAmount I_VMSVehicleSalesOrder NetAmount Stated Amount
TransactionCurrency I_VMSVehicleSalesOrder SalesDocumentCurrency Currency
CreatedByUser I_VMSVehicleSalesOrder CreatedByUser User Name
CreationDate I_VMSVehicleSalesOrder CreationDate Time Stamp
DistributionChannel I_VMSVehicleSalesOrder DistributionChannel RefDistCh-Cust/Mat.
Division I_VMSVehicleSalesOrder Division Internal Division ID
OrganizationDivision I_VMSVehicleSalesOrder OrganizationDivision Org. Division
ProductConfiguration I_VMSVehicleSalesOrder ProductConfiguration
SalesOrderDate I_VMSVehicleSalesOrder SalesOrderDate Document Date
SalesOrderType I_VMSVehicleSalesOrder SalesOrderType Sales Order Type
VMSVehicleInternalID I_VMSVehicle VMSVehicleInternalID Int. Veh. No.
VMSVehicleModelVariant I_VMSVehicle VMSVehicleModelVariant
ConfigurationNumber I_VMSVehicle ConfigurationNumber Int. object no.
VehicleIdentificationNumber I_VMSVehicle VehicleIdentificationNumber VIN
Material I_VMSVehicleSalesOrder Material Vehicle Model
_Batch I_VMSVehicleSalesOrder _Batch
_CreatedByUser I_VMSVehicleSalesOrder _CreatedByUser
_DistributionChannel I_VMSVehicleSalesOrder _DistributionChannel
_Division I_VMSVehicleSalesOrder _Division
_Material I_VMSVehicleSalesOrder _Material
_OrganizationDivision I_VMSVehicleSalesOrder _OrganizationDivision
_Plant I_VMSVehicleSalesOrder _Plant
_SalesOrderType I_VMSVehicleSalesOrder _SalesOrderType
_SalesOrganization I_VMSVehicleSalesOrder _SalesOrganization
_SoldToParty I_VMSVehicleSalesOrder _SoldToParty
_TransactionCurrency I_VMSVehicleSalesOrder _TransactionCurrency

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_VMSVehicleB2CSalesOrdAssign.
-- 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_VMSVehicleB2CSalesOrdAssign AS
SELECT
  _vehiSales.SalesOrder AS SalesOrder,
  _vehiSales.SalesOrderItem AS SalesOrderItem,
  _vehi.VMSVehicleUUID AS VMSVehicleUUID,
  _vehiSales.SoldToParty AS SoldToParty,
  _vehi.Material AS VMSVehicleModel,
  _vehiSales.Plant AS Plant,
  _vehiSales.Batch AS Batch,
  _vehi.VMSVehicleBatch AS VMSVehicleBatch,
  _vehiSales.SalesOrganization AS SalesOrganization,
  _vehiSales.RequestedDeliveryDate AS RequestedDeliveryDate,
  _vehiSales.NetAmount AS NetAmount,
  _vehiSales.SalesDocumentCurrency AS TransactionCurrency,
  _vehiSales.CreatedByUser AS CreatedByUser,
  _vehiSales.CreationDate AS CreationDate,
  _vehiSales.DistributionChannel AS DistributionChannel,
  _vehiSales.Division AS Division,
  _vehiSales.OrganizationDivision AS OrganizationDivision,
  _vehiSales.ProductConfiguration AS ProductConfiguration,
  _vehiSales.SalesOrderDate AS SalesOrderDate,
  _vehiSales.SalesOrderType AS SalesOrderType,
  _vehi.VMSVehicleInternalID AS VMSVehicleInternalID,
  _vehi.VMSVehicleModelVariant AS VMSVehicleModelVariant,
  _vehi.ConfigurationNumber AS ConfigurationNumber,
  _vehi.VehicleIdentificationNumber AS VehicleIdentificationNumber,
  _vehiSales.Material AS Material,
  _vehiSales._Batch AS _Batch,
  _vehiSales._CreatedByUser AS _CreatedByUser,
  _vehiSales._DistributionChannel AS _DistributionChannel,
  _vehiSales._Division AS _Division,
  _vehiSales._Material AS _Material,
  _vehiSales._OrganizationDivision AS _OrganizationDivision,
  _vehiSales._Plant AS _Plant,
  _vehiSales._SalesOrderType AS _SalesOrderType,
  _vehiSales._SalesOrganization AS _SalesOrganization,
  _vehiSales._SoldToParty AS _SoldToParty,
  _vehiSales._TransactionCurrency AS _TransactionCurrency
FROM I_VMSVehicleSalesOrder AS _vehiSales
INNER JOIN I_VMSVehicle AS _vehi ON /* join condition not captured in parsed metadata */
;

Learn More