C_VMSVehMonitorCreditStatus

DDL: C_VMSVEHMONITORCREDITSTATUS Type: view_entity CONSUMPTION
35 Fields 2 Data Sources 1 OData Services

VMSVehicle Monitor Credit Status

C_VMSVehMonitorCreditStatus is a Consumption CDS View that provides data about "VMSVehicle Monitor Credit Status" in SAP S/4HANA. It reads from 2 data sources (R_VMSVehicleTP, I_VMSVehicleOpenSalesOrder) and exposes 35 fields with key field VMSVehicleUUID. It is exposed through 1 OData service (UI_VMSVEHMONITORCREDITSTATUS).

Data Sources (2)

SourceAliasJoin Type
R_VMSVehicleTP _VMSVehicle from
I_VMSVehicleOpenSalesOrder _VMSVehicleSalesOrder inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label VMSVehicle Monitor Credit Status view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Consumption.ranked true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_VMSVEHMONITORCREDITSTATUS UI_VMSVEHMONITORCREDITSTATUS V4 C1 NOT_RELEASED

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY VMSVehicleUUID R_VMSVehicleTP VMSVehicleUUID
VMSVehicleInternalID R_VMSVehicleTP VMSVehicleInternalID
VehicleIdentificationNumber R_VMSVehicleTP VehicleIdentificationNumber VIN
VMSVehicleExternalID R_VMSVehicleTP VMSVehicleExternalID
VMSVehicleBatch R_VMSVehicleTP VMSVehicleBatch
Material R_VMSVehicleTP Material Vehicle Model
Plant R_VMSVehicleTP Plant Valuation Area
StorageLocation R_VMSVehicleTP StorageLocation StorageLocation
ValuationType R_VMSVehicleTP ValuationType Valuation Type
ConfigurationNumber R_VMSVehicleTP ConfigurationNumber Int. object no.
VMSVehicleConfdDelivDateTime R_VMSVehicleTP VMSVehicleConfdDelivDateTime
VMSVehicleProductionDateTime R_VMSVehicleTP VMSVehicleProductionDateTime
VMSVehiclePlndDelivDateTime R_VMSVehicleTP VMSVehiclePlndDelivDateTime
VMSVehicleIsArchived R_VMSVehicleTP VMSVehicleIsArchived
VMSVehicleAvailabilityStatus R_VMSVehicleTP VMSVehicleAvailabilityStatus
VMSVehicleCustomer R_VMSVehicleTP VMSVehicleCustomer
VMSVehicleEndCustomer R_VMSVehicleTP VMSVehicleEndCustomer
CreatedByUserName R_VMSVehicleTP CreatedByUserName Person Resp.
VMSVehicleSearchArea R_VMSVehicleTP VMSVehicleSearchArea
VMSVehicleOrderingParty R_VMSVehicleTP VMSVehicleOrderingParty
VMSVehicleModelVariant R_VMSVehicleTP VMSVehicleModelVariant
ReferenceVendor R_VMSVehicleTP ReferenceVendor
VMSVehiclePrimaryStatus R_VMSVehicleTP VMSVehiclePrimaryStatus
VMSVehiclePrimaryStatusText
VMSVehicleSecondaryStatus R_VMSVehicleTP VMSVehicleSecondaryStatus
VMSVehicleSecondaryStatusText
SalesOrder I_VMSVehicleOpenSalesOrder SalesOrder SD Document
_Customer R_VMSVehicleTP _Customer
_OrderingParty R_VMSVehicleTP _OrderingParty
_Partner R_VMSVehicleTP _Partner
_Supplier R_VMSVehicleTP _Supplier
_VMSVehicleB2CSales R_VMSVehicleTP _VMSVehicleB2CSales
_VMSVehicleConfig _VMSVehicleConfig
_VMSVehicleAdditionalData _VMSVehicleAdditionalData
_VMSVehicleHistory _VMSVehicleHistory

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 C_VMSVehMonitorCreditStatus.
-- 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 C_VMSVehMonitorCreditStatus AS
SELECT
  _VMSVehicle.VMSVehicleUUID AS VMSVehicleUUID,
  _VMSVehicle.VMSVehicleInternalID AS VMSVehicleInternalID,
  _VMSVehicle.VehicleIdentificationNumber AS VehicleIdentificationNumber,
  _VMSVehicle.VMSVehicleExternalID AS VMSVehicleExternalID,
  _VMSVehicle.VMSVehicleBatch AS VMSVehicleBatch,
  _VMSVehicle.Material AS Material,
  _VMSVehicle.Plant AS Plant,
  _VMSVehicle.StorageLocation AS StorageLocation,
  _VMSVehicle.ValuationType AS ValuationType,
  _VMSVehicle.ConfigurationNumber AS ConfigurationNumber,
  _VMSVehicle.VMSVehicleConfdDelivDateTime AS VMSVehicleConfdDelivDateTime,
  _VMSVehicle.VMSVehicleProductionDateTime AS VMSVehicleProductionDateTime,
  _VMSVehicle.VMSVehiclePlndDelivDateTime AS VMSVehiclePlndDelivDateTime,
  _VMSVehicle.VMSVehicleIsArchived AS VMSVehicleIsArchived,
  _VMSVehicle.VMSVehicleAvailabilityStatus AS VMSVehicleAvailabilityStatus,
  _VMSVehicle.VMSVehicleCustomer AS VMSVehicleCustomer,
  _VMSVehicle.VMSVehicleEndCustomer AS VMSVehicleEndCustomer,
  _VMSVehicle.CreatedByUserName AS CreatedByUserName,
  _VMSVehicle.VMSVehicleSearchArea AS VMSVehicleSearchArea,
  _VMSVehicle.VMSVehicleOrderingParty AS VMSVehicleOrderingParty,
  _VMSVehicle.VMSVehicleModelVariant AS VMSVehicleModelVariant,
  _VMSVehicle.ReferenceVendor AS ReferenceVendor,
  _VMSVehicle.VMSVehiclePrimaryStatus AS VMSVehiclePrimaryStatus,
  _VMSVehicle._VMSVehiclePrimaryStsTxt[1:Language = $session.system_language].VMSVehicleStatusText AS VMSVehiclePrimaryStatusText,
  _VMSVehicle.VMSVehicleSecondaryStatus AS VMSVehicleSecondaryStatus,
  _VMSVehicle._VMSVehicleSecondaryStsTxt[1:Language = $session.system_language].VMSVehicleStatusText AS VMSVehicleSecondaryStatusText,
  _VMSVehicleSalesOrder.SalesOrder AS SalesOrder,
  _VMSVehicle._Customer AS _Customer,
  _VMSVehicle._OrderingParty AS _OrderingParty,
  _VMSVehicle._Partner AS _Partner,
  _VMSVehicle._Supplier AS _Supplier,
  _VMSVehicle._VMSVehicleB2CSales AS _VMSVehicleB2CSales
FROM R_VMSVehicleTP AS _VMSVehicle
INNER JOIN I_VMSVehicleOpenSalesOrder AS _VMSVehicleSalesOrder ON /* join condition not captured in parsed metadata */
;

Learn More