A_VMSVehiclePurchaseOrder

DDL: A_VMSVEHICLEPURCHASEORDER SQL: AVMSPURORD Type: view COMPOSITE

Vehicle Purchase Order

A_VMSVehiclePurchaseOrder is a Composite CDS View that provides data about "Vehicle Purchase Order" in SAP S/4HANA. It reads from 2 data sources (I_SAPClient, I_VMSVehiclePurchaseOrder) and exposes 27 fields with key fields VMSVehicleUUID, VMSVehicleActionDateTime. It has 1 association to related views.

2 data source(s) 27 fields

Data Sources (2)

SourceAliasJoin Type
I_SAPClient _SAPClient inner
I_VMSVehiclePurchaseOrder I_VMSVehiclePurchaseOrder from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_VMSVehiclePurchaseOrder _Extension $projection.VMSVehicleUUID = _Extension.VMSVehicleUUID and $projection.VMSVehicleActionDateTime = _Extension.VMSVehicleActionDateTime

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AVMSPURORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Vehicle Purchase Order view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY VMSVehicleUUID VMSVehicleUUID
KEY VMSVehicleActionDateTime VMSVehicleActionDateTime
VMSVehicleActionDocType VMSVehicleActionDocType
PurchaseOrder PurchaseOrder
PurchaseOrderItem PurchaseOrderItem
ConfigurationNumber ConfigurationNumber
VMSVehicleGdsReceiptIsComplete VMSVehicleGdsReceiptIsComplete
VMSVehicleInvcRcptIsComplete VMSVehicleInvcRcptIsComplete
CreatedByUserName CreatedByUserName
CompanyCode CompanyCode
CompanyCodeName CompanyCodeName
Supplier Supplier
PurchasingOrganization PurchasingOrganization
PurchasingOrganizationName PurchasingOrganizationName
PurchasingGroup PurchasingGroup
PurchasingGroupName PurchasingGroupName
CostCenter CostCenter
Plant Plant
PlantName PlantName
PurchaseOrderDate PurchaseOrderDate
NetPriceAmount NetPriceAmount
DocumentCurrency DocumentCurrency
PurchasingProcessingStatus PurchasingProcessingStatus
PurchasingProcessingStatusName PurchasingProcessingStatusName
PurchaseOrderType PurchaseOrderType
_CostCenterText _CostCenterText
LogicalSystem I_SAPClient LogicalSystem 
@AbapCatalog.sqlViewName: 'AVMSPURORD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Vehicle Purchase Order'
@ObjectModel.usageType.serviceQuality : #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass : #TRANSACTIONAL
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations:true
define view A_VMSVehiclePurchaseOrder
  as select from I_VMSVehiclePurchaseOrder
    inner join   I_SAPClient as _SAPClient on _SAPClient.sapclient = $session.client
   association [1..1] to E_VMSVehiclePurchaseOrder as _Extension      on  $projection.VMSVehicleUUID           = _Extension.VMSVehicleUUID
                                                                     and $projection.VMSVehicleActionDateTime = _Extension.VMSVehicleActionDateTime
{
      @ObjectModel.text.element: ['CompanyCodeName','PurchasingOrganizationName' , 'PurchasingGroupName' , 'PurchasingProcessingStatusName']
  key VMSVehicleUUID,
  key VMSVehicleActionDateTime,
      VMSVehicleActionDocType,
      PurchaseOrder,
      PurchaseOrderItem,
      ConfigurationNumber,
      VMSVehicleGdsReceiptIsComplete,
      VMSVehicleInvcRcptIsComplete,
      CreatedByUserName,
      CompanyCode,
      @Semantics.text:true
      CompanyCodeName,
      Supplier,
      PurchasingOrganization,
      @Semantics.text:true
      PurchasingOrganizationName,
      PurchasingGroup,
      @Semantics.text:true
      PurchasingGroupName,
      @ObjectModel.text.association: '_CostCenterText'
      CostCenter,
      Plant,
      @Semantics.text:true
      PlantName,
      PurchaseOrderDate,
      @Semantics.amount.currencyCode : 'DocumentCurrency'
      NetPriceAmount,
      @Semantics.currencyCode: true
      DocumentCurrency,
      PurchasingProcessingStatus,
      @Semantics.text:true
      PurchasingProcessingStatusName,
      @Consumption.hidden: true
      PurchaseOrderType,
      @Consumption.hidden: true
      _CostCenterText,
      _SAPClient.LogicalSystem

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SAPCLIENT",
"I_VMSVEHICLEPURCHASEORDER"
],
"ASSOCIATED":
[
"E_VMSVEHICLEPURCHASEORDER",
"I_COSTCENTERTEXT"
],
"BASE":
[
"I_VMSVEHICLEPURCHASEORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More