R_DigitalVehicleTP

DDL: R_DIGITALVEHICLETP Type: view_entity TRANSACTIONAL
18 Fields 1 Data Sources 5 Associations

Digital Vehicle

R_DigitalVehicleTP is a Transactional CDS View that provides data about "Digital Vehicle" in SAP S/4HANA. It reads from 1 data source (I_VMSVehicle) and exposes 18 fields with key field VMSVehicleUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_VMSVehicle _VMSVehicle from

Associations (5)

CardinalityTargetAliasCondition
[1..*] R_DigitalVehicleConfignTP _DigitalVehicleConfignTP
[1..*] R_DigitalVehiclePurOrderItemTP _DigitalVehiclePurOrderItemTP
[1..*] R_DigitalVehQuotationItemTP _DigitalVehQuotationItemTP
[1..*] R_DigitalVehSalesOrderItemTP _DigitalVehSalesOrderItemTP
[1..*] R_DigitalVehBillingDocItemTP _DigitalVehBillingDocItemTP

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Digital Vehicle view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name DigitalVehicle view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY VMSVehicleUUID VMSVehicleUUID Vehicle GUID
ConfigurationNumber ConfigurationNumber Int. object no.
Material Material Vehicle Model
VMSVehicleInternalID VMSVehicleInternalID Int. Veh. No.
VMSVehicleBatch VMSVehicleBatch Chargeable Proc.
DigitalVehicleReferenceID DigitalVehicleReferenceID Digital.Veh.Ref
Equipment Equipment Equipment check
Plant Plant Valuation Area
PlantName _plant PlantName Plant Name
ValuationType ValuationType Valuation Type
LogicalSystem _SAPClient LogicalSystem Logical System
VMSVehicleExternalID VMSVehicleExternalID Ext.Veh.Number
VehicleIdentificationNumber VehicleIdentificationNumber VIN
_DigitalVehicleConfignTP _DigitalVehicleConfignTP
_DigitalVehiclePurOrderItemTP _DigitalVehiclePurOrderItemTP
_DigitalVehQuotationItemTP _DigitalVehQuotationItemTP
_DigitalVehSalesOrderItemTP _DigitalVehSalesOrderItemTP
_DigitalVehBillingDocItemTP _DigitalVehBillingDocItemTP

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 R_DigitalVehicleTP.
-- 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 R_DigitalVehicleTP AS
SELECT
  VMSVehicleUUID,
  ConfigurationNumber,
  Material,
  VMSVehicleInternalID,
  VMSVehicleBatch,
  DigitalVehicleReferenceID,
  Equipment,
  Plant,
  _plant.PlantName AS PlantName,
  ValuationType,
  _SAPClient.LogicalSystem AS LogicalSystem,
  VMSVehicleExternalID,
  VehicleIdentificationNumber
FROM I_VMSVehicle AS _VMSVehicle
LEFT OUTER JOIN R_DigitalVehicleConfignTP AS _DigitalVehicleConfignTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_DigitalVehiclePurOrderItemTP AS _DigitalVehiclePurOrderItemTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_DigitalVehQuotationItemTP AS _DigitalVehQuotationItemTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_DigitalVehSalesOrderItemTP AS _DigitalVehSalesOrderItemTP ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_DigitalVehBillingDocItemTP AS _DigitalVehBillingDocItemTP ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More