I_DigitalVehicleQuotationItem

DDL: I_DIGITALVEHICLEQUOTATIONITEM Type: view_entity COMPOSITE
36 Fields 1 Data Sources 6 Associations

Quotation

I_DigitalVehicleQuotationItem is a Composite CDS View that provides data about "Quotation" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItem) and exposes 36 fields with key fields SalesDocument, SalesDocumentItem. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentItem _SalesDocumentItem from

Associations (6)

CardinalityTargetAliasCondition
[1..1] I_VMSVehicle _VMSVehicle _VMSVehicle.VMSVehicleBatch = _SalesDocumentItem.Batch and _SalesDocumentItem.Batch is not initial
[1..1] I_SalesDocument _SalesDocument _SalesDocument.SalesDocument = _SalesDocumentItem.SalesDocument
[1..1] I_BusinessPartner _BusinessPartner _BusinessPartner.BusinessPartner = $projection.SoldToParty
[1..1] I_Customer _CustomerBillTo _CustomerBillTo.Customer = $projection.BillToParty
[1..1] I_Customer _CustomerShipTo _CustomerShipTo.Customer = $projection.ShipToParty
[1..1] I_Customer _CustomerPayer _CustomerPayer.Customer = $projection.PayerParty

Annotations (9)

NameValueLevelField
EndUserText.label Quotation view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument I_SalesDocumentItem SalesDocument SD Document
KEY SalesDocumentItem I_SalesDocumentItem SalesDocumentItem Sales Document Item
Batch I_SalesDocumentItem Batch Lot No.
VMSVehicleUUID _VMSVehicle VMSVehicleUUID
ConfigurationNumber I_SalesDocumentItem ProductConfiguration Object Number
Plant I_SalesDocumentItem Plant Valuation Area
Material I_SalesDocumentItem Material Vehicle Model
SoldToParty I_SalesDocumentItem SoldToParty Sold-to Party
BillToPartyName _CustomerBillTo CustomerName Name of Customer
ShipToPartyName _CustomerShipTo CustomerName Name of Customer
PayerPartyName _CustomerPayer CustomerName Name of Customer
BillToParty I_SalesDocumentItem BillToParty Inv. Recipient
PayerParty I_SalesDocumentItem PayerParty Payer
ShipToParty I_SalesDocumentItem ShipToParty Ship-To Party (obsolete)
CreationDate _SalesDocument CreationDate Time Stamp
SalesDocumentDate _SalesDocument SalesDocumentDate Document Date
SalesOrganization _SalesDocument SalesOrganization Sales Organization
DistributionChannel _SalesDocument DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesDocument OrganizationDivision Org. Division
TotalNetAmount _SalesDocument TotalNetAmount Total Net Amount
TransactionCurrency _SalesDocument TransactionCurrency Transaction Currency
OverallSDProcessStatus _SalesDocument OverallSDProcessStatus
SalesOrderType _SalesDocument SalesDocumentType Sales Doc. Type
BindingPeriodValidityStartDate _SalesDocument BindingPeriodValidityStartDate
BindingPeriodValidityEndDate _SalesDocument BindingPeriodValidityEndDate Binding Period
RequestedDeliveryDate _SalesDocument RequestedDeliveryDate Requested Delivery Date
SDDocumentReason _SalesDocument SDDocumentReason Order Reason
PurchaseOrderByCustomer _SalesDocument PurchaseOrderByCustomer Purchase Order Number
SDDocumentCategory _SalesDocument SDDocumentCategory Document Cat.
RequestedQuantity I_SalesDocumentItem RequestedQuantity Requested Quantity
RequestedQuantityUnit I_SalesDocumentItem RequestedQuantityUnit Requested Quantity Unit
DigitalVehicleReferenceID _VMSVehicle DigitalVehicleReferenceID Digital.Veh.Ref
_BusinessPartner _BusinessPartner
_CustomerPayer _CustomerPayer
_CustomerShipTo _CustomerShipTo
_CustomerBillTo _CustomerBillTo

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_DigitalVehicleQuotationItem.
-- 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_DigitalVehicleQuotationItem AS
SELECT
  _SalesDocumentItem.SalesDocument AS SalesDocument,
  _SalesDocumentItem.SalesDocumentItem AS SalesDocumentItem,
  _SalesDocumentItem.Batch AS Batch,
  _VMSVehicle.VMSVehicleUUID AS VMSVehicleUUID,
  _SalesDocumentItem.ProductConfiguration AS ConfigurationNumber,
  _SalesDocumentItem.Plant AS Plant,
  _SalesDocumentItem.Material AS Material,
  _SalesDocumentItem.SoldToParty AS SoldToParty,
  _CustomerBillTo.CustomerName AS BillToPartyName,
  _CustomerShipTo.CustomerName AS ShipToPartyName,
  _CustomerPayer.CustomerName AS PayerPartyName,
  _SalesDocumentItem.BillToParty AS BillToParty,
  _SalesDocumentItem.PayerParty AS PayerParty,
  _SalesDocumentItem.ShipToParty AS ShipToParty,
  _SalesDocument.CreationDate AS CreationDate,
  _SalesDocument.SalesDocumentDate AS SalesDocumentDate,
  _SalesDocument.SalesOrganization AS SalesOrganization,
  _SalesDocument.DistributionChannel AS DistributionChannel,
  _SalesDocument.OrganizationDivision AS OrganizationDivision,
  _SalesDocument.TotalNetAmount AS TotalNetAmount,
  _SalesDocument.TransactionCurrency AS TransactionCurrency,
  _SalesDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
  _SalesDocument.SalesDocumentType AS SalesOrderType,
  _SalesDocument.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  _SalesDocument.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  _SalesDocument.RequestedDeliveryDate AS RequestedDeliveryDate,
  _SalesDocument.SDDocumentReason AS SDDocumentReason,
  _SalesDocument.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  _SalesDocumentItem.RequestedQuantity AS RequestedQuantity,
  _SalesDocumentItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  _VMSVehicle.DigitalVehicleReferenceID AS DigitalVehicleReferenceID
FROM I_SalesDocumentItem AS _SalesDocumentItem
LEFT OUTER JOIN I_VMSVehicle AS _VMSVehicle ON _VMSVehicle.VMSVehicleBatch = _SalesDocumentItem.Batch AND _SalesDocumentItem.Batch is not initial  -- association [1..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON _SalesDocument.SalesDocument = _SalesDocumentItem.SalesDocument  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = SoldToParty  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _CustomerBillTo ON _CustomerBillTo.Customer = BillToParty  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _CustomerShipTo ON _CustomerShipTo.Customer = ShipToParty  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _CustomerPayer ON _CustomerPayer.Customer = PayerParty  -- association [1..1]
;

Learn More