I_VMSVehicle

@AbapCatalog.sqlViewName: 'IVMSVEH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Vehicle Details'
@ObjectModel.usageType.serviceQuality : #C
@ObjectModel.usageType.sizeCategory : #XXL
@ObjectModel.usageType.dataClass : #TRANSACTIONAL
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view I_VMSVehicle
  as select from vlcvehicle
  association        to vlc_vehdvhmodel          as _Vehdvhmodel            on  vlcvehicle.matnr = _Vehdvhmodel.vehicle_model
  association [1..1] to E_VMSVehicle             as _Extension              on  _Extension.VMSVehicleUUID = $projection.VMSVehicleUUID
  association [1..1] to I_Customer               as _Customer               on  $projection.VMSVehicleCustomer = _Customer.Customer
  association [1..1] to I_Customer               as _OrderingParty          on  $projection.VMSVehicleOrderingParty = _OrderingParty.Customer
  association [1..1] to I_Supplier               as _Supplier               on  $projection.ReferenceVendor = _Supplier.Supplier
  association [1..1] to I_BusinessPartner        as _Partner                on  $projection.VMSVehicleEndCustomer = _Partner.BusinessPartner
                                                                    
{
  key vguid                  as VMSVehicleUUID,
      matnr                  as Material,
      _Vehdvhmodel.dvh_model as VMSDigitalVehicleHubModel,
      vhcle                  as VMSVehicleInternalID,
      lifnr                  as ReferenceVendor,
      charg                  as VMSVehicleBatch,
      equnr                  as Equipment,
      cuaba                  as VMSVehicleActionDocType,
      werks                  as Plant,
      lgort                  as StorageLocation,
      bwtar                  as ValuationType,
      cuobj                  as ConfigurationNumber,
      mmctr                  as VMSVehiclePrimActionControl,
      mmsta                  as VMSVehiclePrimaryStatus,
      mmtsp                  as VMSVehiclePrimStatusDateTime,
      sdctr                  as VMSVehicleSecdryActionControl,
      sdsta                  as VMSVehicleSecondaryStatus,
      sdtsp                  as VMSVehicleSecdryStatusDateTime,
      cdtsp                  as VMSVehicleConfdDelivDateTime,
      pdtsp                  as VMSVehicleProductionDateTime,
      pstsp                  as VMSVehiclePlndDelivDateTime,
      archive_flag           as VMSVehicleIsArchived,
      vhvin                  as VehicleIdentificationNumber,
      vhcex                  as VMSVehicleExternalID,
      avail                  as VMSVehicleAvailabilityStatus,
      vblty                  as VMSVehicleIsVisible,
      loctn                  as VMSVehicleLocation,
      kunnr                  as VMSVehicleCustomer,
      endcu                  as VMSVehicleEndCustomer,
      ernam                  as CreatedByUserName,
      vhusg                  as VMSVehicleUsageStatus,
      cmpgn                  as VMSVehicleSalesCampaign,
      pcount                 as VMSVehicleMileageQuantity,
      pcount_u               as VMSVehicleMileageUsageUnit,
      immatdate              as VMSVehicleRegistrationDate,
      digitalvehiclereferenceid as DigitalVehicleReferenceID,
      vhsar                  as VMSVehicleSearchArea,
      vhord                  as VMSVehicleOrderingParty,
      @Semantics.amount.currencyCode : 'VMSVehiclePriceCrcy'
      gprice                 as VMSVehGrossPrcAmtInVehPrcCrcy,
      @Semantics.currencyCode: true
      gpricecuky             as VMSVehiclePriceCrcy,
      shlvl                  as VMSVehicleSharingLevel,
      used_vehicle           as VMSVehicleIsUsed,
      _Customer,
      _OrderingParty,
      _Supplier,
      _Partner

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VLCVEHICLE",
"VLC_VEHDVHMODEL"
],
"ASSOCIATED":
[
"E_VMSVEHICLE",
"I_BUSINESSPARTNER",
"I_CUSTOMER",
"I_SUPPLIER",
"VLC_VEHDVHMODEL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/