ARun_ValAddedSrvcSDReqdDte

DDL: ARUN_VALADDEDSRVCSDREQDDTE Type: view

ARun_ValAddedSrvcSDReqdDte is a CDS View in SAP S/4HANA. It reads from 1 data source (vbep) and exposes 5 fields.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
vbep _SalesDocumentScheduleLine from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName ARUNVASSDDATE1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (5)

KeyFieldSource TableSource FieldDescription
SalesDocument vbep vbeln
SalesDocumentItem vbep posnr
ConfdSchedLineReqdDelivDate vbep req_dlvdate
ProductAvailabilityDate
BaseUnit vbep meins 
@ClientHandling.algorithm: #AUTOMATED
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #NOT_REQUIRED
}
@AbapCatalog: {
  sqlViewName: 'ARUNVASSDDATE1',
  compiler.compareFilter: true,
  preserveKey:true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XXL
   }
}
define view ARun_ValAddedSrvcSDReqdDte
  as select from vbep as _SalesDocumentScheduleLine
{
  _SalesDocumentScheduleLine.vbeln       as SalesDocument,
  _SalesDocumentScheduleLine.posnr       as SalesDocumentItem,
  _SalesDocumentScheduleLine.req_dlvdate as ConfdSchedLineReqdDelivDate,
  min(_SalesDocumentScheduleLine.mbdat)  as ProductAvailabilityDate,
  _SalesDocumentScheduleLine.meins       as BaseUnit
}
where
  _SalesDocumentScheduleLine.wmeng > 0
group by
  _SalesDocumentScheduleLine.vbeln,
  _SalesDocumentScheduleLine.posnr,
  _SalesDocumentScheduleLine.req_dlvdate,
  _SalesDocumentScheduleLine.meins

Learn More