I_VMSVehicleStdSalesOrder

DDL: I_VMSVEHICLESTDSALESORDER SQL: IVMSVEHSALORD Type: view BASIC Package: ISAUTO_VLC_DB

Sales order details

I_VMSVehicleStdSalesOrder is a Basic CDS View that provides data about "Sales order details" in SAP S/4HANA. It reads from 1 data source (I_SalesOrder) and exposes 23 fields with key fields SalesOrder, SalesOrderItem. Part of development package ISAUTO_VLC_DB.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesOrder I_SalesOrder from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IVMSVEHSALORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales order details view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrder SalesOrder
KEY SalesOrderItem I_SalesOrderItem SalesOrderItem
SoldToParty I_SalesOrder SoldToParty
CostCenter I_SalesOrder CostCenter
SalesOrganization I_SalesOrder SalesOrganization
DistributionChannel I_SalesOrder DistributionChannel
Division I_SalesOrder OrganizationDivision
SalesGroup I_SalesOrder SalesGroup
SalesOffice I_SalesOrder SalesOffice
NetAmount I_SalesOrderItem NetAmount
SalesDocumentCurrency I_SalesOrderItem TransactionCurrency
Plant I_SalesOrderItem Plant
SalesOrderDate I_SalesOrder SalesOrderDate
OverallSDProcessStatus I_SalesOrder OverallSDProcessStatus
_SoldToParty I_SalesOrder _SoldToParty
_SalesOrganization I_SalesOrder _SalesOrganization
_DistributionChannel I_SalesOrder _DistributionChannel
_OrganizationDivision I_SalesOrder _OrganizationDivision
_SalesGroup I_SalesOrder _SalesGroup
_SalesOffice I_SalesOrder _SalesOffice
SalesOrderType I_SalesOrder SalesOrderType
OrganizationDivision I_SalesOrder OrganizationDivision
_TransactionCurrency I_SalesOrderItem _TransactionCurrency 
@AbapCatalog.sqlViewName: 'IVMSVEHSALORD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality : #C
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass : #TRANSACTIONAL
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Sales order details'
define view I_VMSVehicleStdSalesOrder
  as select from I_SalesOrder
  association [1..*] to I_SalesOrderItem on I_SalesOrder.SalesOrder = I_SalesOrderItem.SalesOrder
{
  key I_SalesOrder.SalesOrder,
  key I_SalesOrderItem.SalesOrderItem,
      I_SalesOrder.SoldToParty,
      I_SalesOrder.CostCenter              as CostCenter,
      I_SalesOrder.SalesOrganization       as SalesOrganization,
      I_SalesOrder.DistributionChannel     as DistributionChannel,
      I_SalesOrder.OrganizationDivision    as Division,
      I_SalesOrder.SalesGroup              as SalesGroup,
      I_SalesOrder.SalesOffice,
      @Semantics.amount.currencyCode : 'SalesDocumentCurrency'
      I_SalesOrderItem.NetAmount,
      @Semantics.currencyCode: true
      I_SalesOrderItem.TransactionCurrency as SalesDocumentCurrency,
      I_SalesOrderItem.Plant,
      I_SalesOrder.SalesOrderDate,
      I_SalesOrder.OverallSDProcessStatus,
      I_SalesOrder._SoldToParty,
      I_SalesOrder._SalesOrganization,
      I_SalesOrder._DistributionChannel,
      I_SalesOrder._OrganizationDivision,
      I_SalesOrder._SalesGroup,
      I_SalesOrder._SalesOffice,
      I_SalesOrder.SalesOrderType,
      I_SalesOrder.OrganizationDivision,
      I_SalesOrderItem._TransactionCurrency
}

Learn More