I_DigitalVehiclePurOrderItem

DDL: I_DIGITALVEHICLEPURORDERITEM Type: view_entity COMPOSITE
25 Fields 4 Data Sources 2 Associations

Vehicle Purchase Order

I_DigitalVehiclePurOrderItem is a Composite CDS View that provides data about "Vehicle Purchase Order" in SAP S/4HANA. It reads from 4 data sources (I_PurchasingDocument, I_PurchasingDocumentItem, I_PurgDocScheduleLine, I_VMSVehicle) and exposes 25 fields with key fields PurchasingDocument, PurchaseOrderItem. It has 2 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_PurchasingDocument _PurchasingDocument inner
I_PurchasingDocumentItem _PurchasingDocumentItem inner
I_PurgDocScheduleLine _PurgDocScheduleLine inner
I_VMSVehicle _VMSVehicle from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner _BusinessPartner.BusinessPartner = $projection.Supplier
[1..1] I_DigitalVehPurOrdConfign _DigitalVehPurOrdConfign _DigitalVehPurOrdConfign.PurchasingDocument = $projection.PurchasingDocument and _DigitalVehPurOrdConfign.PurchaseOrderItem = $projection.PurchaseOrderItem

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Vehicle Purchase Order view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchaseOrderItem I_PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
VMSVehicleUUID I_VMSVehicle VMSVehicleUUID Vehicle GUID
VMSVehicleBatch I_VMSVehicle VMSVehicleBatch Chargeable Proc.
PurchaseOrderType I_PurchasingDocument PurchasingDocumentType RFQ Type
PurchaseOrderDate I_PurchasingDocument CreationDate Time Stamp
Supplier I_PurchasingDocument Supplier Supplier
CompanyCode I_PurchasingDocument CompanyCode Receiver Company Code
CompanyCodeName
PurchasingOrganization I_PurchasingDocument PurchasingOrganization Purchasing Organization
PurchasingOrganizationName
PurchasingGroup I_PurchasingDocument PurchasingGroup Purchasing Group
PurchasingGroupName
ScheduleLineDeliveryDate I_PurgDocScheduleLine ScheduleLineDeliveryDate Delivery Date
Plant I_PurchasingDocumentItem Plant Valuation Area
PlantName _plant PlantName Plant Name
Material I_PurchasingDocumentItem Material Vehicle Model
PurchaseOrderQuantityUnit I_PurchasingDocumentItem OrderQuantityUnit Sales Unit
OrderQuantity I_PurchasingDocumentItem OrderQuantity Quantity
NetPriceAmount I_PurchasingDocumentItem NetPriceAmount Net Price
DocumentCurrency I_PurchasingDocumentItem DocumentCurrency Document Currency
TaxCode I_PurchasingDocumentItem TaxCode Tax Code
ConfigurationNumber _DigitalVehPurOrdConfign ConfigurationNumber Int. object no.
DigitalVehicleReferenceID I_VMSVehicle DigitalVehicleReferenceID Digital.Veh.Ref
_BusinessPartner _BusinessPartner

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_DigitalVehiclePurOrderItem.
-- 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_DigitalVehiclePurOrderItem AS
SELECT
  _PurchasingDocument.PurchasingDocument AS PurchasingDocument,
  _PurchasingDocumentItem.PurchasingDocumentItem AS PurchaseOrderItem,
  _VMSVehicle.VMSVehicleUUID AS VMSVehicleUUID,
  _VMSVehicle.VMSVehicleBatch AS VMSVehicleBatch,
  _PurchasingDocument.PurchasingDocumentType AS PurchaseOrderType,
  _PurchasingDocument.CreationDate AS PurchaseOrderDate,
  _PurchasingDocument.Supplier AS Supplier,
  _PurchasingDocument.CompanyCode AS CompanyCode,
  _PurchasingDocument._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingDocument._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  _PurchasingDocument._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _PurgDocScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _PurchasingDocumentItem.Plant AS Plant,
  _plant.PlantName AS PlantName,
  _PurchasingDocumentItem.Material AS Material,
  _PurchasingDocumentItem.OrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _PurchasingDocumentItem.OrderQuantity AS OrderQuantity,
  _PurchasingDocumentItem.NetPriceAmount AS NetPriceAmount,
  _PurchasingDocumentItem.DocumentCurrency AS DocumentCurrency,
  _PurchasingDocumentItem.TaxCode AS TaxCode,
  _DigitalVehPurOrdConfign.ConfigurationNumber AS ConfigurationNumber,
  _VMSVehicle.DigitalVehicleReferenceID AS DigitalVehicleReferenceID
FROM I_VMSVehicle AS _VMSVehicle
INNER JOIN I_PurgDocScheduleLine AS _PurgDocScheduleLine ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchasingDocument AS _PurchasingDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = Supplier  -- association [1..1]
LEFT OUTER JOIN I_DigitalVehPurOrdConfign AS _DigitalVehPurOrdConfign ON _DigitalVehPurOrdConfign.PurchasingDocument = PurchasingDocument AND _DigitalVehPurOrdConfign.PurchaseOrderItem = PurchaseOrderItem  -- association [1..1]
;

Learn More