A_DigitalVehQuotationItem_2

DDL: A_DIGITALVEHQUOTATIONITEM_2 Type: view_entity CONSUMPTION
34 Fields 1 Data Sources 4 Associations 1 OData Services

Vehicle Quotation

A_DigitalVehQuotationItem_2 is a Consumption CDS View that provides data about "Vehicle Quotation" in SAP S/4HANA. It reads from 1 data source (R_DigitalVehQuotationItemTP_2) and exposes 34 fields with key fields SalesQuotation, SalesQuotationItem. It has 4 associations to related views. It is exposed through 1 OData service (API_DIGITALVEHQUOTATION).

Data Sources (1)

SourceAliasJoin Type
R_DigitalVehQuotationItemTP_2 R_DigitalVehQuotationItemTP_2 projection

Associations (4)

CardinalityTargetAliasCondition
[1..1] A_Customer _CustomerSoldTo _CustomerSoldTo.Customer = $projection.SoldToParty
[1..1] A_Customer _CustomerBillTo _CustomerBillTo.Customer = $projection.BillToParty
[1..1] A_Customer _CustomerShipTo _CustomerShipTo.Customer = $projection.ShipToParty
[1..1] A_Customer _CustomerPayer _CustomerPayer.Customer = $projection.PayerParty

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Vehicle Quotation view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name DigitalVehQuotationItem_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_DIGITALVEHQUOTATION API_DIGITALVEHQUOTATION V4 C2 C1

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation SalesDocument SD Document
KEY SalesQuotationItem SalesDocumentItem Sales Document Item
VMSVehicleUUID VMSVehicleUUID
Batch Batch Lot No.
Plant Plant Valuation Area
Material Material Vehicle Model
ConfigurationNumber ConfigurationNumber Int. object no.
SoldToParty SoldToParty Sold-to Party
SoldToPartyName SoldToPartyName Sold-to Party Name
BillToParty BillToParty Inv. Recipient
BillToPartyName BillToPartyName
PayerParty PayerParty Payer
PayerPartyName PayerPartyName
ShipToParty ShipToParty Ship-To Party (obsolete)
ShipToPartyName ShipToPartyName Ship-To Party Name
CreationDate CreationDate Time Stamp
SalesQuotationDate SalesDocumentDate Document Date
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
DivisionNameasDivisionNamelocalized
SalesOrderType SalesOrderType Sales Order Type
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
BindingPeriodValidityStartDate BindingPeriodValidityStartDate
BindingPeriodValidityEndDate BindingPeriodValidityEndDate Binding Period
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
RequestedQuantity RequestedQuantity Requested Quantity
RequestedQuantityUnit RequestedQuantityUnit Requested Quantity Unit
_CustomerShipTo _CustomerShipTo
_CustomerSoldTo _CustomerSoldTo
_CustomerBillTo _CustomerBillTo
_CustomerPayer _CustomerPayer

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_DigitalVehQuotationItem_2.
-- 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 A_DigitalVehQuotationItem_2 AS
SELECT
  SalesDocument AS SalesQuotation,
  SalesDocumentItem AS SalesQuotationItem,
  VMSVehicleUUID,
  Batch,
  Plant,
  Material,
  ConfigurationNumber,
  SoldToParty,
  SoldToPartyName,
  BillToParty,
  BillToPartyName,
  PayerParty,
  PayerPartyName,
  ShipToParty,
  ShipToPartyName,
  CreationDate,
  SalesDocumentDate AS SalesQuotationDate,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  _DivisionText.DivisionName as DivisionName : localized AS DivisionNameasDivisionNamelocalized,
  SalesOrderType,
  TotalNetAmount,
  TransactionCurrency,
  BindingPeriodValidityStartDate,
  BindingPeriodValidityEndDate,
  RequestedDeliveryDate,
  PurchaseOrderByCustomer,
  RequestedQuantity,
  RequestedQuantityUnit
FROM R_DigitalVehQuotationItemTP_2
LEFT OUTER JOIN A_Customer AS _CustomerSoldTo ON _CustomerSoldTo.Customer = SoldToParty  -- association [1..1]
LEFT OUTER JOIN A_Customer AS _CustomerBillTo ON _CustomerBillTo.Customer = BillToParty  -- association [1..1]
LEFT OUTER JOIN A_Customer AS _CustomerShipTo ON _CustomerShipTo.Customer = ShipToParty  -- association [1..1]
LEFT OUTER JOIN A_Customer AS _CustomerPayer ON _CustomerPayer.Customer = PayerParty  -- association [1..1]
;

Learn More